Debian Codegraph @

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

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