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 Open .

        Attachments

          Issue links

            Activity

              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