Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_autoinc_lock_mode_func.result

raw
1 '#--------------------FN_DYNVARS_039_01-------------------------#'
2 SET global innodb_autoinc_lock_mode = 1;
3 ERROR HY000: Variable 'innodb_autoinc_lock_mode' is a read only variable
4 '--innodb_autoinc_lock_mode is 1 (consecutive)--'
5 SELECT @@global.innodb_autoinc_lock_mode;
6 @@global.innodb_autoinc_lock_mode
7 1
8 DROP TABLE IF EXISTS t1;
9 CREATE TABLE t1(
10 a INT AUTO_INCREMENT PRIMARY KEY,
11 b CHAR
12 ) ENGINE=INNODB, AUTO_INCREMENT=100;
13 INSERT INTO t1 (a,b) VALUES (5,'a'), (NULL,'b'), (1,'c'), (NULL,'d');
14 INSERT INTO t1 (a,b) VALUES (NULL,'e');
15 'the new auto incremented value should be 104'
16 SELECT * FROM t1;
17 a b
18 1 c
19 5 a
20 100 b
21 101 d
22 104 e
23 DROP TABLE t1;