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.
