In my understanding, you could create a temporary table from your query (without pagination) and then use the special column `_row_id_` for the pagination.
On Tue, 2024-04-16 at 16:42 +0700, Andreas Reichel wrote: > 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 > [1]. [1] https://groups.google.com/d/msgid/h2-database/1fda6aa6c870c759abf48010bec19b56a643a2b6.camel%40manticore-projects.com https://groups.google.com/d/msgid/h2-database/1fda6aa6c870c759abf48010bec19b56a643a2b6.camel%40manticore-projects.com?utm_medium=email&utm_source=footer -- 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/2ce8778f14356adb3f901fbd83935d8e748d0e17.camel%40manticore-projects.com.
