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 t6,t7; 7--enable_warnings 8CREATE TABLE t6(c1 REAL(1,0) NULL); 9CREATE INDEX i1 ON t6(c1); 10SHOW TABLES; 11--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 12 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES; 13CREATE TABLE t7(c1 REAL(5,4) NULL); 14CREATE INDEX i1 ON t7(c1); 15SHOW TABLES; 16--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 17 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES; 18CREATE TABLE t6(c1 DOUBLE(1,0) NULL); 19CREATE INDEX i1 ON t6(c1); 20SHOW TABLES; 21--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 22 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES; 23CREATE TABLE t7(c1 DOUBLE(5,4) NULL); 24CREATE INDEX i1 ON t7(c1); 25SHOW TABLES; 26--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 27 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES; 28CREATE TABLE t6(c1 FLOAT(1,0) NULL); 29CREATE INDEX i1 ON t6(c1); 30SHOW TABLES; 31--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 32 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES; 33CREATE TABLE t7(c1 FLOAT(5,4) NULL); 34CREATE INDEX i1 ON t7(c1); 35SHOW TABLES; 36--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 37 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES; 38CREATE TABLE t6(c1 DECIMAL(1,0) NULL); 39CREATE INDEX i1 ON t6(c1); 40SHOW TABLES; 41--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 42 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES; 43CREATE TABLE t7(c1 DECIMAL(5,4) NULL); 44CREATE INDEX i1 ON t7(c1); 45SHOW TABLES; 46--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 47 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES; 48CREATE TABLE t6(c1 NUMERIC(1,0) NULL); 49CREATE INDEX i1 ON t6(c1); 50SHOW TABLES; 51--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 52 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES; 53CREATE TABLE t7(c1 NUMERIC(5,4) NULL); 54CREATE INDEX i1 ON t7(c1); 55SHOW TABLES; 56--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 57 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES; 58CREATE TABLE t6(c1 REAL(1,0) NOT NULL); 59CREATE INDEX i1 ON t6(c1); 60SHOW TABLES; 61--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 62 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES; 63CREATE TABLE t7(c1 REAL(5,4) NOT NULL); 64CREATE INDEX i1 ON t7(c1); 65SHOW TABLES; 66--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 67 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES; 68CREATE TABLE t6(c1 DOUBLE(1,0) NOT NULL); 69CREATE INDEX i1 ON t6(c1); 70SHOW TABLES; 71--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 72 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES; 73CREATE TABLE t7(c1 DOUBLE(5,4) NOT NULL); 74CREATE INDEX i1 ON t7(c1); 75SHOW TABLES; 76--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 77 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES; 78CREATE TABLE t6(c1 FLOAT(1,0) NOT NULL); 79CREATE INDEX i1 ON t6(c1); 80SHOW TABLES; 81--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 82 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES; 83CREATE TABLE t7(c1 FLOAT(5,4) NOT NULL); 84CREATE INDEX i1 ON t7(c1); 85SHOW TABLES; 86--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 87 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES; 88CREATE TABLE t6(c1 DECIMAL(1,0) NOT NULL); 89CREATE INDEX i1 ON t6(c1); 90SHOW TABLES; 91--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 92 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES; 93CREATE TABLE t7(c1 DECIMAL(5,4) NOT NULL); 94CREATE INDEX i1 ON t7(c1); 95SHOW TABLES; 96--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 97 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES; 98CREATE TABLE t6(c1 NUMERIC(1,0) NOT NULL); 99CREATE INDEX i1 ON t6(c1); 100SHOW TABLES; 101--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 102 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES; 103CREATE TABLE t7(c1 NUMERIC(5,4) NOT NULL); 104CREATE INDEX i1 ON t7(c1); 105SHOW TABLES; 106--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 107 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES; 108 109