53 lines
1.3 KiB
Plaintext
53 lines
1.3 KiB
Plaintext
SET @base_seq = (SELECT CAST(variable_value AS UNSIGNED) FROM performance_schema.global_status WHERE variable_name = 'Lizard_commit_gcn');
|
|
create table t1 (a int , primary key (a));
|
|
show variables like "innodb_equal_gcn_visible";
|
|
Variable_name Value
|
|
innodb_equal_gcn_visible OFF
|
|
set global innodb_equal_gcn_visible =false;
|
|
ERROR HY000: Variable 'innodb_equal_gcn_visible' is a read only variable
|
|
# restart: --innodb_equal_gcn_visible=true
|
|
xa begin 'v1';
|
|
set innodb_snapshot_seq = @base_seq +10002;
|
|
select * from t1;
|
|
a
|
|
insert into t1 values (12001);
|
|
xa begin 'x12002';
|
|
insert into t1 values (12002);
|
|
xa end 'x12002';
|
|
xa commit 'x12002' one phase;
|
|
xa begin 'x12003';
|
|
insert into t1 values (12003);
|
|
xa end 'x12003';
|
|
xa prepare 'x12003';
|
|
set innodb_commit_seq = @base_seq +10002;
|
|
xa commit 'x12003';
|
|
select * from t1;
|
|
a
|
|
12001
|
|
12002
|
|
12003
|
|
xa end 'v1';
|
|
xa commit 'v1' one phase;
|
|
delete from t1;
|
|
# restart: --innodb_equal_gcn_visible=false
|
|
xa begin 'v2';
|
|
set innodb_snapshot_seq = @base_seq +20002;
|
|
select * from t1;
|
|
a
|
|
insert into t1 values (22001);
|
|
xa begin 'x22002';
|
|
insert into t1 values (22002);
|
|
xa end 'x22002';
|
|
xa commit 'x22002' one phase;
|
|
xa begin 'x22003';
|
|
insert into t1 values (22003);
|
|
xa end 'x22003';
|
|
xa prepare 'x22003';
|
|
set innodb_commit_seq = @base_seq +20002;
|
|
xa commit 'x22003';
|
|
select * from t1;
|
|
a
|
|
xa end 'v2';
|
|
xa commit 'v2' one phase;
|
|
drop table t1;
|