1SET @global_start_value = @@global.query_cache_type; 2Warnings: 3Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 4SELECT @global_start_value; 5@global_start_value 6ON 7SET @session_start_value = @@session.query_cache_type; 8Warnings: 9Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 10SELECT @session_start_value; 11@session_start_value 12ON 13'#--------------------FN_DYNVARS_134_01------------------------#' 14SET @@global.query_cache_type = 0; 15Warnings: 16Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 17SET @@global.query_cache_type = DEFAULT; 18Warnings: 19Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 20SELECT @@global.query_cache_type; 21@@global.query_cache_type 22OFF 23Warnings: 24Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 25SET @@session.query_cache_type = 0; 26Warnings: 27Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 28SET @@session.query_cache_type = DEFAULT; 29Warnings: 30Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 31SELECT @@session.query_cache_type; 32@@session.query_cache_type 33OFF 34Warnings: 35Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 36'#---------------------FN_DYNVARS_134_02-------------------------#' 37SET @@global.query_cache_type = NULL; 38ERROR 42000: Variable 'query_cache_type' can't be set to the value of 'NULL' 39SET @@global.query_cache_type = ''; 40ERROR 42000: Variable 'query_cache_type' can't be set to the value of '' 41SET @@session.query_cache_type = NULL; 42ERROR 42000: Variable 'query_cache_type' can't be set to the value of 'NULL' 43SET @@session.query_cache_type = ''; 44ERROR 42000: Variable 'query_cache_type' can't be set to the value of '' 45'#--------------------FN_DYNVARS_134_03------------------------#' 46SET @@global.query_cache_type = OFF; 47Warnings: 48Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 49SELECT @@global.query_cache_type; 50@@global.query_cache_type 51OFF 52Warnings: 53Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 54SET @@global.query_cache_type = ON; 55Warnings: 56Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 57SELECT @@global.query_cache_type; 58@@global.query_cache_type 59ON 60Warnings: 61Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 62SET @@global.query_cache_type = DEMAND; 63Warnings: 64Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 65SELECT @@global.query_cache_type; 66@@global.query_cache_type 67DEMAND 68Warnings: 69Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 70SET @@session.query_cache_type = OFF; 71Warnings: 72Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 73SELECT @@session.query_cache_type; 74@@session.query_cache_type 75OFF 76Warnings: 77Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 78SET @@session.query_cache_type = ON; 79Warnings: 80Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 81SELECT @@session.query_cache_type; 82@@session.query_cache_type 83ON 84Warnings: 85Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 86SET @@session.query_cache_type = DEMAND; 87Warnings: 88Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 89SELECT @@session.query_cache_type; 90@@session.query_cache_type 91DEMAND 92Warnings: 93Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 94'#--------------------FN_DYNVARS_134_04-------------------------#' 95SET @@global.query_cache_type = -1; 96ERROR 42000: Variable 'query_cache_type' can't be set to the value of '-1' 97SET @@global.query_cache_type = ONDEMAND; 98ERROR 42000: Variable 'query_cache_type' can't be set to the value of 'ONDEMAND' 99SET @@global.query_cache_type = 'ON,OFF'; 100ERROR 42000: Variable 'query_cache_type' can't be set to the value of 'ON,OFF' 101SET @@global.query_cache_type = 'OF'; 102ERROR 42000: Variable 'query_cache_type' can't be set to the value of 'OF' 103SET @@global.query_cache_type = YES; 104ERROR 42000: Variable 'query_cache_type' can't be set to the value of 'YES' 105SET @@global.query_cache_type = ' '; 106ERROR 42000: Variable 'query_cache_type' can't be set to the value of ' ' 107'#-------------------FN_DYNVARS_134_05----------------------------#' 108SELECT @@session.query_cache_type = VARIABLE_VALUE 109FROM INFORMATION_SCHEMA.SESSION_VARIABLES 110WHERE VARIABLE_NAME='query_cache_type'; 111@@session.query_cache_type = VARIABLE_VALUE 1121 113'#----------------------FN_DYNVARS_134_06------------------------#' 114SELECT @@global.query_cache_type = VARIABLE_VALUE 115FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 116WHERE VARIABLE_NAME='query_cache_type'; 117@@global.query_cache_type = VARIABLE_VALUE 1181 119'#---------------------FN_DYNVARS_134_07-------------------------#' 120SET @@global.query_cache_type = 0; 121Warnings: 122Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 123SELECT @@global.query_cache_type; 124@@global.query_cache_type 125OFF 126Warnings: 127Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 128SET @@global.query_cache_type = 1; 129Warnings: 130Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 131SELECT @@global.query_cache_type; 132@@global.query_cache_type 133ON 134Warnings: 135Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 136SET @@global.query_cache_type = 2; 137Warnings: 138Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 139SELECT @@global.query_cache_type; 140@@global.query_cache_type 141DEMAND 142Warnings: 143Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 144SET @@global.query_cache_type = 0.4; 145ERROR 42000: Incorrect argument type to variable 'query_cache_type' 146SET @@global.query_cache_type = 3; 147ERROR 42000: Variable 'query_cache_type' can't be set to the value of '3' 148'#---------------------FN_DYNVARS_134_08----------------------#' 149SET @@global.query_cache_type = TRUE; 150Warnings: 151Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 152SELECT @@global.query_cache_type; 153@@global.query_cache_type 154ON 155Warnings: 156Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 157SET @@global.query_cache_type = FALSE; 158Warnings: 159Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 160SELECT @@global.query_cache_type; 161@@global.query_cache_type 162OFF 163Warnings: 164Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 165'#---------------------FN_DYNVARS_134_09----------------------#' 166SET query_cache_type = 'ON'; 167Warnings: 168Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 169SET session.query_cache_type = 'OFF'; 170ERROR 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 'session.query_cache_type = 'OFF'' at line 1 171SET global.query_cache_type = 'DEMAND'; 172ERROR 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_type = 'DEMAND'' at line 1 173SET session query_cache_type = 1; 174Warnings: 175Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 176SELECT @@query_cache_type; 177@@query_cache_type 178ON 179Warnings: 180Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 181SET global query_cache_type = 0; 182Warnings: 183Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 184SELECT @@global.query_cache_type; 185@@global.query_cache_type 186OFF 187Warnings: 188Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 189SET @@global.query_cache_type = @global_start_value; 190Warnings: 191Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 192SELECT @@global.query_cache_type; 193@@global.query_cache_type 194ON 195Warnings: 196Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 197SET @@session.query_cache_type = @session_start_value; 198Warnings: 199Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 200SELECT @@session.query_cache_type; 201@@session.query_cache_type 202ON 203Warnings: 204Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. 205