Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(10) NULL UNIQUE);
3 INSERT INTO t1 (c1) VALUES('abc');
4 INSERT INTO t1 (c1) VALUES('def');
5 INSERT INTO t1 (c1) VALUES('abc') ON DUPLICATE KEY UPDATE c1='abcdefg';
6 SELECT * FROM t1;
7 c1
8 abcdefg
9 def
10 DROP TABLE t1;
11 CREATE TABLE t1(c1 VARCHAR(10) NULL UNIQUE);
12 INSERT INTO t1 (c1) VALUES('abc');
13 INSERT INTO t1 (c1) VALUES('def');
14 INSERT INTO t1 (c1) VALUES('abc') ON DUPLICATE KEY UPDATE c1='abcdefg';
15 SELECT * FROM t1;
16 c1
17 abcdefg
18 def
19 DROP TABLE t1;
20 CREATE TABLE t1(c1 BINARY(10) NULL UNIQUE);
21 INSERT INTO t1 (c1) VALUES('abc');
22 INSERT INTO t1 (c1) VALUES('def');
23 INSERT INTO t1 (c1) VALUES('abc') ON DUPLICATE KEY UPDATE c1='abcdefg';
24 SELECT * FROM t1;
25 c1
26 abcdefg
27 def
28 DROP TABLE t1;
29 CREATE TABLE t1(c1 VARBINARY(10) NULL UNIQUE);
30 INSERT INTO t1 (c1) VALUES('abc');
31 INSERT INTO t1 (c1) VALUES('def');
32 INSERT INTO t1 (c1) VALUES('abc') ON DUPLICATE KEY UPDATE c1='abcdefg';
33 SELECT * FROM t1;
34 c1
35 abcdefg
36 def
37 DROP TABLE t1;