HQL clause:

"select message.forumID, count(*) as mmm from "+ ForumMessage.class.getName()+
" message group by message.forumID order by mmm DESC"

Translated sql clause:

Hibernate: select forummessa0_.forumID as col_0_0_, count(*) as col_1_0_ from ForumMessage forummessa0_ group by forummessa0_.forumID order by mmm DESC limit ?

Eorror reported:

JDBCExceptionReporter [ERROR] Unknown column 'mmm' in 'order clause'

Tested under :mysql 4.1 ,msslql 2000,hibernate3.1rc2,hibernate3.0.5

You want an sql-query, not a query. Query is used for mapping to a class, not a pair of integers. I believe that you can use a plain old query for this, but I never bothered to look up how, as sql-query does it very well.

i try with oracle and i think that this is bug in hql

HQL does not have an "as" keyword in the select clause. This is not valid HQL. Use SQL if you want SQL. Stop posting "bug in Foo" if you don't understand something.

hql would be return error and not wrong sql if it doesn't support - this confuse users

for example :

select model.id,count(*) as mmm
from MyClass as model
group by model.id
order by model.mmm

return error (don't generate and try execute sql)

select model.id,count(*) as mmm
from MyClass as model
group by model.id
order by mmm

generate and execute wrong sql

select model.id,count(*)
from MyClass as model
group by model.id
order by mmm

generate and execute wrong sql

workaround for this query (this work)

select model.id,count(*) as mmm
from MyClass as model
group by model.id
order by 2

(i suppose that id isn;t component type or composite id)

When can you have the patch ready?

Repeat: This isn't a bug. HQL passes on everything it doesn't know in the ORDER BY. It could be a native SQL function. If you want alias support, submit a patch to the grammar.

this isn't correct
hql find error in order by for this case

select model.id,count(*)
from MyClass as model
group by model.id
order by model.mmm

and throw exception QueryException
org.hibernate.QueryException: could not resolve property: mmm of: myClass [select model.id,count(*) from MyClass model group by model.id order by model.mmm]

ok.it isn't bug, than missing features
'order by' can have - same like select list + positional parameters and hql can recognize it easy

i agree that it isn't important (workaround exists) , but it would be nice