Debian Codegraph @

mysql-test/suite/galera/t/versioning_trx_id.test

raw
1 --source include/galera_cluster.inc
2
3 call mtr.add_suppression("Sending JOIN failed: ");
4
5 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
6
7 --connection node_1
8 create table t1 (a int, s bigint unsigned as row start, e bigint unsigned as row end, period for system_time(s,e)) engine=InnoDB with system versioning;
9 insert into t1 (a) values (1),(2);
10
11 --connection node_2
12 set session wsrep_sync_wait=15;
13 insert into t1 (a) values (3),(4);
14 select a from t1;
15 select count(*) from mysql.transaction_registry where begin_timestamp='0-0-0';
16 if (`SELECT count(*) from mysql.transaction_registry where begin_timestamp>commit_timestamp`) {
17 select * from mysql.transaction_registry;
18 }
19 select count(*) from mysql.transaction_registry where begin_timestamp>commit_timestamp;
20
21 --connection node_3
22 set session wsrep_sync_wait=15;
23 insert into t1 (a) values (5),(6);
24 select a from t1;
25 select count(*) from mysql.transaction_registry where begin_timestamp='0-0-0';
26 if (`SELECT count(*) from mysql.transaction_registry where begin_timestamp>commit_timestamp`) {
27 select * from mysql.transaction_registry;
28 }
29 select count(*) from mysql.transaction_registry where begin_timestamp>commit_timestamp;
30
31 --connection node_1
32 set session wsrep_sync_wait=15;
33 select a from t1;
34 select count(*) from mysql.transaction_registry where begin_timestamp='0-0-0';
35 if (`SELECT count(*) from mysql.transaction_registry where begin_timestamp>commit_timestamp`) {
36 select * from mysql.transaction_registry;
37 }
38 select count(*) from mysql.transaction_registry where begin_timestamp>commit_timestamp;
39
40 drop table t1;
41
42 --disconnect node_3