Debian Codegraph @

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

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