Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
11.2(EOL)
Description
--source include/have_innodb.inc
|
|
create table t (a int primary key) engine=innodb; |
insert into t values (1); |
|
--echo # XA commit
|
|
set debug_sync= 'alter_table_online_downgraded signal downgraded wait_for go'; |
send alter table t force, algorithm=copy, lock=none; |
|
--connect(con1, localhost, root,,)
|
set debug_sync= 'now wait_for downgraded'; |
xa begin 'x1'; |
update t set a = 2 where a = 1; |
xa end 'x1'; |
xa prepare 'x1'; |
--disconnect con1
|
--connect(con1, localhost, root,,)
|
xa commit 'x1'; |
set debug_sync= 'now signal go'; |
--connection default
|
--reap # alter table
|
|
select * from t; |
The result expected is 2 in the output, but actual result is 1.
Attachments
Issue Links
- is caused by
-
MDEV-16329 Engine-independent online ALTER TABLE
- Closed