diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/innodb_autoinc_lock_mode_func.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/innodb_autoinc_lock_mode_func.test | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/t/innodb_autoinc_lock_mode_func.test b/mysql-test/suite/sys_vars/t/innodb_autoinc_lock_mode_func.test new file mode 100644 index 00000000000..89c1c80a6dc --- /dev/null +++ b/mysql-test/suite/sys_vars/t/innodb_autoinc_lock_mode_func.test @@ -0,0 +1,59 @@ +################# mysql-test\t\innodb_autoinc_lock_mode_func.test ############ +# # +# Variable Name: innodb_autoinc_lock_mode # +# Scope: GLOBAL # +# Access Type: Readonly # +# Data Type: Numeric # +# Default Value: 1 # +# Range: 0,1,2 # +# # +# # +# Creation Date: 2008-03-08 # +# Author: Rizwan Maredia # +# # +# Description: # +# Test Cases of Dynamic System Variable innodb_autoextend_increment that # +# checks the behavior of this variable # +# # +# Reference: # +# http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html # +# # +############################################################################### + +--echo '#--------------------FN_DYNVARS_039_01-------------------------#' +################################################################ +# Begin the functionality Testing of innodb_autoinc_lock_mode # +################################################################ +--source include/have_innodb.inc + +--Error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET global innodb_autoinc_lock_mode = 1; + +#======================================================== +--echo '--innodb_autoinc_lock_mode is 1 (consecutive)--' +#======================================================== + + +# innodb_autoinc_lock_mode is 1 in opt file +SELECT @@global.innodb_autoinc_lock_mode; + +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings + +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'); +--echo 'the new auto incremented value should be 104' +SELECT * FROM t1; + +DROP TABLE t1; + +############################################################### +# End of functionality Testing for innodb_autoinc_lock_mode # +############################################################### + |