Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
5 INSERT INTO t1 (c1) VALUES(10);
6 INSERT INTO t1 (c1) VALUES(11);
7 --error ER_DUP_ENTRY
8 INSERT INTO t1 (c1) VALUES(10);
9 SELECT * FROM t1;
10 DROP TABLE t1;
11 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
12 INSERT INTO t1 (c1) VALUES(10);
13 INSERT INTO t1 (c1) VALUES(11);
14 --error ER_DUP_ENTRY
15 INSERT INTO t1 (c1) VALUES(10);
16 SELECT * FROM t1;
17 DROP TABLE t1;
18 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
19 INSERT INTO t1 (c1) VALUES(10);
20 INSERT INTO t1 (c1) VALUES(11);
21 --error ER_DUP_ENTRY
22 INSERT INTO t1 (c1) VALUES(10);
23 SELECT * FROM t1;
24 DROP TABLE t1;
25 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
26 INSERT INTO t1 (c1) VALUES(10);
27 INSERT INTO t1 (c1) VALUES(11);
28 --error ER_DUP_ENTRY
29 INSERT INTO t1 (c1) VALUES(10);
30 SELECT * FROM t1;
31 DROP TABLE t1;
32 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
33 INSERT INTO t1 (c1) VALUES(10);
34 INSERT INTO t1 (c1) VALUES(11);
35 --error ER_DUP_ENTRY
36 INSERT INTO t1 (c1) VALUES(10);
37 SELECT * FROM t1;
38 DROP TABLE t1;
39 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
40 INSERT INTO t1 (c1) VALUES(10);
41 INSERT INTO t1 (c1) VALUES(11);
42 --error ER_DUP_ENTRY
43 INSERT INTO t1 (c1) VALUES(10);
44 SELECT * FROM t1;
45 DROP TABLE t1;
46 CREATE TABLE t1(c1 DECIMAL NOT NULL PRIMARY KEY);
47 INSERT INTO t1 (c1) VALUES(10);
48 INSERT INTO t1 (c1) VALUES(11);
49 --error ER_DUP_ENTRY
50 INSERT INTO t1 (c1) VALUES(10);
51 SELECT * FROM t1;
52 DROP TABLE t1;
53 CREATE TABLE t1(c1 DEC NOT NULL PRIMARY KEY);
54 INSERT INTO t1 (c1) VALUES(10);
55 INSERT INTO t1 (c1) VALUES(11);
56 --error ER_DUP_ENTRY
57 INSERT INTO t1 (c1) VALUES(10);
58 SELECT * FROM t1;
59 DROP TABLE t1;
60 CREATE TABLE t1(c1 FIXED NOT NULL PRIMARY KEY);
61 INSERT INTO t1 (c1) VALUES(10);
62 INSERT INTO t1 (c1) VALUES(11);
63 --error ER_DUP_ENTRY
64 INSERT INTO t1 (c1) VALUES(10);
65 SELECT * FROM t1;
66 DROP TABLE t1;
67 CREATE TABLE t1(c1 NUMERIC NOT NULL PRIMARY KEY);
68 INSERT INTO t1 (c1) VALUES(10);
69 INSERT INTO t1 (c1) VALUES(11);
70 --error ER_DUP_ENTRY
71 INSERT INTO t1 (c1) VALUES(10);
72 SELECT * FROM t1;
73 DROP TABLE t1;
74 CREATE TABLE t1(c1 DOUBLE NOT NULL PRIMARY KEY);
75 INSERT INTO t1 (c1) VALUES(10);
76 INSERT INTO t1 (c1) VALUES(11);
77 --error ER_DUP_ENTRY
78 INSERT INTO t1 (c1) VALUES(10);
79 SELECT * FROM t1;
80 DROP TABLE t1;
81 CREATE TABLE t1(c1 REAL NOT NULL PRIMARY KEY);
82 INSERT INTO t1 (c1) VALUES(10);
83 INSERT INTO t1 (c1) VALUES(11);
84 --error ER_DUP_ENTRY
85 INSERT INTO t1 (c1) VALUES(10);
86 SELECT * FROM t1;
87 DROP TABLE t1;
88 CREATE TABLE t1(c1 DOUBLE PRECISION NOT NULL PRIMARY KEY);
89 INSERT INTO t1 (c1) VALUES(10);
90 INSERT INTO t1 (c1) VALUES(11);
91 --error ER_DUP_ENTRY
92 INSERT INTO t1 (c1) VALUES(10);
93 SELECT * FROM t1;
94 DROP TABLE t1;
95 CREATE TABLE t1(c1 FLOAT NOT NULL PRIMARY KEY);
96 INSERT INTO t1 (c1) VALUES(10);
97 INSERT INTO t1 (c1) VALUES(11);
98 --error ER_DUP_ENTRY
99 INSERT INTO t1 (c1) VALUES(10);
100 SELECT * FROM t1;
101 DROP TABLE t1;
102