1.
HQL "select foo from Foo foo order by count(foo.id) desc" will be translated to
"select ... order by count(foo.id)desc", the space character of "count(foo.id)desc"
has been eaten and will produce some error in my application.
I think this is a bug in org.hibernate.sql.QuerySelect.appendTokens(...).


2.

In MySql dialect, I use hql like "select foo from Foo foo where foo.value & 1=1".
Hibernate3 AST parser will print some error like "unexpected token &", and it can't
be solved when I write "&" in query string substitution like "hibernate.query.substitutions=bitand &".