Difference for datatype DATETIME and DATETIME(6) not picked up

Description

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)

Environment

MYSQL 5.7.22- On Ubuntu

Status

Assignee

Unassigned

Reporter

Dilip Padmanabhan

Labels

None

Affects versions

3.5.4

Priority

Minor
Configure