Hi, it seems to me that sql queries that end with OFFSET - LIMIT combination is not handled properly. For instance sql query `SELECT * FROM PET OFFSET 2 LIMIT 2` ends with failure, but the sql query `SELECT * FROM PET LIMIT 2 OFFSET 2` works with no problems.
I discovered this using h2console.war ( http://www.jboss.org/jdf/quickstarts/jboss-as-quickstart/h2-console/) on JBoss AS 7.1.1.Final. The H2 version used: 1.3.168 Not sure whether I should submit a bug for this. Thanks for any comments. -- 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.
