[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2383?page=c... ] Scott Stewart commented on HHH-2383: ------------------------------------ I think I have the same problem as this and it has to do with generated SQL for the paging using the rownum keyword when ordering by a column that has many of the same values. The issue is described rather well here: http://www.oracle.com/technology/oramag/oracle/06-sep/o56asktom.html. Look near the bottom for the 'Pagination with ROWNUM' section. To quote: '...the query cannot do it deterministically—the same sort order is not assured from run to run of the query...' when the values of the column are the same for several 'pages'. Suggestions for 2 possiblities: 1. Simply document it in the books and JavaDocs for setMaxResults() and setFirstResult() or 2. Modify the generated SQL to always include an additional ordering of 'rowid' per the example in the above link. -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2383?page=c... ] Arne Ansper commented on HHH-2383: ---------------------------------- The problem seems to arise from the special treatment of the case when firstResult is 0. getLimitString constructs different SQL statement when hasOffset is false. When offset is 0 SQL starts like this: SELECT * FROM (SELECT saddocumen0_.id AS col_0_0_, When offset > 0 SQL starts like this: SELECT * FROM (SELECT row_.*, rownum rownum_ FROM (SELECT saddocumen0_.id AS col_0_0_, Apparently Oracle does some optimizations that results in different order of rows for those two queries. When I ran the second SQL for rows 0 - pagesize, I got consistent results. I suggest to remove the special treatment of the case when offset is 0 to get consistent results. -- 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