Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5297

TIME(0), TIMESTAMP(0) and DATETIME(0) are self-incompatible during replication (upstream)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.5
    • Fix Version/s: 10.0.7
    • Component/s: None
    • Labels:

      Description

      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;

      • On MariaDB-10.0.5 slave: create a table with the same structure:
      • "Upgrade" master: stop MySQL-5.6 and start MariaDB-10.0.5 on top
        of the MySQL-5.6 data directory.
      • Configure and start row-based replication between master and slave.
      • Start replication
      • 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'

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: