Hi, It's not a bug, it's just the way the grammar is defined.
Regards, Thomas On Thu, Feb 28, 2013 at 5:40 PM, Tomáš Repel <[email protected]> wrote: > 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. > > > -- 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.
