Debian Codegraph @

mysql-test/suite/engines/funcs/t/in_number_pk_constraint_duplicate_update.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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
8 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
15 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
22 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
29 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
36 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
43 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
50 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
57 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
64 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
71 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
78 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
85 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
92 --sorted_result
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 INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
99 --sorted_result
100 SELECT * FROM t1;
101 DROP TABLE t1;
102