Debian Codegraph @

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

raw
1 **** Test Setup Section ****
2 CREATE LOGFILE GROUP lg
3 ADD UNDOFILE './lg_group/undofile.dat'
4 INITIAL_SIZE 16M
5 UNDO_BUFFER_SIZE = 1M
6 ENGINE=NDB;
7 CREATE TABLESPACE ts
8 ADD DATAFILE './table_space/datafile.dat'
9 USE LOGFILE GROUP lg
10 INITIAL_SIZE 36M
11 ENGINE NDB;
12 CREATE TABLE test.t1 (
13 a1 smallint NOT NULL,
14 a2 int NOT NULL,
15 a3 bigint NOT NULL,
16 a4 char(10),
17 a5 decimal(5,1),
18 a6 time,
19 a7 date,
20 a8 datetime,
21 a9 VARCHAR(255),
22 a10 blob,
23 PRIMARY KEY(a1)
24 ) ENGINE=InnoDB;
25 SHOW CREATE TABLE test.t1;
26 Table Create Table
27 t1 CREATE TABLE `t1` (
28 `a1` smallint NOT NULL,
29 `a2` int NOT NULL,
30 `a3` bigint NOT NULL,
31 `a4` char(10) DEFAULT NULL,
32 `a5` decimal(5,1) DEFAULT NULL,
33 `a6` time DEFAULT NULL,
34 `a7` date DEFAULT NULL,
35 `a8` datetime DEFAULT NULL,
36 `a9` varchar(255) DEFAULT NULL,
37 `a10` blob,
38 PRIMARY KEY (`a1`)
39 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
40 SELECT * FROM test.t1 ORDER BY a1;
41 a1 a2 a3 a4 a5 a6 a7 a8 a9 a10
42 1 2 2000000001 aaa1 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb1 binary data
43 2 3 2000000002 aaa2 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb2 binary data
44 3 4 2000000003 aaa3 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb3 binary data
45 4 5 2000000004 aaa4 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb4 binary data
46 5 6 2000000005 aaa5 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb5 binary data
47 6 7 2000000006 aaa6 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb6 binary data
48 7 8 2000000007 aaa7 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb7 binary data
49 8 9 2000000008 aaa8 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb8 binary data
50 9 10 2000000009 aaa9 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb9 binary data
51 10 11 2000000010 aaa10 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb10 binary data
52 11 12 2000000011 aaa11 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb11 binary data
53 12 13 2000000012 aaa12 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb12 binary data
54 13 14 2000000013 aaa13 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb13 binary data
55 14 15 2000000014 aaa14 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb14 binary data
56 15 16 2000000015 aaa15 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb15 binary data
57 16 17 2000000016 aaa16 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb16 binary data
58 17 18 2000000017 aaa17 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb17 binary data
59 18 19 2000000018 aaa18 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb18 binary data
60 19 20 2000000019 aaa19 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb19 binary data
61 20 21 2000000020 aaa20 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb20 binary data
62 ALTER TABLE test.t1 ALGORITHM=INPLACE, TABLESPACE ts STORAGE DISK ENGINE=NDB;
63 ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY.
64 ALTER TABLE test.t1 ALGORITHM=COPY, TABLESPACE ts STORAGE DISK ENGINE=NDB;
65 SHOW CREATE TABLE test.t1;
66 Table Create Table
67 t1 CREATE TABLE `t1` (
68 `a1` smallint NOT NULL,
69 `a2` int NOT NULL,
70 `a3` bigint 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,
77 `a10` blob,
78 PRIMARY KEY (`a1`)
79 ) /*!50100 TABLESPACE `ts` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
80 Attributes:
81 a1 Smallint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
82 a2 Int NOT NULL AT=FIXED ST=DISK
83 a3 Bigint NOT NULL AT=FIXED ST=DISK
84 a4 Char(40;utf8mb4_0900_ai_ci) NULL AT=FIXED ST=DISK
85 a5 Decimal(5,1) NULL AT=FIXED ST=DISK
86 a6 Time2(0) NULL AT=FIXED ST=DISK
87 a7 Date NULL AT=FIXED ST=DISK
88 a8 Datetime2(0) NULL AT=FIXED ST=DISK
89 a9 Longvarchar(1020;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK
90 a10 Blob(256,2000,0) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
91 SELECT * FROM test.t1 ORDER BY a1;
92 a1 a2 a3 a4 a5 a6 a7 a8 a9 a10
93 1 2 2000000001 aaa1 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb1 binary data
94 2 3 2000000002 aaa2 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb2 binary data
95 3 4 2000000003 aaa3 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb3 binary data
96 4 5 2000000004 aaa4 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb4 binary data
97 5 6 2000000005 aaa5 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb5 binary data
98 6 7 2000000006 aaa6 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb6 binary data
99 7 8 2000000007 aaa7 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb7 binary data
100 8 9 2000000008 aaa8 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb8 binary data
101 9 10 2000000009 aaa9 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb9 binary data
102 10 11 2000000010 aaa10 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb10 binary data
103 11 12 2000000011 aaa11 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb11 binary data
104 12 13 2000000012 aaa12 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb12 binary data
105 13 14 2000000013 aaa13 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb13 binary data
106 14 15 2000000014 aaa14 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb14 binary data
107 15 16 2000000015 aaa15 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb15 binary data
108 16 17 2000000016 aaa16 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb16 binary data
109 17 18 2000000017 aaa17 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb17 binary data
110 18 19 2000000018 aaa18 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb18 binary data
111 19 20 2000000019 aaa19 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb19 binary data
112 20 21 2000000020 aaa20 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb20 binary data
113 DROP TABLE test.t1;
114 CREATE TABLE test.t1 (
115 a1 smallint NOT NULL,
116 a2 int NOT NULL,
117 a3 bigint NOT NULL,
118 a4 char(10),
119 a5 decimal(5,1),
120 a6 time,
121 a7 date,
122 a8 datetime,
123 a9 VARCHAR(255),
124 a10 blob,
125 PRIMARY KEY(a1)
126 ) ENGINE=MyISAM;
127 SHOW CREATE TABLE test.t1;
128 Table Create Table
129 t1 CREATE TABLE `t1` (
130 `a1` smallint NOT NULL,
131 `a2` int NOT NULL,
132 `a3` bigint NOT NULL,
133 `a4` char(10) DEFAULT NULL,
134 `a5` decimal(5,1) DEFAULT NULL,
135 `a6` time DEFAULT NULL,
136 `a7` date DEFAULT NULL,
137 `a8` datetime DEFAULT NULL,
138 `a9` varchar(255) DEFAULT NULL,
139 `a10` blob,
140 PRIMARY KEY (`a1`)
141 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
142 SELECT * FROM test.t1 ORDER BY a1;
143 a1 a2 a3 a4 a5 a6 a7 a8 a9 a10
144 1 2 2000000001 aaa1 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb1 binary data
145 2 3 2000000002 aaa2 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb2 binary data
146 3 4 2000000003 aaa3 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb3 binary data
147 4 5 2000000004 aaa4 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb4 binary data
148 5 6 2000000005 aaa5 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb5 binary data
149 6 7 2000000006 aaa6 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb6 binary data
150 7 8 2000000007 aaa7 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb7 binary data
151 8 9 2000000008 aaa8 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb8 binary data
152 9 10 2000000009 aaa9 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb9 binary data
153 10 11 2000000010 aaa10 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb10 binary data
154 11 12 2000000011 aaa11 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb11 binary data
155 12 13 2000000012 aaa12 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb12 binary data
156 13 14 2000000013 aaa13 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb13 binary data
157 14 15 2000000014 aaa14 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb14 binary data
158 15 16 2000000015 aaa15 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb15 binary data
159 16 17 2000000016 aaa16 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb16 binary data
160 17 18 2000000017 aaa17 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb17 binary data
161 18 19 2000000018 aaa18 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb18 binary data
162 19 20 2000000019 aaa19 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb19 binary data
163 20 21 2000000020 aaa20 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb20 binary data
164 ALTER TABLE test.t1 ALGORITHM=COPY, TABLESPACE ts STORAGE DISK ENGINE=NDB;
165 SHOW CREATE TABLE test.t1;
166 Table Create Table
167 t1 CREATE TABLE `t1` (
168 `a1` smallint NOT NULL,
169 `a2` int NOT NULL,
170 `a3` bigint NOT NULL,
171 `a4` char(10) DEFAULT NULL,
172 `a5` decimal(5,1) DEFAULT NULL,
173 `a6` time DEFAULT NULL,
174 `a7` date DEFAULT NULL,
175 `a8` datetime DEFAULT NULL,
176 `a9` varchar(255) DEFAULT NULL,
177 `a10` blob,
178 PRIMARY KEY (`a1`)
179 ) /*!50100 TABLESPACE `ts` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
180 Attributes:
181 a1 Smallint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
182 a2 Int NOT NULL AT=FIXED ST=DISK
183 a3 Bigint NOT NULL AT=FIXED ST=DISK
184 a4 Char(40;utf8mb4_0900_ai_ci) NULL AT=FIXED ST=DISK
185 a5 Decimal(5,1) NULL AT=FIXED ST=DISK
186 a6 Time2(0) NULL AT=FIXED ST=DISK
187 a7 Date NULL AT=FIXED ST=DISK
188 a8 Datetime2(0) NULL AT=FIXED ST=DISK
189 a9 Longvarchar(1020;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK
190 a10 Blob(256,2000,0) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
191 SELECT * FROM test.t1 ORDER BY a1;
192 a1 a2 a3 a4 a5 a6 a7 a8 a9 a10
193 1 2 2000000001 aaa1 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb1 binary data
194 2 3 2000000002 aaa2 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb2 binary data
195 3 4 2000000003 aaa3 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb3 binary data
196 4 5 2000000004 aaa4 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb4 binary data
197 5 6 2000000005 aaa5 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb5 binary data
198 6 7 2000000006 aaa6 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb6 binary data
199 7 8 2000000007 aaa7 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb7 binary data
200 8 9 2000000008 aaa8 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb8 binary data
201 9 10 2000000009 aaa9 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb9 binary data
202 10 11 2000000010 aaa10 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb10 binary data
203 11 12 2000000011 aaa11 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb11 binary data
204 12 13 2000000012 aaa12 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb12 binary data
205 13 14 2000000013 aaa13 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb13 binary data
206 14 15 2000000014 aaa14 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb14 binary data
207 15 16 2000000015 aaa15 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb15 binary data
208 16 17 2000000016 aaa16 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb16 binary data
209 17 18 2000000017 aaa17 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb17 binary data
210 18 19 2000000018 aaa18 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb18 binary data
211 19 20 2000000019 aaa19 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb19 binary data
212 20 21 2000000020 aaa20 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb20 binary data
213 CREATE TABLESPACE ts_innodb ADD DATAFILE 'ts_innodb.ibd' ENGINE=Innodb;
214 ALTER TABLE test.t1 ALGORITHM=INPLACE, ENGINE=InnoDB TABLESPACE ts_innodb;
215 ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY.
216 ALTER TABLE test.t1 ALGORITHM=COPY, ENGINE=InnoDB TABLESPACE ts_innodb;
217 SHOW CREATE TABLE test.t1;
218 Table Create Table
219 t1 CREATE TABLE `t1` (
220 `a1` smallint NOT NULL,
221 `a2` int NOT NULL,
222 `a3` bigint NOT NULL,
223 `a4` char(10) DEFAULT NULL,
224 `a5` decimal(5,1) DEFAULT NULL,
225 `a6` time DEFAULT NULL,
226 `a7` date DEFAULT NULL,
227 `a8` datetime DEFAULT NULL,
228 `a9` varchar(255) DEFAULT NULL,
229 `a10` blob,
230 PRIMARY KEY (`a1`)
231 ) /*!50100 TABLESPACE `ts_innodb` STORAGE DISK */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
232 SELECT * FROM test.t1 ORDER BY a1;
233 a1 a2 a3 a4 a5 a6 a7 a8 a9 a10
234 1 2 2000000001 aaa1 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb1 binary data
235 2 3 2000000002 aaa2 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb2 binary data
236 3 4 2000000003 aaa3 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb3 binary data
237 4 5 2000000004 aaa4 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb4 binary data
238 5 6 2000000005 aaa5 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb5 binary data
239 6 7 2000000006 aaa6 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb6 binary data
240 7 8 2000000007 aaa7 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb7 binary data
241 8 9 2000000008 aaa8 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb8 binary data
242 9 10 2000000009 aaa9 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb9 binary data
243 10 11 2000000010 aaa10 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb10 binary data
244 11 12 2000000011 aaa11 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb11 binary data
245 12 13 2000000012 aaa12 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb12 binary data
246 13 14 2000000013 aaa13 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb13 binary data
247 14 15 2000000014 aaa14 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb14 binary data
248 15 16 2000000015 aaa15 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb15 binary data
249 16 17 2000000016 aaa16 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb16 binary data
250 17 18 2000000017 aaa17 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb17 binary data
251 18 19 2000000018 aaa18 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb18 binary data
252 19 20 2000000019 aaa19 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb19 binary data
253 20 21 2000000020 aaa20 34.2 04:03:02 2006-01-01 1971-05-28 16:55:03 bbbbbbbbbbbbb20 binary data
254 ALTER TABLE test.t1 TABLESPACE ts STORAGE DISK ENGINE=NDB;
255 SHOW CREATE TABLE test.t1;
256 Table Create Table
257 t1 CREATE TABLE `t1` (
258 `a1` smallint NOT NULL,
259 `a2` int NOT NULL,
260 `a3` bigint NOT NULL,
261 `a4` char(10) DEFAULT NULL,
262 `a5` decimal(5,1) DEFAULT NULL,
263 `a6` time DEFAULT NULL,
264 `a7` date DEFAULT NULL,
265 `a8` datetime DEFAULT NULL,
266 `a9` varchar(255) DEFAULT NULL,
267 `a10` blob,
268 PRIMARY KEY (`a1`)
269 ) /*!50100 TABLESPACE `ts` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
270 Attributes:
271 a1 Smallint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
272 a2 Int NOT NULL AT=FIXED ST=DISK
273 a3 Bigint NOT NULL AT=FIXED ST=DISK
274 a4 Char(40;utf8mb4_0900_ai_ci) NULL AT=FIXED ST=DISK
275 a5 Decimal(5,1) NULL AT=FIXED ST=DISK
276 a6 Time2(0) NULL AT=FIXED ST=DISK
277 a7 Date NULL AT=FIXED ST=DISK
278 a8 Datetime2(0) NULL AT=FIXED ST=DISK
279 a9 Longvarchar(1020;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK
280 a10 Blob(256,2000,0) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
281 DROP TABLESPACE ts_innodb;
282 ALTER TABLE test.t1 ALGORITHM=INPLACE, ENGINE=MyISAM;
283 ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY.
284 ALTER TABLE test.t1 ALGORITHM=COPY, ENGINE=MyISAM;
285 SHOW CREATE TABLE test.t1;
286 Table Create Table
287 t1 CREATE TABLE `t1` (
288 `a1` smallint NOT NULL,
289 `a2` int NOT NULL,
290 `a3` bigint NOT NULL,
291 `a4` char(10) DEFAULT NULL,
292 `a5` decimal(5,1) DEFAULT NULL,
293 `a6` time DEFAULT NULL,
294 `a7` date DEFAULT NULL,
295 `a8` datetime DEFAULT NULL,
296 `a9` varchar(255) DEFAULT NULL,
297 `a10` blob,
298 PRIMARY KEY (`a1`)
299 ) /*!50100 TABLESPACE `ts` STORAGE DISK */ ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
300 DROP TABLE test.t1;
301 CREATE TABLE test.t1 (a1 INT PRIMARY KEY) TABLESPACE ts STORAGE DISK ENGINE=NDB;
302 SELECT * FROM test.t1 ORDER BY a1;
303 a1
304 1
305 2
306 3
307 4
308 5
309 6
310 7
311 8
312 9
313 10
314 11
315 12
316 13
317 14
318 15
319 16
320 17
321 18
322 19
323 20
324 SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME,
325 PARTITION_NAME, PARTITION_ORDINAL_POSITION, TABLESPACE_NAME
326 FROM information_schema.partitions
327 WHERE table_name= 't1' AND partition_name = 'p0';
328 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION TABLESPACE_NAME
329 def test t1 p0 1 NULL
330 ALTER TABLE test.t1 ALGORITHM=INPLACE, ADD a2 FLOAT, ADD a3 DOUBLE;
331 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Adding column(s) or add/reorganize partition not supported online. Try ALGORITHM=COPY.
332 ALTER TABLE test.t1 ALGORITHM=COPY, ADD a2 FLOAT, ADD a3 DOUBLE;
333 SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME,
334 PARTITION_NAME, PARTITION_ORDINAL_POSITION, TABLESPACE_NAME
335 FROM information_schema.partitions
336 WHERE table_name= 't1' AND partition_name = 'p0';
337 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION TABLESPACE_NAME
338 def test t1 p0 1 NULL
339 SELECT * FROM test.t1 ORDER BY a1;
340 a1 a2 a3
341 1 2.2345 20000001
342 2 3.2345 20000002
343 3 4.2345 20000003
344 4 5.2345 20000004
345 5 6.2345 20000005
346 6 7.2345 20000006
347 7 8.2345 20000007
348 8 9.2345 20000008
349 9 10.2345 20000009
350 10 11.2345 20000010
351 11 12.2345 20000011
352 12 13.2345 20000012
353 13 14.2345 20000013
354 14 15.2345 20000014
355 15 16.2345 20000015
356 16 17.2345 20000016
357 17 18.2345 20000017
358 18 19.2345 20000018
359 19 20.2345 20000019
360 20 21.2345 20000020
361 ALTER TABLE test.t1 ALGORITHM=COPY, ADD a4 BIT, ADD a5 TINYINT, ADD a6 BIGINT, ADD a7 DATE, ADD a8 TIME;
362 SELECT a1,a2,a3,hex(a4), a5,a6,a7,a8 FROM test.t1 ORDER BY a1;
363 a1 a2 a3 hex(a4) a5 a6 a7 a8
364 1 2.2345 20000001 0 1 23457 2006-01-01 07:04:00
365 2 3.2345 20000002 0 1 23458 2006-01-01 07:04:00
366 3 4.2345 20000003 0 1 23459 2006-01-01 07:04:00
367 4 5.2345 20000004 0 1 23460 2006-01-01 07:04:00
368 5 6.2345 20000005 0 1 23461 2006-01-01 07:04:00
369 6 7.2345 20000006 0 1 23462 2006-01-01 07:04:00
370 7 8.2345 20000007 0 1 23463 2006-01-01 07:04:00
371 8 9.2345 20000008 0 1 23464 2006-01-01 07:04:00
372 9 10.2345 20000009 0 1 23465 2006-01-01 07:04:00
373 10 11.2345 20000010 0 1 23466 2006-01-01 07:04:00
374 11 12.2345 20000011 0 1 23467 2006-01-01 07:04:00
375 12 13.2345 20000012 0 1 23468 2006-01-01 07:04:00
376 13 14.2345 20000013 0 1 23469 2006-01-01 07:04:00
377 14 15.2345 20000014 0 1 23470 2006-01-01 07:04:00
378 15 16.2345 20000015 0 1 23471 2006-01-01 07:04:00
379 16 17.2345 20000016 0 1 23472 2006-01-01 07:04:00
380 17 18.2345 20000017 0 1 23473 2006-01-01 07:04:00
381 18 19.2345 20000018 0 1 23474 2006-01-01 07:04:00
382 19 20.2345 20000019 0 1 23475 2006-01-01 07:04:00
383 20 21.2345 20000020 0 1 23476 2006-01-01 07:04:00
384 ALTER TABLE test.t1 ADD a9 DATETIME, ADD a10 TINYTEXT, ADD a11 MEDIUMTEXT, ADD a12 LONGTEXT, ADD a13 TEXT, ADD a14 BLOB;
385 SHOW CREATE TABLE test.t1;
386 Table Create Table
387 t1 CREATE TABLE `t1` (
388 `a1` int NOT NULL,
389 `a2` float DEFAULT NULL,
390 `a3` double DEFAULT NULL,
391 `a4` bit(1) DEFAULT NULL,
392 `a5` tinyint DEFAULT NULL,
393 `a6` bigint DEFAULT NULL,
394 `a7` date DEFAULT NULL,
395 `a8` time DEFAULT NULL,
396 `a9` datetime DEFAULT NULL,
397 `a10` tinytext,
398 `a11` mediumtext,
399 `a12` longtext,
400 `a13` text,
401 `a14` blob,
402 PRIMARY KEY (`a1`)
403 ) /*!50100 TABLESPACE `ts` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
404 Attributes:
405 a1 Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
406 a2 Float NULL AT=FIXED ST=DISK
407 a3 Double NULL AT=FIXED ST=DISK
408 a4 Bit(1) NULL AT=FIXED ST=DISK
409 a5 Tinyint NULL AT=FIXED ST=DISK
410 a6 Bigint NULL AT=FIXED ST=DISK
411 a7 Date NULL AT=FIXED ST=DISK
412 a8 Time2(0) NULL AT=FIXED ST=DISK
413 a9 Datetime2(0) NULL AT=FIXED ST=DISK
414 a10 Text(256,0,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=MEMORY
415 a11 Text(256,4000,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
416 a12 Text(256,13948,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
417 a13 Text(256,2000,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
418 a14 Blob(256,2000,0) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
419 SELECT a1, a2,a3,hex(a4),a5,a6,a7,a8,a9,a10,a11,a12,a13 FROM test.t1 ORDER BY a1;
420 a1 a2 a3 hex(a4) a5 a6 a7 a8 a9 a10 a11 a12 a13
421 1 2.2345 20000001 0 1 23457 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
422 2 3.2345 20000002 0 1 23458 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
423 3 4.2345 20000003 0 1 23459 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
424 4 5.2345 20000004 0 1 23460 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
425 5 6.2345 20000005 0 1 23461 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
426 6 7.2345 20000006 0 1 23462 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
427 7 8.2345 20000007 0 1 23463 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
428 8 9.2345 20000008 0 1 23464 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
429 9 10.2345 20000009 0 1 23465 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
430 10 11.2345 20000010 0 1 23466 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
431 11 12.2345 20000011 0 1 23467 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
432 12 13.2345 20000012 0 1 23468 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
433 13 14.2345 20000013 0 1 23469 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
434 14 15.2345 20000014 0 1 23470 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
435 15 16.2345 20000015 0 1 23471 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
436 16 17.2345 20000016 0 1 23472 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
437 17 18.2345 20000017 0 1 23473 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
438 18 19.2345 20000018 0 1 23474 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
439 19 20.2345 20000019 0 1 23475 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
440 20 21.2345 20000020 0 1 23476 2006-01-01 07:04:00 1971-05-28 16:55:03 abc abcdefg LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Text Field
441 CREATE TABLESPACE ts2
442 ADD DATAFILE './table_space/datafile2.dat'
443 USE LOGFILE GROUP lg
444 INITIAL_SIZE 1M
445 ENGINE NDB;
446 Expecting tablespace is full error
447 ALTER TABLE test.t1 TABLESPACE ts2 STORAGE DISK ENGINE NDB;
448 Got one of the listed errors
449 ALTER TABLESPACE ts2
450 DROP DATAFILE './table_space/datafile2.dat';
451 DROP TABLESPACE ts2;
452 ALTER TABLE test.t1 ALGORITHM=INPLACE, ADD INDEX a2_i (a2), ADD INDEX a3_i (a3);
453 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Add/drop index is not supported for disk stored column. Try ALGORITHM=COPY.
454 ALTER TABLE test.t1 ALGORITHM=COPY, ADD INDEX a2_i (a2), ADD INDEX a3_i (a3);
455 SHOW CREATE TABLE test.t1;
456 Table Create Table
457 t1 CREATE TABLE `t1` (
458 `a1` int NOT NULL,
459 `a2` float DEFAULT NULL,
460 `a3` double DEFAULT NULL,
461 `a4` bit(1) DEFAULT NULL,
462 `a5` tinyint DEFAULT NULL,
463 `a6` bigint DEFAULT NULL,
464 `a7` date DEFAULT NULL,
465 `a8` time DEFAULT NULL,
466 `a9` datetime DEFAULT NULL,
467 `a10` tinytext,
468 `a11` mediumtext,
469 `a12` longtext,
470 `a13` text,
471 `a14` blob,
472 PRIMARY KEY (`a1`),
473 KEY `a2_i` (`a2`),
474 KEY `a3_i` (`a3`)
475 ) /*!50100 TABLESPACE `ts` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
476 Attributes:
477 a1 Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
478 a2 Float NULL AT=FIXED ST=MEMORY
479 a3 Double NULL AT=FIXED ST=MEMORY
480 a4 Bit(1) NULL AT=FIXED ST=DISK
481 a5 Tinyint NULL AT=FIXED ST=DISK
482 a6 Bigint NULL AT=FIXED ST=DISK
483 a7 Date NULL AT=FIXED ST=DISK
484 a8 Time2(0) NULL AT=FIXED ST=DISK
485 a9 Datetime2(0) NULL AT=FIXED ST=DISK
486 a10 Text(256,0,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=MEMORY
487 a11 Text(256,4000,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
488 a12 Text(256,13948,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
489 a13 Text(256,2000,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
490 a14 Blob(256,2000,0) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
491 ALTER TABLE test.t1 ALGORITHM=INPLACE, DROP INDEX a2_i;
492 SHOW CREATE TABLE test.t1;
493 Table Create Table
494 t1 CREATE TABLE `t1` (
495 `a1` int NOT NULL,
496 `a2` float DEFAULT NULL,
497 `a3` double DEFAULT NULL,
498 `a4` bit(1) DEFAULT NULL,
499 `a5` tinyint DEFAULT NULL,
500 `a6` bigint DEFAULT NULL,
501 `a7` date DEFAULT NULL,
502 `a8` time DEFAULT NULL,
503 `a9` datetime DEFAULT NULL,
504 `a10` tinytext,
505 `a11` mediumtext,
506 `a12` longtext,
507 `a13` text,
508 `a14` blob,
509 PRIMARY KEY (`a1`),
510 KEY `a3_i` (`a3`)
511 ) /*!50100 TABLESPACE `ts` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
512 Attributes:
513 a1 Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
514 a2 Float NULL AT=FIXED ST=MEMORY
515 a3 Double NULL AT=FIXED ST=MEMORY
516 a4 Bit(1) NULL AT=FIXED ST=DISK
517 a5 Tinyint NULL AT=FIXED ST=DISK
518 a6 Bigint NULL AT=FIXED ST=DISK
519 a7 Date NULL AT=FIXED ST=DISK
520 a8 Time2(0) NULL AT=FIXED ST=DISK
521 a9 Datetime2(0) NULL AT=FIXED ST=DISK
522 a10 Text(256,0,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=MEMORY
523 a11 Text(256,4000,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
524 a12 Text(256,13948,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
525 a13 Text(256,2000,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
526 a14 Blob(256,2000,0) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
527 TRUNCATE TABLE test.t1;
528 SHOW CREATE TABLE test.t1;
529 Table Create Table
530 t1 CREATE TABLE `t1` (
531 `a1` int NOT NULL,
532 `a2` float DEFAULT NULL,
533 `a3` double DEFAULT NULL,
534 `a4` bit(1) DEFAULT NULL,
535 `a5` tinyint DEFAULT NULL,
536 `a6` bigint DEFAULT NULL,
537 `a7` date DEFAULT NULL,
538 `a8` time DEFAULT NULL,
539 `a9` datetime DEFAULT NULL,
540 `a10` tinytext,
541 `a11` mediumtext,
542 `a12` longtext,
543 `a13` text,
544 `a14` blob,
545 PRIMARY KEY (`a1`),
546 KEY `a3_i` (`a3`)
547 ) /*!50100 TABLESPACE `ts` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
548 Attributes:
549 a1 Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
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 a6 Bigint NULL AT=FIXED ST=DISK
555 a7 Date NULL AT=FIXED ST=DISK
556 a8 Time2(0) NULL AT=FIXED ST=DISK
557 a9 Datetime2(0) NULL AT=FIXED ST=DISK
558 a10 Text(256,0,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=MEMORY
559 a11 Text(256,4000,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
560 a12 Text(256,13948,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
561 a13 Text(256,2000,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
562 a14 Blob(256,2000,0) NULL AT=MEDIUM_VAR ST=DISK BV=2 BT=NDB$BLOB_#_#
563 ALTER TABLE test.t1 ALGORITHM=INPLACE, DROP a14;
564 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Dropping column. Try ALGORITHM=COPY.
565 ALTER TABLE test.t1 ALGORITHM=COPY, DROP a14;
566 ALTER TABLE test.t1 DROP a13;
567 ALTER TABLE test.t1 DROP a12;
568 ALTER TABLE test.t1 DROP a11;
569 ALTER TABLE test.t1 DROP a10;
570 ALTER TABLE test.t1 DROP a9;
571 ALTER TABLE test.t1 DROP a8;
572 ALTER TABLE test.t1 DROP a7;
573 ALTER TABLE test.t1 DROP a6;
574 ALTER TABLE test.t1 ALGORITHM=INPLACE, DROP PRIMARY KEY;
575 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Dropping primary key. Try ALGORITHM=COPY.
576 ALTER TABLE test.t1 ALGORITHM=COPY, DROP PRIMARY KEY;
577 SHOW CREATE TABLE test.t1;
578 Table Create Table
579 t1 CREATE TABLE `t1` (
580 `a1` int NOT NULL,
581 `a2` float DEFAULT NULL,
582 `a3` double DEFAULT NULL,
583 `a4` bit(1) DEFAULT NULL,
584 `a5` tinyint DEFAULT NULL,
585 KEY `a3_i` (`a3`)
586 ) /*!50100 TABLESPACE `ts` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
587 Attributes:
588 a1 Int NOT NULL AT=FIXED ST=DISK
589 a2 Float NULL AT=FIXED ST=DISK
590 a3 Double NULL AT=FIXED ST=MEMORY
591 a4 Bit(1) NULL AT=FIXED ST=DISK
592 a5 Tinyint NULL AT=FIXED ST=DISK
593 $PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
594 DROP TABLE test.t1;
595 create table t1 (a int primary key, b int, c int, index bc (b,c))
596 storage disk tablespace ts engine = ndb;
597 alter table t1 algorithm=inplace, drop index bc;
598 alter table t1 algorithm=inplace, add index b (b);
599 alter table t1 algorithm=inplace, drop index b;
600 drop table t1;
601 ALTER TABLESPACE ts
602 DROP DATAFILE './table_space/datafile.dat';
603 DROP TABLESPACE ts;
604 DROP LOGFILE GROUP lg ENGINE=NDB;