Debian Codegraph @

mysql-test/suite/galera/r/versioning_trx_id.result

raw
1 connection node_2;
2 connection node_1;
3 call mtr.add_suppression("Sending JOIN failed: ");
4 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
5 connection node_1;
6 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;
7 insert into t1 (a) values (1),(2);
8 connection node_2;
9 set session wsrep_sync_wait=15;
10 insert into t1 (a) values (3),(4);
11 select a from t1;
12 a
13 1
14 2
15 3
16 4
17 select count(*) from mysql.transaction_registry where begin_timestamp='0-0-0';
18 count(*)
19 0
20 select count(*) from mysql.transaction_registry where begin_timestamp>commit_timestamp;
21 count(*)
22 0
23 connection node_3;
24 set session wsrep_sync_wait=15;
25 insert into t1 (a) values (5),(6);
26 select a from t1;
27 a
28 1
29 2
30 3
31 4
32 5
33 6
34 select count(*) from mysql.transaction_registry where begin_timestamp='0-0-0';
35 count(*)
36 0
37 select count(*) from mysql.transaction_registry where begin_timestamp>commit_timestamp;
38 count(*)
39 0
40 connection node_1;
41 set session wsrep_sync_wait=15;
42 select a from t1;
43 a
44 1
45 2
46 3
47 4
48 5
49 6
50 select count(*) from mysql.transaction_registry where begin_timestamp='0-0-0';
51 count(*)
52 0
53 select count(*) from mysql.transaction_registry where begin_timestamp>commit_timestamp;
54 count(*)
55 0
56 drop table t1;
57 disconnect node_3;