Eclipse Community Forums: EclipseLink » Having clause

Home » Eclipse Projects » EclipseLink » Having clause - more unexpected pickiness

Having clause - more unexpected pickiness [message #387037]

Wed, 08 April 2009 15:25

Eclipse User

If I try to run this query:

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?

Re: Having clause - more unexpected pickiness [message #387067 is a reply to message #387037]

Thu, 09 April 2009 09:30

Eclipse User

Sounds odd, please log the bug.

---
James
http://www.nabble.com/EclipseLink---Users-f26658.html

Re: Having clause - more unexpected pickiness [message #387079 is a reply to message #387067]

Fri, 10 April 2009 09:02

Eclipse User

Done: https://bugs.eclipse.org/bugs/show_bug.cgi?id=271889

Previous Topic:	Is JPA QL supposed to be this picky?
Next Topic:	multiple xml-mappings from fragments?

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 13 00:02:27 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter