1--disable_warnings 2DROP TABLE IF EXISTS t1; 3--enable_warnings 4CREATE TABLE t1(c1 TINYINT NULL, c2 TINYINT NULL); 5INSERT INTO t1 VALUES(1,2); 6INSERT INTO t1 VALUES(3,4); 7ANALYZE TABLE t1; 8DROP TABLE t1; 9CREATE TABLE t1(c1 SMALLINT NULL, c2 SMALLINT NULL); 10INSERT INTO t1 VALUES(1,2); 11INSERT INTO t1 VALUES(3,4); 12ANALYZE TABLE t1; 13DROP TABLE t1; 14CREATE TABLE t1(c1 MEDIUMINT NULL, c2 MEDIUMINT NULL); 15INSERT INTO t1 VALUES(1,2); 16INSERT INTO t1 VALUES(3,4); 17ANALYZE TABLE t1; 18DROP TABLE t1; 19CREATE TABLE t1(c1 INT NULL, c2 INT NULL); 20INSERT INTO t1 VALUES(1,2); 21INSERT INTO t1 VALUES(3,4); 22ANALYZE TABLE t1; 23DROP TABLE t1; 24CREATE TABLE t1(c1 INTEGER NULL, c2 INTEGER NULL); 25INSERT INTO t1 VALUES(1,2); 26INSERT INTO t1 VALUES(3,4); 27ANALYZE TABLE t1; 28DROP TABLE t1; 29CREATE TABLE t1(c1 BIGINT NULL, c2 BIGINT NULL); 30INSERT INTO t1 VALUES(1,2); 31INSERT INTO t1 VALUES(3,4); 32ANALYZE TABLE t1; 33DROP TABLE t1; 34CREATE TABLE t1(c1 DECIMAL NULL, c2 DECIMAL NULL); 35INSERT INTO t1 VALUES(1,2); 36INSERT INTO t1 VALUES(3,4); 37ANALYZE TABLE t1; 38DROP TABLE t1; 39CREATE TABLE t1(c1 DEC NULL, c2 DEC NULL); 40INSERT INTO t1 VALUES(1,2); 41INSERT INTO t1 VALUES(3,4); 42ANALYZE TABLE t1; 43DROP TABLE t1; 44CREATE TABLE t1(c1 FIXED NULL, c2 FIXED NULL); 45INSERT INTO t1 VALUES(1,2); 46INSERT INTO t1 VALUES(3,4); 47ANALYZE TABLE t1; 48DROP TABLE t1; 49CREATE TABLE t1(c1 NUMERIC NULL, c2 NUMERIC NULL); 50INSERT INTO t1 VALUES(1,2); 51INSERT INTO t1 VALUES(3,4); 52ANALYZE TABLE t1; 53DROP TABLE t1; 54CREATE TABLE t1(c1 DOUBLE NULL, c2 DOUBLE NULL); 55INSERT INTO t1 VALUES(1,2); 56INSERT INTO t1 VALUES(3,4); 57ANALYZE TABLE t1; 58DROP TABLE t1; 59CREATE TABLE t1(c1 REAL NULL, c2 REAL NULL); 60INSERT INTO t1 VALUES(1,2); 61INSERT INTO t1 VALUES(3,4); 62ANALYZE TABLE t1; 63DROP TABLE t1; 64CREATE TABLE t1(c1 DOUBLE PRECISION NULL, c2 DOUBLE PRECISION NULL); 65INSERT INTO t1 VALUES(1,2); 66INSERT INTO t1 VALUES(3,4); 67ANALYZE TABLE t1; 68DROP TABLE t1; 69CREATE TABLE t1(c1 FLOAT NULL, c2 FLOAT NULL); 70INSERT INTO t1 VALUES(1,2); 71INSERT INTO t1 VALUES(3,4); 72ANALYZE TABLE t1; 73DROP TABLE t1; 74 75