 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
 [11.5.362 Pro] - BUG: Auto Complete Qualify Object Names |
 |
In MariaDB, when selecting a table from the popup for an INNER JOIN disregards the setting DB Options / SQL Assistance / Auto Complete / Always Fully Qualify Object Names being set to Only for objects in other schema or database. The selected table is qualified with the schema name even though it is in the current schema (which also happens to be same schema the first table is in but I guess the other condition is stronger).
Check this short video here.
|
|
| Thu Feb 25, 2021 2:20 pm |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Thank you. It is a "feature" of JOINs popup, which is always displaying schema names in its suggestions, which is in turn a result of what is returned by "Joins (MariaDB)" query. The schema element is always present. What you select in the popup is inserted into the editor as is. I think DB Options / SQL Assistance / Auto Complete / Always Fully Qualify Object Names is not used in this case.
|
|
| Tue Mar 02, 2021 4:43 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
I submitted a new bug report to investigate why DB Options / SQL Assistance / Auto Complete / Always Fully Qualify Object Names is not considered in the JOIN suggestions.
|
|
| Tue Mar 02, 2021 4:46 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
Thank you very much!
|
|
| Tue Mar 02, 2021 1:35 pm |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
