count in group by or order by (new parser in h3 beta1)

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

Hibernate 3 beta1 (new parser) don't recognize count in group by or order by clause

count work in select clause

This hql don't work with new parser (it work with old parser)

select bid.item.id,min(bid.created),count(*)
from Bid bid
group by bid.item.id
having min(bid.item.id) > 1
order by bid.item.id,count(*)

or

select bid.item.id,min(bid.created),count(*)
from Bid bid
group by bid.item.id
having count(bid.item.id) > 1
order by bid.item.id

error is in compile query :

ERROR parser: *** ERROR: <AST>:0:0: unexpected AST node: count

regards
Peco

emmanuel · **Posted:** Mon Dec 27, 2004 12:05 pm

CAn you post those bugs into JIRA, please.

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

I do and error is in having and order by, not group by - query is correct

regards

joshua · **Posted:** Mon Dec 27, 2004 12:58 pm

snpesnpe wrote:

select bid.item.id,min(bid.created),count(*)
from Bid bid
group by bid.item.id
having min(bid.item.id) > 1
order by bid.item.id,count(*)

Thanks for finding that. Post it to JIRA and I'll fix it.

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

I make HHH-75 - I try it with last hibernate cvs too and it don't work

regards

joshua · **Posted:** Mon Dec 27, 2004 2:11 pm

Good. Saw the new defect... like I said, I'm still working on many-to-many.

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

Joshua,
I try make patch for this.Patch is on http://opensource.atlassian.com/project ... wse/HHH-75

regards
peco