Hi, You are right, this is not well documented yet, I will fix that. The reason for the change is added support for "select ... fetch first 1 row only" in the regular mode. In version 1.3.x, this was only supported in the DB2, Derby, and PostgreSQL mode. Actually this also applies to "fetch". At least in PostgreSQL, "fetch" and "offset" are also reserved keywords.
Regards, Thomas On Wednesday, September 3, 2014, Paul Robinson <[email protected]> wrote: > It looks like "offset" is a reserved word in version 1.4.181, where it > wasn't in 1.3.176. In particular, you can't create a table with a column > called offset unless you quote it. > > Offset is not currently listed as a reserved word here: > > http://www.h2database.com/html/advanced.html?highlight=reserved&search=reserved#firstFound > > To replicate this, start the console and run this: > CREATE TABLE THING (OFFSET DOUBLE); > > and it gives a syntax error, while this does not: > CREATE TABLE THING (`OFFSET` DOUBLE); > > Is this a bug in the code, the documentation, or am I doing something > wrong? > > Paul > > -- > 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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. For more options, visit https://groups.google.com/d/optout.
