2 DROP TABLE IF EXISTS t1;
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 IGNORE INTO t1 (c1) VALUES(10);
10 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
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 NOT NULL PRIMARY KEY);
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 NOT NULL PRIMARY KEY);
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 NOT NULL PRIMARY KEY);
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 NOT NULL PRIMARY KEY);
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 NOT NULL PRIMARY KEY);
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 NOT NULL PRIMARY KEY);
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 NOT NULL PRIMARY KEY);
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 NOT NULL PRIMARY KEY);
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 NOT NULL PRIMARY KEY);
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 NOT NULL PRIMARY KEY);
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 NOT NULL PRIMARY KEY);
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 NOT NULL PRIMARY KEY);
83 INSERT INTO t1 (c1) VALUES(10);
84 INSERT INTO t1 (c1) VALUES(11);
85 INSERT IGNORE INTO t1 (c1) VALUES(10);