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