I have created a new topic instead of extending my previous post because
this turns out to be a generic bug in H2 (I tested with versions 1.3.176
and 1.4.195).
Steps to reproduce:
1) Use the SQL Console to connect to an existing database (or create a new
one)
2) Execute: CREATE TABLE TEST("A" INT, "CHECK" INT)
3) Close connection
4) Reconnect to database => Exception:
Column "INT" not found; SQL statement:
CREATE CACHED TABLE PUBLIC.TEST(
A INT,
CHECK INT
) [42122-195]
<http://127.0.1.1:8082/login.do?jsessionid=ab7490ca12f31326b825a9b3e23b3892#>
42S22/42122 (Help)
<http://h2database.com/javadoc/org/h2/api/ErrorCode.html#c42122>
H2 seems to re-execute the CREATE statements to re-establish the structure
of the database tables but fails to store them properly quoted. The parser
will fail on columns named CHECK or CONSTRAINT and will succeed on for
example CREATE. I have not tried using column type names like INT or
VARCHAR.
Kind regards,
Silvio
--
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.
