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

        Details

        • Type: Bug
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Affects Version/s: 5.3.12, 5.5.37, 10.0.10
        • Fix Version/s: 10.1
        • Component/s: None
        • 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.

            Gliffy Diagrams

              Attachments

                Issue Links

                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

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment -

                  one possible solution — use MySQL-5.6 compatible on-disk format for temporal columns by default.

                  Show
                  serg Sergei Golubchik added a comment - one possible solution — use MySQL-5.6 compatible on-disk format for temporal columns by default.
                  Hide
                  Permalink
                  bar Alexander Barkov added a comment -

                  See also:
                  MDEV-5528 Command line variable to choose MariaDB-5.3 vs MySQL-5.6 temporal data formats

                  Show
                  bar Alexander Barkov added a comment - See also: MDEV-5528 Command line variable to choose MariaDB-5.3 vs MySQL-5.6 temporal data formats
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Just for a note,

                  • From TIME(N) to another data type, e.g. VARCHAR or DECIMAL.

                  This one doesn't seem to work on 5.6 either.

                  Show
                  elenst Elena Stepanova added a comment - Just for a note, From TIME(N) to another data type, e.g. VARCHAR or DECIMAL. This one doesn't seem to work on 5.6 either.
                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment -

                  It seems to be that the only reasonable solution is to use MySQL-5.6 temporal format and typecodes (that we already support anyway for compatibility reasons). Unfortunately, this cannot be done in 10.0...

                  Show
                  serg Sergei Golubchik added a comment - It seems to be that the only reasonable solution is to use MySQL-5.6 temporal format and typecodes (that we already support anyway for compatibility reasons). Unfortunately, this cannot be done in 10.0...

                    People

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

                      Dates

                      • Created:
                        Updated: