Hi, I see Noel already replied, sorry for sending (at least partially) the same info. The reason is that I sometimes prepare & send mails offline, which are then sent later on... so I didn't see Noels email.
Regards, Thomas On Wednesday, September 3, 2014, Thomas Mueller < [email protected]> wrote: > 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] > <javascript:_e(%7B%7D,'cvml','[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]. >> 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. >> > -- 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.
