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
