| Quellcodebibliothek Statistik Leitseite products/Sources/formale Sprachen/C/MariaDB/mysql-test/suite/engines/funcs/t/ (MariaDB Server Version 8.1-8.4©) Datei vom 1.9.2026 mit Größe 648 kB |
|
Quellcode-Bibliothek ta_add_column.test Sprache: unbekannt |
|
|
Spracherkennung für: .test vermutete Sprache: SQL {SQL[242] Lisp[77] Masm[77]} [Methode: maximale Elemente, drei Dimensionen] --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1(c1 BIT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYINT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 SMALLINT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMINT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INTEGER NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BIGINT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 REAL NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DOUBLE NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 FLOAT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DECIMAL NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 NUMERIC NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DATE NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TIME NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TIMESTAMP NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 YEAR NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYBLOB NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BLOB NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMBLOB NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 LONGBLOB NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYTEXT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TEXT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMTEXT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 LONGTEXT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BIT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYINT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 SMALLINT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMINT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INTEGER NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BIGINT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 REAL NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DOUBLE NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 FLOAT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DECIMAL NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 NUMERIC NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DATE NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TIME NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TIMESTAMP NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 YEAR NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYBLOB NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BLOB NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMBLOB NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 LONGBLOB NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYTEXT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TEXT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMTEXT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 LONGTEXT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 BIT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BIT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYINT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 SMALLINT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMINT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INTEGER NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BIGINT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 REAL NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DOUBLE NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 FLOAT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DECIMAL NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 NUMERIC NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DATE NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TIME NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TIMESTAMP NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 YEAR NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYBLOB NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BLOB NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMBLOB NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 LONGBLOB NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYTEXT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TEXT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMTEXT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 LONGTEXT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BIT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYINT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 SMALLINT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMINT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INTEGER NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BIGINT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 REAL NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DOUBLE NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 FLOAT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DECIMAL NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 NUMERIC NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DATE NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TIME NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TIMESTAMP NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 YEAR NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYBLOB NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BLOB NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMBLOB NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 LONGBLOB NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYTEXT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TEXT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMTEXT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 LONGTEXT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 TINYINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BIT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYINT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 SMALLINT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMINT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 INTEGER NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BIGINT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 REAL NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DOUBLE NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 FLOAT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DECIMAL NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 NUMERIC NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 DATE NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TIME NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TIMESTAMP NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 YEAR NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYBLOB NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BLOB NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMBLOB NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 LONGBLOB NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYTEXT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TEXT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 MEDIUMTEXT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 LONGTEXT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 BIT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; CREATE TABLE t1(c1 TINYINT NOT NULL); SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; ALTER TABLE t1 ADD c2 SMALLINT NOT NULL; SHOW TABLES; let $ENGINE=`select variable_value from information_schema.global_variables where vari |