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

Inconsistent handling of "ALGORITHM=INPLACE" with PERSISTENT generated columns.

Details

    • 10.0.24

    Description

      It is not possible to add a PERSISTENT virtual column using ALGORITHM=INPLACE but it is possible to drop it (together with an index on it) that way.

      And while the column is present in the table, it is not possible to add/drop any index using ALGORITHM=INPLACE (so if I understand it, "fast index creation" is not available).

      alter ONLINE table ... behaves the same.

      Thanks to danblack for extending the testcase and testing on 10.1.8 http://pastie.org/10517538

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Elena Stepanova made transition -
          Open Confirmed
          		1d 9h 19m 1
          Sergei Golubchik made transition -
          Confirmed In Progress
          		102d 1h 52m 1
          Sergei Golubchik made transition -
          In Progress Stalled
          		1s 1
          Sergei Golubchik made transition -
          Stalled Closed
          		4d 20h 19m 1

          People

            serg Sergei Golubchik
            jkavalik Jiri Kavalik
            Votes:
            1 Vote for this issue
            Watchers:
            3 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.