Hi All, The following query doesn't work in H2 which is being used for Integration testing. The database in use is the one that comes with spring boot.
SELECT id FROM tableName ORDER BY id asc OFFSET CAST( 20000000000 AS BIGINT) ROWS FETCH NEXT 10000 ROWS ONLY; The error I get is "Numeric value out of range: "20000000000" in column ; SQL statement:" But When I run SELECT CAST( 20000000000 AS BIGINT); It works fine. So that means the CAST is fine , Is there some limitations on the use of Offset with H2 ? Or I am missing something here completely. Any advice/direction to look for would be appreciated. Thanks again! -- 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.
