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 t2; 7--enable_warnings 8CREATE TABLE t2(c1 CHAR(200) NOT NULL); 9SHOW TABLES; 10--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 11 SHOW CREATE TABLE t2; 12ALTER TABLE t2 MODIFY c1 CHAR(200) NULL; 13SHOW TABLES; 14--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 15 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 16CREATE TABLE t2(c1 VARCHAR(200) NOT NULL); 17SHOW TABLES; 18--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 19 SHOW CREATE TABLE t2; 20ALTER TABLE t2 MODIFY c1 VARCHAR(200) NULL; 21SHOW TABLES; 22--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 23 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 24CREATE TABLE t2(c1 BINARY(200) NOT NULL); 25SHOW TABLES; 26--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 27 SHOW CREATE TABLE t2; 28ALTER TABLE t2 MODIFY c1 BINARY(200) NULL; 29SHOW TABLES; 30--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 31 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 32CREATE TABLE t2(c1 VARBINARY(200) NOT NULL); 33SHOW TABLES; 34--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 35 SHOW CREATE TABLE t2; 36ALTER TABLE t2 MODIFY c1 VARBINARY(200) NULL; 37SHOW TABLES; 38--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 39 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 40CREATE TABLE t2(c1 CHAR(200) NOT NULL); 41SHOW TABLES; 42--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 43 SHOW CREATE TABLE t2; 44ALTER TABLE t2 CHANGE c1 c1 CHAR(200) NULL; 45SHOW TABLES; 46--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 47 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 48CREATE TABLE t2(c1 VARCHAR(200) NOT NULL); 49SHOW TABLES; 50--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 51 SHOW CREATE TABLE t2; 52ALTER TABLE t2 CHANGE c1 c1 VARCHAR(200) NULL; 53SHOW TABLES; 54--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 55 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 56CREATE TABLE t2(c1 BINARY(200) NOT NULL); 57SHOW TABLES; 58--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 59 SHOW CREATE TABLE t2; 60ALTER TABLE t2 CHANGE c1 c1 BINARY(200) NULL; 61SHOW TABLES; 62--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 63 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 64CREATE TABLE t2(c1 VARBINARY(200) NOT NULL); 65SHOW TABLES; 66--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 67 SHOW CREATE TABLE t2; 68ALTER TABLE t2 CHANGE c1 c1 VARBINARY(200) NULL; 69SHOW TABLES; 70--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 71 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 72 73