Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(10) NOT NULL, c2 CHAR(10) NOT NULL, c3 CHAR(10) NOT NULL, PRIMARY KEY(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 't1.PRIMARY'
12 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
13 ERROR 23000: Duplicate entry 'abc-abc-def' for key 't1.PRIMARY'
14 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
15 ERROR 23000: Duplicate entry 'abc-def-def' for key 't1.PRIMARY'
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) NOT NULL, c2 VARCHAR(10) NOT NULL, c3 VARCHAR(10) NOT NULL, PRIMARY KEY(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 't1.PRIMARY'
36 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
37 ERROR 23000: Duplicate entry 'abc-abc-def' for key 't1.PRIMARY'
38 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
39 ERROR 23000: Duplicate entry 'abc-def-def' for key 't1.PRIMARY'
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) NOT NULL, c2 BINARY(10) NOT NULL, c3 BINARY(10) NOT NULL, PRIMARY KEY(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 't1.PRIMARY'
60 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
61 ERROR 23000: Duplicate entry 'abc-abc-def' for key 't1.PRIMARY'
62 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
63 ERROR 23000: Duplicate entry 'abc-def-def' for key 't1.PRIMARY'
64 SELECT * FROM t1;
65 c1 c2 c3
66 abc####### abc####### abc#######
67 abc####### abc####### def#######
68 abc####### def####### abc#######
69 abc####### def####### def#######
70 def####### abc####### abc#######
71 def####### abc####### def#######
72 def####### def####### abc#######
73 DROP TABLE t1;
74 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL, c2 VARBINARY(10) NOT NULL, c3 VARBINARY(10) NOT NULL, PRIMARY KEY(c1,c2,c3));
75 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
76 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
77 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
78 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
79 INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
80 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
81 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
82 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
83 ERROR 23000: Duplicate entry 'abc-abc-abc' for key 't1.PRIMARY'
84 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
85 ERROR 23000: Duplicate entry 'abc-abc-def' for key 't1.PRIMARY'
86 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
87 ERROR 23000: Duplicate entry 'abc-def-def' for key 't1.PRIMARY'
88 SELECT * FROM t1;
89 c1 c2 c3
90 abc abc abc
91 abc abc def
92 abc def abc
93 abc def def
94 def abc abc
95 def abc def
96 def def abc
97 DROP TABLE t1;