Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsHaving clause - more unexpected pickiness
https://www.eclipse.org/forums/index.php/mv/msg/126102/387037/#msg_387037
select city.stateId, count(city.cityId) from VCity city group by
city.stateId having count(city.cityId) >= :value_0
It fails with this error:
invalid HAVING expression [COUNT(city.cityId) >= value_0] for query with
grouping [GROUP BY city.stateId]. The HAVING clause must specify search
conditions over the grouping items or aggregate functions that apply to
grouping items
However, if I change it to this:
select city.stateId, count(city.cityId) from VCity city group by
city.stateId having count(city.stateId) >= :value_0
It works.
Is that expected behavior?]]>Josh Davis2009-04-08T19:25:22-00:00Re: Having clause - more unexpected pickiness
https://www.eclipse.org/forums/index.php/mv/msg/126102/387067/#msg_387067
---
James http://www.nabble.com/EclipseLink---Users-f26658.html]]>James Sutherland2009-04-09T13:30:58-00:00Re: Having clause - more unexpected pickiness
https://www.eclipse.org/forums/index.php/mv/msg/126102/387079/#msg_387079
https://bugs.eclipse.org/bugs/show_bug.cgi?id=271889]]>Josh Davis2009-04-10T13:02:37-00:00