diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/innodb_compression_failure_threshold_pct_basic.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/innodb_compression_failure_threshold_pct_basic.test | 143 |
1 files changed, 143 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/t/innodb_compression_failure_threshold_pct_basic.test b/mysql-test/suite/sys_vars/t/innodb_compression_failure_threshold_pct_basic.test new file mode 100644 index 00000000000..1cdfaa6b31d --- /dev/null +++ b/mysql-test/suite/sys_vars/t/innodb_compression_failure_threshold_pct_basic.test @@ -0,0 +1,143 @@ +##### mysql-test\t\innodb_compression_failure_threshold_pct_basic.test ######## +# # +# Variable Name: innodb_compression_failure_threshold_pct # +# Scope: GLOBAL # +# Access Type: Dynamic # +# Data Type: Numeric # +# Default Value: 5 # +# Range: 0-100 # +# # +# # +# Creation Date: 2008-02-07 # +# Author: Rizwan # +# # +#Description: Test Cases of Dynamic System Variable # +# innodb_compression_failure_threshold_pct # +# 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_compression_failure_threshold_pct TESTS # +###################################################################### + + +############################################################################################ +# Saving initial value of innodb_compression_failure_threshold_pct in a temporary variable # +############################################################################################ + +SET @global_start_value = @@global.innodb_compression_failure_threshold_pct; +SELECT @global_start_value; + +--echo '#--------------------FN_DYNVARS_046_01------------------------#' +######################################################################## +# Display the DEFAULT value of innodb_compression_failure_threshold_pct# +######################################################################## + +SET @@global.innodb_compression_failure_threshold_pct = 0; +SET @@global.innodb_compression_failure_threshold_pct = DEFAULT; +SELECT @@global.innodb_compression_failure_threshold_pct; + +--echo '#---------------------FN_DYNVARS_046_02-------------------------#' +############################################################################################## +# check if innodb_compression_failure_threshold_pct can be accessed with and without @@ sign # +############################################################################################## + +--Error ER_GLOBAL_VARIABLE +SET innodb_compression_failure_threshold_pct = 1; +SELECT @@innodb_compression_failure_threshold_pct; + +--Error ER_UNKNOWN_TABLE +SELECT local.innodb_compression_failure_threshold_pct; + +SET global innodb_compression_failure_threshold_pct = 0; +SELECT @@global.innodb_compression_failure_threshold_pct; + +--echo '#--------------------FN_DYNVARS_046_03------------------------#' +################################################################################# +# change the value of innodb_compression_failure_threshold_pct to a valid value # +################################################################################# + +SET @@global.innodb_compression_failure_threshold_pct = 0; +SELECT @@global.innodb_compression_failure_threshold_pct; + +SET @@global.innodb_compression_failure_threshold_pct = 1; +SELECT @@global.innodb_compression_failure_threshold_pct; +SET @@global.innodb_compression_failure_threshold_pct = 100; +SELECT @@global.innodb_compression_failure_threshold_pct; + +--echo '#--------------------FN_DYNVARS_046_04-------------------------#' +################################################################################ +# Cange the value of innodb_compression_failure_threshold_pct to invalid value # +################################################################################ + +SET @@global.innodb_compression_failure_threshold_pct = -1; +SELECT @@global.innodb_compression_failure_threshold_pct; + +--Error ER_WRONG_TYPE_FOR_VAR +SET @@global.innodb_compression_failure_threshold_pct = "T"; +SELECT @@global.innodb_compression_failure_threshold_pct; + +--Error ER_WRONG_TYPE_FOR_VAR +SET @@global.innodb_compression_failure_threshold_pct = "Y"; +SELECT @@global.innodb_compression_failure_threshold_pct; + +SET @@global.innodb_compression_failure_threshold_pct = 101; +SELECT @@global.innodb_compression_failure_threshold_pct; + + +--echo '#----------------------FN_DYNVARS_046_05------------------------#' +######################################################################### +# Check if the value in GLOBAL Table matches value in variable # +######################################################################### + +SELECT @@global.innodb_compression_failure_threshold_pct = + VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES + WHERE VARIABLE_NAME='innodb_compression_failure_threshold_pct'; +SELECT @@global.innodb_compression_failure_threshold_pct; +SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES + WHERE VARIABLE_NAME='innodb_compression_failure_threshold_pct'; + +--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_compression_failure_threshold_pct = OFF; +SELECT @@global.innodb_compression_failure_threshold_pct; + +--ERROR ER_WRONG_TYPE_FOR_VAR +SET @@global.innodb_compression_failure_threshold_pct = ON; +SELECT @@global.innodb_compression_failure_threshold_pct; + +--echo '#---------------------FN_DYNVARS_046_07----------------------#' +################################################################### +# Check if TRUE and FALSE values can be used on variable # +################################################################### + +SET @@global.innodb_compression_failure_threshold_pct = TRUE; +SELECT @@global.innodb_compression_failure_threshold_pct; +SET @@global.innodb_compression_failure_threshold_pct = FALSE; +SELECT @@global.innodb_compression_failure_threshold_pct; + +############################## +# Restore initial value # +############################## + +SET @@global.innodb_compression_failure_threshold_pct = @global_start_value; +SELECT @@global.innodb_compression_failure_threshold_pct; + +############################################################### +# END OF innodb_compression_failure_threshold_pct TESTS # +############################################################### |