1--disable_warnings 2let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`; 3--enable_warnings 4 5--disable_warnings 6DROP TABLE IF EXISTS t4; 7--enable_warnings 8CREATE TABLE t4(c1 TINYBLOB NULL); 9CREATE UNIQUE INDEX i1 ON t4(c1(100)); 10SHOW TABLES; 11--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 12 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 13CREATE TABLE t4(c1 BLOB NULL); 14CREATE UNIQUE INDEX i1 ON t4(c1(100)); 15SHOW TABLES; 16--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 17 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 18CREATE TABLE t4(c1 MEDIUMBLOB NULL); 19CREATE UNIQUE INDEX i1 ON t4(c1(100)); 20SHOW TABLES; 21--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 22 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 23CREATE TABLE t4(c1 LONGBLOB NULL); 24CREATE UNIQUE INDEX i1 ON t4(c1(100)); 25SHOW TABLES; 26--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 27 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 28CREATE TABLE t4(c1 TINYTEXT NULL) charset latin1; 29CREATE UNIQUE INDEX i1 ON t4(c1(100)); 30SHOW TABLES; 31--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 32 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 33CREATE TABLE t4(c1 TEXT NULL); 34CREATE UNIQUE INDEX i1 ON t4(c1(100)); 35SHOW TABLES; 36--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 37 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 38CREATE TABLE t4(c1 MEDIUMTEXT NULL); 39CREATE UNIQUE INDEX i1 ON t4(c1(100)); 40SHOW TABLES; 41--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 42 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 43CREATE TABLE t4(c1 LONGTEXT NULL); 44CREATE UNIQUE INDEX i1 ON t4(c1(100)); 45SHOW TABLES; 46--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 47 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 48CREATE TABLE t4(c1 TINYBLOB NOT NULL); 49CREATE UNIQUE INDEX i1 ON t4(c1(100)); 50SHOW TABLES; 51--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 52 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 53CREATE TABLE t4(c1 BLOB NOT NULL); 54CREATE UNIQUE INDEX i1 ON t4(c1(100)); 55SHOW TABLES; 56--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 57 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 58CREATE TABLE t4(c1 MEDIUMBLOB NOT NULL); 59CREATE UNIQUE INDEX i1 ON t4(c1(100)); 60SHOW TABLES; 61--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 62 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 63CREATE TABLE t4(c1 LONGBLOB NOT NULL); 64CREATE UNIQUE INDEX i1 ON t4(c1(100)); 65SHOW TABLES; 66--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 67 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 68CREATE TABLE t4(c1 TINYTEXT NOT NULL) charset latin1; 69CREATE UNIQUE INDEX i1 ON t4(c1(100)); 70SHOW TABLES; 71--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 72 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 73CREATE TABLE t4(c1 TEXT NOT NULL); 74CREATE UNIQUE INDEX i1 ON t4(c1(100)); 75SHOW TABLES; 76--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 77 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 78CREATE TABLE t4(c1 MEDIUMTEXT NOT NULL); 79CREATE UNIQUE INDEX i1 ON t4(c1(100)); 80SHOW TABLES; 81--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 82 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 83CREATE TABLE t4(c1 LONGTEXT NOT NULL); 84CREATE UNIQUE INDEX i1 ON t4(c1(100)); 85SHOW TABLES; 86--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 87 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES; 88