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

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.5
    • 10.0.7
    • None

    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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.