1--disable_warnings 2DROP TABLE IF EXISTS t1; 3--enable_warnings 4CREATE TABLE t1(c1 CHAR(100) NULL); 5SHOW TABLES; 6let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 7--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 8 SHOW CREATE TABLE t1; 9ALTER TABLE t1 MODIFY c1 CHAR(100) NOT NULL; 10SHOW TABLES; 11let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 12--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 13 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 14CREATE TABLE t1(c1 VARCHAR(100) NULL); 15SHOW TABLES; 16let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 17--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 18 SHOW CREATE TABLE t1; 19ALTER TABLE t1 MODIFY c1 VARCHAR(100) NOT NULL; 20SHOW TABLES; 21let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 22--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 23 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 24CREATE TABLE t1(c1 BINARY(100) NULL); 25SHOW TABLES; 26let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 27--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 28 SHOW CREATE TABLE t1; 29ALTER TABLE t1 MODIFY c1 BINARY(100) NOT NULL; 30SHOW TABLES; 31let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 32--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 33 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 34CREATE TABLE t1(c1 VARBINARY(100) NULL); 35SHOW TABLES; 36let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 37--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 38 SHOW CREATE TABLE t1; 39ALTER TABLE t1 MODIFY c1 VARBINARY(100) NOT NULL; 40SHOW TABLES; 41let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 42--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 43 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 44CREATE TABLE t1(c1 CHAR(100) NULL); 45SHOW TABLES; 46let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 47--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 48 SHOW CREATE TABLE t1; 49ALTER TABLE t1 CHANGE c1 c1 CHAR(100) NOT NULL; 50SHOW TABLES; 51let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 52--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 53 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 54CREATE TABLE t1(c1 VARCHAR(100) NULL); 55SHOW TABLES; 56let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 57--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 58 SHOW CREATE TABLE t1; 59ALTER TABLE t1 CHANGE c1 c1 VARCHAR(100) NOT NULL; 60SHOW TABLES; 61let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 62--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 63 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 64CREATE TABLE t1(c1 BINARY(100) NULL); 65SHOW TABLES; 66let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 67--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 68 SHOW CREATE TABLE t1; 69ALTER TABLE t1 CHANGE c1 c1 BINARY(100) NOT NULL; 70SHOW TABLES; 71let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 72--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 73 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 74CREATE TABLE t1(c1 VARBINARY(100) NULL); 75SHOW TABLES; 76let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 77--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 78 SHOW CREATE TABLE t1; 79ALTER TABLE t1 CHANGE c1 c1 VARBINARY(100) NOT NULL; 80SHOW TABLES; 81let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 82--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 83 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 84 85