1SET @start_value = @@global.query_cache_min_res_unit; 2SELECT @start_value; 3@start_value 44096 5'#--------------------FN_DYNVARS_132_01------------------------#' 6SET @@global.query_cache_min_res_unit = 99; 7SET @@global.query_cache_min_res_unit = DEFAULT; 8SELECT @@global.query_cache_min_res_unit; 9@@global.query_cache_min_res_unit 104096 11'#---------------------FN_DYNVARS_132_02-------------------------#' 12SET @@global.query_cache_min_res_unit = @start_value; 13SELECT @@global.query_cache_min_res_unit = 4096; 14@@global.query_cache_min_res_unit = 4096 151 16'#--------------------FN_DYNVARS_132_03------------------------#' 17SET @@global.query_cache_min_res_unit = 0; 18SELECT @@global.query_cache_min_res_unit; 19@@global.query_cache_min_res_unit 20512 21SET @@global.query_cache_min_res_unit = 1; 22SELECT @@global.query_cache_min_res_unit; 23@@global.query_cache_min_res_unit 24512 25SET @@global.query_cache_min_res_unit = 512; 26SELECT @@global.query_cache_min_res_unit; 27@@global.query_cache_min_res_unit 28512 29SET @@global.query_cache_min_res_unit = 513; 30SELECT @@global.query_cache_min_res_unit; 31@@global.query_cache_min_res_unit 32520 33SET @@global.query_cache_min_res_unit = 1048576; 34SELECT @@global.query_cache_min_res_unit; 35@@global.query_cache_min_res_unit 361048576 37SET @@global.query_cache_min_res_unit = 1048575; 38SELECT @@global.query_cache_min_res_unit; 39@@global.query_cache_min_res_unit 401048576 41'#--------------------FN_DYNVARS_132_04-------------------------#' 42SET @@global.query_cache_min_res_unit = -1; 43Warnings: 44Warning 1292 Truncated incorrect query_cache_min_res_unit value: '-1' 45SELECT @@global.query_cache_min_res_unit; 46@@global.query_cache_min_res_unit 47512 48SET @@global.query_cache_min_res_unit = 4294967296; 49SELECT @@global.query_cache_min_res_unit; 50@@global.query_cache_min_res_unit 514294967296 52SET @@global.query_cache_min_res_unit = 511; 53SELECT @@global.query_cache_min_res_unit; 54@@global.query_cache_min_res_unit 55512 56SET @@global.query_cache_min_res_unit = 10000.01; 57ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit' 58SELECT @@global.query_cache_min_res_unit; 59@@global.query_cache_min_res_unit 60512 61SET @@global.query_cache_min_res_unit = -1024; 62Warnings: 63Warning 1292 Truncated incorrect query_cache_min_res_unit value: '-1024' 64SELECT @@global.query_cache_min_res_unit; 65@@global.query_cache_min_res_unit 66512 67SET @@global.query_cache_min_res_unit = 42949672950; 68SELECT @@global.query_cache_min_res_unit; 69@@global.query_cache_min_res_unit 7042949672952 71SET @@global.query_cache_min_res_unit = ON; 72ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit' 73SELECT @@global.query_cache_min_res_unit; 74@@global.query_cache_min_res_unit 7542949672952 76SET @@global.query_cache_min_res_unit = 'test'; 77ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit' 78SELECT @@global.query_cache_min_res_unit; 79@@global.query_cache_min_res_unit 8042949672952 81'#-------------------FN_DYNVARS_132_05----------------------------#' 82SET @@session.query_cache_min_res_unit = 0; 83ERROR HY000: Variable 'query_cache_min_res_unit' is a GLOBAL variable and should be set with SET GLOBAL 84SELECT @@query_cache_min_res_unit; 85@@query_cache_min_res_unit 8642949672952 87'#----------------------FN_DYNVARS_132_06------------------------#' 88SELECT @@global.query_cache_min_res_unit = VARIABLE_VALUE 89FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 90WHERE VARIABLE_NAME='query_cache_min_res_unit'; 91@@global.query_cache_min_res_unit = VARIABLE_VALUE 921 93SELECT @@query_cache_min_res_unit = VARIABLE_VALUE 94FROM INFORMATION_SCHEMA.SESSION_VARIABLES 95WHERE VARIABLE_NAME='query_cache_min_res_unit'; 96@@query_cache_min_res_unit = VARIABLE_VALUE 971 98'#---------------------FN_DYNVARS_132_07----------------------#' 99SET @@global.query_cache_min_res_unit = TRUE; 100SELECT @@global.query_cache_min_res_unit; 101@@global.query_cache_min_res_unit 102512 103SET @@global.query_cache_min_res_unit = FALSE; 104SELECT @@global.query_cache_min_res_unit; 105@@global.query_cache_min_res_unit 106512 107'#---------------------FN_DYNVARS_132_08----------------------#' 108SET @@global.query_cache_min_res_unit = 1; 109SELECT @@query_cache_min_res_unit = @@global.query_cache_min_res_unit; 110@@query_cache_min_res_unit = @@global.query_cache_min_res_unit 1111 112'#---------------------FN_DYNVARS_132_09----------------------#' 113SET query_cache_min_res_unit = 1; 114ERROR HY000: Variable 'query_cache_min_res_unit' is a GLOBAL variable and should be set with SET GLOBAL 115SELECT @@query_cache_min_res_unit; 116@@query_cache_min_res_unit 117512 118SET local.query_cache_min_res_unit = 1; 119ERROR 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_min_res_unit = 1' at line 1 120SELECT local.query_cache_min_res_unit; 121ERROR 42S02: Unknown table 'local' in field list 122SET global.query_cache_min_res_unit = 1; 123ERROR 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_min_res_unit = 1' at line 1 124SELECT global.query_cache_min_res_unit; 125ERROR 42S02: Unknown table 'global' in field list 126SELECT query_cache_min_res_unit = @@session.query_cache_min_res_unit; 127ERROR 42S22: Unknown column 'query_cache_min_res_unit' in 'field list' 128SET @@global.query_cache_min_res_unit = @start_value; 129SELECT @@global.query_cache_min_res_unit; 130@@global.query_cache_min_res_unit 1314096 132