[ http://issues.apache.org/jira/browse/DERBY-1624?page=comments#action_12424957 ] Emmanuel Bernard commented on DERBY-1624: -----------------------------------------
Somehow related to DERBY-127 > 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.1.0, 10.1.3.1 > 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