Edit File: query_cache_size_basic_64.result
SET @start_value = @@global.query_cache_size; '#--------------------FN_DYNVARS_133_01------------------------#' SET @@global.query_cache_size = 99; Warnings: Warning 1292 Truncated incorrect query_cache_size value: '99' SET @@global.query_cache_size = DEFAULT; SELECT @@global.query_cache_size; @@global.query_cache_size 0 '#---------------------FN_DYNVARS_133_02-------------------------#' SET @@global.query_cache_size = @start_value; SELECT @@global.query_cache_size = @start_value; @@global.query_cache_size = @start_value 1 '#--------------------FN_DYNVARS_133_03------------------------#' SET @@global.query_cache_size = 0; SELECT @@global.query_cache_size; @@global.query_cache_size 0 SET @@global.query_cache_size = 1; Warnings: Warning 1292 Truncated incorrect query_cache_size value: '1' SELECT @@global.query_cache_size; @@global.query_cache_size 0 SET @@global.query_cache_size = 512; Warnings: Warning 1292 Truncated incorrect query_cache_size value: '512' SELECT @@global.query_cache_size; @@global.query_cache_size 0 SET @@global.query_cache_size = 1024; Warnings: Warning 1282 Query cache failed to set size 1024; new query cache size is 0 SELECT @@global.query_cache_size; @@global.query_cache_size 0 SET @@global.query_cache_size = 1048576; SELECT @@global.query_cache_size; @@global.query_cache_size 1048576 SET @@global.query_cache_size = 1048575; Warnings: Warning 1292 Truncated incorrect query_cache_size value: '1048575' SELECT @@global.query_cache_size; @@global.query_cache_size 1047552 '#--------------------FN_DYNVARS_133_04-------------------------#' SET @@global.query_cache_size = -1; Warnings: Warning 1292 Truncated incorrect query_cache_size value: '-1' SELECT @@global.query_cache_size; @@global.query_cache_size 0 SET @@global.query_cache_size = 511; Warnings: Warning 1292 Truncated incorrect query_cache_size value: '511' SELECT @@global.query_cache_size; @@global.query_cache_size 0 SET @@global.query_cache_size = 10000.01; ERROR 42000: Incorrect argument type to variable 'query_cache_size' SELECT @@global.query_cache_size; @@global.query_cache_size 0 SET @@global.query_cache_size = -1024; Warnings: Warning 1292 Truncated incorrect query_cache_size value: '-1024' SELECT @@global.query_cache_size; @@global.query_cache_size 0 SET @@global.query_cache_size = 42949672950; Warnings: Warning 1292 Truncated incorrect query_cache_size value: '42949672950' Warning 1282 Query cache failed to set size 42949671936; new query cache size is 0 SELECT @@global.query_cache_size; @@global.query_cache_size 0 SET @@global.query_cache_size = ON; ERROR 42000: Incorrect argument type to variable 'query_cache_size' SELECT @@global.query_cache_size; @@global.query_cache_size 0 SET @@global.query_cache_size = 'test'; ERROR 42000: Incorrect argument type to variable 'query_cache_size' SELECT @@global.query_cache_size; @@global.query_cache_size 0 '#-------------------FN_DYNVARS_133_05----------------------------#' SET @@session.query_cache_size = 0; ERROR HY000: Variable 'query_cache_size' is a GLOBAL variable and should be set with SET GLOBAL SELECT @@query_cache_size; @@query_cache_size 0 '#----------------------FN_DYNVARS_133_06------------------------#' SELECT @@global.query_cache_size = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='query_cache_size'; @@global.query_cache_size = VARIABLE_VALUE 1 SELECT @@query_cache_size = VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='query_cache_size'; @@query_cache_size = VARIABLE_VALUE 1 '#---------------------FN_DYNVARS_133_07----------------------#' SET @@global.query_cache_size = TRUE; Warnings: Warning 1292 Truncated incorrect query_cache_size value: '1' SELECT @@global.query_cache_size; @@global.query_cache_size 0 SET @@global.query_cache_size = FALSE; SELECT @@global.query_cache_size; @@global.query_cache_size 0 '#---------------------FN_DYNVARS_133_08----------------------#' SET @@global.query_cache_size = 1; Warnings: Warning 1292 Truncated incorrect query_cache_size value: '1' SELECT @@query_cache_size = @@global.query_cache_size; @@query_cache_size = @@global.query_cache_size 1 '#---------------------FN_DYNVARS_133_09----------------------#' SET query_cache_size = 1; ERROR HY000: Variable 'query_cache_size' is a GLOBAL variable and should be set with SET GLOBAL SELECT @@query_cache_size; @@query_cache_size 0 SET local.query_cache_size = 1; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'query_cache_size = 1' at line 1 SELECT local.query_cache_size; ERROR 42S02: Unknown table 'local' in field list SET global.query_cache_size = 1; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'query_cache_size = 1' at line 1 SELECT global.query_cache_size; ERROR 42S02: Unknown table 'global' in field list SELECT query_cache_size = @@session.query_cache_size; ERROR 42S22: Unknown column 'query_cache_size' in 'field list' SET @@global.query_cache_size = @start_value;
Back to File Manager