Debian Codegraph @

mysql-test/suite/clone/r/remote_encrypt.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
6 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
7 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
8 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
9 PARTITION BY KEY(col1) PARTITIONS 5;
10 CREATE PROCEDURE execute_dml(
11 p_dml_type INT,
12 p_key_min INT,
13 p_key_range INT,
14 p_loop_count INT,
15 p_frequency INT,
16 p_is_rand INT)
17 BEGIN
18 DECLARE v_idx INT DEFAULT 0;
19 DECLARE v_commit INT DEFAULT 0;
20 DECLARE v_key INT DEFAULT 0;
21 /* Loop and INSERT data at random position */
22 WHILE(v_idx < p_loop_count) DO
23 /* Generate key between 1 to p_loop_count */
24 IF p_is_rand = 1 THEN
25 SET v_key = p_key_min + FLOOR(RAND() * p_key_range);
26 ELSE
27 SET v_key = p_key_min + (v_idx % p_key_range);
28 END IF;
29 CASE p_dml_type
30 WHEN 0 THEN
31 SET @clol3_text = CONCAT('Clone Test Row - ', v_key);
32 INSERT INTO t1 (col1, col2, col3, col4) VALUES (
33 v_key, v_key * 10,
34 @clol3_text, REPEAT('Large Column Data ', 2048))
35 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
36 INSERT INTO t2 (col1, col2, col3, col4) VALUES (
37 v_key, v_key * 10,
38 @clol3_text, REPEAT('Large Column Data ', 2048))
39 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
40 WHEN 1 THEN
41 UPDATE t1 SET col2 = v_idx + 1 WHERE col1 = v_key;
42 UPDATE t2 SET col2 = v_idx + 1 WHERE col1 = v_key;
43 WHEN 2 THEN
44 DELETE FROM t1 WHERE col1 = v_key;
45 DELETE FROM t2 WHERE col1 = v_key;
46 ELSE
47 DELETE FROM t1;
48 DELETE FROM t2;
49 END CASE;
50 SET v_idx = v_idx + 1;
51 /* Commit or rollback work at specified frequency. */
52 IF v_idx % p_frequency = 0 THEN
53 SET v_commit = FLOOR(RAND() * 2);
54 IF v_commit = 0 AND p_is_rand = 1 THEN
55 ROLLBACK;
56 START TRANSACTION;
57 ELSE
58 COMMIT;
59 START TRANSACTION;
60 END IF;
61 END IF;
62 END WHILE;
63 COMMIT;
64 END|
65 # In connection default - starting clone
66 SET DEBUG_SYNC = 'clone_file_copy SIGNAL set_encryption WAIT_FOR resume_clone';
67 SET GLOBAL clone_autotune_concurrency = OFF;
68 SET GLOBAL clone_max_concurrency = 8;
69 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
70 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
71 # In connection con1 - Trying to set redo and undo encryption
72 SET DEBUG_SYNC = 'now WAIT_FOR set_encryption';
73 SHOW VARIABLES LIKE 'innodb_redo_log_encrypt';
74 Variable_name Value
75 innodb_redo_log_encrypt OFF
76 SET GLOBAL innodb_redo_log_encrypt = ON;
77 SHOW VARIABLES LIKE 'innodb_redo_log_encrypt';
78 Variable_name Value
79 innodb_redo_log_encrypt ON
80 SHOW VARIABLES LIKE 'innodb_undo_log_encrypt';
81 Variable_name Value
82 innodb_undo_log_encrypt OFF
83 SET GLOBAL innodb_undo_log_encrypt = ON;
84 SHOW VARIABLES LIKE 'innodb_undo_log_encrypt';
85 Variable_name Value
86 innodb_undo_log_encrypt ON
87 SET DEBUG_SYNC = 'now SIGNAL resume_clone';
88 # In connection default - finishing Clone
89 SET GLOBAL innodb_redo_log_encrypt = OFF;
90 SET GLOBAL innodb_undo_log_encrypt = OFF;
91 DROP TABLE t1;
92 DROP TABLE t2;
93 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
94 ROW_FORMAT = COMPRESSED ENCRYPTION = "Y";
95 CREATE TABLESPACE tbs1 ADD DATAFILE 'tbs1_data1.ibd' ENCRYPTION="Y";
96 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
97 ENCRYPTION="Y" TABLESPACE = tbs1;
98 SET GLOBAL innodb_redo_log_encrypt = ON;
99 SHOW VARIABLES LIKE 'innodb_redo_log_encrypt';
100 Variable_name Value
101 innodb_redo_log_encrypt ON
102 SET GLOBAL innodb_undo_log_encrypt = ON;
103 SHOW VARIABLES LIKE 'innodb_undo_log_encrypt';
104 Variable_name Value
105 innodb_undo_log_encrypt ON
106 call execute_dml(0, 0, 200, 200, 100, 0);
107 SHOW CREATE TABLE t1;
108 Table Create Table
109 t1 CREATE TABLE `t1` (
110 `col1` int NOT NULL,
111 `col2` int DEFAULT NULL,
112 `col3` varchar(64) DEFAULT NULL,
113 `col4` blob,
114 PRIMARY KEY (`col1`)
115 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED ENCRYPTION='Y'
116 SELECT count(*) from t1;
117 count(*)
118 200
119 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
120 col1 col2 col3 SUBSTRING(col4, 1000, 32)
121 0 0 Clone Test Row - 0 umn Data Large Column Data Large
122 1 10 Clone Test Row - 1 umn Data Large Column Data Large
123 2 20 Clone Test Row - 2 umn Data Large Column Data Large
124 3 30 Clone Test Row - 3 umn Data Large Column Data Large
125 4 40 Clone Test Row - 4 umn Data Large Column Data Large
126 5 50 Clone Test Row - 5 umn Data Large Column Data Large
127 6 60 Clone Test Row - 6 umn Data Large Column Data Large
128 7 70 Clone Test Row - 7 umn Data Large Column Data Large
129 8 80 Clone Test Row - 8 umn Data Large Column Data Large
130 9 90 Clone Test Row - 9 umn Data Large Column Data Large
131 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
132 col1 col2 col3 SUBSTRING(col4, 1000, 32)
133 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
134 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
135 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
136 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
137 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
138 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
139 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
140 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
141 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
142 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
143 SHOW CREATE TABLE t2;
144 Table Create Table
145 t2 CREATE TABLE `t2` (
146 `col1` int NOT NULL,
147 `col2` int DEFAULT NULL,
148 `col3` varchar(64) DEFAULT NULL,
149 `col4` blob,
150 PRIMARY KEY (`col1`)
151 ) /*!50100 TABLESPACE `tbs1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!80016 ENCRYPTION='Y' */
152 SELECT count(*) from t2;
153 count(*)
154 200
155 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
156 col1 col2 col3 SUBSTRING(col4, 1000, 32)
157 0 0 Clone Test Row - 0 umn Data Large Column Data Large
158 1 10 Clone Test Row - 1 umn Data Large Column Data Large
159 2 20 Clone Test Row - 2 umn Data Large Column Data Large
160 3 30 Clone Test Row - 3 umn Data Large Column Data Large
161 4 40 Clone Test Row - 4 umn Data Large Column Data Large
162 5 50 Clone Test Row - 5 umn Data Large Column Data Large
163 6 60 Clone Test Row - 6 umn Data Large Column Data Large
164 7 70 Clone Test Row - 7 umn Data Large Column Data Large
165 8 80 Clone Test Row - 8 umn Data Large Column Data Large
166 9 90 Clone Test Row - 9 umn Data Large Column Data Large
167 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
168 col1 col2 col3 SUBSTRING(col4, 1000, 32)
169 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
170 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
171 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
172 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
173 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
174 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
175 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
176 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
177 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
178 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
179 SET GLOBAL innodb_buf_flush_list_now = 1;
180 SET GLOBAL clone_autotune_concurrency = OFF;
181 SET GLOBAL clone_max_concurrency = 8;
182 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
183 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
184 select ID, STATE, ERROR_NO from performance_schema.clone_status;
185 ID STATE ERROR_NO
186 1 Completed 0
187 select ID, STAGE, STATE from performance_schema.clone_progress;
188 ID STAGE STATE
189 1 DROP DATA Completed
190 1 FILE COPY Completed
191 1 PAGE COPY Completed
192 1 REDO COPY Completed
193 1 FILE SYNC Completed
194 1 RESTART Not Started
195 1 RECOVERY Not Started
196 # Restart cloned database
197 # restart: --datadir=CLONE_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
198 SHOW CREATE TABLE t1;
199 Table Create Table
200 t1 CREATE TABLE `t1` (
201 `col1` int NOT NULL,
202 `col2` int DEFAULT NULL,
203 `col3` varchar(64) DEFAULT NULL,
204 `col4` blob,
205 PRIMARY KEY (`col1`)
206 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED ENCRYPTION='Y'
207 SELECT count(*) from t1;
208 count(*)
209 200
210 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
211 col1 col3 SUBSTRING(col4, 1000, 32)
212 0 Clone Test Row - 0 umn Data Large Column Data Large
213 1 Clone Test Row - 1 umn Data Large Column Data Large
214 2 Clone Test Row - 2 umn Data Large Column Data Large
215 3 Clone Test Row - 3 umn Data Large Column Data Large
216 4 Clone Test Row - 4 umn Data Large Column Data Large
217 5 Clone Test Row - 5 umn Data Large Column Data Large
218 6 Clone Test Row - 6 umn Data Large Column Data Large
219 7 Clone Test Row - 7 umn Data Large Column Data Large
220 8 Clone Test Row - 8 umn Data Large Column Data Large
221 9 Clone Test Row - 9 umn Data Large Column Data Large
222 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
223 col1 col3 SUBSTRING(col4, 1000, 32)
224 199 Clone Test Row - 199 umn Data Large Column Data Large
225 198 Clone Test Row - 198 umn Data Large Column Data Large
226 197 Clone Test Row - 197 umn Data Large Column Data Large
227 196 Clone Test Row - 196 umn Data Large Column Data Large
228 195 Clone Test Row - 195 umn Data Large Column Data Large
229 194 Clone Test Row - 194 umn Data Large Column Data Large
230 193 Clone Test Row - 193 umn Data Large Column Data Large
231 192 Clone Test Row - 192 umn Data Large Column Data Large
232 191 Clone Test Row - 191 umn Data Large Column Data Large
233 190 Clone Test Row - 190 umn Data Large Column Data Large
234 SHOW CREATE TABLE t2;
235 Table Create Table
236 t2 CREATE TABLE `t2` (
237 `col1` int NOT NULL,
238 `col2` int DEFAULT NULL,
239 `col3` varchar(64) DEFAULT NULL,
240 `col4` blob,
241 PRIMARY KEY (`col1`)
242 ) /*!50100 TABLESPACE `tbs1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!80016 ENCRYPTION='Y' */
243 SELECT count(*) from t2;
244 count(*)
245 200
246 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
247 col1 col3 SUBSTRING(col4, 1000, 32)
248 0 Clone Test Row - 0 umn Data Large Column Data Large
249 1 Clone Test Row - 1 umn Data Large Column Data Large
250 2 Clone Test Row - 2 umn Data Large Column Data Large
251 3 Clone Test Row - 3 umn Data Large Column Data Large
252 4 Clone Test Row - 4 umn Data Large Column Data Large
253 5 Clone Test Row - 5 umn Data Large Column Data Large
254 6 Clone Test Row - 6 umn Data Large Column Data Large
255 7 Clone Test Row - 7 umn Data Large Column Data Large
256 8 Clone Test Row - 8 umn Data Large Column Data Large
257 9 Clone Test Row - 9 umn Data Large Column Data Large
258 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
259 col1 col3 SUBSTRING(col4, 1000, 32)
260 199 Clone Test Row - 199 umn Data Large Column Data Large
261 198 Clone Test Row - 198 umn Data Large Column Data Large
262 197 Clone Test Row - 197 umn Data Large Column Data Large
263 196 Clone Test Row - 196 umn Data Large Column Data Large
264 195 Clone Test Row - 195 umn Data Large Column Data Large
265 194 Clone Test Row - 194 umn Data Large Column Data Large
266 193 Clone Test Row - 193 umn Data Large Column Data Large
267 192 Clone Test Row - 192 umn Data Large Column Data Large
268 191 Clone Test Row - 191 umn Data Large Column Data Large
269 190 Clone Test Row - 190 umn Data Large Column Data Large
270 call execute_dml(3, 0, 1, 1, 1, 0);
271 call execute_dml(0, 0, 200, 200, 100, 0);
272 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
273 col1 col2 col3 SUBSTRING(col4, 1000, 32)
274 0 0 Clone Test Row - 0 umn Data Large Column Data Large
275 1 10 Clone Test Row - 1 umn Data Large Column Data Large
276 2 20 Clone Test Row - 2 umn Data Large Column Data Large
277 3 30 Clone Test Row - 3 umn Data Large Column Data Large
278 4 40 Clone Test Row - 4 umn Data Large Column Data Large
279 5 50 Clone Test Row - 5 umn Data Large Column Data Large
280 6 60 Clone Test Row - 6 umn Data Large Column Data Large
281 7 70 Clone Test Row - 7 umn Data Large Column Data Large
282 8 80 Clone Test Row - 8 umn Data Large Column Data Large
283 9 90 Clone Test Row - 9 umn Data Large Column Data Large
284 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
285 col1 col2 col3 SUBSTRING(col4, 1000, 32)
286 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
287 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
288 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
289 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
290 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
291 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
292 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
293 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
294 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
295 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
296 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
297 col1 col2 col3 SUBSTRING(col4, 1000, 32)
298 0 0 Clone Test Row - 0 umn Data Large Column Data Large
299 1 10 Clone Test Row - 1 umn Data Large Column Data Large
300 2 20 Clone Test Row - 2 umn Data Large Column Data Large
301 3 30 Clone Test Row - 3 umn Data Large Column Data Large
302 4 40 Clone Test Row - 4 umn Data Large Column Data Large
303 5 50 Clone Test Row - 5 umn Data Large Column Data Large
304 6 60 Clone Test Row - 6 umn Data Large Column Data Large
305 7 70 Clone Test Row - 7 umn Data Large Column Data Large
306 8 80 Clone Test Row - 8 umn Data Large Column Data Large
307 9 90 Clone Test Row - 9 umn Data Large Column Data Large
308 # restart: --datadir=ENCRYPT_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
309 SET GLOBAL innodb_redo_log_encrypt = ON;
310 SET GLOBAL innodb_undo_log_encrypt = ON;
311 # In connection default - Cloning database
312 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
313 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
314 SET GLOBAL clone_autotune_concurrency = OFF;
315 SET GLOBAL clone_max_concurrency = 8;
316 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
317 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
318 # In connection con1 - Running Update Random [0 - 200 Key Range]
319 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
320 START TRANSACTION;
321 CALL execute_dml(1, 0, 200, 500, 100, 1);
322 COMMIT;
323 # Flush all dirty buffers
324 SET GLOBAL innodb_buf_flush_list_now = 1;
325 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
326 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
327 START TRANSACTION;
328 CALL execute_dml(1, 0, 200, 500, 100, 1);
329 COMMIT;
330 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
331 # In connection default - Cloning database
332 # Restart cloned database
333 # restart: --datadir=CLONE_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
334 SHOW CREATE TABLE t1;
335 Table Create Table
336 t1 CREATE TABLE `t1` (
337 `col1` int NOT NULL,
338 `col2` int DEFAULT NULL,
339 `col3` varchar(64) DEFAULT NULL,
340 `col4` blob,
341 PRIMARY KEY (`col1`)
342 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED ENCRYPTION='Y'
343 SELECT count(*) from t1;
344 count(*)
345 200
346 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
347 col1 col3 SUBSTRING(col4, 1000, 32)
348 0 Clone Test Row - 0 umn Data Large Column Data Large
349 1 Clone Test Row - 1 umn Data Large Column Data Large
350 2 Clone Test Row - 2 umn Data Large Column Data Large
351 3 Clone Test Row - 3 umn Data Large Column Data Large
352 4 Clone Test Row - 4 umn Data Large Column Data Large
353 5 Clone Test Row - 5 umn Data Large Column Data Large
354 6 Clone Test Row - 6 umn Data Large Column Data Large
355 7 Clone Test Row - 7 umn Data Large Column Data Large
356 8 Clone Test Row - 8 umn Data Large Column Data Large
357 9 Clone Test Row - 9 umn Data Large Column Data Large
358 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
359 col1 col3 SUBSTRING(col4, 1000, 32)
360 199 Clone Test Row - 199 umn Data Large Column Data Large
361 198 Clone Test Row - 198 umn Data Large Column Data Large
362 197 Clone Test Row - 197 umn Data Large Column Data Large
363 196 Clone Test Row - 196 umn Data Large Column Data Large
364 195 Clone Test Row - 195 umn Data Large Column Data Large
365 194 Clone Test Row - 194 umn Data Large Column Data Large
366 193 Clone Test Row - 193 umn Data Large Column Data Large
367 192 Clone Test Row - 192 umn Data Large Column Data Large
368 191 Clone Test Row - 191 umn Data Large Column Data Large
369 190 Clone Test Row - 190 umn Data Large Column Data Large
370 SHOW CREATE TABLE t2;
371 Table Create Table
372 t2 CREATE TABLE `t2` (
373 `col1` int NOT NULL,
374 `col2` int DEFAULT NULL,
375 `col3` varchar(64) DEFAULT NULL,
376 `col4` blob,
377 PRIMARY KEY (`col1`)
378 ) /*!50100 TABLESPACE `tbs1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!80016 ENCRYPTION='Y' */
379 SELECT count(*) from t2;
380 count(*)
381 200
382 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
383 col1 col3 SUBSTRING(col4, 1000, 32)
384 0 Clone Test Row - 0 umn Data Large Column Data Large
385 1 Clone Test Row - 1 umn Data Large Column Data Large
386 2 Clone Test Row - 2 umn Data Large Column Data Large
387 3 Clone Test Row - 3 umn Data Large Column Data Large
388 4 Clone Test Row - 4 umn Data Large Column Data Large
389 5 Clone Test Row - 5 umn Data Large Column Data Large
390 6 Clone Test Row - 6 umn Data Large Column Data Large
391 7 Clone Test Row - 7 umn Data Large Column Data Large
392 8 Clone Test Row - 8 umn Data Large Column Data Large
393 9 Clone Test Row - 9 umn Data Large Column Data Large
394 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
395 col1 col3 SUBSTRING(col4, 1000, 32)
396 199 Clone Test Row - 199 umn Data Large Column Data Large
397 198 Clone Test Row - 198 umn Data Large Column Data Large
398 197 Clone Test Row - 197 umn Data Large Column Data Large
399 196 Clone Test Row - 196 umn Data Large Column Data Large
400 195 Clone Test Row - 195 umn Data Large Column Data Large
401 194 Clone Test Row - 194 umn Data Large Column Data Large
402 193 Clone Test Row - 193 umn Data Large Column Data Large
403 192 Clone Test Row - 192 umn Data Large Column Data Large
404 191 Clone Test Row - 191 umn Data Large Column Data Large
405 190 Clone Test Row - 190 umn Data Large Column Data Large
406 call execute_dml(3, 0, 1, 1, 1, 0);
407 call execute_dml(0, 0, 200, 200, 100, 0);
408 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
409 col1 col2 col3 SUBSTRING(col4, 1000, 32)
410 0 0 Clone Test Row - 0 umn Data Large Column Data Large
411 1 10 Clone Test Row - 1 umn Data Large Column Data Large
412 2 20 Clone Test Row - 2 umn Data Large Column Data Large
413 3 30 Clone Test Row - 3 umn Data Large Column Data Large
414 4 40 Clone Test Row - 4 umn Data Large Column Data Large
415 5 50 Clone Test Row - 5 umn Data Large Column Data Large
416 6 60 Clone Test Row - 6 umn Data Large Column Data Large
417 7 70 Clone Test Row - 7 umn Data Large Column Data Large
418 8 80 Clone Test Row - 8 umn Data Large Column Data Large
419 9 90 Clone Test Row - 9 umn Data Large Column Data Large
420 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
421 col1 col2 col3 SUBSTRING(col4, 1000, 32)
422 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
423 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
424 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
425 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
426 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
427 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
428 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
429 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
430 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
431 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
432 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
433 col1 col2 col3 SUBSTRING(col4, 1000, 32)
434 0 0 Clone Test Row - 0 umn Data Large Column Data Large
435 1 10 Clone Test Row - 1 umn Data Large Column Data Large
436 2 20 Clone Test Row - 2 umn Data Large Column Data Large
437 3 30 Clone Test Row - 3 umn Data Large Column Data Large
438 4 40 Clone Test Row - 4 umn Data Large Column Data Large
439 5 50 Clone Test Row - 5 umn Data Large Column Data Large
440 6 60 Clone Test Row - 6 umn Data Large Column Data Large
441 7 70 Clone Test Row - 7 umn Data Large Column Data Large
442 8 80 Clone Test Row - 8 umn Data Large Column Data Large
443 9 90 Clone Test Row - 9 umn Data Large Column Data Large
444 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
445 col1 col2 col3 SUBSTRING(col4, 1000, 32)
446 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
447 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
448 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
449 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
450 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
451 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
452 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
453 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
454 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
455 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
456 # restart: --datadir=ENCRYPT_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
457 DROP TABLE t1;
458 DROP TABLE t2;
459 DROP PROCEDURE execute_dml;
460 DROP TABLESPACE tbs1;
461 UNINSTALL PLUGIN clone;
462 UNINSTALL PLUGIN keyring_file;
463 SET DEBUG_SYNC = 'RESET';
464 # Restart server and remove encrypted data directory
465 # restart: