Hi, the SQL statement below works in version 1.3.175 but fails in 1.4.195.
CREATE TABLE CHECK(ID INTEGER NOT NULL, NAME VARCHAR(32) NOT NULL); The error in 1.4.195 is: Syntax error in SQL statement "CREATE TABLE CHECK[*]( ID INTEGER NOT NULL, NAME VARCHAR(32) NOT NULL)"; expected "identifier"; SQL statement: CREATE TABLE CHECK( ID INTEGER NOT NULL, NAME VARCHAR(32) NOT NULL) [42001-196] 42001/42001 (Help) It works in both versions of H2 if I create a table with a different name than CHECK. The H2 documentation doesn't include CHECK as one of the keywords. In my case, I work with a legacy system with a large amount of data and several surrounding systems, so I can't easily pick a different name so I am kind of stuck with one of the tables having this unfortunate name. Before attempting to start a such journey would I like to get some input on this matter. Regards, Henrik -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
