A new topic, 'addDefaultValue generates erroneous sql for MySQL', has been made
on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=1061.new#new
The text of the topic is shown below:
Hi,
I tried to execute the following changeSet with liquibase 1.9.5 on MySQL 5.1.32
<addDefaultValue tableName="myTab" columnName="myColumn"
defaultValueDate="CURRENT_TIMESTAMP" />
The liquibase update of my database does not work. Liquibase tries to execute
the following sql statement:
ALTER TABLE myTab ALTER myColumn SET DEFAULT CURRENT_TIMESTAMP;
The error I get is "You have an error in your SQL syntax."
What could be the problem?
Best regards /Lasse
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.
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Liquibase-user mailing list
Liquibase-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/liquibase-user
