I have a PageStore database that throws an error when I try to connect to
it (both with version 1.3.176 and 1.4.195).
It throws an error saying:
Column "INT" not found; SQL statement:
CREATE CACHED TABLE PUBLIC.SURVEY6(
RESPONSE_ID UUID NOT NULL,
CHECK INT,
Q1 INT,
Q2 INT,
Q3 INT,
Q4 INT,
Q28 INT
) [42122-195]
The syntax error is correct (because of the occurrence of CHECK INT) if
this statement had ever been executed. Instead, earlier a similar statement
has been executed but that had quoted column names containing "CHECK" INT
(I can tell that from my database logging). These actions on the database
have been performed with 1.4.195.
Why is H2 trying to create a table when I try to connect to this database?
Is that because an error occurred earlier and that has left the database in
an invalid state? And why is it trying to execute an unquoted version of my
original SQL statement?
Thanks,
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
