1
DROP TABLE IF EXISTS test.t1;
2
DROP TABLE IF EXISTS test.t2;
3
**** Test Setup Section ****
4
CREATE LOGFILE GROUP lg
5
ADD UNDOFILE './lg_group/undofile.dat'
10
ADD DATAFILE './table_space/datafile.dat'
14
CREATE TABLE test.t1 (
27
SHOW CREATE TABLE test.t1;
29
t1 CREATE TABLE `t1` (
30
`a1` smallint(6) NOT NULL,
31
`a2` int(11) NOT NULL,
32
`a3` bigint(20) NOT NULL,
33
`a4` char(10) DEFAULT NULL,
34
`a5` decimal(5,1) DEFAULT NULL,
35
`a6` time DEFAULT NULL,
36
`a7` date DEFAULT NULL,
37
`a8` datetime DEFAULT NULL,
38
`a9` varchar(255) DEFAULT NULL,
41
) ENGINE=InnoDB DEFAULT CHARSET=latin1
42
SELECT * FROM test.t1 ORDER BY a1;
43
a1 a2 a3 a4 a5 a6 a7 a8 a9 a10
44
1 2 2000000001 aaa1 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb1 binary data
45
2 3 2000000002 aaa2 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb2 binary data
46
3 4 2000000003 aaa3 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb3 binary data
47
4 5 2000000004 aaa4 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb4 binary data
48
5 6 2000000005 aaa5 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb5 binary data
49
6 7 2000000006 aaa6 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb6 binary data
50
7 8 2000000007 aaa7 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb7 binary data
51
8 9 2000000008 aaa8 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb8 binary data
52
9 10 2000000009 aaa9 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb9 binary data
53
10 11 2000000010 aaa10 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb10 binary data
54
11 12 2000000011 aaa11 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb11 binary data
55
12 13 2000000012 aaa12 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb12 binary data
56
13 14 2000000013 aaa13 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb13 binary data
57
14 15 2000000014 aaa14 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb14 binary data
58
15 16 2000000015 aaa15 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb15 binary data
59
16 17 2000000016 aaa16 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb16 binary data
60
17 18 2000000017 aaa17 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb17 binary data
61
18 19 2000000018 aaa18 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb18 binary data
62
19 20 2000000019 aaa19 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb19 binary data
63
20 21 2000000020 aaa20 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb20 binary data
64
ALTER TABLE test.t1 TABLESPACE ts STORAGE DISK ENGINE=NDB;
65
SHOW CREATE TABLE test.t1;
67
t1 CREATE TABLE `t1` (
68
`a1` smallint(6) NOT NULL,
69
`a2` int(11) NOT NULL,
70
`a3` bigint(20) NOT NULL,
71
`a4` char(10) DEFAULT NULL,
72
`a5` decimal(5,1) DEFAULT NULL,
73
`a6` time DEFAULT NULL,
74
`a7` date DEFAULT NULL,
75
`a8` datetime DEFAULT NULL,
76
`a9` varchar(255) DEFAULT NULL,
79
) /*!50100 TABLESPACE ts STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
80
a1 Smallint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
81
a2 Int NOT NULL AT=FIXED ST=DISK
82
a3 Bigint NOT NULL AT=FIXED ST=DISK
83
a4 Char(10;latin1_swedish_ci) NULL AT=FIXED ST=DISK
84
a5 Decimal(5,1) NULL AT=FIXED ST=DISK
85
a6 Time NULL AT=FIXED ST=DISK
86
a7 Date NULL AT=FIXED ST=DISK
87
a8 Datetime NULL AT=FIXED ST=DISK
88
a9 Varchar(255;latin1_swedish_ci) NULL AT=FIXED ST=DISK
89
a10 Blob(256,2000;16) NULL AT=FIXED ST=MEMORY
90
SELECT * FROM test.t1 ORDER BY a1;
91
a1 a2 a3 a4 a5 a6 a7 a8 a9 a10
92
1 2 2000000001 aaa1 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb1 binary data
93
2 3 2000000002 aaa2 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb2 binary data
94
3 4 2000000003 aaa3 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb3 binary data
95
4 5 2000000004 aaa4 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb4 binary data
96
5 6 2000000005 aaa5 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb5 binary data
97
6 7 2000000006 aaa6 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb6 binary data
98
7 8 2000000007 aaa7 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb7 binary data
99
8 9 2000000008 aaa8 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb8 binary data
100
9 10 2000000009 aaa9 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb9 binary data
101
10 11 2000000010 aaa10 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb10 binary data
102
11 12 2000000011 aaa11 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb11 binary data
103
12 13 2000000012 aaa12 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb12 binary data
104
13 14 2000000013 aaa13 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb13 binary data
105
14 15 2000000014 aaa14 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb14 binary data
106
15 16 2000000015 aaa15 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb15 binary data
107
16 17 2000000016 aaa16 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb16 binary data
108
17 18 2000000017 aaa17 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb17 binary data
109
18 19 2000000018 aaa18 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb18 binary data
110
19 20 2000000019 aaa19 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb19 binary data
111
20 21 2000000020 aaa20 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb20 binary data
113
CREATE TABLE test.t1 (
114
a1 smallint NOT NULL,
126
SHOW CREATE TABLE test.t1;
128
t1 CREATE TABLE `t1` (
129
`a1` smallint(6) NOT NULL,
130
`a2` int(11) NOT NULL,
131
`a3` bigint(20) NOT NULL,
132
`a4` char(10) DEFAULT NULL,
133
`a5` decimal(5,1) DEFAULT NULL,
134
`a6` time DEFAULT NULL,
135
`a7` date DEFAULT NULL,
136
`a8` datetime DEFAULT NULL,
137
`a9` varchar(255) DEFAULT NULL,
140
) ENGINE=MyISAM DEFAULT CHARSET=latin1
141
SELECT * FROM test.t1 ORDER BY a1;
142
a1 a2 a3 a4 a5 a6 a7 a8 a9 a10
143
1 2 2000000001 aaa1 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb1 binary data
144
2 3 2000000002 aaa2 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb2 binary data
145
3 4 2000000003 aaa3 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb3 binary data
146
4 5 2000000004 aaa4 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb4 binary data
147
5 6 2000000005 aaa5 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb5 binary data
148
6 7 2000000006 aaa6 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb6 binary data
149
7 8 2000000007 aaa7 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb7 binary data
150
8 9 2000000008 aaa8 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb8 binary data
151
9 10 2000000009 aaa9 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb9 binary data
152
10 11 2000000010 aaa10 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb10 binary data
153
11 12 2000000011 aaa11 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb11 binary data
154
12 13 2000000012 aaa12 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb12 binary data
155
13 14 2000000013 aaa13 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb13 binary data
156
14 15 2000000014 aaa14 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb14 binary data
157
15 16 2000000015 aaa15 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb15 binary data
158
16 17 2000000016 aaa16 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb16 binary data
159
17 18 2000000017 aaa17 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb17 binary data
160
18 19 2000000018 aaa18 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb18 binary data
161
19 20 2000000019 aaa19 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb19 binary data
162
20 21 2000000020 aaa20 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb20 binary data
163
ALTER TABLE test.t1 TABLESPACE ts STORAGE DISK ENGINE=NDB;
164
SHOW CREATE TABLE test.t1;
166
t1 CREATE TABLE `t1` (
167
`a1` smallint(6) NOT NULL,
168
`a2` int(11) NOT NULL,
169
`a3` bigint(20) NOT NULL,
170
`a4` char(10) DEFAULT NULL,
171
`a5` decimal(5,1) DEFAULT NULL,
172
`a6` time DEFAULT NULL,
173
`a7` date DEFAULT NULL,
174
`a8` datetime DEFAULT NULL,
175
`a9` varchar(255) DEFAULT NULL,
178
) /*!50100 TABLESPACE ts STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
179
a1 Smallint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
180
a2 Int NOT NULL AT=FIXED ST=DISK
181
a3 Bigint NOT NULL AT=FIXED ST=DISK
182
a4 Char(10;latin1_swedish_ci) NULL AT=FIXED ST=DISK
183
a5 Decimal(5,1) NULL AT=FIXED ST=DISK
184
a6 Time NULL AT=FIXED ST=DISK
185
a7 Date NULL AT=FIXED ST=DISK
186
a8 Datetime NULL AT=FIXED ST=DISK
187
a9 Varchar(255;latin1_swedish_ci) NULL AT=FIXED ST=DISK
188
a10 Blob(256,2000;16) NULL AT=FIXED ST=MEMORY
189
SELECT * FROM test.t1 ORDER BY a1;
190
a1 a2 a3 a4 a5 a6 a7 a8 a9 a10
191
1 2 2000000001 aaa1 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb1 binary data
192
2 3 2000000002 aaa2 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb2 binary data
193
3 4 2000000003 aaa3 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb3 binary data
194
4 5 2000000004 aaa4 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb4 binary data
195
5 6 2000000005 aaa5 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb5 binary data
196
6 7 2000000006 aaa6 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb6 binary data
197
7 8 2000000007 aaa7 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb7 binary data
198
8 9 2000000008 aaa8 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb8 binary data
199
9 10 2000000009 aaa9 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb9 binary data
200
10 11 2000000010 aaa10 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb10 binary data
201
11 12 2000000011 aaa11 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb11 binary data
202
12 13 2000000012 aaa12 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb12 binary data
203
13 14 2000000013 aaa13 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb13 binary data
204
14 15 2000000014 aaa14 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb14 binary data
205
15 16 2000000015 aaa15 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb15 binary data
206
16 17 2000000016 aaa16 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb16 binary data
207
17 18 2000000017 aaa17 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb17 binary data
208
18 19 2000000018 aaa18 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb18 binary data
209
19 20 2000000019 aaa19 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb19 binary data
210
20 21 2000000020 aaa20 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb20 binary data
211
ALTER TABLE test.t1 ENGINE=InnoDB;
212
SHOW CREATE TABLE test.t1;
214
t1 CREATE TABLE `t1` (
215
`a1` smallint(6) NOT NULL,
216
`a2` int(11) NOT NULL,
217
`a3` bigint(20) NOT NULL,
218
`a4` char(10) DEFAULT NULL,
219
`a5` decimal(5,1) DEFAULT NULL,
220
`a6` time DEFAULT NULL,
221
`a7` date DEFAULT NULL,
222
`a8` datetime DEFAULT NULL,
223
`a9` varchar(255) DEFAULT NULL,
226
) ENGINE=InnoDB DEFAULT CHARSET=latin1
227
SELECT * FROM test.t1 ORDER BY a1;
228
a1 a2 a3 a4 a5 a6 a7 a8 a9 a10
229
1 2 2000000001 aaa1 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb1 binary data
230
2 3 2000000002 aaa2 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb2 binary data
231
3 4 2000000003 aaa3 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb3 binary data
232
4 5 2000000004 aaa4 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb4 binary data
233
5 6 2000000005 aaa5 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb5 binary data
234
6 7 2000000006 aaa6 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb6 binary data
235
7 8 2000000007 aaa7 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb7 binary data
236
8 9 2000000008 aaa8 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb8 binary data
237
9 10 2000000009 aaa9 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb9 binary data
238
10 11 2000000010 aaa10 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb10 binary data
239
11 12 2000000011 aaa11 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb11 binary data
240
12 13 2000000012 aaa12 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb12 binary data
241
13 14 2000000013 aaa13 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb13 binary data
242
14 15 2000000014 aaa14 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb14 binary data
243
15 16 2000000015 aaa15 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb15 binary data
244
16 17 2000000016 aaa16 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb16 binary data
245
17 18 2000000017 aaa17 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb17 binary data
246
18 19 2000000018 aaa18 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb18 binary data
247
19 20 2000000019 aaa19 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb19 binary data
248
20 21 2000000020 aaa20 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb20 binary data
249
ALTER TABLE test.t1 TABLESPACE ts STORAGE DISK ENGINE=NDB;
250
SHOW CREATE TABLE test.t1;
252
t1 CREATE TABLE `t1` (
253
`a1` smallint(6) NOT NULL,
254
`a2` int(11) NOT NULL,
255
`a3` bigint(20) NOT NULL,
256
`a4` char(10) DEFAULT NULL,
257
`a5` decimal(5,1) DEFAULT NULL,
258
`a6` time DEFAULT NULL,
259
`a7` date DEFAULT NULL,
260
`a8` datetime DEFAULT NULL,
261
`a9` varchar(255) DEFAULT NULL,
264
) /*!50100 TABLESPACE ts STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
265
a1 Smallint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
266
a2 Int NOT NULL AT=FIXED ST=DISK
267
a3 Bigint NOT NULL AT=FIXED ST=DISK
268
a4 Char(10;latin1_swedish_ci) NULL AT=FIXED ST=DISK
269
a5 Decimal(5,1) NULL AT=FIXED ST=DISK
270
a6 Time NULL AT=FIXED ST=DISK
271
a7 Date NULL AT=FIXED ST=DISK
272
a8 Datetime NULL AT=FIXED ST=DISK
273
a9 Varchar(255;latin1_swedish_ci) NULL AT=FIXED ST=DISK
274
a10 Blob(256,2000;16) NULL AT=FIXED ST=MEMORY
275
ALTER TABLE test.t1 ENGINE=MyISAM;
276
SHOW CREATE TABLE test.t1;
278
t1 CREATE TABLE `t1` (
279
`a1` smallint(6) NOT NULL,
280
`a2` int(11) NOT NULL,
281
`a3` bigint(20) NOT NULL,
282
`a4` char(10) DEFAULT NULL,
283
`a5` decimal(5,1) DEFAULT NULL,
284
`a6` time DEFAULT NULL,
285
`a7` date DEFAULT NULL,
286
`a8` datetime DEFAULT NULL,
287
`a9` varchar(255) DEFAULT NULL,
290
) ENGINE=MyISAM DEFAULT CHARSET=latin1
292
CREATE TABLE test.t1 (a1 INT PRIMARY KEY) TABLESPACE ts STORAGE DISK ENGINE=NDB;
293
SELECT * FROM test.t1 ORDER BY a1;
315
SELECT * FROM information_schema.partitions WHERE table_name= 't1' AND partition_name = 'p0';
316
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME PARTITION_ORDINAL_POSITION SUBPARTITION_ORDINAL_POSITION PARTITION_METHOD SUBPARTITION_METHOD PARTITION_EXPRESSION SUBPARTITION_EXPRESSION PARTITION_DESCRIPTION TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE CREATE_TIME UPDATE_TIME CHECK_TIME CHECKSUM PARTITION_COMMENT NODEGROUP TABLESPACE_NAME
317
NULL test t1 p0 NULL 1 NULL KEY NULL NULL NULL 0 0 0 NULL 0 0 NULL NULL NULL NULL default ts
318
ALTER TABLE test.t1 ADD a2 FLOAT, ADD a3 DOUBLE;
319
SELECT * FROM information_schema.partitions WHERE table_name= 't1' AND partition_name = 'p0';
320
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME PARTITION_ORDINAL_POSITION SUBPARTITION_ORDINAL_POSITION PARTITION_METHOD SUBPARTITION_METHOD PARTITION_EXPRESSION SUBPARTITION_EXPRESSION PARTITION_DESCRIPTION TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE CREATE_TIME UPDATE_TIME CHECK_TIME CHECKSUM PARTITION_COMMENT NODEGROUP TABLESPACE_NAME
321
NULL test t1 p0 NULL 1 NULL KEY NULL NULL NULL 0 0 0 NULL 0 0 NULL NULL NULL NULL default ts
322
SELECT * FROM test.t1 ORDER BY a1;
344
ALTER TABLE test.t1 ADD a4 BIT, ADD a5 TINYINT, ADD a6 BIGINT, ADD a7 DATE, ADD a8 TIME;
345
SELECT a1,a2,a3,hex(a4), a5,a6,a7,a8 FROM test.t1 ORDER BY a1;
346
a1 a2 a3 hex(a4) a5 a6 a7 a8
347
1 2.2345 20000001 0 1 23457 2006-01-01 07:04:00
348
2 3.2345 20000002 0 1 23458 2006-01-01 07:04:00
349
3 4.2345 20000003 0 1 23459 2006-01-01 07:04:00
350
4 5.2345 20000004 0 1 23460 2006-01-01 07:04:00
351
5 6.2345 20000005 0 1 23461 2006-01-01 07:04:00
352
6 7.2345 20000006 0 1 23462 2006-01-01 07:04:00
353
7 8.2345 20000007 0 1 23463 2006-01-01 07:04:00
354
8 9.2345 20000008 0 1 23464 2006-01-01 07:04:00
355
9 10.2345 20000009 0 1 23465 2006-01-01 07:04:00
356
10 11.2345 20000010 0 1 23466 2006-01-01 07:04:00
357
11 12.2345 20000011 0 1 23467 2006-01-01 07:04:00
358
12 13.2345 20000012 0 1 23468 2006-01-01 07:04:00
359
13 14.2345 20000013 0 1 23469 2006-01-01 07:04:00
360
14 15.2345 20000014 0 1 23470 2006-01-01 07:04:00
361
15 16.2345 20000015 0 1 23471 2006-01-01 07:04:00
362
16 17.2345 20000016 0 1 23472 2006-01-01 07:04:00
363
17 18.2345 20000017 0 1 23473 2006-01-01 07:04:00
364
18 19.2345 20000018 0 1 23474 2006-01-01 07:04:00
365
19 20.2345 20000019 0 1 23475 2006-01-01 07:04:00
366
20 21.2345 20000020 0 1 23476 2006-01-01 07:04:00
367
ALTER TABLE test.t1 ADD a9 DATETIME, ADD a10 TINYTEXT, ADD a11 MEDIUMTEXT, ADD a12 LONGTEXT, ADD a13 TEXT, ADD a14 BLOB;
368
SHOW CREATE TABLE test.t1;
370
t1 CREATE TABLE `t1` (
371
`a1` int(11) NOT NULL,
372
`a2` float DEFAULT NULL,
373
`a3` double DEFAULT NULL,
374
`a4` bit(1) DEFAULT NULL,
375
`a5` tinyint(4) DEFAULT NULL,
376
`a6` bigint(20) DEFAULT NULL,
377
`a7` date DEFAULT NULL,
378
`a8` time DEFAULT NULL,
379
`a9` datetime DEFAULT NULL,
386
) /*!50100 TABLESPACE ts STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
387
a1 Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
388
a2 Float NULL AT=FIXED ST=DISK
389
a3 Double NULL AT=FIXED ST=DISK
390
a4 Bit(1) NULL AT=FIXED ST=DISK
391
a5 Tinyint NULL AT=FIXED ST=DISK
392
a6 Bigint NULL AT=FIXED ST=DISK
393
a7 Date NULL AT=FIXED ST=DISK
394
a8 Time NULL AT=FIXED ST=DISK
395
a9 Datetime NULL AT=FIXED ST=DISK
396
a10 Text(256,0;0;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
397
a11 Text(256,4000;8;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
398
a12 Text(256,8000;4;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
399
a13 Text(256,2000;16;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
400
a14 Blob(256,2000;16) NULL AT=FIXED ST=MEMORY
401
SELECT a1, a2,a3,hex(a4),a5,a6,a7,a8,a9,a10,a11,a12,a13 FROM test.t1 ORDER BY a1;
402
a1 a2 a3 hex(a4) a5 a6 a7 a8 a9 a10 a11 a12 a13
403
1 2.2345 20000001 0 1 23457 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
404
2 3.2345 20000002 0 1 23458 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
405
3 4.2345 20000003 0 1 23459 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
406
4 5.2345 20000004 0 1 23460 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
407
5 6.2345 20000005 0 1 23461 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
408
6 7.2345 20000006 0 1 23462 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
409
7 8.2345 20000007 0 1 23463 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
410
8 9.2345 20000008 0 1 23464 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
411
9 10.2345 20000009 0 1 23465 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
412
10 11.2345 20000010 0 1 23466 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
413
11 12.2345 20000011 0 1 23467 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
414
12 13.2345 20000012 0 1 23468 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
415
13 14.2345 20000013 0 1 23469 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
416
14 15.2345 20000014 0 1 23470 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
417
15 16.2345 20000015 0 1 23471 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
418
16 17.2345 20000016 0 1 23472 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
419
17 18.2345 20000017 0 1 23473 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
420
18 19.2345 20000018 0 1 23474 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
421
19 20.2345 20000019 0 1 23475 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
422
20 21.2345 20000020 0 1 23476 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
423
ALTER TABLE test.t1 ADD INDEX a2_i (a2), ADD INDEX a3_i (a3);
424
SHOW CREATE TABLE test.t1;
426
t1 CREATE TABLE `t1` (
427
`a1` int(11) NOT NULL,
428
`a2` float DEFAULT NULL,
429
`a3` double DEFAULT NULL,
430
`a4` bit(1) DEFAULT NULL,
431
`a5` tinyint(4) DEFAULT NULL,
432
`a6` bigint(20) DEFAULT NULL,
433
`a7` date DEFAULT NULL,
434
`a8` time DEFAULT NULL,
435
`a9` datetime DEFAULT NULL,
444
) /*!50100 TABLESPACE ts STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
445
a1 Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
446
a2 Float NULL AT=FIXED ST=MEMORY
447
a3 Double NULL AT=FIXED ST=MEMORY
448
a4 Bit(1) NULL AT=FIXED ST=DISK
449
a5 Tinyint NULL AT=FIXED ST=DISK
450
a6 Bigint NULL AT=FIXED ST=DISK
451
a7 Date NULL AT=FIXED ST=DISK
452
a8 Time NULL AT=FIXED ST=DISK
453
a9 Datetime NULL AT=FIXED ST=DISK
454
a10 Text(256,0;0;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
455
a11 Text(256,4000;8;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
456
a12 Text(256,8000;4;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
457
a13 Text(256,2000;16;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
458
a14 Blob(256,2000;16) NULL AT=FIXED ST=MEMORY
459
ALTER TABLE test.t1 DROP INDEX a2_i;
460
SHOW CREATE TABLE test.t1;
462
t1 CREATE TABLE `t1` (
463
`a1` int(11) NOT NULL,
464
`a2` float DEFAULT NULL,
465
`a3` double DEFAULT NULL,
466
`a4` bit(1) DEFAULT NULL,
467
`a5` tinyint(4) DEFAULT NULL,
468
`a6` bigint(20) DEFAULT NULL,
469
`a7` date DEFAULT NULL,
470
`a8` time DEFAULT NULL,
471
`a9` datetime DEFAULT NULL,
479
) /*!50100 TABLESPACE ts STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
480
a1 Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
481
a2 Float NULL AT=FIXED ST=DISK
482
a3 Double NULL AT=FIXED ST=MEMORY
483
a4 Bit(1) NULL AT=FIXED ST=DISK
484
a5 Tinyint NULL AT=FIXED ST=DISK
485
a6 Bigint NULL AT=FIXED ST=DISK
486
a7 Date NULL AT=FIXED ST=DISK
487
a8 Time NULL AT=FIXED ST=DISK
488
a9 Datetime NULL AT=FIXED ST=DISK
489
a10 Text(256,0;0;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
490
a11 Text(256,4000;8;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
491
a12 Text(256,8000;4;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
492
a13 Text(256,2000;16;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
493
a14 Blob(256,2000;16) NULL AT=FIXED ST=MEMORY
494
TRUNCATE TABLE test.t1;
495
SHOW CREATE TABLE test.t1;
497
t1 CREATE TABLE `t1` (
498
`a1` int(11) NOT NULL,
499
`a2` float DEFAULT NULL,
500
`a3` double DEFAULT NULL,
501
`a4` bit(1) DEFAULT NULL,
502
`a5` tinyint(4) DEFAULT NULL,
503
`a6` bigint(20) DEFAULT NULL,
504
`a7` date DEFAULT NULL,
505
`a8` time DEFAULT NULL,
506
`a9` datetime DEFAULT NULL,
514
) /*!50100 TABLESPACE ts STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
515
a1 Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
516
a2 Float NULL AT=FIXED ST=DISK
517
a3 Double NULL AT=FIXED ST=MEMORY
518
a4 Bit(1) NULL AT=FIXED ST=DISK
519
a5 Tinyint NULL AT=FIXED ST=DISK
520
a6 Bigint NULL AT=FIXED ST=DISK
521
a7 Date NULL AT=FIXED ST=DISK
522
a8 Time NULL AT=FIXED ST=DISK
523
a9 Datetime NULL AT=FIXED ST=DISK
524
a10 Text(256,0;0;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
525
a11 Text(256,4000;8;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
526
a12 Text(256,8000;4;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
527
a13 Text(256,2000;16;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
528
a14 Blob(256,2000;16) NULL AT=FIXED ST=MEMORY
529
ALTER TABLE test.t1 DROP a14;
530
ALTER TABLE test.t1 DROP a13;
531
ALTER TABLE test.t1 DROP a12;
532
ALTER TABLE test.t1 DROP a11;
533
ALTER TABLE test.t1 DROP a10;
534
ALTER TABLE test.t1 DROP a9;
535
ALTER TABLE test.t1 DROP a8;
536
ALTER TABLE test.t1 DROP a7;
537
ALTER TABLE test.t1 DROP a6;
538
ALTER TABLE test.t1 DROP PRIMARY KEY;
539
SHOW CREATE TABLE test.t1;
541
t1 CREATE TABLE `t1` (
542
`a1` int(11) NOT NULL,
543
`a2` float DEFAULT NULL,
544
`a3` double DEFAULT NULL,
545
`a4` bit(1) DEFAULT NULL,
546
`a5` tinyint(4) DEFAULT NULL,
548
) /*!50100 TABLESPACE ts STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
549
a1 Int NOT NULL AT=FIXED ST=DISK
550
a2 Float NULL AT=FIXED ST=DISK
551
a3 Double NULL AT=FIXED ST=MEMORY
552
a4 Bit(1) NULL AT=FIXED ST=DISK
553
a5 Tinyint NULL AT=FIXED ST=DISK
554
$PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
557
DROP DATAFILE './table_space/datafile.dat'
559
DROP TABLESPACE ts ENGINE NDB;
560
DROP LOGFILE GROUP lg ENGINE=NDB;