HI, Many Thanks for the reply! That explains why its failing I guess. Just to give you some context, I am using H2 for spring integration tests , the production database is Ms SQL, which works fine with this large number. Frankly I am still trying to figure out if really want users to access such a large number of pages, this was just part of testing.
Just on a side note you said usage of Offset is bad Idea, how to you see pagination working if not for offset ? On Monday, 10 September 2018 10:12:27 UTC+1, Evgenij Ryazanov wrote: > > Hello. > > 64-bit offsets are only supported by a current development version of H2 > that you can build for yourself from the sources > https://github.com/h2database/h2database > http://h2database.com/html/build.html#building > > You cannot use large offsets in released versions of H2. > > Usage of OFFSET, however, usually a bad idea, especially with so large > values. OFFSET means that database must read all these rows. Do you really > want to read 20,000,001,000 rows and use only 1,000 of them? WHERE > condition with index will work much faster. > -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
