[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4121) DB2 Projection with paging and ordering generates illegal SQL. sqlerror -206

DB2 Projection with paging and ordering generates illegal SQL. sqlerror -206 ---------------------------------------------------------------------------- Key: HHH-4121 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4121 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.2.6 Reporter: Nick Wiedenbrück We're using DB2 8.1 and we have a projection query with paging and sorting. The generated SQL looks like this: select * from ( select rownumber() over(order by y5_ asc) as rownumber_, [...] , this_.beginn as y5_, [...] from [...] order by y5_ asc ) as temp_ where rownumber_ <= ? This results in an error, because the query uses the alias in the over() part. If instead this_.beginn would be used it would possibly work. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira