Debian Codegraph @

mysql-test/suite/ndb/r/ndb_dd_dump.result

raw
1 CREATE LOGFILE GROUP lg1
2 ADD UNDOFILE 'undofile_lg1_01.dat'
3 INITIAL_SIZE 3M
4 UNDO_BUFFER_SIZE = 1M
5 ENGINE NDB;
6 ALTER LOGFILE GROUP lg1
7 ADD UNDOFILE 'undofile_lg1_02.dat'
8 INITIAL_SIZE = 6M
9 ENGINE NDB;
10 CREATE TABLESPACE ts1
11 ADD DATAFILE 'datafile_ts1_01.dat'
12 USE LOGFILE GROUP lg1
13 EXTENT_SIZE 1M
14 INITIAL_SIZE 32M
15 ENGINE NDB;
16 ALTER TABLESPACE ts1
17 ADD DATAFILE 'datafile_ts1_02.dat'
18 INITIAL_SIZE = 3M;
19 CREATE TABLESPACE ts2
20 ADD DATAFILE 'datafile_ts2_01.dat'
21 USE LOGFILE GROUP lg1
22 INITIAL_SIZE 6M
23 ENGINE NDB;
24 CREATE TABLESPACE ts3
25 ADD DATAFILE 'datafile_ts3_01.dat'
26 USE LOGFILE GROUP lg1
27 INITIAL_SIZE 12M
28 ENGINE NDB;
29 CREATE TABLE t1
30 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
31 TABLESPACE ts1 STORAGE DISK
32 ENGINE=NDB;
33 CREATE TABLE t2
34 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
35 TABLESPACE ts2 STORAGE DISK
36 ENGINE=NDB;
37 CREATE TABLE t3
38 (pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
39 TABLESPACE ts3 STORAGE DISK
40 ENGINE=NDB;
41 INSERT INTO t1 VALUES
42 (1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5),
43 (6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10),
44 (11,11,11),(12,12,12),(13,13,13),(14,14,14),(15,15,15),
45 (16,16,16),(17,17,17),(18,18,18),(19,19,19),(20,20,20),
46 (21,21,21),(22,22,22),(23,23,23),(24,24,24),(25,25,25),
47 (26,26,26),(27,27,27),(28,28,28),(29,29,29),(30,30,30),
48 (31,31,31),(32,32,32),(33,33,33),(34,34,34),(35,35,35),
49 (36,36,36),(37,37,37),(38,38,38),(39,39,39),(40,40,40),
50 (41,41,41),(42,42,42),(43,43,43),(44,44,44),(45,45,45),
51 (46,46,46),(47,47,47),(48,48,48),(49,49,49),(50,50,50),
52 (51,51,51),(52,52,52),(53,53,53),(54,54,54),(55,55,55),
53 (56,56,56),(57,57,57),(58,58,58),(59,59,59),(60,60,60),
54 (61,61,61),(62,62,62),(63,63,63),(64,64,64),(65,65,65),
55 (66,66,66),(67,67,67),(68,68,68),(69,69,69),(70,70,70),
56 (71,71,71),(72,72,72),(73,73,73),(74,74,74),(75,75,75),
57 (76,76,76),(77,77,77),(78,78,78),(79,79,79),(80,80,80),
58 (81,81,81),(82,82,82),(83,83,83),(84,84,84),(85,85,85),
59 (86,86,86),(87,87,87),(88,88,88),(89,89,89),(90,90,90),
60 (91,91,91),(92,92,92),(93,93,93),(94,94,94),(95,95,95),
61 (96,96,96),(97,97,97),(98,98,98),(99,99,99),(100,100,100),
62 (101,101,101),(102,102,102),(103,103,103),(104,104,104),(105,105,105),
63 (106,106,106),(107,107,107),(108,108,108),(109,109,109),(110,110,110),
64 (111,111,111),(112,112,112),(113,113,113),(114,114,114),(115,115,115),
65 (116,116,116),(117,117,117),(118,118,118),(119,119,119),(120,120,120),
66 (121,121,121),(122,122,122),(123,123,123),(124,124,124),(125,125,125),
67 (126,126,126),(127,127,127),(128,128,128),(129,129,129),(130,130,130),
68 (131,131,131),(132,132,132),(133,133,133),(134,134,134),(135,135,135),
69 (136,136,136),(137,137,137),(138,138,138),(139,139,139),(140,140,140),
70 (141,141,141),(142,142,142),(143,143,143),(144,144,144),(145,145,145),
71 (146,146,146),(147,147,147),(148,148,148),(149,149,149),(150,150,150),
72 (151,151,151),(152,152,152),(153,153,153),(154,154,154),(155,155,155),
73 (156,156,156),(157,157,157),(158,158,158),(159,159,159),(160,160,160),
74 (161,161,161),(162,162,162),(163,163,163),(164,164,164),(165,165,165),
75 (166,166,166),(167,167,167),(168,168,168),(169,169,169),(170,170,170),
76 (171,171,171),(172,172,172),(173,173,173),(174,174,174),(175,175,175),
77 (176,176,176),(177,177,177),(178,178,178),(179,179,179),(180,180,180),
78 (181,181,181),(182,182,182),(183,183,183),(184,184,184),(185,185,185),
79 (186,186,186),(187,187,187),(188,188,188),(189,189,189),(190,190,190),
80 (191,191,191),(192,192,192),(193,193,193),(194,194,194),(195,195,195),
81 (196,196,196),(197,197,197),(198,198,198),(199,199,199),(200,200,200),
82 (201,201,201),(202,202,202),(203,203,203),(204,204,204),(205,205,205),
83 (206,206,206),(207,207,207),(208,208,208),(209,209,209),(210,210,210),
84 (211,211,211),(212,212,212),(213,213,213),(214,214,214),(215,215,215),
85 (216,216,216),(217,217,217),(218,218,218),(219,219,219),(220,220,220),
86 (221,221,221),(222,222,222),(223,223,223),(224,224,224),(225,225,225),
87 (226,226,226),(227,227,227),(228,228,228),(229,229,229),(230,230,230),
88 (231,231,231),(232,232,232),(233,233,233),(234,234,234),(235,235,235),
89 (236,236,236),(237,237,237),(238,238,238),(239,239,239),(240,240,240),
90 (241,241,241),(242,242,242),(243,243,243),(244,244,244),(245,245,245),
91 (246,246,246),(247,247,247),(248,248,248),(249,249,249),(250,250,250),
92 (251,251,251),(252,252,252),(253,253,253),(254,254,254),(255,255,255),
93 (256,256,256),(257,257,257),(258,258,258),(259,259,259),(260,260,260),
94 (261,261,261),(262,262,262),(263,263,263),(264,264,264),(265,265,265),
95 (266,266,266),(267,267,267),(268,268,268),(269,269,269),(270,270,270),
96 (271,271,271),(272,272,272),(273,273,273),(274,274,274),(275,275,275),
97 (276,276,276),(277,277,277),(278,278,278),(279,279,279),(280,280,280),
98 (281,281,281),(282,282,282),(283,283,283),(284,284,284),(285,285,285),
99 (286,286,286),(287,287,287),(288,288,288),(289,289,289),(290,290,290),
100 (291,291,291),(292,292,292),(293,293,293),(294,294,294),(295,295,295),
101 (296,296,296),(297,297,297),(298,298,298),(299,299,299),(300,300,300),
102 (301,301,301),(302,302,302),(303,303,303),(304,304,304),(305,305,305),
103 (306,306,306),(307,307,307),(308,308,308),(309,309,309),(310,310,310),
104 (311,311,311),(312,312,312),(313,313,313),(314,314,314),(315,315,315),
105 (316,316,316),(317,317,317),(318,318,318),(319,319,319),(320,320,320),
106 (321,321,321),(322,322,322),(323,323,323),(324,324,324),(325,325,325),
107 (326,326,326),(327,327,327),(328,328,328),(329,329,329),(330,330,330),
108 (331,331,331),(332,332,332),(333,333,333),(334,334,334),(335,335,335),
109 (336,336,336),(337,337,337),(338,338,338),(339,339,339),(340,340,340),
110 (341,341,341),(342,342,342),(343,343,343),(344,344,344),(345,345,345),
111 (346,346,346),(347,347,347),(348,348,348),(349,349,349),(350,350,350),
112 (351,351,351),(352,352,352),(353,353,353),(354,354,354),(355,355,355),
113 (356,356,356),(357,357,357),(358,358,358),(359,359,359),(360,360,360),
114 (361,361,361),(362,362,362),(363,363,363),(364,364,364),(365,365,365),
115 (366,366,366),(367,367,367),(368,368,368),(369,369,369),(370,370,370),
116 (371,371,371),(372,372,372),(373,373,373),(374,374,374),(375,375,375),
117 (376,376,376),(377,377,377),(378,378,378),(379,379,379),(380,380,380),
118 (381,381,381),(382,382,382),(383,383,383),(384,384,384),(385,385,385),
119 (386,386,386),(387,387,387),(388,388,388),(389,389,389),(390,390,390),
120 (391,391,391),(392,392,392),(393,393,393),(394,394,394),(395,395,395),
121 (396,396,396),(397,397,397),(398,398,398),(399,399,399),(400,400,400),
122 (401,401,401),(402,402,402),(403,403,403),(404,404,404),(405,405,405),
123 (406,406,406),(407,407,407),(408,408,408),(409,409,409),(410,410,410),
124 (411,411,411),(412,412,412),(413,413,413),(414,414,414),(415,415,415),
125 (416,416,416),(417,417,417),(418,418,418),(419,419,419),(420,420,420),
126 (421,421,421),(422,422,422),(423,423,423),(424,424,424),(425,425,425),
127 (426,426,426),(427,427,427),(428,428,428),(429,429,429),(430,430,430),
128 (431,431,431),(432,432,432),(433,433,433),(434,434,434),(435,435,435),
129 (436,436,436),(437,437,437),(438,438,438),(439,439,439),(440,440,440),
130 (441,441,441),(442,442,442),(443,443,443),(444,444,444),(445,445,445),
131 (446,446,446),(447,447,447),(448,448,448),(449,449,449),(450,450,450),
132 (451,451,451),(452,452,452),(453,453,453),(454,454,454),(455,455,455),
133 (456,456,456),(457,457,457),(458,458,458),(459,459,459),(460,460,460),
134 (461,461,461),(462,462,462),(463,463,463),(464,464,464),(465,465,465),
135 (466,466,466),(467,467,467),(468,468,468),(469,469,469),(470,470,470),
136 (471,471,471),(472,472,472),(473,473,473),(474,474,474),(475,475,475),
137 (476,476,476),(477,477,477),(478,478,478),(479,479,479),(480,480,480),
138 (481,481,481),(482,482,482),(483,483,483),(484,484,484),(485,485,485),
139 (486,486,486),(487,487,487),(488,488,488),(489,489,489),(490,490,490),
140 (491,491,491),(492,492,492),(493,493,493),(494,494,494),(495,495,495),
141 (496,496,496),(497,497,497),(498,498,498),(499,499,499),(500, 500, 500);
142 INSERT INTO t2 VALUES
143 (1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5);
144 INSERT INTO t3 VALUES
145 (1,1,1);
146 DROP TABLE t1;
147 DROP TABLE t2;
148 DROP TABLE t3;
149 ALTER TABLESPACE ts1
150 DROP DATAFILE 'datafile_ts1_01.dat';
151 ALTER TABLESPACE ts1
152 DROP DATAFILE 'datafile_ts1_02.dat';
153 ALTER TABLESPACE ts2
154 DROP DATAFILE 'datafile_ts2_01.dat';
155 ALTER TABLESPACE ts3
156 DROP DATAFILE 'datafile_ts3_01.dat';
157 DROP TABLESPACE ts1;
158 DROP TABLESPACE ts2;
159 DROP TABLESPACE ts3;
160 DROP LOGFILE GROUP lg1 ENGINE = NDB;
161 SELECT DISTINCT
162 LOGFILE_GROUP_NAME,
163 FILE_NAME,
164 TOTAL_EXTENTS,
165 INITIAL_SIZE,
166 ENGINE
167 FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE="UNDO LOG" AND ENGINE="NDBCLUSTER"
168 ORDER BY FILE_NAME;
169 LOGFILE_GROUP_NAME FILE_NAME TOTAL_EXTENTS INITIAL_SIZE ENGINE
170 lg1 ./undofile_lg1_01.dat 786432 3145728 ndbcluster
171 lg1 ./undofile_lg1_02.dat 1572864 6291456 ndbcluster
172 SELECT DISTINCT
173 TABLESPACE_NAME,
174 LOGFILE_GROUP_NAME,
175 FILE_NAME,
176 EXTENT_SIZE,
177 INITIAL_SIZE,
178 ENGINE
179 FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE="DATAFILE" ORDER BY FILE_NAME;
180 TABLESPACE_NAME LOGFILE_GROUP_NAME FILE_NAME EXTENT_SIZE INITIAL_SIZE ENGINE
181 ts1 lg1 ./datafile_ts1_01.dat 1048576 33554432 ndbcluster
182 ts1 lg1 ./datafile_ts1_02.dat 1048576 3145728 ndbcluster
183 ts2 lg1 ./datafile_ts2_01.dat 1048576 6291456 ndbcluster
184 ts3 lg1 ./datafile_ts3_01.dat 1048576 12582912 ndbcluster
185 SELECT COUNT(*) FROM t1;
186 COUNT(*)
187 500
188 SELECT COUNT(*) FROM t2;
189 COUNT(*)
190 5
191 SELECT COUNT(*) FROM t3;
192 COUNT(*)
193 1
194 DROP TABLE t1;
195 DROP TABLE t2;
196 DROP TABLE t3;
197 CREATE TABLE test.t (
198 a smallint NOT NULL,
199 b int NOT NULL,
200 c bigint NOT NULL,
201 d char(10),
202 e TEXT,
203 f VARCHAR(255),
204 PRIMARY KEY(a)
205 ) TABLESPACE ts1 STORAGE DISK ENGINE=NDB;
206 ALTER TABLE test.t ADD INDEX (d), ADD INDEX (f);
207 SHOW CREATE TABLE test.t;
208 Table Create Table
209 t CREATE TABLE `t` (
210 `a` smallint NOT NULL,
211 `b` int NOT NULL,
212 `c` bigint NOT NULL,
213 `d` char(10) DEFAULT NULL,
214 `e` text,
215 `f` varchar(255) DEFAULT NULL,
216 PRIMARY KEY (`a`),
217 KEY `d` (`d`),
218 KEY `f` (`f`)
219 ) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
220 SELECT * FROM test.t order by a;
221 a b c d e f
222 1 2 3 aaa1 bbb1 ccccc1
223 2 3 4 aaa2 bbb2 ccccc2
224 3 4 5 aaa3 bbb3 ccccc3
225 4 5 6 aaa4 bbb4 ccccc4
226 5 6 7 aaa5 bbb5 ccccc5
227 6 7 8 aaa6 bbb6 ccccc6
228 7 8 9 aaa7 bbb7 ccccc7
229 8 9 10 aaa8 bbb8 ccccc8
230 9 10 11 aaa9 bbb9 ccccc9
231 10 11 12 aaa10 bbb10 ccccc10
232 11 12 13 aaa11 bbb11 ccccc11
233 12 13 14 aaa12 bbb12 ccccc12
234 13 14 15 aaa13 bbb13 ccccc13
235 14 15 16 aaa14 bbb14 ccccc14
236 15 16 17 aaa15 bbb15 ccccc15
237 16 17 18 aaa16 bbb16 ccccc16
238 17 18 19 aaa17 bbb17 ccccc17
239 18 19 20 aaa18 bbb18 ccccc18
240 19 20 21 aaa19 bbb19 ccccc19
241 20 21 22 aaa20 bbb20 ccccc20
242 21 22 23 aaa21 bbb21 ccccc21
243 22 23 24 aaa22 bbb22 ccccc22
244 23 24 25 aaa23 bbb23 ccccc23
245 24 25 26 aaa24 bbb24 ccccc24
246 25 26 27 aaa25 bbb25 ccccc25
247 26 27 28 aaa26 bbb26 ccccc26
248 27 28 29 aaa27 bbb27 ccccc27
249 28 29 30 aaa28 bbb28 ccccc28
250 29 30 31 aaa29 bbb29 ccccc29
251 30 31 32 aaa30 bbb30 ccccc30
252 31 32 33 aaa31 bbb31 ccccc31
253 32 33 34 aaa32 bbb32 ccccc32
254 33 34 35 aaa33 bbb33 ccccc33
255 34 35 36 aaa34 bbb34 ccccc34
256 35 36 37 aaa35 bbb35 ccccc35
257 36 37 38 aaa36 bbb36 ccccc36
258 37 38 39 aaa37 bbb37 ccccc37
259 38 39 40 aaa38 bbb38 ccccc38
260 39 40 41 aaa39 bbb39 ccccc39
261 40 41 42 aaa40 bbb40 ccccc40
262 41 42 43 aaa41 bbb41 ccccc41
263 42 43 44 aaa42 bbb42 ccccc42
264 43 44 45 aaa43 bbb43 ccccc43
265 44 45 46 aaa44 bbb44 ccccc44
266 45 46 47 aaa45 bbb45 ccccc45
267 46 47 48 aaa46 bbb46 ccccc46
268 47 48 49 aaa47 bbb47 ccccc47
269 48 49 50 aaa48 bbb48 ccccc48
270 49 50 51 aaa49 bbb49 ccccc49
271 50 51 52 aaa50 bbb50 ccccc50
272 51 52 53 aaa51 bbb51 ccccc51
273 52 53 54 aaa52 bbb52 ccccc52
274 53 54 55 aaa53 bbb53 ccccc53
275 54 55 56 aaa54 bbb54 ccccc54
276 55 56 57 aaa55 bbb55 ccccc55
277 56 57 58 aaa56 bbb56 ccccc56
278 57 58 59 aaa57 bbb57 ccccc57
279 58 59 60 aaa58 bbb58 ccccc58
280 59 60 61 aaa59 bbb59 ccccc59
281 60 61 62 aaa60 bbb60 ccccc60
282 61 62 63 aaa61 bbb61 ccccc61
283 62 63 64 aaa62 bbb62 ccccc62
284 63 64 65 aaa63 bbb63 ccccc63
285 64 65 66 aaa64 bbb64 ccccc64
286 65 66 67 aaa65 bbb65 ccccc65
287 66 67 68 aaa66 bbb66 ccccc66
288 67 68 69 aaa67 bbb67 ccccc67
289 68 69 70 aaa68 bbb68 ccccc68
290 69 70 71 aaa69 bbb69 ccccc69
291 70 71 72 aaa70 bbb70 ccccc70
292 71 72 73 aaa71 bbb71 ccccc71
293 72 73 74 aaa72 bbb72 ccccc72
294 73 74 75 aaa73 bbb73 ccccc73
295 74 75 76 aaa74 bbb74 ccccc74
296 75 76 77 aaa75 bbb75 ccccc75
297 76 77 78 aaa76 bbb76 ccccc76
298 77 78 79 aaa77 bbb77 ccccc77
299 78 79 80 aaa78 bbb78 ccccc78
300 79 80 81 aaa79 bbb79 ccccc79
301 80 81 82 aaa80 bbb80 ccccc80
302 81 82 83 aaa81 bbb81 ccccc81
303 82 83 84 aaa82 bbb82 ccccc82
304 83 84 85 aaa83 bbb83 ccccc83
305 84 85 86 aaa84 bbb84 ccccc84
306 85 86 87 aaa85 bbb85 ccccc85
307 86 87 88 aaa86 bbb86 ccccc86
308 87 88 89 aaa87 bbb87 ccccc87
309 88 89 90 aaa88 bbb88 ccccc88
310 89 90 91 aaa89 bbb89 ccccc89
311 90 91 92 aaa90 bbb90 ccccc90
312 91 92 93 aaa91 bbb91 ccccc91
313 92 93 94 aaa92 bbb92 ccccc92
314 93 94 95 aaa93 bbb93 ccccc93
315 94 95 96 aaa94 bbb94 ccccc94
316 95 96 97 aaa95 bbb95 ccccc95
317 96 97 98 aaa96 bbb96 ccccc96
318 97 98 99 aaa97 bbb97 ccccc97
319 98 99 100 aaa98 bbb98 ccccc98
320 99 100 101 aaa99 bbb99 ccccc99
321 100 101 102 aaa100 bbb100 ccccc100
322 SELECT * INTO OUTFILE 't_backup' FROM test.t;
323 TRUNCATE test.t;
324 SELECT count(*) FROM test.t;
325 count(*)
326 0
327 LOAD DATA INFILE 't_backup' INTO TABLE test.t;
328 SELECT * FROM test.t order by a;
329 a b c d e f
330 1 2 3 aaa1 bbb1 ccccc1
331 2 3 4 aaa2 bbb2 ccccc2
332 3 4 5 aaa3 bbb3 ccccc3
333 4 5 6 aaa4 bbb4 ccccc4
334 5 6 7 aaa5 bbb5 ccccc5
335 6 7 8 aaa6 bbb6 ccccc6
336 7 8 9 aaa7 bbb7 ccccc7
337 8 9 10 aaa8 bbb8 ccccc8
338 9 10 11 aaa9 bbb9 ccccc9
339 10 11 12 aaa10 bbb10 ccccc10
340 11 12 13 aaa11 bbb11 ccccc11
341 12 13 14 aaa12 bbb12 ccccc12
342 13 14 15 aaa13 bbb13 ccccc13
343 14 15 16 aaa14 bbb14 ccccc14
344 15 16 17 aaa15 bbb15 ccccc15
345 16 17 18 aaa16 bbb16 ccccc16
346 17 18 19 aaa17 bbb17 ccccc17
347 18 19 20 aaa18 bbb18 ccccc18
348 19 20 21 aaa19 bbb19 ccccc19
349 20 21 22 aaa20 bbb20 ccccc20
350 21 22 23 aaa21 bbb21 ccccc21
351 22 23 24 aaa22 bbb22 ccccc22
352 23 24 25 aaa23 bbb23 ccccc23
353 24 25 26 aaa24 bbb24 ccccc24
354 25 26 27 aaa25 bbb25 ccccc25
355 26 27 28 aaa26 bbb26 ccccc26
356 27 28 29 aaa27 bbb27 ccccc27
357 28 29 30 aaa28 bbb28 ccccc28
358 29 30 31 aaa29 bbb29 ccccc29
359 30 31 32 aaa30 bbb30 ccccc30
360 31 32 33 aaa31 bbb31 ccccc31
361 32 33 34 aaa32 bbb32 ccccc32
362 33 34 35 aaa33 bbb33 ccccc33
363 34 35 36 aaa34 bbb34 ccccc34
364 35 36 37 aaa35 bbb35 ccccc35
365 36 37 38 aaa36 bbb36 ccccc36
366 37 38 39 aaa37 bbb37 ccccc37
367 38 39 40 aaa38 bbb38 ccccc38
368 39 40 41 aaa39 bbb39 ccccc39
369 40 41 42 aaa40 bbb40 ccccc40
370 41 42 43 aaa41 bbb41 ccccc41
371 42 43 44 aaa42 bbb42 ccccc42
372 43 44 45 aaa43 bbb43 ccccc43
373 44 45 46 aaa44 bbb44 ccccc44
374 45 46 47 aaa45 bbb45 ccccc45
375 46 47 48 aaa46 bbb46 ccccc46
376 47 48 49 aaa47 bbb47 ccccc47
377 48 49 50 aaa48 bbb48 ccccc48
378 49 50 51 aaa49 bbb49 ccccc49
379 50 51 52 aaa50 bbb50 ccccc50
380 51 52 53 aaa51 bbb51 ccccc51
381 52 53 54 aaa52 bbb52 ccccc52
382 53 54 55 aaa53 bbb53 ccccc53
383 54 55 56 aaa54 bbb54 ccccc54
384 55 56 57 aaa55 bbb55 ccccc55
385 56 57 58 aaa56 bbb56 ccccc56
386 57 58 59 aaa57 bbb57 ccccc57
387 58 59 60 aaa58 bbb58 ccccc58
388 59 60 61 aaa59 bbb59 ccccc59
389 60 61 62 aaa60 bbb60 ccccc60
390 61 62 63 aaa61 bbb61 ccccc61
391 62 63 64 aaa62 bbb62 ccccc62
392 63 64 65 aaa63 bbb63 ccccc63
393 64 65 66 aaa64 bbb64 ccccc64
394 65 66 67 aaa65 bbb65 ccccc65
395 66 67 68 aaa66 bbb66 ccccc66
396 67 68 69 aaa67 bbb67 ccccc67
397 68 69 70 aaa68 bbb68 ccccc68
398 69 70 71 aaa69 bbb69 ccccc69
399 70 71 72 aaa70 bbb70 ccccc70
400 71 72 73 aaa71 bbb71 ccccc71
401 72 73 74 aaa72 bbb72 ccccc72
402 73 74 75 aaa73 bbb73 ccccc73
403 74 75 76 aaa74 bbb74 ccccc74
404 75 76 77 aaa75 bbb75 ccccc75
405 76 77 78 aaa76 bbb76 ccccc76
406 77 78 79 aaa77 bbb77 ccccc77
407 78 79 80 aaa78 bbb78 ccccc78
408 79 80 81 aaa79 bbb79 ccccc79
409 80 81 82 aaa80 bbb80 ccccc80
410 81 82 83 aaa81 bbb81 ccccc81
411 82 83 84 aaa82 bbb82 ccccc82
412 83 84 85 aaa83 bbb83 ccccc83
413 84 85 86 aaa84 bbb84 ccccc84
414 85 86 87 aaa85 bbb85 ccccc85
415 86 87 88 aaa86 bbb86 ccccc86
416 87 88 89 aaa87 bbb87 ccccc87
417 88 89 90 aaa88 bbb88 ccccc88
418 89 90 91 aaa89 bbb89 ccccc89
419 90 91 92 aaa90 bbb90 ccccc90
420 91 92 93 aaa91 bbb91 ccccc91
421 92 93 94 aaa92 bbb92 ccccc92
422 93 94 95 aaa93 bbb93 ccccc93
423 94 95 96 aaa94 bbb94 ccccc94
424 95 96 97 aaa95 bbb95 ccccc95
425 96 97 98 aaa96 bbb96 ccccc96
426 97 98 99 aaa97 bbb97 ccccc97
427 98 99 100 aaa98 bbb98 ccccc98
428 99 100 101 aaa99 bbb99 ccccc99
429 100 101 102 aaa100 bbb100 ccccc100
430 DROP TABLE test.t;
431 ALTER TABLESPACE ts1
432 DROP DATAFILE './datafile_ts1_01.dat';
433 ALTER TABLESPACE ts1
434 DROP DATAFILE './datafile_ts1_02.dat';
435 ALTER TABLESPACE ts2
436 DROP DATAFILE './datafile_ts2_01.dat';
437 ALTER TABLESPACE ts3
438 DROP DATAFILE './datafile_ts3_01.dat';
439 DROP TABLESPACE ts1;
440 DROP TABLESPACE ts2;
441 DROP TABLESPACE ts3;
442 DROP LOGFILE GROUP lg1 ENGINE = NDB;