[MDEV-17035] Support ALGORITHM=NOCOPY for CHANGE virtual column expression - Jira

Details

Type: Task
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Fix Version/s: None
Component/s: Storage Engine - InnoDB
Labels:
- online-ddl

Description

Currently, the ALTER TABLE operation ALTER_STORED_GCOL_EXPR (changing the expression of a generated stored column, or materialized virtual column) is only supported by ALGORITHM=COPY, which does a full rebuild of the table.

We could support the operation with ALGORITHM=NOCOPY by validating all data and executing UPDATE of the data. Concurrent non-locking MVCC reads would be possible, but concurrent writes to the table could lead to locking conflicts.

Attachments

Issue Links

is blocked by

MDEV-16291 Allow ALGORITHM=NOCOPY for most ALTER TABLE in InnoDB

Open

relates to

MDEV-14341 Allow LOCK=NONE in table-rebuilding ALTER when indexed virtual columns exist

Open

MDEV-17468 Avoid table rebuild on operations on generated columns

Stalled

Activity

Ascending order - Click to sort in descending order

Marko Mäkelä created issue - 2018-08-22 12:42

Marko Mäkelä made changes - 2018-08-22 12:42

Field	Original Value	New Value
Link		This issue is blocked by MDEV-16291 [ MDEV-16291 ]

Geoff Montee (Inactive) made changes - 2019-04-20 21:11

Link

This issue relates to MDEV-14341 [ MDEV-14341 ]

Geoff Montee (Inactive) made changes - 2019-04-20 21:15

Link

This issue relates to MDEV-17468 [ MDEV-17468 ]

Sergei Golubchik made changes - 2021-12-06 21:21

Workflow

MariaDB v3 [ 89030 ]

MariaDB v4 [ 130889 ]

People

Assignee:: Marko Mäkelä

Reporter:: Marko Mäkelä

Votes:: 1 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2018-08-22 12:42

Updated:: 2019-04-20 21:15

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server