[h2] LIMIT[*] inserted into query?

['Peter Borissow' via H2 Database]

Hello,
    I just upgraded my h2 jdbc driver from h2-1.4.197.jar to h2-1.4.199.jar 
and ran into an odd exception. My query is simple:

select date,description,amount from transaction offset 0 limit 50

Here's the error:

org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement 
"SELECT DATE,DESCRIPTION,AMOUNT FROM TRANSACTION OFFSET 0 LIMIT[*] 50 "; 
SQL statement:
select date,description,amount from transaction offset 0 limit 50 
[42000-199]
        at 
org.h2.message.DbException.getJdbcSQLException(DbException.java:451)
        at 
org.h2.message.DbException.getJdbcSQLException(DbException.java:427)
        at org.h2.message.DbException.get(DbException.java:205)
        at org.h2.message.DbException.get(DbException.java:181)
        at org.h2.message.DbException.getSyntaxError(DbException.java:229)
        at org.h2.command.Parser.getSyntaxError(Parser.java:989)
        at org.h2.command.Parser.prepareCommand(Parser.java:686)



I'm not sure what's wrong or whether this is a known issue. Downgrading to 
h2-1.4.197.jar for now.

Thanks,
Peter

-- 
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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/2bbcdf0b-8e3d-4bd8-932d-40169d78f54d%40googlegroups.com.