[ https://issues.apache.org/jira/browse/DERBY-2457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12595109#action_12595109 ]
Andrew McIntyre commented on DERBY-2457: ---------------------------------------- See also the discussion in DERBY-84 and DERBY-127. This bug could be potentially be considered a dup of DERBY-84. > 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.1.4 > Reporter: Andrew McIntyre > Assignee: Bryan Pendleton > 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.