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

    • Sprint:
      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

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              marko Marko Mäkelä
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated: