1
SET @global_start_value = @@global.tx_isolation;
2
SELECT @global_start_value;
5
SET @session_start_value = @@session.tx_isolation;
6
SELECT @session_start_value;
9
'#--------------------FN_DYNVARS_183_01------------------------#'
10
SET @@global.tx_isolation = 'READ-UNCOMMITTED';
11
SET @@global.tx_isolation = DEFAULT;
12
ERROR 42000: Variable 'tx_isolation' doesn't have a default value
13
'Bug# 34878: Documentation specifies a DEFAULT value of REPEATABLE-READ';
14
'where as DEFAULT is not supported here.';
15
SET @@session.tx_isolation = 'SERIALIZABLE';
16
SET @@session.tx_isolation = DEFAULT;
17
SELECT @@session.tx_isolation;
18
@@session.tx_isolation
20
'Bug# 34876: Documentation specifies a DEFAULT value of REPEATABLE-READ';
21
'where as DEFAULT here as no effect.';
22
'#---------------------FN_DYNVARS_183_02-------------------------#'
23
SET @@global.tx_isolation = NULL;
24
ERROR 42000: Variable 'tx_isolation' can't be set to the value of 'NULL'
25
SET @@global.tx_isolation = '';
26
ERROR 42000: Variable 'tx_isolation' can't be set to the value of ''
27
SET @@session.tx_isolation = NULL;
28
ERROR 42000: Variable 'tx_isolation' can't be set to the value of 'NULL'
29
SET @@session.tx_isolation = '';
30
ERROR 42000: Variable 'tx_isolation' can't be set to the value of ''
31
'#--------------------FN_DYNVARS_183_03------------------------#'
32
SET @@global.tx_isolation = 'READ-UNCOMMITTED';
33
SELECT @@global.tx_isolation;
36
SET @@global.tx_isolation = 'read-COMMITTED';
37
SELECT @@global.tx_isolation;
40
SET @@global.tx_isolation = 'REPEATABLE-READ';
41
SELECT @@global.tx_isolation;
44
SET @@global.tx_isolation = 'SERIALIZable';
45
SELECT @@global.tx_isolation;
48
SET @@session.tx_isolation = 'READ-UNCOMMITTED';
49
SELECT @@session.tx_isolation;
50
@@session.tx_isolation
52
SET @@session.tx_isolation = 'READ-COMMITTED';
53
SELECT @@session.tx_isolation;
54
@@session.tx_isolation
56
SET @@session.tx_isolation = 'REPEATABLE-READ';
57
SELECT @@session.tx_isolation;
58
@@session.tx_isolation
60
SET @@session.tx_isolation = 'serializable';
61
SELECT @@session.tx_isolation;
62
@@session.tx_isolation
64
'#--------------------FN_DYNVARS_183_04-------------------------#'
65
SET @@global.tx_isolation = -1;
66
ERROR 42000: Variable 'tx_isolation' can't be set to the value of '-1'
67
SET @@global.tx_isolation = READUNCOMMITTED;
68
ERROR 42000: Variable 'tx_isolation' can't be set to the value of 'READUNCOMMITTED'
69
SET @@global.tx_isolation = 'REPEATABLE';
70
SELECT @@global.tx_isolation;
73
'Bug# 34833: REPEATABLE is not documented as as valid tx_isolation level'
74
SET @@global.tx_isolation = OFF;
75
ERROR 42000: Variable 'tx_isolation' can't be set to the value of 'OFF'
76
SET @@global.tx_isolation = ON;
77
ERROR 42000: Variable 'tx_isolation' can't be set to the value of 'ON'
78
SET @@global.tx_isolation = 'NON-SERIALIZABLE';
79
ERROR 42000: Variable 'tx_isolation' can't be set to the value of 'NON-SERIALIZABLE'
80
SET @@tx_isolation = -1;
81
ERROR 42000: Variable 'tx_isolation' can't be set to the value of '-1'
82
SET @@tx_isolation = READUNCOMMITTED;
83
ERROR 42000: Variable 'tx_isolation' can't be set to the value of 'READUNCOMMITTED'
84
SET @@tx_isolation = 'REPEATABLE';
85
SELECT @@tx_isolation;
88
'Bug# 34833: REPEATABLE is not documented as as valid tx_isolation level'
89
SET @@tx_isolation = 'NONE';
90
ERROR 42000: Variable 'tx_isolation' can't be set to the value of 'NONE'
91
SET @@tx_isolation = 'ALL';
92
ERROR 42000: Variable 'tx_isolation' can't be set to the value of 'ALL'
93
'#-------------------FN_DYNVARS_183_05----------------------------#'
94
SELECT @@session.tx_isolation = VARIABLE_VALUE
95
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
96
WHERE VARIABLE_NAME='tx_isolation';
97
@@session.tx_isolation = VARIABLE_VALUE
99
'#----------------------FN_DYNVARS_183_06------------------------#'
100
SELECT @@global.tx_isolation = VARIABLE_VALUE
101
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
102
WHERE VARIABLE_NAME='tx_isolation';
103
@@global.tx_isolation = VARIABLE_VALUE
105
'#---------------------FN_DYNVARS_183_07-------------------------#'
106
SET @@global.tx_isolation = 0;
107
SELECT @@global.tx_isolation;
108
@@global.tx_isolation
110
SET @@global.tx_isolation = 1;
111
SELECT @@global.tx_isolation;
112
@@global.tx_isolation
114
SET @@global.tx_isolation = 2;
115
SELECT @@global.tx_isolation;
116
@@global.tx_isolation
118
SET @@global.tx_isolation = 3;
119
SELECT @@global.tx_isolation;
120
@@global.tx_isolation
122
SET @@global.tx_isolation = 0.4;
123
SELECT @@global.tx_isolation;
124
@@global.tx_isolation
126
SET @@global.tx_isolation = 1.1;
127
SELECT @@global.tx_isolation;
128
@@global.tx_isolation
130
SET @@global.tx_isolation = 1.5;
131
SELECT @@global.tx_isolation;
132
@@global.tx_isolation
134
SET @@global.tx_isolation = 2.9;
135
SELECT @@global.tx_isolation;
136
@@global.tx_isolation
138
SET @@session.tx_isolation = 3.49;
139
SELECT @@session.tx_isolation;
140
@@session.tx_isolation
142
SET @@session.tx_isolation = 3.6;
143
ERROR 42000: Variable 'tx_isolation' can't be set to the value of '4'
144
'Bug: Decimal values can be used within the range [0.0-3.5).';
145
'Values are rounded to 0,1,2,3 as evident from outcome.';
146
'#---------------------FN_DYNVARS_183_08----------------------#'
147
SET @@global.tx_isolation = TRUE;
148
SELECT @@global.tx_isolation;
149
@@global.tx_isolation
151
SET @@global.tx_isolation = FALSE;
152
SELECT @@global.tx_isolation;
153
@@global.tx_isolation
155
'#---------------------FN_DYNVARS_183_09----------------------#'
156
SET tx_isolation = 'REPEATABLE-READ';
157
SET session.tx_isolation = 'REPEATABLE-READ';
158
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tx_isolation = 'REPEATABLE-READ'' at line 1
159
SET global.tx_isolation = 'REPEATABLE-READ';
160
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tx_isolation = 'REPEATABLE-READ'' at line 1
161
SET session tx_isolation = 'REPEATABLE-READ';
162
SELECT @@tx_isolation;
165
SET global tx_isolation = 'REPEATABLE-READ';
166
SELECT @@global.tx_isolation;
167
@@global.tx_isolation
169
SET @@global.tx_isolation = @global_start_value;
170
SELECT @@global.tx_isolation;
171
@@global.tx_isolation
173
SET @@session.tx_isolation = @session_start_value;
174
SELECT @@session.tx_isolation;
175
@@session.tx_isolation