Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_multicolumn_string_unique_constraint_duplicate_update.result

raw
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';
13 SELECT * FROM t1;
14 c1 c2 c3
15 abc abcdefg abcdefg
16 abc def abc
17 abcdefg abcdefg abcdefg
18 abcdefg abcdefg def
19 def abc abc
20 def abc def
21 def def abc
22 DROP TABLE t1;
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';
34 SELECT * FROM t1;
35 c1 c2 c3
36 abc abcdefg abcdefg
37 abc def abc
38 abcdefg abcdefg abcdefg
39 abcdefg abcdefg def
40 def abc abc
41 def abc def
42 def def abc
43 DROP TABLE t1;
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
64 DROP TABLE t1;
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';
76 SELECT * FROM t1;
77 c1 c2 c3
78 abc abcdefg abcdefg
79 abc def abc
80 abcdefg abcdefg abcdefg
81 abcdefg abcdefg def
82 def abc abc
83 def abc def
84 def def abc
85 DROP TABLE t1;