Liquibase : issue with setting boolean default value

Question

I am trying to add a new field with liquibase

<addColumn tableName="contact_client">
            <column defaultValue="0"
                    defaultValueBoolean="0"
                    name="obsolete"
                    type="boolean"/>
        </addColumn>

But I am getting this error :

liquibase.exception.DatabaseException: Invalid default value for 'obsolete' [Failed SQL: ALTER TABLE myApp.contact_client ADD obsolete BIT(1) DEFAULT 'false' NULL]

How can I pass a default value?

Answer 1

Actually, here is the solution for a MySQL database:

<addColumn tableName="contact_client">
    <column defaultValueBoolean="false"
            name="obsolete"
            type="boolean"/>
</addColumn>

I needed to remove the defaultValue property.