1--disable_warnings 2DROP TABLE IF EXISTS t9; 3--enable_warnings 4CREATE TABLE t9(c1 BIT NOT NULL PRIMARY KEY); 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 t9; 9ALTER TABLE t9 DROP PRIMARY KEY; 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 t9; DROP TABLE t9; SHOW TABLES; 14CREATE TABLE t9(c1 TINYINT NOT NULL PRIMARY KEY); 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 t9; 19ALTER TABLE t9 DROP PRIMARY KEY; 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 t9; DROP TABLE t9; SHOW TABLES; 24CREATE TABLE t9(c1 SMALLINT NOT NULL PRIMARY KEY); 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 t9; 29ALTER TABLE t9 DROP PRIMARY KEY; 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 t9; DROP TABLE t9; SHOW TABLES; 34CREATE TABLE t9(c1 MEDIUMINT NOT NULL PRIMARY KEY); 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 t9; 39ALTER TABLE t9 DROP PRIMARY KEY; 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 t9; DROP TABLE t9; SHOW TABLES; 44CREATE TABLE t9(c1 INT NOT NULL PRIMARY KEY); 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 t9; 49ALTER TABLE t9 DROP PRIMARY KEY; 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 t9; DROP TABLE t9; SHOW TABLES; 54CREATE TABLE t9(c1 INTEGER NOT NULL PRIMARY KEY); 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 t9; 59ALTER TABLE t9 DROP PRIMARY KEY; 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 t9; DROP TABLE t9; SHOW TABLES; 64CREATE TABLE t9(c1 BIGINT NOT NULL PRIMARY KEY); 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 t9; 69ALTER TABLE t9 DROP PRIMARY KEY; 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 t9; DROP TABLE t9; SHOW TABLES; 74CREATE TABLE t9(c1 REAL NOT NULL PRIMARY KEY); 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 t9; 79ALTER TABLE t9 DROP PRIMARY KEY; 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 t9; DROP TABLE t9; SHOW TABLES; 84CREATE TABLE t9(c1 DOUBLE NOT NULL PRIMARY KEY); 85SHOW TABLES; 86let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 87--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 88 SHOW CREATE TABLE t9; 89ALTER TABLE t9 DROP PRIMARY KEY; 90SHOW TABLES; 91let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 92--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 93 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES; 94CREATE TABLE t9(c1 FLOAT NOT NULL PRIMARY KEY); 95SHOW TABLES; 96let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 97--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 98 SHOW CREATE TABLE t9; 99ALTER TABLE t9 DROP PRIMARY KEY; 100SHOW TABLES; 101let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 103 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES; 104CREATE TABLE t9(c1 DECIMAL NOT NULL PRIMARY KEY); 105SHOW TABLES; 106let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 107--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 108 SHOW CREATE TABLE t9; 109ALTER TABLE t9 DROP PRIMARY KEY; 110SHOW TABLES; 111let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 112--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 113 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES; 114CREATE TABLE t9(c1 NUMERIC NOT NULL PRIMARY KEY); 115SHOW TABLES; 116let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 117--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 118 SHOW CREATE TABLE t9; 119ALTER TABLE t9 DROP PRIMARY KEY; 120SHOW TABLES; 121let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 123 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES; 124CREATE TABLE t9(c1 DATE NOT NULL PRIMARY KEY); 125SHOW TABLES; 126let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 127--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 128 SHOW CREATE TABLE t9; 129ALTER TABLE t9 DROP PRIMARY KEY; 130SHOW TABLES; 131let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 132--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 133 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES; 134CREATE TABLE t9(c1 TIME NOT NULL PRIMARY KEY); 135SHOW TABLES; 136let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 137--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 138 SHOW CREATE TABLE t9; 139ALTER TABLE t9 DROP PRIMARY KEY; 140SHOW TABLES; 141let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 143 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES; 144CREATE TABLE t9(c1 TIMESTAMP NOT NULL PRIMARY KEY); 145SHOW TABLES; 146let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 147--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 148 SHOW CREATE TABLE t9; 149ALTER TABLE t9 DROP PRIMARY KEY; 150SHOW TABLES; 151let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 152--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 153 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES; 154CREATE TABLE t9(c1 YEAR NOT NULL PRIMARY KEY); 155SHOW TABLES; 156let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 157--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 158 SHOW CREATE TABLE t9; 159ALTER TABLE t9 DROP PRIMARY KEY; 160SHOW TABLES; 161let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; 162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 163 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES; 164 165