1SET @start_value = @@global.query_cache_min_res_unit; 2Warnings: 3Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 4SELECT @start_value; 5@start_value 64096 7'#--------------------FN_DYNVARS_132_01------------------------#' 8SET @@global.query_cache_min_res_unit = 99; 9Warnings: 10Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 11SET @@global.query_cache_min_res_unit = DEFAULT; 12Warnings: 13Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 14SELECT @@global.query_cache_min_res_unit; 15@@global.query_cache_min_res_unit 164096 17Warnings: 18Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 19'#---------------------FN_DYNVARS_132_02-------------------------#' 20SET @@global.query_cache_min_res_unit = @start_value; 21Warnings: 22Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 23SELECT @@global.query_cache_min_res_unit = 4096; 24@@global.query_cache_min_res_unit = 4096 251 26Warnings: 27Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 28'#--------------------FN_DYNVARS_132_03------------------------#' 29SET @@global.query_cache_min_res_unit = 0; 30Warnings: 31Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 32SELECT @@global.query_cache_min_res_unit; 33@@global.query_cache_min_res_unit 34512 35Warnings: 36Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 37SET @@global.query_cache_min_res_unit = 1; 38Warnings: 39Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 40SELECT @@global.query_cache_min_res_unit; 41@@global.query_cache_min_res_unit 42512 43Warnings: 44Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 45SET @@global.query_cache_min_res_unit = 512; 46Warnings: 47Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 48SELECT @@global.query_cache_min_res_unit; 49@@global.query_cache_min_res_unit 50512 51Warnings: 52Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 53SET @@global.query_cache_min_res_unit = 513; 54Warnings: 55Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 56SELECT @@global.query_cache_min_res_unit; 57@@global.query_cache_min_res_unit 58520 59Warnings: 60Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 61SET @@global.query_cache_min_res_unit = 1048576; 62Warnings: 63Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 64SELECT @@global.query_cache_min_res_unit; 65@@global.query_cache_min_res_unit 661048576 67Warnings: 68Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 69SET @@global.query_cache_min_res_unit = 1048575; 70Warnings: 71Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 72SELECT @@global.query_cache_min_res_unit; 73@@global.query_cache_min_res_unit 741048576 75Warnings: 76Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 77'#--------------------FN_DYNVARS_132_04-------------------------#' 78SET @@global.query_cache_min_res_unit = -1; 79Warnings: 80Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 81Warning 1292 Truncated incorrect query_cache_min_res_unit value: '-1' 82SELECT @@global.query_cache_min_res_unit; 83@@global.query_cache_min_res_unit 84512 85Warnings: 86Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 87SET @@global.query_cache_min_res_unit = 4294967296; 88Warnings: 89Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 90SELECT @@global.query_cache_min_res_unit; 91@@global.query_cache_min_res_unit 924294967296 93Warnings: 94Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 95SET @@global.query_cache_min_res_unit = 511; 96Warnings: 97Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 98SELECT @@global.query_cache_min_res_unit; 99@@global.query_cache_min_res_unit 100512 101Warnings: 102Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 103SET @@global.query_cache_min_res_unit = 10000.01; 104ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit' 105SELECT @@global.query_cache_min_res_unit; 106@@global.query_cache_min_res_unit 107512 108Warnings: 109Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 110SET @@global.query_cache_min_res_unit = -1024; 111Warnings: 112Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 113Warning 1292 Truncated incorrect query_cache_min_res_unit value: '-1024' 114SELECT @@global.query_cache_min_res_unit; 115@@global.query_cache_min_res_unit 116512 117Warnings: 118Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 119SET @@global.query_cache_min_res_unit = 42949672950; 120Warnings: 121Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 122SELECT @@global.query_cache_min_res_unit; 123@@global.query_cache_min_res_unit 12442949672952 125Warnings: 126Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 127SET @@global.query_cache_min_res_unit = ON; 128ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit' 129SELECT @@global.query_cache_min_res_unit; 130@@global.query_cache_min_res_unit 13142949672952 132Warnings: 133Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 134SET @@global.query_cache_min_res_unit = 'test'; 135ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit' 136SELECT @@global.query_cache_min_res_unit; 137@@global.query_cache_min_res_unit 13842949672952 139Warnings: 140Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 141'#-------------------FN_DYNVARS_132_05----------------------------#' 142SET @@session.query_cache_min_res_unit = 0; 143ERROR HY000: Variable 'query_cache_min_res_unit' is a GLOBAL variable and should be set with SET GLOBAL 144SELECT @@query_cache_min_res_unit; 145@@query_cache_min_res_unit 14642949672952 147Warnings: 148Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 149'#----------------------FN_DYNVARS_132_06------------------------#' 150SELECT @@global.query_cache_min_res_unit = VARIABLE_VALUE 151FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 152WHERE VARIABLE_NAME='query_cache_min_res_unit'; 153@@global.query_cache_min_res_unit = VARIABLE_VALUE 1541 155SELECT @@query_cache_min_res_unit = VARIABLE_VALUE 156FROM INFORMATION_SCHEMA.SESSION_VARIABLES 157WHERE VARIABLE_NAME='query_cache_min_res_unit'; 158@@query_cache_min_res_unit = VARIABLE_VALUE 1591 160'#---------------------FN_DYNVARS_132_07----------------------#' 161SET @@global.query_cache_min_res_unit = TRUE; 162Warnings: 163Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 164SELECT @@global.query_cache_min_res_unit; 165@@global.query_cache_min_res_unit 166512 167Warnings: 168Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 169SET @@global.query_cache_min_res_unit = FALSE; 170Warnings: 171Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 172SELECT @@global.query_cache_min_res_unit; 173@@global.query_cache_min_res_unit 174512 175Warnings: 176Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 177'#---------------------FN_DYNVARS_132_08----------------------#' 178SET @@global.query_cache_min_res_unit = 1; 179Warnings: 180Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 181SELECT @@query_cache_min_res_unit = @@global.query_cache_min_res_unit; 182@@query_cache_min_res_unit = @@global.query_cache_min_res_unit 1831 184Warnings: 185Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 186Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 187'#---------------------FN_DYNVARS_132_09----------------------#' 188SET query_cache_min_res_unit = 1; 189ERROR HY000: Variable 'query_cache_min_res_unit' is a GLOBAL variable and should be set with SET GLOBAL 190SELECT @@query_cache_min_res_unit; 191@@query_cache_min_res_unit 192512 193Warnings: 194Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 195SET local.query_cache_min_res_unit = 1; 196ERROR 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 'local.query_cache_min_res_unit = 1' at line 1 197SELECT local.query_cache_min_res_unit; 198ERROR 42S02: Unknown table 'local' in field list 199SET global.query_cache_min_res_unit = 1; 200ERROR 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 'global.query_cache_min_res_unit = 1' at line 1 201SELECT global.query_cache_min_res_unit; 202ERROR 42S02: Unknown table 'global' in field list 203SELECT query_cache_min_res_unit = @@session.query_cache_min_res_unit; 204ERROR 42S22: Unknown column 'query_cache_min_res_unit' in 'field list' 205SET @@global.query_cache_min_res_unit = @start_value; 206Warnings: 207Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 208SELECT @@global.query_cache_min_res_unit; 209@@global.query_cache_min_res_unit 2104096 211Warnings: 212Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 213