We're updating the issue view to help you get more done. 

Row-based replication of MariaDB temporal data types with FSP>0 into a different column type

Description

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.

Environment

None

Status

Assignee

Alexander Barkov

Reporter

Alexander Barkov

Fix versions

Affects versions

5.3.12
5.5.37
10.0.10

Priority

Major