Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
5 INSERT INTO t1 (c1) VALUES('abc');
6 INSERT INTO t1 (c1) VALUES('def');
7 --error ER_DUP_ENTRY
8 INSERT INTO t1 (c1) VALUES('abc');
9 SELECT * FROM t1;
10 DROP TABLE t1;
11 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
12 INSERT INTO t1 (c1) VALUES('abc');
13 INSERT INTO t1 (c1) VALUES('def');
14 --error ER_DUP_ENTRY
15 INSERT INTO t1 (c1) VALUES('abc');
16 SELECT * FROM t1;
17 DROP TABLE t1;
18 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
19 INSERT INTO t1 (c1) VALUES('abc');
20 INSERT INTO t1 (c1) VALUES('def');
21 # Bug#52430
22 --error ER_DUP_ENTRY
23 INSERT INTO t1 (c1) VALUES('abc');
24 SELECT * FROM t1;
25 DROP TABLE t1;
26 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
27 INSERT INTO t1 (c1) VALUES('abc');
28 INSERT INTO t1 (c1) VALUES('def');
29 --error ER_DUP_ENTRY
30 INSERT INTO t1 (c1) VALUES('abc');
31 SELECT * FROM t1;
32 DROP TABLE t1;
33