Debian Codegraph @

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