Is order by broken in 3.2.1ga?
I have this HQL query:
Code:
select book from Book as book order by book.pdate
That generates the following SQL query:
Code:
select
book0_.id as id4_,
book0_.version as version4_,
book0_.read_count as read3_4_,
book0_.pdate as p4_4_,
book0_.title as title4_,
book0_.publish_date as publish6_4_,
book0_.description as descript7_4_,
book0_.link as link4_,
book0_.blog_id as blog9_4_
from
book book0_
order by
book0_.pdate
As you can see, the pdate is aliased as p4_4 in the select clause, but as pdate in the order by clause. Any ideas what is possibly wrong?
Thanks in advance,
Behi