Column type of "TIMESTAMP(6)" under MySql converted to TIMESTAMP dropping fractional seconds

Description

A createTable with the following does not work:

Causes the following error:

MySql error:

Relevent MySql documentation on fractional sections:

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

Reporter

JasonK

Components

Fix versions

Affects versions

Priority

Major
Configure