|
--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.
|