Query by example Bug

[Grego]

Hi, i'm trying to use the 'query by example' feature, but when i use an alias on a column, it uses the alias instead of the column name.

Example:
the following query

"select dummy column1
from dual"

after querying by example, returns

"select dummy alias
from dual
where alias = 'x'"

and therefore an error message "invalid column name" returns.

Ps: pl/sql developer 6.0.5.931

 

[Marco Kalter]

This is a known restriction. You cannot query on aliased columns.

 

[Grego]

 

[Marco Kalter]

PL/SQL Developer would have to analyze the SQL to find the alias and resolve it to the actual column name. This is on the to-do list.