← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

Viewing changes to mysql-test/suite/ndb/t/ndb_dd_dump.test

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
Import upstream version 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/ndb/t/ndb_dd_dump.test
 
1
# test uses mysqldump and hence not in embedded
 
2
-- source include/not_embedded.inc
 
3
-- source include/have_ndb.inc
 
4
 
 
5
--disable_warnings
 
6
DROP TABLE IF EXISTS t1, t2, t3;
 
7
--enable_warnings
 
8
 
 
9
CREATE LOGFILE GROUP lg1
 
10
ADD UNDOFILE 'undofile_lg1_01.dat'
 
11
INITIAL_SIZE 3M
 
12
UNDO_BUFFER_SIZE = 1M
 
13
ENGINE NDB;
 
14
 
 
15
ALTER LOGFILE GROUP lg1
 
16
ADD UNDOFILE 'undofile_lg1_02.dat'
 
17
INITIAL_SIZE = 6M 
 
18
ENGINE NDB;
 
19
 
 
20
CREATE TABLESPACE ts1
 
21
ADD DATAFILE 'datafile_ts1_01.dat'
 
22
USE LOGFILE GROUP lg1
 
23
EXTENT_SIZE 1M
 
24
INITIAL_SIZE 6M
 
25
ENGINE NDB;
 
26
 
 
27
ALTER TABLESPACE ts1
 
28
ADD DATAFILE 'datafile_ts1_02.dat'
 
29
INITIAL_SIZE = 3M 
 
30
ENGINE=NDB;
 
31
 
 
32
CREATE TABLESPACE ts2
 
33
ADD DATAFILE 'datafile_ts2_01.dat'
 
34
USE LOGFILE GROUP lg1
 
35
INITIAL_SIZE 6M
 
36
ENGINE NDB;
 
37
 
 
38
CREATE TABLESPACE ts3
 
39
ADD DATAFILE 'datafile_ts3_01.dat'
 
40
USE LOGFILE GROUP lg1
 
41
INITIAL_SIZE 12M
 
42
ENGINE NDB;
 
43
 
 
44
########################################
 
45
# Create a table using this tablespace
 
46
########################################
 
47
 
 
48
CREATE TABLE t1
 
