diff options
Diffstat (limited to 'mysql-test/suite')
11 files changed, 166 insertions, 76 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_autoextend_increment_basic.result b/mysql-test/suite/sys_vars/r/innodb_autoextend_increment_basic.result index 69a8b6cc430..ea87526c42a 100644 --- a/mysql-test/suite/sys_vars/r/innodb_autoextend_increment_basic.result +++ b/mysql-test/suite/sys_vars/r/innodb_autoextend_increment_basic.result @@ -6,13 +6,13 @@ Warning 1292 Truncated incorrect autoextend_increment value: '0' SET @@global.innodb_autoextend_increment = DEFAULT; SELECT @@global.innodb_autoextend_increment ; @@global.innodb_autoextend_increment -8 +64 '#---------------------FN_DYNVARS_046_02-------------------------#' SET innodb_autoextend_increment = 1; ERROR HY000: Variable 'innodb_autoextend_increment' is a GLOBAL variable and should be set with SET GLOBAL SELECT @@innodb_autoextend_increment ; @@innodb_autoextend_increment -8 +64 SELECT local.innodb_autoextend_increment ; ERROR 42S02: Unknown table 'local' in field list SET global innodb_autoextend_increment = 0; diff --git a/mysql-test/suite/sys_vars/r/innodb_file_io_threads_basic.result b/mysql-test/suite/sys_vars/r/innodb_file_io_threads_basic.result index 4c1c3ae8d54..5ef7e1099e0 100644 --- a/mysql-test/suite/sys_vars/r/innodb_file_io_threads_basic.result +++ b/mysql-test/suite/sys_vars/r/innodb_file_io_threads_basic.result @@ -1,53 +1,101 @@ '#---------------------BS_STVARS_027_01----------------------#' -SELECT COUNT(@@GLOBAL.innodb_file_io_threads); -COUNT(@@GLOBAL.innodb_file_io_threads) +SELECT COUNT(@@GLOBAL.innodb_read_io_threads); +COUNT(@@GLOBAL.innodb_read_io_threads) +1 +1 Expected +SELECT COUNT(@@GLOBAL.innodb_write_io_threads); +COUNT(@@GLOBAL.innodb_write_io_threads) 1 1 Expected '#---------------------BS_STVARS_027_02----------------------#' -SET @@GLOBAL.innodb_file_io_threads=1; -ERROR HY000: Variable 'innodb_file_io_threads' is a read only variable +SET @@GLOBAL.innodb_read_io_threads=1; +ERROR HY000: Variable 'innodb_read_io_threads' is a read only variable +Expected error 'Read only variable' +SELECT COUNT(@@GLOBAL.innodb_read_io_threads); +COUNT(@@GLOBAL.innodb_read_io_threads) +1 +1 Expected +SET @@GLOBAL.innodb_write_io_threads=1; +ERROR HY000: Variable 'innodb_write_io_threads' is a read only variable Expected error 'Read only variable' -SELECT COUNT(@@GLOBAL.innodb_file_io_threads); -COUNT(@@GLOBAL.innodb_file_io_threads) +SELECT COUNT(@@GLOBAL.innodb_write_io_threads); +COUNT(@@GLOBAL.innodb_write_io_threads) 1 1 Expected '#---------------------BS_STVARS_027_03----------------------#' -SELECT @@GLOBAL.innodb_file_io_threads = VARIABLE_VALUE +SELECT @@GLOBAL.innodb_read_io_threads = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_read_io_threads'; +@@GLOBAL.innodb_read_io_threads = VARIABLE_VALUE +1 +1 Expected +SELECT COUNT(@@GLOBAL.innodb_read_io_threads); +COUNT(@@GLOBAL.innodb_read_io_threads) +1 +1 Expected +SELECT COUNT(VARIABLE_VALUE) +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_read_io_threads'; +COUNT(VARIABLE_VALUE) +1 +1 Expected +SELECT @@GLOBAL.innodb_write_io_threads = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES -WHERE VARIABLE_NAME='innodb_file_io_threads'; -@@GLOBAL.innodb_file_io_threads = VARIABLE_VALUE +WHERE VARIABLE_NAME='innodb_write_io_threads'; +@@GLOBAL.innodb_write_io_threads = VARIABLE_VALUE 1 1 Expected -SELECT COUNT(@@GLOBAL.innodb_file_io_threads); -COUNT(@@GLOBAL.innodb_file_io_threads) +SELECT COUNT(@@GLOBAL.innodb_write_io_threads); +COUNT(@@GLOBAL.innodb_write_io_threads) 1 1 Expected SELECT COUNT(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES -WHERE VARIABLE_NAME='innodb_file_io_threads'; +WHERE VARIABLE_NAME='innodb_write_io_threads'; COUNT(VARIABLE_VALUE) 1 1 Expected '#---------------------BS_STVARS_027_04----------------------#' -SELECT @@innodb_file_io_threads = @@GLOBAL.innodb_file_io_threads; -@@innodb_file_io_threads = @@GLOBAL.innodb_file_io_threads +SELECT @@innodb_read_io_threads = @@GLOBAL.innodb_read_io_threads; +@@innodb_read_io_threads = @@GLOBAL.innodb_read_io_threads +1 +1 Expected +SELECT @@innodb_write_io_threads = @@GLOBAL.innodb_write_io_threads; +@@innodb_write_io_threads = @@GLOBAL.innodb_write_io_threads 1 1 Expected '#---------------------BS_STVARS_027_05----------------------#' -SELECT COUNT(@@innodb_file_io_threads); -COUNT(@@innodb_file_io_threads) +SELECT COUNT(@@innodb_read_io_threads); +COUNT(@@innodb_read_io_threads) +1 +1 Expected +SELECT COUNT(@@local.innodb_read_io_threads); +ERROR HY000: Variable 'innodb_read_io_threads' is a GLOBAL variable +Expected error 'Variable is a GLOBAL variable' +SELECT COUNT(@@SESSION.innodb_read_io_threads); +ERROR HY000: Variable 'innodb_read_io_threads' is a GLOBAL variable +Expected error 'Variable is a GLOBAL variable' +SELECT COUNT(@@GLOBAL.innodb_read_io_threads); +COUNT(@@GLOBAL.innodb_read_io_threads) +1 +1 Expected +SELECT innodb_read_io_threads = @@SESSION.innodb_read_io_threads; +ERROR 42S22: Unknown column 'innodb_read_io_threads' in 'field list' +Expected error 'Readonly variable' +SELECT COUNT(@@innodb_write_io_threads); +COUNT(@@innodb_write_io_threads) 1 1 Expected -SELECT COUNT(@@local.innodb_file_io_threads); -ERROR HY000: Variable 'innodb_file_io_threads' is a GLOBAL variable +SELECT COUNT(@@local.innodb_write_io_threads); +ERROR HY000: Variable 'innodb_write_io_threads' is a GLOBAL variable Expected error 'Variable is a GLOBAL variable' -SELECT COUNT(@@SESSION.innodb_file_io_threads); -ERROR HY000: Variable 'innodb_file_io_threads' is a GLOBAL variable +SELECT COUNT(@@SESSION.innodb_write_io_threads); +ERROR HY000: Variable 'innodb_write_io_threads' is a GLOBAL variable Expected error 'Variable is a GLOBAL variable' -SELECT COUNT(@@GLOBAL.innodb_file_io_threads); -COUNT(@@GLOBAL.innodb_file_io_threads) +SELECT COUNT(@@GLOBAL.innodb_write_io_threads); +COUNT(@@GLOBAL.innodb_write_io_threads) 1 1 Expected -SELECT innodb_file_io_threads = @@SESSION.innodb_file_io_threads; -ERROR 42S22: Unknown column 'innodb_file_io_threads' in 'field list' +SELECT innodb_write_io_threads = @@SESSION.innodb_write_io_threads; +ERROR 42S22: Unknown column 'innodb_write_io_threads' in 'field list' Expected error 'Readonly variable' diff --git a/mysql-test/suite/sys_vars/r/innodb_max_dirty_pages_pct_basic.result b/mysql-test/suite/sys_vars/r/innodb_max_dirty_pages_pct_basic.result index 6c52f79f9ad..8e48957258f 100644 --- a/mysql-test/suite/sys_vars/r/innodb_max_dirty_pages_pct_basic.result +++ b/mysql-test/suite/sys_vars/r/innodb_max_dirty_pages_pct_basic.result @@ -1,19 +1,19 @@ SET @global_start_value = @@global.innodb_max_dirty_pages_pct; SELECT @global_start_value; @global_start_value -90 +75 '#--------------------FN_DYNVARS_046_01------------------------#' SET @@global.innodb_max_dirty_pages_pct = 0; SET @@global.innodb_max_dirty_pages_pct = DEFAULT; SELECT @@global.innodb_max_dirty_pages_pct; @@global.innodb_max_dirty_pages_pct -90 +75 '#---------------------FN_DYNVARS_046_02-------------------------#' SET innodb_max_dirty_pages_pct = 1; ERROR HY000: Variable 'innodb_max_dirty_pages_pct' is a GLOBAL variable and should be set with SET GLOBAL SELECT @@innodb_max_dirty_pages_pct; @@innodb_max_dirty_pages_pct -90 +75 SELECT local.innodb_max_dirty_pages_pct; ERROR 42S02: Unknown table 'local' in field list SET global innodb_max_dirty_pages_pct = 0; @@ -29,33 +29,33 @@ SET @@global.innodb_max_dirty_pages_pct = 1; SELECT @@global.innodb_max_dirty_pages_pct; @@global.innodb_max_dirty_pages_pct 1 -SET @@global.innodb_max_dirty_pages_pct = 100; +SET @@global.innodb_max_dirty_pages_pct = 99; SELECT @@global.innodb_max_dirty_pages_pct; @@global.innodb_max_dirty_pages_pct -100 +99 '#--------------------FN_DYNVARS_046_04-------------------------#' SET @@global.innodb_max_dirty_pages_pct = -1; Warnings: Warning 1292 Truncated incorrect max_dirty_pages_pct value: '18446744073709551615' SELECT @@global.innodb_max_dirty_pages_pct; @@global.innodb_max_dirty_pages_pct -100 +99 SET @@global.innodb_max_dirty_pages_pct = "T"; ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' SELECT @@global.innodb_max_dirty_pages_pct; @@global.innodb_max_dirty_pages_pct -100 +99 SET @@global.innodb_max_dirty_pages_pct = "Y"; ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' SELECT @@global.innodb_max_dirty_pages_pct; @@global.innodb_max_dirty_pages_pct -100 +99 SET @@global.innodb_max_dirty_pages_pct = 1001; Warnings: Warning 1292 Truncated incorrect max_dirty_pages_pct value: '1001' SELECT @@global.innodb_max_dirty_pages_pct; @@global.innodb_max_dirty_pages_pct -100 +99 '#----------------------FN_DYNVARS_046_05------------------------#' SELECT @@global.innodb_max_dirty_pages_pct = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES @@ -65,22 +65,22 @@ VARIABLE_VALUE 1 SELECT @@global.innodb_max_dirty_pages_pct; @@global.innodb_max_dirty_pages_pct -100 +99 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_max_dirty_pages_pct'; VARIABLE_VALUE -100 +99 '#---------------------FN_DYNVARS_046_06-------------------------#' SET @@global.innodb_max_dirty_pages_pct = OFF; ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' SELECT @@global.innodb_max_dirty_pages_pct; @@global.innodb_max_dirty_pages_pct -100 +99 SET @@global.innodb_max_dirty_pages_pct = ON; ERROR 42000: Incorrect argument type to variable 'innodb_max_dirty_pages_pct' SELECT @@global.innodb_max_dirty_pages_pct; @@global.innodb_max_dirty_pages_pct -100 +99 '#---------------------FN_DYNVARS_046_07----------------------#' SET @@global.innodb_max_dirty_pages_pct = TRUE; SELECT @@global.innodb_max_dirty_pages_pct; @@ -93,4 +93,4 @@ SELECT @@global.innodb_max_dirty_pages_pct; SET @@global.innodb_max_dirty_pages_pct = @global_start_value; SELECT @@global.innodb_max_dirty_pages_pct; @@global.innodb_max_dirty_pages_pct -90 +75 diff --git a/mysql-test/suite/sys_vars/r/innodb_thread_concurrency_basic.result b/mysql-test/suite/sys_vars/r/innodb_thread_concurrency_basic.result index 65a79fecd97..b27bbce5b3c 100644 --- a/mysql-test/suite/sys_vars/r/innodb_thread_concurrency_basic.result +++ b/mysql-test/suite/sys_vars/r/innodb_thread_concurrency_basic.result @@ -1,19 +1,19 @@ SET @global_start_value = @@global.innodb_thread_concurrency; SELECT @global_start_value; @global_start_value -8 +0 '#--------------------FN_DYNVARS_046_01------------------------#' SET @@global.innodb_thread_concurrency = 0; SET @@global.innodb_thread_concurrency = DEFAULT; SELECT @@global.innodb_thread_concurrency; @@global.innodb_thread_concurrency -8 +0 '#---------------------FN_DYNVARS_046_02-------------------------#' SET innodb_thread_concurrency = 1; ERROR HY000: Variable 'innodb_thread_concurrency' is a GLOBAL variable and should be set with SET GLOBAL SELECT @@innodb_thread_concurrency; @@innodb_thread_concurrency -8 +0 SELECT local.innodb_thread_concurrency; ERROR 42S02: Unknown table 'local' in field list SET global innodb_thread_concurrency = 0; @@ -93,4 +93,4 @@ SELECT @@global.innodb_thread_concurrency; SET @@global.innodb_thread_concurrency = @global_start_value; SELECT @@global.innodb_thread_concurrency; @@global.innodb_thread_concurrency -8 +0 diff --git a/mysql-test/suite/sys_vars/r/table_definition_cache_basic.result b/mysql-test/suite/sys_vars/r/table_definition_cache_basic.result index 612d4138003..611fda6f84a 100644 --- a/mysql-test/suite/sys_vars/r/table_definition_cache_basic.result +++ b/mysql-test/suite/sys_vars/r/table_definition_cache_basic.result @@ -1,7 +1,7 @@ SET @start_value = @@global.table_definition_cache; SELECT @start_value; @start_value -256 +400 '#--------------------FN_DYNVARS_019_01------------------------#' SET @@global.table_definition_cache = 100; Warnings: @@ -9,12 +9,12 @@ Warning 1292 Truncated incorrect table_definition_cache value: '100' SET @@global.table_definition_cache = DEFAULT; SELECT @@global.table_definition_cache; @@global.table_definition_cache -256 +400 '#---------------------FN_DYNVARS_019_02-------------------------#' SET @@global.table_definition_cache = DEFAULT; -SELECT @@global.table_definition_cache = 128; -@@global.table_definition_cache = 128 -0 +SELECT @@global.table_definition_cache = 400; +@@global.table_definition_cache = 400 +1 '#--------------------FN_DYNVARS_019_03------------------------#' SET @@global.table_definition_cache = 1; Warnings: @@ -109,4 +109,4 @@ ERROR 42S22: Unknown column 'table_definition_cache' in 'field list' SET @@global.table_definition_cache = @start_value; SELECT @@global.table_definition_cache; @@global.table_definition_cache -256 +400 diff --git a/mysql-test/suite/sys_vars/r/table_open_cache_basic.result b/mysql-test/suite/sys_vars/r/table_open_cache_basic.result index 080bcb6537e..da9b8c0d1aa 100644 --- a/mysql-test/suite/sys_vars/r/table_open_cache_basic.result +++ b/mysql-test/suite/sys_vars/r/table_open_cache_basic.result @@ -1,17 +1,17 @@ SET @start_value = @@global.table_open_cache ; SELECT @start_value; @start_value -64 +400 '#--------------------FN_DYNVARS_001_01------------------------#' SET @@global.table_open_cache = 99; SET @@global.table_open_cache = DeFAULT; SELECT @@global.table_open_cache; @@global.table_open_cache -64 +400 '#---------------------FN_DYNVARS_001_02-------------------------#' SET @@global.table_open_cache = Default; -SELECT @@global.table_open_cache = 64; -@@global.table_open_cache = 64 +SELECT @@global.table_open_cache = 400; +@@global.table_open_cache = 400 1 '#--------------------FN_DYNVARS_001_03------------------------#' SET @@global.table_open_cache = 8; @@ -105,4 +105,4 @@ ERROR 42S22: Unknown column 'table_open_cache' in 'field list' SET @@global.table_open_cache = @start_value; SELECT @@global.table_open_cache ; @@global.table_open_cache -64 +400 diff --git a/mysql-test/suite/sys_vars/t/innodb_file_io_threads_basic.test b/mysql-test/suite/sys_vars/t/innodb_file_io_threads_basic.test index 8e09c75ded6..32cdd0beac4 100644 --- a/mysql-test/suite/sys_vars/t/innodb_file_io_threads_basic.test +++ b/mysql-test/suite/sys_vars/t/innodb_file_io_threads_basic.test @@ -28,7 +28,9 @@ #################################################################### # Displaying default value # #################################################################### -SELECT COUNT(@@GLOBAL.innodb_file_io_threads); +SELECT COUNT(@@GLOBAL.innodb_read_io_threads); +--echo 1 Expected +SELECT COUNT(@@GLOBAL.innodb_write_io_threads); --echo 1 Expected @@ -38,10 +40,17 @@ SELECT COUNT(@@GLOBAL.innodb_file_io_threads); #################################################################### --error ER_INCORRECT_GLOBAL_LOCAL_VAR -SET @@GLOBAL.innodb_file_io_threads=1; +SET @@GLOBAL.innodb_read_io_threads=1; --echo Expected error 'Read only variable' -SELECT COUNT(@@GLOBAL.innodb_file_io_threads); +SELECT COUNT(@@GLOBAL.innodb_read_io_threads); +--echo 1 Expected + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET @@GLOBAL.innodb_write_io_threads=1; +--echo Expected error 'Read only variable' + +SELECT COUNT(@@GLOBAL.innodb_write_io_threads); --echo 1 Expected @@ -52,51 +61,84 @@ SELECT COUNT(@@GLOBAL.innodb_file_io_threads); # Check if the value in GLOBAL Table matches value in variable # ################################################################# -SELECT @@GLOBAL.innodb_file_io_threads = VARIABLE_VALUE +SELECT @@GLOBAL.innodb_read_io_threads = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES -WHERE VARIABLE_NAME='innodb_file_io_threads'; +WHERE VARIABLE_NAME='innodb_read_io_threads'; --echo 1 Expected -SELECT COUNT(@@GLOBAL.innodb_file_io_threads); +SELECT COUNT(@@GLOBAL.innodb_read_io_threads); --echo 1 Expected SELECT COUNT(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES -WHERE VARIABLE_NAME='innodb_file_io_threads'; +WHERE VARIABLE_NAME='innodb_read_io_threads'; +--echo 1 Expected + +SELECT @@GLOBAL.innodb_write_io_threads = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_write_io_threads'; +--echo 1 Expected + +SELECT COUNT(@@GLOBAL.innodb_write_io_threads); --echo 1 Expected +SELECT COUNT(VARIABLE_VALUE) +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_write_io_threads'; +--echo 1 Expected --echo '#---------------------BS_STVARS_027_04----------------------#' ################################################################################ # Check if accessing variable with and without GLOBAL point to same variable # ################################################################################ -SELECT @@innodb_file_io_threads = @@GLOBAL.innodb_file_io_threads; +SELECT @@innodb_read_io_threads = @@GLOBAL.innodb_read_io_threads; --echo 1 Expected +SELECT @@innodb_write_io_threads = @@GLOBAL.innodb_write_io_threads; +--echo 1 Expected --echo '#---------------------BS_STVARS_027_05----------------------#' ################################################################################ -# Check if innodb_file_io_threads can be accessed with and without @@ sign # +# Check if innodb_read_io_threads can be accessed with and without @@ sign # +# Check if innodb_write_io_threads can be accessed with and without @@ sign # ################################################################################ -SELECT COUNT(@@innodb_file_io_threads); +SELECT COUNT(@@innodb_read_io_threads); +--echo 1 Expected + +--Error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT COUNT(@@local.innodb_read_io_threads); +--echo Expected error 'Variable is a GLOBAL variable' + +--Error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT COUNT(@@SESSION.innodb_read_io_threads); +--echo Expected error 'Variable is a GLOBAL variable' + +SELECT COUNT(@@GLOBAL.innodb_read_io_threads); +--echo 1 Expected + +--Error ER_BAD_FIELD_ERROR +SELECT innodb_read_io_threads = @@SESSION.innodb_read_io_threads; +--echo Expected error 'Readonly variable' + +SELECT COUNT(@@innodb_write_io_threads); --echo 1 Expected --Error ER_INCORRECT_GLOBAL_LOCAL_VAR -SELECT COUNT(@@local.innodb_file_io_threads); +SELECT COUNT(@@local.innodb_write_io_threads); --echo Expected error 'Variable is a GLOBAL variable' --Error ER_INCORRECT_GLOBAL_LOCAL_VAR -SELECT COUNT(@@SESSION.innodb_file_io_threads); +SELECT COUNT(@@SESSION.innodb_write_io_threads); --echo Expected error 'Variable is a GLOBAL variable' -SELECT COUNT(@@GLOBAL.innodb_file_io_threads); +SELECT COUNT(@@GLOBAL.innodb_write_io_threads); --echo 1 Expected --Error ER_BAD_FIELD_ERROR -SELECT innodb_file_io_threads = @@SESSION.innodb_file_io_threads; +SELECT innodb_write_io_threads = @@SESSION.innodb_write_io_threads; --echo Expected error 'Readonly variable' diff --git a/mysql-test/suite/sys_vars/t/innodb_max_dirty_pages_pct_basic.test b/mysql-test/suite/sys_vars/t/innodb_max_dirty_pages_pct_basic.test index 830617866ca..38c3acd92a2 100644 --- a/mysql-test/suite/sys_vars/t/innodb_max_dirty_pages_pct_basic.test +++ b/mysql-test/suite/sys_vars/t/innodb_max_dirty_pages_pct_basic.test @@ -72,7 +72,7 @@ SELECT @@global.innodb_max_dirty_pages_pct; SET @@global.innodb_max_dirty_pages_pct = 1; SELECT @@global.innodb_max_dirty_pages_pct; -SET @@global.innodb_max_dirty_pages_pct = 100; +SET @@global.innodb_max_dirty_pages_pct = 99; SELECT @@global.innodb_max_dirty_pages_pct; --echo '#--------------------FN_DYNVARS_046_04-------------------------#' diff --git a/mysql-test/suite/sys_vars/t/innodb_thread_concurrency_basic.test b/mysql-test/suite/sys_vars/t/innodb_thread_concurrency_basic.test index 40ce09ce4db..d30ec214f4a 100644 --- a/mysql-test/suite/sys_vars/t/innodb_thread_concurrency_basic.test +++ b/mysql-test/suite/sys_vars/t/innodb_thread_concurrency_basic.test @@ -4,7 +4,7 @@ # Scope: GLOBAL # # Access Type: Dynamic # # Data Type: Numeric # -# Default Value: 8 # +# Default Value: 0 # # Range: 0-1000 # # # # # diff --git a/mysql-test/suite/sys_vars/t/table_definition_cache_basic.test b/mysql-test/suite/sys_vars/t/table_definition_cache_basic.test index 63296590511..741079091bc 100644 --- a/mysql-test/suite/sys_vars/t/table_definition_cache_basic.test +++ b/mysql-test/suite/sys_vars/t/table_definition_cache_basic.test @@ -4,7 +4,7 @@ # Scope: GLOBAL # # Access Type: Dynamic # # Data Type: Numeric # -# Default Value: 128 # +# Default Value: 400 # # Range: 1 - 524288 # # # # # @@ -52,7 +52,7 @@ SELECT @@global.table_definition_cache; ############################################### SET @@global.table_definition_cache = DEFAULT; -SELECT @@global.table_definition_cache = 128; +SELECT @@global.table_definition_cache = 400; --echo '#--------------------FN_DYNVARS_019_03------------------------#' diff --git a/mysql-test/suite/sys_vars/t/table_open_cache_basic.test b/mysql-test/suite/sys_vars/t/table_open_cache_basic.test index 23f60bde00a..c32463ca030 100644 --- a/mysql-test/suite/sys_vars/t/table_open_cache_basic.test +++ b/mysql-test/suite/sys_vars/t/table_open_cache_basic.test @@ -4,8 +4,8 @@ # Scope: GLOBAL # # Access Type: Dynamic # # Data Type: numeric # -# Default Value: 64 # -# Range: 1-524288 # +# Default Value: 400 # +# Range: 64-524288 # # # # # # Creation Date: 2008-02-13 # @@ -54,7 +54,7 @@ SELECT @@global.table_open_cache; ############################################### SET @@global.table_open_cache = Default; -SELECT @@global.table_open_cache = 64; +SELECT @@global.table_open_cache = 400; --echo '#--------------------FN_DYNVARS_001_03------------------------#' ######################################################################## |