Debian Codegraph @

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

raw
1 CREATE LOGFILE GROUP lg1
2 ADD UNDOFILE 'undofile.dat'
3 INITIAL_SIZE 1M
4 UNDO_BUFFER_SIZE = 1M
5 ENGINE=NDB;
6 CREATE TABLESPACE ts1
7 ADD DATAFILE 'datafile.dat'
8 USE LOGFILE GROUP lg1
9 INITIAL_SIZE 8M
10 EXTENT_SIZE 256k
11 ENGINE NDB;
12 create table t1 (a int column_format DYNAMIC STORAGE DISK) TABLESPACE ts1 engine NDB CHARACTER SET latin1;
13 Warnings:
14 Warning 1478 DYNAMIC column a with STORAGE DISK is not supported, column will become FIXED
15 show create table t1;
16 Table Create Table
17 t1 CREATE TABLE `t1` (
18 `a` int /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL
19 ) /*!50100 TABLESPACE `ts1` */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
20 Attributes:
21 a Int NULL AT=FIXED ST=DISK
22 $PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
23 drop table t1;
24 create table t1 (a int column_format DYNAMIC,
25 a1 int column_format FIXED,
26 b int NOT NULL column_format DYNAMIC,
27 b1 int NOT NULL column_format FIXED storage DISK,
28 c VARCHAR(100) column_format FIXED,
29 c1 VARCHAR(100) column_format DYNAMIC storage memory,
30 d VARCHAR(100) NOT NULL column_format FIXED,
31 d1 VARCHAR(100) NOT NULL column_format DYNAMIC,
32 e CHAR(100) column_format FIXED,
33 e1 CHAR(100) column_format DYNAMIC,
34 f CHAR(100) NOT NULL column_format FIXED,
35 f1 char(100) NOT NULL column_format DYNAMIC storage DISK,
36 index (b)) TABLESPACE ts1 engine NDB CHARACTER SET latin1;
37 Warnings:
38 Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED
39 insert into t1 (b, b1, d,d1,f,f1) values
40 (1,1,"1","1","1","1"),
41 (2,2,"2","2","2","2"),
42 (3,3,"3","3","3","3");
43 alter table t1 change column a a int column_format FIXED;
44 Warnings:
45 Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED
46 show create table t1;
47 Table Create Table
48 t1 CREATE TABLE `t1` (
49 `a` int /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
50 `a1` int /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
51 `b` int NOT NULL /*!50606 COLUMN_FORMAT DYNAMIC */,
52 `b1` int NOT NULL /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT FIXED */,
53 `c` varchar(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
54 `c1` varchar(100) /*!50606 STORAGE MEMORY */ /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
55 `d` varchar(100) NOT NULL /*!50606 COLUMN_FORMAT FIXED */,
56 `d1` varchar(100) NOT NULL /*!50606 COLUMN_FORMAT DYNAMIC */,
57 `e` char(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
58 `e1` char(100) /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
59 `f` char(100) NOT NULL /*!50606 COLUMN_FORMAT FIXED */,
60 `f1` char(100) NOT NULL /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT DYNAMIC */,
61 KEY `b` (`b`)
62 ) /*!50100 TABLESPACE `ts1` */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
63 alter table t1 change column a a int storage disk;
64 Warnings:
65 Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED
66 show create table t1;
67 Table Create Table
68 t1 CREATE TABLE `t1` (
69 `a` int /*!50606 STORAGE DISK */ DEFAULT NULL,
70 `a1` int /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
71 `b` int NOT NULL /*!50606 COLUMN_FORMAT DYNAMIC */,
72 `b1` int NOT NULL /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT FIXED */,
73 `c` varchar(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
74 `c1` varchar(100) /*!50606 STORAGE MEMORY */ /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
75 `d` varchar(100) NOT NULL /*!50606 COLUMN_FORMAT FIXED */,
76 `d1` varchar(100) NOT NULL /*!50606 COLUMN_FORMAT DYNAMIC */,
77 `e` char(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
78 `e1` char(100) /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
79 `f` char(100) NOT NULL /*!50606 COLUMN_FORMAT FIXED */,
80 `f1` char(100) NOT NULL /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT DYNAMIC */,
81 KEY `b` (`b`)
82 ) /*!50100 TABLESPACE `ts1` */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
83 Attributes:
84 a Int NULL AT=FIXED ST=DISK
85 a1 Int NULL AT=FIXED ST=MEMORY
86 b Int NOT NULL AT=FIXED ST=MEMORY DYNAMIC
87 b1 Int NOT NULL AT=FIXED ST=DISK
88 c Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY
89 c1 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC
90 d Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY
91 d1 Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY DYNAMIC
92 e Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
93 e1 Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY DYNAMIC
94 f Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY
95 f1 Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=DISK
96 $PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
97 alter table t1 change column a a int storage memory;
98 Warnings:
99 Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED
100 show create table t1;
101 Table Create Table
102 t1 CREATE TABLE `t1` (
103 `a` int /*!50606 STORAGE MEMORY */ DEFAULT NULL,
104 `a1` int /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
105 `b` int NOT NULL /*!50606 COLUMN_FORMAT DYNAMIC */,
106 `b1` int NOT NULL /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT FIXED */,
107 `c` varchar(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
108 `c1` varchar(100) /*!50606 STORAGE MEMORY */ /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
109 `d` varchar(100) NOT NULL /*!50606 COLUMN_FORMAT FIXED */,
110 `d1` varchar(100) NOT NULL /*!50606 COLUMN_FORMAT DYNAMIC */,
111 `e` char(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
112 `e1` char(100) /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
113 `f` char(100) NOT NULL /*!50606 COLUMN_FORMAT FIXED */,
114 `f1` char(100) NOT NULL /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT DYNAMIC */,
115 KEY `b` (`b`)
116 ) /*!50100 TABLESPACE `ts1` */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
117 Attributes:
118 a Int NULL AT=FIXED ST=MEMORY
119 a1 Int NULL AT=FIXED ST=MEMORY
120 b Int NOT NULL AT=FIXED ST=MEMORY DYNAMIC
121 b1 Int NOT NULL AT=FIXED ST=DISK
122 c Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY
123 c1 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC
124 d Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY
125 d1 Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY DYNAMIC
126 e Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
127 e1 Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY DYNAMIC
128 f Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY
129 f1 Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=DISK
130 $PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
131 alter table t1 algorithm=inplace, change column a1 a1 int column_format FIXED NOT NULL;
132 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Altering if field is nullable is not supported. Try ALGORITHM=COPY.
133 alter table t1 algorithm=inplace, change column b b int NOT NULL storage memory, add index b_i(b);
134 Warnings:
135 Warning 1831 Duplicate index 'b_i' defined on the table 'test.t1'. This is deprecated and will be disallowed in a future release.
136 alter table t1 algorithm=inplace, change column b b int NOT NULL storage memory, add index b1_i(b1);
137 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Add/drop index is not supported for disk stored column. Try ALGORITHM=COPY.
138 alter table t1 change column b b int NOT NULL storage memory;
139 alter table t1 add column a2 int column_format FIXED;
140 Warnings:
141 Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED
142 show create table t1;
143 Table Create Table
144 t1 CREATE TABLE `t1` (
145 `a` int /*!50606 STORAGE MEMORY */ DEFAULT NULL,
146 `a1` int /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
147 `b` int NOT NULL /*!50606 STORAGE MEMORY */,
148 `b1` int NOT NULL /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT FIXED */,
149 `c` varchar(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
150 `c1` varchar(100) /*!50606 STORAGE MEMORY */ /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
151 `d` varchar(100) NOT NULL /*!50606 COLUMN_FORMAT FIXED */,
152 `d1` varchar(100) NOT NULL /*!50606 COLUMN_FORMAT DYNAMIC */,
153 `e` char(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
154 `e1` char(100) /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
155 `f` char(100) NOT NULL /*!50606 COLUMN_FORMAT FIXED */,
156 `f1` char(100) NOT NULL /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT DYNAMIC */,
157 `a2` int /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
158 KEY `b` (`b`),
159 KEY `b_i` (`b`)
160 ) /*!50100 TABLESPACE `ts1` */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
161 Attributes:
162 a Int NULL AT=FIXED ST=MEMORY
163 a1 Int NULL AT=FIXED ST=MEMORY
164 b Int NOT NULL AT=FIXED ST=MEMORY
165 b1 Int NOT NULL AT=FIXED ST=DISK
166 c Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY
167 c1 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC
168 d Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY
169 d1 Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY DYNAMIC
170 e Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
171 e1 Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY DYNAMIC
172 f Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY
173 f1 Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=DISK
174 a2 Int NULL AT=FIXED ST=MEMORY
175 $PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
176 alter table t1 add column c2 VARCHAR(100) column_format DYNAMIC;
177 Warnings:
178 Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED
179 show create table t1;
180 Table Create Table
181 t1 CREATE TABLE `t1` (
182 `a` int /*!50606 STORAGE MEMORY */ DEFAULT NULL,
183 `a1` int /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
184 `b` int NOT NULL /*!50606 STORAGE MEMORY */,
185 `b1` int NOT NULL /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT FIXED */,
186 `c` varchar(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
187 `c1` varchar(100) /*!50606 STORAGE MEMORY */ /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
188 `d` varchar(100) NOT NULL /*!50606 COLUMN_FORMAT FIXED */,
189 `d1` varchar(100) NOT NULL /*!50606 COLUMN_FORMAT DYNAMIC */,
190 `e` char(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
191 `e1` char(100) /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
192 `f` char(100) NOT NULL /*!50606 COLUMN_FORMAT FIXED */,
193 `f1` char(100) NOT NULL /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT DYNAMIC */,
194 `a2` int /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
195 `c2` varchar(100) /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
196 KEY `b` (`b`),
197 KEY `b_i` (`b`)
198 ) /*!50100 TABLESPACE `ts1` */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
199 Attributes:
200 a Int NULL AT=FIXED ST=MEMORY
201 a1 Int NULL AT=FIXED ST=MEMORY
202 b Int NOT NULL AT=FIXED ST=MEMORY
203 b1 Int NOT NULL AT=FIXED ST=DISK
204 c Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY
205 c1 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC
206 d Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY
207 d1 Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY DYNAMIC
208 e Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
209 e1 Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY DYNAMIC
210 f Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY
211 f1 Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=DISK
212 a2 Int NULL AT=FIXED ST=MEMORY
213 c2 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC
214 $PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
215 alter table t1 add column c3 VARCHAR(100) column_format FIXED;
216 Warnings:
217 Warning 1478 DYNAMIC column f1 with STORAGE DISK is not supported, column will become FIXED
218 show create table t1;
219 Table Create Table
220 t1 CREATE TABLE `t1` (
221 `a` int /*!50606 STORAGE MEMORY */ DEFAULT NULL,
222 `a1` int /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
223 `b` int NOT NULL /*!50606 STORAGE MEMORY */,
224 `b1` int NOT NULL /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT FIXED */,
225 `c` varchar(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
226 `c1` varchar(100) /*!50606 STORAGE MEMORY */ /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
227 `d` varchar(100) NOT NULL /*!50606 COLUMN_FORMAT FIXED */,
228 `d1` varchar(100) NOT NULL /*!50606 COLUMN_FORMAT DYNAMIC */,
229 `e` char(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
230 `e1` char(100) /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
231 `f` char(100) NOT NULL /*!50606 COLUMN_FORMAT FIXED */,
232 `f1` char(100) NOT NULL /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT DYNAMIC */,
233 `a2` int /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
234 `c2` varchar(100) /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL,
235 `c3` varchar(100) /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
236 KEY `b` (`b`),
237 KEY `b_i` (`b`)
238 ) /*!50100 TABLESPACE `ts1` */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
239 Attributes:
240 a Int NULL AT=FIXED ST=MEMORY
241 a1 Int NULL AT=FIXED ST=MEMORY
242 b Int NOT NULL AT=FIXED ST=MEMORY
243 b1 Int NOT NULL AT=FIXED ST=DISK
244 c Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY
245 c1 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC
246 d Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY
247 d1 Varchar(100;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY DYNAMIC
248 e Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY
249 e1 Char(100;latin1_swedish_ci) NULL AT=FIXED ST=MEMORY DYNAMIC
250 f Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=MEMORY
251 f1 Char(100;latin1_swedish_ci) NOT NULL AT=FIXED ST=DISK
252 a2 Int NULL AT=FIXED ST=MEMORY
253 c2 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY DYNAMIC
254 c3 Varchar(100;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY
255 $PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
256 drop table t1;
257 create table t1 (a int storage disk column_format FIXED) TABLESPACE ts1 engine NDB CHARACTER SET latin1;
258 alter table t1 change column a a int storage memory column_format DYNAMIC;
259 show create table t1;
260 Table Create Table
261 t1 CREATE TABLE `t1` (
262 `a` int /*!50606 STORAGE MEMORY */ /*!50606 COLUMN_FORMAT DYNAMIC */ DEFAULT NULL
263 ) /*!50100 TABLESPACE `ts1` */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
264 Attributes:
265 a Int NULL AT=FIXED ST=MEMORY DYNAMIC
266 $PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
267 drop table t1;
268 create table t1 (column_format int storage disk column_format FIXED, storage int storage disk column_format FIXED) TABLESPACE ts1 engine NDB CHARACTER SET latin1;
269 show create table t1;
270 Table Create Table
271 t1 CREATE TABLE `t1` (
272 `column_format` int /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL,
273 `storage` int /*!50606 STORAGE DISK */ /*!50606 COLUMN_FORMAT FIXED */ DEFAULT NULL
274 ) /*!50100 TABLESPACE `ts1` */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
275 Attributes:
276 column_format Int NULL AT=FIXED ST=DISK
277 storage Int NULL AT=FIXED ST=DISK
278 $PK Bigunsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
279 drop table t1;
280 ALTER TABLESPACE ts1
281 DROP DATAFILE 'datafile.dat';
282 drop tablespace ts1;
283 drop logfile group lg1
284 engine ndb;
285 CREATE TABLE t1 (
286 pk1 INT NOT NULL auto_increment,
287 c00 int not null column_format dynamic,
288 c01 int not null column_format dynamic,
289 c02 int not null column_format dynamic,
290 c03 int not null column_format dynamic,
291 c04 int not null column_format dynamic,
292 c05 int not null column_format dynamic,
293 c06 int not null column_format dynamic,
294 c07 int not null column_format dynamic,
295 c08 int not null column_format dynamic,
296 c09 int not null column_format dynamic,
297 c10 int not null column_format dynamic,
298 c11 int not null column_format dynamic,
299 c12 int not null column_format dynamic,
300 c13 int not null column_format dynamic,
301 c14 int not null column_format dynamic,
302 c15 int not null column_format dynamic,
303 c16 int not null column_format dynamic,
304 c17 int not null column_format dynamic,
305 c18 int not null column_format dynamic,
306 c19 int not null column_format dynamic,
307 primary key(pk1)
308 ) ENGINE=ndbcluster;
309 insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21);
310 insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21);
311 insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21);
312 insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21);
313 insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21);
314 insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21);
315 insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21);
316 insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21);
317 insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21);
318 insert into t1 values(null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21);
319 select * from t1 order by 1;
320 pk1 c00 c01 c02 c03 c04 c05 c06 c07 c08 c09 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19
321 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
322 2 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
323 3 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
324 4 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
325 5 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
326 6 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
327 7 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
328 8 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
329 9 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
330 10 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
331 delete from t1;
332 drop table t1;