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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 5.3.12, 5.5.37, 10.0.10
    • Fix Version/s: 10.1.2
    • Component/s: Replication
    • Labels:
      None

      Description

      Row based replication of the TIME(N), DATETIME(N) and TIMESTAMP(N)
      data types does not store column metadata into the binary log, so
      slave does not have any information about the precision of the column on
      master. Slave can only assume that the precision is exactly the same
      on master and on slave.

      This puts some limitations. Examples when RBR does not work:

      • From TIME(N) to TIME(M), for N!=M
      • From TIME(N) to another data type, e.g. VARCHAR or DECIMAL.
      • From TIME(N) in a MariaDB master to TIME(N) in a MySQL56 slave.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: