Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
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