[MDEV-5297] TIME(0), TIMESTAMP(0) and DATETIME(0) are self-incompatible during replication (upstream) - JIRA

Details

The upstream bug http://bugs.mysql.com/bug.php?id=70124
is repeatable with MariaDB-10.0.5.

How-to-repeat:

Install and start two instances:
MySQL-5.6 for master, and MariaDB-10.0.5 for slave.
Do not start replication at this point.

On MySQL-5.6 master: create a table with non-fractional temporal fields:

CREATE TABLE t1 (a time(0), b datetime(0), c timestamp(0)) engine=myisam;

"Upgrade" master: stop MySQL-5.6 and start MariaDB-10.0.5 on top
of the MySQL-5.6 data directory.

Insert some data on master:

INSERT INTO t1 VALUES ('00:00:02','2001-01-01 00:00:02','2001-01-01 00:00:02');

Slave will fail with this error:

SHOW SLAVE STATUS;
...
Last_Error	Column 0 of table 'test.t1' cannot be converted from type 'time' to type 'time'

links to

Hide

Permalink

Alexander Barkov added a comment - 2013-12-06 17:05

Fixed in 10.0.

Show

Alexander Barkov added a comment - 2013-12-06 17:05 Fixed in 10.0.