Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_number_unique_constraint_duplicate_update.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 INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
6 SELECT * FROM t1;
7 c1
8 100
9 11
10 DROP TABLE t1;
11 CREATE TABLE t1(c1 SMALLINT NULL UNIQUE);
12 INSERT INTO t1 (c1) VALUES(10);
13 INSERT INTO t1 (c1) VALUES(11);
14 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
15 SELECT * FROM t1;
16 c1
17 100
18 11
19 DROP TABLE t1;
20 CREATE TABLE t1(c1 MEDIUMINT NULL UNIQUE);
21 INSERT INTO t1 (c1) VALUES(10);
22 INSERT INTO t1 (c1) VALUES(11);
23 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
24 SELECT * FROM t1;
25 c1
26 100
27 11
28 DROP TABLE t1;
29 CREATE TABLE t1(c1 INT NULL UNIQUE);
30 INSERT INTO t1 (c1) VALUES(10);
31 INSERT INTO t1 (c1) VALUES(11);
32 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
33 SELECT * FROM t1;
34 c1
35 100
36 11
37 DROP TABLE t1;
38 CREATE TABLE t1(c1 INTEGER NULL UNIQUE);
39 INSERT INTO t1 (c1) VALUES(10);
40 INSERT INTO t1 (c1) VALUES(11);
41 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
42 SELECT * FROM t1;
43 c1
44 100
45 11
46 DROP TABLE t1;
47 CREATE TABLE t1(c1 BIGINT NULL UNIQUE);
48 INSERT INTO t1 (c1) VALUES(10);
49 INSERT INTO t1 (c1) VALUES(11);
50 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
51 SELECT * FROM t1;
52 c1
53 100
54 11
55 DROP TABLE t1;
56 CREATE TABLE t1(c1 DECIMAL NULL UNIQUE);
57 INSERT INTO t1 (c1) VALUES(10);
58 INSERT INTO t1 (c1) VALUES(11);
59 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
60 SELECT * FROM t1;
61 c1
62 100
63 11
64 DROP TABLE t1;
65 CREATE TABLE t1(c1 DEC NULL UNIQUE);
66 INSERT INTO t1 (c1) VALUES(10);
67 INSERT INTO t1 (c1) VALUES(11);
68 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
69 SELECT * FROM t1;
70 c1
71 100
72 11
73 DROP TABLE t1;
74 CREATE TABLE t1(c1 FIXED NULL UNIQUE);
75 INSERT INTO t1 (c1) VALUES(10);
76 INSERT INTO t1 (c1) VALUES(11);
77 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
78 SELECT * FROM t1;
79 c1
80 100
81 11
82 DROP TABLE t1;
83 CREATE TABLE t1(c1 NUMERIC NULL UNIQUE);
84 INSERT INTO t1 (c1) VALUES(10);
85 INSERT INTO t1 (c1) VALUES(11);
86 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
87 SELECT * FROM t1;
88 c1
89 100
90 11
91 DROP TABLE t1;
92 CREATE TABLE t1(c1 DOUBLE NULL UNIQUE);
93 INSERT INTO t1 (c1) VALUES(10);
94 INSERT INTO t1 (c1) VALUES(11);
95 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
96 SELECT * FROM t1;
97 c1
98 100
99 11
100 DROP TABLE t1;
101 CREATE TABLE t1(c1 REAL NULL UNIQUE);
102 INSERT INTO t1 (c1) VALUES(10);
103 INSERT INTO t1 (c1) VALUES(11);
104 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
105 SELECT * FROM t1;
106 c1
107 100
108 11
109 DROP TABLE t1;
110 CREATE TABLE t1(c1 DOUBLE PRECISION NULL UNIQUE);
111 INSERT INTO t1 (c1) VALUES(10);
112 INSERT INTO t1 (c1) VALUES(11);
113 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
114 SELECT * FROM t1;
115 c1
116 100
117 11
118 DROP TABLE t1;
119 CREATE TABLE t1(c1 FLOAT NULL UNIQUE);
120 INSERT INTO t1 (c1) VALUES(10);
121 INSERT INTO t1 (c1) VALUES(11);
122 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
123 SELECT * FROM t1;
124 c1
125 100
126 11
127 DROP TABLE t1;