Hi, Yes, this is a regression introduced by sorting optimization. Will be fixed in next release, thanks for reporting!
Sergi On Wednesday, March 27, 2013 11:37:28 AM UTC+4, Olaf Tomczak wrote: > > 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.
