Completion Insight changes in 22.2?

user618567

In previous version I was able to type in 'SELECT p. ' (where p is my table alias) and see the columns in my table. I'm now seeing what appears to be a list of schemas/users. Am I doing something wrong or did something change?

Update: If the table is in my current schema, it works as it always has. If I'm using a synonym to a table in another schema, it appears that the completion insight might not be working as I expected. Can somebody else try this and confirm?

Lothar Armbrüster

Yes, I observed the same thing. I didn't notice that it still works with own tables, since most of our tables are accessed via synonyms. Even qualifying the table name with user name does not help.

thatJeffSmith-Oracle

Can you provide an example? My 22.2 rig

Lothar Armbrüster

Well, actually I cannot reproduce that right now. But when I have another big SQL of, say 117 lines in the worksheet above my actual SQL, I get columns proposed that do not belong to the table for which I try to enter my new SQL.

I did not find out yet, which the exact conditions are but have a look at this:

Here, the "*" is offered only when the above SQL exists. The is something strange going on with the parsing.

And then that here:

Here columns of the inner SQL above are offered: gp_nr and gp_nr_betrieb are not part of wt_funktion.

I'm having no demo schemas installed, so I hope you can reproduce something like this.

Kind regards,

Lothar

thatJeffSmith-Oracle

It's quite possible something is up with the parser. But I'll need a test case.

Lothar Armbrüster

Okay, here you are:

I disabled the autopopup and called that via CTRL-Space.

thatJeffSmith-Oracle

In your example 't' isn't an alias for your table.

This works

Contents of my editos

select *
from (select * from user_tab_colums) c;

select t. from user_tables t;

Lothar Armbrüster

Yes, you are right, but adding the alias does not help in my case:

The list is influenced by the SQL above. If I remove that, SQL Developer shows a different one without column_name:

Also the list in this case it ordered differently each time, I call it:

IIRC the column list used to be ordered alphabetically.

Regards,

Lothar

thatJeffSmith-Oracle

there's for sure a bug here if not two. For the moment i can only verify the sorting/alpha issue. I'll log that now.

user618567

I have been trying to create a consistent test case, but the issue is not consistent. It definitely only happens (at least for me) when I am using synonyms to tables in another schema. If I fully qualify the schema.tablename in my SQL it works fine.

Patrick Speicher

I would say that the Completion Insight function does not work at all without table schema in 22.2.