On Tue, 2024-04-16 at 09:14 +0000, 'Peter Borissow' via H2 Database wrote: > I don't care if 218 appears before 217 or if 217 appears before 218 > as long as they both appear.
Peter, please consider that 1) the second query call knows nothing about the first query call ( and this fact alone makes pagination unreliable unless you can guarantee that there is a distinct order and no change to the data in between the calls). 2) both query calls grab ANY records out of the duplicates The observed behaviour is perfectly expected and explainable, unless you order by a distinct criteria -- which was "ID" in your example only. Cheers Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/1fda6aa6c870c759abf48010bec19b56a643a2b6.camel%40manticore-projects.com.
