Debian Codegraph @

mysql-test/suite/engines/funcs/t/in_multicolumn_string_pk_constraint_duplicate_update.test

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