Debian Codegraph @

mysql-test/suite/clone/r/remote_ddl_sys_encrypt_file_copy.result

raw
1 # Prepare for creating Encrypted Table
2 # create bootstrap file
3 # Create and start mysqld with keyring plugin.
4 # restart: --datadir=ENCRYPT_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
5 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
6 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
7 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
8 PARTITION BY KEY(col1) PARTITIONS 5;
9 CREATE PROCEDURE execute_dml(
10 p_dml_type INT,
11 p_key_min INT,
12 p_key_range INT,
13 p_loop_count INT,
14 p_frequency INT,
15 p_is_rand INT)
16 BEGIN
17 DECLARE v_idx INT DEFAULT 0;
18 DECLARE v_commit INT DEFAULT 0;
19 DECLARE v_key INT DEFAULT 0;
20 /* Loop and INSERT data at random position */
21 WHILE(v_idx < p_loop_count) DO
22 /* Generate key between 1 to p_loop_count */
23 IF p_is_rand = 1 THEN
24 SET v_key = p_key_min + FLOOR(RAND() * p_key_range);
25 ELSE
26 SET v_key = p_key_min + (v_idx % p_key_range);
27 END IF;
28 CASE p_dml_type
29 WHEN 0 THEN
30 SET @clol3_text = CONCAT('Clone Test Row - ', v_key);
31 INSERT INTO t1 (col1, col2, col3, col4) VALUES (
32 v_key, v_key * 10,
33 @clol3_text, REPEAT('Large Column Data ', 2048))
34 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
35 INSERT INTO t2 (col1, col2, col3, col4) VALUES (
36 v_key, v_key * 10,
37 @clol3_text, REPEAT('Large Column Data ', 2048))
38 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
39 WHEN 1 THEN
40 UPDATE t1 SET col2 = v_idx + 1 WHERE col1 = v_key;
41 UPDATE t2 SET col2 = v_idx + 1 WHERE col1 = v_key;
42 WHEN 2 THEN
43 DELETE FROM t1 WHERE col1 = v_key;
44 DELETE FROM t2 WHERE col1 = v_key;
45 ELSE
46 DELETE FROM t1;
47 DELETE FROM t2;
48 END CASE;
49 SET v_idx = v_idx + 1;
50 /* Commit or rollback work at specified frequency. */
51 IF v_idx % p_frequency = 0 THEN
52 SET v_commit = FLOOR(RAND() * 2);
53 IF v_commit = 0 AND p_is_rand = 1 THEN
54 ROLLBACK;
55 START TRANSACTION;
56 ELSE
57 COMMIT;
58 START TRANSACTION;
59 END IF;
60 END IF;
61 END WHILE;
62 COMMIT;
63 END|
64 call execute_dml(0, 0, 100, 100, 10, 0);
65 CREATE TABLE t SELECT * FROM t1;
66 CREATE TABLE t0 (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
67 CREATE TABLE t01 (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
68 CREATE TABLE t3 (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
69 CREATE TABLE t11 (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
70 CREATE TABLE t21 (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
71 INSERT INTO t11 SELECT * FROM t;
72 INSERT INTO t21 SELECT * FROM t;
73 SHOW VARIABLES LIKE 'clone_ddl_timeout';
74 Variable_name Value
75 clone_ddl_timeout 300
76 SHOW VARIABLES LIKE 'clone_block_ddl';
77 Variable_name Value
78 clone_block_ddl OFF
79 CREATE TABLESPACE tbs;
80 DROP TABLE t1;
81 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
82 TABLESPACE = tbs;
83 DROP TABLE t2;
84 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
85 TABLESPACE = tbs;
86 # 1. Enable REDO and UNDO encryption while clone in progress
87 RESET MASTER;
88 SET GLOBAL DEBUG = '+d,remote_release_clone_file_pin';
89 SET GLOBAL DEBUG = '+d,log_redo_with_invalid_master_key';
90 SET DEBUG_SYNC = 'clone_before_init_meta SIGNAL start_ddl_file_init WAIT_FOR resume_file_init';
91 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl_file WAIT_FOR resume_file';
92 SET DEBUG_SYNC = 'clone_file_copy_end_before_ack SIGNAL start_ddl_file_ack WAIT_FOR resume_file_ack';
93 SET DEBUG_SYNC = 'clone_before_file_ddl_meta SIGNAL start_ddl_file_meta WAIT_FOR resume_file_meta';
94 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_ddl_page WAIT_FOR resume_page';
95 SET DEBUG_SYNC = 'clone_before_page_ddl_meta SIGNAL start_ddl_page_meta WAIT_FOR resume_page_meta';
96 SET DEBUG_SYNC = 'clone_redo_copy SIGNAL start_ddl_redo WAIT_FOR resume_redo';
97 SET GLOBAL clone_autotune_concurrency = OFF;
98 SET GLOBAL clone_max_concurrency = 8;
99 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
100 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
101 # In connection CON1
102 SET GLOBAL innodb_redo_log_encrypt = ON;
103 SET GLOBAL innodb_undo_log_encrypt = ON;
104 ALTER TABLESPACE tbs ENCRYPTION = 'Y';
105 SET DEBUG_SYNC = 'now SIGNAL resume_file_init';
106 # Waiting for clone to reach 'file copy'
107 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file';
108 # Wait finished
109 # For remote clone, let the donor progress concurrently
110 # otherwise file pins may not be released causing deadlock
111 SET DEBUG_SYNC = 'clone_notify_ddl SIGNAL resume_file';
112 SET GLOBAL innodb_redo_log_encrypt = ON;
113 SET GLOBAL innodb_undo_log_encrypt = ON;
114 ALTER TABLESPACE tbs ENCRYPTION = 'Y';
115 CALL execute_dml(0, 0, 100, 100, 10, 0);
116 # Flush all dirty pages to track
117 SET GLOBAL innodb_buf_flush_list_now = 1;
118 SET DEBUG_SYNC = 'now SIGNAL resume_file';
119 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file_ack';
120 SET DEBUG_SYNC = 'now SIGNAL resume_file_ack';
121 SET GLOBAL innodb_redo_log_encrypt = ON;
122 SET GLOBAL innodb_undo_log_encrypt = ON;
123 ALTER TABLESPACE tbs ENCRYPTION = 'Y';
124 CALL execute_dml(0, 0, 100, 100, 10, 0);
125 SET DEBUG_SYNC = 'now SIGNAL resume_file_meta';
126 # Waiting for clone to reach 'page copy'
127 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_page';
128 # Wait finished
129 SET GLOBAL innodb_redo_log_encrypt = ON;
130 SET GLOBAL innodb_undo_log_encrypt = ON;
131 ALTER TABLESPACE tbs ENCRYPTION = 'Y';
132 CALL execute_dml(0, 0, 100, 100, 10, 0);
133 SET DEBUG_SYNC = 'now SIGNAL resume_page';
134 # Waiting for clone to reach 'redo copy'
135 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_redo';
136 # Wait finished
137 SET GLOBAL innodb_redo_log_encrypt = ON;
138 SET GLOBAL innodb_undo_log_encrypt = ON;
139 ALTER TABLESPACE tbs ENCRYPTION = 'Y';
140 CALL execute_dml(0, 0, 100, 100, 10, 0);
141 SET GLOBAL innodb_redo_log_encrypt = ON;
142 SET GLOBAL innodb_undo_log_encrypt = ON;
143 ALTER TABLESPACE tbs ENCRYPTION = 'Y';
144 SET DEBUG_SYNC = 'now SIGNAL resume_redo';
145 # In connection DEFAULT
146 # Waiting for clone to complete
147 # Wait finished
148 SET GLOBAL DEBUG = '-d,remote_release_clone_file_pin';
149 # Restart server on cloned data directory
150 # restart: --datadir=CLONE_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
151 # Check cloned data
152 SHOW TABLES;
153 Tables_in_test
154 t
155 t0
156 t01
157 t1
158 t11
159 t2
160 t21
161 t3
162 SHOW CREATE TABLE t1;
163 Table Create Table
164 t1 CREATE TABLE `t1` (
165 `col1` int NOT NULL,
166 `col2` int DEFAULT NULL,
167 `col3` varchar(64) DEFAULT NULL,
168 `col4` blob,
169 PRIMARY KEY (`col1`)
170 ) /*!50100 TABLESPACE `tbs` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!80016 ENCRYPTION='Y' */
171 CHECK TABLE t1 EXTENDED;
172 Table Op Msg_type Msg_text
173 test.t1 check status OK
174 SELECT count(*) from t1;
175 count(*)
176 100
177 SELECT col1, col2, col3 FROM t1 ORDER BY col1 LIMIT 10;;
178 col1 col2 col3
179 0 2 Clone Test Row - 0
180 1 12 Clone Test Row - 1
181 2 22 Clone Test Row - 2
182 3 32 Clone Test Row - 3
183 4 42 Clone Test Row - 4
184 5 52 Clone Test Row - 5
185 6 62 Clone Test Row - 6
186 7 72 Clone Test Row - 7
187 8 82 Clone Test Row - 8
188 9 92 Clone Test Row - 9
189 SELECT col1, col2, col3 FROM t1 ORDER BY col1 DESC LIMIT 10;;
190 col1 col2 col3
191 99 992 Clone Test Row - 99
192 98 982 Clone Test Row - 98
193 97 972 Clone Test Row - 97
194 96 962 Clone Test Row - 96
195 95 952 Clone Test Row - 95
196 94 942 Clone Test Row - 94
197 93 932 Clone Test Row - 93
198 92 922 Clone Test Row - 92
199 91 912 Clone Test Row - 91
200 90 902 Clone Test Row - 90
201 SHOW CREATE TABLE t11;
202 Table Create Table
203 t11 CREATE TABLE `t11` (
204 `col1` int NOT NULL,
205 `col2` int DEFAULT NULL,
206 `col3` varchar(64) DEFAULT NULL,
207 `col4` blob,
208 PRIMARY KEY (`col1`)
209 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
210 CHECK TABLE t11 EXTENDED;
211 Table Op Msg_type Msg_text
212 test.t11 check status OK
213 SELECT count(*) from t11;
214 count(*)
215 100
216 SELECT col1, col2, col3 FROM t11 ORDER BY col1 LIMIT 10;;
217 col1 col2 col3
218 0 0 Clone Test Row - 0
219 1 10 Clone Test Row - 1
220 2 20 Clone Test Row - 2
221 3 30 Clone Test Row - 3
222 4 40 Clone Test Row - 4
223 5 50 Clone Test Row - 5
224 6 60 Clone Test Row - 6
225 7 70 Clone Test Row - 7
226 8 80 Clone Test Row - 8
227 9 90 Clone Test Row - 9
228 SELECT col1, col2, col3 FROM t11 ORDER BY col1 DESC LIMIT 10;;
229 col1 col2 col3
230 99 990 Clone Test Row - 99
231 98 980 Clone Test Row - 98
232 97 970 Clone Test Row - 97
233 96 960 Clone Test Row - 96
234 95 950 Clone Test Row - 95
235 94 940 Clone Test Row - 94
236 93 930 Clone Test Row - 93
237 92 920 Clone Test Row - 92
238 91 910 Clone Test Row - 91
239 90 900 Clone Test Row - 90
240 SHOW CREATE TABLE t2;
241 Table Create Table
242 t2 CREATE TABLE `t2` (
243 `col1` int NOT NULL,
244 `col2` int DEFAULT NULL,
245 `col3` varchar(64) DEFAULT NULL,
246 `col4` blob,
247 PRIMARY KEY (`col1`)
248 ) /*!50100 TABLESPACE `tbs` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!80016 ENCRYPTION='Y' */
249 CHECK TABLE t2 EXTENDED;
250 Table Op Msg_type Msg_text
251 test.t2 check status OK
252 SELECT count(*) from t2;
253 count(*)
254 100
255 SELECT col1, col2, col3 FROM t2 ORDER BY col1 LIMIT 10;;
256 col1 col2 col3
257 0 2 Clone Test Row - 0
258 1 12 Clone Test Row - 1
259 2 22 Clone Test Row - 2
260 3 32 Clone Test Row - 3
261 4 42 Clone Test Row - 4
262 5 52 Clone Test Row - 5
263 6 62 Clone Test Row - 6
264 7 72 Clone Test Row - 7
265 8 82 Clone Test Row - 8
266 9 92 Clone Test Row - 9
267 SELECT col1, col2, col3 FROM t2 ORDER BY col1 DESC LIMIT 10;;
268 col1 col2 col3
269 99 992 Clone Test Row - 99
270 98 982 Clone Test Row - 98
271 97 972 Clone Test Row - 97
272 96 962 Clone Test Row - 96
273 95 952 Clone Test Row - 95
274 94 942 Clone Test Row - 94
275 93 932 Clone Test Row - 93
276 92 922 Clone Test Row - 92
277 91 912 Clone Test Row - 91
278 90 902 Clone Test Row - 90
279 call execute_dml(1, 0, 100, 100, 10, 0);
280 # Restart server back on base data directory
281 # restart: --datadir=ENCRYPT_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
282 SET DEBUG_SYNC = 'RESET';
283 # 2. Disable REDO and UNDO encryption while clone in progress
284 RESET MASTER;
285 SET GLOBAL DEBUG = '+d,remote_release_clone_file_pin';
286 SET GLOBAL DEBUG = '+d,log_redo_with_invalid_master_key';
287 SET DEBUG_SYNC = 'clone_before_init_meta SIGNAL start_ddl_file_init WAIT_FOR resume_file_init';
288 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl_file WAIT_FOR resume_file';
289 SET DEBUG_SYNC = 'clone_file_copy_end_before_ack SIGNAL start_ddl_file_ack WAIT_FOR resume_file_ack';
290 SET DEBUG_SYNC = 'clone_before_file_ddl_meta SIGNAL start_ddl_file_meta WAIT_FOR resume_file_meta';
291 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_ddl_page WAIT_FOR resume_page';
292 SET DEBUG_SYNC = 'clone_before_page_ddl_meta SIGNAL start_ddl_page_meta WAIT_FOR resume_page_meta';
293 SET DEBUG_SYNC = 'clone_redo_copy SIGNAL start_ddl_redo WAIT_FOR resume_redo';
294 SET GLOBAL clone_autotune_concurrency = OFF;
295 SET GLOBAL clone_max_concurrency = 8;
296 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
297 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
298 # In connection CON1
299 SET GLOBAL innodb_redo_log_encrypt = OFF;
300 SET GLOBAL innodb_undo_log_encrypt = OFF;
301 ALTER TABLESPACE tbs ENCRYPTION = 'N';
302 SET DEBUG_SYNC = 'now SIGNAL resume_file_init';
303 # Waiting for clone to reach 'file copy'
304 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file';
305 # Wait finished
306 # For remote clone, let the donor progress concurrently
307 # otherwise file pins may not be released causing deadlock
308 SET DEBUG_SYNC = 'clone_notify_ddl SIGNAL resume_file';
309 SET GLOBAL innodb_redo_log_encrypt = OFF;
310 SET GLOBAL innodb_undo_log_encrypt = OFF;
311 ALTER TABLESPACE tbs ENCRYPTION = 'N';
312 call execute_dml(1, 0, 100, 100, 10, 0);
313 # Flush all dirty pages to track
314 SET GLOBAL innodb_buf_flush_list_now = 1;
315 SET DEBUG_SYNC = 'now SIGNAL resume_file';
316 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file_ack';
317 SET DEBUG_SYNC = 'now SIGNAL resume_file_ack';
318 SET GLOBAL innodb_redo_log_encrypt = OFF;
319 SET GLOBAL innodb_undo_log_encrypt = OFF;
320 ALTER TABLESPACE tbs ENCRYPTION = 'N';
321 INSERT INTO t11 SELECT * FROM t ON DUPLICATE KEY UPDATE col2 = t11.col2 + 1;;
322 SET DEBUG_SYNC = 'now SIGNAL resume_file_meta';
323 # Waiting for clone to reach 'page copy'
324 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_page';
325 # Wait finished
326 SET GLOBAL innodb_redo_log_encrypt = OFF;
327 SET GLOBAL innodb_undo_log_encrypt = OFF;
328 ALTER TABLESPACE tbs ENCRYPTION = 'N';
329 call execute_dml(1, 0, 100, 100, 10, 0);
330 SET DEBUG_SYNC = 'now SIGNAL resume_page';
331 # Waiting for clone to reach 'redo copy'
332 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_redo';
333 # Wait finished
334 SET GLOBAL innodb_redo_log_encrypt = OFF;
335 SET GLOBAL innodb_undo_log_encrypt = OFF;
336 ALTER TABLESPACE tbs ENCRYPTION = 'N';
337 INSERT INTO t21 SELECT * FROM t ON DUPLICATE KEY UPDATE col2 = t21.col2 + 1;;
338 SET GLOBAL innodb_redo_log_encrypt = OFF;
339 SET GLOBAL innodb_undo_log_encrypt = OFF;
340 ALTER TABLESPACE tbs ENCRYPTION = 'N';
341 SET DEBUG_SYNC = 'now SIGNAL resume_redo';
342 # In connection DEFAULT
343 # Waiting for clone to complete
344 # Wait finished
345 SET GLOBAL DEBUG = '-d,remote_release_clone_file_pin';
346 # Restart server on cloned data directory
347 # restart: --datadir=CLONE_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
348 # Check cloned data
349 SHOW TABLES;
350 Tables_in_test
351 t
352 t0
353 t01
354 t1
355 t11
356 t2
357 t21
358 t3
359 SHOW CREATE TABLE t1;
360 Table Create Table
361 t1 CREATE TABLE `t1` (
362 `col1` int NOT NULL,
363 `col2` int DEFAULT NULL,
364 `col3` varchar(64) DEFAULT NULL,
365 `col4` blob,
366 PRIMARY KEY (`col1`)
367 ) /*!50100 TABLESPACE `tbs` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
368 CHECK TABLE t1 EXTENDED;
369 Table Op Msg_type Msg_text
370 test.t1 check status OK
371 SELECT count(*) from t1;
372 count(*)
373 100
374 SELECT col1, col2, col3 FROM t1 ORDER BY col1 LIMIT 10;;
375 col1 col2 col3
376 0 1 Clone Test Row - 0
377 1 2 Clone Test Row - 1
378 2 3 Clone Test Row - 2
379 3 4 Clone Test Row - 3
380 4 5 Clone Test Row - 4
381 5 6 Clone Test Row - 5
382 6 7 Clone Test Row - 6
383 7 8 Clone Test Row - 7
384 8 9 Clone Test Row - 8
385 9 10 Clone Test Row - 9
386 SELECT col1, col2, col3 FROM t1 ORDER BY col1 DESC LIMIT 10;;
387 col1 col2 col3
388 99 100 Clone Test Row - 99
389 98 99 Clone Test Row - 98
390 97 98 Clone Test Row - 97
391 96 97 Clone Test Row - 96
392 95 96 Clone Test Row - 95
393 94 95 Clone Test Row - 94
394 93 94 Clone Test Row - 93
395 92 93 Clone Test Row - 92
396 91 92 Clone Test Row - 91
397 90 91 Clone Test Row - 90
398 SHOW CREATE TABLE t11;
399 Table Create Table
400 t11 CREATE TABLE `t11` (
401 `col1` int NOT NULL,
402 `col2` int DEFAULT NULL,
403 `col3` varchar(64) DEFAULT NULL,
404 `col4` blob,
405 PRIMARY KEY (`col1`)
406 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
407 CHECK TABLE t11 EXTENDED;
408 Table Op Msg_type Msg_text
409 test.t11 check status OK
410 SELECT count(*) from t11;
411 count(*)
412 100
413 SELECT col1, col2, col3 FROM t11 ORDER BY col1 LIMIT 10;;
414 col1 col2 col3
415 0 1 Clone Test Row - 0
416 1 11 Clone Test Row - 1
417 2 21 Clone Test Row - 2
418 3 31 Clone Test Row - 3
419 4 41 Clone Test Row - 4
420 5 51 Clone Test Row - 5
421 6 61 Clone Test Row - 6
422 7 71 Clone Test Row - 7
423 8 81 Clone Test Row - 8
424 9 91 Clone Test Row - 9
425 SELECT col1, col2, col3 FROM t11 ORDER BY col1 DESC LIMIT 10;;
426 col1 col2 col3
427 99 991 Clone Test Row - 99
428 98 981 Clone Test Row - 98
429 97 971 Clone Test Row - 97
430 96 961 Clone Test Row - 96
431 95 951 Clone Test Row - 95
432 94 941 Clone Test Row - 94
433 93 931 Clone Test Row - 93
434 92 921 Clone Test Row - 92
435 91 911 Clone Test Row - 91
436 90 901 Clone Test Row - 90
437 SHOW CREATE TABLE t2;
438 Table Create Table
439 t2 CREATE TABLE `t2` (
440 `col1` int NOT NULL,
441 `col2` int DEFAULT NULL,
442 `col3` varchar(64) DEFAULT NULL,
443 `col4` blob,
444 PRIMARY KEY (`col1`)
445 ) /*!50100 TABLESPACE `tbs` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
446 CHECK TABLE t2 EXTENDED;
447 Table Op Msg_type Msg_text
448 test.t2 check status OK
449 SELECT count(*) from t2;
450 count(*)
451 100
452 SELECT col1, col2, col3 FROM t2 ORDER BY col1 LIMIT 10;;
453 col1 col2 col3
454 0 1 Clone Test Row - 0
455 1 2 Clone Test Row - 1
456 2 3 Clone Test Row - 2
457 3 4 Clone Test Row - 3
458 4 5 Clone Test Row - 4
459 5 6 Clone Test Row - 5
460 6 7 Clone Test Row - 6
461 7 8 Clone Test Row - 7
462 8 9 Clone Test Row - 8
463 9 10 Clone Test Row - 9
464 SELECT col1, col2, col3 FROM t2 ORDER BY col1 DESC LIMIT 10;;
465 col1 col2 col3
466 99 100 Clone Test Row - 99
467 98 99 Clone Test Row - 98
468 97 98 Clone Test Row - 97
469 96 97 Clone Test Row - 96
470 95 96 Clone Test Row - 95
471 94 95 Clone Test Row - 94
472 93 94 Clone Test Row - 93
473 92 93 Clone Test Row - 92
474 91 92 Clone Test Row - 91
475 90 91 Clone Test Row - 90
476 call execute_dml(1, 0, 100, 100, 10, 0);
477 # Restart server back on base data directory
478 # restart: --datadir=ENCRYPT_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
479 SET DEBUG_SYNC = 'RESET';
480 # Cleanup
481 DROP TABLE t;
482 DROP TABLE t1;
483 DROP TABLE t2;
484 DROP PROCEDURE execute_dml;
485 DROP TABLE t0;
486 DROP TABLE t01;
487 DROP TABLE t3;
488 DROP TABLE t11;
489 DROP TABLE t21;
490 DROP TABLESPACE tbs;
491 # Uninstall clone
492 UNINSTALL PLUGIN clone;
493 # Restart server and remove encrypted data directory
494 # restart: