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 IGNORE INTO t1 (c1) VALUES(10);
10
CREATE TABLE t1(c1 SMALLINT NULL UNIQUE);
11
INSERT INTO t1 (c1) VALUES(10);
12
INSERT INTO t1 (c1) VALUES(11);
13
INSERT IGNORE INTO t1 (c1) VALUES(10);
16
CREATE TABLE t1(c1 MEDIUMINT NULL UNIQUE);
17
INSERT INTO t1 (c1) VALUES(10);
18
INSERT INTO t1 (c1) VALUES(11);
19
INSERT IGNORE INTO t1 (c1) VALUES(10);
22
CREATE TABLE t1(c1 INT NULL UNIQUE);
23
INSERT INTO t1 (c1) VALUES(10);
24
INSERT INTO t1 (c1) VALUES(11);
25
INSERT IGNORE INTO t1 (c1) VALUES(10);
28
CREATE TABLE t1(c1 INTEGER NULL UNIQUE);
29
INSERT INTO t1 (c1) VALUES(10);
30
INSERT INTO t1 (c1) VALUES(11);
31
INSERT IGNORE INTO t1 (c1) VALUES(10);
34
CREATE TABLE t1(c1 BIGINT NULL UNIQUE);
35
INSERT INTO t1 (c1) VALUES(10);
36
INSERT INTO t1 (c1) VALUES(11);
37
INSERT IGNORE INTO t1 (c1) VALUES(10);
40
CREATE TABLE t1(c1 DECIMAL NULL UNIQUE);
41
INSERT INTO t1 (c1) VALUES(10);
42
INSERT INTO t1 (c1) VALUES(11);
43
INSERT IGNORE INTO t1 (c1) VALUES(10);
46
CREATE TABLE t1(c1 DEC NULL UNIQUE);
47
INSERT INTO t1 (c1) VALUES(10);
48
INSERT INTO t1 (c1) VALUES(11);
49
INSERT IGNORE INTO t1 (c1) VALUES(10);
52
CREATE TABLE t1(c1 FIXED NULL UNIQUE);
53
INSERT INTO t1 (c1) VALUES(10);
54
INSERT INTO t1 (c1) VALUES(11);
55
INSERT IGNORE INTO t1 (c1) VALUES(10);
58
CREATE TABLE t1(c1 NUMERIC NULL UNIQUE);
59
INSERT INTO t1 (c1) VALUES(10);
60
INSERT INTO t1 (c1) VALUES(11);
61
INSERT IGNORE INTO t1 (c1) VALUES(10);
64
CREATE TABLE t1(c1 DOUBLE NULL UNIQUE);
65
INSERT INTO t1 (c1) VALUES(10);
66
INSERT INTO t1 (c1) VALUES(11);
67
INSERT IGNORE INTO t1 (c1) VALUES(10);
70
CREATE TABLE t1(c1 REAL NULL UNIQUE);
71
INSERT INTO t1 (c1) VALUES(10);
72
INSERT INTO t1 (c1) VALUES(11);
73
INSERT IGNORE INTO t1 (c1) VALUES(10);
76
CREATE TABLE t1(c1 DOUBLE PRECISION NULL UNIQUE);
77
INSERT INTO t1 (c1) VALUES(10);
78
INSERT INTO t1 (c1) VALUES(11);
79
INSERT IGNORE INTO t1 (c1) VALUES(10);
82
CREATE TABLE t1(c1 FLOAT NULL UNIQUE);
83
INSERT INTO t1 (c1) VALUES(10);
84
INSERT INTO t1 (c1) VALUES(11);
85
INSERT IGNORE INTO t1 (c1) VALUES(10);