| 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; |