* subselects (can't notice one anywhere) * floating point and decimal literals (it doesn't need to parse them, just recognize them)
We also want to plan for the following new syntax:
select foo, count(bar) from Foo foo outer join foo.bars bar group
This is the "implicit group by" we discussed in Aarhus, where Hibernate guesses what columns it needs to group by.
Finally, why is the "having" node a submode of the "group" node?
input: ->select cat.color, sum(cat.weight), count(cat)
from eg.Cat cat group by cat.color
having cat.color in (eg.Color.TABBY, eg.Color.BLACK)<-
AST : ( query ( select ( . cat color ) ( sum ( . cat
weight ) ) ( count cat ) ) ( from ( . eg Cat ) ( alias cat ) ) ( group ( . cat color ) ( having ( in ( . cat color ) ( . ( . eg Color ) TABBY ) ( . ( . eg Color ) BLACK ) ) ) ) )
\-'query' [5] +-'select' [13] | +-'.' [9] | | +-'cat' [71] | | \-'color' [71] | +-'sum' [37] | | \-'.' [9] | | +-'cat' [71] | | \-'weight' [71] | \-'count' [41] | \-'cat' [71] +-'from' [18] | +-'.' [9] | | +-'eg' [71] | | \-'Cat' [71] | \-'alias' [4] | \-'cat' [71] \-'group' [28] +-'.' [9] | +-'cat' [71] | \-'color' [71] \-'having' [35] \-'in' [57] +-'.' [9] | +-'cat' [71] | \-'color' [71] +-'.' [9] | +-'.' [9] | | +-'eg' [71] | | \-'Color' [71] | \-'TABBY' [71] \-'.' [9] +-'.' [9] | +-'eg' [71] | \-'Color' [71] \-'BLACK' [71]
------------------------------------------------------- This SF. Net email is sponsored by: GoToMyPC GoToMyPC is the fast, easy and secure way to access your computer from any Web browser or wireless device. Click here to Try it Free! https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel