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

[Nick Wiedenbrück (JIRA)]

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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira