Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE ten (f1 INTEGER NOT NULL PRIMARY KEY) 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 INSERT INTO t1 (f2) SELECT 1 FROM ten;
8 connection node_2;
9 INSERT INTO t1 (f2) SELECT 1 FROM ten;
10 ALTER TABLE t1 AUTO_INCREMENT = 1000;
11 INSERT INTO t1 (f2) SELECT 1 FROM ten;
12 connection node_1;
13 INSERT INTO t1 (f2) SELECT 1 FROM ten;
14 SELECT MIN(f1) >= 1000, COUNT(*) = 20, COUNT(DISTINCT f1) = 20 FROM t1 WHERE f1 >= 1000;
15 MIN(f1) >= 1000 COUNT(*) = 20 COUNT(DISTINCT f1) = 20
16 1 1 1
17 connection node_2;
18 SELECT MIN(f1) >= 1000, COUNT(*) = 20, COUNT(DISTINCT f1) = 20 FROM t1 WHERE f1 >= 1000;
19 MIN(f1) >= 1000 COUNT(*) = 20 COUNT(DISTINCT f1) = 20
20 1 1 1
21 connection node_1;
22 ALTER TABLE t1 AUTO_INCREMENT = 5;
23 INSERT INTO t1 (f2) SELECT 1 FROM ten;
24 connection node_2;
25 INSERT INTO t1 (f2) SELECT 1 FROM ten;
26 SELECT MIN(f1) >= 1000, COUNT(*) = 40, COUNT(DISTINCT f1) = 40 FROM t1 WHERE f1 >= 1000;
27 MIN(f1) >= 1000 COUNT(*) = 40 COUNT(DISTINCT f1) = 40
28 1 1 1
29 connection node_1;
30 SELECT MIN(f1) >= 1000, COUNT(*) = 40, COUNT(DISTINCT f1) = 40 FROM t1 WHERE f1 >= 1000;
31 MIN(f1) >= 1000 COUNT(*) = 40 COUNT(DISTINCT f1) = 40
32 1 1 1
33 DROP TABLE t1;
34 connection node_1;
35 SET GLOBAL wsrep_auto_increment_control = OFF;
36 SET GLOBAL auto_increment_increment = 1;
37 SET GLOBAL auto_increment_offset = 1;
38 connection node_2;
39 SET GLOBAL wsrep_auto_increment_control = OFF;
40 SET GLOBAL auto_increment_increment = 1;
41 SET GLOBAL auto_increment_offset = 1;
42 connection node_1a;
43 CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB;
44 connection node_2a;
45 ALTER TABLE t1 AUTO_INCREMENT=100;
46 connection node_1a;
47 INSERT INTO t1 (f2) SELECT 1 FROM ten;
48 connection node_2a;
49 INSERT INTO t1 (f2) SELECT 1 FROM ten;
50 SELECT MIN(f1) = 100, MAX(f1) = 119, COUNT(f1) = 20, COUNT(DISTINCT f1) = 20 FROM t1;
51 MIN(f1) = 100 MAX(f1) = 119 COUNT(f1) = 20 COUNT(DISTINCT f1) = 20
52 1 1 1 1
53 connection node_1a;
54 SELECT MIN(f1) = 100, MAX(f1) = 119, COUNT(f1) = 20, COUNT(DISTINCT f1) = 20 FROM t1;
55 MIN(f1) = 100 MAX(f1) = 119 COUNT(f1) = 20 COUNT(DISTINCT f1) = 20
56 1 1 1 1
57 DROP TABLE t1;
58 DROP TABLE ten;