"Bug" in context menu

[F. van Boven]

Hi,

I've noticed a flaw in the context menu (right-click in a SQL Window).

If 2 tablenames are mentioned behind each other, and I put the cursor on the 2nd table, then open the context menu, and select the option "Edit". The first table mentioned is opened..

Here's a sample:

-- Create 2 useless test tables
create table ATEST(a1 int, a2 varchar(2));
create table BTEST(b1 int, b2 varchar(2));

-- The actual code:
select * from ATEST

BTEST          <-- Put mouse cursor somewhere here, and choose "Edit" from the context menu

-- Remove the test tables

drop table ATEST
drop table BTEST

 

[Marco Kalter]

The select statement is parsed, and BTEST is an alias for ATEST in this example. So, however illogical it may seem, this is in fact correct.