Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_priv_checks_user_minimal.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 SET @@session.sql_log_bin = OFF;
7 CREATE TABLE t(c INT, d INT);
8 SET @@session.sql_log_bin = ON;
9 [connection slave]
10 CALL mtr.add_suppression(".*command denied to user.");
11 CALL mtr.add_suppression(".*the option binlog_row_value_options.*");
12 CALL mtr.add_suppression(".*The replica coordinator and worker threads are stopped.*");
13 CALL mtr.add_suppression(".*Replica worker thread has failed to apply an event. As a consequence, the coordinator*");
14 CREATE TABLE t(c INT, d INT);
15 #
16 # Running test for
17 # GRANT INSERT ON *.* TO ...
18 #
19 [connection master]
20 INSERT INTO t VALUES(10, 10);
21 include/save_master_pos.inc
22 [connection slave]
23 START SLAVE;
24 Warnings:
25 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
26 include/wait_for_slave_sql_error.inc [errno=1142]
27 STOP SLAVE;
28 Warnings:
29 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
30 GRANT INSERT ON *.* TO 'a_bigger_username_just_for_test';
31 START SLAVE;
32 Warnings:
33 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
34 include/sync_slave_sql.inc
35 REVOKE INSERT ON *.* FROM 'a_bigger_username_just_for_test';
36 STOP SLAVE;
37 Warnings:
38 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
39 include/diff_tables.inc [master:t, slave:t]
40 #
41 # Running test for
42 # GRANT UPDATE ON *.* TO ...
43 #
44 [connection master]
45 UPDATE t SET c = 12 WHERE c = 10;
46 include/save_master_pos.inc
47 [connection slave]
48 START SLAVE;
49 Warnings:
50 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
51 include/wait_for_slave_sql_error.inc [errno=1142]
52 STOP SLAVE;
53 Warnings:
54 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
55 GRANT UPDATE ON *.* TO 'a_bigger_username_just_for_test';
56 START SLAVE;
57 Warnings:
58 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
59 include/sync_slave_sql.inc
60 REVOKE UPDATE ON *.* FROM 'a_bigger_username_just_for_test';
61 STOP SLAVE;
62 Warnings:
63 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
64 include/diff_tables.inc [master:t, slave:t]
65 [connection slave]
66 SET @binlog_row_value_options_save= @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS;
67 SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= PARTIAL_JSON;
68 #
69 # Running test for
70 # GRANT UPDATE ON *.* TO ...
71 #
72 [connection master]
73 UPDATE t SET c = 8 WHERE c = 12;
74 include/save_master_pos.inc
75 [connection slave]
76 START SLAVE;
77 Warnings:
78 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
79 include/wait_for_slave_sql_error.inc [errno=1142]
80 STOP SLAVE;
81 Warnings:
82 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
83 GRANT UPDATE ON *.* TO 'a_bigger_username_just_for_test';
84 START SLAVE;
85 Warnings:
86 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
87 include/sync_slave_sql.inc
88 REVOKE UPDATE ON *.* FROM 'a_bigger_username_just_for_test';
89 STOP SLAVE;
90 Warnings:
91 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
92 SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= @binlog_row_value_options_save;
93 include/diff_tables.inc [master:t, slave:t]
94 #
95 # Running test for
96 # GRANT DELETE ON *.* TO ...
97 #
98 [connection master]
99 DELETE FROM t WHERE c = 8;
100 include/save_master_pos.inc
101 [connection slave]
102 START SLAVE;
103 Warnings:
104 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
105 include/wait_for_slave_sql_error.inc [errno=1142]
106 STOP SLAVE;
107 Warnings:
108 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
109 GRANT DELETE ON *.* TO 'a_bigger_username_just_for_test';
110 START SLAVE;
111 Warnings:
112 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
113 include/sync_slave_sql.inc
114 REVOKE DELETE ON *.* FROM 'a_bigger_username_just_for_test';
115 STOP SLAVE;
116 Warnings:
117 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
118 include/diff_tables.inc [master:t, slave:t]
119 #
120 # Running test for
121 # GRANT INSERT ON test.* TO ...
122 #
123 [connection master]
124 INSERT INTO t VALUES(10, 10);
125 include/save_master_pos.inc
126 [connection slave]
127 START SLAVE;
128 Warnings:
129 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
130 include/wait_for_slave_sql_error.inc [errno=1142]
131 STOP SLAVE;
132 Warnings:
133 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
134 GRANT INSERT ON test.* TO 'a_bigger_username_just_for_test';
135 START SLAVE;
136 Warnings:
137 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
138 include/sync_slave_sql.inc
139 REVOKE INSERT ON test.* FROM 'a_bigger_username_just_for_test';
140 STOP SLAVE;
141 Warnings:
142 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
143 include/diff_tables.inc [master:t, slave:t]
144 #
145 # Running test for
146 # GRANT UPDATE ON test.* TO ...
147 #
148 [connection master]
149 UPDATE t SET c = 12 WHERE c = 10;
150 include/save_master_pos.inc
151 [connection slave]
152 START SLAVE;
153 Warnings:
154 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
155 include/wait_for_slave_sql_error.inc [errno=1142]
156 STOP SLAVE;
157 Warnings:
158 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
159 GRANT UPDATE ON test.* TO 'a_bigger_username_just_for_test';
160 START SLAVE;
161 Warnings:
162 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
163 include/sync_slave_sql.inc
164 REVOKE UPDATE ON test.* FROM 'a_bigger_username_just_for_test';
165 STOP SLAVE;
166 Warnings:
167 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
168 include/diff_tables.inc [master:t, slave:t]
169 [connection slave]
170 SET @binlog_row_value_options_save= @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS;
171 SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= PARTIAL_JSON;
172 #
173 # Running test for
174 # GRANT UPDATE ON test.* TO ...
175 #
176 [connection master]
177 UPDATE t SET c = 8 WHERE c = 12;
178 include/save_master_pos.inc
179 [connection slave]
180 START SLAVE;
181 Warnings:
182 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
183 include/wait_for_slave_sql_error.inc [errno=1142]
184 STOP SLAVE;
185 Warnings:
186 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
187 GRANT UPDATE ON test.* TO 'a_bigger_username_just_for_test';
188 START SLAVE;
189 Warnings:
190 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
191 include/sync_slave_sql.inc
192 REVOKE UPDATE ON test.* FROM 'a_bigger_username_just_for_test';
193 STOP SLAVE;
194 Warnings:
195 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
196 SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= @binlog_row_value_options_save;
197 include/diff_tables.inc [master:t, slave:t]
198 #
199 # Running test for
200 # GRANT DELETE ON test.* TO ...
201 #
202 [connection master]
203 DELETE FROM t WHERE c = 8;
204 include/save_master_pos.inc
205 [connection slave]
206 START SLAVE;
207 Warnings:
208 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
209 include/wait_for_slave_sql_error.inc [errno=1142]
210 STOP SLAVE;
211 Warnings:
212 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
213 GRANT DELETE ON test.* TO 'a_bigger_username_just_for_test';
214 START SLAVE;
215 Warnings:
216 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
217 include/sync_slave_sql.inc
218 REVOKE DELETE ON test.* FROM 'a_bigger_username_just_for_test';
219 STOP SLAVE;
220 Warnings:
221 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
222 include/diff_tables.inc [master:t, slave:t]
223 #
224 # Running test for
225 # GRANT INSERT ON test.t TO ...
226 #
227 [connection master]
228 INSERT INTO t VALUES(10, 10);
229 include/save_master_pos.inc
230 [connection slave]
231 START SLAVE;
232 Warnings:
233 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
234 include/wait_for_slave_sql_error.inc [errno=1142]
235 STOP SLAVE;
236 Warnings:
237 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
238 GRANT INSERT ON test.t TO 'a_bigger_username_just_for_test';
239 START SLAVE;
240 Warnings:
241 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
242 include/sync_slave_sql.inc
243 REVOKE INSERT ON test.t FROM 'a_bigger_username_just_for_test';
244 STOP SLAVE;
245 Warnings:
246 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
247 include/diff_tables.inc [master:t, slave:t]
248 #
249 # Running test for
250 # GRANT UPDATE ON test.t TO ...
251 #
252 [connection master]
253 UPDATE t SET c = 12 WHERE c = 10;
254 include/save_master_pos.inc
255 [connection slave]
256 START SLAVE;
257 Warnings:
258 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
259 include/wait_for_slave_sql_error.inc [errno=1142]
260 STOP SLAVE;
261 Warnings:
262 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
263 GRANT UPDATE ON test.t TO 'a_bigger_username_just_for_test';
264 START SLAVE;
265 Warnings:
266 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
267 include/sync_slave_sql.inc
268 REVOKE UPDATE ON test.t FROM 'a_bigger_username_just_for_test';
269 STOP SLAVE;
270 Warnings:
271 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
272 include/diff_tables.inc [master:t, slave:t]
273 [connection slave]
274 SET @binlog_row_value_options_save= @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS;
275 SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= PARTIAL_JSON;
276 #
277 # Running test for
278 # GRANT UPDATE ON test.t TO ...
279 #
280 [connection master]
281 UPDATE t SET c = 8 WHERE c = 12;
282 include/save_master_pos.inc
283 [connection slave]
284 START SLAVE;
285 Warnings:
286 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
287 include/wait_for_slave_sql_error.inc [errno=1142]
288 STOP SLAVE;
289 Warnings:
290 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
291 GRANT UPDATE ON test.t TO 'a_bigger_username_just_for_test';
292 START SLAVE;
293 Warnings:
294 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
295 include/sync_slave_sql.inc
296 REVOKE UPDATE ON test.t FROM 'a_bigger_username_just_for_test';
297 STOP SLAVE;
298 Warnings:
299 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
300 SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= @binlog_row_value_options_save;
301 include/diff_tables.inc [master:t, slave:t]
302 #
303 # Running test for
304 # GRANT DELETE ON test.t TO ...
305 #
306 [connection master]
307 DELETE FROM t WHERE c = 8;
308 include/save_master_pos.inc
309 [connection slave]
310 START SLAVE;
311 Warnings:
312 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
313 include/wait_for_slave_sql_error.inc [errno=1142]
314 STOP SLAVE;
315 Warnings:
316 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
317 GRANT DELETE ON test.t TO 'a_bigger_username_just_for_test';
318 START SLAVE;
319 Warnings:
320 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
321 include/sync_slave_sql.inc
322 REVOKE DELETE ON test.t FROM 'a_bigger_username_just_for_test';
323 STOP SLAVE;
324 Warnings:
325 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
326 include/diff_tables.inc [master:t, slave:t]
327 GRANT INSERT(c) ON test.t TO 'a_bigger_username_just_for_test';
328 [connection master]
329 INSERT INTO t VALUES(10, 10);
330 include/save_master_pos.inc
331 [connection slave]
332 START SLAVE;
333 Warnings:
334 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
335 include/wait_for_slave_sql_error.inc [errno=1142]
336 STOP SLAVE;
337 Warnings:
338 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
339 #
340 # Running test for
341 # GRANT INSERT(c, d) ON test.t TO ...
342 #
343 [connection master]
344 INSERT INTO t VALUES(10, 10);
345 include/save_master_pos.inc
346 [connection slave]
347 START SLAVE;
348 Warnings:
349 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
350 include/wait_for_slave_sql_error.inc [errno=1142]
351 STOP SLAVE;
352 Warnings:
353 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
354 GRANT INSERT(c, d) ON test.t TO 'a_bigger_username_just_for_test';
355 START SLAVE;
356 Warnings:
357 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
358 include/sync_slave_sql.inc
359 REVOKE INSERT(c, d) ON test.t FROM 'a_bigger_username_just_for_test';
360 STOP SLAVE;
361 Warnings:
362 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
363 include/diff_tables.inc [master:t, slave:t]
364 #
365 # Running test for
366 # GRANT UPDATE(c) ON test.t TO ...
367 #
368 [connection master]
369 UPDATE t SET c = 12 WHERE c = 10;
370 include/save_master_pos.inc
371 [connection slave]
372 START SLAVE;
373 Warnings:
374 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
375 include/wait_for_slave_sql_error.inc [errno=1142]
376 STOP SLAVE;
377 Warnings:
378 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
379 GRANT UPDATE(c) ON test.t TO 'a_bigger_username_just_for_test';
380 START SLAVE;
381 Warnings:
382 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
383 include/sync_slave_sql.inc
384 REVOKE UPDATE(c) ON test.t FROM 'a_bigger_username_just_for_test';
385 STOP SLAVE;
386 Warnings:
387 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
388 include/diff_tables.inc [master:t, slave:t]
389 DROP TABLE t;
390 [connection master]
391 DROP TABLE t;
392 include/rpl_end.inc