db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew McIntyre (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2457) Use of column aliases in group by / having clauses can cause queries to fail
Date Thu, 15 Mar 2007 23:00:09 GMT
Use of column aliases in group by / having clauses can cause queries to fail
----------------------------------------------------------------------------

                 Key: DERBY-2457
                 URL: https://issues.apache.org/jira/browse/DERBY-2457
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 10.3.0.0
            Reporter: Andrew McIntyre
            Priority: Minor
         Attachments: 1624_repro.sql

Some use of column aliases in group by / having clauses can cause queries to fail with error
42X04. The queries can sometimes be made to work by also aliasing the table or rewriting the
query to use a subselect. Attached is a simple sql script which reproduces the issue, originally
found as part of DERBY-1624.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message