From: Inaam Rana Date: April 29 2010 5:43pm Subject: bzr commit into mysql-trunk-innodb branch (inaam.rana:3043) List-Archive: http://lists.mysql.com/commits/106970 Message-Id: <20100429174344.D3C04BFC37@dabba> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1466228806==" --===============1466228806== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline #At file:///home/inaam/w/plugin-1.1/ based on revid:sunny.bains@stripped 3043 Inaam Rana 2010-04-29 Add basic tests for new innodb features added: mysql-test/suite/sys_vars/r/innodb_buffer_pool_instances_basic.result mysql-test/suite/sys_vars/r/innodb_purge_batch_size_basic.result mysql-test/suite/sys_vars/r/innodb_purge_threads_basic.result mysql-test/suite/sys_vars/r/innodb_use_native_aio_basic.result mysql-test/suite/sys_vars/t/innodb_buffer_pool_instances_basic.test mysql-test/suite/sys_vars/t/innodb_purge_batch_size_basic.test mysql-test/suite/sys_vars/t/innodb_purge_threads_basic.test mysql-test/suite/sys_vars/t/innodb_use_native_aio_basic.test === added file 'mysql-test/suite/sys_vars/r/innodb_buffer_pool_instances_basic.result' --- a/mysql-test/suite/sys_vars/r/innodb_buffer_pool_instances_basic.result 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/r/innodb_buffer_pool_instances_basic.result 2010-04-29 17:43:10 +0000 @@ -0,0 +1,53 @@ +'#---------------------BS_STVARS_035_01----------------------#' +SELECT COUNT(@@GLOBAL.innodb_buffer_pool_instances); +COUNT(@@GLOBAL.innodb_buffer_pool_instances) +1 +1 Expected +'#---------------------BS_STVARS_035_02----------------------#' +SET @@GLOBAL.innodb_buffer_pool_instances=1; +ERROR HY000: Variable 'innodb_buffer_pool_instances' is a read only variable +Expected error 'Read only variable' +SELECT COUNT(@@GLOBAL.innodb_buffer_pool_instances); +COUNT(@@GLOBAL.innodb_buffer_pool_instances) +1 +1 Expected +'#---------------------BS_STVARS_035_03----------------------#' +SELECT @@GLOBAL.innodb_buffer_pool_instances = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_buffer_pool_instances'; +@@GLOBAL.innodb_buffer_pool_instances = VARIABLE_VALUE +1 +1 Expected +SELECT COUNT(@@GLOBAL.innodb_buffer_pool_instances); +COUNT(@@GLOBAL.innodb_buffer_pool_instances) +1 +1 Expected +SELECT COUNT(VARIABLE_VALUE) +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_buffer_pool_instances'; +COUNT(VARIABLE_VALUE) +1 +1 Expected +'#---------------------BS_STVARS_035_04----------------------#' +SELECT @@innodb_buffer_pool_instances = @@GLOBAL.innodb_buffer_pool_instances; +@@innodb_buffer_pool_instances = @@GLOBAL.innodb_buffer_pool_instances +1 +1 Expected +'#---------------------BS_STVARS_035_05----------------------#' +SELECT COUNT(@@innodb_buffer_pool_instances); +COUNT(@@innodb_buffer_pool_instances) +1 +1 Expected +SELECT COUNT(@@local.innodb_buffer_pool_instances); +ERROR HY000: Variable 'innodb_buffer_pool_instances' is a GLOBAL variable +Expected error 'Variable is a GLOBAL variable' +SELECT COUNT(@@SESSION.innodb_buffer_pool_instances); +ERROR HY000: Variable 'innodb_buffer_pool_instances' is a GLOBAL variable +Expected error 'Variable is a GLOBAL variable' +SELECT COUNT(@@GLOBAL.innodb_buffer_pool_instances); +COUNT(@@GLOBAL.innodb_buffer_pool_instances) +1 +1 Expected +SELECT innodb_buffer_pool_instances = @@SESSION.innodb_buffer_pool_instances; +ERROR 42S22: Unknown column 'innodb_buffer_pool_instances' in 'field list' +Expected error 'Readonly variable' === added file 'mysql-test/suite/sys_vars/r/innodb_purge_batch_size_basic.result' --- a/mysql-test/suite/sys_vars/r/innodb_purge_batch_size_basic.result 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/r/innodb_purge_batch_size_basic.result 2010-04-29 17:43:10 +0000 @@ -0,0 +1,98 @@ +SET @global_start_value = @@global.innodb_purge_batch_size; +SELECT @global_start_value; +@global_start_value +20 +'#--------------------FN_DYNVARS_046_01------------------------#' +SET @@global.innodb_purge_batch_size = 1; +SET @@global.innodb_purge_batch_size = DEFAULT; +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +20 +'#---------------------FN_DYNVARS_046_02-------------------------#' +SET innodb_purge_batch_size = 1; +ERROR HY000: Variable 'innodb_purge_batch_size' is a GLOBAL variable and should be set with SET GLOBAL +SELECT @@innodb_purge_batch_size; +@@innodb_purge_batch_size +20 +SELECT local.innodb_purge_batch_size; +ERROR 42S02: Unknown table 'local' in field list +SET global innodb_purge_batch_size = 1; +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +1 +'#--------------------FN_DYNVARS_046_03------------------------#' +SET @@global.innodb_purge_batch_size = 1; +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +1 +SET @@global.innodb_purge_batch_size = 5000; +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +5000 +SET @@global.innodb_purge_batch_size = 1000; +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +1000 +'#--------------------FN_DYNVARS_046_04-------------------------#' +SET @@global.innodb_purge_batch_size = 0; +Warnings: +Warning 1292 Truncated incorrect innodb_purge_batch_size value: '0' +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +1 +SET @@global.innodb_purge_batch_size = "T"; +ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size' +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +1 +SET @@global.innodb_purge_batch_size = "Y"; +ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size' +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +1 +SET @@global.innodb_purge_batch_size = 5001; +Warnings: +Warning 1292 Truncated incorrect innodb_purge_batch_size value: '5001' +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +5000 +'#----------------------FN_DYNVARS_046_05------------------------#' +SELECT @@global.innodb_purge_batch_size = +VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_purge_batch_size'; +@@global.innodb_purge_batch_size = +VARIABLE_VALUE +1 +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +5000 +SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_purge_batch_size'; +VARIABLE_VALUE +5000 +'#---------------------FN_DYNVARS_046_06-------------------------#' +SET @@global.innodb_purge_batch_size = OFF; +ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size' +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +5000 +SET @@global.innodb_purge_batch_size = ON; +ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size' +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +5000 +'#---------------------FN_DYNVARS_046_07----------------------#' +SET @@global.innodb_purge_batch_size = TRUE; +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +1 +SET @@global.innodb_purge_batch_size = FALSE; +Warnings: +Warning 1292 Truncated incorrect innodb_purge_batch_size value: '0' +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +1 +SET @@global.innodb_purge_batch_size = @global_start_value; +SELECT @@global.innodb_purge_batch_size; +@@global.innodb_purge_batch_size +20 === added file 'mysql-test/suite/sys_vars/r/innodb_purge_threads_basic.result' --- a/mysql-test/suite/sys_vars/r/innodb_purge_threads_basic.result 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/r/innodb_purge_threads_basic.result 2010-04-29 17:43:10 +0000 @@ -0,0 +1,53 @@ +'#---------------------BS_STVARS_035_01----------------------#' +SELECT COUNT(@@GLOBAL.innodb_purge_threads); +COUNT(@@GLOBAL.innodb_purge_threads) +1 +1 Expected +'#---------------------BS_STVARS_035_02----------------------#' +SET @@GLOBAL.innodb_purge_threads=1; +ERROR HY000: Variable 'innodb_purge_threads' is a read only variable +Expected error 'Read only variable' +SELECT COUNT(@@GLOBAL.innodb_purge_threads); +COUNT(@@GLOBAL.innodb_purge_threads) +1 +1 Expected +'#---------------------BS_STVARS_035_03----------------------#' +SELECT @@GLOBAL.innodb_purge_threads = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_purge_threads'; +@@GLOBAL.innodb_purge_threads = VARIABLE_VALUE +1 +1 Expected +SELECT COUNT(@@GLOBAL.innodb_purge_threads); +COUNT(@@GLOBAL.innodb_purge_threads) +1 +1 Expected +SELECT COUNT(VARIABLE_VALUE) +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_purge_threads'; +COUNT(VARIABLE_VALUE) +1 +1 Expected +'#---------------------BS_STVARS_035_04----------------------#' +SELECT @@innodb_purge_threads = @@GLOBAL.innodb_purge_threads; +@@innodb_purge_threads = @@GLOBAL.innodb_purge_threads +1 +1 Expected +'#---------------------BS_STVARS_035_05----------------------#' +SELECT COUNT(@@innodb_purge_threads); +COUNT(@@innodb_purge_threads) +1 +1 Expected +SELECT COUNT(@@local.innodb_purge_threads); +ERROR HY000: Variable 'innodb_purge_threads' is a GLOBAL variable +Expected error 'Variable is a GLOBAL variable' +SELECT COUNT(@@SESSION.innodb_purge_threads); +ERROR HY000: Variable 'innodb_purge_threads' is a GLOBAL variable +Expected error 'Variable is a GLOBAL variable' +SELECT COUNT(@@GLOBAL.innodb_purge_threads); +COUNT(@@GLOBAL.innodb_purge_threads) +1 +1 Expected +SELECT innodb_purge_threads = @@SESSION.innodb_purge_threads; +ERROR 42S22: Unknown column 'innodb_purge_threads' in 'field list' +Expected error 'Readonly variable' === added file 'mysql-test/suite/sys_vars/r/innodb_use_native_aio_basic.result' --- a/mysql-test/suite/sys_vars/r/innodb_use_native_aio_basic.result 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/r/innodb_use_native_aio_basic.result 2010-04-29 17:43:10 +0000 @@ -0,0 +1,53 @@ +'#---------------------BS_STVARS_035_01----------------------#' +SELECT COUNT(@@GLOBAL.innodb_use_native_aio); +COUNT(@@GLOBAL.innodb_use_native_aio) +1 +1 Expected +'#---------------------BS_STVARS_035_02----------------------#' +SET @@GLOBAL.innodb_use_native_aio=1; +ERROR HY000: Variable 'innodb_use_native_aio' is a read only variable +Expected error 'Read only variable' +SELECT COUNT(@@GLOBAL.innodb_use_native_aio); +COUNT(@@GLOBAL.innodb_use_native_aio) +1 +1 Expected +'#---------------------BS_STVARS_035_03----------------------#' +SELECT IF(@@GLOBAL.innodb_use_native_aio, 'ON', 'OFF') = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_use_native_aio'; +IF(@@GLOBAL.innodb_use_native_aio, 'ON', 'OFF') = VARIABLE_VALUE +1 +1 Expected +SELECT COUNT(@@GLOBAL.innodb_use_native_aio); +COUNT(@@GLOBAL.innodb_use_native_aio) +1 +1 Expected +SELECT COUNT(VARIABLE_VALUE) +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_use_native_aio'; +COUNT(VARIABLE_VALUE) +1 +1 Expected +'#---------------------BS_STVARS_035_04----------------------#' +SELECT @@innodb_use_native_aio = @@GLOBAL.innodb_use_native_aio; +@@innodb_use_native_aio = @@GLOBAL.innodb_use_native_aio +1 +1 Expected +'#---------------------BS_STVARS_035_05----------------------#' +SELECT COUNT(@@innodb_use_native_aio); +COUNT(@@innodb_use_native_aio) +1 +1 Expected +SELECT COUNT(@@local.innodb_use_native_aio); +ERROR HY000: Variable 'innodb_use_native_aio' is a GLOBAL variable +Expected error 'Variable is a GLOBAL variable' +SELECT COUNT(@@SESSION.innodb_use_native_aio); +ERROR HY000: Variable 'innodb_use_native_aio' is a GLOBAL variable +Expected error 'Variable is a GLOBAL variable' +SELECT COUNT(@@GLOBAL.innodb_use_native_aio); +COUNT(@@GLOBAL.innodb_use_native_aio) +1 +1 Expected +SELECT innodb_use_native_aio = @@SESSION.innodb_use_native_aio; +ERROR 42S22: Unknown column 'innodb_use_native_aio' in 'field list' +Expected error 'Readonly variable' === added file 'mysql-test/suite/sys_vars/t/innodb_buffer_pool_instances_basic.test' --- a/mysql-test/suite/sys_vars/t/innodb_buffer_pool_instances_basic.test 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/t/innodb_buffer_pool_instances_basic.test 2010-04-29 17:43:10 +0000 @@ -0,0 +1,103 @@ + + +################## mysql-test\t\innodb_buffer_pool_instances_basic.test ####### +# # +# Variable Name: innodb_buffer_pool_instances # +# Scope: Global # +# Access Type: Static # +# Data Type: numeric # +# # +# # +# Creation Date: 2008-02-07 # +# Author : Sharique Abdullah # +# # +# # +# Description:Test Cases of Dynamic System Variable # +# innodb_buffer_pool_instances # +# that checks the behavior of this variable in the following ways # +# * Value Check # +# * Scope Check # +# # +# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # +# server-system-variables.html # +# # +############################################################################### + +--source include/have_innodb.inc + +--echo '#---------------------BS_STVARS_035_01----------------------#' +#################################################################### +# Displaying default value # +#################################################################### +SELECT COUNT(@@GLOBAL.innodb_buffer_pool_instances); +--echo 1 Expected + + +--echo '#---------------------BS_STVARS_035_02----------------------#' +#################################################################### +# Check if Value can set # +#################################################################### + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET @@GLOBAL.innodb_buffer_pool_instances=1; +--echo Expected error 'Read only variable' + +SELECT COUNT(@@GLOBAL.innodb_buffer_pool_instances); +--echo 1 Expected + + + + +--echo '#---------------------BS_STVARS_035_03----------------------#' +################################################################# +# Check if the value in GLOBAL Table matches value in variable # +################################################################# + +SELECT @@GLOBAL.innodb_buffer_pool_instances = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_buffer_pool_instances'; +--echo 1 Expected + +SELECT COUNT(@@GLOBAL.innodb_buffer_pool_instances); +--echo 1 Expected + +SELECT COUNT(VARIABLE_VALUE) +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_buffer_pool_instances'; +--echo 1 Expected + + + +--echo '#---------------------BS_STVARS_035_04----------------------#' +################################################################################ +# Check if accessing variable with and without GLOBAL point to same variable # +################################################################################ +SELECT @@innodb_buffer_pool_instances = @@GLOBAL.innodb_buffer_pool_instances; +--echo 1 Expected + + + +--echo '#---------------------BS_STVARS_035_05----------------------#' +################################################################################ +# Check if innodb_buffer_pool_instances can be accessed with and without @@ sign # +################################################################################ + +SELECT COUNT(@@innodb_buffer_pool_instances); +--echo 1 Expected + +--Error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT COUNT(@@local.innodb_buffer_pool_instances); +--echo Expected error 'Variable is a GLOBAL variable' + +--Error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT COUNT(@@SESSION.innodb_buffer_pool_instances); +--echo Expected error 'Variable is a GLOBAL variable' + +SELECT COUNT(@@GLOBAL.innodb_buffer_pool_instances); +--echo 1 Expected + +--Error ER_BAD_FIELD_ERROR +SELECT innodb_buffer_pool_instances = @@SESSION.innodb_buffer_pool_instances; +--echo Expected error 'Readonly variable' + + === added file 'mysql-test/suite/sys_vars/t/innodb_purge_batch_size_basic.test' --- a/mysql-test/suite/sys_vars/t/innodb_purge_batch_size_basic.test 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/t/innodb_purge_batch_size_basic.test 2010-04-29 17:43:10 +0000 @@ -0,0 +1,142 @@ +################# mysql-test\t\innodb_purge_batch_size_basic.test ############# +# # +# Variable Name: innodb_purge_batch_size # +# Scope: GLOBAL # +# Access Type: Dynamic # +# Data Type: Numeric # +# Default Value: 20 # +# Range: 0-4294967295 # +# # +# # +# Creation Date: 2008-02-07 # +# Author: Rizwan # +# # +#Description:Test Cases of Dynamic System Variable innodb_purge_batch_size # +# that checks the behavior of this variable in the following ways # +# * Default Value # +# * Valid & Invalid values # +# * Scope & Access method # +# * Data Integrity # +# # +# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # +# server-system-variables.html # +# # +############################################################################### + +--source include/have_innodb.inc +--source include/load_sysvars.inc + +######################################################################## +# START OF innodb_purge_batch_size TESTS # +######################################################################## + + +############################################################################ +# Saving initial value of innodb_purge_batch_size in a temporary variable # +############################################################################ + +SET @global_start_value = @@global.innodb_purge_batch_size; +SELECT @global_start_value; + +--echo '#--------------------FN_DYNVARS_046_01------------------------#' +######################################################################## +# Display the DEFAULT value of innodb_purge_batch_size # +######################################################################## + +SET @@global.innodb_purge_batch_size = 1; +SET @@global.innodb_purge_batch_size = DEFAULT; +SELECT @@global.innodb_purge_batch_size; + +--echo '#---------------------FN_DYNVARS_046_02-------------------------#' +############################################################################## +# Check if innodb_purge_batch_size can be accessed with and without @@ sign # +############################################################################## + +--Error ER_GLOBAL_VARIABLE +SET innodb_purge_batch_size = 1; +SELECT @@innodb_purge_batch_size; + +--Error ER_UNKNOWN_TABLE +SELECT local.innodb_purge_batch_size; + +SET global innodb_purge_batch_size = 1; +SELECT @@global.innodb_purge_batch_size; + +--echo '#--------------------FN_DYNVARS_046_03------------------------#' +########################################################################## +# change the value of innodb_purge_batch_size to a valid value # +########################################################################## + +SET @@global.innodb_purge_batch_size = 1; +SELECT @@global.innodb_purge_batch_size; + +SET @@global.innodb_purge_batch_size = 5000; +SELECT @@global.innodb_purge_batch_size; +SET @@global.innodb_purge_batch_size = 1000; +SELECT @@global.innodb_purge_batch_size; + +--echo '#--------------------FN_DYNVARS_046_04-------------------------#' +########################################################################### +# Change the value of innodb_purge_batch_size to invalid value # +########################################################################### + +SET @@global.innodb_purge_batch_size = 0; +SELECT @@global.innodb_purge_batch_size; + +--Error ER_WRONG_TYPE_FOR_VAR +SET @@global.innodb_purge_batch_size = "T"; +SELECT @@global.innodb_purge_batch_size; + +--Error ER_WRONG_TYPE_FOR_VAR +SET @@global.innodb_purge_batch_size = "Y"; +SELECT @@global.innodb_purge_batch_size; + +SET @@global.innodb_purge_batch_size = 5001; +SELECT @@global.innodb_purge_batch_size; + +--echo '#----------------------FN_DYNVARS_046_05------------------------#' +######################################################################### +# Check if the value in GLOBAL Table matches value in variable # +######################################################################### + +SELECT @@global.innodb_purge_batch_size = + VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES + WHERE VARIABLE_NAME='innodb_purge_batch_size'; +SELECT @@global.innodb_purge_batch_size; +SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES + WHERE VARIABLE_NAME='innodb_purge_batch_size'; + +--echo '#---------------------FN_DYNVARS_046_06-------------------------#' +################################################################### +# Check if ON and OFF values can be used on variable # +################################################################### + +--ERROR ER_WRONG_TYPE_FOR_VAR +SET @@global.innodb_purge_batch_size = OFF; +SELECT @@global.innodb_purge_batch_size; + +--ERROR ER_WRONG_TYPE_FOR_VAR +SET @@global.innodb_purge_batch_size = ON; +SELECT @@global.innodb_purge_batch_size; + +--echo '#---------------------FN_DYNVARS_046_07----------------------#' +################################################################### +# Check if TRUE and FALSE values can be used on variable # +################################################################### + + +SET @@global.innodb_purge_batch_size = TRUE; +SELECT @@global.innodb_purge_batch_size; +SET @@global.innodb_purge_batch_size = FALSE; +SELECT @@global.innodb_purge_batch_size; + +############################## +# Restore initial value # +############################## + +SET @@global.innodb_purge_batch_size = @global_start_value; +SELECT @@global.innodb_purge_batch_size; + +############################################################### +# END OF innodb_purge_batch_size TESTS # +############################################################### === added file 'mysql-test/suite/sys_vars/t/innodb_purge_threads_basic.test' --- a/mysql-test/suite/sys_vars/t/innodb_purge_threads_basic.test 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/t/innodb_purge_threads_basic.test 2010-04-29 17:43:10 +0000 @@ -0,0 +1,102 @@ + + +################## mysql-test\t\innodb_log_purge_threads_basic.test ########### +# # +# Variable Name: innodb_purge_threads # +# Scope: Global # +# Access Type: Static # +# Data Type: numeric # +# # +# # +# Creation Date: 2008-02-07 # +# Author : Sharique Abdullah # +# # +# # +# Description:Test Cases of Dynamic System Variable innodb_purge_threads # +# that checks the behavior of this variable in the following ways # +# * Value Check # +# * Scope Check # +# # +# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # +# server-system-variables.html # +# # +############################################################################### + +--source include/have_innodb.inc + +--echo '#---------------------BS_STVARS_035_01----------------------#' +#################################################################### +# Displaying default value # +#################################################################### +SELECT COUNT(@@GLOBAL.innodb_purge_threads); +--echo 1 Expected + + +--echo '#---------------------BS_STVARS_035_02----------------------#' +#################################################################### +# Check if Value can set # +#################################################################### + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET @@GLOBAL.innodb_purge_threads=1; +--echo Expected error 'Read only variable' + +SELECT COUNT(@@GLOBAL.innodb_purge_threads); +--echo 1 Expected + + + + +--echo '#---------------------BS_STVARS_035_03----------------------#' +################################################################# +# Check if the value in GLOBAL Table matches value in variable # +################################################################# + +SELECT @@GLOBAL.innodb_purge_threads = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_purge_threads'; +--echo 1 Expected + +SELECT COUNT(@@GLOBAL.innodb_purge_threads); +--echo 1 Expected + +SELECT COUNT(VARIABLE_VALUE) +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_purge_threads'; +--echo 1 Expected + + + +--echo '#---------------------BS_STVARS_035_04----------------------#' +################################################################################ +# Check if accessing variable with and without GLOBAL point to same variable # +################################################################################ +SELECT @@innodb_purge_threads = @@GLOBAL.innodb_purge_threads; +--echo 1 Expected + + + +--echo '#---------------------BS_STVARS_035_05----------------------#' +################################################################################ +# Check if innodb_purge_threads can be accessed with and without @@ sign # +################################################################################ + +SELECT COUNT(@@innodb_purge_threads); +--echo 1 Expected + +--Error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT COUNT(@@local.innodb_purge_threads); +--echo Expected error 'Variable is a GLOBAL variable' + +--Error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT COUNT(@@SESSION.innodb_purge_threads); +--echo Expected error 'Variable is a GLOBAL variable' + +SELECT COUNT(@@GLOBAL.innodb_purge_threads); +--echo 1 Expected + +--Error ER_BAD_FIELD_ERROR +SELECT innodb_purge_threads = @@SESSION.innodb_purge_threads; +--echo Expected error 'Readonly variable' + + === added file 'mysql-test/suite/sys_vars/t/innodb_use_native_aio_basic.test' --- a/mysql-test/suite/sys_vars/t/innodb_use_native_aio_basic.test 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/t/innodb_use_native_aio_basic.test 2010-04-29 17:43:10 +0000 @@ -0,0 +1,102 @@ + + +################## mysql-test\t\innodb_use_native_aio_basic.test ############## +# # +# Variable Name: innodb_use_native_aio # +# Scope: Global # +# Access Type: Static # +# Data Type: numeric # +# # +# # +# Creation Date: 2008-02-07 # +# Author : Sharique Abdullah # +# # +# # +# Description:Test Cases of Dynamic System Variable innodb_use_native_aio # +# that checks the behavior of this variable in the following ways # +# * Value Check # +# * Scope Check # +# # +# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # +# server-system-variables.html # +# # +############################################################################### + +--source include/have_innodb.inc + +--echo '#---------------------BS_STVARS_035_01----------------------#' +#################################################################### +# Displaying default value # +#################################################################### +SELECT COUNT(@@GLOBAL.innodb_use_native_aio); +--echo 1 Expected + + +--echo '#---------------------BS_STVARS_035_02----------------------#' +#################################################################### +# Check if Value can set # +#################################################################### + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET @@GLOBAL.innodb_use_native_aio=1; +--echo Expected error 'Read only variable' + +SELECT COUNT(@@GLOBAL.innodb_use_native_aio); +--echo 1 Expected + + + + +--echo '#---------------------BS_STVARS_035_03----------------------#' +################################################################# +# Check if the value in GLOBAL Table matches value in variable # +################################################################# + +SELECT IF(@@GLOBAL.innodb_use_native_aio, 'ON', 'OFF') = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_use_native_aio'; +--echo 1 Expected + +SELECT COUNT(@@GLOBAL.innodb_use_native_aio); +--echo 1 Expected + +SELECT COUNT(VARIABLE_VALUE) +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_use_native_aio'; +--echo 1 Expected + + + +--echo '#---------------------BS_STVARS_035_04----------------------#' +################################################################################ +# Check if accessing variable with and without GLOBAL point to same variable # +################################################################################ +SELECT @@innodb_use_native_aio = @@GLOBAL.innodb_use_native_aio; +--echo 1 Expected + + + +--echo '#---------------------BS_STVARS_035_05----------------------#' +################################################################################ +# Check if innodb_log_file_size can be accessed with and without @@ sign # +################################################################################ + +SELECT COUNT(@@innodb_use_native_aio); +--echo 1 Expected + +--Error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT COUNT(@@local.innodb_use_native_aio); +--echo Expected error 'Variable is a GLOBAL variable' + +--Error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT COUNT(@@SESSION.innodb_use_native_aio); +--echo Expected error 'Variable is a GLOBAL variable' + +SELECT COUNT(@@GLOBAL.innodb_use_native_aio); +--echo 1 Expected + +--Error ER_BAD_FIELD_ERROR +SELECT innodb_use_native_aio = @@SESSION.innodb_use_native_aio; +--echo Expected error 'Readonly variable' + + --===============1466228806== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/inaam.rana@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: inaam.rana@stripped # target_branch: file:///home/inaam/w/plugin-1.1/ # testament_sha1: c8d960b4095c24754c7af3e4f2ed98237e94bf4b # timestamp: 2010-04-29 13:43:44 -0400 # base_revision_id: sunny.bains@stripped\ # ztbx98k0n7euxlrt # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWTINxLMAEJ1/gHz7d5Nf//// ///fpL////BgFX5eZEfG2DSc5nWsUAAAAZhtUADRpIiUUoAAWMBlQVYwGhwySGkINP1NQ002o0Bi PUxAGh6mQPRADTTQBoABwNAaDRoGTQAGgAMTQ00DTQA0aNAA0aHA0BoNGgZNAAaAAxNDTQNNADRo 0ADRoJNRTSCp6aPVPap6noZQaemppk8iAA00BoDQAAABoIlCE0Keiek00ZCemp5T0mCDJpmSPSYJ iAPU9QA00DQFSSAgBMmQEA0mk9EybTRNKfqmTPUMmTRHqPUD0j0m1P1J6nNMR3o0GMHnxJCcj1Go WBDjHbY9W44at+TB7Rx07tb3w5mjUb29oHA+IM+pkc/AcVTNCQnjKFtzeZeiff8DVcn0kiqAIRWh hRWCOViMZixNPPklilAh1OTq7+UOKdKM6NTxelgJsjAnBplIhwxVYkYNVSiU0yJENvRfGnEEoN4h oCTeCBF2+TvIeo29xqhLDnAYlIl242NUoUY4zKqZKpaohaCGDqsHEcBthdJJRGEggmiqZtqqKWjL fSzoNWlFtWlFveVW1Vq1W1VbxsxhV13eFXVS6L0Yu1xQrlG8Yawe4/zenf1O3xxRRFfemU0kDjA5 3koVTQQKc2Y7ITxDIIJEoRR3cu7qVsJoGAg886FaelxOjUpGNogeUK2JI7OFdh9fpC/0j2A/Z3de LztXcxdVR0opEIoyZhisWlKoHhbuou8TgWmOi0nApLuP8OSRqn60/kJoMhVSqPZoD+2HGTPHa/jG 3lo2CYMDp6bhc1zTHTR67/L2ixmZzXl8KqvhWmqpkme2UG2SHATZEEoko66Cbwc77hEURIwgxBYR WFztB6IFgBuCw4iWWmL/C47C1jCc/4m0Ot1hN5PNqe43aNhunnkLppRskTF+8LzDq6i77cdmxwp/ 84xre2usuNKek1tGh7Tt31KmR1hhDy3tfXU0y2/NG0tMt2tI59N5pm3/tdxk2HLMql5oUpUvLj75 gJ/pdgPfRl7/ldbkXB8Jpyi1RLStX+2Og2GG75R7ZkHQmeeDK7s287ckwEZuBgsN3undrhmPLVMT IuNEisB5555ZG3bO45zRo/OXZ+nQG3YYGo0KMFnGUUUz69S+XmZxwuhjh39ybCc4mcvYGWsOCZS4 gqqqoUG5rDRGTsc3LzcvZ05dr0a8zsgYA1GQo8eNIGeq89d3WFY0AIEz1RHHZ7iwEABEAG/1RRWn V3DstG1ulkk+JLp7SH7YD4FcBYEyOZDRx0Ag7LjzYEvCePMpZwz0t4iIsZAwaNLx4UEYFQgBAoCt AUeMOSDyNCgFIjShKThBSwLdBG8DinWVqSHXjOOxes2CKLBhOz2nz0pHKitOtVYxjGMYxjFVV86d yXM8zNFKSii6IfKVFFFFFFfMQylJJbFjSvjKKRR5rJsmRkiiiiiigIIoJmEvSzVp6AEA0CJ7z0+s 6Xdd5uI1atbOMzGMLXV0aGq3AJxTqEoAmwMg9PZv6++uZWLL8L/z7Xu8fvKPPP1MylKUpYjUPR0k mpdaJJpXkcp/XTrYRrPSaTAcXR2zuTWa9tf+A++cxNZxj7j7yXeVirWtVUsEUSrUDVUrIVVA1QUq f8GyEO4E6Yc8PaCi0PgYG82GG2w5Cv/JpK6r+PK11UVTrW2XUnO2ffb2sNpFfbePVmthrTTio/oR evihGC8lSH8haSGvXeppaWTPMeY/bfheNCkhoEWWSaZhYXtCzQy0Fy8ejEn4PM8u+5r1MUmqGvqu K0MW11nF7Oxc8X9Uwch7oTVHG0lpEoS4b9sPk/SrqYf0niRnoatEkLTq/DXlOz98u6Z26be6++3P QG9i1O2G3/PDsc71nmXM83Dwx0uRDnhryaHv5YX4Vf8TbSuVJWjVCzopk5rNj8b3R8j/8wmM9Dr2 K7FyLpeS9cPAv7byxaSR0nX3OfR65gM0nh1LsleDPGZ4LJC0rCnf0m/CRedhgxaGlxcV7vIplyVq 6Fb+JYbHJRGdN41DK7a3jgysjg0rNbtV18sEkvYOSzFq3WuaVNimnw3Ot6XqeDJZrI0P5s9d1/Vj zOm/jDE0DOzRK4w6M+LRevWLkmiSHBqsvMGBGhoekjPA5aedq3NDBm+LeuZZbEmU3rT0aW1yUmF3 FVnY1t97c7YZqcGDFk5s38+LLdrFmzS11x4u+7jzNI3up8xj6ExfLTsxa2x5tmjsZzXSVit4LLnY ufQuzORquaGbQmtcxYJJkuWcHU5KZOtiwZbDJu1GDOaqo16WS3Xw6tTWmlhrw2NDa6kbUlz5hkz1 9T3cNkcL+q5qnVuYPBmwXGIra9Te731382ghyaUvbHFis8XYyZN7C5rRes0LMnwWaVPonJ52xsc8 suVX77je34M14tjfpra7192Kqd4pvX01NDRzXHGuKbVNxiqa2m652Vqb1NGqEYtLWvvs2213zVhr U2tmlm9Eywus7+/Nqd7UzaXMjkR9U+TJJiVulTaXItI9pacKncVNXajai7dDRIphoQ6cTuUdGrOM GrHlNS1RsXqy1JallbPMO3wXYGGBkISEyd6/DRlvpwZqloYXYX0yS11wQlrWtn62uD5UyYT7UxMM QkmrHhtAs0FUnAlPAB5AWIiIiJDwADabUdnYk6+VF6LNLV7oB3g58Ogn7hGFJQRgyRBERESpIrCS KVKoUqVRUCyQgXZKkJyaYkf9A6f1wk9siR3z8RLQ/1hUHiFxBb8AC9zAbUDs6UNSUoyUhwv9CC+A Rn8kk77ofcG6GRpFFCiklUqlUCMG5QWB5oPq89BPLF2gyUeUL5HQ1Bup/pQt+MjBax/mFbqhVK5h vxREwh/CeExRE/iH/2g2zMfgpGxDSGRPBUI/EuEYxMJCYypUpKTc7HibJTCdsvTXNruUf5LHQLzJ qUpGpYk9hJL0f2hiXzB6w/2C6IdISbppuaIUHInWHuuTSmqkeFKkiOM8lIiUJP9UJNML54ypEnMM Q3BcFyGAdIYUFxj+NIH+STqSXhx3R3yJJU+yU2BVppJZcWCpIyDnCikDq0m5NUqSiNoZQuhJcGQa y+SLoYSRhEjlLJLijU1kpLBe/QcA3ToiJ2kohlR2EzJ4UySTYSOiSaJA3jAiCISJICJAimSUIiTT 2uSBZnpzcAqWBcZQuP6T/GWGUk1VCmcy4oGBZIlSG5QqvohxSTYkukTkTAtVVDLIsm56ketJoPtH /BOIgwgw5grQaFBaDQdV0C4DrhkQsR1QuDAM0kr0GF4mELFQUfORPs+Ba1qqxEn4ET/3+w+1eOBV rFi4GKXEUHvgjREEvl+HnTIcMGgC5ICNAI4r37AjkUG5cm0oUSJ4T4zFCFQ7Fn7H6lj9b9r9TxZL 37H622I/vcFkj917Yg4UJ6CpJPX79DS5Sf3P1eIm2HR5rSJNq5i5OjS8WiR/g8Z8p1jxlpJFRyaJ ZElUrIkCL5vpbRaQgxWRegBoFM7vhtC7XQzIfUG9pRLgBmyJuFpm2gSwaAdSLGBFIkVirc/CNMVx 7QayOfAIddKqJLFjbMp4nCQld8ZnaPmsWOR9fuyo8z2rqehsWalyzy8vWyf4ng0LMnodTU/O2ySA cTviKexvKq5TuNV1iB1ywagqns+E18QieE3x7h9clQbTrcm50OLO5udbB8zg0P2ux63gwZtsOkNk 7mbUydsVJZ5RifRQTaTqaDvZuDHr6SEn6e/eXHmAzoMaLAOCVuekCzdAsvYDBVXXwsam7cCwIZYX 4S4tJ5tzvXub0erQ5sGTJ3ujUjBqRbWRo3EQd7zPDvjW1Ocz/aXPXCxciTT6J9CGMXYQlKElKUpQ KLhFaqlSAwau/YvYFri5hLhcWLrix1x6bpC4x+DFmXM0un5JkhYqFR8FhPEoVwenkudzyYsKTvfI 5OE4VicIcTeWm9MKEqqVHfQvhk2DOtXzyExmEhJshcWkeqQl1iJsc59Kc6Swk09Hc9qJMUTCTqEN whxqbE7GbW+Vd2NHF866by807j0loeYvOhQ5yiUZ9MesScMjzic51l516qd1QpcdC6RO0pN6pxO2 0a1SbT4FC7rtrNUX+acTkMJJ4ZQY+g2oqqldtFkyHv9zveY8XU0NrB7Xp72lkWI8mDOLzQ0tTN5o eaiJkb4eJEv+6fuHuF0Py5Hr7bxyfk5XpOxU4O+QkqRREtt9jQ/oiIucD+bblP5aDS7Hi77p5xf+ dREnqQr41+aYHvNhaSc8UjEXHk3C5El0aKkSfUdZ3PCSeDepTG8jqe1+51wkYKutLFjVEts7PmNR HqM20PdDQbMETBgh7/4dj60UOSXAcimvqvbdfQ90LOwBkdIZs8me3r3WhVnVAotgsigY77itFrkQ wwxGQRVSAwM4FS2BFJlm1gyiVHAFFsFkUzwtESlawZRMAWWwWRZDLN1TUATrT8NHzdVsZJHM4KKi dR4SYJHxLpJ8TxOck5vPiz0yE9TUJJn9fc6nrE/NOuRsT7CLz6W45D2ikiNjSRLSbJwH0n0+8/MI /IKQmwSw0ikXGg7ispqK+R9pHl/VLpIj2+1oUdHUfTNMPqu4Rtkhx3S7xd0kwh1mAlFoix9T5z0z eYBsHL29mFfWxjx9Zr0S/6obe18XjrPnL5lWya5WoqL0+SXXXNaBWSBlCwVysQKCnmuRMqG+nRUH 3SycHLcwYoDZMQjQSKZctFahFN/YGjN/eZSS4iC6d5EGs7r0iaya6lqDndYraOcyPdMQTG56gqRI Dz0KCvOOielIuhUiR9hUMdJEHHcTgweqXuJE2HqBqjNSH2WmtKTMiZ4iiTXKDPM+4i/5BOEjOsZn JddNePvipNpvLutiejdDy8vYjPCGo9MUVJ7hCxvaz9+qesiZ8O3btVzMZIR5Nubuax7mUu3BPZ8T 2GqJERigdRE6dNVJpdoEe8G2unWDKGsjRqOXx1DKpdhJCMYkjKM/OXT5Nssnm+Av2Q1AEvXEB8Yk Y5NyLCpaHxMCloU5FY8QVKiIqJwh0yQu03cqDrAhgHCqqqqqqqqqqqqoIKieSc8oRLDd2SrVVVXU PHLoRvWb8sPCiJceV5vKMLoaoXXxKMJskl4kmaPbHnvOA0pLUSpUbAmUl41SL0xtLsjDRjKNWssV OTsLypqkumPCxlJdrOx9ZHHHS+4zNI9wapMI5YCT757JfJEmCjHcIWmeQz5+kci6DZ0H6S6Q5dZf JzInhZsm9ksecqQnsLobib5vKtTKkZ4n2rM8n5l2TQfK/K9HGSaZUSfKRK+pwwnZ0Jyw6QaXx4uo 6S9vJlSvMVBNdQdJZfAHZJi1zCsbJSpJRSJO40c5CbjGbCw0Db+XFfF8k1PixXbnZ07n6Hp4HIqS Ufoc3U757XveifOIb4O0cuyufXLqJqlvIYWuYTF98YH5RuwOg9x4xfxMNg8IST5tbYRlvpjLcLv+ LuSKcKEgZBuJZg== --===============1466228806==--