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);
11 CREATE TABLE t1(c1 SMALLINT NULL UNIQUE);
12 INSERT INTO t1 (c1) VALUES(10);
13 INSERT INTO t1 (c1) VALUES(11);
14 INSERT IGNORE INTO t1 (c1) VALUES(10);
20 CREATE TABLE t1(c1 MEDIUMINT NULL UNIQUE);
21 INSERT INTO t1 (c1) VALUES(10);
22 INSERT INTO t1 (c1) VALUES(11);
23 INSERT IGNORE INTO t1 (c1) VALUES(10);
29 CREATE TABLE t1(c1 INT NULL UNIQUE);
30 INSERT INTO t1 (c1) VALUES(10);
31 INSERT INTO t1 (c1) VALUES(11);
32 INSERT IGNORE INTO t1 (c1) VALUES(10);
38 CREATE TABLE t1(c1 INTEGER NULL UNIQUE);
39 INSERT INTO t1 (c1) VALUES(10);
40 INSERT INTO t1 (c1) VALUES(11);
41 INSERT IGNORE INTO t1 (c1) VALUES(10);
47 CREATE TABLE t1(c1 BIGINT NULL UNIQUE);
48 INSERT INTO t1 (c1) VALUES(10);
49 INSERT INTO t1 (c1) VALUES(11);
50 INSERT IGNORE INTO t1 (c1) VALUES(10);
56 CREATE TABLE t1(c1 DECIMAL NULL UNIQUE);
57 INSERT INTO t1 (c1) VALUES(10);
58 INSERT INTO t1 (c1) VALUES(11);
59 INSERT IGNORE INTO t1 (c1) VALUES(10);
65 CREATE TABLE t1(c1 DEC NULL UNIQUE);
66 INSERT INTO t1 (c1) VALUES(10);
67 INSERT INTO t1 (c1) VALUES(11);
68 INSERT IGNORE INTO t1 (c1) VALUES(10);
74 CREATE TABLE t1(c1 FIXED NULL UNIQUE);
75 INSERT INTO t1 (c1) VALUES(10);
76 INSERT INTO t1 (c1) VALUES(11);
77 INSERT IGNORE INTO t1 (c1) VALUES(10);
83 CREATE TABLE t1(c1 NUMERIC NULL UNIQUE);
84 INSERT INTO t1 (c1) VALUES(10);
85 INSERT INTO t1 (c1) VALUES(11);
86 INSERT IGNORE INTO t1 (c1) VALUES(10);
92 CREATE TABLE t1(c1 DOUBLE NULL UNIQUE);
93 INSERT INTO t1 (c1) VALUES(10);
94 INSERT INTO t1 (c1) VALUES(11);
95 INSERT IGNORE INTO t1 (c1) VALUES(10);
101 CREATE TABLE t1(c1 REAL NULL UNIQUE);
102 INSERT INTO t1 (c1) VALUES(10);
103 INSERT INTO t1 (c1) VALUES(11);
104 INSERT IGNORE INTO t1 (c1) VALUES(10);
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 IGNORE INTO t1 (c1) VALUES(10);
119 CREATE TABLE t1(c1 FLOAT NULL UNIQUE);
120 INSERT INTO t1 (c1) VALUES(10);
121 INSERT INTO t1 (c1) VALUES(11);
122 INSERT IGNORE INTO t1 (c1) VALUES(10);