Skip to:
The Liquibase is not generating difference between two columns of datatype datetime in MYSQL.Liquibase says no difference found.
Eg: Column name dob.
Source:
mysql> desc test;-------------------+----+--------------------+
Field
Type
Null
Key
Default
Extra
-------------------+----+--------------------+
sno
int(10)
YES
NULL
name
varchar(10)
dob
datetime
-------------------+----+--------------------+3 rows in set (0.00 sec)
Target :
datetime(6)
MYSQL 5.7.22- On Ubuntu
The Liquibase is not generating difference between two columns of datatype datetime in MYSQL.
Liquibase says no difference found.
Eg: Column name dob.
Source:
mysql> desc test;
-------------------+----+--------------------+
Field
Type
Null
Key
Default
Extra
-------------------+----+--------------------+
sno
int(10)
YES
NULL
name
varchar(10)
YES
NULL
dob
datetime
YES
NULL
-------------------+----+--------------------+
3 rows in set (0.00 sec)
Target :
mysql> desc test;
-------------------+----+--------------------+
Field
Type
Null
Key
Default
Extra
-------------------+----+--------------------+
sno
int(10)
YES
NULL
name
varchar(10)
YES
NULL
dob
datetime(6)
YES
NULL
-------------------+----+--------------------+
3 rows in set (0.00 sec)