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 [email protected]. > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/2ce8778f14356adb3f901fbd83935d8e748d0e17.camel%40manticore-projects.com.
