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.
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
