Debian Codegraph @

mysql-test/suite/binlog_gtid/t/binlog_gtid_errors.test

raw
1 # ==== Purpose ====
2 #
3 # Test errors/restrictions/conditions for the following variables:
4 #
5 # - GTID_EXECUTED
6 # - readable, read-only, global only
7 # - GTID_PURGED
8 # - readable, read-only, global only
9 # - GTID_OWNED
10 # - readable, read-only, both session and global
11 # - GTID_NEXT
12 # - read-writable, session only
13 # - must be set to UUID:NUMBER or AUTOMATIC (when gtid_mode=ON)
14 # - only settable by SUPER
15 # - not settable from sub-statement
16 # - not settable from statement that also invokes sub-statement
17 # - not settable inside transaction
18 # - not settable when some gtid is owned
19 #
20 # Note: some variables related to GTIDs are tested in other files:
21 # GTID_MODE - rpl_gtid_mode.test
22 # ENFORCE_GTID_CONSISTENCY - binlog_enforce_gtid_consistency.test
23 # GTID_PURGED - rpl_gtid_purged_*.test
24 #
25 # ==== Implementation ====
26 #
27 # Just try all possibilities, verify that the correct error message is
28 # given.
29 #
30 # ==== References ====
31 #
32 # Implemented in WL#3584: Global Transaction Identifiers
33 # Bug#20343644 ASSERTION AT BINLOG.CC:1120 WHEN GTID_MODE=ON, GTID_NEXT='UUID:NUMBER'
34
35 --source include/have_log_bin.inc
36 --source include/have_debug.inc
37
38 # Clean gtid_executed so that test can execute after other tests
39 RESET MASTER;
40
41 --let $ida= aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa
42 --let $idb= bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb
43 --let $idc= cccccccc-cccc-cccc-cccc-cccccccccccc
44 --let $idd= dddddddd-dddd-dddd-dddd-dddddddddddd
45 --let $ide= eeeeeeee-eeee-eeee-eeee-eeeeeeeeeeee
46 --let $idf= ffffffff-ffff-ffff-ffff-ffffffffffff
47 --let $tab= `SELECT '\t'`
48
49 --echo ==== Conditions for gtid_executed ====
50
51 --echo # Readable.
52 --replace_regex /[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}:[0-9-]*//
53 SELECT @@GLOBAL.GTID_EXECUTED;
54 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
55 SELECT @@SESSION.GTID_EXECUTED;
56 --echo # Read-only.
57 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
58 eval SET @@GLOBAL.GTID_EXECUTED= '$ida:1';
59 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
60 eval SET @@SESSION.GTID_EXECUTED= '$ida:2';
61
62 --echo ==== Conditions for gtid_purged ====
63
64 --echo # Readable global variable
65 --replace_regex /[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}:[0-9-]*//
66 SELECT @@GLOBAL.GTID_PURGED;
67 --echo # Not a session variable
68 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
69 SELECT @@SESSION.GTID_PURGED;
70 --echo # Read-only.
71 --error ER_GLOBAL_VARIABLE
72 eval SET @@SESSION.GTID_PURGED= '$ida:3';
73
74 --echo ==== Conditions for gtid_owned ====
75
76 --echo # Readable.
77 SELECT @@GLOBAL.GTID_OWNED;
78 SELECT @@SESSION.GTID_OWNED;
79 --echo # Read-only.
80 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
81 eval SET @@SESSION.GTID_OWNED= '$ida:5';
82 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
83 eval SET @@GLOBAL.GTID_OWNED= '$ida:6#1';
84
85 --echo ==== Valid and invalid values for gtid_next ====
86
87 --echo # Default should be AUTOMATIC
88 SELECT @@SESSION.GTID_NEXT;
89
90 SET @@SESSION.GTID_NEXT= 'AUTOMATIC';
91 SELECT @@SESSION.GTID_NEXT;
92
93 eval SET @@SESSION.GTID_NEXT= '$ida:10';
94 SELECT @@SESSION.GTID_NEXT;
95 ROLLBACK;
96
97 eval SET @@SESSION.GTID_NEXT= '
98 $ida $tab : $tab 10
99 ';
100 SELECT @@SESSION.GTID_NEXT;
101 ROLLBACK;
102
103 eval SET @@SESSION.GTID_NEXT= '$ida:0x10';
104 SELECT @@SESSION.GTID_NEXT;
105 ROLLBACK;
106
107 eval SET @@SESSION.GTID_NEXT= '$ida:010';
108 SELECT @@SESSION.GTID_NEXT;
109 ROLLBACK;
110
111 SET @@SESSION.GTID_NEXT= 'AUTOMATIC';
112
113 --error ER_MALFORMED_GTID_SPECIFICATION
114 eval SET @@SESSION.GTID_NEXT= '$ida:10#';
115 SELECT @@SESSION.GTID_NEXT;
116
117 --error ER_MALFORMED_GTID_SPECIFICATION
118 eval SET @@SESSION.GTID_NEXT= '$ida:1-10';
119 SELECT @@SESSION.GTID_NEXT;
120
121 --error ER_MALFORMED_GTID_SPECIFICATION
122 eval SET @@SESSION.GTID_NEXT= '$ida:1:3';
123 SELECT @@SESSION.GTID_NEXT;
124
125 --error ER_MALFORMED_GTID_SPECIFICATION
126 eval SET @@SESSION.GTID_NEXT= '$ida:1,$ida:3';
127 SELECT @@SESSION.GTID_NEXT;
128
129 --error ER_WRONG_VALUE_FOR_VAR
130 SET @@SESSION.GTID_NEXT= NULL;
131 SELECT @@SESSION.GTID_NEXT;
132
133 --error ER_WRONG_TYPE_FOR_VAR
134 SET @@SESSION.GTID_NEXT= 10;
135 SELECT @@SESSION.GTID_NEXT;
136
137 --error ER_MALFORMED_GTID_SPECIFICATION
138 SET @@SESSION.GTID_NEXT= '10';
139 SELECT @@SESSION.GTID_NEXT;
140
141 --error ER_MALFORMED_GTID_SPECIFICATION
142 eval SET @@SESSION.GTID_NEXT= '$ida:';
143 SELECT @@SESSION.GTID_NEXT;
144
145 --error ER_MALFORMED_GTID_SPECIFICATION
146 eval SET @@SESSION.GTID_NEXT= '$ida:0';
147 SELECT @@SESSION.GTID_NEXT;
148
149 --error ER_MALFORMED_GTID_SPECIFICATION
150 eval SET @@SESSION.GTID_NEXT= '$ida:0x8000000000000000';
151 SELECT @@SESSION.GTID_NEXT;
152
153 --error ER_MALFORMED_GTID_SPECIFICATION
154 eval SET @@SESSION.GTID_NEXT= '$ida:-33';
155 SELECT @@SESSION.GTID_NEXT;
156
157 --error ER_MALFORMED_GTID_SPECIFICATION
158 eval SET @@SESSION.GTID_NEXT= '$ida:66-33';
159 SELECT @@SESSION.GTID_NEXT;
160
161 --error ER_MALFORMED_GTID_SPECIFICATION
162 eval SET @@SESSION.GTID_NEXT= '$ida:33 33';
163 SELECT @@SESSION.GTID_NEXT;
164
165 --error ER_MALFORMED_GTID_SPECIFICATION
166 eval SET @@SESSION.GTID_NEXT= '$ida-33';
167 SELECT @@SESSION.GTID_NEXT;
168
169 --echo ==== Conditions for gtid_next ====
170
171 --echo # Initialize
172 --eval CREATE FUNCTION f() RETURNS INT BEGIN RETURN 1; END
173 CREATE TABLE t1 (a INT) ENGINE = InnoDB;
174 CREATE USER nonsuper@localhost;
175 GRANT SELECT ON *.* TO nonsuper@localhost;
176 --connect (nonsuper,localhost,nonsuper,,)
177 --connection default
178
179 --echo # Read/write session
180 SELECT @@SESSION.GTID_NEXT;
181 eval SET @@SESSION.GTID_NEXT= '$ida:7';
182 ROLLBACK;
183 --echo # not global
184 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
185 SELECT @@GLOBAL.GTID_NEXT;
186 --error ER_LOCAL_VARIABLE
187 eval SET @@GLOBAL.GTID_NEXT= '$ida:8';
188 ROLLBACK;
189 SET GTID_NEXT = 'AUTOMATIC';
190
191 --echo # Can't set value from stored function
192 --eval CREATE FUNCTION set_var() RETURNS INT BEGIN SET @@SESSION.GTID_NEXT = '$ida:9'; RETURN 1; END
193 --error ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
194 SELECT set_var();
195 DROP FUNCTION set_var;
196
197 --echo # Can't set value from trigger
198 eval CREATE TRIGGER t BEFORE INSERT ON t1 FOR EACH ROW SET @@SESSION.GTID_NEXT = '$ida:10';
199 --error ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
200 INSERT INTO t1 VALUES (1);
201 DROP TRIGGER t;
202
203 --echo # Can't set value when invoking SF
204 --error ER_SET_STATEMENT_CANNOT_INVOKE_FUNCTION
205 SET @@SESSION.GTID_NEXT = f();
206
207 --echo # must be SUPER
208 --connection nonsuper
209 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
210 eval SET @@SESSION.GTID_NEXT = '$ida:11';
211
212 --echo # can read even if non-SUPER
213 SELECT @@SESSION.GTID_NEXT;
214 --connection default
215
216 --echo # can't set inside transaction
217 BEGIN;
218 --error ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
219 eval SET @@SESSION.GTID_NEXT = '$ida:12';
220 INSERT INTO t1 VALUES (4);
221 ROLLBACK;
222
223 --echo # can't set while owning a GTID
224 eval SET @@SESSION.GTID_NEXT = '$ida:13';
225 --error ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID
226 eval SET @@SESSION.GTID_NEXT = '$ida:14';
227 # the above error will clean owned_gtid
228 eval SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
229 ROLLBACK;
230
231 --echo # can't set while owning a GTID
232 eval SET @@SESSION.GTID_NEXT = '$ida:13';
233 --error ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID
234 eval SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
235 ROLLBACK;
236
237 --echo # Can't set while owning ANONYMOUS
238 --let $rpl_gtid_mode= OFF
239 --source include/rpl_set_gtid_mode.inc
240
241 SET GTID_NEXT = 'ANONYMOUS';
242 --error ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID
243 SET GTID_NEXT = 'ANONYMOUS';
244
245 SET GTID_NEXT = 'ANONYMOUS';
246 --error ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID
247 eval SET GTID_NEXT = '$ida:1';
248
249 SET GTID_NEXT = 'ANONYMOUS';
250 --error ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID
251 SET GTID_NEXT = 'AUTOMATIC';
252
253 SET GTID_NEXT = 'AUTOMATIC';
254
255 --let $rpl_gtid_mode= ON
256 --source include/rpl_set_gtid_mode.inc
257
258 eval SET @@SESSION.GTID_NEXT = '$ida:14';
259 --echo # can't do implicit commit while gtid_next=SID:GNO
260 BEGIN;
261 --error ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET
262 CREATE TABLE t2 (a INT);
263 ROLLBACK;
264
265 # ==== Purpose ====
266 #
267 # Verify that we can succeed to commit a transaction with a specified gtid,
268 # even if an error is caused by executing the statement 'CREATE TABLE'
269 # in the middle.
270 #
271 # ==== References ====
272 #
273 # Bug#20343644 ASSERTION AT BINLOG.CC:1120 WHEN GTID_MODE=ON, GTID_NEXT='UUID:NUMBER'
274
275 eval SET @@SESSION.GTID_NEXT= '$ida:15';
276 BEGIN;
277 INSERT INTO t1 VALUES (1);
278 --error ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET
279 CREATE TABLE t2 (a INT);
280 COMMIT;
281
282 # ==== Purpose ====
283 #
284 # Verify that we can succeed to commit a transaction with a specified gtid,
285 # even if an error is caused by executing the statement 'CREATE..SELECT'
286 # in the middle. The CREATE..SELECT using non-transactional engine are
287 # expected to fail with ER_GTID_UNSAFE_CREATE_SELECT.
288 #
289 # ==== References ====
290 #
291 # Bug#20444828 WL7592: ASSERT `THD->VARIABLES.GTID_NEXT.TYPE == GTID_GROUP' ON CREATE..SELECT
292
293 --eval SET @@SESSION.GTID_NEXT= '$ida:16'
294 --error ER_GTID_UNSAFE_CREATE_SELECT
295 CREATE TABLE t2 ENGINE=MyISAM AS SELECT * FROM t1;
296 COMMIT;
297
298 eval SET @@SESSION.GTID_NEXT = '$ida:17';
299 --echo # can't do implicit commit while gtid_next=SID:GNO
300 SET AUTOCOMMIT = 0;
301 INSERT INTO t1 VALUES (1);
302 --error ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET
303 CREATE TABLE t2 (a INT);
304 ROLLBACK;
305
306 SELECT @@SESSION.GTID_NEXT;
307 eval SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
308
309 DROP TABLE t1;
310 DROP FUNCTION f;
311 DROP USER nonsuper@localhost;
312
313 # It is (unfortunately) possible to set the value from a stored
314 # procedure. No user should do this, it's just weird, but was hard
315 # to prevent so instead we allow it. Although this is unsupported, we
316 # have to check that at least there is no crash.
317 --delimiter |
318 eval CREATE PROCEDURE p ()
319 BEGIN
320 SET @@SESSION.GTID_NEXT = '$ida:16';
321 ROLLBACK;
322 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
323 END|
324 --delimiter ;
325 CALL p();
326 DROP PROCEDURE p;