Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
3 INSERT INTO t1 (c1) VALUES('abc');
4 INSERT INTO t1 (c1) VALUES('def');
5 INSERT IGNORE INTO t1 (c1) VALUES('abc');
6 Warnings:
7 Warning 1062 Duplicate entry 'abc' for key 't1.PRIMARY'
8 SELECT * FROM t1;
9 c1
10 abc
11 def
12 DROP TABLE t1;
13 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
14 INSERT INTO t1 (c1) VALUES('abc');
15 INSERT INTO t1 (c1) VALUES('def');
16 INSERT IGNORE INTO t1 (c1) VALUES('abc');
17 Warnings:
18 Warning 1062 Duplicate entry 'abc' for key 't1.PRIMARY'
19 SELECT * FROM t1;
20 c1
21 abc
22 def
23 DROP TABLE t1;
24 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
25 INSERT INTO t1 (c1) VALUES('abc');
26 INSERT INTO t1 (c1) VALUES('def');
27 INSERT IGNORE INTO t1 (c1) VALUES('abc');
28 Warnings:
29 Warning 1062 Duplicate entry 'abc' for key 't1.PRIMARY'
30 SELECT * FROM t1;
31 c1
32 abc
33 def
34 DROP TABLE t1;
35 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
36 INSERT INTO t1 (c1) VALUES('abc');
37 INSERT INTO t1 (c1) VALUES('def');
38 INSERT IGNORE INTO t1 (c1) VALUES('abc');
39 Warnings:
40 Warning 1062 Duplicate entry 'abc' for key 't1.PRIMARY'
41 SELECT * FROM t1;
42 c1
43 abc
44 def
45 DROP TABLE t1;