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