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);
8
INSERT INTO t1 (c1) VALUES(10);
11
CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
12
INSERT INTO t1 (c1) VALUES(10);
13
INSERT INTO t1 (c1) VALUES(11);
15
INSERT INTO t1 (c1) VALUES(10);
18
CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
19
INSERT INTO t1 (c1) VALUES(10);
20
INSERT INTO t1 (c1) VALUES(11);
22
INSERT INTO t1 (c1) VALUES(10);
25
CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
26
INSERT INTO t1 (c1) VALUES(10);
27
INSERT INTO t1 (c1) VALUES(11);
29
INSERT INTO t1 (c1) VALUES(10);
32
CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
33
INSERT INTO t1 (c1) VALUES(10);
34
INSERT INTO t1 (c1) VALUES(11);
36
INSERT INTO t1 (c1) VALUES(10);
39
CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
40
INSERT INTO t1 (c1) VALUES(10);
41
INSERT INTO t1 (c1) VALUES(11);
43
INSERT INTO t1 (c1) VALUES(10);
46
CREATE TABLE t1(c1 DECIMAL NOT NULL PRIMARY KEY);
47
INSERT INTO t1 (c1) VALUES(10);
48
INSERT INTO t1 (c1) VALUES(11);
50
INSERT INTO t1 (c1) VALUES(10);
53
CREATE TABLE t1(c1 DEC NOT NULL PRIMARY KEY);
54
INSERT INTO t1 (c1) VALUES(10);
55
INSERT INTO t1 (c1) VALUES(11);
57
INSERT INTO t1 (c1) VALUES(10);
60
CREATE TABLE t1(c1 FIXED NOT NULL PRIMARY KEY);
61
INSERT INTO t1 (c1) VALUES(10);
62
INSERT INTO t1 (c1) VALUES(11);
64
INSERT INTO t1 (c1) VALUES(10);
67
CREATE TABLE t1(c1 NUMERIC NOT NULL PRIMARY KEY);
68
INSERT INTO t1 (c1) VALUES(10);
69
INSERT INTO t1 (c1) VALUES(11);
71
INSERT INTO t1 (c1) VALUES(10);
74
CREATE TABLE t1(c1 DOUBLE NOT NULL PRIMARY KEY);
75
INSERT INTO t1 (c1) VALUES(10);
76
INSERT INTO t1 (c1) VALUES(11);
78
INSERT INTO t1 (c1) VALUES(10);
81
CREATE TABLE t1(c1 REAL NOT NULL PRIMARY KEY);
82
INSERT INTO t1 (c1) VALUES(10);
83
INSERT INTO t1 (c1) VALUES(11);
85
INSERT INTO t1 (c1) VALUES(10);
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);
92
INSERT INTO t1 (c1) VALUES(10);
95
CREATE TABLE t1(c1 FLOAT NOT NULL PRIMARY KEY);
96
INSERT INTO t1 (c1) VALUES(10);
97
INSERT INTO t1 (c1) VALUES(11);
99
INSERT INTO t1 (c1) VALUES(10);