Debian Codegraph @

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