Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_multicolumn_string_unique_constraint_ignore.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 IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
11 Warnings:
12 Warning 1062 Duplicate entry 'abc-abc-abc' for key 't1.c1'
13 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
14 Warnings:
15 Warning 1062 Duplicate entry 'abc-abc-def' for key 't1.c1'
16 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','def','def');
17 Warnings:
18 Warning 1062 Duplicate entry 'abc-def-def' for key 't1.c1'
19 SELECT * FROM t1;
20 c1 c2 c3
21 abc abc abc
22 abc abc def
23 abc def abc
24 abc def def
25 def abc abc
26 def abc def
27 def def abc
28 DROP TABLE t1;
29 CREATE TABLE t1(c1 VARCHAR(10) NULL, c2 VARCHAR(10) NULL, c3 VARCHAR(10) NULL, UNIQUE(c1,c2,c3));
30 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
31 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
32 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
33 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
34 INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
35 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
36 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
37 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
38 Warnings:
39 Warning 1062 Duplicate entry 'abc-abc-abc' for key 't1.c1'
40 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
41 Warnings:
42 Warning 1062 Duplicate entry 'abc-abc-def' for key 't1.c1'
43 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','def','def');
44 Warnings:
45 Warning 1062 Duplicate entry 'abc-def-def' for key 't1.c1'
46 SELECT * FROM t1;
47 c1 c2 c3
48 abc abc abc
49 abc abc def
50 abc def abc
51 abc def def
52 def abc abc
53 def abc def
54 def def abc
55 DROP TABLE t1;
56 CREATE TABLE t1(c1 BINARY(10) NULL, c2 BINARY(10) NULL, c3 BINARY(10) NULL, UNIQUE(c1,c2,c3));
57 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
58 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
59 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
60 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
61 INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
62 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
63 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
64 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
65 Warnings:
66 Warning 1062 Duplicate entry 'abc-abc-abc' for key 't1.c1'
67 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
68 Warnings:
69 Warning 1062 Duplicate entry 'abc-abc-def' for key 't1.c1'
70 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','def','def');
71 Warnings:
72 Warning 1062 Duplicate entry 'abc-def-def' for key 't1.c1'
73 SELECT * FROM t1;
74 c1 c2 c3
75 abc####### abc####### abc#######
76 abc####### abc####### def#######
77 abc####### def####### abc#######
78 abc####### def####### def#######
79 def####### abc####### abc#######
80 def####### abc####### def#######
81 def####### def####### abc#######
82 DROP TABLE t1;
83 CREATE TABLE t1(c1 VARBINARY(10) NULL, c2 VARBINARY(10) NULL, c3 VARBINARY(10) NULL, UNIQUE(c1,c2,c3));
84 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
85 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
86 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
87 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
88 INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
89 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
90 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
91 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
92 Warnings:
93 Warning 1062 Duplicate entry 'abc-abc-abc' for key 't1.c1'
94 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
95 Warnings:
96 Warning 1062 Duplicate entry 'abc-abc-def' for key 't1.c1'
97 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','def','def');
98 Warnings:
99 Warning 1062 Duplicate entry 'abc-def-def' for key 't1.c1'
100 SELECT * FROM t1;
101 c1 c2 c3
102 abc abc abc
103 abc abc def
104 abc def abc
105 abc def def
106 def abc abc
107 def abc def
108 def def abc
109 DROP TABLE t1;