Debian Codegraph @

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