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; 11Warnings: 12Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 13SET @@session.innodb_support_xa = DEFAULT; 14Warnings: 15Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. 16SELECT @@session.innodb_support_xa; 17@@session.innodb_support_xa 181 19SET @@global.innodb_support_xa = 0; 20Warnings: 21Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 22SET @@global.innodb_support_xa = DEFAULT; 23Warnings: 24Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. 25SELECT @@global.innodb_support_xa; 26@@global.innodb_support_xa 271 28'#---------------------FN_DYNVARS_046_02-------------------------#' 29SET innodb_support_xa = 1; 30Warnings: 31Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. 32SELECT @@innodb_support_xa; 33@@innodb_support_xa 341 35SELECT session.innodb_support_xa; 36ERROR 42S02: Unknown table 'session' in field list 37SELECT local.innodb_support_xa; 38ERROR 42S02: Unknown table 'local' in field list 39SELECT global.innodb_support_xa; 40ERROR 42S02: Unknown table 'global' in field list 41SET session innodb_support_xa = 0; 42Warnings: 43Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 44SELECT @@session.innodb_support_xa; 45@@session.innodb_support_xa 461 47SET global innodb_support_xa = 0; 48Warnings: 49Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 50SELECT @@global.innodb_support_xa; 51@@global.innodb_support_xa 521 53'#--------------------FN_DYNVARS_046_03------------------------#' 54SET @@session.innodb_support_xa = 0; 55Warnings: 56Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 57SELECT @@session.innodb_support_xa; 58@@session.innodb_support_xa 591 60SET @@session.innodb_support_xa = 1; 61Warnings: 62Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. 63SELECT @@session.innodb_support_xa; 64@@session.innodb_support_xa 651 66SET @@global.innodb_support_xa = 0; 67Warnings: 68Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 69SELECT @@global.innodb_support_xa; 70@@global.innodb_support_xa 711 72SET @@global.innodb_support_xa = 1; 73Warnings: 74Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. 75SELECT @@global.innodb_support_xa; 76@@global.innodb_support_xa 771 78'#--------------------FN_DYNVARS_046_04-------------------------#' 79SET @@session.innodb_support_xa = -0.6; 80ERROR 42000: Incorrect argument type to variable 'innodb_support_xa' 81SET @@session.innodb_support_xa = 1.6; 82ERROR 42000: Incorrect argument type to variable 'innodb_support_xa' 83SET @@session.innodb_support_xa = "T"; 84ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of 'T' 85SET @@session.innodb_support_xa = "Y"; 86ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of 'Y' 87SET @@session.innodb_support_xa = TR�E; 88ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of 'TR�E' 89SET @@session.innodb_support_xa = �N; 90ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of '�N' 91SET @@session.innodb_support_xa = OF; 92Warnings: 93Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 94SELECT @@session.innodb_support_xa; 95@@session.innodb_support_xa 961 97SET @@session.innodb_support_xa = �FF; 98ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of '�FF' 99SET @@global.innodb_support_xa = -1; 100ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of '-1' 101SELECT @@global.innodb_support_xa; 102@@global.innodb_support_xa 1031 104SET @@global.innodb_support_xa = 2; 105ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of '2' 106SET @@global.innodb_support_xa = "T"; 107ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of 'T' 108SET @@global.innodb_support_xa = "Y"; 109ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of 'Y' 110SET @@global.innodb_support_xa = TR�E; 111ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of 'TR�E' 112SET @@global.innodb_support_xa = �N; 113ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of '�N' 114SET @@global.innodb_support_xa = OF; 115Warnings: 116Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 117SELECT @@global.innodb_support_xa; 118@@global.innodb_support_xa 1191 120SET @@global.innodb_support_xa = �FF; 121ERROR 42000: Variable 'innodb_support_xa' can't be set to the value of '�FF' 122'#-------------------FN_DYNVARS_046_05----------------------------#' 123SET @@global.innodb_support_xa = 0; 124Warnings: 125Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 126SET @@session.innodb_support_xa = 1; 127Warnings: 128Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. 129SELECT @@global.innodb_support_xa AS res_is_0; 130res_is_0 1311 132SET @@global.innodb_support_xa = 0; 133Warnings: 134Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 135SELECT @@session.innodb_support_xa AS res_is_1; 136res_is_1 1371 138'#----------------------FN_DYNVARS_046_06------------------------#' 139SELECT IF(@@global.innodb_support_xa, "ON", "OFF") = 140VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 141WHERE VARIABLE_NAME='innodb_support_xa'; 142IF(@@global.innodb_support_xa, "ON", "OFF") = 143VARIABLE_VALUE 1441 145SELECT @@global.innodb_support_xa; 146@@global.innodb_support_xa 1471 148SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 149WHERE VARIABLE_NAME='innodb_support_xa'; 150VARIABLE_VALUE 151ON 152'#----------------------FN_DYNVARS_046_07------------------------#' 153SELECT IF(@@session.innodb_support_xa, "ON", "OFF") = 154VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 155WHERE VARIABLE_NAME='innodb_support_xa'; 156IF(@@session.innodb_support_xa, "ON", "OFF") = 157VARIABLE_VALUE 1581 159SELECT @@session.innodb_support_xa; 160@@session.innodb_support_xa 1611 162SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 163WHERE VARIABLE_NAME='innodb_support_xa'; 164VARIABLE_VALUE 165ON 166'#---------------------FN_DYNVARS_046_08-------------------------#' 167SET @@session.innodb_support_xa = OFF; 168Warnings: 169Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 170SELECT @@session.innodb_support_xa; 171@@session.innodb_support_xa 1721 173SET @@session.innodb_support_xa = ON; 174Warnings: 175Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. 176SELECT @@session.innodb_support_xa; 177@@session.innodb_support_xa 1781 179SET @@global.innodb_support_xa = OFF; 180Warnings: 181Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 182SELECT @@global.innodb_support_xa; 183@@global.innodb_support_xa 1841 185SET @@global.innodb_support_xa = ON; 186Warnings: 187Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. 188SELECT @@global.innodb_support_xa; 189@@global.innodb_support_xa 1901 191'#---------------------FN_DYNVARS_046_09----------------------#' 192SET @@session.innodb_support_xa = TRUE; 193Warnings: 194Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. 195SELECT @@session.innodb_support_xa; 196@@session.innodb_support_xa 1971 198SET @@session.innodb_support_xa = FALSE; 199Warnings: 200Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 201SELECT @@session.innodb_support_xa; 202@@session.innodb_support_xa 2031 204SET @@global.innodb_support_xa = TRUE; 205Warnings: 206Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. 207SELECT @@global.innodb_support_xa; 208@@global.innodb_support_xa 2091 210SET @@global.innodb_support_xa = FALSE; 211Warnings: 212Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. Only innodb_support_xa=ON is allowed. 213SELECT @@global.innodb_support_xa; 214@@global.innodb_support_xa 2151 216SET @@session.innodb_support_xa = @session_start_value; 217Warnings: 218Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. 219SELECT @@session.innodb_support_xa; 220@@session.innodb_support_xa 2211 222SET @@global.innodb_support_xa = @global_start_value; 223Warnings: 224Warning 131 Using innodb_support_xa is deprecated and the parameter may be removed in future releases. 225SELECT @@global.innodb_support_xa; 226@@global.innodb_support_xa 2271 228