|
1
by brian
clean slate |
1 |
drop table if exists t1, t2;
|
2 |
select 0,256,00000000000000065536,2147483647,-2147483648,2147483648,+4294967296;
|
|
3 |
0 256 00000000000000065536 2147483647 -2147483648 2147483648 4294967296
|
|
4 |
0 256 65536 2147483647 -2147483648 2147483648 4294967296
|
|
5 |
select 9223372036854775807,-009223372036854775808;
|
|
6 |
9223372036854775807 -009223372036854775808
|
|
7 |
9223372036854775807 -9223372036854775808
|
|
8 |
select +9999999999999999999,-9999999999999999999;
|
|
9 |
9999999999999999999 -9999999999999999999
|
|
10 |
9999999999999999999 -9999999999999999999
|
|
|
520.1.8
by Brian Aker
Updating tests. |
11 |
select 9223372036854775808 +1;
|
12 |
9223372036854775808 +1
|
|
|
1
by brian
clean slate |
13 |
9223372036854775809
|
14 |
select 9223372036854775808+1;
|
|
15 |
9223372036854775808+1
|
|
16 |
9223372036854775809
|
|
17 |
select -(0-3),round(-(0-3)), round(9999999999999999999);
|
|
18 |
-(0-3) round(-(0-3)) round(9999999999999999999)
|
|
19 |
3 3 9999999999999999999
|
|
20 |
select 1,11,101,1001,10001,100001,1000001,10000001,100000001,1000000001,10000000001,100000000001,1000000000001,10000000000001,100000000000001,1000000000000001,10000000000000001,100000000000000001,1000000000000000001,10000000000000000001;
|
|
21 |
1 11 101 1001 10001 100001 1000001 10000001 100000001 1000000001 10000000001 100000000001 1000000000001 10000000000001 100000000000001 1000000000000001 10000000000000001 100000000000000001 1000000000000000001 10000000000000000001
|
|
22 |
1 11 101 1001 10001 100001 1000001 10000001 100000001 1000000001 10000000001 100000000001 1000000000001 10000000000001 100000000000001 1000000000000001 10000000000000001 100000000000000001 1000000000000000001 10000000000000000001
|
|
23 |
select -1,-11,-101,-1001,-10001,-100001,-1000001,-10000001,-100000001,-1000000001,-10000000001,-100000000001,-1000000000001,-10000000000001,-100000000000001,-1000000000000001,-10000000000000001,-100000000000000001,-1000000000000000001,-10000000000000000001;
|
|
24 |
-1 -11 -101 -1001 -10001 -100001 -1000001 -10000001 -100000001 -1000000001 -10000000001 -100000000001 -1000000000001 -10000000000001 -100000000000001 -1000000000000001 -10000000000000001 -100000000000000001 -1000000000000000001 -10000000000000000001
|
|
25 |
-1 -11 -101 -1001 -10001 -100001 -1000001 -10000001 -100000001 -1000000001 -10000000001 -100000000001 -1000000000001 -10000000000001 -100000000000001 -1000000000000001 -10000000000000001 -100000000000000001 -1000000000000000001 -10000000000000000001
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
26 |
create table t1 (a bigint unsigned not null, primary key(a));
|
|
520.1.8
by Brian Aker
Updating tests. |
27 |
insert into t1 values (9223372036854775808);
|
28 |
insert into t1 values (0x7000000000000000);
|
|
|
1
by brian
clean slate |
29 |
select * from t1;
|
30 |
a
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
31 |
8070450532247928832
|
|
520.1.8
by Brian Aker
Updating tests. |
32 |
-9223372036854775808
|
|
1
by brian
clean slate |
33 |
select * from t1 where a=18446744073709551615;
|
34 |
a
|
|
35 |
delete from t1 where a=18446744073709551615;
|
|
36 |
select * from t1;
|
|
37 |
a
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
38 |
8070450532247928832
|
|
520.1.8
by Brian Aker
Updating tests. |
39 |
-9223372036854775808
|
|
1
by brian
clean slate |
40 |
drop table t1;
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
41 |
create table t1 ( a int not null default 1, big bigint unsigned);
|
|
520.1.8
by Brian Aker
Updating tests. |
42 |
insert into t1 (big) values (-1),(9223372036854775808),(9223372036854775807),(9223372036854775808);
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
43 |
ERROR 22003: Out of range value for column 'big' at row 1
|
44 |
insert into t1 (big) values (-1);
|
|
45 |
ERROR 22003: Out of range value for column 'big' at row 1
|
|
46 |
insert into t1 (big) values (9223372036854775808),(9223372036854775807),(9223372036854775808);
|
|
|
520.1.8
by Brian Aker
Updating tests. |
47 |
select * from t1;
|
48 |
a big
|
|
49 |
1 -9223372036854775808
|
|
50 |
1 9223372036854775807
|
|
51 |
1 -9223372036854775808
|
|
52 |
select min(big),max(big),max(big)-1 from t1;
|
|
53 |
min(big) max(big) max(big)-1
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
54 |
9223372036854775807 9223372036854775808 9223372036854775807
|
|
520.1.8
by Brian Aker
Updating tests. |
55 |
select min(big),max(big),max(big)-1 from t1 group by a;
|
56 |
min(big) max(big) max(big)-1
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
57 |
9223372036854775807 -9223372036854775808 9223372036854775807
|
|
520.1.8
by Brian Aker
Updating tests. |
58 |
alter table t1 modify big bigint not null;
|
59 |
select min(big),max(big),max(big)-1 from t1;
|
|
60 |
min(big) max(big) max(big)-1
|
|
61 |
-9223372036854775808 9223372036854775807 9223372036854775806
|
|
62 |
select min(big),max(big),max(big)-1 from t1 group by a;
|
|
63 |
min(big) max(big) max(big)-1
|
|
64 |
-9223372036854775808 9223372036854775807 9223372036854775806
|
|
65 |
insert into t1 (big) values (9223372036854775808);
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
66 |
ERROR 22003: Out of range value for column 'big' at row 1
|
|
520.1.8
by Brian Aker
Updating tests. |
67 |
select * from t1;
|
68 |
a big
|
|
69 |
1 -9223372036854775808
|
|
70 |
1 9223372036854775807
|
|
71 |
1 -9223372036854775808
|
|
72 |
select min(big),max(big),max(big)-1 from t1;
|
|
73 |
min(big) max(big) max(big)-1
|
|
74 |
-9223372036854775808 9223372036854775807 9223372036854775806
|
|
75 |
select min(big),max(big),max(big)-1 from t1 group by a;
|
|
76 |
min(big) max(big) max(big)-1
|
|
77 |
-9223372036854775808 9223372036854775807 9223372036854775806
|
|
|
1
by brian
clean slate |
78 |
alter table t1 add key (big);
|
79 |
select min(big),max(big),max(big)-1 from t1;
|
|
80 |
min(big) max(big) max(big)-1
|
|
|
520.1.8
by Brian Aker
Updating tests. |
81 |
-9223372036854775808 9223372036854775807 9223372036854775806
|
|
1
by brian
clean slate |
82 |
select min(big),max(big),max(big)-1 from t1 group by a;
|
83 |
min(big) max(big) max(big)-1
|
|
|
520.1.8
by Brian Aker
Updating tests. |
84 |
-9223372036854775808 9223372036854775807 9223372036854775806
|
|
1
by brian
clean slate |
85 |
alter table t1 modify big bigint not null;
|
86 |
select * from t1;
|
|
87 |
a big
|
|
|
520.1.8
by Brian Aker
Updating tests. |
88 |
1 -9223372036854775808
|
89 |
1 9223372036854775807
|
|
90 |
1 -9223372036854775808
|
|
|
1
by brian
clean slate |
91 |
select min(big),max(big),max(big)-1 from t1;
|
92 |
min(big) max(big) max(big)-1
|
|
|
520.1.8
by Brian Aker
Updating tests. |
93 |
-9223372036854775808 9223372036854775807 9223372036854775806
|
|
1
by brian
clean slate |
94 |
select min(big),max(big),max(big)-1 from t1 group by a;
|
95 |
min(big) max(big) max(big)-1
|
|
|
520.1.8
by Brian Aker
Updating tests. |
96 |
-9223372036854775808 9223372036854775807 9223372036854775806
|
|
1
by brian
clean slate |
97 |
drop table t1;
|
98 |
create table t1 (id bigint auto_increment primary key, a int) auto_increment=9999999999;
|
|
99 |
insert into t1 values (null,1);
|
|
100 |
select * from t1;
|
|
101 |
id a
|
|
102 |
9999999999 1
|
|
103 |
select * from t1 limit 9999999999;
|
|
104 |
id a
|
|
105 |
9999999999 1
|
|
106 |
drop table t1;
|
|
107 |
CREATE TABLE t1 ( quantity decimal(60,0));
|
|
108 |
insert into t1 values (10000000000000000000);
|
|
109 |
insert into t1 values (10000000000000000000.0);
|
|
110 |
insert into t1 values ('10000000000000000000');
|
|
111 |
select * from t1;
|
|
112 |
quantity
|
|
113 |
10000000000000000000
|
|
114 |
10000000000000000000
|
|
115 |
10000000000000000000
|
|
116 |
drop table t1;
|
|
117 |
SELECT '0x8000000000000001'+0;
|
|
118 |
'0x8000000000000001'+0
|
|
119 |
0
|
|
120 |
Warnings:
|
|
121 |
Warning 1292 Truncated incorrect DOUBLE value: '0x8000000000000001'
|
|
122 |
create table t1 (
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
123 |
value64 bigint unsigned not null,
|
|
1
by brian
clean slate |
124 |
value32 integer not null,
|
125 |
primary key(value64, value32)
|
|
126 |
);
|
|
127 |
create table t2 (
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
128 |
value64 bigint unsigned not null,
|
|
1
by brian
clean slate |
129 |
value32 integer not null,
|
130 |
primary key(value64, value32)
|
|
131 |
);
|
|
132 |
insert into t1 values(17156792991891826145, 1);
|
|
133 |
insert into t1 values( 9223372036854775807, 2);
|
|
134 |
insert into t2 values(17156792991891826145, 3);
|
|
135 |
insert into t2 values( 9223372036854775807, 4);
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
136 |
select * from t1 ORDER BY value32;
|
|
1
by brian
clean slate |
137 |
value64 value32
|
|
520.1.8
by Brian Aker
Updating tests. |
138 |
-1289951081817725471 1
|
|
1
by brian
clean slate |
139 |
9223372036854775807 2
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
140 |
select * from t2 ORDER BY value32;
|
|
1
by brian
clean slate |
141 |
value64 value32
|
|
520.1.8
by Brian Aker
Updating tests. |
142 |
-1289951081817725471 3
|
|
1
by brian
clean slate |
143 |
9223372036854775807 4
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
144 |
select * from t1, t2 where t1.value64=17156792991891826145 and t2.value64=17156792991891826145;
|
145 |
value64 value32 value64 value32
|
|
146 |
-1289951081817725471 1 -1289951081817725471 3
|
|
147 |
select * from t1, t2 where t1.value64=17156792991891826145 and t2.value64=t1.value64;
|
|
148 |
value64 value32 value64 value32
|
|
149 |
-1289951081817725471 1 -1289951081817725471 3
|
|
150 |
select * from t1, t2 where t1.value64= 9223372036854775807 and t2.value64=9223372036854775807;
|
|
|
1
by brian
clean slate |
151 |
value64 value32 value64 value32
|
152 |
9223372036854775807 2 9223372036854775807 4
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
153 |
select * from t1, t2 where t1.value64= 9223372036854775807 and t2.value64=t1.value64;
|
|
1
by brian
clean slate |
154 |
value64 value32 value64 value32
|
155 |
9223372036854775807 2 9223372036854775807 4
|
|
156 |
drop table t1, t2;
|
|
157 |
create table t1 (sint64 bigint not null);
|
|
158 |
insert into t1 values (-9223372036854775808);
|
|
159 |
select * from t1;
|
|
160 |
sint64
|
|
161 |
-9223372036854775808
|
|
162 |
drop table t1;
|
|
163 |
create table t1 select 1 as 'a';
|
|
164 |
show create table t1;
|
|
165 |
Table Create Table
|
|
166 |
t1 CREATE TABLE `t1` (
|
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
167 |
`a` INT NOT NULL
|
|
1638.10.56
by Stewart Smith
bigint.result with explicit COLLATE in SHOW CREATE TABLE |
168 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
|
1
by brian
clean slate |
169 |
drop table t1;
|
170 |
create table t1 select 9223372036854775809 as 'a';
|
|
171 |
show create table t1;
|
|
172 |
Table Create Table
|
|
173 |
t1 CREATE TABLE `t1` (
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
174 |
`a` BIGINT UNSIGNED NOT NULL
|
175 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
|
176 |
drop table t1;
|
|
177 |
create table t1 select 72036854775809 as 'a';
|
|
178 |
show create table t1;
|
|
179 |
Table Create Table
|
|
180 |
t1 CREATE TABLE `t1` (
|
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
181 |
`a` BIGINT NOT NULL
|
|
1638.10.56
by Stewart Smith
bigint.result with explicit COLLATE in SHOW CREATE TABLE |
182 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
|
1
by brian
clean slate |
183 |
select * from t1;
|
184 |
a
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
185 |
72036854775809
|
|
1
by brian
clean slate |
186 |
drop table t1;
|
187 |
DROP DATABASE IF EXISTS `scott`;
|
|
188 |
Warnings:
|
|
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
189 |
Note 1008 Can't drop schema 'scott'; schema doesn't exist
|
|
1
by brian
clean slate |
190 |
create table t1 (a char(100), b varchar(100), c text, d blob);
|
191 |
insert into t1 values(
|
|
192 |
18446744073709551615,18446744073709551615,
|
|
193 |
18446744073709551615, 18446744073709551615
|
|
194 |
);
|
|
|
520.1.8
by Brian Aker
Updating tests. |
195 |
insert into t1 values (-1,-1,-1,-1);
|
|
1
by brian
clean slate |
196 |
select * from t1;
|
197 |
a b c d
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
198 |
-1 -1 -1 -1
|
|
1
by brian
clean slate |
199 |
18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
|
200 |
drop table t1;
|
|
|
520.1.8
by Brian Aker
Updating tests. |
201 |
create table t1 ( quantity decimal(2));
|
202 |
insert into t1 values (50), (-50), (0), (-1);
|
|
|
1
by brian
clean slate |
203 |
select * from t1;
|
204 |
quantity
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
205 |
-1
|
206 |
-50
|
|
207 |
0
|
|
|
520.1.8
by Brian Aker
Updating tests. |
208 |
50
|
|
1
by brian
clean slate |
209 |
drop table t1;
|
210 |
CREATE TABLE t1 (
|
|
|
520.1.8
by Brian Aker
Updating tests. |
211 |
`col1` INT NULL,
|
212 |
`col2` INT NULL,
|
|
213 |
`col3` INT NULL,
|
|
214 |
`col4` INT NULL,
|
|
215 |
`col5` INT NULL,
|
|
216 |
`col6` INT NULL,
|
|
217 |
`col7` INT NULL,
|
|
218 |
`col8` INT NULL,
|
|
219 |
`col9` INT NULL,
|
|
220 |
`col10` BIGINT NULL,
|
|
221 |
`col11` BIGINT NULL,
|
|
222 |
`col12` BIGINT NULL,
|
|
223 |
`col13` BIGINT NULL,
|
|
224 |
`col14` BIGINT NULL,
|
|
225 |
`col15` BIGINT NULL,
|
|
226 |
`col16` BIGINT NULL,
|
|
227 |
`col17` BIGINT NULL,
|
|
228 |
`col18` BIGINT NULL,
|
|
|
1
by brian
clean slate |
229 |
`col19` DECIMAL(19, 0) NULL,
|
230 |
`col20` DECIMAL(20, 0) NULL,
|
|
231 |
`col21` DECIMAL(21, 0) NULL,
|
|
232 |
`col22` DECIMAL(22, 0) NULL,
|
|
233 |
`col23` DECIMAL(23, 0) NULL,
|
|
234 |
`col24` DECIMAL(24, 0) NULL,
|
|
235 |
`col25` DECIMAL(25, 0) NULL,
|
|
236 |
`col26` DECIMAL(26, 0) NULL,
|
|
237 |
`col27` DECIMAL(27, 0) NULL,
|
|
238 |
`col28` DECIMAL(28, 0) NULL,
|
|
239 |
`col29` DECIMAL(29, 0) NULL,
|
|
240 |
`col30` DECIMAL(30, 0) NULL,
|
|
241 |
`col31` DECIMAL(31, 0) NULL,
|
|
242 |
`col32` DECIMAL(32, 0) NULL,
|
|
243 |
`col33` DECIMAL(33, 0) NULL,
|
|
244 |
`col34` DECIMAL(34, 0) NULL,
|
|
245 |
`col35` DECIMAL(35, 0) NULL,
|
|
246 |
`col36` DECIMAL(36, 0) NULL,
|
|
247 |
`col37` DECIMAL(37, 0) NULL,
|
|
248 |
`col38` DECIMAL(38, 0) NULL,
|
|
249 |
`fix1` DECIMAL(38, 1) NULL,
|
|
250 |
`fix2` DECIMAL(38, 2) NULL,
|
|
251 |
`fix3` DECIMAL(38, 3) NULL,
|
|
252 |
`fix4` DECIMAL(38, 4) NULL,
|
|
253 |
`fix5` DECIMAL(38, 5) NULL,
|
|
254 |
`fix6` DECIMAL(38, 6) NULL,
|
|
255 |
`fix7` DECIMAL(38, 7) NULL,
|
|
256 |
`fix8` DECIMAL(38, 8) NULL,
|
|
257 |
`fix9` DECIMAL(38, 9) NULL,
|
|
258 |
`fix10` DECIMAL(38, 10) NULL,
|
|
259 |
`fix11` DECIMAL(38, 11) NULL,
|
|
260 |
`fix12` DECIMAL(38, 12) NULL,
|
|
261 |
`fix13` DECIMAL(38, 13) NULL,
|
|
262 |
`fix14` DECIMAL(38, 14) NULL,
|
|
263 |
`fix15` DECIMAL(38, 15) NULL,
|
|
264 |
`fix16` DECIMAL(38, 16) NULL,
|
|
265 |
`fix17` DECIMAL(38, 17) NULL,
|
|
266 |
`fix18` DECIMAL(38, 18) NULL,
|
|
267 |
`fix19` DECIMAL(38, 19) NULL,
|
|
268 |
`fix20` DECIMAL(38, 20) NULL,
|
|
269 |
`fix21` DECIMAL(38, 21) NULL,
|
|
270 |
`fix22` DECIMAL(38, 22) NULL,
|
|
271 |
`fix23` DECIMAL(38, 23) NULL,
|
|
272 |
`fix24` DECIMAL(38, 24) NULL,
|
|
273 |
`fix25` DECIMAL(38, 25) NULL,
|
|
274 |
`fix26` DECIMAL(38, 26) NULL,
|
|
275 |
`fix27` DECIMAL(38, 27) NULL,
|
|
276 |
`fix28` DECIMAL(38, 28) NULL,
|
|
277 |
`fix29` DECIMAL(38, 29) NULL,
|
|
278 |
`fix30` DECIMAL(38, 30) NULL
|
|
279 |
);
|
|
280 |
INSERT INTO t1(`col1`, `col2`, `col3`, `col4`, `col5`, `col6`, `col7`, `col8`, `col9`, `col10`, `col11`, `col12`, `col13`, `col14`, `col15`, `col16`, `col17`, `col18`, `col19`, `col20`, `col21`, `col22`, `col23`, `col24`, `col25`, `col26`, `col27`, `col28`, `col29`, `col30`, `col31`, `col32`, `col33`, `col34`, `col35`, `col36`, `col37`, `col38`, `fix1`, `fix2`, `fix3`, `fix4`, `fix5`, `fix6`, `fix7`, `fix8`, `fix9`, `fix10`, `fix11`, `fix12`, `fix13`, `fix14`, `fix15`, `fix16`, `fix17`, `fix18`, `fix19`, `fix20`, `fix21`, `fix22`, `fix23`, `fix24`, `fix25`, `fix26`, `fix27`, `fix28`, `fix29`, `fix30`)
|
|
281 |
VALUES (9, 99, 999, 9999, 99999, 999999, 9999999, 99999999, 999999999,
|
|
282 |
9999999999, 99999999999, 999999999999, 9999999999999, 99999999999999,
|
|
283 |
999999999999999, 9999999999999999, 99999999999999999, 999999999999999999,
|
|
284 |
9999999999999999999, 99999999999999999999, 999999999999999999999,
|
|
285 |
9999999999999999999999, 99999999999999999999999, 999999999999999999999999,
|
|
286 |
9999999999999999999999999, 99999999999999999999999999,
|
|
287 |
999999999999999999999999999, 9999999999999999999999999999,
|
|
288 |
99999999999999999999999999999, 999999999999999999999999999999,
|
|
289 |
9999999999999999999999999999999, 99999999999999999999999999999999,
|
|
290 |
999999999999999999999999999999999, 9999999999999999999999999999999999,
|
|
291 |
99999999999999999999999999999999999, 999999999999999999999999999999999999,
|
|
292 |
9999999999999999999999999999999999999, 99999999999999999999999999999999999999,
|
|
293 |
9999999999999999999999999999999999999.9,
|
|
294 |
999999999999999999999999999999999999.99,
|
|
295 |
99999999999999999999999999999999999.999,
|
|
296 |
9999999999999999999999999999999999.9999,
|
|
297 |
999999999999999999999999999999999.99999,
|
|
298 |
99999999999999999999999999999999.999999,
|
|
299 |
9999999999999999999999999999999.9999999,
|
|
300 |
999999999999999999999999999999.99999999,
|
|
301 |
99999999999999999999999999999.999999999,
|
|
302 |
9999999999999999999999999999.9999999999,
|
|
303 |
999999999999999999999999999.99999999999,
|
|
304 |
99999999999999999999999999.999999999999,
|
|
305 |
9999999999999999999999999.9999999999999,
|
|
306 |
999999999999999999999999.99999999999999,
|
|
307 |
99999999999999999999999.999999999999999,
|
|
308 |
9999999999999999999999.9999999999999999,
|
|
309 |
999999999999999999999.99999999999999999,
|
|
310 |
99999999999999999999.999999999999999999,
|
|
311 |
9999999999999999999.9999999999999999999,
|
|
312 |
999999999999999999.99999999999999999999,
|
|
313 |
99999999999999999.999999999999999999999,
|
|
314 |
9999999999999999.9999999999999999999999,
|
|
315 |
999999999999999.99999999999999999999999,
|
|
316 |
99999999999999.999999999999999999999999,
|
|
317 |
9999999999999.9999999999999999999999999,
|
|
318 |
999999999999.99999999999999999999999999,
|
|
319 |
99999999999.999999999999999999999999999,
|
|
320 |
9999999999.9999999999999999999999999999,
|
|
321 |
999999999.99999999999999999999999999999,
|
|
322 |
99999999.999999999999999999999999999999);
|
|
323 |
SELECT * FROM t1;
|
|
324 |
col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 col14 col15 col16 col17 col18 col19 col20 col21 col22 col23 col24 col25 col26 col27 col28 col29 col30 col31 col32 col33 col34 col35 col36 col37 col38 fix1 fix2 fix3 fix4 fix5 fix6 fix7 fix8 fix9 fix10 fix11 fix12 fix13 fix14 fix15 fix16 fix17 fix18 fix19 fix20 fix21 fix22 fix23 fix24 fix25 fix26 fix27 fix28 fix29 fix30
|
|
325 |
9 99 999 9999 99999 999999 9999999 99999999 999999999 9999999999 99999999999 999999999999 9999999999999 99999999999999 999999999999999 9999999999999999 99999999999999999 999999999999999999 9999999999999999999 99999999999999999999 999999999999999999999 9999999999999999999999 99999999999999999999999 999999999999999999999999 9999999999999999999999999 99999999999999999999999999 999999999999999999999999999 9999999999999999999999999999 99999999999999999999999999999 999999999999999999999999999999 9999999999999999999999999999999 99999999999999999999999999999999 999999999999999999999999999999999 9999999999999999999999999999999999 99999999999999999999999999999999999 999999999999999999999999999999999999 9999999999999999999999999999999999999 99999999999999999999999999999999999999 9999999999999999999999999999999999999.9 999999999999999999999999999999999999.99 99999999999999999999999999999999999.999 9999999999999999999999999999999999.9999 999999999999999999999999999999999.99999 99999999999999999999999999999999.999999 9999999999999999999999999999999.9999999 999999999999999999999999999999.99999999 99999999999999999999999999999.999999999 9999999999999999999999999999.9999999999 999999999999999999999999999.99999999999 99999999999999999999999999.999999999999 9999999999999999999999999.9999999999999 999999999999999999999999.99999999999999 99999999999999999999999.999999999999999 9999999999999999999999.9999999999999999 999999999999999999999.99999999999999999 99999999999999999999.999999999999999999 9999999999999999999.9999999999999999999 999999999999999999.99999999999999999999 99999999999999999.999999999999999999999 9999999999999999.9999999999999999999999 999999999999999.99999999999999999999999 99999999999999.999999999999999999999999 9999999999999.9999999999999999999999999 999999999999.99999999999999999999999999 99999999999.999999999999999999999999999 9999999999.9999999999999999999999999999 999999999.99999999999999999999999999999 99999999.999999999999999999999999999999
|
|
326 |
DROP TABLE t1;
|
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
327 |
create table t1 (bigint_col bigint unsigned);
|
|
1
by brian
clean slate |
328 |
insert into t1 values (17666000000000000000);
|
329 |
select * from t1 where bigint_col=17666000000000000000;
|
|
330 |
bigint_col
|
|
|
520.1.8
by Brian Aker
Updating tests. |
331 |
-780744073709551616
|
|
1
by brian
clean slate |
332 |
select * from t1 where bigint_col='17666000000000000000';
|
333 |
bigint_col
|
|
334 |
drop table t1;
|
|
335 |
||
336 |
bug 19955 -- mod is signed with bigint |
|
|
520.1.8
by Brian Aker
Updating tests. |
337 |
select 10000002383263201056 mod 50 as result; |
|
1
by brian
clean slate |
338 |
result |
339 |
6 |
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
340 |
create table t1 (c1 bigint unsigned); |
|
1
by brian
clean slate |
341 |
insert into t1 values (10000002383263201056); |
342 |
select c1 mod 50 as result from t1; |
|
343 |
result |
|
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
344 |
6 |
|
1
by brian
clean slate |
345 |
drop table t1; |
346 |
select -9223372036854775808; |
|
347 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
971.7.6
by Eric Day
Merged Stewart's tinyint removal, and fixed a few things to not break protocol. |
348 |
def -9223372036854775808 5 20 20 N 32897 0 63 |
|
1
by brian
clean slate |
349 |
-9223372036854775808 |
350 |
-9223372036854775808 |
|
351 |
select -(9223372036854775808); |
|
352 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
971.7.6
by Eric Day
Merged Stewart's tinyint removal, and fixed a few things to not break protocol. |
353 |
def -(9223372036854775808) 5 20 20 N 32897 0 63 |
|
1
by brian
clean slate |
354 |
-(9223372036854775808) |
355 |
-9223372036854775808 |
|
356 |
select -((9223372036854775808)); |
|
357 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
971.7.6
by Eric Day
Merged Stewart's tinyint removal, and fixed a few things to not break protocol. |
358 |
def -((9223372036854775808)) 5 20 20 N 32897 0 63 |
|
1
by brian
clean slate |
359 |
-((9223372036854775808)) |
360 |
-9223372036854775808 |
|
361 |
select -(-(9223372036854775808)); |
|
362 |
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr |
|
|
971.7.6
by Eric Day
Merged Stewart's tinyint removal, and fixed a few things to not break protocol. |
363 |
def -(-(9223372036854775808)) 9 21 19 N 129 0 63 |
|
1
by brian
clean slate |
364 |
-(-(9223372036854775808)) |
365 |
9223372036854775808 |
|
366 |
select --9223372036854775808, ---9223372036854775808, ----9223372036854775808; |
|
367 |
--9223372036854775808 ---9223372036854775808 ----9223372036854775808 |
|
368 |
9223372036854775808 -9223372036854775808 9223372036854775808 |
|
369 |
select -(-9223372036854775808), -(-(-9223372036854775808)); |
|
370 |
-(-9223372036854775808) -(-(-9223372036854775808)) |
|
371 |
9223372036854775808 -9223372036854775808 |
|
372 |
create table t1 select -9223372036854775808 bi; |
|
373 |
describe t1; |
|
|
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
374 |
Field Type Null Default Default_is_NULL On_Update |
|
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
375 |
bi BIGINT NO NO |
|
1
by brian
clean slate |
376 |
drop table t1; |
377 |
create table t1 select -9223372036854775809 bi; |
|
378 |
describe t1; |
|
|
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
379 |
Field Type Null Default Default_is_NULL On_Update |
|
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
380 |
bi DECIMAL NO NO |
|
1
by brian
clean slate |
381 |
drop table t1; |