Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_multicolumn_string_pk_constraint_error.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 hex(c1),hex(c2),hex(c3) FROM t1;
41 hex(c1) hex(c2) hex(c3)
42 616263 616263 616263
43 616263 616263 646566
44 616263 646566 616263
45 616263 646566 646566
46 646566 616263 616263
47 646566 616263 646566
48 646566 646566 616263
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 hex(c1),hex(c2),hex(c3) FROM t1;
65 hex(c1) hex(c2) hex(c3)
66 61626300000000000000 61626300000000000000 61626300000000000000
67 61626300000000000000 61626300000000000000 64656600000000000000
68 61626300000000000000 64656600000000000000 61626300000000000000
69 61626300000000000000 64656600000000000000 64656600000000000000
70 64656600000000000000 61626300000000000000 61626300000000000000
71 64656600000000000000 61626300000000000000 64656600000000000000
72 64656600000000000000 64656600000000000000 61626300000000000000
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;