1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 CHAR(10) NULL, c2 CHAR(10) NULL, c3 CHAR(10) NULL, UNIQUE(c1,c2,c3));
3
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
4
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
5
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
6
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
7
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
8
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
9
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
10
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
11
ERROR 23000: Duplicate entry 'abc-abc-abc' for key 'c1'
12
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
13
ERROR 23000: Duplicate entry 'abc-abc-def' for key 'c1'
14
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
15
ERROR 23000: Duplicate entry 'abc-def-def' for key 'c1'
26
CREATE TABLE t1(c1 VARCHAR(10) NULL, c2 VARCHAR(10) NULL, c3 VARCHAR(10) NULL, UNIQUE(c1,c2,c3));
27
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
28
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
29
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
30
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
31
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
32
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
33
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
34
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
35
ERROR 23000: Duplicate entry 'abc-abc-abc' for key 'c1'
36
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
37
ERROR 23000: Duplicate entry 'abc-abc-def' for key 'c1'
38
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
39
ERROR 23000: Duplicate entry 'abc-def-def' for key 'c1'
50
CREATE TABLE t1(c1 BINARY(10) NULL, c2 BINARY(10) NULL, c3 BINARY(10) NULL, UNIQUE(c1,c2,c3));
51
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
52
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
53
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
54
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
55
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
56
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
57
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
58
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
59
ERROR 23000: Duplicate entry 'abc' for key 'c1'
60
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
61
ERROR 23000: Duplicate entry 'abc' for key 'c1'
62
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
63
ERROR 23000: Duplicate entry 'abc' for key 'c1'
68
CREATE TABLE t1(c1 VARBINARY(10) NULL, c2 VARBINARY(10) NULL, c3 VARBINARY(10) NULL, UNIQUE(c1,c2,c3));
69
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
70
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
71
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
72
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
73
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
74
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
75
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
76
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
77
ERROR 23000: Duplicate entry 'abc-abc-abc' for key 'c1'
78
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
79
ERROR 23000: Duplicate entry 'abc-abc-def' for key 'c1'
80
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
81
ERROR 23000: Duplicate entry 'abc-def-def' for key 'c1'