I have a situation with hsqldb that is giving me some problems. For this changelog:
I am getting a SQL statement generated like this:
– Changeset classpath:migrations/changelog.xml::createUsernamePasswordsTable::evan::(Checksum: 2:a9e5b31be82c449c720781a980039eeb)
CREATE TABLE username_passwords (id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, person_id INT, username VARCHAR(255), “password” VARCHAR(255), CONSTRAINT PK_USERNAME_PASSWORDS PRIMARY KEY (id));
Notice the quotations around “password”?? This causes hsqldb to use case-sensitive comparisons for that column name. The issue comes later then, when my jdbc preparedStatement uppercases the column name and then goes looking for the column PASSWORD in the database, which of course, hsqldb says does not exist.
So the question is, why is liquibase putting quotes around that one column name? And, how do I get it to stop doing so?