Debian Codegraph @

mysql-test/suite/rpl/r/rpl_default_table_encryption.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 #### SETUP ####
7 [connection master]
8 SET @default_table_encryption_save = @@global.default_table_encryption;
9 CALL mtr.add_suppression("Could not flush keys to keyring's backup");
10 CALL mtr.add_suppression("Incorrect Keyring File");
11 include/sync_slave_sql_with_master.inc
12 SET @default_table_encryption_save = @@global.default_table_encryption;
13 #### TEST ####
14 [connection master]
15 SET @@global.default_table_encryption = 0;
16 [connection slave]
17 SET @@global.default_table_encryption = 0;
18 [connection master]
19 SET @@session.default_table_encryption = 0;
20 ==== CREATE DATABASE db [master_session:0 master_global:0 slave_global:0] ====
21 # CREATE without ENCRYPTION: include the variable in the binlog
22 [connection slave]
23 include/stop_slave_sql.inc
24 include/start_slave_sql.inc
25 [connection master]
26 include/save_binlog_position.inc
27 CREATE DATABASE db;
28 # Assert that binlog is as expected
29 include/assert_grep.inc [Binlog should contain default_table_encryption=0]
30 # Assert that object on master is "%ENCRYPTION='N'%"
31 include/sync_slave_sql_with_master.inc
32 # Assert that object on slave is "%ENCRYPTION='N'%"
33 [connection master]
34 include/sync_slave_sql_with_master.inc
35 [connection master]
36 SET @@session.default_table_encryption = 1-0;
37 ==== ALTER DATABASE db CHARACTER SET = utf8 [master_session:0 master_global:0 slave_global:0] ====
38 # ALTER: exclude the variable from the binlog
39 [connection slave]
40 include/stop_slave_sql.inc
41 include/start_slave_sql.inc
42 [connection master]
43 include/save_binlog_position.inc
44 ALTER DATABASE db CHARACTER SET = utf8;
45 Warnings:
46 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
47 # Assert that binlog is as expected
48 include/assert_grep.inc [Binlog should not contain default_table_encryption]
49 # Assert that object on master is "%ENCRYPTION='N'%"
50 include/sync_slave_sql_with_master.inc
51 # Assert that object on slave is "%ENCRYPTION='N'%"
52 [connection master]
53 DROP DATABASE db;
54 include/sync_slave_sql_with_master.inc
55 [connection master]
56 SET @@session.default_table_encryption = 0;
57 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'n' [master_session:0 master_global:0 slave_global:0] ====
58 # CREATE with ENCRYPTION: exclude the variable from the binlog
59 [connection slave]
60 include/stop_slave_sql.inc
61 include/start_slave_sql.inc
62 [connection master]
63 include/save_binlog_position.inc
64 CREATE DATABASE db DEFAULT ENCRYPTION = 'n';
65 # Assert that binlog is as expected
66 include/assert_grep.inc [Binlog should not contain default_table_encryption]
67 # Assert that object on master is "%ENCRYPTION='N'%"
68 include/sync_slave_sql_with_master.inc
69 # Assert that object on slave is "%ENCRYPTION='N'%"
70 [connection master]
71 DROP DATABASE db;
72 include/sync_slave_sql_with_master.inc
73 [connection master]
74 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'y' [master_session:0 master_global:0 slave_global:0] ====
75 # CREATE with ENCRYPTION: exclude the variable from the binlog
76 [connection slave]
77 include/stop_slave_sql.inc
78 include/start_slave_sql.inc
79 [connection master]
80 include/save_binlog_position.inc
81 CREATE DATABASE db DEFAULT ENCRYPTION = 'y';
82 # Assert that binlog is as expected
83 include/assert_grep.inc [Binlog should not contain default_table_encryption]
84 # Assert that object on master is "%ENCRYPTION='Y'%"
85 include/sync_slave_sql_with_master.inc
86 # Assert that object on slave is "%ENCRYPTION='Y'%"
87 [connection master]
88 DROP DATABASE db;
89 include/sync_slave_sql_with_master.inc
90 [connection master]
91 ==== CREATE TABLESPACE ts [master_session:0 master_global:0 slave_global:0] ====
92 # CREATE without ENCRYPTION: include the variable in the binlog
93 [connection slave]
94 include/stop_slave_sql.inc
95 include/start_slave_sql.inc
96 [connection master]
97 include/save_binlog_position.inc
98 CREATE TABLESPACE ts;
99 # Assert that binlog is as expected
100 include/assert_grep.inc [Binlog should contain default_table_encryption=0]
101 # Assert that object on master is "N"
102 include/sync_slave_sql_with_master.inc
103 # Assert that object on slave is "N"
104 [connection master]
105 include/sync_slave_sql_with_master.inc
106 [connection master]
107 SET @@session.default_table_encryption = 1-0;
108 ==== ALTER TABLESPACE ts RENAME TO ts2 [master_session:0 master_global:0 slave_global:0] ====
109 # ALTER should not include the variable in the binlog
110 [connection slave]
111 include/stop_slave_sql.inc
112 include/start_slave_sql.inc
113 [connection master]
114 include/save_binlog_position.inc
115 ALTER TABLESPACE ts RENAME TO ts2;
116 # Assert that binlog is as expected
117 include/assert_grep.inc [Binlog should not contain default_table_encryption]
118 # Assert that object on master is "N"
119 include/sync_slave_sql_with_master.inc
120 # Assert that object on slave is "N"
121 [connection master]
122 DROP TABLESPACE ts2;
123 include/sync_slave_sql_with_master.inc
124 [connection master]
125 SET @@session.default_table_encryption = 0;
126 ==== CREATE TABLESPACE ts ENCRYPTION = 'y' [master_session:0 master_global:0 slave_global:0] ====
127 # CREATE with ENCRYPTION: exclude the variable from the binlog
128 [connection slave]
129 include/stop_slave_sql.inc
130 include/start_slave_sql.inc
131 [connection master]
132 include/save_binlog_position.inc
133 CREATE TABLESPACE ts ENCRYPTION = 'y';
134 # Assert that binlog is as expected
135 include/assert_grep.inc [Binlog should not contain default_table_encryption]
136 # Assert that object on master is "Y"
137 include/sync_slave_sql_with_master.inc
138 # Assert that object on slave is "Y"
139 [connection master]
140 DROP TABLESPACE ts;
141 include/sync_slave_sql_with_master.inc
142 [connection master]
143 ==== CREATE TABLESPACE ts ENCRYPTION = 'n' [master_session:0 master_global:0 slave_global:0] ====
144 # CREATE with ENCRYPTION: exclude the variable from the binlog
145 [connection slave]
146 include/stop_slave_sql.inc
147 include/start_slave_sql.inc
148 [connection master]
149 include/save_binlog_position.inc
150 CREATE TABLESPACE ts ENCRYPTION = 'n';
151 # Assert that binlog is as expected
152 include/assert_grep.inc [Binlog should not contain default_table_encryption]
153 # Assert that object on master is "N"
154 include/sync_slave_sql_with_master.inc
155 # Assert that object on slave is "N"
156 [connection master]
157 DROP TABLESPACE ts;
158 include/sync_slave_sql_with_master.inc
159 [connection master]
160 [connection master]
161 SET @@session.default_table_encryption = 1;
162 ==== CREATE DATABASE db [master_session:1 master_global:0 slave_global:0] ====
163 # CREATE without ENCRYPTION: include the variable in the binlog
164 [connection slave]
165 include/stop_slave_sql.inc
166 include/start_slave_sql.inc
167 [connection master]
168 include/save_binlog_position.inc
169 CREATE DATABASE db;
170 # Assert that binlog is as expected
171 include/assert_grep.inc [Binlog should contain default_table_encryption=1]
172 # Assert that object on master is "%ENCRYPTION='Y'%"
173 include/sync_slave_sql_with_master.inc
174 # Assert that object on slave is "%ENCRYPTION='Y'%"
175 [connection master]
176 include/sync_slave_sql_with_master.inc
177 [connection master]
178 SET @@session.default_table_encryption = 1-1;
179 ==== ALTER DATABASE db CHARACTER SET = utf8 [master_session:1 master_global:0 slave_global:0] ====
180 # ALTER: exclude the variable from the binlog
181 [connection slave]
182 include/stop_slave_sql.inc
183 include/start_slave_sql.inc
184 [connection master]
185 include/save_binlog_position.inc
186 ALTER DATABASE db CHARACTER SET = utf8;
187 Warnings:
188 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
189 # Assert that binlog is as expected
190 include/assert_grep.inc [Binlog should not contain default_table_encryption]
191 # Assert that object on master is "%ENCRYPTION='Y'%"
192 include/sync_slave_sql_with_master.inc
193 # Assert that object on slave is "%ENCRYPTION='Y'%"
194 [connection master]
195 DROP DATABASE db;
196 include/sync_slave_sql_with_master.inc
197 [connection master]
198 SET @@session.default_table_encryption = 1;
199 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'n' [master_session:1 master_global:0 slave_global:0] ====
200 # CREATE with ENCRYPTION: exclude the variable from the binlog
201 [connection slave]
202 include/stop_slave_sql.inc
203 include/start_slave_sql.inc
204 [connection master]
205 include/save_binlog_position.inc
206 CREATE DATABASE db DEFAULT ENCRYPTION = 'n';
207 # Assert that binlog is as expected
208 include/assert_grep.inc [Binlog should not contain default_table_encryption]
209 # Assert that object on master is "%ENCRYPTION='N'%"
210 include/sync_slave_sql_with_master.inc
211 # Assert that object on slave is "%ENCRYPTION='N'%"
212 [connection master]
213 DROP DATABASE db;
214 include/sync_slave_sql_with_master.inc
215 [connection master]
216 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'y' [master_session:1 master_global:0 slave_global:0] ====
217 # CREATE with ENCRYPTION: exclude the variable from the binlog
218 [connection slave]
219 include/stop_slave_sql.inc
220 include/start_slave_sql.inc
221 [connection master]
222 include/save_binlog_position.inc
223 CREATE DATABASE db DEFAULT ENCRYPTION = 'y';
224 # Assert that binlog is as expected
225 include/assert_grep.inc [Binlog should not contain default_table_encryption]
226 # Assert that object on master is "%ENCRYPTION='Y'%"
227 include/sync_slave_sql_with_master.inc
228 # Assert that object on slave is "%ENCRYPTION='Y'%"
229 [connection master]
230 DROP DATABASE db;
231 include/sync_slave_sql_with_master.inc
232 [connection master]
233 ==== CREATE TABLESPACE ts [master_session:1 master_global:0 slave_global:0] ====
234 # CREATE without ENCRYPTION: include the variable in the binlog
235 [connection slave]
236 include/stop_slave_sql.inc
237 include/start_slave_sql.inc
238 [connection master]
239 include/save_binlog_position.inc
240 CREATE TABLESPACE ts;
241 # Assert that binlog is as expected
242 include/assert_grep.inc [Binlog should contain default_table_encryption=1]
243 # Assert that object on master is "Y"
244 include/sync_slave_sql_with_master.inc
245 # Assert that object on slave is "Y"
246 [connection master]
247 include/sync_slave_sql_with_master.inc
248 [connection master]
249 SET @@session.default_table_encryption = 1-1;
250 ==== ALTER TABLESPACE ts RENAME TO ts2 [master_session:1 master_global:0 slave_global:0] ====
251 # ALTER should not include the variable in the binlog
252 [connection slave]
253 include/stop_slave_sql.inc
254 include/start_slave_sql.inc
255 [connection master]
256 include/save_binlog_position.inc
257 ALTER TABLESPACE ts RENAME TO ts2;
258 # Assert that binlog is as expected
259 include/assert_grep.inc [Binlog should not contain default_table_encryption]
260 # Assert that object on master is "Y"
261 include/sync_slave_sql_with_master.inc
262 # Assert that object on slave is "Y"
263 [connection master]
264 DROP TABLESPACE ts2;
265 include/sync_slave_sql_with_master.inc
266 [connection master]
267 SET @@session.default_table_encryption = 1;
268 ==== CREATE TABLESPACE ts ENCRYPTION = 'y' [master_session:1 master_global:0 slave_global:0] ====
269 # CREATE with ENCRYPTION: exclude the variable from the binlog
270 [connection slave]
271 include/stop_slave_sql.inc
272 include/start_slave_sql.inc
273 [connection master]
274 include/save_binlog_position.inc
275 CREATE TABLESPACE ts ENCRYPTION = 'y';
276 # Assert that binlog is as expected
277 include/assert_grep.inc [Binlog should not contain default_table_encryption]
278 # Assert that object on master is "Y"
279 include/sync_slave_sql_with_master.inc
280 # Assert that object on slave is "Y"
281 [connection master]
282 DROP TABLESPACE ts;
283 include/sync_slave_sql_with_master.inc
284 [connection master]
285 ==== CREATE TABLESPACE ts ENCRYPTION = 'n' [master_session:1 master_global:0 slave_global:0] ====
286 # CREATE with ENCRYPTION: exclude the variable from the binlog
287 [connection slave]
288 include/stop_slave_sql.inc
289 include/start_slave_sql.inc
290 [connection master]
291 include/save_binlog_position.inc
292 CREATE TABLESPACE ts ENCRYPTION = 'n';
293 # Assert that binlog is as expected
294 include/assert_grep.inc [Binlog should not contain default_table_encryption]
295 # Assert that object on master is "N"
296 include/sync_slave_sql_with_master.inc
297 # Assert that object on slave is "N"
298 [connection master]
299 DROP TABLESPACE ts;
300 include/sync_slave_sql_with_master.inc
301 [connection master]
302 [connection slave]
303 SET @@global.default_table_encryption = 1;
304 [connection master]
305 SET @@session.default_table_encryption = 0;
306 ==== CREATE DATABASE db [master_session:0 master_global:0 slave_global:1] ====
307 # CREATE without ENCRYPTION: include the variable in the binlog
308 [connection slave]
309 include/stop_slave_sql.inc
310 include/start_slave_sql.inc
311 [connection master]
312 include/save_binlog_position.inc
313 CREATE DATABASE db;
314 # Assert that binlog is as expected
315 include/assert_grep.inc [Binlog should contain default_table_encryption=0]
316 # Assert that object on master is "%ENCRYPTION='N'%"
317 include/sync_slave_sql_with_master.inc
318 # Assert that object on slave is "%ENCRYPTION='N'%"
319 [connection master]
320 include/sync_slave_sql_with_master.inc
321 [connection master]
322 SET @@session.default_table_encryption = 1-0;
323 ==== ALTER DATABASE db CHARACTER SET = utf8 [master_session:0 master_global:0 slave_global:1] ====
324 # ALTER: exclude the variable from the binlog
325 [connection slave]
326 include/stop_slave_sql.inc
327 include/start_slave_sql.inc
328 [connection master]
329 include/save_binlog_position.inc
330 ALTER DATABASE db CHARACTER SET = utf8;
331 Warnings:
332 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
333 # Assert that binlog is as expected
334 include/assert_grep.inc [Binlog should not contain default_table_encryption]
335 # Assert that object on master is "%ENCRYPTION='N'%"
336 include/sync_slave_sql_with_master.inc
337 # Assert that object on slave is "%ENCRYPTION='N'%"
338 [connection master]
339 DROP DATABASE db;
340 include/sync_slave_sql_with_master.inc
341 [connection master]
342 SET @@session.default_table_encryption = 0;
343 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'n' [master_session:0 master_global:0 slave_global:1] ====
344 # CREATE with ENCRYPTION: exclude the variable from the binlog
345 [connection slave]
346 include/stop_slave_sql.inc
347 include/start_slave_sql.inc
348 [connection master]
349 include/save_binlog_position.inc
350 CREATE DATABASE db DEFAULT ENCRYPTION = 'n';
351 # Assert that binlog is as expected
352 include/assert_grep.inc [Binlog should not contain default_table_encryption]
353 # Assert that object on master is "%ENCRYPTION='N'%"
354 include/sync_slave_sql_with_master.inc
355 # Assert that object on slave is "%ENCRYPTION='N'%"
356 [connection master]
357 DROP DATABASE db;
358 include/sync_slave_sql_with_master.inc
359 [connection master]
360 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'y' [master_session:0 master_global:0 slave_global:1] ====
361 # CREATE with ENCRYPTION: exclude the variable from the binlog
362 [connection slave]
363 include/stop_slave_sql.inc
364 include/start_slave_sql.inc
365 [connection master]
366 include/save_binlog_position.inc
367 CREATE DATABASE db DEFAULT ENCRYPTION = 'y';
368 # Assert that binlog is as expected
369 include/assert_grep.inc [Binlog should not contain default_table_encryption]
370 # Assert that object on master is "%ENCRYPTION='Y'%"
371 include/sync_slave_sql_with_master.inc
372 # Assert that object on slave is "%ENCRYPTION='Y'%"
373 [connection master]
374 DROP DATABASE db;
375 include/sync_slave_sql_with_master.inc
376 [connection master]
377 ==== CREATE TABLESPACE ts [master_session:0 master_global:0 slave_global:1] ====
378 # CREATE without ENCRYPTION: include the variable in the binlog
379 [connection slave]
380 include/stop_slave_sql.inc
381 include/start_slave_sql.inc
382 [connection master]
383 include/save_binlog_position.inc
384 CREATE TABLESPACE ts;
385 # Assert that binlog is as expected
386 include/assert_grep.inc [Binlog should contain default_table_encryption=0]
387 # Assert that object on master is "N"
388 include/sync_slave_sql_with_master.inc
389 # Assert that object on slave is "N"
390 [connection master]
391 include/sync_slave_sql_with_master.inc
392 [connection master]
393 SET @@session.default_table_encryption = 1-0;
394 ==== ALTER TABLESPACE ts RENAME TO ts2 [master_session:0 master_global:0 slave_global:1] ====
395 # ALTER should not include the variable in the binlog
396 [connection slave]
397 include/stop_slave_sql.inc
398 include/start_slave_sql.inc
399 [connection master]
400 include/save_binlog_position.inc
401 ALTER TABLESPACE ts RENAME TO ts2;
402 # Assert that binlog is as expected
403 include/assert_grep.inc [Binlog should not contain default_table_encryption]
404 # Assert that object on master is "N"
405 include/sync_slave_sql_with_master.inc
406 # Assert that object on slave is "N"
407 [connection master]
408 DROP TABLESPACE ts2;
409 include/sync_slave_sql_with_master.inc
410 [connection master]
411 SET @@session.default_table_encryption = 0;
412 ==== CREATE TABLESPACE ts ENCRYPTION = 'y' [master_session:0 master_global:0 slave_global:1] ====
413 # CREATE with ENCRYPTION: exclude the variable from the binlog
414 [connection slave]
415 include/stop_slave_sql.inc
416 include/start_slave_sql.inc
417 [connection master]
418 include/save_binlog_position.inc
419 CREATE TABLESPACE ts ENCRYPTION = 'y';
420 # Assert that binlog is as expected
421 include/assert_grep.inc [Binlog should not contain default_table_encryption]
422 # Assert that object on master is "Y"
423 include/sync_slave_sql_with_master.inc
424 # Assert that object on slave is "Y"
425 [connection master]
426 DROP TABLESPACE ts;
427 include/sync_slave_sql_with_master.inc
428 [connection master]
429 ==== CREATE TABLESPACE ts ENCRYPTION = 'n' [master_session:0 master_global:0 slave_global:1] ====
430 # CREATE with ENCRYPTION: exclude the variable from the binlog
431 [connection slave]
432 include/stop_slave_sql.inc
433 include/start_slave_sql.inc
434 [connection master]
435 include/save_binlog_position.inc
436 CREATE TABLESPACE ts ENCRYPTION = 'n';
437 # Assert that binlog is as expected
438 include/assert_grep.inc [Binlog should not contain default_table_encryption]
439 # Assert that object on master is "N"
440 include/sync_slave_sql_with_master.inc
441 # Assert that object on slave is "N"
442 [connection master]
443 DROP TABLESPACE ts;
444 include/sync_slave_sql_with_master.inc
445 [connection master]
446 [connection master]
447 SET @@session.default_table_encryption = 1;
448 ==== CREATE DATABASE db [master_session:1 master_global:0 slave_global:1] ====
449 # CREATE without ENCRYPTION: include the variable in the binlog
450 [connection slave]
451 include/stop_slave_sql.inc
452 include/start_slave_sql.inc
453 [connection master]
454 include/save_binlog_position.inc
455 CREATE DATABASE db;
456 # Assert that binlog is as expected
457 include/assert_grep.inc [Binlog should contain default_table_encryption=1]
458 # Assert that object on master is "%ENCRYPTION='Y'%"
459 include/sync_slave_sql_with_master.inc
460 # Assert that object on slave is "%ENCRYPTION='Y'%"
461 [connection master]
462 include/sync_slave_sql_with_master.inc
463 [connection master]
464 SET @@session.default_table_encryption = 1-1;
465 ==== ALTER DATABASE db CHARACTER SET = utf8 [master_session:1 master_global:0 slave_global:1] ====
466 # ALTER: exclude the variable from the binlog
467 [connection slave]
468 include/stop_slave_sql.inc
469 include/start_slave_sql.inc
470 [connection master]
471 include/save_binlog_position.inc
472 ALTER DATABASE db CHARACTER SET = utf8;
473 Warnings:
474 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
475 # Assert that binlog is as expected
476 include/assert_grep.inc [Binlog should not contain default_table_encryption]
477 # Assert that object on master is "%ENCRYPTION='Y'%"
478 include/sync_slave_sql_with_master.inc
479 # Assert that object on slave is "%ENCRYPTION='Y'%"
480 [connection master]
481 DROP DATABASE db;
482 include/sync_slave_sql_with_master.inc
483 [connection master]
484 SET @@session.default_table_encryption = 1;
485 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'n' [master_session:1 master_global:0 slave_global:1] ====
486 # CREATE with ENCRYPTION: exclude the variable from the binlog
487 [connection slave]
488 include/stop_slave_sql.inc
489 include/start_slave_sql.inc
490 [connection master]
491 include/save_binlog_position.inc
492 CREATE DATABASE db DEFAULT ENCRYPTION = 'n';
493 # Assert that binlog is as expected
494 include/assert_grep.inc [Binlog should not contain default_table_encryption]
495 # Assert that object on master is "%ENCRYPTION='N'%"
496 include/sync_slave_sql_with_master.inc
497 # Assert that object on slave is "%ENCRYPTION='N'%"
498 [connection master]
499 DROP DATABASE db;
500 include/sync_slave_sql_with_master.inc
501 [connection master]
502 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'y' [master_session:1 master_global:0 slave_global:1] ====
503 # CREATE with ENCRYPTION: exclude the variable from the binlog
504 [connection slave]
505 include/stop_slave_sql.inc
506 include/start_slave_sql.inc
507 [connection master]
508 include/save_binlog_position.inc
509 CREATE DATABASE db DEFAULT ENCRYPTION = 'y';
510 # Assert that binlog is as expected
511 include/assert_grep.inc [Binlog should not contain default_table_encryption]
512 # Assert that object on master is "%ENCRYPTION='Y'%"
513 include/sync_slave_sql_with_master.inc
514 # Assert that object on slave is "%ENCRYPTION='Y'%"
515 [connection master]
516 DROP DATABASE db;
517 include/sync_slave_sql_with_master.inc
518 [connection master]
519 ==== CREATE TABLESPACE ts [master_session:1 master_global:0 slave_global:1] ====
520 # CREATE without ENCRYPTION: include the variable in the binlog
521 [connection slave]
522 include/stop_slave_sql.inc
523 include/start_slave_sql.inc
524 [connection master]
525 include/save_binlog_position.inc
526 CREATE TABLESPACE ts;
527 # Assert that binlog is as expected
528 include/assert_grep.inc [Binlog should contain default_table_encryption=1]
529 # Assert that object on master is "Y"
530 include/sync_slave_sql_with_master.inc
531 # Assert that object on slave is "Y"
532 [connection master]
533 include/sync_slave_sql_with_master.inc
534 [connection master]
535 SET @@session.default_table_encryption = 1-1;
536 ==== ALTER TABLESPACE ts RENAME TO ts2 [master_session:1 master_global:0 slave_global:1] ====
537 # ALTER should not include the variable in the binlog
538 [connection slave]
539 include/stop_slave_sql.inc
540 include/start_slave_sql.inc
541 [connection master]
542 include/save_binlog_position.inc
543 ALTER TABLESPACE ts RENAME TO ts2;
544 # Assert that binlog is as expected
545 include/assert_grep.inc [Binlog should not contain default_table_encryption]
546 # Assert that object on master is "Y"
547 include/sync_slave_sql_with_master.inc
548 # Assert that object on slave is "Y"
549 [connection master]
550 DROP TABLESPACE ts2;
551 include/sync_slave_sql_with_master.inc
552 [connection master]
553 SET @@session.default_table_encryption = 1;
554 ==== CREATE TABLESPACE ts ENCRYPTION = 'y' [master_session:1 master_global:0 slave_global:1] ====
555 # CREATE with ENCRYPTION: exclude the variable from the binlog
556 [connection slave]
557 include/stop_slave_sql.inc
558 include/start_slave_sql.inc
559 [connection master]
560 include/save_binlog_position.inc
561 CREATE TABLESPACE ts ENCRYPTION = 'y';
562 # Assert that binlog is as expected
563 include/assert_grep.inc [Binlog should not contain default_table_encryption]
564 # Assert that object on master is "Y"
565 include/sync_slave_sql_with_master.inc
566 # Assert that object on slave is "Y"
567 [connection master]
568 DROP TABLESPACE ts;
569 include/sync_slave_sql_with_master.inc
570 [connection master]
571 ==== CREATE TABLESPACE ts ENCRYPTION = 'n' [master_session:1 master_global:0 slave_global:1] ====
572 # CREATE with ENCRYPTION: exclude the variable from the binlog
573 [connection slave]
574 include/stop_slave_sql.inc
575 include/start_slave_sql.inc
576 [connection master]
577 include/save_binlog_position.inc
578 CREATE TABLESPACE ts ENCRYPTION = 'n';
579 # Assert that binlog is as expected
580 include/assert_grep.inc [Binlog should not contain default_table_encryption]
581 # Assert that object on master is "N"
582 include/sync_slave_sql_with_master.inc
583 # Assert that object on slave is "N"
584 [connection master]
585 DROP TABLESPACE ts;
586 include/sync_slave_sql_with_master.inc
587 [connection master]
588 [connection master]
589 SET @@global.default_table_encryption = 1;
590 [connection slave]
591 SET @@global.default_table_encryption = 0;
592 [connection master]
593 SET @@session.default_table_encryption = 0;
594 ==== CREATE DATABASE db [master_session:0 master_global:1 slave_global:0] ====
595 # CREATE without ENCRYPTION: include the variable in the binlog
596 [connection slave]
597 include/stop_slave_sql.inc
598 include/start_slave_sql.inc
599 [connection master]
600 include/save_binlog_position.inc
601 CREATE DATABASE db;
602 # Assert that binlog is as expected
603 include/assert_grep.inc [Binlog should contain default_table_encryption=0]
604 # Assert that object on master is "%ENCRYPTION='N'%"
605 include/sync_slave_sql_with_master.inc
606 # Assert that object on slave is "%ENCRYPTION='N'%"
607 [connection master]
608 include/sync_slave_sql_with_master.inc
609 [connection master]
610 SET @@session.default_table_encryption = 1-0;
611 ==== ALTER DATABASE db CHARACTER SET = utf8 [master_session:0 master_global:1 slave_global:0] ====
612 # ALTER: exclude the variable from the binlog
613 [connection slave]
614 include/stop_slave_sql.inc
615 include/start_slave_sql.inc
616 [connection master]
617 include/save_binlog_position.inc
618 ALTER DATABASE db CHARACTER SET = utf8;
619 Warnings:
620 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
621 # Assert that binlog is as expected
622 include/assert_grep.inc [Binlog should not contain default_table_encryption]
623 # Assert that object on master is "%ENCRYPTION='N'%"
624 include/sync_slave_sql_with_master.inc
625 # Assert that object on slave is "%ENCRYPTION='N'%"
626 [connection master]
627 DROP DATABASE db;
628 include/sync_slave_sql_with_master.inc
629 [connection master]
630 SET @@session.default_table_encryption = 0;
631 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'n' [master_session:0 master_global:1 slave_global:0] ====
632 # CREATE with ENCRYPTION: exclude the variable from the binlog
633 [connection slave]
634 include/stop_slave_sql.inc
635 include/start_slave_sql.inc
636 [connection master]
637 include/save_binlog_position.inc
638 CREATE DATABASE db DEFAULT ENCRYPTION = 'n';
639 # Assert that binlog is as expected
640 include/assert_grep.inc [Binlog should not contain default_table_encryption]
641 # Assert that object on master is "%ENCRYPTION='N'%"
642 include/sync_slave_sql_with_master.inc
643 # Assert that object on slave is "%ENCRYPTION='N'%"
644 [connection master]
645 DROP DATABASE db;
646 include/sync_slave_sql_with_master.inc
647 [connection master]
648 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'y' [master_session:0 master_global:1 slave_global:0] ====
649 # CREATE with ENCRYPTION: exclude the variable from the binlog
650 [connection slave]
651 include/stop_slave_sql.inc
652 include/start_slave_sql.inc
653 [connection master]
654 include/save_binlog_position.inc
655 CREATE DATABASE db DEFAULT ENCRYPTION = 'y';
656 # Assert that binlog is as expected
657 include/assert_grep.inc [Binlog should not contain default_table_encryption]
658 # Assert that object on master is "%ENCRYPTION='Y'%"
659 include/sync_slave_sql_with_master.inc
660 # Assert that object on slave is "%ENCRYPTION='Y'%"
661 [connection master]
662 DROP DATABASE db;
663 include/sync_slave_sql_with_master.inc
664 [connection master]
665 ==== CREATE TABLESPACE ts [master_session:0 master_global:1 slave_global:0] ====
666 # CREATE without ENCRYPTION: include the variable in the binlog
667 [connection slave]
668 include/stop_slave_sql.inc
669 include/start_slave_sql.inc
670 [connection master]
671 include/save_binlog_position.inc
672 CREATE TABLESPACE ts;
673 # Assert that binlog is as expected
674 include/assert_grep.inc [Binlog should contain default_table_encryption=0]
675 # Assert that object on master is "N"
676 include/sync_slave_sql_with_master.inc
677 # Assert that object on slave is "N"
678 [connection master]
679 include/sync_slave_sql_with_master.inc
680 [connection master]
681 SET @@session.default_table_encryption = 1-0;
682 ==== ALTER TABLESPACE ts RENAME TO ts2 [master_session:0 master_global:1 slave_global:0] ====
683 # ALTER should not include the variable in the binlog
684 [connection slave]
685 include/stop_slave_sql.inc
686 include/start_slave_sql.inc
687 [connection master]
688 include/save_binlog_position.inc
689 ALTER TABLESPACE ts RENAME TO ts2;
690 # Assert that binlog is as expected
691 include/assert_grep.inc [Binlog should not contain default_table_encryption]
692 # Assert that object on master is "N"
693 include/sync_slave_sql_with_master.inc
694 # Assert that object on slave is "N"
695 [connection master]
696 DROP TABLESPACE ts2;
697 include/sync_slave_sql_with_master.inc
698 [connection master]
699 SET @@session.default_table_encryption = 0;
700 ==== CREATE TABLESPACE ts ENCRYPTION = 'y' [master_session:0 master_global:1 slave_global:0] ====
701 # CREATE with ENCRYPTION: exclude the variable from the binlog
702 [connection slave]
703 include/stop_slave_sql.inc
704 include/start_slave_sql.inc
705 [connection master]
706 include/save_binlog_position.inc
707 CREATE TABLESPACE ts ENCRYPTION = 'y';
708 # Assert that binlog is as expected
709 include/assert_grep.inc [Binlog should not contain default_table_encryption]
710 # Assert that object on master is "Y"
711 include/sync_slave_sql_with_master.inc
712 # Assert that object on slave is "Y"
713 [connection master]
714 DROP TABLESPACE ts;
715 include/sync_slave_sql_with_master.inc
716 [connection master]
717 ==== CREATE TABLESPACE ts ENCRYPTION = 'n' [master_session:0 master_global:1 slave_global:0] ====
718 # CREATE with ENCRYPTION: exclude the variable from the binlog
719 [connection slave]
720 include/stop_slave_sql.inc
721 include/start_slave_sql.inc
722 [connection master]
723 include/save_binlog_position.inc
724 CREATE TABLESPACE ts ENCRYPTION = 'n';
725 # Assert that binlog is as expected
726 include/assert_grep.inc [Binlog should not contain default_table_encryption]
727 # Assert that object on master is "N"
728 include/sync_slave_sql_with_master.inc
729 # Assert that object on slave is "N"
730 [connection master]
731 DROP TABLESPACE ts;
732 include/sync_slave_sql_with_master.inc
733 [connection master]
734 [connection master]
735 SET @@session.default_table_encryption = 1;
736 ==== CREATE DATABASE db [master_session:1 master_global:1 slave_global:0] ====
737 # CREATE without ENCRYPTION: include the variable in the binlog
738 [connection slave]
739 include/stop_slave_sql.inc
740 include/start_slave_sql.inc
741 [connection master]
742 include/save_binlog_position.inc
743 CREATE DATABASE db;
744 # Assert that binlog is as expected
745 include/assert_grep.inc [Binlog should contain default_table_encryption=1]
746 # Assert that object on master is "%ENCRYPTION='Y'%"
747 include/sync_slave_sql_with_master.inc
748 # Assert that object on slave is "%ENCRYPTION='Y'%"
749 [connection master]
750 include/sync_slave_sql_with_master.inc
751 [connection master]
752 SET @@session.default_table_encryption = 1-1;
753 ==== ALTER DATABASE db CHARACTER SET = utf8 [master_session:1 master_global:1 slave_global:0] ====
754 # ALTER: exclude the variable from the binlog
755 [connection slave]
756 include/stop_slave_sql.inc
757 include/start_slave_sql.inc
758 [connection master]
759 include/save_binlog_position.inc
760 ALTER DATABASE db CHARACTER SET = utf8;
761 Warnings:
762 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
763 # Assert that binlog is as expected
764 include/assert_grep.inc [Binlog should not contain default_table_encryption]
765 # Assert that object on master is "%ENCRYPTION='Y'%"
766 include/sync_slave_sql_with_master.inc
767 # Assert that object on slave is "%ENCRYPTION='Y'%"
768 [connection master]
769 DROP DATABASE db;
770 include/sync_slave_sql_with_master.inc
771 [connection master]
772 SET @@session.default_table_encryption = 1;
773 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'n' [master_session:1 master_global:1 slave_global:0] ====
774 # CREATE with ENCRYPTION: exclude the variable from the binlog
775 [connection slave]
776 include/stop_slave_sql.inc
777 include/start_slave_sql.inc
778 [connection master]
779 include/save_binlog_position.inc
780 CREATE DATABASE db DEFAULT ENCRYPTION = 'n';
781 # Assert that binlog is as expected
782 include/assert_grep.inc [Binlog should not contain default_table_encryption]
783 # Assert that object on master is "%ENCRYPTION='N'%"
784 include/sync_slave_sql_with_master.inc
785 # Assert that object on slave is "%ENCRYPTION='N'%"
786 [connection master]
787 DROP DATABASE db;
788 include/sync_slave_sql_with_master.inc
789 [connection master]
790 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'y' [master_session:1 master_global:1 slave_global:0] ====
791 # CREATE with ENCRYPTION: exclude the variable from the binlog
792 [connection slave]
793 include/stop_slave_sql.inc
794 include/start_slave_sql.inc
795 [connection master]
796 include/save_binlog_position.inc
797 CREATE DATABASE db DEFAULT ENCRYPTION = 'y';
798 # Assert that binlog is as expected
799 include/assert_grep.inc [Binlog should not contain default_table_encryption]
800 # Assert that object on master is "%ENCRYPTION='Y'%"
801 include/sync_slave_sql_with_master.inc
802 # Assert that object on slave is "%ENCRYPTION='Y'%"
803 [connection master]
804 DROP DATABASE db;
805 include/sync_slave_sql_with_master.inc
806 [connection master]
807 ==== CREATE TABLESPACE ts [master_session:1 master_global:1 slave_global:0] ====
808 # CREATE without ENCRYPTION: include the variable in the binlog
809 [connection slave]
810 include/stop_slave_sql.inc
811 include/start_slave_sql.inc
812 [connection master]
813 include/save_binlog_position.inc
814 CREATE TABLESPACE ts;
815 # Assert that binlog is as expected
816 include/assert_grep.inc [Binlog should contain default_table_encryption=1]
817 # Assert that object on master is "Y"
818 include/sync_slave_sql_with_master.inc
819 # Assert that object on slave is "Y"
820 [connection master]
821 include/sync_slave_sql_with_master.inc
822 [connection master]
823 SET @@session.default_table_encryption = 1-1;
824 ==== ALTER TABLESPACE ts RENAME TO ts2 [master_session:1 master_global:1 slave_global:0] ====
825 # ALTER should not include the variable in the binlog
826 [connection slave]
827 include/stop_slave_sql.inc
828 include/start_slave_sql.inc
829 [connection master]
830 include/save_binlog_position.inc
831 ALTER TABLESPACE ts RENAME TO ts2;
832 # Assert that binlog is as expected
833 include/assert_grep.inc [Binlog should not contain default_table_encryption]
834 # Assert that object on master is "Y"
835 include/sync_slave_sql_with_master.inc
836 # Assert that object on slave is "Y"
837 [connection master]
838 DROP TABLESPACE ts2;
839 include/sync_slave_sql_with_master.inc
840 [connection master]
841 SET @@session.default_table_encryption = 1;
842 ==== CREATE TABLESPACE ts ENCRYPTION = 'y' [master_session:1 master_global:1 slave_global:0] ====
843 # CREATE with ENCRYPTION: exclude the variable from the binlog
844 [connection slave]
845 include/stop_slave_sql.inc
846 include/start_slave_sql.inc
847 [connection master]
848 include/save_binlog_position.inc
849 CREATE TABLESPACE ts ENCRYPTION = 'y';
850 # Assert that binlog is as expected
851 include/assert_grep.inc [Binlog should not contain default_table_encryption]
852 # Assert that object on master is "Y"
853 include/sync_slave_sql_with_master.inc
854 # Assert that object on slave is "Y"
855 [connection master]
856 DROP TABLESPACE ts;
857 include/sync_slave_sql_with_master.inc
858 [connection master]
859 ==== CREATE TABLESPACE ts ENCRYPTION = 'n' [master_session:1 master_global:1 slave_global:0] ====
860 # CREATE with ENCRYPTION: exclude the variable from the binlog
861 [connection slave]
862 include/stop_slave_sql.inc
863 include/start_slave_sql.inc
864 [connection master]
865 include/save_binlog_position.inc
866 CREATE TABLESPACE ts ENCRYPTION = 'n';
867 # Assert that binlog is as expected
868 include/assert_grep.inc [Binlog should not contain default_table_encryption]
869 # Assert that object on master is "N"
870 include/sync_slave_sql_with_master.inc
871 # Assert that object on slave is "N"
872 [connection master]
873 DROP TABLESPACE ts;
874 include/sync_slave_sql_with_master.inc
875 [connection master]
876 [connection slave]
877 SET @@global.default_table_encryption = 1;
878 [connection master]
879 SET @@session.default_table_encryption = 0;
880 ==== CREATE DATABASE db [master_session:0 master_global:1 slave_global:1] ====
881 # CREATE without ENCRYPTION: include the variable in the binlog
882 [connection slave]
883 include/stop_slave_sql.inc
884 include/start_slave_sql.inc
885 [connection master]
886 include/save_binlog_position.inc
887 CREATE DATABASE db;
888 # Assert that binlog is as expected
889 include/assert_grep.inc [Binlog should contain default_table_encryption=0]
890 # Assert that object on master is "%ENCRYPTION='N'%"
891 include/sync_slave_sql_with_master.inc
892 # Assert that object on slave is "%ENCRYPTION='N'%"
893 [connection master]
894 include/sync_slave_sql_with_master.inc
895 [connection master]
896 SET @@session.default_table_encryption = 1-0;
897 ==== ALTER DATABASE db CHARACTER SET = utf8 [master_session:0 master_global:1 slave_global:1] ====
898 # ALTER: exclude the variable from the binlog
899 [connection slave]
900 include/stop_slave_sql.inc
901 include/start_slave_sql.inc
902 [connection master]
903 include/save_binlog_position.inc
904 ALTER DATABASE db CHARACTER SET = utf8;
905 Warnings:
906 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
907 # Assert that binlog is as expected
908 include/assert_grep.inc [Binlog should not contain default_table_encryption]
909 # Assert that object on master is "%ENCRYPTION='N'%"
910 include/sync_slave_sql_with_master.inc
911 # Assert that object on slave is "%ENCRYPTION='N'%"
912 [connection master]
913 DROP DATABASE db;
914 include/sync_slave_sql_with_master.inc
915 [connection master]
916 SET @@session.default_table_encryption = 0;
917 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'n' [master_session:0 master_global:1 slave_global:1] ====
918 # CREATE with ENCRYPTION: exclude the variable from the binlog
919 [connection slave]
920 include/stop_slave_sql.inc
921 include/start_slave_sql.inc
922 [connection master]
923 include/save_binlog_position.inc
924 CREATE DATABASE db DEFAULT ENCRYPTION = 'n';
925 # Assert that binlog is as expected
926 include/assert_grep.inc [Binlog should not contain default_table_encryption]
927 # Assert that object on master is "%ENCRYPTION='N'%"
928 include/sync_slave_sql_with_master.inc
929 # Assert that object on slave is "%ENCRYPTION='N'%"
930 [connection master]
931 DROP DATABASE db;
932 include/sync_slave_sql_with_master.inc
933 [connection master]
934 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'y' [master_session:0 master_global:1 slave_global:1] ====
935 # CREATE with ENCRYPTION: exclude the variable from the binlog
936 [connection slave]
937 include/stop_slave_sql.inc
938 include/start_slave_sql.inc
939 [connection master]
940 include/save_binlog_position.inc
941 CREATE DATABASE db DEFAULT ENCRYPTION = 'y';
942 # Assert that binlog is as expected
943 include/assert_grep.inc [Binlog should not contain default_table_encryption]
944 # Assert that object on master is "%ENCRYPTION='Y'%"
945 include/sync_slave_sql_with_master.inc
946 # Assert that object on slave is "%ENCRYPTION='Y'%"
947 [connection master]
948 DROP DATABASE db;
949 include/sync_slave_sql_with_master.inc
950 [connection master]
951 ==== CREATE TABLESPACE ts [master_session:0 master_global:1 slave_global:1] ====
952 # CREATE without ENCRYPTION: include the variable in the binlog
953 [connection slave]
954 include/stop_slave_sql.inc
955 include/start_slave_sql.inc
956 [connection master]
957 include/save_binlog_position.inc
958 CREATE TABLESPACE ts;
959 # Assert that binlog is as expected
960 include/assert_grep.inc [Binlog should contain default_table_encryption=0]
961 # Assert that object on master is "N"
962 include/sync_slave_sql_with_master.inc
963 # Assert that object on slave is "N"
964 [connection master]
965 include/sync_slave_sql_with_master.inc
966 [connection master]
967 SET @@session.default_table_encryption = 1-0;
968 ==== ALTER TABLESPACE ts RENAME TO ts2 [master_session:0 master_global:1 slave_global:1] ====
969 # ALTER should not include the variable in the binlog
970 [connection slave]
971 include/stop_slave_sql.inc
972 include/start_slave_sql.inc
973 [connection master]
974 include/save_binlog_position.inc
975 ALTER TABLESPACE ts RENAME TO ts2;
976 # Assert that binlog is as expected
977 include/assert_grep.inc [Binlog should not contain default_table_encryption]
978 # Assert that object on master is "N"
979 include/sync_slave_sql_with_master.inc
980 # Assert that object on slave is "N"
981 [connection master]
982 DROP TABLESPACE ts2;
983 include/sync_slave_sql_with_master.inc
984 [connection master]
985 SET @@session.default_table_encryption = 0;
986 ==== CREATE TABLESPACE ts ENCRYPTION = 'y' [master_session:0 master_global:1 slave_global:1] ====
987 # CREATE with ENCRYPTION: exclude the variable from the binlog
988 [connection slave]
989 include/stop_slave_sql.inc
990 include/start_slave_sql.inc
991 [connection master]
992 include/save_binlog_position.inc
993 CREATE TABLESPACE ts ENCRYPTION = 'y';
994 # Assert that binlog is as expected
995 include/assert_grep.inc [Binlog should not contain default_table_encryption]
996 # Assert that object on master is "Y"
997 include/sync_slave_sql_with_master.inc
998 # Assert that object on slave is "Y"
999 [connection master]
1000 DROP TABLESPACE ts;
1001 include/sync_slave_sql_with_master.inc
1002 [connection master]
1003 ==== CREATE TABLESPACE ts ENCRYPTION = 'n' [master_session:0 master_global:1 slave_global:1] ====
1004 # CREATE with ENCRYPTION: exclude the variable from the binlog
1005 [connection slave]
1006 include/stop_slave_sql.inc
1007 include/start_slave_sql.inc
1008 [connection master]
1009 include/save_binlog_position.inc
1010 CREATE TABLESPACE ts ENCRYPTION = 'n';
1011 # Assert that binlog is as expected
1012 include/assert_grep.inc [Binlog should not contain default_table_encryption]
1013 # Assert that object on master is "N"
1014 include/sync_slave_sql_with_master.inc
1015 # Assert that object on slave is "N"
1016 [connection master]
1017 DROP TABLESPACE ts;
1018 include/sync_slave_sql_with_master.inc
1019 [connection master]
1020 [connection master]
1021 SET @@session.default_table_encryption = 1;
1022 ==== CREATE DATABASE db [master_session:1 master_global:1 slave_global:1] ====
1023 # CREATE without ENCRYPTION: include the variable in the binlog
1024 [connection slave]
1025 include/stop_slave_sql.inc
1026 include/start_slave_sql.inc
1027 [connection master]
1028 include/save_binlog_position.inc
1029 CREATE DATABASE db;
1030 # Assert that binlog is as expected
1031 include/assert_grep.inc [Binlog should contain default_table_encryption=1]
1032 # Assert that object on master is "%ENCRYPTION='Y'%"
1033 include/sync_slave_sql_with_master.inc
1034 # Assert that object on slave is "%ENCRYPTION='Y'%"
1035 [connection master]
1036 include/sync_slave_sql_with_master.inc
1037 [connection master]
1038 SET @@session.default_table_encryption = 1-1;
1039 ==== ALTER DATABASE db CHARACTER SET = utf8 [master_session:1 master_global:1 slave_global:1] ====
1040 # ALTER: exclude the variable from the binlog
1041 [connection slave]
1042 include/stop_slave_sql.inc
1043 include/start_slave_sql.inc
1044 [connection master]
1045 include/save_binlog_position.inc
1046 ALTER DATABASE db CHARACTER SET = utf8;
1047 Warnings:
1048 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1049 # Assert that binlog is as expected
1050 include/assert_grep.inc [Binlog should not contain default_table_encryption]
1051 # Assert that object on master is "%ENCRYPTION='Y'%"
1052 include/sync_slave_sql_with_master.inc
1053 # Assert that object on slave is "%ENCRYPTION='Y'%"
1054 [connection master]
1055 DROP DATABASE db;
1056 include/sync_slave_sql_with_master.inc
1057 [connection master]
1058 SET @@session.default_table_encryption = 1;
1059 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'n' [master_session:1 master_global:1 slave_global:1] ====
1060 # CREATE with ENCRYPTION: exclude the variable from the binlog
1061 [connection slave]
1062 include/stop_slave_sql.inc
1063 include/start_slave_sql.inc
1064 [connection master]
1065 include/save_binlog_position.inc
1066 CREATE DATABASE db DEFAULT ENCRYPTION = 'n';
1067 # Assert that binlog is as expected
1068 include/assert_grep.inc [Binlog should not contain default_table_encryption]
1069 # Assert that object on master is "%ENCRYPTION='N'%"
1070 include/sync_slave_sql_with_master.inc
1071 # Assert that object on slave is "%ENCRYPTION='N'%"
1072 [connection master]
1073 DROP DATABASE db;
1074 include/sync_slave_sql_with_master.inc
1075 [connection master]
1076 ==== CREATE DATABASE db DEFAULT ENCRYPTION = 'y' [master_session:1 master_global:1 slave_global:1] ====
1077 # CREATE with ENCRYPTION: exclude the variable from the binlog
1078 [connection slave]
1079 include/stop_slave_sql.inc
1080 include/start_slave_sql.inc
1081 [connection master]
1082 include/save_binlog_position.inc
1083 CREATE DATABASE db DEFAULT ENCRYPTION = 'y';
1084 # Assert that binlog is as expected
1085 include/assert_grep.inc [Binlog should not contain default_table_encryption]
1086 # Assert that object on master is "%ENCRYPTION='Y'%"
1087 include/sync_slave_sql_with_master.inc
1088 # Assert that object on slave is "%ENCRYPTION='Y'%"
1089 [connection master]
1090 DROP DATABASE db;
1091 include/sync_slave_sql_with_master.inc
1092 [connection master]
1093 ==== CREATE TABLESPACE ts [master_session:1 master_global:1 slave_global:1] ====
1094 # CREATE without ENCRYPTION: include the variable in the binlog
1095 [connection slave]
1096 include/stop_slave_sql.inc
1097 include/start_slave_sql.inc
1098 [connection master]
1099 include/save_binlog_position.inc
1100 CREATE TABLESPACE ts;
1101 # Assert that binlog is as expected
1102 include/assert_grep.inc [Binlog should contain default_table_encryption=1]
1103 # Assert that object on master is "Y"
1104 include/sync_slave_sql_with_master.inc
1105 # Assert that object on slave is "Y"
1106 [connection master]
1107 include/sync_slave_sql_with_master.inc
1108 [connection master]
1109 SET @@session.default_table_encryption = 1-1;
1110 ==== ALTER TABLESPACE ts RENAME TO ts2 [master_session:1 master_global:1 slave_global:1] ====
1111 # ALTER should not include the variable in the binlog
1112 [connection slave]
1113 include/stop_slave_sql.inc
1114 include/start_slave_sql.inc
1115 [connection master]
1116 include/save_binlog_position.inc
1117 ALTER TABLESPACE ts RENAME TO ts2;
1118 # Assert that binlog is as expected
1119 include/assert_grep.inc [Binlog should not contain default_table_encryption]
1120 # Assert that object on master is "Y"
1121 include/sync_slave_sql_with_master.inc
1122 # Assert that object on slave is "Y"
1123 [connection master]
1124 DROP TABLESPACE ts2;
1125 include/sync_slave_sql_with_master.inc
1126 [connection master]
1127 SET @@session.default_table_encryption = 1;
1128 ==== CREATE TABLESPACE ts ENCRYPTION = 'y' [master_session:1 master_global:1 slave_global:1] ====
1129 # CREATE with ENCRYPTION: exclude the variable from the binlog
1130 [connection slave]
1131 include/stop_slave_sql.inc
1132 include/start_slave_sql.inc
1133 [connection master]
1134 include/save_binlog_position.inc
1135 CREATE TABLESPACE ts ENCRYPTION = 'y';
1136 # Assert that binlog is as expected
1137 include/assert_grep.inc [Binlog should not contain default_table_encryption]
1138 # Assert that object on master is "Y"
1139 include/sync_slave_sql_with_master.inc
1140 # Assert that object on slave is "Y"
1141 [connection master]
1142 DROP TABLESPACE ts;
1143 include/sync_slave_sql_with_master.inc
1144 [connection master]
1145 ==== CREATE TABLESPACE ts ENCRYPTION = 'n' [master_session:1 master_global:1 slave_global:1] ====
1146 # CREATE with ENCRYPTION: exclude the variable from the binlog
1147 [connection slave]
1148 include/stop_slave_sql.inc
1149 include/start_slave_sql.inc
1150 [connection master]
1151 include/save_binlog_position.inc
1152 CREATE TABLESPACE ts ENCRYPTION = 'n';
1153 # Assert that binlog is as expected
1154 include/assert_grep.inc [Binlog should not contain default_table_encryption]
1155 # Assert that object on master is "N"
1156 include/sync_slave_sql_with_master.inc
1157 # Assert that object on slave is "N"
1158 [connection master]
1159 DROP TABLESPACE ts;
1160 include/sync_slave_sql_with_master.inc
1161 [connection master]
1162 #### CLEANUP ####
1163 [connection master]
1164 SET @@global.default_table_encryption = @default_table_encryption_save;
1165 [connection slave]
1166 SET @@global.default_table_encryption = @default_table_encryption_save;
1167 include/rpl_end.inc