Hibernate Query Pagination Consistency Across Dialects

Hibernate Pagination Behavior

The Hibernate query pagination feature utilizes `setMaxResults` and `setFirstResult`.

Dialect Dependency

The actual SQL implementation, such as using `OFFSET` versus `LIMIT`, is determined by the underlying database dialect configuration.

When transitioning between database dialects, how is the consistency of offset-based pagination maintained?

• Does Hibernate guarantee identical result sets for the same parameters across PostgreSQL and MySQL?
• What is the documented behavior regarding offset performance degradation in different dialects?