Debian Codegraph @

mysql-test/suite/innodb/r/autoinc_debug.result

raw
1 CREATE TABLE t1 (id INT AUTO_INCREMENT PRIMARY KEY)ENGINE=INNODB;
2 # SETTING auto_increment_increment IN CONNECTION DEFAULT
3 SET AUTO_INCREMENT_INCREMENT = 1;
4 INSERT INTO t1 VALUES(NULL);
5 SELECT * FROM t1;
6 id
7 1
8 SHOW CREATE TABLE t1;
9 Table Create Table
10 t1 CREATE TABLE `t1` (
11 `id` int NOT NULL AUTO_INCREMENT,
12 PRIMARY KEY (`id`)
13 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
14 # restart
15 # SETTING auto_increment_increment IN CONNECTION1
16 SET AUTO_INCREMENT_INCREMENT = 2;
17 SET DEBUG_SYNC= 'ib_after_row_insert SIGNAL opened WAIT_FOR flushed1';
18 INSERT INTO t1 VALUES(NULL);
19 SET AUTO_INCREMENT_INCREMENT = 2;
20 SET DEBUG_SYNC= 'now WAIT_FOR opened';
21 SET DEBUG_SYNC= 'ib_after_row_insert_step SIGNAL flushed1 WAIT_FOR opened1';
22 insert into t1 values(NULL);
23 # CONNECTION default
24 SELECT * FROM t1;
25 id
26 1
27 3
28 SHOW CREATE TABLE t1;
29 Table Create Table
30 t1 CREATE TABLE `t1` (
31 `id` int NOT NULL AUTO_INCREMENT,
32 PRIMARY KEY (`id`)
33 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
34 SET DEBUG_SYNC= 'now SIGNAL opened1';
35 # CONNECTION con1
36 SELECT * FROM t1;
37 id
38 1
39 3
40 5
41 SHOW CREATE TABLE t1;
42 Table Create Table
43 t1 CREATE TABLE `t1` (
44 `id` int NOT NULL AUTO_INCREMENT,
45 PRIMARY KEY (`id`)
46 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
47 DROP TABLE t1;
48 CREATE TABLE t1(id INT AUTO_INCREMENT PRIMARY KEY)ENGINE=INNODB;
49 # SETTING auto_increment_increment IN CONNECTION DEFAULT
50 SET AUTO_INCREMENT_INCREMENT = 1;
51 INSERT INTO t1 VALUES(NULL);
52 SELECT * FROM t1;
53 id
54 1
55 SHOW CREATE TABLE t1;
56 Table Create Table
57 t1 CREATE TABLE `t1` (
58 `id` int NOT NULL AUTO_INCREMENT,
59 PRIMARY KEY (`id`)
60 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
61 SET DEBUG_SYNC = 'now SIGNAL flushed';
62 # SETTING auto_increment_increment in connection1
63 SET AUTO_INCREMENT_INCREMENT = 2;
64 SET DEBUG_SYNC= 'now WAIT_FOR flushed';
65 SET DEBUG_SYNC= 'ib_after_row_insert SIGNAL opened WAIT_FOR flushed1';
66 INSERT INTO t1 values(NULL);
67 # CONNECTION DEFAULT
68 SET DEBUG_SYNC= 'now WAIT_FOR opened';
69 SET DEBUG_SYNC= 'ib_after_row_insert_step SIGNAL flushed1 WAIT_FOR opened1';
70 INSERT INTO t1 VALUES(NULL);
71 # CONNECTION con1
72 SELECT * FROM t1;
73 id
74 1
75 3
76 SHOW CREATE TABLE t1;
77 Table Create Table
78 t1 CREATE TABLE `t1` (
79 `id` int NOT NULL AUTO_INCREMENT,
80 PRIMARY KEY (`id`)
81 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
82 SET DEBUG_SYNC= 'now SIGNAL opened1';
83 # CONNECTION default
84 SELECT * FROM t1;
85 id
86 1
87 3
88 5
89 SHOW CREATE TABLE t1;
90 Table Create Table
91 t1 CREATE TABLE `t1` (
92 `id` int NOT NULL AUTO_INCREMENT,
93 PRIMARY KEY (`id`)
94 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
95 DROP TABLE t1;