db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bob Gibson (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-84) Column aliasing could simplify queries
Date Sun, 28 Nov 2004 15:33:18 GMT
Column aliasing could simplify queries
--------------------------------------

         Key: DERBY-84
         URL: http://nagoya.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://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


Mime
View raw message