2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 TINYINT NULL UNIQUE);
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;
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;
18
CREATE TABLE t1(c1 MEDIUMINT NULL UNIQUE);
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;
25
CREATE TABLE t1(c1 INT NULL UNIQUE);
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;
32
CREATE TABLE t1(c1 INTEGER NULL UNIQUE);
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;
39
CREATE TABLE t1(c1 BIGINT NULL UNIQUE);
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;
46
CREATE TABLE t1(c1 DECIMAL NULL UNIQUE);
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;
53
CREATE TABLE t1(c1 DEC NULL UNIQUE);
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;
60
CREATE TABLE t1(c1 FIXED NULL UNIQUE);
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;
67
CREATE TABLE t1(c1 NUMERIC NULL UNIQUE);
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;
74
CREATE TABLE t1(c1 DOUBLE 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;
81
CREATE TABLE t1(c1 REAL NULL UNIQUE);
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;
88
CREATE TABLE t1(c1 DOUBLE PRECISION NULL UNIQUE);
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;
95
CREATE TABLE t1(c1 FLOAT NULL UNIQUE);
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;