Hello, I've just upgraded from 1.3.170 to 1.3.171 and my unit tests (using in memory database) fail when OFFSET in query is greater than number of rows in the queried table:
The query below is executed on db_operators table with 8 rows: [error] Method returned: java.lang.RuntimeException: Exception while executing statement : Blad ogolny: "java.lang.IllegalArgumentException: fromIndex(9) > toIndex(8)" [error] General error: "java.lang.IllegalArgumentException: fromIndex(9) > toIndex(8)"; SQL statement: [error] Select [error] db_operator11.opr_email as db_operator11_opr_email, [error] db_operator11.opr_enabled as db_operator11_opr_enabled, [error] db_operator11.opr_country as db_operator11_opr_country, [error] db_operator11.opr_last_name as db_operator11_opr_last_name, [error] db_operator11.opr_first_name as db_operator11_opr_first_name, [error] db_operator11.opr_id as db_operator11_opr_id, [error] db_operator11.opr_language as db_operator11_opr_language, [error] db_operator11.opr_secret_key as db_operator11_opr_secret_key, [error] db_operator11.opr_time as db_operator11_opr_time, [error] db_operator11.opr_password as db_operator11_opr_password [error] From [error] db_operator db_operator11 [error] Order By [error] db_operator11.opr_id Asc, [error] db_operator11.opr_id Asc [error] limit 3 offset 9 [50000-171] [error] errorCode: 50000, sqlState: HY000 The query works OK (returning 0 rows) in 1.3.170 Please confirm that this is a bug. Thanks, Olaf -- 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 http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
