[ Avaa Bypassed ]

Upload:

Command:

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

Filemanager

DIR : / usr/ share/ mysql-test/ suite/ ndb/ r/
Name Type Size Permission Actions
bug36547.result File 455 B 0644
loaddata_autocom_ndb.result File 726 B 0644
ndb_add_partition.result File 5.91 KB 0644
ndb_alter_table.result File 10.88 KB 0644
ndb_alter_table2.result File 685 B 0644
ndb_alter_table3.result File 1.48 KB 0644
ndb_alter_table_backup.result File 1.76 KB 0644
ndb_alter_table_error.result File 648 B 0644
ndb_alter_table_online.result File 26.79 KB 0644
ndb_alter_table_online2.result File 2.62 KB 0644
ndb_alter_table_online_multi.result File 1.98 KB 0644
ndb_auto_increment.result File 9.99 KB 0644
ndb_autoinc.result File 793 B 0644
ndb_basic.result File 29.94 KB 0644
ndb_bitfield.result File 8.26 KB 0644
ndb_blob.result File 22.71 KB 0644
ndb_blob_big.result File 1.24 KB 0644
ndb_blob_partition.result File 9.03 KB 0644
ndb_bug26793.result File 257 B 0644
ndb_bug31477.result File 1.85 KB 0644
ndb_bug31754.result File 262 B 0644
ndb_bulk_delete.result File 1.87 KB 0644
ndb_cache.result File 8.68 KB 0644
ndb_cache2.result File 13.31 KB 0644
ndb_cache_multi.result File 1.67 KB 0644
ndb_cache_multi2.result File 1.68 KB 0644
ndb_cache_trans.result File 6.65 KB 0644
ndb_charset.result File 5.77 KB 0644
ndb_column_properties.result File 15.98 KB 0644
ndb_condition_pushdown.result File 72.29 KB 0644
ndb_config.result File 3.21 KB 0644
ndb_config2.result File 475 B 0644
ndb_create_table.result File 1.02 KB 0644
ndb_cursor.result File 865 B 0644
ndb_database.result File 1.23 KB 0644
ndb_dbug_lock.result File 1.64 KB 0644
ndb_dbug_tc_select.result File 5.98 KB 0644
ndb_dd_alter.result File 27.07 KB 0644
ndb_dd_basic.result File 20.67 KB 0644
ndb_dd_bug12581213.result File 334 B 0644
ndb_dd_ddl.result File 5.56 KB 0644
ndb_dd_disk2memory.result File 12.99 KB 0644
ndb_dd_dump.result File 15.97 KB 0644
ndb_dd_restore_compat.result File 3.61 KB 0644
ndb_dd_sql_features.result File 22.4 KB 0644
ndb_ddl_open_trans.result File 1.36 KB 0644
ndb_disconnect_ddl.result File 281 B 0644
ndb_discover_db.result File 1.55 KB 0644
ndb_dist_priv.result File 4.8 KB 0644
ndb_gis.result File 47.18 KB 0644
ndb_global_schema_lock.result File 3.43 KB 0644
ndb_global_schema_lock_error.result File 1.94 KB 0644
ndb_grant.result File 17.65 KB 0644
ndb_hidden_pk.result File 10.55 KB 0644
ndb_index.result File 13.93 KB 0644
ndb_index_ordered.result File 16.71 KB 0644
ndb_index_stat.result File 14.33 KB 0644
ndb_index_unique.result File 17.43 KB 0644
ndb_insert.result File 36.2 KB 0644
ndb_join_pushdown.result File 274.88 KB 0644
ndb_limit.result File 2.01 KB 0644
ndb_load.result File 2.64 KB 0644
ndb_loaddatalocal.result File 1.39 KB 0644
ndb_lock.result File 4.17 KB 0644
ndb_lock_table.result File 205 B 0644
ndb_mgm.result File 3.55 KB 0644
ndb_minmax.result File 1.47 KB 0644
ndb_multi.result File 3.7 KB 0644
ndb_multi_row.result File 1.33 KB 0644
ndb_native_default_support.result File 47.23 KB 0644
ndb_optimize_table.result File 2 KB 0644
ndb_optimized_node_selection.result File 1017 B 0644
ndb_partition_error.result File 1.41 KB 0644
ndb_partition_error2.result File 150 B 0644
ndb_partition_hash.result File 890 B 0644
ndb_partition_key.result File 8.16 KB 0644
ndb_partition_list.result File 2.31 KB 0644
ndb_partition_range.result File 7.91 KB 0644
ndb_read_multi_range.result File 14.54 KB 0644
ndb_reconnect.result File 560 B 0644
ndb_rename.result File 772 B 0644
ndb_replace.result File 3.64 KB 0644
ndb_restore_compat_downward.result File 132.43 KB 0644
ndb_restore_compat_endianness.result File 10.87 KB 0644
ndb_restore_conv_lossy_charbinary.result File 15.46 KB 0644
ndb_restore_conv_lossy_integral.result File 20.72 KB 0644
ndb_restore_conv_padding.result File 6.14 KB 0644
ndb_restore_conv_promotion.result File 23.26 KB 0644
ndb_restore_discover.result File 540 B 0644
ndb_restore_misc.result File 23.77 KB 0644
ndb_restore_print.result File 9.8 KB 0644
ndb_restore_schema_blobs.result File 6.44 KB 0644
ndb_restore_schema_partitions.result File 13.3 KB 0644
ndb_restore_schema_rewrites.result File 12.22 KB 0644
ndb_restore_schema_subsets.result File 95.9 KB 0644
ndb_restore_schema_tolerance.result File 4.57 KB 0644
ndb_restore_undolog.result File 18.66 KB 0644
ndb_row_count.result File 5.11 KB 0644
ndb_row_format.result File 1.74 KB 0644
ndb_select_count.result File 334 B 0644
ndb_share.result File 9.85 KB 0644
ndb_short_sigs.result File 2.53 KB 0644
ndb_single_user.result File 3.97 KB 0644
ndb_sp.result File 1.1 KB 0644
ndb_sql_allow_batching.result File 918 B 0644
ndb_statistics0.result File 7.78 KB 0644
ndb_statistics1.result File 8.04 KB 0644
ndb_subquery.result File 3.07 KB 0644
ndb_temporary.result File 939 B 0644
ndb_tmp_table_and_DDL.result File 3.11 KB 0644
ndb_transaction.result File 4.62 KB 0644
ndb_trigger.result File 9.38 KB 0644
ndb_truncate.result File 425 B 0644
ndb_types.result File 3.12 KB 0644
ndb_update.result File 2.76 KB 0644
ndb_update_no_read.result File 11.37 KB 0644
ndb_view.result File 597 B 0644
ndbapi.result File 734 B 0644
ndbinfo.result File 12.86 KB 0644
ndbinfo_cache.result File 423 B 0644
ndbinfo_dump.result File 95 B 0644
ps_7ndb.result File 103.12 KB 0644
strict_autoinc_5ndb.result File 651 B 0644