A new topic, 'Unnecessary quoting of column name?', has been made on a board
you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=698.new#new
The text of the topic is shown below:
I have a situation with hsqldb that is giving me some problems. For this
changelog:
<changeSet id="createUsernamePasswordsTable" author="evan">
<createTable tableName="username_passwords">
<column name="id" type="int" autoIncrement="true">
<constraints primaryKey="true" nullable="false" />
</column>
<column name="person_id" type="int"/>
<column name="username" type="varchar(255)"/>
<column name="password" type="varchar(255)"/> <!-- content
encrypted -->
</createTable>
</changeSet>
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?
Thanks!
Evan
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The Liquibase Community Forum Team.------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
