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

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14023 10.1 InnoDB tables with virtual columns cannot be accessed in 10.2

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17199 Assertion `pos < table->n_v_def' failed in dict_table_get_nth_v_col after upgrade from 10.1/10.0 to 10.2

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18084 Server crashes in row_upd_changes_some_index_ord_field_binary or Assertion `pos < index->n_def' failed in dict_index_get_nth_field upon UPDATE after upgrade from 10.1/10.0

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19027 create_table_def fails when virtual column is present between stored columns

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19066 AddressSanitizer: use-after-poison in innobase_build_col_map after upgrade from 10.1

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

          Task - A task that needs to be done. MDEV-11424 Instant ALTER TABLE of failure-free record format changes

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14341 Allow LOCK=NONE in table-rebuilding ALTER when indexed virtual columns exist

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17468 Avoid table rebuild on operations on generated columns

          • Major - Major loss of function.
          • Stalled

          Task - A task that needs to be done. MDEV-5800 indexes on virtual (not materialized) columns

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15476 Inplace algorithm doesn't support changing virtual column datatype

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16332 Allow ALGORITHM=NOCOPY or INSTANT for changes of virtual column type

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19214 Virtual column type cannot be converted from one to another - unhelpful error message

          • Major - Major loss of function.
          • Open

          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.