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 t3; 7--enable_warnings 8CREATE TABLE t3(c1 CHAR(50) NULL); 9CREATE INDEX i1 ON t3(c1(10)); 10SHOW TABLES; 11--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 12 SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; 13CREATE TABLE t3(c1 VARCHAR(50) NULL); 14CREATE INDEX i1 ON t3(c1(10)); 15SHOW TABLES; 16--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 17 SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; 18CREATE TABLE t3(c1 BINARY(50) NULL); 19CREATE INDEX i1 ON t3(c1(10)); 20SHOW TABLES; 21--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 22 SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; 23CREATE TABLE t3(c1 VARBINARY(50) NULL); 24CREATE INDEX i1 ON t3(c1(10)); 25SHOW TABLES; 26--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 27 SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; 28CREATE TABLE t3(c1 CHAR(50) NOT NULL); 29CREATE INDEX i1 ON t3(c1(10)); 30SHOW TABLES; 31--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 32 SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; 33CREATE TABLE t3(c1 VARCHAR(50) NOT NULL); 34CREATE INDEX i1 ON t3(c1(10)); 35SHOW TABLES; 36--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 37 SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; 38CREATE TABLE t3(c1 BINARY(50) NOT NULL); 39CREATE INDEX i1 ON t3(c1(10)); 40SHOW TABLES; 41--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 42 SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; 43CREATE TABLE t3(c1 VARBINARY(50) NOT NULL); 44CREATE INDEX i1 ON t3(c1(10)); 45SHOW TABLES; 46--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 47 SHOW CREATE TABLE t3; DROP TABLE t3; SHOW TABLES; 48 49