Thanks Evgeni, as always, for your prompt response! So you don't think this is a bug? Pagination using offset and limit is not uncommon. Also, I should have mentioned this earlier but I don't see this behavior in PostgreSQL. Not sure how other RDBMS behave but it would be interesting to compare.
Peter -- 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/1762141233.7723443.1713022482287%40mail.yahoo.com.
