Debian Codegraph @

mysql-test/suite/clone/r/local_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 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
145 # In connection con1 - Insert [20 Rows - No commit]
146 SET DEBUG_SYNC = 'now WAIT_FOR start_insert1';
147 START TRANSACTION;
148 call execute_dml(0, 50, 20, 20, 500, 0);
149 # Flush all dirty buffers
150 SET GLOBAL innodb_buf_flush_list_now = 1;
151 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
152 # In connection default - Cloning database
153 # In connection con1
154 ROLLBACK;
155 # In connection default - Cloning database
156 # Restart cloned database
157 # restart: --datadir=CLONE_DATADIR
158 SHOW CREATE TABLE t1;
159 Table Create Table
160 t1 CREATE TABLE `t1` (
161 `col1` int NOT NULL,
162 `col2` int DEFAULT NULL,
163 `col3` varchar(64) DEFAULT NULL,
164 `col4` blob,
165 PRIMARY KEY (`col1`)
166 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED
167 SELECT count(*) from t1;
168 count(*)
169 40
170 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
171 col1 col3 SUBSTRING(col4, 1000, 32)
172 0 Clone Test Row - 0 umn Data Large Column Data Large
173 1 Clone Test Row - 1 umn Data Large Column Data Large
174 2 Clone Test Row - 2 umn Data Large Column Data Large
175 3 Clone Test Row - 3 umn Data Large Column Data Large
176 4 Clone Test Row - 4 umn Data Large Column Data Large
177 5 Clone Test Row - 5 umn Data Large Column Data Large
178 6 Clone Test Row - 6 umn Data Large Column Data Large
179 7 Clone Test Row - 7 umn Data Large Column Data Large
180 8 Clone Test Row - 8 umn Data Large Column Data Large
181 9 Clone Test Row - 9 umn Data Large Column Data Large
182 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
183 col1 col3 SUBSTRING(col4, 1000, 32)
184 69 Clone Test Row - 69 umn Data Large Column Data Large
185 68 Clone Test Row - 68 umn Data Large Column Data Large
186 67 Clone Test Row - 67 umn Data Large Column Data Large
187 66 Clone Test Row - 66 umn Data Large Column Data Large
188 65 Clone Test Row - 65 umn Data Large Column Data Large
189 64 Clone Test Row - 64 umn Data Large Column Data Large
190 63 Clone Test Row - 63 umn Data Large Column Data Large
191 62 Clone Test Row - 62 umn Data Large Column Data Large
192 61 Clone Test Row - 61 umn Data Large Column Data Large
193 60 Clone Test Row - 60 umn Data Large Column Data Large
194 SHOW CREATE TABLE t2;
195 Table Create Table
196 t2 CREATE TABLE `t2` (
197 `col1` int NOT NULL,
198 `col2` int DEFAULT NULL,
199 `col3` varchar(64) DEFAULT NULL,
200 `col4` blob,
201 PRIMARY KEY (`col1`)
202 ) /*!50100 TABLESPACE `tbs1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
203 SELECT count(*) from t2;
204 count(*)
205 40
206 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
207 col1 col3 SUBSTRING(col4, 1000, 32)
208 0 Clone Test Row - 0 umn Data Large Column Data Large
209 1 Clone Test Row - 1 umn Data Large Column Data Large
210 2 Clone Test Row - 2 umn Data Large Column Data Large
211 3 Clone Test Row - 3 umn Data Large Column Data Large
212 4 Clone Test Row - 4 umn Data Large Column Data Large
213 5 Clone Test Row - 5 umn Data Large Column Data Large
214 6 Clone Test Row - 6 umn Data Large Column Data Large
215 7 Clone Test Row - 7 umn Data Large Column Data Large
216 8 Clone Test Row - 8 umn Data Large Column Data Large
217 9 Clone Test Row - 9 umn Data Large Column Data Large
218 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
219 col1 col3 SUBSTRING(col4, 1000, 32)
220 69 Clone Test Row - 69 umn Data Large Column Data Large
221 68 Clone Test Row - 68 umn Data Large Column Data Large
222 67 Clone Test Row - 67 umn Data Large Column Data Large
223 66 Clone Test Row - 66 umn Data Large Column Data Large
224 65 Clone Test Row - 65 umn Data Large Column Data Large
225 64 Clone Test Row - 64 umn Data Large Column Data Large
226 63 Clone Test Row - 63 umn Data Large Column Data Large
227 62 Clone Test Row - 62 umn Data Large Column Data Large
228 61 Clone Test Row - 61 umn Data Large Column Data Large
229 60 Clone Test Row - 60 umn Data Large Column Data Large
230 call execute_dml(3, 0, 1, 1, 1, 0);
231 call execute_dml(0, 0, 10, 10, 2, 0);
232 commit;
233 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
234 col1 col2 col3 SUBSTRING(col4, 1000, 32)
235 0 0 Clone Test Row - 0 umn Data Large Column Data Large
236 1 10 Clone Test Row - 1 umn Data Large Column Data Large
237 2 20 Clone Test Row - 2 umn Data Large Column Data Large
238 3 30 Clone Test Row - 3 umn Data Large Column Data Large
239 4 40 Clone Test Row - 4 umn Data Large Column Data Large
240 5 50 Clone Test Row - 5 umn Data Large Column Data Large
241 6 60 Clone Test Row - 6 umn Data Large Column Data Large
242 7 70 Clone Test Row - 7 umn Data Large Column Data Large
243 8 80 Clone Test Row - 8 umn Data Large Column Data Large
244 9 90 Clone Test Row - 9 umn Data Large Column Data Large
245 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
246 col1 col2 col3 SUBSTRING(col4, 1000, 32)
247 9 90 Clone Test Row - 9 umn Data Large Column Data Large
248 8 80 Clone Test Row - 8 umn Data Large Column Data Large
249 7 70 Clone Test Row - 7 umn Data Large Column Data Large
250 6 60 Clone Test Row - 6 umn Data Large Column Data Large
251 5 50 Clone Test Row - 5 umn Data Large Column Data Large
252 4 40 Clone Test Row - 4 umn Data Large Column Data Large
253 3 30 Clone Test Row - 3 umn Data Large Column Data Large
254 2 20 Clone Test Row - 2 umn Data Large Column Data Large
255 1 10 Clone Test Row - 1 umn Data Large Column Data Large
256 0 0 Clone Test Row - 0 umn Data Large Column Data Large
257 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
258 col1 col2 col3 SUBSTRING(col4, 1000, 32)
259 0 0 Clone Test Row - 0 umn Data Large Column Data Large
260 1 10 Clone Test Row - 1 umn Data Large Column Data Large
261 2 20 Clone Test Row - 2 umn Data Large Column Data Large
262 3 30 Clone Test Row - 3 umn Data Large Column Data Large
263 4 40 Clone Test Row - 4 umn Data Large Column Data Large
264 5 50 Clone Test Row - 5 umn Data Large Column Data Large
265 6 60 Clone Test Row - 6 umn Data Large Column Data Large
266 7 70 Clone Test Row - 7 umn Data Large Column Data Large
267 8 80 Clone Test Row - 8 umn Data Large Column Data Large
268 9 90 Clone Test Row - 9 umn Data Large Column Data Large
269 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
270 col1 col2 col3 SUBSTRING(col4, 1000, 32)
271 9 90 Clone Test Row - 9 umn Data Large Column Data Large
272 8 80 Clone Test Row - 8 umn Data Large Column Data Large
273 7 70 Clone Test Row - 7 umn Data Large Column Data Large
274 6 60 Clone Test Row - 6 umn Data Large Column Data Large
275 5 50 Clone Test Row - 5 umn Data Large Column Data Large
276 4 40 Clone Test Row - 4 umn Data Large Column Data Large
277 3 30 Clone Test Row - 3 umn Data Large Column Data Large
278 2 20 Clone Test Row - 2 umn Data Large Column Data Large
279 1 10 Clone Test Row - 1 umn Data Large Column Data Large
280 0 0 Clone Test Row - 0 umn Data Large Column Data Large
281 # restart:
282 # In connection default - Cloning database
283 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml WAIT_FOR resume_clone2';
284 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_insert2 WAIT_FOR resume_clone3';
285 SET GLOBAL clone_autotune_concurrency = OFF;
286 SET GLOBAL clone_max_concurrency = 8;
287 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
288 # In connection con1 - Insert [20 Rows - No commit]
289 SET DEBUG_SYNC = 'now WAIT_FOR start_dml';
290 START TRANSACTION;
291 call execute_dml(1, 0, 20, 20, 10, 1);
292 COMMIT;
293 # Flush all dirty buffers
294 SET GLOBAL innodb_buf_flush_list_now = 1;
295 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
296 SET DEBUG_SYNC = 'now WAIT_FOR start_insert2';
297 START TRANSACTION;
298 call execute_dml(0, 50, 20, 20, 500, 0);
299 # Flush all dirty buffers
300 SET GLOBAL innodb_buf_flush_list_now = 1;
301 SET DEBUG_SYNC = 'now SIGNAL resume_clone3';
302 # In connection default - Cloning database
303 # In connection con1
304 ROLLBACK;
305 # In connection default - Cloning database
306 # Restart cloned database
307 # restart: --datadir=CLONE_DATADIR
308 SHOW CREATE TABLE t1;
309 Table Create Table
310 t1 CREATE TABLE `t1` (
311 `col1` int NOT NULL,
312 `col2` int DEFAULT NULL,
313 `col3` varchar(64) DEFAULT NULL,
314 `col4` blob,
315 PRIMARY KEY (`col1`)
316 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED
317 SELECT count(*) from t1;
318 count(*)
319 40
320 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
321 col1 col3 SUBSTRING(col4, 1000, 32)
322 0 Clone Test Row - 0 umn Data Large Column Data Large
323 1 Clone Test Row - 1 umn Data Large Column Data Large
324 2 Clone Test Row - 2 umn Data Large Column Data Large
325 3 Clone Test Row - 3 umn Data Large Column Data Large
326 4 Clone Test Row - 4 umn Data Large Column Data Large
327 5 Clone Test Row - 5 umn Data Large Column Data Large
328 6 Clone Test Row - 6 umn Data Large Column Data Large
329 7 Clone Test Row - 7 umn Data Large Column Data Large
330 8 Clone Test Row - 8 umn Data Large Column Data Large
331 9 Clone Test Row - 9 umn Data Large Column Data Large
332 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
333 col1 col3 SUBSTRING(col4, 1000, 32)
334 69 Clone Test Row - 69 umn Data Large Column Data Large
335 68 Clone Test Row - 68 umn Data Large Column Data Large
336 67 Clone Test Row - 67 umn Data Large Column Data Large
337 66 Clone Test Row - 66 umn Data Large Column Data Large
338 65 Clone Test Row - 65 umn Data Large Column Data Large
339 64 Clone Test Row - 64 umn Data Large Column Data Large
340 63 Clone Test Row - 63 umn Data Large Column Data Large
341 62 Clone Test Row - 62 umn Data Large Column Data Large
342 61 Clone Test Row - 61 umn Data Large Column Data Large
343 60 Clone Test Row - 60 umn Data Large Column Data Large
344 SHOW CREATE TABLE t2;
345 Table Create Table
346 t2 CREATE TABLE `t2` (
347 `col1` int NOT NULL,
348 `col2` int DEFAULT NULL,
349 `col3` varchar(64) DEFAULT NULL,
350 `col4` blob,
351 PRIMARY KEY (`col1`)
352 ) /*!50100 TABLESPACE `tbs1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
353 SELECT count(*) from t2;
354 count(*)
355 40
356 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
357 col1 col3 SUBSTRING(col4, 1000, 32)
358 0 Clone Test Row - 0 umn Data Large Column Data Large
359 1 Clone Test Row - 1 umn Data Large Column Data Large
360 2 Clone Test Row - 2 umn Data Large Column Data Large
361 3 Clone Test Row - 3 umn Data Large Column Data Large
362 4 Clone Test Row - 4 umn Data Large Column Data Large
363 5 Clone Test Row - 5 umn Data Large Column Data Large
364 6 Clone Test Row - 6 umn Data Large Column Data Large
365 7 Clone Test Row - 7 umn Data Large Column Data Large
366 8 Clone Test Row - 8 umn Data Large Column Data Large
367 9 Clone Test Row - 9 umn Data Large Column Data Large
368 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
369 col1 col3 SUBSTRING(col4, 1000, 32)
370 69 Clone Test Row - 69 umn Data Large Column Data Large
371 68 Clone Test Row - 68 umn Data Large Column Data Large
372 67 Clone Test Row - 67 umn Data Large Column Data Large
373 66 Clone Test Row - 66 umn Data Large Column Data Large
374 65 Clone Test Row - 65 umn Data Large Column Data Large
375 64 Clone Test Row - 64 umn Data Large Column Data Large
376 63 Clone Test Row - 63 umn Data Large Column Data Large
377 62 Clone Test Row - 62 umn Data Large Column Data Large
378 61 Clone Test Row - 61 umn Data Large Column Data Large
379 60 Clone Test Row - 60 umn Data Large Column Data Large
380 call execute_dml(3, 0, 1, 1, 1, 0);
381 call execute_dml(0, 0, 10, 10, 2, 0);
382 commit;
383 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
384 col1 col2 col3 SUBSTRING(col4, 1000, 32)
385 0 0 Clone Test Row - 0 umn Data Large Column Data Large
386 1 10 Clone Test Row - 1 umn Data Large Column Data Large
387 2 20 Clone Test Row - 2 umn Data Large Column Data Large
388 3 30 Clone Test Row - 3 umn Data Large Column Data Large
389 4 40 Clone Test Row - 4 umn Data Large Column Data Large
390 5 50 Clone Test Row - 5 umn Data Large Column Data Large
391 6 60 Clone Test Row - 6 umn Data Large Column Data Large
392 7 70 Clone Test Row - 7 umn Data Large Column Data Large
393 8 80 Clone Test Row - 8 umn Data Large Column Data Large
394 9 90 Clone Test Row - 9 umn Data Large Column Data Large
395 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
396 col1 col2 col3 SUBSTRING(col4, 1000, 32)
397 9 90 Clone Test Row - 9 umn Data Large Column Data Large
398 8 80 Clone Test Row - 8 umn Data Large Column Data Large
399 7 70 Clone Test Row - 7 umn Data Large Column Data Large
400 6 60 Clone Test Row - 6 umn Data Large Column Data Large
401 5 50 Clone Test Row - 5 umn Data Large Column Data Large
402 4 40 Clone Test Row - 4 umn Data Large Column Data Large
403 3 30 Clone Test Row - 3 umn Data Large Column Data Large
404 2 20 Clone Test Row - 2 umn Data Large Column Data Large
405 1 10 Clone Test Row - 1 umn Data Large Column Data Large
406 0 0 Clone Test Row - 0 umn Data Large Column Data Large
407 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
408 col1 col2 col3 SUBSTRING(col4, 1000, 32)
409 0 0 Clone Test Row - 0 umn Data Large Column Data Large
410 1 10 Clone Test Row - 1 umn Data Large Column Data Large
411 2 20 Clone Test Row - 2 umn Data Large Column Data Large
412 3 30 Clone Test Row - 3 umn Data Large Column Data Large
413 4 40 Clone Test Row - 4 umn Data Large Column Data Large
414 5 50 Clone Test Row - 5 umn Data Large Column Data Large
415 6 60 Clone Test Row - 6 umn Data Large Column Data Large
416 7 70 Clone Test Row - 7 umn Data Large Column Data Large
417 8 80 Clone Test Row - 8 umn Data Large Column Data Large
418 9 90 Clone Test Row - 9 umn Data Large Column Data Large
419 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
420 col1 col2 col3 SUBSTRING(col4, 1000, 32)
421 9 90 Clone Test Row - 9 umn Data Large Column Data Large
422 8 80 Clone Test Row - 8 umn Data Large Column Data Large
423 7 70 Clone Test Row - 7 umn Data Large Column Data Large
424 6 60 Clone Test Row - 6 umn Data Large Column Data Large
425 5 50 Clone Test Row - 5 umn Data Large Column Data Large
426 4 40 Clone Test Row - 4 umn Data Large Column Data Large
427 3 30 Clone Test Row - 3 umn Data Large Column Data Large
428 2 20 Clone Test Row - 2 umn Data Large Column Data Large
429 1 10 Clone Test Row - 1 umn Data Large Column Data Large
430 0 0 Clone Test Row - 0 umn Data Large Column Data Large
431 # restart:
432 DROP TABLE t1;
433 DROP TABLE t2;
434 DROP PROCEDURE execute_dml;
435 DROP TABLESPACE tbs1;
436 UNINSTALL PLUGIN clone;
437 SET DEBUG_SYNC = 'RESET';