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?
Okay, so I poked around a bit and found the keywords list in the class liquibase.database.core.HsqlDatabase, and “password” is in the list, making it a candidate to be quoted. This would be fine if password is a reserved word in sql.
Thanks for pointing that out. I’m not sure where the list of reserved words came from originally, but I removed password from the list for the next release. For now, you could capitalize password in your changelog or use the tag which will not do any quoting.
