Debian Codegraph @

mysql-test/suite/sys_vars/r/transaction_isolation_basic.result

raw
1 SET @global_start_value = @@global.transaction_isolation;
2 SELECT @global_start_value;
3 @global_start_value
4 REPEATABLE-READ
5 SET @session_start_value = @@session.transaction_isolation;
6 SELECT @session_start_value;
7 @session_start_value
8 REPEATABLE-READ
9 '#--------------------FN_DYNVARS_183_01------------------------#'
10 SET @@global.transaction_isolation = 'READ-UNCOMMITTED';
11 SET @@global.transaction_isolation = DEFAULT;
12 SELECT @@global.transaction_isolation;
13 @@global.transaction_isolation
14 REPEATABLE-READ
15 SET @@session.transaction_isolation = DEFAULT;
16 SELECT @@session.transaction_isolation;
17 @@session.transaction_isolation
18 REPEATABLE-READ
19 '#---------------------FN_DYNVARS_183_02-------------------------#'
20 SET @@global.transaction_isolation = NULL;
21 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of 'NULL'
22 SET @@global.transaction_isolation = '';
23 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of ''
24 SET @@session.transaction_isolation = NULL;
25 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of 'NULL'
26 SET @@session.transaction_isolation = '';
27 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of ''
28 '#--------------------FN_DYNVARS_183_03------------------------#'
29 SET @@global.transaction_isolation = 'READ-UNCOMMITTED';
30 SELECT @@global.transaction_isolation;
31 @@global.transaction_isolation
32 READ-UNCOMMITTED
33 SET @@global.transaction_isolation = 'read-COMMITTED';
34 SELECT @@global.transaction_isolation;
35 @@global.transaction_isolation
36 READ-COMMITTED
37 SET @@global.transaction_isolation = 'REPEATABLE-READ';
38 SELECT @@global.transaction_isolation;
39 @@global.transaction_isolation
40 REPEATABLE-READ
41 SET @@global.transaction_isolation = 'SERIALIZable';
42 SELECT @@global.transaction_isolation;
43 @@global.transaction_isolation
44 SERIALIZABLE
45 SET @@session.transaction_isolation = 'READ-UNCOMMITTED';
46 SELECT @@session.transaction_isolation;
47 @@session.transaction_isolation
48 READ-UNCOMMITTED
49 SET @@session.transaction_isolation = 'READ-COMMITTED';
50 SELECT @@session.transaction_isolation;
51 @@session.transaction_isolation
52 READ-COMMITTED
53 SET @@session.transaction_isolation = 'REPEATABLE-READ';
54 SELECT @@session.transaction_isolation;
55 @@session.transaction_isolation
56 REPEATABLE-READ
57 SET @@session.transaction_isolation = 'serializable';
58 SELECT @@session.transaction_isolation;
59 @@session.transaction_isolation
60 SERIALIZABLE
61 '#--------------------FN_DYNVARS_183_04-------------------------#'
62 SET @@global.transaction_isolation = -1;
63 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of '-1'
64 SET @@global.transaction_isolation = READUNCOMMITTED;
65 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of 'READUNCOMMITTED'
66 SET @@global.transaction_isolation = 'REPEATABLE';
67 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of 'REPEATABLE'
68 SET @@global.transaction_isolation = OFF;
69 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of 'OFF'
70 SET @@global.transaction_isolation = ON;
71 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of 'ON'
72 SET @@global.transaction_isolation = 'NON-SERIALIZABLE';
73 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of 'NON-SERIALIZABLE'
74 SET @@transaction_isolation = -1;
75 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of '-1'
76 SET @@transaction_isolation = READUNCOMMITTED;
77 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of 'READUNCOMMITTED'
78 SET @@transaction_isolation = 'REPEATABLE';
79 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of 'REPEATABLE'
80 SET @@transaction_isolation = 'NONE';
81 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of 'NONE'
82 SET @@transaction_isolation = 'ALL';
83 ERROR 42000: Variable 'transaction_isolation' can't be set to the value of 'ALL'
84 '#-------------------FN_DYNVARS_183_05----------------------------#'
85 SELECT @@session.transaction_isolation = VARIABLE_VALUE
86 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
87 WHERE VARIABLE_NAME='transaction_isolation';
88 @@session.transaction_isolation = VARIABLE_VALUE
89 1
90 '#----------------------FN_DYNVARS_183_06------------------------#'
91 SELECT @@global.transaction_isolation = VARIABLE_VALUE
92 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
93 WHERE VARIABLE_NAME='transaction_isolation';
94 @@global.transaction_isolation = VARIABLE_VALUE
95 1
96 '#---------------------FN_DYNVARS_183_07-------------------------#'
97 SET @@global.transaction_isolation = 0;
98 SELECT @@global.transaction_isolation;
99 @@global.transaction_isolation
100 READ-UNCOMMITTED
101 SET @@global.transaction_isolation = 1;
102 SELECT @@global.transaction_isolation;
103 @@global.transaction_isolation
104 READ-COMMITTED
105 SET @@global.transaction_isolation = 2;
106 SELECT @@global.transaction_isolation;
107 @@global.transaction_isolation
108 REPEATABLE-READ
109 SET @@global.transaction_isolation = 3;
110 SELECT @@global.transaction_isolation;
111 @@global.transaction_isolation
112 SERIALIZABLE
113 SET @@global.transaction_isolation = 0.4;
114 ERROR 42000: Incorrect argument type to variable 'transaction_isolation'
115 '#---------------------FN_DYNVARS_183_08----------------------#'
116 SET @@global.transaction_isolation = TRUE;
117 SELECT @@global.transaction_isolation;
118 @@global.transaction_isolation
119 READ-COMMITTED
120 SET @@global.transaction_isolation = FALSE;
121 SELECT @@global.transaction_isolation;
122 @@global.transaction_isolation
123 READ-UNCOMMITTED
124 '#---------------------FN_DYNVARS_183_09----------------------#'
125 SET transaction_isolation = 'REPEATABLE-READ';
126 SET session transaction_isolation = 'REPEATABLE-READ';
127 SELECT @@transaction_isolation;
128 @@transaction_isolation
129 REPEATABLE-READ
130 SET global transaction_isolation = 'REPEATABLE-READ';
131 SELECT @@global.transaction_isolation;
132 @@global.transaction_isolation
133 REPEATABLE-READ
134 SET @@global.transaction_isolation = @global_start_value;
135 SELECT @@global.transaction_isolation;
136 @@global.transaction_isolation
137 REPEATABLE-READ
138 SET @@session.transaction_isolation = @session_start_value;
139 SELECT @@session.transaction_isolation;
140 @@session.transaction_isolation
141 REPEATABLE-READ