Debian Codegraph @

mysql-test/suite/innodb/t/autoinc_debug.test

raw
1 --source include/have_debug.inc
2
3 # Two parallel connection with autoinc column after restart.
4
5 CREATE TABLE t1 (id INT AUTO_INCREMENT PRIMARY KEY)ENGINE=INNODB;
6
7 --echo # SETTING auto_increment_increment IN CONNECTION DEFAULT
8 SET AUTO_INCREMENT_INCREMENT = 1;
9 INSERT INTO t1 VALUES(NULL);
10 SELECT * FROM t1;
11 SHOW CREATE TABLE t1;
12
13 --source include/restart_mysqld.inc
14
15 --echo # SETTING auto_increment_increment IN CONNECTION1
16 SET AUTO_INCREMENT_INCREMENT = 2;
17
18 SET DEBUG_SYNC= 'ib_after_row_insert SIGNAL opened WAIT_FOR flushed1';
19
20 SEND INSERT INTO t1 VALUES(NULL);
21
22 connect(con1, localhost, root,,);
23 SET AUTO_INCREMENT_INCREMENT = 2;
24 SET DEBUG_SYNC= 'now WAIT_FOR opened';
25 SET DEBUG_SYNC= 'ib_after_row_insert_step SIGNAL flushed1 WAIT_FOR opened1';
26 send insert into t1 values(NULL);
27
28 --echo # CONNECTION default
29 connection default;
30 reap;
31 SELECT * FROM t1;
32 SHOW CREATE TABLE t1;
33 SET DEBUG_SYNC= 'now SIGNAL opened1';
34
35 --echo # CONNECTION con1
36 connection con1;
37 reap;
38 SELECT * FROM t1;
39 SHOW CREATE TABLE t1;
40 connection default;
41 disconnect con1;
42
43 DROP TABLE t1;
44
45 # Two parallel connection with autoinc column without restart.
46
47 CREATE TABLE t1(id INT AUTO_INCREMENT PRIMARY KEY)ENGINE=INNODB;
48
49 --echo # SETTING auto_increment_increment IN CONNECTION DEFAULT
50 SET AUTO_INCREMENT_INCREMENT = 1;
51 INSERT INTO t1 VALUES(NULL);
52 SELECT * FROM t1;
53 SHOW CREATE TABLE t1;
54 SET DEBUG_SYNC = 'now SIGNAL flushed';
55
56 connect(con1, localhost, root,,);
57
58 --echo # SETTING auto_increment_increment in connection1
59 SET AUTO_INCREMENT_INCREMENT = 2;
60
61 SET DEBUG_SYNC= 'now WAIT_FOR flushed';
62 SET DEBUG_SYNC= 'ib_after_row_insert SIGNAL opened WAIT_FOR flushed1';
63
64 send INSERT INTO t1 values(NULL);
65
66 --echo # CONNECTION DEFAULT
67 connection default;
68
69 SET DEBUG_SYNC= 'now WAIT_FOR opened';
70 SET DEBUG_SYNC= 'ib_after_row_insert_step SIGNAL flushed1 WAIT_FOR opened1';
71
72 send INSERT INTO t1 VALUES(NULL);
73
74 --echo # CONNECTION con1
75 connection con1;
76 reap;
77 SELECT * FROM t1;
78 SHOW CREATE TABLE t1;
79 SET DEBUG_SYNC= 'now SIGNAL opened1';
80
81 --echo # CONNECTION default
82 connection default;
83 reap;
84 SELECT * FROM t1;
85 SHOW CREATE TABLE t1;
86 disconnect con1;
87 DROP TABLE t1;