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') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg',c3='abcdefg';
11 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg';
12 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def') ON DUPLICATE KEY UPDATE c2='abcdefg',c3='abcdefg';
17 abcdefg abcdefg abcdefg
23 CREATE TABLE t1(c1 VARCHAR(10) NULL, c2 VARCHAR(10) NULL, c3 VARCHAR(10) NULL, UNIQUE(c1,c2,c3));
24 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
25 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
26 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
27 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
28 INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
29 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
30 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
31 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg',c3='abcdefg';
32 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg';
33 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def') ON DUPLICATE KEY UPDATE c2='abcdefg',c3='abcdefg';
38 abcdefg abcdefg abcdefg
44 CREATE TABLE t1(c1 BINARY(10) NULL, c2 BINARY(10) NULL, c3 BINARY(10) NULL, UNIQUE(c1,c2,c3));
45 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
46 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
47 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
48 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
49 INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
50 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
51 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
52 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg',c3='abcdefg';
53 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg';
54 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def') ON DUPLICATE KEY UPDATE c2='abcdefg',c3='abcdefg';
55 SELECT hex(c1),hex(c2),hex(c3) FROM t1;
56 hex(c1) hex(c2) hex(c3)
57 61626300000000000000 61626364656667000000 61626364656667000000
58 61626300000000000000 64656600000000000000 61626300000000000000
59 61626364656667000000 61626364656667000000 61626364656667000000
60 61626364656667000000 61626364656667000000 64656600000000000000
61 64656600000000000000 61626300000000000000 61626300000000000000
62 64656600000000000000 61626300000000000000 64656600000000000000
63 64656600000000000000 64656600000000000000 61626300000000000000
65 CREATE TABLE t1(c1 VARBINARY(10) NULL, c2 VARBINARY(10) NULL, c3 VARBINARY(10) NULL, UNIQUE(c1,c2,c3));
66 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
67 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
68 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
69 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
70 INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
71 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
72 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
73 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg',c3='abcdefg';
74 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def') ON DUPLICATE KEY UPDATE c1='abcdefg',c2='abcdefg';
75 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def') ON DUPLICATE KEY UPDATE c2='abcdefg',c3='abcdefg';
80 abcdefg abcdefg abcdefg