Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE ten (f1 INTEGER) Engine=InnoDB;
5 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
6 CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) Engine=InnoDB;
7 connection node_2;
8 set session wsrep_sync_wait=15;
9 SET GLOBAL wsrep_slave_threads = 4;
10 connection node_1;
11 INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;;
12 connection node_1a;
13 INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;;
14 connection node_2;
15 INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;;
16 connection node_1;
17 SELECT COUNT(*) FROM t1;
18 COUNT(*)
19 30000
20 SELECT COUNT(DISTINCT f1) FROM t1;
21 COUNT(DISTINCT f1)
22 30000
23 connection node_1a;
24 SELECT COUNT(*) FROM t1;
25 COUNT(*)
26 30000
27 SELECT COUNT(DISTINCT f1) FROM t1;
28 COUNT(DISTINCT f1)
29 30000
30 connection node_2;
31 disconnect node_1a;
32 SELECT COUNT(*) AS EXPECT_30000 FROM t1;
33 EXPECT_30000
34 30000
35 SELECT COUNT(DISTINCT f1) AS EXPECT_30000 FROM t1;
36 EXPECT_30000
37 30000
38 connection default;
39 DROP TABLE t1;
40 DROP TABLE ten;