use of direct column name rather than alias make aggregation fail (Hibernate depends on that) ---------------------------------------------------------------------------------------------
Key: DERBY-1624 URL: http://issues.apache.org/jira/browse/DERBY-1624 Project: Derby Issue Type: Improvement Components: SQL Affects Versions: 10.1.3.1, 10.1.1.0 Reporter: Emmanuel Bernard Error: org.apache.derby.client.am.SqlException: Column 'MODEL0_.COL_0_0_' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'MODEL0_.COL_0_0_' is not a column in the target table., SQL State: 42X04, Error Code: -1 for select model0_.balance as col_0_0_, count(*) as col_1_0_ from account model0_ group by model0_.balance having count(*) > 1 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira