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. 90Warning 1292 Truncated incorrect query_cache_min_res_unit value: '4294967296' 91SELECT @@global.query_cache_min_res_unit; 92@@global.query_cache_min_res_unit 934294967288 94Warnings: 95Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 96SET @@global.query_cache_min_res_unit = 511; 97Warnings: 98Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 99SELECT @@global.query_cache_min_res_unit; 100@@global.query_cache_min_res_unit 101512 102Warnings: 103Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 104SET @@global.query_cache_min_res_unit = 10000.01; 105ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit' 106SELECT @@global.query_cache_min_res_unit; 107@@global.query_cache_min_res_unit 108512 109Warnings: 110Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 111SET @@global.query_cache_min_res_unit = -1024; 112Warnings: 113Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 114Warning 1292 Truncated incorrect query_cache_min_res_unit value: '-1024' 115SELECT @@global.query_cache_min_res_unit; 116@@global.query_cache_min_res_unit 117512 118Warnings: 119Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 120SET @@global.query_cache_min_res_unit = 42949672950; 121Warnings: 122Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 123Warning 1292 Truncated incorrect query_cache_min_res_unit value: '42949672950' 124SELECT @@global.query_cache_min_res_unit; 125@@global.query_cache_min_res_unit 1264294967288 127Warnings: 128Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 129SET @@global.query_cache_min_res_unit = ON; 130ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit' 131SELECT @@global.query_cache_min_res_unit; 132@@global.query_cache_min_res_unit 1334294967288 134Warnings: 135Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 136SET @@global.query_cache_min_res_unit = 'test'; 137ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit' 138SELECT @@global.query_cache_min_res_unit; 139@@global.query_cache_min_res_unit 1404294967288 141Warnings: 142Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 143'#-------------------FN_DYNVARS_132_05----------------------------#' 144SET @@session.query_cache_min_res_unit = 0; 145ERROR HY000: Variable 'query_cache_min_res_unit' is a GLOBAL variable and should be set with SET GLOBAL 146SELECT @@query_cache_min_res_unit; 147@@query_cache_min_res_unit 1484294967288 149Warnings: 150Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 151'#----------------------FN_DYNVARS_132_06------------------------#' 152SELECT @@global.query_cache_min_res_unit = VARIABLE_VALUE 153FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 154WHERE VARIABLE_NAME='query_cache_min_res_unit'; 155@@global.query_cache_min_res_unit = VARIABLE_VALUE 1561 157SELECT @@query_cache_min_res_unit = VARIABLE_VALUE 158FROM INFORMATION_SCHEMA.SESSION_VARIABLES 159WHERE VARIABLE_NAME='query_cache_min_res_unit'; 160@@query_cache_min_res_unit = VARIABLE_VALUE 1611 162'#---------------------FN_DYNVARS_132_07----------------------#' 163SET @@global.query_cache_min_res_unit = TRUE; 164Warnings: 165Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 166SELECT @@global.query_cache_min_res_unit; 167@@global.query_cache_min_res_unit 168512 169Warnings: 170Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 171SET @@global.query_cache_min_res_unit = FALSE; 172Warnings: 173Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 174SELECT @@global.query_cache_min_res_unit; 175@@global.query_cache_min_res_unit 176512 177Warnings: 178Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 179'#---------------------FN_DYNVARS_132_08----------------------#' 180SET @@global.query_cache_min_res_unit = 1; 181Warnings: 182Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 183SELECT @@query_cache_min_res_unit = @@global.query_cache_min_res_unit; 184@@query_cache_min_res_unit = @@global.query_cache_min_res_unit 1851 186Warnings: 187Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 188Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 189'#---------------------FN_DYNVARS_132_09----------------------#' 190SET query_cache_min_res_unit = 1; 191ERROR HY000: Variable 'query_cache_min_res_unit' is a GLOBAL variable and should be set with SET GLOBAL 192SELECT @@query_cache_min_res_unit; 193@@query_cache_min_res_unit 194512 195Warnings: 196Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 197SET local.query_cache_min_res_unit = 1; 198ERROR 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 199SELECT local.query_cache_min_res_unit; 200ERROR 42S02: Unknown table 'local' in field list 201SET global.query_cache_min_res_unit = 1; 202ERROR 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 203SELECT global.query_cache_min_res_unit; 204ERROR 42S02: Unknown table 'global' in field list 205SELECT query_cache_min_res_unit = @@session.query_cache_min_res_unit; 206ERROR 42S22: Unknown column 'query_cache_min_res_unit' in 'field list' 207SET @@global.query_cache_min_res_unit = @start_value; 208Warnings: 209Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 210SELECT @@global.query_cache_min_res_unit; 211@@global.query_cache_min_res_unit 2124096 213Warnings: 214Warning 1287 '@@query_cache_min_res_unit' is deprecated and will be removed in a future release. 215