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

Convert old temporal types on ALTER TABLE ... FORCE

    XMLWordPrintable

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

          Activity

            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.