Wednesday 10 December 2008

Nasty liquibase bug

We recently came across a nasty liquibase bug.

When you drop a not null constraint on a table and you do not add in the column data type liquibase creates the column with a null column type.

Eg:
dropnotnullconstraint tablename="pirates" columnname="crew" --- creates a null column type.

Easy fix:
dropnotnullconstraint tablename="pirates" columnname="crew" columndatatype="VARCHAR(255)"


Just wanted to give everyone a heads up on the problem so they don't burn half a day trying to figure out what is going on.

1 comment:

Agile Enforcer said...

Oh I could have told you that... moo hahahaha.