[MDEV-16332] Allow ALGORITHM=NOCOPY or INSTANT for changes of virtual column type - Jira

XML

Word

Printable

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.6
Component/s: Storage Engine - InnoDB
Labels:

Description

Changing the type of a virtual column will not affect the format of the clustered index. It may imply DROP INDEX and ADD INDEX for any indexes that are defined on the virtual column. If such indexes are to remain after the ALTER TABLE operation, then changing the virtual column type obviously cannot be an instantaneous operation.

Attachments

Issue Links

relates to

MDEV-11424 Instant ALTER TABLE of failure-free record format changes

Closed

MDEV-14046 Allow ALGORITHM=INPLACE for 10.1 tables that contain virtual columns

Closed

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

Open

MDEV-16356 Allow ALGORITHM=NOCOPY for ADD CONSTRAINT

Open

MDEV-17468 Avoid table rebuild on operations on generated columns

Stalled

MDEV-5800 indexes on virtual (not materialized) columns

Closed

MDEV-15476 Inplace algorithm doesn't support changing virtual column datatype

Stalled

MDEV-19214 Virtual column type cannot be converted from one to another - unhelpful error message

Open

(3 relates to)

Activity

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Marko Mäkelä

Votes:: 1 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2018-05-30 10:22

Updated:: 2026-06-10 07:22

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

2d 7h

Git Integration

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