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 6SET sql_mode='NO_ENGINE_SUBSTITUTION'; 7DROP TABLE IF EXISTS t1; 8--enable_warnings 9CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT NOT NULL); 10SHOW TABLES; 11--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 12 SHOW CREATE TABLE t1; 13ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 14SHOW TABLES; 15--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 16 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 17CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT NOT NULL); 18SHOW TABLES; 19--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 20 SHOW CREATE TABLE t1; 21ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 22SHOW TABLES; 23--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 24 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 25CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT NOT NULL); 26SHOW TABLES; 27--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 28 SHOW CREATE TABLE t1; 29ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 30SHOW TABLES; 31--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 32 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 33CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT NOT NULL); 34SHOW TABLES; 35--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 36 SHOW CREATE TABLE t1; 37ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 38SHOW TABLES; 39--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 40 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 41CREATE TABLE t1(c1 INT NOT NULL, c2 INT NOT NULL); 42SHOW TABLES; 43--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 44 SHOW CREATE TABLE t1; 45ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 46SHOW TABLES; 47--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 48 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 49CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER NOT NULL); 50SHOW TABLES; 51--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 52 SHOW CREATE TABLE t1; 53ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 54SHOW TABLES; 55--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 56 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 57CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT NOT NULL); 58SHOW TABLES; 59--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 60 SHOW CREATE TABLE t1; 61ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 62SHOW TABLES; 63--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 64 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 65CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL NOT NULL); 66SHOW TABLES; 67--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 68 SHOW CREATE TABLE t1; 69ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 70SHOW TABLES; 71--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 72 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 73CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE NOT NULL); 74SHOW TABLES; 75--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 76 SHOW CREATE TABLE t1; 77ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 78SHOW TABLES; 79--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 80 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 81CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT NOT NULL); 82SHOW TABLES; 83--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 84 SHOW CREATE TABLE t1; 85ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 86SHOW TABLES; 87--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 88 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 89CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL NOT NULL); 90SHOW TABLES; 91--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 92 SHOW CREATE TABLE t1; 93ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 94SHOW TABLES; 95--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 96 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 97CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC NOT NULL); 98SHOW TABLES; 99--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 100 SHOW CREATE TABLE t1; 101ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 102SHOW TABLES; 103--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 104 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 105CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NOT NULL); 106SHOW TABLES; 107--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 108 SHOW CREATE TABLE t1; 109ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 110SHOW TABLES; 111--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 112 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 113CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL); 114SHOW TABLES; 115--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 116 SHOW CREATE TABLE t1; 117ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 118SHOW TABLES; 119--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 120 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 121CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL); 122SHOW TABLES; 123--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 124 SHOW CREATE TABLE t1; 125ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 126SHOW TABLES; 127--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 128 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 129CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL); 130SHOW TABLES; 131--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 132 SHOW CREATE TABLE t1; 133ALTER TABLE t1 ADD PRIMARY KEY (c1,c2); 134SHOW TABLES; 135--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" 136 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES; 137SET sql_mode=default; 138