db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shreyas Kaushik (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-84) Column aliasing could simplify queries
Date Thu, 02 Jun 2005 05:42:53 GMT
     [ 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


Mime
View raw message