1DROP TABLE IF EXISTS t1; 2CREATE TABLE t1(c1 TINYINT NULL, c2 TINYINT NULL, c3 TINYINT NULL, UNIQUE(c1,c2,c3)); 3INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 4INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 5INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 6INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 7INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 8INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 9INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 10INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 11ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 12INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 13ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 14INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 15ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 16SELECT * FROM t1; 17c1 c2 c3 1810 10 10 1910 10 11 2010 11 10 2110 11 11 2211 10 10 2311 10 11 2411 11 10 25DROP TABLE t1; 26CREATE TABLE t1(c1 SMALLINT NULL, c2 SMALLINT NULL, c3 SMALLINT NULL, UNIQUE(c1,c2,c3)); 27INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 28INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 29INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 30INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 31INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 32INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 33INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 34INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 35ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 36INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 37ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 38INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 39ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 40SELECT * FROM t1; 41c1 c2 c3 4210 10 10 4310 10 11 4410 11 10 4510 11 11 4611 10 10 4711 10 11 4811 11 10 49DROP TABLE t1; 50CREATE TABLE t1(c1 MEDIUMINT NULL, c2 MEDIUMINT NULL, c3 MEDIUMINT NULL, UNIQUE(c1,c2,c3)); 51INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 52INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 53INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 54INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 55INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 56INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 57INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 58INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 59ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 60INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 61ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 62INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 63ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 64SELECT * FROM t1; 65c1 c2 c3 6610 10 10 6710 10 11 6810 11 10 6910 11 11 7011 10 10 7111 10 11 7211 11 10 73DROP TABLE t1; 74CREATE TABLE t1(c1 INT NULL, c2 INT NULL, c3 INT NULL, UNIQUE(c1,c2,c3)); 75INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 76INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 77INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 78INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 79INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 80INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 81INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 82INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 83ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 84INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 85ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 86INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 87ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 88SELECT * FROM t1; 89c1 c2 c3 9010 10 10 9110 10 11 9210 11 10 9310 11 11 9411 10 10 9511 10 11 9611 11 10 97DROP TABLE t1; 98CREATE TABLE t1(c1 INTEGER NULL, c2 INTEGER NULL, c3 INTEGER NULL, UNIQUE(c1,c2,c3)); 99INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 100INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 101INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 102INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 103INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 104INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 105INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 106INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 107ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 108INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 109ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 110INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 111ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 112SELECT * FROM t1; 113c1 c2 c3 11410 10 10 11510 10 11 11610 11 10 11710 11 11 11811 10 10 11911 10 11 12011 11 10 121DROP TABLE t1; 122CREATE TABLE t1(c1 BIGINT NULL, c2 BIGINT NULL, c3 BIGINT NULL, UNIQUE(c1,c2,c3)); 123INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 124INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 125INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 126INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 127INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 128INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 129INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 130INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 131ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 132INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 133ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 134INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 135ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 136SELECT * FROM t1; 137c1 c2 c3 13810 10 10 13910 10 11 14010 11 10 14110 11 11 14211 10 10 14311 10 11 14411 11 10 145DROP TABLE t1; 146CREATE TABLE t1(c1 DECIMAL NULL, c2 DECIMAL NULL, c3 DECIMAL NULL, UNIQUE(c1,c2,c3)); 147INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 148INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 149INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 150INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 151INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 152INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 153INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 154INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 155ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 156INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 157ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 158INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 159ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 160SELECT * FROM t1; 161c1 c2 c3 16210 10 10 16310 10 11 16410 11 10 16510 11 11 16611 10 10 16711 10 11 16811 11 10 169DROP TABLE t1; 170CREATE TABLE t1(c1 DEC NULL, c2 DEC NULL, c3 DEC NULL, UNIQUE(c1,c2,c3)); 171INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 172INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 173INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 174INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 175INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 176INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 177INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 178INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 179ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 180INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 181ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 182INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 183ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 184SELECT * FROM t1; 185c1 c2 c3 18610 10 10 18710 10 11 18810 11 10 18910 11 11 19011 10 10 19111 10 11 19211 11 10 193DROP TABLE t1; 194CREATE TABLE t1(c1 FIXED NULL, c2 FIXED NULL, c3 FIXED NULL, UNIQUE(c1,c2,c3)); 195INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 196INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 197INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 198INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 199INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 200INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 201INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 202INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 203ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 204INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 205ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 206INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 207ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 208SELECT * FROM t1; 209c1 c2 c3 21010 10 10 21110 10 11 21210 11 10 21310 11 11 21411 10 10 21511 10 11 21611 11 10 217DROP TABLE t1; 218CREATE TABLE t1(c1 NUMERIC NULL, c2 NUMERIC NULL, c3 NUMERIC NULL, UNIQUE(c1,c2,c3)); 219INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 220INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 221INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 222INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 223INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 224INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 225INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 226INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 227ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 228INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 229ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 230INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 231ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 232SELECT * FROM t1; 233c1 c2 c3 23410 10 10 23510 10 11 23610 11 10 23710 11 11 23811 10 10 23911 10 11 24011 11 10 241DROP TABLE t1; 242CREATE TABLE t1(c1 DOUBLE NULL, c2 DOUBLE NULL, c3 DOUBLE NULL, UNIQUE(c1,c2,c3)); 243INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 244INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 245INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 246INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 247INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 248INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 249INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 250INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 251ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 252INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 253ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 254INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 255ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 256SELECT * FROM t1; 257c1 c2 c3 25810 10 10 25910 10 11 26010 11 10 26110 11 11 26211 10 10 26311 10 11 26411 11 10 265DROP TABLE t1; 266CREATE TABLE t1(c1 REAL NULL, c2 REAL NULL, c3 REAL NULL, UNIQUE(c1,c2,c3)); 267INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 268INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 269INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 270INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 271INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 272INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 273INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 274INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 275ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 276INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 277ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 278INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 279ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 280SELECT * FROM t1; 281c1 c2 c3 28210 10 10 28310 10 11 28410 11 10 28510 11 11 28611 10 10 28711 10 11 28811 11 10 289DROP TABLE t1; 290CREATE TABLE t1(c1 DOUBLE PRECISION NULL, c2 DOUBLE PRECISION NULL, c3 DOUBLE PRECISION NULL, UNIQUE(c1,c2,c3)); 291INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 292INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 293INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 294INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 295INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 296INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 297INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 298INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 299ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 300INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 301ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 302INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 303ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 304SELECT * FROM t1; 305c1 c2 c3 30610 10 10 30710 10 11 30810 11 10 30910 11 11 31011 10 10 31111 10 11 31211 11 10 313DROP TABLE t1; 314CREATE TABLE t1(c1 FLOAT NULL, c2 FLOAT NULL, c3 FLOAT NULL, UNIQUE(c1,c2,c3)); 315INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 316INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 317INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10); 318INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10); 319INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10); 320INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11); 321INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 322INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10); 323ERROR 23000: Duplicate entry '10-10-10' for key 't1.c1' 324INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11); 325ERROR 23000: Duplicate entry '10-10-11' for key 't1.c1' 326INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11); 327ERROR 23000: Duplicate entry '10-11-11' for key 't1.c1' 328SELECT * FROM t1; 329c1 c2 c3 33010 10 10 33110 10 11 33210 11 10 33310 11 11 33411 10 10 33511 10 11 33611 11 10 337DROP TABLE t1; 338