|
1
by brian
clean slate |
1 |
--disable_warnings
|
2 |
DROP TABLE IF EXISTS t1; |
|
3 |
--enable_warnings
|
|
4 |
||
|
396
by Brian Aker
Cleanup tiny and small int. |
5 |
CREATE TABLE t1 (sint8 int not null); |
|
1
by brian
clean slate |
6 |
INSERT INTO t1 VALUES ('0.1'); |
7 |
INSERT INTO t1 VALUES ('0.5'); |
|
8 |
INSERT INTO t1 VALUES ('127.4'); |
|
9 |
INSERT INTO t1 VALUES ('127.5'); |
|
10 |
INSERT INTO t1 VALUES ('-0.1'); |
|
11 |
INSERT INTO t1 VALUES ('-0.5'); |
|
12 |
INSERT INTO t1 VALUES ('-127.4'); |
|
13 |
INSERT INTO t1 VALUES ('-127.5'); |
|
14 |
INSERT INTO t1 VALUES ('-128.4'); |
|
15 |
INSERT INTO t1 VALUES ('-128.5'); |
|
16 |
SELECT * FROM t1; |
|
17 |
DROP TABLE t1; |
|
18 |
||
|
413.2.2
by Brian Aker
Removed UNSIGNED from parser. |
19 |
CREATE TABLE t1 (uint8 int not null); |
|
1
by brian
clean slate |
20 |
INSERT INTO t1 VALUES ('0.1'); |
21 |
INSERT INTO t1 VALUES ('0.5'); |
|
22 |
INSERT INTO t1 VALUES ('127.4'); |
|
23 |
INSERT INTO t1 VALUES ('127.5'); |
|
24 |
INSERT INTO t1 VALUES ('-0.1'); |
|
25 |
INSERT INTO t1 VALUES ('-0.5'); |
|
26 |
INSERT INTO t1 VALUES ('255.4'); |
|
27 |
INSERT INTO t1 VALUES ('255.5'); |
|
28 |
SELECT * FROM t1; |
|
29 |
DROP TABLE t1; |
|
30 |
||
31 |
||
|
396
by Brian Aker
Cleanup tiny and small int. |
32 |
CREATE TABLE t1 (sint16 int not null); |
|
1
by brian
clean slate |
33 |
INSERT INTO t1 VALUES ('0.1'); |
34 |
INSERT INTO t1 VALUES ('0.5'); |
|
35 |
INSERT INTO t1 VALUES ('32767.4'); |
|
36 |
INSERT INTO t1 VALUES ('32767.5'); |
|
37 |
INSERT INTO t1 VALUES ('-0.1'); |
|
38 |
INSERT INTO t1 VALUES ('-0.5'); |
|
39 |
INSERT INTO t1 VALUES ('-32767.4'); |
|
40 |
INSERT INTO t1 VALUES ('-32767.5'); |
|
41 |
INSERT INTO t1 VALUES ('-32768.4'); |
|
42 |
INSERT INTO t1 VALUES ('-32768.5'); |
|
43 |
SELECT * FROM t1; |
|
44 |
DROP TABLE t1; |
|
45 |
||
46 |
||
|
413.2.2
by Brian Aker
Removed UNSIGNED from parser. |
47 |
CREATE TABLE t1 (uint16 int not null); |
|
1
by brian
clean slate |
48 |
INSERT INTO t1 VALUES ('0.1'); |
49 |
INSERT INTO t1 VALUES ('0.5'); |
|
50 |
INSERT INTO t1 VALUES ('32767.4'); |
|
51 |
INSERT INTO t1 VALUES ('32767.5'); |
|
52 |
INSERT INTO t1 VALUES ('-0.1'); |
|
53 |
INSERT INTO t1 VALUES ('-0.5'); |
|
54 |
INSERT INTO t1 VALUES ('65535.4'); |
|
55 |
INSERT INTO t1 VALUES ('65535.5'); |
|
56 |
SELECT * FROM t1; |
|
57 |
DROP TABLE t1; |
|
58 |
||
|
520.1.10
by Brian Aker
Adding back more tests. |
59 |
CREATE TABLE t1 (sint24 int not null); |
|
1
by brian
clean slate |
60 |
INSERT INTO t1 VALUES ('0.1'); |
61 |
INSERT INTO t1 VALUES ('0.5'); |
|
62 |
INSERT INTO t1 VALUES ('8388607.4'); |
|
63 |
INSERT INTO t1 VALUES ('8388607.5'); |
|
64 |
INSERT INTO t1 VALUES ('-0.1'); |
|
65 |
INSERT INTO t1 VALUES ('-0.5'); |
|
66 |
INSERT INTO t1 VALUES ('-8388607.4'); |
|
67 |
INSERT INTO t1 VALUES ('-8388607.5'); |
|
68 |
INSERT INTO t1 VALUES ('-8388608.4'); |
|
69 |
INSERT INTO t1 VALUES ('-8388608.5'); |
|
70 |
SELECT * FROM t1; |
|
71 |
DROP TABLE t1; |
|
72 |
||
|
520.1.10
by Brian Aker
Adding back more tests. |
73 |
CREATE TABLE t1 (uint24 int not null); |
|
1
by brian
clean slate |
74 |
INSERT INTO t1 VALUES ('0.1'); |
75 |
INSERT INTO t1 VALUES ('0.5'); |
|
76 |
INSERT INTO t1 VALUES ('8388607.4'); |
|
77 |
INSERT INTO t1 VALUES ('8388607.5'); |
|
78 |
INSERT INTO t1 VALUES ('-0.1'); |
|
79 |
INSERT INTO t1 VALUES ('-0.5'); |
|
80 |
INSERT INTO t1 VALUES ('16777215.4'); |
|
81 |
INSERT INTO t1 VALUES ('16777215.5'); |
|
82 |
SELECT * FROM t1; |
|
83 |
DROP TABLE t1; |
|
84 |
||
85 |
CREATE TABLE t1 (sint64 bigint not null); |
|
86 |
INSERT INTO t1 VALUES ('0.1'); |
|
87 |
INSERT INTO t1 VALUES ('0.5'); |
|
88 |
INSERT INTO t1 VALUES ('9223372036854775807.4'); |
|
|
520.1.10
by Brian Aker
Adding back more tests. |
89 |
INSERT INTO t1 VALUES ('9223372036854775806.5'); |
|
1
by brian
clean slate |
90 |
INSERT INTO t1 VALUES ('-0.1'); |
91 |
INSERT INTO t1 VALUES ('-0.5'); |
|
92 |
INSERT INTO t1 VALUES ('-9223372036854775807.4'); |
|
93 |
INSERT INTO t1 VALUES ('-9223372036854775807.5'); |
|
94 |
INSERT INTO t1 VALUES ('-9223372036854775808.4'); |
|
|
520.1.10
by Brian Aker
Adding back more tests. |
95 |
INSERT INTO t1 VALUES ('-9223372036854775802.5'); |
|
1
by brian
clean slate |
96 |
SELECT * FROM t1; |
97 |
DROP TABLE t1; |
|
98 |
||
|
413.2.2
by Brian Aker
Removed UNSIGNED from parser. |
99 |
CREATE TABLE t1 (uint64 bigint not null); |
|
1
by brian
clean slate |
100 |
INSERT INTO t1 VALUES ('0.1'); |
101 |
INSERT INTO t1 VALUES ('0.5'); |
|
102 |
INSERT INTO t1 VALUES ('9223372036854775807.4'); |
|
|
520.1.10
by Brian Aker
Adding back more tests. |
103 |
--error 1264
|
|
1
by brian
clean slate |
104 |
INSERT INTO t1 VALUES ('9223372036854775807.5'); |
105 |
INSERT INTO t1 VALUES ('-0.1'); |
|
106 |
INSERT INTO t1 VALUES ('-0.5'); |
|
|
520.1.10
by Brian Aker
Adding back more tests. |
107 |
--error 1264
|
|
1
by brian
clean slate |
108 |
INSERT INTO t1 VALUES ('18446744073709551615.4'); |
109 |
SELECT * FROM t1; |
|
110 |
DROP TABLE t1; |
|
111 |
||
112 |
CREATE TABLE t1 (str varchar(128), sint64 bigint not null default 0); |
|
113 |
INSERT INTO t1 (str) VALUES ('1.5'); |
|
114 |
INSERT INTO t1 (str) VALUES ('1.00005e4'); |
|
115 |
INSERT INTO t1 (str) VALUES ('1.0005e3'); |
|
116 |
INSERT INTO t1 (str) VALUES ('1.005e2'); |
|
117 |
INSERT INTO t1 (str) VALUES ('1.05e1'); |
|
118 |
INSERT INTO t1 (str) VALUES ('1.5e0'); |
|
119 |
INSERT INTO t1 (str) VALUES ('100005e-1'); |
|
120 |
INSERT INTO t1 (str) VALUES ('100050e-2'); |
|
121 |
INSERT INTO t1 (str) VALUES ('100500e-3'); |
|
122 |
INSERT INTO t1 (str) VALUES ('105000e-4'); |
|
123 |
INSERT INTO t1 (str) VALUES ('150000e-5'); |
|
124 |
UPDATE t1 SET sint64=str; |
|
125 |
SELECT * FROM t1; |
|
126 |
DROP TABLE t1; |
|
127 |
||
128 |