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

Allow ALGORITHM=INPLACE for 10.1 tables that contain virtual columns

    XMLWordPrintable

Details

    • 10.2.11

    Description

      With the dataset of MDEV-14023, ALTER TABLE will fail in InnoDB with a misleading error message:

      ERROR 1901 (HY000): Function or expression 'AUTO_INCREMENT' cannot be used in the GENERATED ALWAYS AS clause of `AttendDet_ID`
      

      All of the following statements will lead to the above response:

      ALTER TABLE AttendDet ADD INDEX(counter), LOCK=NONE;
      ALTER TABLE AttendDet DROP INDEX IX_AttendDet_Shift, LOCK=NONE;
      ALTER TABLE AttendDet DROP INDEX IX_AttendDet_Shift, ALGORITHM=INPLACE;
      

      We must fix this (insert the missing records to SYS_VIRTUAL), so that early users of virtual columns in 10.1 will be able to quickly create indexes on the virtual columns in 10.2 (MDEV-5800), and to instantly add columns in 10.3 (MDEV-11369), among other things.

      Attachments

        1. data.tar.gz
          1.12 MB
          Elena Stepanova

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              1 Vote for this issue
              Watchers:
              7 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.