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');
12
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg',c3='abcdefg';
13
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg';
14
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def') ON DUPLICATE KEY UPDATE c2='abcdefg',c3='abcdefg';
18
CREATE TABLE t1(c1 VARCHAR(10) NULL, c2 VARCHAR(10) NULL, c3 VARCHAR(10) NULL, UNIQUE(c1,c2,c3));
19
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
20
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
21
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
22
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
23
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
24
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
25
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
26
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg',c3='abcdefg';
27
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg';
28
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def') ON DUPLICATE KEY UPDATE c2='abcdefg',c3='abcdefg';
32
CREATE TABLE t1(c1 BINARY(10) NULL, c2 BINARY(10) NULL, c3 BINARY(10) NULL, UNIQUE(c1,c2,c3));
33
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
34
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
35
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
36
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
37
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
38
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
39
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
40
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg',c3='abcdefg';
41
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg';
42
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def') ON DUPLICATE KEY UPDATE c2='abcdefg',c3='abcdefg';
44
SELECT hex(c1),hex(c2),hex(c3) FROM t1;
46
CREATE TABLE t1(c1 VARBINARY(10) NULL, c2 VARBINARY(10) NULL, c3 VARBINARY(10) NULL, UNIQUE(c1,c2,c3));
47
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
48
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
49
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
50
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
51
INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
52
INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
53
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
54
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg',c3='abcdefg';
55
INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg';
56
INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def') ON DUPLICATE KEY UPDATE c2='abcdefg',c3='abcdefg';