1'#--------------------begin------------------------#' 2SET @session_start_value = @@session.tokudb_support_xa; 3SELECT @session_start_value; 4@session_start_value 51 6SET @global_start_value = @@global.tokudb_support_xa; 7SELECT @global_start_value; 8@global_start_value 91 10SET @@session.tokudb_support_xa = 0; 11SET @@session.tokudb_support_xa = DEFAULT; 12SELECT @@session.tokudb_support_xa; 13@@session.tokudb_support_xa 141 15SET @@global.tokudb_support_xa = 0; 16SET @@global.tokudb_support_xa = DEFAULT; 17SELECT @@global.tokudb_support_xa; 18@@global.tokudb_support_xa 191 20'#--------------------case#1 valid set support_xa------------------------#' 21SET @@session.tokudb_support_xa = 0; 22SELECT @@session.tokudb_support_xa; 23@@session.tokudb_support_xa 240 25SET @@session.tokudb_support_xa = 1; 26SELECT @@session.tokudb_support_xa; 27@@session.tokudb_support_xa 281 29SET @@global.tokudb_support_xa = 0; 30SELECT @@global.tokudb_support_xa; 31@@global.tokudb_support_xa 320 33SET @@global.tokudb_support_xa = 1; 34SELECT @@global.tokudb_support_xa; 35@@global.tokudb_support_xa 361 37'#--------------------case#2 invalid set support_xa------------------------#' 38SET @@session.tokudb_support_xa = -0.6; 39ERROR 42000: Incorrect argument type to variable 'tokudb_support_xa' 40SET @@session.tokudb_support_xa = 1.6; 41ERROR 42000: Incorrect argument type to variable 'tokudb_support_xa' 42SET @@session.tokudb_support_xa = "T"; 43ERROR 42000: Variable 'tokudb_support_xa' can't be set to the value of 'T' 44SET @@session.tokudb_support_xa = "Y"; 45ERROR 42000: Variable 'tokudb_support_xa' can't be set to the value of 'Y' 46SET @@session.tokudb_support_xa = OFF; 47SELECT @@session.tokudb_support_xa; 48@@session.tokudb_support_xa 490 50SET @@global.tokudb_support_xa = 2; 51ERROR 42000: Variable 'tokudb_support_xa' can't be set to the value of '2' 52SET @@global.tokudb_support_xa = "T"; 53ERROR 42000: Variable 'tokudb_support_xa' can't be set to the value of 'T' 54SET @@global.tokudb_support_xa = "Y"; 55ERROR 42000: Variable 'tokudb_support_xa' can't be set to the value of 'Y' 56'#--------------------case#3 xa.test port from tokudb_mariadb/xa.test ------------------------#' 57'#--------------------xa.test with tokudb_support_xa OFF ------------------------#' 58SET @@global.tokudb_support_xa = OFF; 59SELECT @@global.tokudb_support_xa; 60@@global.tokudb_support_xa 610 62create table t1 (a int) engine=tokudb; 63xa start 'test1'; 64insert t1 values (10); 65xa end 'test1'; 66xa prepare 'test1'; 67xa rollback 'test1'; 68select * from t1; 69a 70xa start 'test2'; 71xa start 'test-bad'; 72ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state 73insert t1 values (20); 74xa prepare 'test2'; 75ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state 76xa end 'test2'; 77xa prepare 'test2'; 78xa commit 'test2'; 79select * from t1; 80a 8120 82xa start 'testa','testb'; 83insert t1 values (30); 84commit; 85ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state 86xa end 'testa','testb'; 87begin; 88ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state 89create table t2 (a int); 90ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state 91connect con1,localhost,root,,; 92connection con1; 93xa start 'testa','testb'; 94ERROR XAE08: XAER_DUPID: The XID already exists 95xa start 'testa','testb', 123; 96ERROR XAE08: XAER_DUPID: The XID already exists 97xa start 0x7465737462, 0x2030405060, 0xb; 98insert t1 values (40); 99xa end 'testb',' 0@P`',11; 100xa prepare 'testb',0x2030405060,11; 101start transaction; 102ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state 103xa recover; 104formatID gtrid_length bqual_length data 10511 5 5 testb 0@P` 106connection default; 107xa prepare 'testa','testb'; 108xa recover; 109formatID gtrid_length bqual_length data 11011 5 5 testb 0@P` 1111 5 5 testatestb 112xa commit 'testb',0x2030405060,11; 113ERROR XAE04: XAER_NOTA: Unknown XID 114xa rollback 'testa','testb'; 115xa start 'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz'; 116ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your XYZ server version for the right syntax to use near '' at line 1 117select * from t1; 118a 11920 120disconnect con1; 121connection default; 122drop table t1; 123'#--------------------end------------------------#' 124SET @@session.tokudb_support_xa = @session_start_value; 125SELECT @@session.tokudb_support_xa; 126@@session.tokudb_support_xa 1271 128SET @@global.tokudb_support_xa = @global_start_value; 129SELECT @@global.tokudb_support_xa; 130@@global.tokudb_support_xa 1311 132