1SET @session_start_value = @@session.query_cache_wlock_invalidate; 2SELECT @session_start_value; 3@session_start_value 40 5SET @global_start_value = @@global.query_cache_wlock_invalidate; 6SELECT @global_start_value; 7@global_start_value 80 9'#--------------------FN_DYNVARS_135_01------------------------#' 10SET @@session.query_cache_wlock_invalidate = 1; 11SET @@session.query_cache_wlock_invalidate = DEFAULT; 12SELECT @@session.query_cache_wlock_invalidate; 13@@session.query_cache_wlock_invalidate 140 15SET @@global.query_cache_wlock_invalidate = 1; 16SET @@global.query_cache_wlock_invalidate = DEFAULT; 17SELECT @@global.query_cache_wlock_invalidate; 18@@global.query_cache_wlock_invalidate 190 20'#---------------------FN_DYNVARS_135_02-------------------------#' 21SET query_cache_wlock_invalidate = 1; 22SELECT @@query_cache_wlock_invalidate; 23@@query_cache_wlock_invalidate 241 25SELECT session.query_cache_wlock_invalidate; 26ERROR 42S02: Unknown table 'session' in field list 27SELECT local.query_cache_wlock_invalidate; 28ERROR 42S02: Unknown table 'local' in field list 29SELECT global.query_cache_wlock_invalidate; 30ERROR 42S02: Unknown table 'global' in field list 31SET session query_cache_wlock_invalidate = 0; 32SELECT @@session.query_cache_wlock_invalidate; 33@@session.query_cache_wlock_invalidate 340 35SET global query_cache_wlock_invalidate = 0; 36SELECT @@global.query_cache_wlock_invalidate; 37@@global.query_cache_wlock_invalidate 380 39'#--------------------FN_DYNVARS_135_03------------------------#' 40SET @@session.query_cache_wlock_invalidate = 0; 41SELECT @@session.query_cache_wlock_invalidate; 42@@session.query_cache_wlock_invalidate 430 44SET @@session.query_cache_wlock_invalidate = 1; 45SELECT @@session.query_cache_wlock_invalidate; 46@@session.query_cache_wlock_invalidate 471 48SET @@global.query_cache_wlock_invalidate = 0; 49SELECT @@global.query_cache_wlock_invalidate; 50@@global.query_cache_wlock_invalidate 510 52SET @@global.query_cache_wlock_invalidate = 1; 53SELECT @@global.query_cache_wlock_invalidate; 54@@global.query_cache_wlock_invalidate 551 56'#--------------------FN_DYNVARS_135_04-------------------------#' 57SET @@session.query_cache_wlock_invalidate = -1; 58ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '-1' 59SET @@session.query_cache_wlock_invalidate = 1.6; 60ERROR 42000: Incorrect argument type to variable 'query_cache_wlock_invalidate' 61SET @@session.query_cache_wlock_invalidate = "T"; 62ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'T' 63SET @@session.query_cache_wlock_invalidate = "Y"; 64ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'Y' 65SET @@session.query_cache_wlock_invalidate = TR�E; 66ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'TR�E' 67SET @@session.query_cache_wlock_invalidate = �N; 68ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '�N' 69SET @@session.query_cache_wlock_invalidate = OF; 70ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'OF' 71SET @@session.query_cache_wlock_invalidate = �FF; 72ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '�FF' 73SET @@global.query_cache_wlock_invalidate = -1; 74ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '-1' 75SET @@global.query_cache_wlock_invalidate = 2; 76ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '2' 77SET @@global.query_cache_wlock_invalidate = "T"; 78ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'T' 79SET @@global.query_cache_wlock_invalidate = "Y"; 80ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'Y' 81SET @@global.query_cache_wlock_invalidate = TR�E; 82ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'TR�E' 83SET @@global.query_cache_wlock_invalidate = �N; 84ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '�N' 85SET @@global.query_cache_wlock_invalidate = OF; 86ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of 'OF' 87SET @@global.query_cache_wlock_invalidate = �FF; 88ERROR 42000: Variable 'query_cache_wlock_invalidate' can't be set to the value of '�FF' 89'#-------------------FN_DYNVARS_135_05----------------------------#' 90SET @@global.query_cache_wlock_invalidate = 0; 91SET @@session.query_cache_wlock_invalidate = 1; 92SELECT @@global.query_cache_wlock_invalidate AS res_is_0; 93res_is_0 940 95SET @@global.query_cache_wlock_invalidate = 0; 96SELECT @@session.query_cache_wlock_invalidate AS res_is_1; 97res_is_1 981 99'#----------------------FN_DYNVARS_135_06------------------------#' 100SELECT IF(@@global.query_cache_wlock_invalidate, "ON", "OFF") = VARIABLE_VALUE 101FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 102WHERE VARIABLE_NAME='query_cache_wlock_invalidate'; 103IF(@@global.query_cache_wlock_invalidate, "ON", "OFF") = VARIABLE_VALUE 1041 105SELECT @@global.query_cache_wlock_invalidate; 106@@global.query_cache_wlock_invalidate 1070 108SELECT VARIABLE_VALUE 109FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 110WHERE VARIABLE_NAME='query_cache_wlock_invalidate'; 111VARIABLE_VALUE 112OFF 113'#----------------------FN_DYNVARS_135_07------------------------#' 114SELECT IF(@@session.query_cache_wlock_invalidate, "ON", "OFF") = VARIABLE_VALUE 115FROM INFORMATION_SCHEMA.SESSION_VARIABLES 116WHERE VARIABLE_NAME='query_cache_wlock_invalidate'; 117IF(@@session.query_cache_wlock_invalidate, "ON", "OFF") = VARIABLE_VALUE 1181 119SELECT @@session.query_cache_wlock_invalidate; 120@@session.query_cache_wlock_invalidate 1211 122SELECT VARIABLE_VALUE 123FROM INFORMATION_SCHEMA.SESSION_VARIABLES 124WHERE VARIABLE_NAME='query_cache_wlock_invalidate'; 125VARIABLE_VALUE 126ON 127'#---------------------FN_DYNVARS_135_08-------------------------#' 128SET @@session.query_cache_wlock_invalidate = OFF; 129SELECT @@session.query_cache_wlock_invalidate; 130@@session.query_cache_wlock_invalidate 1310 132SET @@session.query_cache_wlock_invalidate = ON; 133SELECT @@session.query_cache_wlock_invalidate; 134@@session.query_cache_wlock_invalidate 1351 136SET @@global.query_cache_wlock_invalidate = OFF; 137SELECT @@global.query_cache_wlock_invalidate; 138@@global.query_cache_wlock_invalidate 1390 140SET @@global.query_cache_wlock_invalidate = ON; 141SELECT @@global.query_cache_wlock_invalidate; 142@@global.query_cache_wlock_invalidate 1431 144'#---------------------FN_DYNVARS_135_09----------------------#' 145SET @@session.query_cache_wlock_invalidate = TRUE; 146SELECT @@session.query_cache_wlock_invalidate; 147@@session.query_cache_wlock_invalidate 1481 149SET @@session.query_cache_wlock_invalidate = FALSE; 150SELECT @@session.query_cache_wlock_invalidate; 151@@session.query_cache_wlock_invalidate 1520 153SET @@global.query_cache_wlock_invalidate = TRUE; 154SELECT @@global.query_cache_wlock_invalidate; 155@@global.query_cache_wlock_invalidate 1561 157SET @@global.query_cache_wlock_invalidate = FALSE; 158SELECT @@global.query_cache_wlock_invalidate; 159@@global.query_cache_wlock_invalidate 1600 161SET @@session.query_cache_wlock_invalidate = @session_start_value; 162SELECT @@session.query_cache_wlock_invalidate; 163@@session.query_cache_wlock_invalidate 1640 165SET @@global.query_cache_wlock_invalidate = @global_start_value; 166SELECT @@global.query_cache_wlock_invalidate; 167@@global.query_cache_wlock_invalidate 1680 169