1--disable_warnings 2let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`; 3--enable_warnings 4 5--disable_warnings 6DROP TABLE IF EXISTS t1; 7--enable_warnings 8SET sql_mode='NO_ENGINE_SUBSTITUTION'; 9CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT); 10SHOW TABLES; 11--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 12 SHOW CREATE TABLE t1; 13ALTER TABLE t1 DROP c2; 14--error 1090 15ALTER TABLE t1 DROP c1; 16--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 17 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 18CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT); 19SHOW TABLES; 20--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 21 SHOW CREATE TABLE t1; 22ALTER TABLE t1 DROP c2; 23--error 1090 24ALTER TABLE t1 DROP c1; 25--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 26 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 27CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT); 28SHOW TABLES; 29--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 30 SHOW CREATE TABLE t1; 31ALTER TABLE t1 DROP c2; 32--error 1090 33ALTER TABLE t1 DROP c1; 34--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 35 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 36CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT); 37SHOW TABLES; 38--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 39 SHOW CREATE TABLE t1; 40ALTER TABLE t1 DROP c2; 41--error 1090 42ALTER TABLE t1 DROP c1; 43--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 44 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 45CREATE TABLE t1(c1 INT NOT NULL, c2 INT); 46SHOW TABLES; 47--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 48 SHOW CREATE TABLE t1; 49ALTER TABLE t1 DROP c2; 50--error 1090 51ALTER TABLE t1 DROP c1; 52--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 53 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 54CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER); 55SHOW TABLES; 56--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 57 SHOW CREATE TABLE t1; 58ALTER TABLE t1 DROP c2; 59--error 1090 60ALTER TABLE t1 DROP c1; 61--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 62 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 63CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT); 64SHOW TABLES; 65--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 66 SHOW CREATE TABLE t1; 67ALTER TABLE t1 DROP c2; 68--error 1090 69ALTER TABLE t1 DROP c1; 70--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 71 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 72CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL); 73SHOW TABLES; 74--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 75 SHOW CREATE TABLE t1; 76ALTER TABLE t1 DROP c2; 77--error 1090 78ALTER TABLE t1 DROP c1; 79--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 80 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 81CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE); 82SHOW TABLES; 83--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 84 SHOW CREATE TABLE t1; 85ALTER TABLE t1 DROP c2; 86--error 1090 87ALTER TABLE t1 DROP c1; 88--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 89 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 90CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT); 91SHOW TABLES; 92--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 93 SHOW CREATE TABLE t1; 94ALTER TABLE t1 DROP c2; 95--error 1090 96ALTER TABLE t1 DROP c1; 97--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 98 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 99CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL); 100SHOW TABLES; 101--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 102 SHOW CREATE TABLE t1; 103ALTER TABLE t1 DROP c2; 104--error 1090 105ALTER TABLE t1 DROP c1; 106--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 107 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 108CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC); 109SHOW TABLES; 110--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 111 SHOW CREATE TABLE t1; 112ALTER TABLE t1 DROP c2; 113--error 1090 114ALTER TABLE t1 DROP c1; 115--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 116 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 117CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE); 118SHOW TABLES; 119--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 120 SHOW CREATE TABLE t1; 121ALTER TABLE t1 DROP c2; 122--error 1090 123ALTER TABLE t1 DROP c1; 124--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 125 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 126CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME); 127SHOW TABLES; 128--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 129 SHOW CREATE TABLE t1; 130ALTER TABLE t1 DROP c2; 131--error 1090 132ALTER TABLE t1 DROP c1; 133--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 134 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 135CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP); 136SHOW TABLES; 137--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 138 SHOW CREATE TABLE t1; 139ALTER TABLE t1 DROP c2; 140--error 1090 141ALTER TABLE t1 DROP c1; 142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 143 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 144CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR); 145SHOW TABLES; 146--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 147 SHOW CREATE TABLE t1; 148ALTER TABLE t1 DROP c2; 149--error 1090 150ALTER TABLE t1 DROP c1; 151--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 152 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 153CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT); 154SHOW TABLES; 155--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 156 SHOW CREATE TABLE t1; 157ALTER TABLE t1 DROP COLUMN c2; 158--error 1090 159ALTER TABLE t1 DROP COLUMN c1; 160--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 161 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 162CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT); 163SHOW TABLES; 164--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 165 SHOW CREATE TABLE t1; 166ALTER TABLE t1 DROP COLUMN c2; 167--error 1090 168ALTER TABLE t1 DROP COLUMN c1; 169--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 170 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 171CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT); 172SHOW TABLES; 173--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 174 SHOW CREATE TABLE t1; 175ALTER TABLE t1 DROP COLUMN c2; 176--error 1090 177ALTER TABLE t1 DROP COLUMN c1; 178--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 179 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 180CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT); 181SHOW TABLES; 182--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 183 SHOW CREATE TABLE t1; 184ALTER TABLE t1 DROP COLUMN c2; 185--error 1090 186ALTER TABLE t1 DROP COLUMN c1; 187--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 188 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 189CREATE TABLE t1(c1 INT NOT NULL, c2 INT); 190SHOW TABLES; 191--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 192 SHOW CREATE TABLE t1; 193ALTER TABLE t1 DROP COLUMN c2; 194--error 1090 195ALTER TABLE t1 DROP COLUMN c1; 196--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 197 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 198CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER); 199SHOW TABLES; 200--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 201 SHOW CREATE TABLE t1; 202ALTER TABLE t1 DROP COLUMN c2; 203--error 1090 204ALTER TABLE t1 DROP COLUMN c1; 205--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 206 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 207CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT); 208SHOW TABLES; 209--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 210 SHOW CREATE TABLE t1; 211ALTER TABLE t1 DROP COLUMN c2; 212--error 1090 213ALTER TABLE t1 DROP COLUMN c1; 214--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 215 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 216CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL); 217SHOW TABLES; 218--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 219 SHOW CREATE TABLE t1; 220ALTER TABLE t1 DROP COLUMN c2; 221--error 1090 222ALTER TABLE t1 DROP COLUMN c1; 223--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 224 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 225CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE); 226SHOW TABLES; 227--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 228 SHOW CREATE TABLE t1; 229ALTER TABLE t1 DROP COLUMN c2; 230--error 1090 231ALTER TABLE t1 DROP COLUMN c1; 232--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 233 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 234CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT); 235SHOW TABLES; 236--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 237 SHOW CREATE TABLE t1; 238ALTER TABLE t1 DROP COLUMN c2; 239--error 1090 240ALTER TABLE t1 DROP COLUMN c1; 241--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 242 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 243CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL); 244SHOW TABLES; 245--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 246 SHOW CREATE TABLE t1; 247ALTER TABLE t1 DROP COLUMN c2; 248--error 1090 249ALTER TABLE t1 DROP COLUMN c1; 250--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 251 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 252CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC); 253SHOW TABLES; 254--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 255 SHOW CREATE TABLE t1; 256ALTER TABLE t1 DROP COLUMN c2; 257--error 1090 258ALTER TABLE t1 DROP COLUMN c1; 259--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 260 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 261CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE); 262SHOW TABLES; 263--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 264 SHOW CREATE TABLE t1; 265ALTER TABLE t1 DROP COLUMN c2; 266--error 1090 267ALTER TABLE t1 DROP COLUMN c1; 268--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 269 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 270CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME); 271SHOW TABLES; 272--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 273 SHOW CREATE TABLE t1; 274ALTER TABLE t1 DROP COLUMN c2; 275--error 1090 276ALTER TABLE t1 DROP COLUMN c1; 277--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 278 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 279CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP); 280SHOW TABLES; 281--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 282 SHOW CREATE TABLE t1; 283ALTER TABLE t1 DROP COLUMN c2; 284--error 1090 285ALTER TABLE t1 DROP COLUMN c1; 286--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 287 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 288CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR); 289SHOW TABLES; 290--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 291 SHOW CREATE TABLE t1; 292ALTER TABLE t1 DROP COLUMN c2; 293--error 1090 294ALTER TABLE t1 DROP COLUMN c1; 295--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 296 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 297SET sql_mode=default; 298