A new topic, 'bug report - liquibase 2.0 RC 5: true is false and false is
true', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=627.new#new
The text of the topic is shown below:
I am trying to create a table on a mysql server with a bit column and a default
value. Here the responsible changelog part:
Code:
<changeSet id="248fdeca-6cab-4ab9-9d9a-3f97f19c7b1e" author="ma.eberhard">
<createTable tableName="RM_Benutzer">
<column name="BenutzerId" type="int"
autoIncrement="true">
<constraints nullable="false"
primaryKey="true"/>
</column>
<column name="BenutzerName" type="varchar(255)">
<constraints nullable="false" unique="true"/>
</column>
<column name="PasswordDoesNotExpire" type="bit"
defaultValueBoolean="false">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
This results in the following sql beeing executet:
Code:
CREATE TABLE `RM_Benutzer` (
`BenutzerId` INT AUTO_INCREMENT NOT NULL,
`BenutzerName` VARCHAR(255) NOT NULL,
`PasswordDoesNotExpire` bit DEFAULT 1 NOT NULL,
);
The Default value is now 1 on the db. It should be 0.
I have deleted some columns to make it clearer. So if there are any syntax
errors or inconsistencies, it's because of that. I can assure you, that the
code works.
I think, from what I have found on the web and from the .xsd files, that
"false" should be the correct value. And it works in liquibase 1.9. So I would
consider this a bug, until someone tells me what I am doing wrong.
Thanks
Mario Eberhard
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.------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
