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); 7--error ER_DUP_ENTRY 8INSERT INTO t1 (c1) VALUES(10); 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); 14--error ER_DUP_ENTRY 15INSERT INTO t1 (c1) VALUES(10); 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); 21--error ER_DUP_ENTRY 22INSERT INTO t1 (c1) VALUES(10); 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); 28--error ER_DUP_ENTRY 29INSERT INTO t1 (c1) VALUES(10); 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); 35--error ER_DUP_ENTRY 36INSERT INTO t1 (c1) VALUES(10); 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); 42--error ER_DUP_ENTRY 43INSERT INTO t1 (c1) VALUES(10); 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); 49--error ER_DUP_ENTRY 50INSERT INTO t1 (c1) VALUES(10); 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); 56--error ER_DUP_ENTRY 57INSERT INTO t1 (c1) VALUES(10); 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); 63--error ER_DUP_ENTRY 64INSERT INTO t1 (c1) VALUES(10); 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); 70--error ER_DUP_ENTRY 71INSERT INTO t1 (c1) VALUES(10); 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); 77--error ER_DUP_ENTRY 78INSERT INTO t1 (c1) VALUES(10); 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); 84--error ER_DUP_ENTRY 85INSERT INTO t1 (c1) VALUES(10); 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); 91--error ER_DUP_ENTRY 92INSERT INTO t1 (c1) VALUES(10); 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); 98--error ER_DUP_ENTRY 99INSERT INTO t1 (c1) VALUES(10); 100SELECT * FROM t1; 101DROP TABLE t1; 102 103