When using Hibernate to query while paging and sorting the data, some pages have the same data. The issue appears to be in the hibernate-core class org.hibernate.dialect.Oracle9iDialect where it defines a AbstractLimitHandler. The default limit handler has a processSql() method that handles paging a query.

The create.sql attachment will create the tables and populate them with data. The description.md attachment provides detailed instructions on how to reproduce. And finally, the drop.sql attachment will drop the created tables.