As describend on http://www.liquibase.org/documentation/changes/update.html LiquiBase generates SQL like : UPDATE cat.person SET address = NULL WHERE A String; This is invalid SQL unless address would be a boolean column. correct SQL should be UPDATE cat.person SET address = NULL WHERE address = 'A String';
Advice: 1. 'A String' in the example should be renamed to a valid example like "address = 'A String' ". 2. The <WHERE> element should be evolved to to build a WHERE clause by XML elements. Otherwise it is easier to use <SQL> element.
As describend on http://www.liquibase.org/documentation/changes/update.html
LiquiBase generates SQL like :
UPDATE cat.person SET address = NULL WHERE A String;
This is invalid SQL unless address would be a boolean column. correct SQL should be
UPDATE cat.person SET address = NULL WHERE address = 'A String';
Advice:
1. 'A String' in the example should be renamed to a valid example like "address = 'A String' ".
2. The <WHERE> element should be evolved to to build a WHERE clause by XML elements. Otherwise it is easier to use <SQL> element.