1SET @session_start_value = @@session.innodb_support_xa; 2SELECT @session_start_value; 3@session_start_value 41 5SET @global_start_value = @@global.innodb_support_xa; 6SELECT @global_start_value; 7@global_start_value 81 9'#--------------------FN_DYNVARS_046_01------------------------#' 10SET @@session.innodb_support_xa = 0; 11SET @@session.innodb_support_xa = DEFAULT; 12SELECT @@session.innodb_support_xa; 13@@session.innodb_support_xa 141 15SET @@global.innodb_support_xa = 0; 16SET @@global.innodb_support_xa = DEFAULT; 17SELECT @@global.innodb_support_xa; 18@@global.innodb_support_xa 191 20'#---------------------FN_DYNVARS_046_02-------------------------#' 21SET innodb_support_xa = 1; 22SELECT @@innodb_support_xa; 23@@innodb_support_xa 241 25SELECT session.innodb_support_xa; 26ERROR 42S02: Unknown table 'session' in field list 27SELECT local.innodb_support_xa; 28ERROR 42S02: Unknown table 'local' in field list 29SELECT global.innodb_support_xa; 30ERROR 42S02: Unknown table 'global' in field list 31SET session innodb_support_xa = 0; 32SELECT @@session.innodb_support_xa; 33@@session.innodb_support_xa 340 35SET global innodb_support_xa = 0; 36SELECT @@global.innodb_support_xa; 37@@global.innodb_support_xa 380 39'#--------------------FN_DYNVARS_046_03------------------------#' 40SET @@session.innodb_support_xa = 0; 41SELECT @@session.innodb_support_xa; 42@@session.innodb_support_xa 430 44SET @@session.innodb_support_xa = 1; 45SELECT @@session.innodb_support_xa; 46@@session.innodb_support_xa 471 48SET @@global.innodb_support_xa = 0; 49SELECT @@global.innodb_support_xa; 50@@global.innodb_support_xa 510 52SET @@global.innodb_support_xa = 1; 53SELECT @@global.innodb_support_xa; 54@@global.innodb_support_xa 551 56'#--------------------FN_DYNVARS_046_04-------------------------#' 57SET @@session.innodb_support_xa = -0.6; 58ERROR 42000: Incorrect argument type to variable 'innodb_support_xa' 59SET @@session.innodb_support_xa = 1.6; 60ERROR 42000: Incorrect argument type to variable 'innodb_support_xa' 61SET @@session.innodb_support_xa = "T"; 62ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of 'T' 63SET @@session.innodb_support_xa = "Y"; 64ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of 'Y' 65SET @@session.innodb_support_xa = TR�E; 66ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of 'TR�E' 67SET @@session.innodb_support_xa = �N; 68ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of '�N' 69SET @@session.innodb_support_xa = OF; 70SELECT @@session.innodb_support_xa; 71@@session.innodb_support_xa 720 73SET @@session.innodb_support_xa = �FF; 74ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of '�FF' 75SET @@global.innodb_support_xa = -1; 76SELECT @@global.innodb_support_xa; 77@@global.innodb_support_xa 781 79SET @@global.innodb_support_xa = 2; 80ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of '2' 81SET @@global.innodb_support_xa = "T"; 82ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of 'T' 83SET @@global.innodb_support_xa = "Y"; 84ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of 'Y' 85SET @@global.innodb_support_xa = TR�E; 86ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of 'TR�E' 87SET @@global.innodb_support_xa = �N; 88ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of '�N' 89SET @@global.innodb_support_xa = OF; 90SELECT @@global.innodb_support_xa; 91@@global.innodb_support_xa 920 93SET @@global.innodb_support_xa = �FF; 94ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of '�FF' 95'#-------------------FN_DYNVARS_046_05----------------------------#' 96SET @@global.innodb_support_xa = 0; 97SET @@session.innodb_support_xa = 1; 98SELECT @@global.innodb_support_xa AS res_is_0; 99res_is_0 1000 101SET @@global.innodb_support_xa = 0; 102SELECT @@session.innodb_support_xa AS res_is_1; 103res_is_1 1041 105'#----------------------FN_DYNVARS_046_06------------------------#' 106SELECT IF(@@global.innodb_support_xa, "ON", "OFF") = 107VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 108WHERE VARIABLE_NAME='innodb_support_xa'; 109IF(@@global.innodb_support_xa, "ON", "OFF") = 110VARIABLE_VALUE 1111 112SELECT @@global.innodb_support_xa; 113@@global.innodb_support_xa 1140 115SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 116WHERE VARIABLE_NAME='innodb_support_xa'; 117VARIABLE_VALUE 118OFF 119'#----------------------FN_DYNVARS_046_07------------------------#' 120SELECT IF(@@session.innodb_support_xa, "ON", "OFF") = 121VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 122WHERE VARIABLE_NAME='innodb_support_xa'; 123IF(@@session.innodb_support_xa, "ON", "OFF") = 124VARIABLE_VALUE 1251 126SELECT @@session.innodb_support_xa; 127@@session.innodb_support_xa 1281 129SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 130WHERE VARIABLE_NAME='innodb_support_xa'; 131VARIABLE_VALUE 132ON 133'#---------------------FN_DYNVARS_046_08-------------------------#' 134SET @@session.innodb_support_xa = OFF; 135SELECT @@session.innodb_support_xa; 136@@session.innodb_support_xa 1370 138SET @@session.innodb_support_xa = ON; 139SELECT @@session.innodb_support_xa; 140@@session.innodb_support_xa 1411 142SET @@global.innodb_support_xa = OFF; 143SELECT @@global.innodb_support_xa; 144@@global.innodb_support_xa 1450 146SET @@global.innodb_support_xa = ON; 147SELECT @@global.innodb_support_xa; 148@@global.innodb_support_xa 1491 150'#---------------------FN_DYNVARS_046_09----------------------#' 151SET @@session.innodb_support_xa = TRUE; 152SELECT @@session.innodb_support_xa; 153@@session.innodb_support_xa 1541 155SET @@session.innodb_support_xa = FALSE; 156SELECT @@session.innodb_support_xa; 157@@session.innodb_support_xa 1580 159SET @@global.innodb_support_xa = TRUE; 160SELECT @@global.innodb_support_xa; 161@@global.innodb_support_xa 1621 163SET @@global.innodb_support_xa = FALSE; 164SELECT @@global.innodb_support_xa; 165@@global.innodb_support_xa 1660 167SET @@session.innodb_support_xa = @session_start_value; 168SELECT @@session.innodb_support_xa; 169@@session.innodb_support_xa 1701 171SET @@global.innodb_support_xa = @global_start_value; 172SELECT @@global.innodb_support_xa; 173@@global.innodb_support_xa 1741 175