1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_autoinc_lock_mode_func.result b/mysql-test/suite/sys_vars/r/innodb_autoinc_lock_mode_func.result
new file mode 100644
index 00000000000..f8082cfaedb
--- /dev/null
+++ b/mysql-test/suite/sys_vars/r/innodb_autoinc_lock_mode_func.result
@@ -0,0 +1,23 @@
+'#--------------------FN_DYNVARS_039_01-------------------------#'
+SET global innodb_autoinc_lock_mode = 1;
+ERROR HY000: Variable 'innodb_autoinc_lock_mode' is a read only variable
+'--innodb_autoinc_lock_mode is 1 (consecutive)--'
+SELECT @@global.innodb_autoinc_lock_mode;
+@@global.innodb_autoinc_lock_mode
+1
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1(
+a INT AUTO_INCREMENT PRIMARY KEY,
+b CHAR
+) ENGINE=INNODB, AUTO_INCREMENT=100;
+INSERT INTO t1 (a,b) VALUES (5,'a'), (NULL,'b'), (1,'c'), (NULL,'d');
+INSERT INTO t1 (a,b) VALUES (NULL,'e');
+'the new auto incremented value should be 104'
+SELECT * FROM t1;
+a	b
+1	c
+5	a
+100	b
+101	d
+104	e
+DROP TABLE t1;