1--disable_warnings 2DROP TABLE IF EXISTS t1; 3--enable_warnings 4CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 5INSERT INTO t1 (c1) VALUES(10); 6INSERT INTO t1 (c1) VALUES(11); 7INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 8--sorted_result 9SELECT * FROM t1; 10DROP TABLE t1; 11CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 12INSERT INTO t1 (c1) VALUES(10); 13INSERT INTO t1 (c1) VALUES(11); 14INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 15--sorted_result 16SELECT * FROM t1; 17DROP TABLE t1; 18CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 19INSERT INTO t1 (c1) VALUES(10); 20INSERT INTO t1 (c1) VALUES(11); 21INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 22--sorted_result 23SELECT * FROM t1; 24DROP TABLE t1; 25CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 26INSERT INTO t1 (c1) VALUES(10); 27INSERT INTO t1 (c1) VALUES(11); 28INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 29--sorted_result 30SELECT * FROM t1; 31DROP TABLE t1; 32CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 33INSERT INTO t1 (c1) VALUES(10); 34INSERT INTO t1 (c1) VALUES(11); 35INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 36--sorted_result 37SELECT * FROM t1; 38DROP TABLE t1; 39CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 40INSERT INTO t1 (c1) VALUES(10); 41INSERT INTO t1 (c1) VALUES(11); 42INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 43--sorted_result 44SELECT * FROM t1; 45DROP TABLE t1; 46CREATE TABLE t1(c1 DECIMAL NOT NULL PRIMARY KEY); 47INSERT INTO t1 (c1) VALUES(10); 48INSERT INTO t1 (c1) VALUES(11); 49INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 50--sorted_result 51SELECT * FROM t1; 52DROP TABLE t1; 53CREATE TABLE t1(c1 DEC NOT NULL PRIMARY KEY); 54INSERT INTO t1 (c1) VALUES(10); 55INSERT INTO t1 (c1) VALUES(11); 56INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 57--sorted_result 58SELECT * FROM t1; 59DROP TABLE t1; 60CREATE TABLE t1(c1 FIXED NOT NULL PRIMARY KEY); 61INSERT INTO t1 (c1) VALUES(10); 62INSERT INTO t1 (c1) VALUES(11); 63INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 64--sorted_result 65SELECT * FROM t1; 66DROP TABLE t1; 67CREATE TABLE t1(c1 NUMERIC NOT NULL PRIMARY KEY); 68INSERT INTO t1 (c1) VALUES(10); 69INSERT INTO t1 (c1) VALUES(11); 70INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 71--sorted_result 72SELECT * FROM t1; 73DROP TABLE t1; 74CREATE TABLE t1(c1 DOUBLE NOT NULL PRIMARY KEY); 75INSERT INTO t1 (c1) VALUES(10); 76INSERT INTO t1 (c1) VALUES(11); 77INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 78--sorted_result 79SELECT * FROM t1; 80DROP TABLE t1; 81CREATE TABLE t1(c1 REAL NOT NULL PRIMARY KEY); 82INSERT INTO t1 (c1) VALUES(10); 83INSERT INTO t1 (c1) VALUES(11); 84INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 85--sorted_result 86SELECT * FROM t1; 87DROP TABLE t1; 88CREATE TABLE t1(c1 DOUBLE PRECISION NOT NULL PRIMARY KEY); 89INSERT INTO t1 (c1) VALUES(10); 90INSERT INTO t1 (c1) VALUES(11); 91INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 92--sorted_result 93SELECT * FROM t1; 94DROP TABLE t1; 95CREATE TABLE t1(c1 FLOAT NOT NULL PRIMARY KEY); 96INSERT INTO t1 (c1) VALUES(10); 97INSERT INTO t1 (c1) VALUES(11); 98INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100; 99--sorted_result 100SELECT * FROM t1; 101DROP TABLE t1; 102 103