defaultValueComputed does not seem to work

General Discussion
1

I have a loadUpdateChange set and wants to get id value from a sequence but seems like it is been ignored by liquibase. Following is the change set

<loadUpdateData
                file="/db/data/017_Hubs.csv"
                separator=";"
                tableName="hub"
                usePreparedStatements="true"
                primaryKey="id">
            <column name="id" type="numeric" defaultValueComputed="nextval('sequence_generator')"/>
            <column name="name" type="string"/>
            <column name="url" type="string"/>
            <column name="facility_type" type="string"/>
            <column name="address_id" type="numeric"/>
            <column name="tenant_id" type="numeric"/>
            <column name="start_date" type="date" defaultValue="${now}"/>
            <column name="email" type="string"/>
            <column name="phone" type="string"/>
            <column name="status" type="string"/>
</loadUpdateData>
2

No Reply, this is disappointing.

3

What DB are you using? The defaultValueComputed attribute is not supported by MySQL and HyperSQL as stated here.

4

I haven’t tried using defaultValueComputed, but have you tried adding the function to the csv file instead? I did this for SYSDATE (oracle db) in a date column, and it worked just fine.