[bug] autocomplete alias only works for first statement

[expired user #8388]'s profile image [expired user #8388] posted 9 years ago in General Permalink
When i open one tab and have for instance:

select * from user u where u.id = 3;

the autcomplete works as expected after i type "u.", loading field names. the problem occurs when i use create another query after the first and try to use other aliases. for instance:

select * from user u where u.id = 3;
select * from page p where p. (...)

on the second query, the alias for p is not loaded. it only works if i use that query on another tab or put it at the top.
[expired user #1821]'s profile image [expired user #1821] posted 9 years ago Permalink
This is probably because your delimiter is set to anything other then a semicolon (;)

Use the red semicolon symbol to set the delimiter to a ;

Or, alternatively, finish the first query with whatever you have set as the delimiter.
[expired user #8388]'s profile image [expired user #8388] posted 9 years ago Permalink
well, that indeed was the problem. my delimiter was set to ;; but i was using only ;. changing to ; or finishing the statements with ;; solved the problem.
Thank you.

Please login to leave a reply, or register at first.