Liquibase - Add defaultValueComputed as CURRENT_TIMESTAMP to timestamp column

mysql liquibase database-versioning
Suraj Prajapati picture Suraj Prajapati · Feb 14, 2018 · Viewed 9.3k times · Source

I am using liquibase 3.5.3 to run liquibase update command on MySql 5.5. I have below changeSet to create a table which has a column as Created_Time that should have a default value as CURRENT_TIMESTAMP.

<changeSet author="authorName" id="AutoGeneratedId">
    <createTable tableName="aTable">
        <column autoIncrement="true" name="Id" type="INT">
            <constraints primaryKey="true"/>
        </column>
        <column name="Code" type="VARCHAR(45)"/>
        <column defaultValueComputed="CURRENT_TIMESTAMP" name="Created_Time" type="TIMESTAMP(19)"/>
    </createTable>
</changeSet>

While firing liquibase command it throws an exception as Unexpected error running Liquibase: Invalid default value for 'Created_Time' [Failed SQL: CREATE TABLE aTable (Id INT AUTO_INCREMENT NOT NULL, Code VARCHAR(45) NULL, Created_Time TIMESTAMP(19) DEFAULT NOW() NULL, CONSTRAINT PK_ATABLE PRIMARY KEY (Id))]

Liquibase is converting CURRENT_TIMESTAMP into NOW() that might be causing this issue.

Can some please provide me any solution or alternative to this issue?

Answer

Duminda Jayarathne picture Duminda Jayarathne · Feb 16, 2018

Add type as 'TIMESTAMP' as following

<column defaultValueComputed="CURRENT_TIMESTAMP" name="Created_Time" type="TIMESTAMP"/>

Related questions

Define Changeset for insert query in liquibase

I have two table as following : CREATE TABLE StudentMaster ( sId SERIAL, StudentName VARCHAR(50) ); CREATE TABLE StudentClassMap ( studnetId BIGINT UNSIGNED NOT NULL, studentClass VARCHAR(10), FOREIGN KEY (studnetId) REFERENCES StudentMaster (sId) ); This is my insert query. INSERT INTO StudentMaster (studentName) values ('Jay …

Read More
Liquibase - how to generate a changelog for existing database

I'm trying to use liquibase for generating the changeLog, starting by snapshoting the current state of my database. Environment details: OS: Windows 7 32 x86, Java JDK 1.7, mysql jdbc driver from MySQL liquibase 2.0.5. I run the following from command line: liquibase --driver=…

Read More
Liquibase: How to set Charset UTF-8 on MySQL database tables?

My Liquibase changeset looks like <changeSet id="05192014.1525" author="h2"> <createTable tableName="network"> <column name="network_id" type="BIGINT(19) UNSIGNED"> <constraints nullable="false" primaryKey="true"/> </column> <column name="name" type="…

Read More