Column type of "TIMESTAMP(6)" under MySql converted to TIMESTAMP dropping fractional seconds
Description
Environment
Mysql 5.6.19, 5.6.22
Java 7u60, 7u65, 7u67, 7u71, 8u25
mysql-connector 5.1.31 & 5.1.32, 5.1.34
Activity
Show:
PengCheng Zhou September 28, 2017 at 4:00 PM
not fixed. my liquibase is 3.5.3, jdk 1.8, mysql-connector-java-5.1.41.jar. It looks like it always output now() as defaultValue for all timestamp or timestamp(3) or timestamp(6) type.
Nathan Voxland April 15, 2015 at 7:46 PM
Fixed
JasonK January 16, 2015 at 3:27 PM
This does not seem to be resolved (testing 3.3.2).
Column definition:
Executed SQL from debug logging:
Which causes a failure on the default value due to the column type not being specified with precision:
Nathan Voxland October 21, 2014 at 9:37 PM
Fixed for 3.3.0
JasonK September 2, 2014 at 5:03 PM
Issue continues to exist with 3.2.2
A createTable with the following does not work:
Causes the following error:
MySql error:
Relevent MySql documentation on fractional sections:
http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html
http://dev.mysql.com/doc/refman/5.6/en/datetime.html