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

Convert old temporal types on ALTER TABLE ... FORCE

Details

    Description

      MySQL 5.6 converts temporal types to the new sub-second-enabled type on ALTER TABLE ... FORCE (while original old types are kept when doing ALTER TABLE ... ENGINE=..., and even on CREATE TABLE ... LIKE)

      MariaDB doesn't touch temporal types on ALTER TABLE ... FORCE though, here some explicit change to the table structure is needed to force a change to the new temporal implementation instead, e.g. a ADD COULUMN or MODIFY COLUMN.

      The MySQL implementation of the operation was added with the following change set:

      https://github.com/mysql/mysql-server/commit/cc1fd36e44c793b85b2cae0117492a34f09dbf1a

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-16542 Fix ALTER TABLE FORCE to upgrade temporal types

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

          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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15225 Can't import .ibd file with temporal type format differing from mysql56_temporal_format

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

          Task - A task that needs to be done. MDEV-15228 Document how to upgrade old temporal columns

          • Major - Major loss of function.
          • Closed

          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-11351 Not able to rebuild tables with old timestamp format

          • Major - Major loss of function.
          • Confirmed

          Activity

            Ascending order - Click to sort in descending order
            hholzgra Hartmut Holzgraefe added a comment -

            Bug description modified, removed the part about "online operation"

            hholzgra Hartmut Holzgraefe added a comment - Bug description modified, removed the part about "online operation"
            hholzgra Hartmut Holzgraefe added a comment -

            Adding or modifying a column also doesn't force a temporal type change in MariaDB, so every temporal type needs to be converted manually ...

            hholzgra Hartmut Holzgraefe added a comment - Adding or modifying a column also doesn't force a temporal type change in MariaDB, so every temporal type needs to be converted manually ...

            People

              bar Alexander Barkov
              hholzgra Hartmut Holzgraefe
              Votes:
              1 Vote for this issue
              Watchers:
              4 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.