Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, node VARCHAR(10)) ENGINE=InnoDB;
5 SELECT @@auto_increment_increment = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size');
6 @@auto_increment_increment = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size')
7 1
8 connection node_2;
9 auto_increment_offset_differ
10 1
11 connection node_1;
12 INSERT INTO t1 VALUES (DEFAULT, 'node1');;
13 connection node_2;
14 INSERT INTO t1 VALUES (DEFAULT, 'node2');;
15 connection node_1;
16 connection node_2;
17 SELECT @@auto_increment_increment = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size');
18 @@auto_increment_increment = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size')
19 1
20 connection node_1;
21 auto_increment_offset_differ
22 1
23 connection node_2;
24 INSERT INTO t1 VALUES (DEFAULT, 'node2'), (DEFAULT, 'node2'), (DEFAULT, 'node2'), (DEFAULT, 'node2'), (DEFAULT, 'node2'), (DEFAULT, 'node2'), (DEFAULT, 'node2'), (DEFAULT, 'node2'), (DEFAULT, 'node2'), (DEFAULT, 'node2');;
25 connection node_1;
26 INSERT INTO t1 VALUES (DEFAULT, 'node1'), (DEFAULT, 'node1'), (DEFAULT, 'node1'), (DEFAULT, 'node1'), (DEFAULT, 'node1'), (DEFAULT, 'node1'), (DEFAULT, 'node1'), (DEFAULT, 'node1'), (DEFAULT, 'node1'), (DEFAULT, 'node1');;
27 connection node_2;
28 connection node_1;
29 connection node_2;
30 SELECT COUNT(*) = 22 FROM t1;
31 COUNT(*) = 22
32 1
33 SELECT COUNT(DISTINCT f1) = 22 FROM t1;
34 COUNT(DISTINCT f1) = 22
35 1
36 connection node_1;
37 SELECT COUNT(*) = 22 FROM t1;
38 COUNT(*) = 22
39 1
40 SELECT COUNT(DISTINCT f1) = 22 FROM t1;
41 COUNT(DISTINCT f1) = 22
42 1
43 DROP TABLE t1;