2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 CHAR(10) NULL, c2 CHAR(10) NULL, c3 CHAR(10) NULL, UNIQUE(c1,c2,c3));
5
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
6
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
7
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
8
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
9
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
10
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
11
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
13
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
15
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
17
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
21
CREATE TABLE t1(c1 VARCHAR(10) NULL, c2 VARCHAR(10) NULL, c3 VARCHAR(10) NULL, UNIQUE(c1,c2,c3));
22
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
23
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
24
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
25
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
26
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
27
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
28
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
30
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
32
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
34
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
38
CREATE TABLE t1(c1 BINARY(10) NULL, c2 BINARY(10) NULL, c3 BINARY(10) NULL, UNIQUE(c1,c2,c3));
39
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
40
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
41
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
42
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
43
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
44
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
45
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
47
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
49
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
51
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
55
CREATE TABLE t1(c1 VARBINARY(10) NULL, c2 VARBINARY(10) NULL, c3 VARBINARY(10) NULL, UNIQUE(c1,c2,c3));
56
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
57
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
58
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
59
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
60
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
61
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
62
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
64
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
66
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
68
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');