maria-developers team mailing list archive

[Alexander Barkov <bar@xxxxxxxxxxx>]

Hello,

I propose to switch to MySQL-5.6 TIME/DATETIME/TIMESTAMP formats
by default and deprecate MariaDB native temporal data types,
together with pre-5.6 non-fractional types.

The problem is that MariaDB native data types
(and MySQL-5.5 non-fractional data types)
do not work with row based replication in case of:
  TIME(N) -> TIME(M)

There is no metadata telling about the column precision
in the binary log file. It can only work when N=M.

MySQL-5.6 uses separate type codes for the temporal data types:
MYSQL_TYPE_TIME2
MYSQL_TYPE_DATETIME2
MYSQL_TYPE_TIMESTAMP2
and does put precision into metadata in the binary log.

So it works for N != M.


There is a JIRA task for this:

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

I'd propose to do it in 10.1.x,
as 10.0.x is too late.

Greetings.