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