1SET @start_value = @@global.query_cache_size; 2'#--------------------FN_DYNVARS_133_01------------------------#' 3SET @@global.query_cache_size = 99; 4Warnings: 5Warning 1292 Truncated incorrect query_cache_size value: '99' 6SET @@global.query_cache_size = DEFAULT; 7SELECT @@global.query_cache_size; 8@@global.query_cache_size 91048576 10'#---------------------FN_DYNVARS_133_02-------------------------#' 11SET @@global.query_cache_size = @start_value; 12SELECT @@global.query_cache_size = @start_value; 13@@global.query_cache_size = @start_value 141 15'#--------------------FN_DYNVARS_133_03------------------------#' 16SET @@global.query_cache_size = 0; 17SELECT @@global.query_cache_size; 18@@global.query_cache_size 190 20SET @@global.query_cache_size = 1; 21Warnings: 22Warning 1292 Truncated incorrect query_cache_size value: '1' 23SELECT @@global.query_cache_size; 24@@global.query_cache_size 250 26SET @@global.query_cache_size = 512; 27Warnings: 28Warning 1292 Truncated incorrect query_cache_size value: '512' 29SELECT @@global.query_cache_size; 30@@global.query_cache_size 310 32SET @@global.query_cache_size = 1024; 33Warnings: 34Warning 1282 Query cache failed to set size 1024; new query cache size is 0 35SELECT @@global.query_cache_size; 36@@global.query_cache_size 370 38SET @@global.query_cache_size = 1048576; 39SELECT @@global.query_cache_size; 40@@global.query_cache_size 411048576 42SET @@global.query_cache_size = 1048575; 43Warnings: 44Warning 1292 Truncated incorrect query_cache_size value: '1048575' 45SELECT @@global.query_cache_size; 46@@global.query_cache_size 471047552 48'#--------------------FN_DYNVARS_133_04-------------------------#' 49SET @@global.query_cache_size = -1; 50Warnings: 51Warning 1292 Truncated incorrect query_cache_size value: '-1' 52SELECT @@global.query_cache_size; 53@@global.query_cache_size 540 55SET @@global.query_cache_size = 511; 56Warnings: 57Warning 1292 Truncated incorrect query_cache_size value: '511' 58SELECT @@global.query_cache_size; 59@@global.query_cache_size 600 61SET @@global.query_cache_size = 10000.01; 62ERROR 42000: Incorrect argument type to variable 'query_cache_size' 63SELECT @@global.query_cache_size; 64@@global.query_cache_size 650 66SET @@global.query_cache_size = -1024; 67Warnings: 68Warning 1292 Truncated incorrect query_cache_size value: '-1024' 69SELECT @@global.query_cache_size; 70@@global.query_cache_size 710 72SET @@global.query_cache_size = 42949672950; 73Warnings: 74Warning 1292 Truncated incorrect query_cache_size value: '42949672950' 75Warning 1282 Query cache failed to set size 4294966272; new query cache size is 0 76SELECT @@global.query_cache_size; 77@@global.query_cache_size 780 79SET @@global.query_cache_size = ON; 80ERROR 42000: Incorrect argument type to variable 'query_cache_size' 81SELECT @@global.query_cache_size; 82@@global.query_cache_size 830 84SET @@global.query_cache_size = 'test'; 85ERROR 42000: Incorrect argument type to variable 'query_cache_size' 86SELECT @@global.query_cache_size; 87@@global.query_cache_size 880 89'#-------------------FN_DYNVARS_133_05----------------------------#' 90SET @@session.query_cache_size = 0; 91ERROR HY000: Variable 'query_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 92SELECT @@query_cache_size; 93@@query_cache_size 940 95'#----------------------FN_DYNVARS_133_06------------------------#' 96SELECT @@global.query_cache_size = VARIABLE_VALUE 97FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 98WHERE VARIABLE_NAME='query_cache_size'; 99@@global.query_cache_size = VARIABLE_VALUE 1001 101SELECT @@query_cache_size = VARIABLE_VALUE 102FROM INFORMATION_SCHEMA.SESSION_VARIABLES 103WHERE VARIABLE_NAME='query_cache_size'; 104@@query_cache_size = VARIABLE_VALUE 1051 106'#---------------------FN_DYNVARS_133_07----------------------#' 107SET @@global.query_cache_size = TRUE; 108Warnings: 109Warning 1292 Truncated incorrect query_cache_size value: '1' 110SELECT @@global.query_cache_size; 111@@global.query_cache_size 1120 113SET @@global.query_cache_size = FALSE; 114SELECT @@global.query_cache_size; 115@@global.query_cache_size 1160 117'#---------------------FN_DYNVARS_133_08----------------------#' 118SET @@global.query_cache_size = 1; 119Warnings: 120Warning 1292 Truncated incorrect query_cache_size value: '1' 121SELECT @@query_cache_size = @@global.query_cache_size; 122@@query_cache_size = @@global.query_cache_size 1231 124'#---------------------FN_DYNVARS_133_09----------------------#' 125SET query_cache_size = 1; 126ERROR HY000: Variable 'query_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 127SELECT @@query_cache_size; 128@@query_cache_size 1290 130SET local.query_cache_size = 1; 131ERROR 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 132SELECT local.query_cache_size; 133ERROR 42S02: Unknown table 'local' in field list 134SET global.query_cache_size = 1; 135ERROR 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 136SELECT global.query_cache_size; 137ERROR 42S02: Unknown table 'global' in field list 138SELECT query_cache_size = @@session.query_cache_size; 139ERROR 42S22: Unknown column 'query_cache_size' in 'field list' 140SET @@global.query_cache_size = @start_value; 141