Eclipse Community Forums: EclipseLink » Having clause

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

Having clause - more unexpected pickiness [message #387037]

Wed, 08 April 2009 19:25

Josh Davis

Messages: 10
Registered: July 2009

Junior Member

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?

Report message to a moderator