1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1 (sint8 int not null);
3
INSERT INTO t1 VALUES ('0.1');
4
INSERT INTO t1 VALUES ('0.5');
5
INSERT INTO t1 VALUES ('127.4');
6
INSERT INTO t1 VALUES ('127.5');
7
INSERT INTO t1 VALUES ('-0.1');
8
INSERT INTO t1 VALUES ('-0.5');
9
INSERT INTO t1 VALUES ('-127.4');
10
INSERT INTO t1 VALUES ('-127.5');
11
INSERT INTO t1 VALUES ('-128.4');
12
INSERT INTO t1 VALUES ('-128.5');
26
CREATE TABLE t1 (uint8 int not null);
27
INSERT INTO t1 VALUES ('0.1');
28
INSERT INTO t1 VALUES ('0.5');
29
INSERT INTO t1 VALUES ('127.4');
30
INSERT INTO t1 VALUES ('127.5');
31
INSERT INTO t1 VALUES ('-0.1');
32
INSERT INTO t1 VALUES ('-0.5');
33
INSERT INTO t1 VALUES ('255.4');
34
INSERT INTO t1 VALUES ('255.5');
46
CREATE TABLE t1 (sint16 int not null);
47
INSERT INTO t1 VALUES ('0.1');
48
INSERT INTO t1 VALUES ('0.5');
49
INSERT INTO t1 VALUES ('32767.4');
50
INSERT INTO t1 VALUES ('32767.5');
51
INSERT INTO t1 VALUES ('-0.1');
52
INSERT INTO t1 VALUES ('-0.5');
53
INSERT INTO t1 VALUES ('-32767.4');
54
INSERT INTO t1 VALUES ('-32767.5');
55
INSERT INTO t1 VALUES ('-32768.4');
56
INSERT INTO t1 VALUES ('-32768.5');
70
CREATE TABLE t1 (uint16 int not null);
71
INSERT INTO t1 VALUES ('0.1');
72
INSERT INTO t1 VALUES ('0.5');
73
INSERT INTO t1 VALUES ('32767.4');
74
INSERT INTO t1 VALUES ('32767.5');
75
INSERT INTO t1 VALUES ('-0.1');
76
INSERT INTO t1 VALUES ('-0.5');
77
INSERT INTO t1 VALUES ('65535.4');
78
INSERT INTO t1 VALUES ('65535.5');
90
CREATE TABLE t1 (sint24 int not null);
91
INSERT INTO t1 VALUES ('0.1');
92
INSERT INTO t1 VALUES ('0.5');
93
INSERT INTO t1 VALUES ('8388607.4');
94
INSERT INTO t1 VALUES ('8388607.5');
95
INSERT INTO t1 VALUES ('-0.1');
96
INSERT INTO t1 VALUES ('-0.5');
97
INSERT INTO t1 VALUES ('-8388607.4');
98
INSERT INTO t1 VALUES ('-8388607.5');
99
INSERT INTO t1 VALUES ('-8388608.4');
100
INSERT INTO t1 VALUES ('-8388608.5');
114
CREATE TABLE t1 (uint24 int not null);
115
INSERT INTO t1 VALUES ('0.1');
116
INSERT INTO t1 VALUES ('0.5');
117
INSERT INTO t1 VALUES ('8388607.4');
118
INSERT INTO t1 VALUES ('8388607.5');
119
INSERT INTO t1 VALUES ('-0.1');
120
INSERT INTO t1 VALUES ('-0.5');
121
INSERT INTO t1 VALUES ('16777215.4');
122
INSERT INTO t1 VALUES ('16777215.5');
134
CREATE TABLE t1 (sint64 bigint not null);
135
INSERT INTO t1 VALUES ('0.1');
136
INSERT INTO t1 VALUES ('0.5');
137
INSERT INTO t1 VALUES ('9223372036854775807.4');
138
INSERT INTO t1 VALUES ('9223372036854775806.5');
139
INSERT INTO t1 VALUES ('-0.1');
140
INSERT INTO t1 VALUES ('-0.5');
141
INSERT INTO t1 VALUES ('-9223372036854775807.4');
142
INSERT INTO t1 VALUES ('-9223372036854775807.5');
143
INSERT INTO t1 VALUES ('-9223372036854775808.4');
144
INSERT INTO t1 VALUES ('-9223372036854775802.5');
158
CREATE TABLE t1 (uint64 bigint not null);
159
INSERT INTO t1 VALUES ('0.1');
160
INSERT INTO t1 VALUES ('0.5');
161
INSERT INTO t1 VALUES ('9223372036854775807.4');
162
INSERT INTO t1 VALUES ('9223372036854775807.5');
163
ERROR 22003: Out of range value for column 'uint64' at row 1
164
INSERT INTO t1 VALUES ('-0.1');
165
INSERT INTO t1 VALUES ('-0.5');
166
INSERT INTO t1 VALUES ('18446744073709551615.4');
167
ERROR 22003: Out of range value for column 'uint64' at row 1
176
CREATE TABLE t1 (str varchar(128), sint64 bigint not null default 0);
177
INSERT INTO t1 (str) VALUES ('1.5');
178
INSERT INTO t1 (str) VALUES ('1.00005e4');
179
INSERT INTO t1 (str) VALUES ('1.0005e3');
180
INSERT INTO t1 (str) VALUES ('1.005e2');
181
INSERT INTO t1 (str) VALUES ('1.05e1');
182
INSERT INTO t1 (str) VALUES ('1.5e0');
183
INSERT INTO t1 (str) VALUES ('100005e-1');
184
INSERT INTO t1 (str) VALUES ('100050e-2');
185
INSERT INTO t1 (str) VALUES ('100500e-3');
186
INSERT INTO t1 (str) VALUES ('105000e-4');
187
INSERT INTO t1 (str) VALUES ('150000e-5');
188
UPDATE t1 SET sint64=str;