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

              Assignee:
              bar Alexander Barkov
              Reporter:
              hholzgra Hartmut Holzgraefe
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: