[ http://issues.apache.org/jira/browse/DERBY-84?page=comments#action_66828 ] Shreyas Kaushik commented on DERBY-84: --------------------------------------
Without the where clause this works, looks like a binding issue ij> connect 'jdbc:derby:test'; ij> drop table test; 0 rows inserted/updated/deleted ij> create table test(i int, longcolname varchar(10)); 0 rows inserted/updated/deleted ij> insert into test values(1,'abcd'); 1 row inserted/updated/deleted ij> select longcolname as lc from test where lc like '%ab%'; ERROR 42X04: Column 'LC' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'LC' is not a column in the target table. ij> select longcolname as lc from test; LC ---------- abcd 1 row selected > Column aliasing could simplify queries > -------------------------------------- > > Key: DERBY-84 > URL: http://issues.apache.org/jira/browse/DERBY-84 > Project: Derby > Type: New Feature > Components: SQL > Versions: 10.0.2.0 > Reporter: Bob Gibson > Priority: Minor > > Currently, one can not use an alias to simplify queries. For example, being > able to alias "LongDescriptiveColumnName" AS LDCN would allow one to use the > alias elsewhere in the query, e.g., the WHERE clause: > SELECT LongDescriptiveColumnName AS LDCN FROM MyTable WHERE LDCN LIKE > '%testing%'; > The current result is a message like: > ERROR 42X04: Column 'LDCN' is not in any table in the FROM list or it appears > within a join specification and is outside the scope of the join > specification or it appears in a HAVING clause and is not in the GROUP BY > list. If this is a CREATE or ALTER TABLE statement then 'LDCN' is not a > column in the target table. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
