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

1
8 comments

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
Avatar
Permanently deleted user

Great, nice to hear that ..

0
Avatar
Permanently deleted user

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
Avatar
Permanently deleted user

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

0

Hello,

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

0

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
Avatar
Permanently deleted user

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

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.