The iSQL v16.0.0 build 2076 is not working as iSQL v11.0.1 build 2742 used to do.
The auto-complete feature does not bring the table's owner before the table name when a table is chosen from the drop down menu.
The drop down menu is showing the table's owner as expected.
Step 1= select * from pro
Step 2= ctrl+space
Step 3= table admin.program is selected
iSQLv11 "SQL Statements" window is filled with "select * from admin.program"
iSQLv16 "SQL Statements" window is filled with "select * from program"
Is there a bug?
In version 11, the owner name for tables was added if the table's owner was different from the name of the current user, even if the owner was not necessary. For example, in the "demo" database, if you were logged in as "dba", the text completer always completes "cust" as "GROUPO.Customers", even though "Customers" is, in this case, sufficient. This results in the completed SQL being pedantically correct, but a bit noisy.
In version 12 and 16, the algorithm regarding adding owner names is different. The owner name is added automatically only if there is more than one table in the database with the given name. So, unless there is both a GROUPO.Customers and a MyUser.Customers, "cust" will be completed as "Customers" (without an explicit owner).
answered 04 Jun '15, 11:17
Late to the game but this appears to have been a deliberate change introduced in 12.0.1 and up and basically does not complete the text with owner if there is no possibility of ambiguity without one.
One description I found about this was this one
and is something that did not seem to make it into the official docs.
To me this looks like a bug. In my test it didn't make any difference, whether "Show owner names" was checked in the Editor Options or not.
answered 03 Jun '15, 03:41