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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 5.3.12, 5.5.37, 10.0.10
    • 10.1.2
    • Replication
    • 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

          duplicates

          Task - A task that needs to be done. MDEV-5528 Command line variable to choose MariaDB-5.3 vs MySQL-5.6 temporal data formats

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10746 Replicate Data from 10.0 -> 10.1 (Corrupted replication event was detected )

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12744 Corrupted replication event was detected. Not printing the value

          • Major - Major loss of function.
          • Closed
          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-6389 DATETIME w/ transportable tablespaces from MySQL 5.6 to MariaDB 10.0 gives "precise type mismatch" error.

          • Major - Major loss of function.
          • Open
          is blocked by

          Task - A task that needs to be done. MDEV-5528 Command line variable to choose MariaDB-5.3 vs MySQL-5.6 temporal data formats

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-19906 Show internal type for TIMESTAMP, DATETIME, and TIME columns

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9567 mysqlbinlog fails to read binlog event which inserts timestamp with wrong number of microseconds

          • Major - Major loss of function.
          • Closed

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              3 Vote for this issue
              Watchers:
              7 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.