49
(pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
 
50
TABLESPACE ts1 STORAGE DISK
 
51
ENGINE=NDB;
 
52
 
 
53
CREATE TABLE t2
 
54
(pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
 
55
TABLESPACE ts2 STORAGE DISK
 
56
ENGINE=NDB;
 
57
 
 
58
CREATE TABLE t3
 
59
(pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
 
60
TABLESPACE ts3 STORAGE DISK
 
61
ENGINE=NDB;
 
62
 
 
63
INSERT INTO t1 VALUES 
 
64
(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5),
 
65
(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10),
 
66
(11,11,11),(12,12,12),(13,13,13),(14,14,14),(15,15,15),
 
67
(16,16,16),(17,17,17),(18,18,18),(19,19,19),(20,20,20),
 
68
(21,21,21),(22,22,22),(23,23,23),(24,24,24),(25,25,25),
 
69
(26,26,26),(27,27,27),(28,28,28),(29,29,29),(30,30,30),
 
70
(31,31,31),(32,32,32),(33,33,33),(34,34,34),(35,35,35),
 
71
(36,36,36),(37,37,37),(38,38,38),(39,39,39),(40,40,40),
 
72
(41,41,41),(42,42,42),(43,43,43),(44,44,44),(45,45,45),
 
73
(46,46,46),(47,47,47),(48,48,48),(49,49,49),(50,50,50),
 
74
(51,51,51),(52,52,52),(53,53,53),(54,54,54),(55,55,55),
 
75
(56,56,56),(57,57,57),(58,58,58),(59,59,59),(60,60,60),
 
76
(61,61,61),(62,62,62),(63,63,63),(64,64,64),(65,65,65),
 
77
(66,66,66),(67,67,67),(68,68,68),(69,69,69),(70,70,70),
 
78
(71,71,71),(72,72,72),(73,73,73),(74,74,74),(75,75,75),
 
79
(76,76,76),(77,77,77),(78,78,78),(79,79,79),(80,80,80),
 
80
(81,81,81),(82,82,82),(83,83,83),(84,84,84),(85,85,85),
 
81
(86,86,86),(87,87,87),(88,88,88),(89,89,89),(90,90,90),
 
82
(91,91,91),(92,92,92),(93,93,93),(94,94,94),(95,95,95),
 
83
(96,96,96),(97,97,97),(98,98,98),(99,99,99),(100,100,100),
 
84
(101,101,101),(102,102,102),(103,103,103),(104,104,104),(105,105,105),
 
85
(106,106,106),(107,107,107),(108,108,108),(109,109,109),(110,110,110),
 
86
(111,111,111),(112,112,112),(113,113,113),(114,114,114),(115,115,115),
 
87
(116,116,116),(117,117,117),(118,118,118),(119,119,119),(120,120,120),
 
88
(121,121,121),(122,122,122),(123,123,123),(124,124,124),(125,125,125),
 
89
(126,126,126),(127,127,127),(128,128,128),(129,129,129),(130,130,130),
 
90
(131,131,131),(132,132,132),(133,133,133),(134,134,134),(135,135,135),
 
91
(136,136,136),(137,137,137),(138,138,138),(139,139,139),(140,140,140),
 
92
(141,141,141),(142,142,142),(143,143,143),(144,144,144),(145,145,145),
 
93
(146,146,146),(147,147,147),(148,148,148),(149,149,149),(150,150,150),
 
94
(151,151,151),(152,152,152),(153,153,153),(154,154,154),(155,155,155),
 
95
(156,156,156),(157,157,157),(158,158,158),(159,159,159),(160,160,160),
 
96
(161,161,161),(162,162,162),(163,163,163),(164,164,164),(165,165,165),
 
97
(166,166,166),(167,167,167),(168,168,168),(169,169,169),(170,170,170),
 
98
(171,171,171),(172,172,172),(173,173,173),(174,174,174),(175,175,175),
 
99
(176,176,176),(177,177,177),(178,178,178),(179,179,179),(180,180,180),
 
100
(181,181,181),(182,182,182),(183,183,183),(184,184,184),(185,185,185),
 
101
(186,186,186),(187,187,187),(188,188,188),(189,189,189),(190,190,190),
 
102
(191,191,191),(192,192,192),(193,193,193),(194,194,194),(195,195,195),
 
103
(196,196,196),(197,197,197),(198,198,198),(199,199,199),(200,200,200),
 
104
(201,201,201),(202,202,202),(203,203,203),(204,204,204),(205,205,205),
 
105
(206,206,206),(207,207,207),(208,208,208),(209,209,209),(210,210,210),
 
106
(211,211,211),(212,212,212),(213,213,213),(214,214,214),(215,215,215),
 
107
(216,216,216),(217,217,217),(218,218,218),(219,219,219),(220,220,220),
 
108
(221,221,221),(222,222,222),(223,223,223),(224,224,224),(225,225,225),
 
109
(226,226,226),(227,227,227),(228,228,228),(229,229,229),(230,230,230),
 
110
(231,231,231),(232,232,232),(233,233,233),(234,234,234),(235,235,235),
 
111
(236,236,236),(237,237,237),(238,238,238),(239,239,239),(240,240,240),
 
112
(241,241,241),(242,242,242),(243,243,243),(244,244,244),(245,245,245),
 
113
(246,246,246),(247,247,247),(248,248,248),(249,249,249),(250,250,250),
 
114
(251,251,251),(252,252,252),(253,253,253),(254,254,254),(255,255,255),
 
115
(256,256,256),(257,257,257),(258,258,258),(259,259,259),(260,260,260),
 
116
(261,261,261),(262,262,262),(263,263,263),(264,264,264),(265,265,265),
 
117
(266,266,266),(267,267,267),(268,268,268),(269,269,269),(270,270,270),
 
118
(271,271,271),(272,272,272),(273,273,273),(274,274,274),(275,275,275),
 
119
(276,276,276),(277,277,277),(278,278,278),(279,279,279),(280,280,280),
 
120
(281,281,281),(282,282,282),(283,283,283),(284,284,284),(285,285,285),
 
121
(286,286,286),(287,287,287),(288,288,288),(289,289,289),(290,290,290),
 
122
(291,291,291),(292,292,292),(293,293,293),(294,294,294),(295,295,295),
 
123
(296,296,296),(297,297,297),(298,298,298),(299,299,299),(300,300,300),
 
124
(301,301,301),(302,302,302),(303,303,303),(304,304,304),(305,305,305),
 
125
(306,306,306),(307,307,307),(308,308,308),(309,309,309),(310,310,310),
 
126
(311,311,311),(312,312,312),(313,313,313),(314,314,314),(315,315,315),
 
127
(316,316,316),(317,317,317),(318,318,318),(319,319,319),(320,320,320),
 
128
(321,321,321),(322,322,322),(323,323,323),(324,324,324),(325,325,325),
 
129
(326,326,326),(327,327,327),(328,328,328),(329,329,329),(330,330,330),
 
130
(331,331,331),(332,332,332),(333,333,333),(334,334,334),(335,335,335),
 
131
(336,336,336),(337,337,337),(338,338,338),(339,339,339),(340,340,340),
 
132
(341,341,341),(342,342,342),(343,343,343),(344,344,344),(345,345,345),
 
133
(346,346,346),(347,347,347),(348,348,348),(349,349,349),(350,350,350),
 
134
(351,351,351),(352,352,352),(353,353,353),(354,354,354),(355,355,355),
 
135
(356,356,356),(357,357,357),(358,358,358),(359,359,359),(360,360,360),
 
136
(361,361,361),(362,362,362),(363,363,363),(364,364,364),(365,365,365),
 
137
(366,366,366),(367,367,367),(368,368,368),(369,369,369),(370,370,370),
 
138
(371,371,371),(372,372,372),(373,373,373),(374,374,374),(375,375,375),
 
139
(376,376,376),(377,377,377),(378,378,378),(379,379,379),(380,380,380),
 
140
(381,381,381),(382,382,382),(383,383,383),(384,384,384),(385,385,385),
 
141
(386,386,386),(387,387,387),(388,388,388),(389,389,389),(390,390,390),
 
142
(391,391,391),(392,392,392),(393,393,393),(394,394,394),(395,395,395),
 
143
(396,396,396),(397,397,397),(398,398,398),(399,399,399),(400,400,400),
 
144
(401,401,401),(402,402,402),(403,403,403),(404,404,404),(405,405,405),
 
145
(406,406,406),(407,407,407),(408,408,408),(409,409,409),(410,410,410),
 
146
(411,411,411),(412,412,412),(413,413,413),(414,414,414),(415,415,415),
 
147
(416,416,416),(417,417,417),(418,418,418),(419,419,419),(420,420,420),
 
148
(421,421,421),(422,422,422),(423,423,423),(424,424,424),(425,425,425),
 
149
(426,426,426),(427,427,427),(428,428,428),(429,429,429),(430,430,430),
 
150
(431,431,431),(432,432,432),(433,433,433),(434,434,434),(435,435,435),
 
151
(436,436,436),(437,437,437),(438,438,438),(439,439,439),(440,440,440),
 
152
(441,441,441),(442,442,442),(443,443,443),(444,444,444),(445,445,445),
 
153
(446,446,446),(447,447,447),(448,448,448),(449,449,449),(450,450,450),
 
154
(451,451,451),(452,452,452),(453,453,453),(454,454,454),(455,455,455),
 
155
(456,456,456),(457,457,457),(458,458,458),(459,459,459),(460,460,460),
 
156
(461,461,461),(462,462,462),(463,463,463),(464,464,464),(465,465,465),
 
157
(466,466,466),(467,467,467),(468,468,468),(469,469,469),(470,470,470),
 
158
(471,471,471),(472,472,472),(473,473,473),(474,474,474),(475,475,475),
 
159
(476,476,476),(477,477,477),(478,478,478),(479,479,479),(480,480,480),
 
160
(481,481,481),(482,482,482),(483,483,483),(484,484,484),(485,485,485),
 
161
(486,486,486),(487,487,487),(488,488,488),(489,489,489),(490,490,490),
 
162
(491,491,491),(492,492,492),(493,493,493),(494,494,494),(495,495,495),
 
163
(496,496,496),(497,497,497),(498,498,498),(499,499,499),(500, 500, 500);
 
164
 
 
165
INSERT INTO t2 VALUES 
 
166
(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5);
 
167
 
 
168
INSERT INTO t3 VALUES 
 
169
(1,1,1);
 
170
 
 
171
--exec $MYSQL_DUMP --skip-comments --compact -Y test > $MYSQLTEST_VARDIR/tmp/ndb_dd_dump.sql
 
172
 
 
173
DROP TABLE t1;
 
174
DROP TABLE t2;
 
175
DROP TABLE t3;
 
176
 
 
177
ALTER TABLESPACE ts1 
 
178
DROP DATAFILE 'datafile_ts1_01.dat' 
 
179
ENGINE = NDB;
 
180
 
 
181
ALTER TABLESPACE ts1 
 
182
DROP DATAFILE 'datafile_ts1_02.dat' 
 
183
ENGINE = NDB;
 
184
 
 
185
ALTER TABLESPACE ts2 
 
186
DROP DATAFILE 'datafile_ts2_01.dat' 
 
187
ENGINE = NDB;
 
188
 
 
189
ALTER TABLESPACE ts3 
 
190
DROP DATAFILE 'datafile_ts3_01.dat' 
 
191
ENGINE = NDB;
 
192
 
 
193
DROP TABLESPACE ts1 ENGINE = NDB;
 
194
DROP TABLESPACE ts2 ENGINE = NDB;
 
195
DROP TABLESPACE ts3 ENGINE = NDB;
 
196
 
 
197
DROP LOGFILE GROUP lg1 ENGINE = NDB;
 
198
 
 
199
--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/ndb_dd_dump.sql
 
200
 
 
201
SELECT DISTINCT
 
202
  LOGFILE_GROUP_NAME,
 
203
  FILE_NAME,
 
204
  TOTAL_EXTENTS,
 
205
  INITIAL_SIZE,
 
206
  ENGINE
 
207
FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE="UNDO LOG" ORDER BY FILE_NAME;
 
208
 
 
209
SELECT DISTINCT
 
210
  TABLESPACE_NAME,
 
211
  LOGFILE_GROUP_NAME, 
 
212
  FILE_NAME,
 
213
  EXTENT_SIZE,
 
214
  INITIAL_SIZE,
 
215
  ENGINE
 
216
FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE="DATAFILE" ORDER BY FILE_NAME;
 
217
 
 
218
SELECT COUNT(*) FROM t1;
 
219
SELECT COUNT(*) FROM t2;
 
220
SELECT COUNT(*) FROM t3;
 
221
 
 
222
DROP TABLE t1;
 
223
DROP TABLE t2;
 
224
DROP TABLE t3;
 
225
 
 
226
#### BUG 18856 test case comented out
 
227
##### Use "SELECT * INTO OUTFILE" to dump data and "LOAD DATA INFILE" to load ##### data back to the data file.
 
228
 
 
229
CREATE TABLE test.t (
 
230
  a smallint NOT NULL,
 
231
  b int NOT NULL,
 
232
  c bigint NOT NULL,
 
233
  d char(10),
 
234
  e TEXT,
 
235
  f VARCHAR(255),
 
236
  PRIMARY KEY(a)
 
237
) TABLESPACE ts1 STORAGE DISK ENGINE=NDB;
 
238
 
 
239
 ALTER TABLE test.t ADD INDEX (d), ADD INDEX (f);
 
240
 SHOW CREATE TABLE test.t;
 
241
 
 
242
# insert records into tables
 
243
 
 
244
 let $1=100;
 
245
 disable_query_log;
 
246
 while ($1)
 
247
 {
 
248
  eval insert into test.t values($1, $1+1, $1+2, "aaa$1", "bbb$1", "ccccc$1");
 
249
  dec $1;
 
250
 }
 
251
 enable_query_log;
 
252
 
 
253
 SELECT * FROM test.t order by a;
 
254
 
 
255
 SELECT * INTO OUTFILE 't_backup' FROM test.t;
 
256
 TRUNCATE test.t;
 
257
 
 
258
#'TRUNCATE test.t' failed: 1205: Lock wait timeout exceeded; try restarting 
 
259
#transaction. TABLESPACE ts STORAGE DISK ENGINE=NDB;
 
260
 
 
261
 SELECT count(*) FROM test.t;
 
262
 LOAD DATA INFILE 't_backup' INTO TABLE test.t;
 
263
--let $MYSQLD_DATADIR= `SELECT @@datadir`
 
264
--remove_file  $MYSQLD_DATADIR/test/t_backup
 
265
 
 
266
 SELECT * FROM test.t order by a;
 
267
 
 
268
 DROP TABLE test.t;
 
269
 
 
270
 
 
271
ALTER TABLESPACE ts1 
 
272
DROP DATAFILE 'datafile_ts1_01.dat' 
 
273
ENGINE = NDB;
 
274
 
 
275
ALTER TABLESPACE ts1 
 
276
DROP DATAFILE 'datafile_ts1_02.dat' 
 
277
ENGINE = NDB;
 
278
 
 
279
ALTER TABLESPACE ts2 
 
280
DROP DATAFILE 'datafile_ts2_01.dat' 
 
281
ENGINE = NDB;
 
282
 
 
283
ALTER TABLESPACE ts3 
 
284
DROP DATAFILE 'datafile_ts3_01.dat' 
 
285
ENGINE = NDB;
 
286
 
 
287
DROP TABLESPACE ts1 ENGINE = NDB;
 
288
DROP TABLESPACE ts2 ENGINE = NDB;
 
289
DROP TABLESPACE ts3 ENGINE = NDB;
 
290
 
 
291
DROP LOGFILE GROUP lg1 ENGINE = NDB;
 
292
 
 
293
#End 5.1 test case