addDefaultValue generates erroneous sql for MySQL

General Discussion
1

Hi,

I tried to execute the following changeSet with liquibase 1.9.5 on MySQL 5.1.32

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

2

With 2.0, we introduced defaultValueComputed as an attribute to get around vagueness as to what is a real value, and what is a function that should never be quoted or parsed.  If you change your attribute, does it work better?

Nathan

3

Ok,

What could I change the attribute to to accomplish the same result?

Best regards /Lasse

4

Woudl it work to use defaultValueDate=“CURRENT_TIMESTAMP()” ?

Otherwise, you can always fall back to if the generated SQL is not working for you.

Nathan