Liquibase Add default value

Question

I have created a table with name person and added a column 'phone_number' using liquibase changeset. But now I want to add a default value for it. but it did not work, so far I have tried this:

<addDefaultValue columnName="phone_number"
                 defaultValue="[phone]"
                 tableName="person"/>

and

<changeSet author="haseeb" id="20160413123500">
    <update tableName="person">
        <column name="phone_number" type="varchar(255)" defaultValue="[phone]"/>
    </update>
</changeSet>

and

<changeSet author="haseeb" id="20160413123501">
    <update tableName="person">
        <column name="phone_number" type="varchar(255)" value="[phone]"/>
</update>

Can anyone point out where I did wrong and also would adding default value will add value to previously added rows?

Answer 1

try this

<addDefaultValue columnName="phone_number"
             defaultValue="[phone]"
             tableName="person" columnDataType="varchar(255)"/>

Answer 2

Try this:

<changeSet author="haseeb" id="20160413123501">
    <modifyDataType
        columnName="phone_number"
        newDataType="varchar(255)"
        defaultValue="[phone]"
        tableName="person"/>
    <comment>Change default value</comment>
</changeSet>

Answer 3

This is worked for expression:

- addDefaultValue:
    tableName: RT_STAGE
    columnName: CREATED_DATE
    defaultValueComputed: now()

and this for boolean:

- addDefaultValue:
    tableName: RT_STAGE
    columnName: FINAL
    defaultValueBoolean: false