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