Debian Codegraph @

mysql-test/suite/component_keyring_file/r/rpl_default_table_encryption.result

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