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

Command line variable to choose MariaDB-5.3 vs MySQL-5.6 temporal data formats

        Details

        • Type: Task
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Fix Version/s: 10.1.2
        • Component/s: OTHER
        • Labels:
          None

          Description

          Add a new mysqld command line parameter to choose
          between MariaDB-5.3 and MySQL-5.6 low level formats
          for TIME, DATETIME, TIMESTAMP:

          mysqld --mysql56-temporal-format

          Add a corresponding read-only global system variable @@mysql56_temporal_format.

          Consider switching to the MySQL56 temporal format as the default.
          The advantage of the MySQL56 format is that it uses
          separate type codes MYSQL_TYPE_TIME2, MYSQL_TYPE_TIMESTAMP2,
          MySQL_TYPE_DATETIME2 and put the column precisions in metadata
          in the binary log, which can help to fix the problem reported in MDEV-5377.

            Gliffy Diagrams

              Attachments

                Issue Links

                blocks

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5377 Row-based replication of MariaDB temporal data types with FSP>0 into a different column type

                • Major - Major loss of function.
                • Open

                Task - A task that needs to be done. MDEV-6001 Merge tests for MySQL WL#946 TIME/DATETIME/TIMESTAMP with fractional precision

                • Major - Major loss of function.
                • Stalled
                links to

                Web Link Bug #70124 Timestamp and datetimes self-incompatible during replication

                Web Link Bug #72610 Out of memory on 5.6 slave using RBR with DATETIME when table created in 5.5.

                  Activity

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

                  ok to push

                  Show
                  serg Sergei Golubchik added a comment - ok to push
                  Hide
                  Permalink
                  greenman Ian Gilfillan added a comment -

                  This option has now been added to the documentation.

                  Show
                  greenman Ian Gilfillan added a comment - This option has now been added to the documentation.

                    People

                    • Assignee:
                      greenman Ian Gilfillan
                      Reporter:
                      bar Alexander Barkov
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      4 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - 1 week
                        1w
                        Remaining:
                        Time Spent - 2 hours, 30 minutes Remaining Estimate - 4 days, 5 hours, 30 minutes
                        4d 5h 30m
                        Logged:
                        Time Spent - 2 hours, 30 minutes Remaining Estimate - 4 days, 5 hours, 30 minutes
                        2h 30m