Resolving Oracle synonyms

I am just wondering if you maybe know what is the status of this issue? We heavily depend on public synonyms and developing without autocomplete is quite a pain..

Thank you

8 comments
Comment actions Permalink

Hello,

The work for the fix is in progress and it is partly finished. I guess, the new build with the fix can be expected already in the mid of this month (~1weeks).

0
Comment actions Permalink

Great, nice to hear that ..

0
Comment actions Permalink

I have noticed another issue with autocomplete. Problem arises when using autocomplete with live templates. When the template is triggered no suggestion is made for the source table (see pics). After the table is inserted and you move to the select section, sugesstion works as expected.

Thanks for the great tool you provided us..



Attachment(s):
000777.png
000776.png
0
Comment actions Permalink

Issue was produced on  PostgreSQL 9.4.2 (heroku) but it think the same behaviour occurs on Oracle.

0
Comment actions Permalink

Hello,

we're working on this issue and I exepect we fix it before the next EAP build.

0
Comment actions Permalink

Can not reproduce issue with completion and Live Templates. Works fine for me:
2015-06-11_13-29-21.png
Doesn't it work only when using Live Templates? Check that you have current schema defined in SQL Console Editor (in my screenshot it is set to public in the upoper right corner). Then IDE will suggest you table names choosing from available in this schema tables.

0
Comment actions Permalink

Leonid I can see that the issue was fixed but in the last version (143.109.1) I still have some problems with autocomplete when I am connected in a different schema than a table that I want to access is located.

Here is the case:
- connect to schema A
- create table X
- grant select on X to B
- create public synonym X for A.X
- connect to schema B
- autocomplete on synonym X will not work despite having all the privilegies

0
Comment actions Permalink

Hello Mertez,

looks like it's a completely different problem. If it's still actual, could you please file a new issue? In that issue please add a screenshot of the list of synonyms in schema B.
Thanks

0

Please sign in to leave a comment.