Details
-
Improvement
-
Status: Closed
-
Minor
-
Resolution: Won't Fix
-
10.3.1.4
-
None
-
None
Description
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.
Attachments
Attachments
Issue Links
- is blocked by
-
DERBY-3094 Grouping of expressions causes NullPointerException
- Closed
- is related to
-
DERBY-1624 use of direct column name rather than alias make aggregation fail (Hibernate depends on that)
- Closed
-
DERBY-84 Column aliasing could simplify queries
- Closed