[MDEV-29021] ALTER TABLE fails when a stored virtual column is dropped and added - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 11.2.1
Component/s: Data Definition - Alter Table, Virtual Columns
Labels:
None

Description

Test case
--source include/have_innodb.inc
--source include/have_debug_sync.inc

create table t1 (a char(9), b char(9) as (a) stored) engine=InnoDB;
insert into t1 values ('foobar');

--send
set debug_sync= 'now wait_for downgraded';

--connect(con1,localhost,root,,)
set debug_sync= 'alter_table_online_downgraded signal downgraded wait_for goforit';
--send
alter ignore table t1 drop b, add b char(3) as (a) stored, algorithm=copy, lock=none

--connection default
--reap
update t1 set a = 'foobarqux';
set debug_sync= 'now signal goforit';

--connection con1
--reap

# Cleanup
drop table t1;
set debug_sync= reset;

Attachments

Issue Links

is duplicated by

MDEV-29007 Assertion `marked_for_write_or_computed()' failed upon online ADD COLUMN .. FIRST

Closed

relates to

MDEV-29013 ER_KEY_NOT_FOUND/lock timeout upon online alter with long unique indexes

Closed

Activity

Ascending order - Click to sort in descending order

Nikita Malyavin created issue - 2022-07-04 12:07

Nikita Malyavin made changes - 2022-07-04 12:08

Field	Original Value	New Value
Priority	Major [ 3 ]	Critical [ 2 ]

Nikita Malyavin made changes - 2022-07-04 12:08

Fix Version/s

10.10 [ 27530 ]

Nikita Malyavin made changes - 2022-07-04 12:08

Status

Open [ 1 ]

In Progress [ 3 ]

Nikita Malyavin made changes - 2022-07-04 12:31

Description

{code:sql|title=Test case}
--source include/have_innodb.inc
--source include/have_debug_sync.inc

create table t1 (a char(9), b char(9) as (a) stored) engine=InnoDB;
insert into t values ('foobar');

--send
set debug_sync= 'now wait_for downgraded';

--connect(con1,localhost,root,,)
set debug_sync= 'alter_table_online_downgraded signal downgraded wait_for goforit';
--send
alter ignore table t1 drop b, add b char(3) as (a) stored, algorithm=copy, lock=none

--connection default
--reap
update t set a = 'foobarqux';
set debug_sync= 'now signal goforit';

--connection con1
--reap

# Cleanup
drop table t;
set debug_sync= reset;
{code}

{code:sql|title=Test case}
--source include/have_innodb.inc
--source include/have_debug_sync.inc

create table t1 (a char(9), b char(9) as (a) stored) engine=InnoDB;
insert into t1 values ('foobar');

--send
set debug_sync= 'now wait_for downgraded';

--connect(con1,localhost,root,,)
set debug_sync= 'alter_table_online_downgraded signal downgraded wait_for goforit';
--send
alter ignore table t1 drop b, add b char(3) as (a) stored, algorithm=copy, lock=none

--connection default
--reap
update t1 set a = 'foobarqux';
set debug_sync= 'now signal goforit';

--connection con1
--reap

# Cleanup
drop table t;
set debug_sync= reset;
{code}

Nikita Malyavin made changes - 2022-07-04 12:32

Description

{code:sql|title=Test case}
--source include/have_innodb.inc
--source include/have_debug_sync.inc

create table t1 (a char(9), b char(9) as (a) stored) engine=InnoDB;
insert into t1 values ('foobar');

--send
set debug_sync= 'now wait_for downgraded';

--connect(con1,localhost,root,,)
set debug_sync= 'alter_table_online_downgraded signal downgraded wait_for goforit';
--send
alter ignore table t1 drop b, add b char(3) as (a) stored, algorithm=copy, lock=none

--connection default
--reap
update t1 set a = 'foobarqux';
set debug_sync= 'now signal goforit';

--connection con1
--reap

# Cleanup
drop table t;
set debug_sync= reset;
{code}

{code:sql|title=Test case}
--source include/have_innodb.inc
--source include/have_debug_sync.inc

create table t1 (a char(9), b char(9) as (a) stored) engine=InnoDB;
insert into t1 values ('foobar');

--send
set debug_sync= 'now wait_for downgraded';

--connect(con1,localhost,root,,)
set debug_sync= 'alter_table_online_downgraded signal downgraded wait_for goforit';
--send
alter ignore table t1 drop b, add b char(3) as (a) stored, algorithm=copy, lock=none

--connection default
--reap
update t1 set a = 'foobarqux';
set debug_sync= 'now signal goforit';

--connection con1
--reap

# Cleanup
drop table t1;
set debug_sync= reset;
{code}

Nikita Malyavin made changes - 2022-07-04 17:23

Status

In Progress [ 3 ]

In Testing [ 10301 ]

Nikita Malyavin made changes - 2022-07-04 17:23

Status

In Testing [ 10301 ]

Stalled [ 10000 ]

Nikita Malyavin made changes - 2022-07-04 17:23

Assignee	Nikita Malyavin [ nikitamalyavin ]	Sergei Golubchik [ serg ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Nikita Malyavin made changes - 2022-07-04 17:32

Link

This issue relates to ~~MDEV-29013~~ [ ~~MDEV-29013~~ ]

Nikita Malyavin made changes - 2022-07-05 12:32

Component/s		Data Definition - Alter Table [ 10114 ]
Component/s		Virtual Columns [ 10803 ]

Sergei Golubchik made changes - 2022-07-07 13:05

Assignee	Sergei Golubchik [ serg ]	Nikita Malyavin [ nikitamalyavin ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Nikita Malyavin made changes - 2022-07-13 17:15

Assignee	Nikita Malyavin [ nikitamalyavin ]	Sergei Golubchik [ serg ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Nikita Malyavin made changes - 2022-07-13 17:22

Link

This issue is duplicated by ~~MDEV-29007~~ [ ~~MDEV-29007~~ ]

Sergei Golubchik made changes - 2022-07-17 11:22

Status

In Review [ 10002 ]

In Testing [ 10301 ]

Sergei Golubchik made changes - 2022-07-17 11:22

Assignee

Sergei Golubchik [ serg ]

Nikita Malyavin [ nikitamalyavin ]

Ralf Gebhardt made changes - 2022-08-02 12:25

Fix Version/s		10.11 [ 27614 ]
Fix Version/s	10.10 [ 27530 ]

Sergei Golubchik made changes - 2023-08-16 09:39

Fix Version/s		11.2.1 [ 29034 ]
Fix Version/s	10.11 [ 27614 ]
Resolution		Fixed [ 1 ]
Status	In Testing [ 10301 ]	Closed [ 6 ]

People

Assignee:: Nikita Malyavin

Reporter:: Nikita Malyavin

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2022-07-04 12:07

Updated:: 2023-08-16 09:39

Resolved:: 2023-08-16 09:39

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration