Debian Codegraph @

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