If you run liquibase on HSQLDB to create a table named blob for example, it will generate the table “blob”. This is because blob is a keyword so the generated SQL looks something like CREATE TABLE “blob”, which in HSQLDB means the table will be in lowercase. Is there a way to specify that I want the tables to be in uppercase?(other than modifying the changeLogs)
Liquibase doesn’t do anything with the case of what is passed in. If you want the table uppercase, you either have to change it in the changelog file or create a custom subclass of HsqlDatabase that overrides the escapeDatabaseObject to uppercase it. See liquibase.org/extensions on how to register custom databases.
Nathan
That makes total sense. Thanks! FYI I’ve decided just not to name the table names keywords like blob and property, just makes every1s life easier
Suneet
