Row based replication of the TIME(N), DATETIME(N) and TIMESTAMP(N)
data types does not store column metadata into the binary log, so
slave does not have any information about the precision of the column on
master. Slave can only assume that the precision is exactly the same
on master and on slave.
This puts some limitations. Examples when RBR does not work:
- From TIME(N) to TIME(M), for N!=M
- From TIME(N) to another data type, e.g. VARCHAR or DECIMAL.
- From TIME(N) in a MariaDB master to TIME(N) in a MySQL56 slave.