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 '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 '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 '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 '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 '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 '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 '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 '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 'c1'
73 SELECT * FROM t1;
74 c1 c2 c3
75 abc
76 DROP TABLE t1;
77 CREATE TABLE t1(c1 VARBINARY(10) NULL, c2 VARBINARY(10) NULL, c3 VARBINARY(10) NULL, UNIQUE(c1,c2,c3));
78 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
79 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
80 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
81 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
82 INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
83 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
84 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
85 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
86 Warnings:
87 Warning 1062 Duplicate entry 'abc-abc-abc' for key 'c1'
88 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
89 Warnings:
90 Warning 1062 Duplicate entry 'abc-abc-def' for key 'c1'
91 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','def','def');
92 Warnings:
93 Warning 1062 Duplicate entry 'abc-def-def' for key 'c1'
94 SELECT * FROM t1;
95 c1 c2 c3
96 abc abc abc
97 abc abc def
98 abc def abc
99 abc def def
100 def abc abc
101 def abc def
102 def def abc
103 DROP TABLE t1;