Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(10) NOT NULL, c2 CHAR(10) NULL, c3 CHAR(10) NULL, PRIMARY KEY (c1), UNIQUE (c2));
3 INSERT INTO t1 (c1,c2,c3) VALUES('a','e','abc');
4 INSERT INTO t1 (c1,c2,c3) VALUES('b','d','abc');
5 INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc');
6 INSERT INTO t1 (c1,c2,c3) VALUES('d','b','abc');
7 INSERT INTO t1 (c1,c2,c3) VALUES('e','a','abc');
8 INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
9 INSERT INTO t1 (c1,c2,c3) VALUES('a','a','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
10 SELECT * FROM t1;
11 c1 c2 c3
12 a e abcdefg
13 b d abc
14 c c abcdefg
15 d b abc
16 e a abc
17 DROP TABLE t1;
18 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL, c2 VARCHAR(10) NULL, c3 VARCHAR(10) NULL, PRIMARY KEY (c1), UNIQUE (c2));
19 INSERT INTO t1 (c1,c2,c3) VALUES('a','e','abc');
20 INSERT INTO t1 (c1,c2,c3) VALUES('b','d','abc');
21 INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc');
22 INSERT INTO t1 (c1,c2,c3) VALUES('d','b','abc');
23 INSERT INTO t1 (c1,c2,c3) VALUES('e','a','abc');
24 INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
25 INSERT INTO t1 (c1,c2,c3) VALUES('a','a','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
26 SELECT * FROM t1;
27 c1 c2 c3
28 a e abcdefg
29 b d abc
30 c c abcdefg
31 d b abc
32 e a abc
33 DROP TABLE t1;
34 CREATE TABLE t1(c1 BINARY(10) NOT NULL, c2 BINARY(10) NULL, c3 BINARY(10) NULL, PRIMARY KEY (c1), UNIQUE (c2));
35 INSERT INTO t1 (c1,c2,c3) VALUES('a','e','abc');
36 INSERT INTO t1 (c1,c2,c3) VALUES('b','d','abc');
37 INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc');
38 INSERT INTO t1 (c1,c2,c3) VALUES('d','b','abc');
39 INSERT INTO t1 (c1,c2,c3) VALUES('e','a','abc');
40 INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
41 INSERT INTO t1 (c1,c2,c3) VALUES('a','a','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
42 SELECT hex(c1),hex(c2),hex(c3) FROM t1;
43 hex(c1) hex(c2) hex(c3)
44 61000000000000000000 65000000000000000000 61626364656667000000
45 62000000000000000000 64000000000000000000 61626300000000000000
46 63000000000000000000 63000000000000000000 61626364656667000000
47 64000000000000000000 62000000000000000000 61626300000000000000
48 65000000000000000000 61000000000000000000 61626300000000000000
49 DROP TABLE t1;
50 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL, c2 VARBINARY(10) NULL, c3 VARBINARY(10) NULL, PRIMARY KEY (c1), UNIQUE (c2));
51 INSERT INTO t1 (c1,c2,c3) VALUES('a','e','abc');
52 INSERT INTO t1 (c1,c2,c3) VALUES('b','d','abc');
53 INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc');
54 INSERT INTO t1 (c1,c2,c3) VALUES('d','b','abc');
55 INSERT INTO t1 (c1,c2,c3) VALUES('e','a','abc');
56 INSERT INTO t1 (c1,c2,c3) VALUES('c','c','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
57 INSERT INTO t1 (c1,c2,c3) VALUES('a','a','abc') ON DUPLICATE KEY UPDATE c3='abcdefg';
58 SELECT * FROM t1;
59 c1 c2 c3
60 a e abcdefg
61 b d abc
62 c c abcdefg
63 d b abc
64 e a abc
65 DROP TABLE t1;