Debian Codegraph @

mysql-test/suite/clone/r/local_features.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, 200, 200, 100, 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 200
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 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
95 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
96 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
97 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
98 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
99 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
100 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
101 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
102 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
103 190 1900 Clone Test Row - 190 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 200
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 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
131 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
132 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
133 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
134 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
135 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
136 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
137 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
138 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
139 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
140 SET GLOBAL innodb_buf_flush_list_now = 1;
141 SET GLOBAL clone_autotune_concurrency = OFF;
142 SET GLOBAL clone_max_concurrency = 8;
143 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
144 select ID, STATE, ERROR_NO from performance_schema.clone_status;
145 ID STATE ERROR_NO
146 1 Completed 0
147 select ID, STAGE, STATE from performance_schema.clone_progress;
148 ID STAGE STATE
149 1 DROP DATA Completed
150 1 FILE COPY Completed
151 1 PAGE COPY Completed
152 1 REDO COPY Completed
153 1 FILE SYNC Completed
154 1 RESTART Not Started
155 1 RECOVERY Not Started
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 200
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 199 Clone Test Row - 199 umn Data Large Column Data Large
185 198 Clone Test Row - 198 umn Data Large Column Data Large
186 197 Clone Test Row - 197 umn Data Large Column Data Large
187 196 Clone Test Row - 196 umn Data Large Column Data Large
188 195 Clone Test Row - 195 umn Data Large Column Data Large
189 194 Clone Test Row - 194 umn Data Large Column Data Large
190 193 Clone Test Row - 193 umn Data Large Column Data Large
191 192 Clone Test Row - 192 umn Data Large Column Data Large
192 191 Clone Test Row - 191 umn Data Large Column Data Large
193 190 Clone Test Row - 190 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 200
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 199 Clone Test Row - 199 umn Data Large Column Data Large
221 198 Clone Test Row - 198 umn Data Large Column Data Large
222 197 Clone Test Row - 197 umn Data Large Column Data Large
223 196 Clone Test Row - 196 umn Data Large Column Data Large
224 195 Clone Test Row - 195 umn Data Large Column Data Large
225 194 Clone Test Row - 194 umn Data Large Column Data Large
226 193 Clone Test Row - 193 umn Data Large Column Data Large
227 192 Clone Test Row - 192 umn Data Large Column Data Large
228 191 Clone Test Row - 191 umn Data Large Column Data Large
229 190 Clone Test Row - 190 umn Data Large Column Data Large
230 call execute_dml(3, 0, 1, 1, 1, 0);
231 call execute_dml(0, 0, 200, 200, 100, 0);
232 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
233 col1 col2 col3 SUBSTRING(col4, 1000, 32)
234 0 0 Clone Test Row - 0 umn Data Large Column Data Large
235 1 10 Clone Test Row - 1 umn Data Large Column Data Large
236 2 20 Clone Test Row - 2 umn Data Large Column Data Large
237 3 30 Clone Test Row - 3 umn Data Large Column Data Large
238 4 40 Clone Test Row - 4 umn Data Large Column Data Large
239 5 50 Clone Test Row - 5 umn Data Large Column Data Large
240 6 60 Clone Test Row - 6 umn Data Large Column Data Large
241 7 70 Clone Test Row - 7 umn Data Large Column Data Large
242 8 80 Clone Test Row - 8 umn Data Large Column Data Large
243 9 90 Clone Test Row - 9 umn Data Large Column Data Large
244 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
245 col1 col2 col3 SUBSTRING(col4, 1000, 32)
246 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
247 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
248 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
249 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
250 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
251 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
252 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
253 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
254 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
255 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
256 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
257 col1 col2 col3 SUBSTRING(col4, 1000, 32)
258 0 0 Clone Test Row - 0 umn Data Large Column Data Large
259 1 10 Clone Test Row - 1 umn Data Large Column Data Large
260 2 20 Clone Test Row - 2 umn Data Large Column Data Large
261 3 30 Clone Test Row - 3 umn Data Large Column Data Large
262 4 40 Clone Test Row - 4 umn Data Large Column Data Large
263 5 50 Clone Test Row - 5 umn Data Large Column Data Large
264 6 60 Clone Test Row - 6 umn Data Large Column Data Large
265 7 70 Clone Test Row - 7 umn Data Large Column Data Large
266 8 80 Clone Test Row - 8 umn Data Large Column Data Large
267 9 90 Clone Test Row - 9 umn Data Large Column Data Large
268 # restart:
269 # In connection default - Cloning database
270 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
271 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
272 SET GLOBAL clone_autotune_concurrency = OFF;
273 SET GLOBAL clone_max_concurrency = 8;
274 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
275 # In connection con1 - Running Update Random [0 - 200 Key Range]
276 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
277 START TRANSACTION;
278 CALL execute_dml(1, 0, 200, 500, 100, 1);
279 COMMIT;
280 # Flush all dirty buffers
281 SET GLOBAL innodb_buf_flush_list_now = 1;
282 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
283 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
284 START TRANSACTION;
285 CALL execute_dml(1, 0, 200, 500, 100, 1);
286 COMMIT;
287 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
288 # In connection default - Cloning database
289 # Restart cloned database
290 # restart: --datadir=CLONE_DATADIR
291 SHOW CREATE TABLE t1;
292 Table Create Table
293 t1 CREATE TABLE `t1` (
294 `col1` int NOT NULL,
295 `col2` int DEFAULT NULL,
296 `col3` varchar(64) DEFAULT NULL,
297 `col4` blob,
298 PRIMARY KEY (`col1`)
299 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED
300 SELECT count(*) from t1;
301 count(*)
302 200
303 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
304 col1 col3 SUBSTRING(col4, 1000, 32)
305 0 Clone Test Row - 0 umn Data Large Column Data Large
306 1 Clone Test Row - 1 umn Data Large Column Data Large
307 2 Clone Test Row - 2 umn Data Large Column Data Large
308 3 Clone Test Row - 3 umn Data Large Column Data Large
309 4 Clone Test Row - 4 umn Data Large Column Data Large
310 5 Clone Test Row - 5 umn Data Large Column Data Large
311 6 Clone Test Row - 6 umn Data Large Column Data Large
312 7 Clone Test Row - 7 umn Data Large Column Data Large
313 8 Clone Test Row - 8 umn Data Large Column Data Large
314 9 Clone Test Row - 9 umn Data Large Column Data Large
315 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
316 col1 col3 SUBSTRING(col4, 1000, 32)
317 199 Clone Test Row - 199 umn Data Large Column Data Large
318 198 Clone Test Row - 198 umn Data Large Column Data Large
319 197 Clone Test Row - 197 umn Data Large Column Data Large
320 196 Clone Test Row - 196 umn Data Large Column Data Large
321 195 Clone Test Row - 195 umn Data Large Column Data Large
322 194 Clone Test Row - 194 umn Data Large Column Data Large
323 193 Clone Test Row - 193 umn Data Large Column Data Large
324 192 Clone Test Row - 192 umn Data Large Column Data Large
325 191 Clone Test Row - 191 umn Data Large Column Data Large
326 190 Clone Test Row - 190 umn Data Large Column Data Large
327 SHOW CREATE TABLE t2;
328 Table Create Table
329 t2 CREATE TABLE `t2` (
330 `col1` int NOT NULL,
331 `col2` int DEFAULT NULL,
332 `col3` varchar(64) DEFAULT NULL,
333 `col4` blob,
334 PRIMARY KEY (`col1`)
335 ) /*!50100 TABLESPACE `tbs1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
336 SELECT count(*) from t2;
337 count(*)
338 200
339 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
340 col1 col3 SUBSTRING(col4, 1000, 32)
341 0 Clone Test Row - 0 umn Data Large Column Data Large
342 1 Clone Test Row - 1 umn Data Large Column Data Large
343 2 Clone Test Row - 2 umn Data Large Column Data Large
344 3 Clone Test Row - 3 umn Data Large Column Data Large
345 4 Clone Test Row - 4 umn Data Large Column Data Large
346 5 Clone Test Row - 5 umn Data Large Column Data Large
347 6 Clone Test Row - 6 umn Data Large Column Data Large
348 7 Clone Test Row - 7 umn Data Large Column Data Large
349 8 Clone Test Row - 8 umn Data Large Column Data Large
350 9 Clone Test Row - 9 umn Data Large Column Data Large
351 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
352 col1 col3 SUBSTRING(col4, 1000, 32)
353 199 Clone Test Row - 199 umn Data Large Column Data Large
354 198 Clone Test Row - 198 umn Data Large Column Data Large
355 197 Clone Test Row - 197 umn Data Large Column Data Large
356 196 Clone Test Row - 196 umn Data Large Column Data Large
357 195 Clone Test Row - 195 umn Data Large Column Data Large
358 194 Clone Test Row - 194 umn Data Large Column Data Large
359 193 Clone Test Row - 193 umn Data Large Column Data Large
360 192 Clone Test Row - 192 umn Data Large Column Data Large
361 191 Clone Test Row - 191 umn Data Large Column Data Large
362 190 Clone Test Row - 190 umn Data Large Column Data Large
363 call execute_dml(3, 0, 1, 1, 1, 0);
364 call execute_dml(0, 0, 200, 200, 100, 0);
365 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
366 col1 col2 col3 SUBSTRING(col4, 1000, 32)
367 0 0 Clone Test Row - 0 umn Data Large Column Data Large
368 1 10 Clone Test Row - 1 umn Data Large Column Data Large
369 2 20 Clone Test Row - 2 umn Data Large Column Data Large
370 3 30 Clone Test Row - 3 umn Data Large Column Data Large
371 4 40 Clone Test Row - 4 umn Data Large Column Data Large
372 5 50 Clone Test Row - 5 umn Data Large Column Data Large
373 6 60 Clone Test Row - 6 umn Data Large Column Data Large
374 7 70 Clone Test Row - 7 umn Data Large Column Data Large
375 8 80 Clone Test Row - 8 umn Data Large Column Data Large
376 9 90 Clone Test Row - 9 umn Data Large Column Data Large
377 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
378 col1 col2 col3 SUBSTRING(col4, 1000, 32)
379 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
380 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
381 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
382 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
383 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
384 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
385 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
386 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
387 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
388 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
389 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
390 col1 col2 col3 SUBSTRING(col4, 1000, 32)
391 0 0 Clone Test Row - 0 umn Data Large Column Data Large
392 1 10 Clone Test Row - 1 umn Data Large Column Data Large
393 2 20 Clone Test Row - 2 umn Data Large Column Data Large
394 3 30 Clone Test Row - 3 umn Data Large Column Data Large
395 4 40 Clone Test Row - 4 umn Data Large Column Data Large
396 5 50 Clone Test Row - 5 umn Data Large Column Data Large
397 6 60 Clone Test Row - 6 umn Data Large Column Data Large
398 7 70 Clone Test Row - 7 umn Data Large Column Data Large
399 8 80 Clone Test Row - 8 umn Data Large Column Data Large
400 9 90 Clone Test Row - 9 umn Data Large Column Data Large
401 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
402 col1 col2 col3 SUBSTRING(col4, 1000, 32)
403 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
404 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
405 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
406 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
407 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
408 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
409 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
410 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
411 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
412 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
413 # restart:
414 DROP TABLE t1;
415 DROP TABLE t2;
416 DROP PROCEDURE execute_dml;
417 DROP TABLESPACE tbs1;
418 UNINSTALL PLUGIN clone;
419 SET DEBUG_SYNC = 'RESET';