Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT NULL UNIQUE);
3 INSERT INTO t1 (c1) VALUES(10);
4 INSERT INTO t1 (c1) VALUES(11);
5 INSERT IGNORE INTO t1 (c1) VALUES(10);
6 Warnings:
7 Warning 1062 Duplicate entry '10' for key 't1.c1'
8 SELECT * FROM t1;
9 c1
10 10
11 11
12 DROP TABLE t1;
13 CREATE TABLE t1(c1 SMALLINT NULL UNIQUE);
14 INSERT INTO t1 (c1) VALUES(10);
15 INSERT INTO t1 (c1) VALUES(11);
16 INSERT IGNORE INTO t1 (c1) VALUES(10);
17 Warnings:
18 Warning 1062 Duplicate entry '10' for key 't1.c1'
19 SELECT * FROM t1;
20 c1
21 10
22 11
23 DROP TABLE t1;
24 CREATE TABLE t1(c1 MEDIUMINT NULL UNIQUE);
25 INSERT INTO t1 (c1) VALUES(10);
26 INSERT INTO t1 (c1) VALUES(11);
27 INSERT IGNORE INTO t1 (c1) VALUES(10);
28 Warnings:
29 Warning 1062 Duplicate entry '10' for key 't1.c1'
30 SELECT * FROM t1;
31 c1
32 10
33 11
34 DROP TABLE t1;
35 CREATE TABLE t1(c1 INT NULL UNIQUE);
36 INSERT INTO t1 (c1) VALUES(10);
37 INSERT INTO t1 (c1) VALUES(11);
38 INSERT IGNORE INTO t1 (c1) VALUES(10);
39 Warnings:
40 Warning 1062 Duplicate entry '10' for key 't1.c1'
41 SELECT * FROM t1;
42 c1
43 10
44 11
45 DROP TABLE t1;
46 CREATE TABLE t1(c1 INTEGER NULL UNIQUE);
47 INSERT INTO t1 (c1) VALUES(10);
48 INSERT INTO t1 (c1) VALUES(11);
49 INSERT IGNORE INTO t1 (c1) VALUES(10);
50 Warnings:
51 Warning 1062 Duplicate entry '10' for key 't1.c1'
52 SELECT * FROM t1;
53 c1
54 10
55 11
56 DROP TABLE t1;
57 CREATE TABLE t1(c1 BIGINT NULL UNIQUE);
58 INSERT INTO t1 (c1) VALUES(10);
59 INSERT INTO t1 (c1) VALUES(11);
60 INSERT IGNORE INTO t1 (c1) VALUES(10);
61 Warnings:
62 Warning 1062 Duplicate entry '10' for key 't1.c1'
63 SELECT * FROM t1;
64 c1
65 10
66 11
67 DROP TABLE t1;
68 CREATE TABLE t1(c1 DECIMAL NULL UNIQUE);
69 INSERT INTO t1 (c1) VALUES(10);
70 INSERT INTO t1 (c1) VALUES(11);
71 INSERT IGNORE INTO t1 (c1) VALUES(10);
72 Warnings:
73 Warning 1062 Duplicate entry '10' for key 't1.c1'
74 SELECT * FROM t1;
75 c1
76 10
77 11
78 DROP TABLE t1;
79 CREATE TABLE t1(c1 DEC NULL UNIQUE);
80 INSERT INTO t1 (c1) VALUES(10);
81 INSERT INTO t1 (c1) VALUES(11);
82 INSERT IGNORE INTO t1 (c1) VALUES(10);
83 Warnings:
84 Warning 1062 Duplicate entry '10' for key 't1.c1'
85 SELECT * FROM t1;
86 c1
87 10
88 11
89 DROP TABLE t1;
90 CREATE TABLE t1(c1 FIXED NULL UNIQUE);
91 INSERT INTO t1 (c1) VALUES(10);
92 INSERT INTO t1 (c1) VALUES(11);
93 INSERT IGNORE INTO t1 (c1) VALUES(10);
94 Warnings:
95 Warning 1062 Duplicate entry '10' for key 't1.c1'
96 SELECT * FROM t1;
97 c1
98 10
99 11
100 DROP TABLE t1;
101 CREATE TABLE t1(c1 NUMERIC NULL UNIQUE);
102 INSERT INTO t1 (c1) VALUES(10);
103 INSERT INTO t1 (c1) VALUES(11);
104 INSERT IGNORE INTO t1 (c1) VALUES(10);
105 Warnings:
106 Warning 1062 Duplicate entry '10' for key 't1.c1'
107 SELECT * FROM t1;
108 c1
109 10
110 11
111 DROP TABLE t1;
112 CREATE TABLE t1(c1 DOUBLE NULL UNIQUE);
113 INSERT INTO t1 (c1) VALUES(10);
114 INSERT INTO t1 (c1) VALUES(11);
115 INSERT IGNORE INTO t1 (c1) VALUES(10);
116 Warnings:
117 Warning 1062 Duplicate entry '10' for key 't1.c1'
118 SELECT * FROM t1;
119 c1
120 10
121 11
122 DROP TABLE t1;
123 CREATE TABLE t1(c1 REAL NULL UNIQUE);
124 INSERT INTO t1 (c1) VALUES(10);
125 INSERT INTO t1 (c1) VALUES(11);
126 INSERT IGNORE INTO t1 (c1) VALUES(10);
127 Warnings:
128 Warning 1062 Duplicate entry '10' for key 't1.c1'
129 SELECT * FROM t1;
130 c1
131 10
132 11
133 DROP TABLE t1;
134 CREATE TABLE t1(c1 DOUBLE PRECISION NULL UNIQUE);
135 INSERT INTO t1 (c1) VALUES(10);
136 INSERT INTO t1 (c1) VALUES(11);
137 INSERT IGNORE INTO t1 (c1) VALUES(10);
138 Warnings:
139 Warning 1062 Duplicate entry '10' for key 't1.c1'
140 SELECT * FROM t1;
141 c1
142 10
143 11
144 DROP TABLE t1;
145 CREATE TABLE t1(c1 FLOAT NULL UNIQUE);
146 INSERT INTO t1 (c1) VALUES(10);
147 INSERT INTO t1 (c1) VALUES(11);
148 INSERT IGNORE INTO t1 (c1) VALUES(10);
149 Warnings:
150 Warning 1062 Duplicate entry '10' for key 't1.c1'
151 SELECT * FROM t1;
152 c1
153 10
154 11
155 DROP TABLE t1;