1SET @session_start_value = @@session.innodb_table_locks; 2SELECT @session_start_value; 3@session_start_value 41 5SET @global_start_value = @@global.innodb_table_locks; 6SELECT @global_start_value; 7@global_start_value 81 9'#--------------------FN_DYNVARS_046_01------------------------#' 10SET @@session.innodb_table_locks = 0; 11SET @@session.innodb_table_locks = DEFAULT; 12SELECT @@session.innodb_table_locks; 13@@session.innodb_table_locks 141 15SET @@global.innodb_table_locks = 0; 16SET @@global.innodb_table_locks = DEFAULT; 17SELECT @@global.innodb_table_locks; 18@@global.innodb_table_locks 191 20'#---------------------FN_DYNVARS_046_02-------------------------#' 21SET innodb_table_locks = 1; 22SELECT @@innodb_table_locks; 23@@innodb_table_locks 241 25SELECT session.innodb_table_locks; 26ERROR 42S02: Unknown table 'session' in field list 27SELECT local.innodb_table_locks; 28ERROR 42S02: Unknown table 'local' in field list 29SELECT global.innodb_table_locks; 30ERROR 42S02: Unknown table 'global' in field list 31SET session innodb_table_locks = 0; 32SELECT @@session.innodb_table_locks; 33@@session.innodb_table_locks 340 35SET global innodb_table_locks = 0; 36SELECT @@global.innodb_table_locks; 37@@global.innodb_table_locks 380 39'#--------------------FN_DYNVARS_046_03------------------------#' 40SET @@session.innodb_table_locks = 0; 41SELECT @@session.innodb_table_locks; 42@@session.innodb_table_locks 430 44SET @@session.innodb_table_locks = 1; 45SELECT @@session.innodb_table_locks; 46@@session.innodb_table_locks 471 48SET @@global.innodb_table_locks = 0; 49SELECT @@global.innodb_table_locks; 50@@global.innodb_table_locks 510 52SET @@global.innodb_table_locks = 1; 53SELECT @@global.innodb_table_locks; 54@@global.innodb_table_locks 551 56'#--------------------FN_DYNVARS_046_04-------------------------#' 57SET @@session.innodb_table_locks = -6; 58ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '-6' 59SET @@session.innodb_table_locks = 1.6; 60ERROR 42000: Incorrect argument type to variable 'innodb_table_locks' 61SET @@session.innodb_table_locks = "T"; 62ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'T' 63SET @@session.innodb_table_locks = "Y"; 64ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'Y' 65SET @@session.innodb_table_locks = TR�E; 66ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'TR�E' 67SET @@session.innodb_table_locks = �N; 68ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '�N' 69SET @@session.innodb_table_locks = OF; 70SELECT @@session.innodb_table_locks; 71@@session.innodb_table_locks 720 73SET @@session.innodb_table_locks = �FF; 74ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '�FF' 75SET @@global.innodb_table_locks = -1; 76ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '-1' 77SET @@global.innodb_table_locks = 2; 78ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '2' 79SET @@global.innodb_table_locks = "T"; 80ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'T' 81SET @@global.innodb_table_locks = "Y"; 82ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'Y' 83SET @@global.innodb_table_locks = TR�E; 84ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'TR�E' 85SET @@global.innodb_table_locks = QN; 86ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'QN' 87SET @@global.innodb_table_locks = OF; 88SELECT @@global.innodb_table_locks; 89@@global.innodb_table_locks 900 91'#-------------------FN_DYNVARS_046_05----------------------------#' 92SET @@global.innodb_table_locks = 0; 93SET @@session.innodb_table_locks = 1; 94SELECT @@global.innodb_table_locks AS res_is_0; 95res_is_0 960 97SET @@global.innodb_table_locks = 0; 98SELECT @@session.innodb_table_locks AS res_is_1; 99res_is_1 1001 101'#----------------------FN_DYNVARS_046_06------------------------#' 102SELECT IF(@@global.innodb_table_locks, "ON", "OFF") = 103VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 104WHERE VARIABLE_NAME='innodb_table_locks'; 105IF(@@global.innodb_table_locks, "ON", "OFF") = 106VARIABLE_VALUE 1071 108SELECT @@global.innodb_table_locks; 109@@global.innodb_table_locks 1100 111SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 112WHERE VARIABLE_NAME='innodb_table_locks'; 113VARIABLE_VALUE 114OFF 115'#----------------------FN_DYNVARS_046_07------------------------#' 116SELECT IF(@@session.innodb_table_locks, "ON", "OFF") = 117VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 118WHERE VARIABLE_NAME='innodb_table_locks'; 119IF(@@session.innodb_table_locks, "ON", "OFF") = 120VARIABLE_VALUE 1211 122SELECT @@session.innodb_table_locks; 123@@session.innodb_table_locks 1241 125SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 126WHERE VARIABLE_NAME='innodb_table_locks'; 127VARIABLE_VALUE 128ON 129'#---------------------FN_DYNVARS_046_08-------------------------#' 130SET @@session.innodb_table_locks = OFF; 131SELECT @@session.innodb_table_locks; 132@@session.innodb_table_locks 1330 134SET @@session.innodb_table_locks = ON; 135SELECT @@session.innodb_table_locks; 136@@session.innodb_table_locks 1371 138SET @@global.innodb_table_locks = OFF; 139SELECT @@global.innodb_table_locks; 140@@global.innodb_table_locks 1410 142SET @@global.innodb_table_locks = ON; 143SELECT @@global.innodb_table_locks; 144@@global.innodb_table_locks 1451 146'#---------------------FN_DYNVARS_046_09----------------------#' 147SET @@session.innodb_table_locks = TRUE; 148SELECT @@session.innodb_table_locks; 149@@session.innodb_table_locks 1501 151SET @@session.innodb_table_locks = FALSE; 152SELECT @@session.innodb_table_locks; 153@@session.innodb_table_locks 1540 155SET @@global.innodb_table_locks = TRUE; 156SELECT @@global.innodb_table_locks; 157@@global.innodb_table_locks 1581 159SET @@global.innodb_table_locks = FALSE; 160SELECT @@global.innodb_table_locks; 161@@global.innodb_table_locks 1620 163SET @@session.innodb_table_locks = @session_start_value; 164SELECT @@session.innodb_table_locks; 165@@session.innodb_table_locks 1661 167SET @@global.innodb_table_locks = @global_start_value; 168SELECT @@global.innodb_table_locks; 169@@global.innodb_table_locks 1701 171