« back to all changes in this revision
Viewing changes to tests/r/bigint.result
- browse files at revision 520.1.8
- compare with another revision
- compare with revision 2456.1.5
- download diff
- download tarball
- view history from revision 520.1.8
- Committer: Brian Aker
- Date: 2008-10-18 15:43:20 UTC
- mto: (492.3.20 drizzle-clean-code)
- mto: This revision was merged to the branch mainline in revision 530.
- Revision ID: brian@tangent.org-20081018154320-jc9jyij3mdf08abp
Updating tests.
- files removed:
- tests/r/bootstrap.result
- files modified:
- tests/Makefile.am
added
removed
tests/r/bigint.result
8
8
select +9999999999999999999,-9999999999999999999;
9
9
9999999999999999999 -9999999999999999999
10
10
9999999999999999999 -9999999999999999999
11
select cast(9223372036854775808 as unsigned)+1;
12
cast(9223372036854775808 as unsigned)+1
11
select 9223372036854775808 +1;
12
9223372036854775808 +1
13
13
9223372036854775809
14
14
select 9223372036854775808+1;
15
15
9223372036854775808+1
23
23
select -1,-11,-101,-1001,-10001,-100001,-1000001,-10000001,-100000001,-1000000001,-10000000001,-100000000001,-1000000000001,-10000000000001,-100000000000001,-1000000000000001,-10000000000000001,-100000000000000001,-1000000000000000001,-10000000000000000001;
24
24
-1 -11 -101 -1001 -10001 -100001 -1000001 -10000001 -100000001 -1000000001 -10000000001 -100000000001 -1000000000001 -10000000000001 -100000000000001 -1000000000000001 -10000000000000001 -100000000000000001 -1000000000000000001 -10000000000000000001
25
25
-1 -11 -101 -1001 -10001 -100001 -1000001 -10000001 -100000001 -1000000001 -10000000001 -100000000001 -1000000000001 -10000000000001 -100000000000001 -1000000000000001 -10000000000000001 -100000000000000001 -1000000000000000001 -10000000000000000001
26
select conv(1,10,16),conv((1<<2)-1,10,16),conv((1<<10)-2,10,16),conv((1<<16)-3,10,16),conv((1<<25)-4,10,16),conv((1<<31)-5,10,16),conv((1<<36)-6,10,16),conv((1<<47)-7,10,16),conv((1<<48)-8,10,16),conv((1<<55)-9,10,16),conv((1<<56)-10,10,16),conv((1<<63)-11,10,16);
27
conv(1,10,16) conv((1<<2)-1,10,16) conv((1<<10)-2,10,16) conv((1<<16)-3,10,16) conv((1<<25)-4,10,16) conv((1<<31)-5,10,16) conv((1<<36)-6,10,16) conv((1<<47)-7,10,16) conv((1<<48)-8,10,16) conv((1<<55)-9,10,16) conv((1<<56)-10,10,16) conv((1<<63)-11,10,16)
28
1 3 3FE FFFD 1FFFFFC 7FFFFFFB FFFFFFFFA 7FFFFFFFFFF9 FFFFFFFFFFF8 7FFFFFFFFFFFF7 FFFFFFFFFFFFF6 7FFFFFFFFFFFFFF5
29
create table t1 (a bigint unsigned not null, primary key(a));
30
insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFE), (18446744073709551613), (18446744073709551612);
26
create table t1 (a bigint not null, primary key(a));
27
insert into t1 values (9223372036854775808);
28
insert into t1 values (0x7000000000000000);
31
29
select * from t1;
32
30
a
33
18446744073709551612
34
18446744073709551613
35
18446744073709551614
36
18446744073709551615
31
-9223372036854775808
32
8070450532247928832
37
33
select * from t1 where a=18446744073709551615;
38
34
a
39
18446744073709551615
40
35
delete from t1 where a=18446744073709551615;
41
36
select * from t1;
42
37
a
43
18446744073709551612
44
18446744073709551613
45
18446744073709551614
38
-9223372036854775808
39
8070450532247928832
46
40
drop table t1;
47
41
create table t1 ( a int not null default 1, big bigint );
48
insert into t1 (big) values (-1),(12345678901234567),(9223372036854775807),(18446744073709551615);
49
Warnings:
50
Warning 1264 Out of range value for column 'big' at row 4
51
select * from t1;
52
a big
53
1 -1
54
1 12345678901234567
55
1 9223372036854775807
56
1 9223372036854775807
57
select min(big),max(big),max(big)-1 from t1;
58
min(big) max(big) max(big)-1
59
-1 9223372036854775807 9223372036854775806
60
select min(big),max(big),max(big)-1 from t1 group by a;
61
min(big) max(big) max(big)-1
62
-1 9223372036854775807 9223372036854775806
63
alter table t1 modify big bigint unsigned not null;
64
Warnings:
65
Warning 1264 Out of range value for column 'big' at row 1
66
select min(big),max(big),max(big)-1 from t1;
67
min(big) max(big) max(big)-1
68
0 9223372036854775807 9223372036854775806
69
select min(big),max(big),max(big)-1 from t1 group by a;
70
min(big) max(big) max(big)-1
71
0 9223372036854775807 9223372036854775806
72
insert into t1 (big) values (18446744073709551615);
73
select * from t1;
74
a big
75
1 0
76
1 12345678901234567
77
1 9223372036854775807
78
1 9223372036854775807
79
1 18446744073709551615
80
select min(big),max(big),max(big)-1 from t1;
81
min(big) max(big) max(big)-1
82
0 18446744073709551615 18446744073709551614
83
select min(big),max(big),max(big)-1 from t1 group by a;
84
min(big) max(big) max(big)-1
85
0 18446744073709551615 18446744073709551614
42
insert into t1 (big) values (-1),(9223372036854775808),(9223372036854775807),(9223372036854775808);
43
select * from t1;
44
a big
45
1 -1
46
1 -9223372036854775808
47
1 9223372036854775807
48
1 -9223372036854775808
49
select min(big),max(big),max(big)-1 from t1;
50
min(big) max(big) max(big)-1
51
-9223372036854775808 9223372036854775807 9223372036854775806
52
select min(big),max(big),max(big)-1 from t1 group by a;
53
min(big) max(big) max(big)-1
54
-9223372036854775808 9223372036854775807 9223372036854775806
55
alter table t1 modify big bigint not null;
56
select min(big),max(big),max(big)-1 from t1;
57
min(big) max(big) max(big)-1
58
-9223372036854775808 9223372036854775807 9223372036854775806
59
select min(big),max(big),max(big)-1 from t1 group by a;
60
min(big) max(big) max(big)-1
61
-9223372036854775808 9223372036854775807 9223372036854775806
62
insert into t1 (big) values (9223372036854775808);
63
select * from t1;
64
a big
65
1 -1
66
1 -9223372036854775808
67
1 9223372036854775807
68
1 -9223372036854775808
69
1 -9223372036854775808
70
select min(big),max(big),max(big)-1 from t1;
71
min(big) max(big) max(big)-1
72
-9223372036854775808 9223372036854775807 9223372036854775806
73
select min(big),max(big),max(big)-1 from t1 group by a;
74
min(big) max(big) max(big)-1
75
-9223372036854775808 9223372036854775807 9223372036854775806
86
76
alter table t1 add key (big);
87
77
select min(big),max(big),max(big)-1 from t1;
88
78
min(big) max(big) max(big)-1
89
0 18446744073709551615 18446744073709551614
79
-9223372036854775808 9223372036854775807 9223372036854775806
90
80
select min(big),max(big),max(big)-1 from t1 group by a;
91
81
min(big) max(big) max(big)-1
92
0 18446744073709551615 18446744073709551614
82
-9223372036854775808 9223372036854775807 9223372036854775806
93
83
alter table t1 modify big bigint not null;
94
Warnings:
95
Warning 1264 Out of range value for column 'big' at row 5
96
84
select * from t1;
97
85
a big
98
1 0
99
1 12345678901234567
100
1 9223372036854775807
101
1 9223372036854775807
102
1 9223372036854775807
86
1 -1
87
1 -9223372036854775808
88
1 9223372036854775807
89
1 -9223372036854775808
90
1 -9223372036854775808
103
91
select min(big),max(big),max(big)-1 from t1;
104
92
min(big) max(big) max(big)-1
105
0 9223372036854775807 9223372036854775806
93
-9223372036854775808 9223372036854775807 9223372036854775806
106
94
select min(big),max(big),max(big)-1 from t1 group by a;
107
95
min(big) max(big) max(big)-1
108
0 9223372036854775807 9223372036854775806
96
-9223372036854775808 9223372036854775807 9223372036854775806
109
97
drop table t1;
110
98
create table t1 (id bigint auto_increment primary key, a int) auto_increment=9999999999;
111
99
insert into t1 values (null,1);
132
120
Warnings:
133
121
Warning 1292 Truncated incorrect DOUBLE value: '0x8000000000000001'
134
122
create table t1 (
135
value64 bigint unsigned not null,
123
value64 bigint not null,
136
124
value32 integer not null,
137
125
primary key(value64, value32)
138
126
);
139
127
create table t2 (
140
value64 bigint unsigned not null,
128
value64 bigint not null,
141
129
value32 integer not null,
142
130
primary key(value64, value32)
143
131
);
147
135
insert into t2 values( 9223372036854775807, 4);
148
136
select * from t1;
149
137
value64 value32
138
-1289951081817725471 1
150
139
9223372036854775807 2
151
17156792991891826145 1
152
140
select * from t2;
153
141
value64 value32
142
-1289951081817725471 3
154
143
9223372036854775807 4
155
17156792991891826145 3
156
144
select * from t1, t2 where t1.value64=17156792991891826145 and
157
145
t2.value64=17156792991891826145;
158
146
value64 value32 value64 value32
159
17156792991891826145 1 17156792991891826145 3
147
-1289951081817725471 1 -1289951081817725471 3
160
148
select * from t1, t2 where t1.value64=17156792991891826145 and
161
149
t2.value64=t1.value64;
162
150
value64 value32 value64 value32
163
17156792991891826145 1 17156792991891826145 3
151
-1289951081817725471 1 -1289951081817725471 3
164
152
select * from t1, t2 where t1.value64= 9223372036854775807 and
165
153
t2.value64=9223372036854775807;
166
154
value64 value32 value64 value32
180
168
show create table t1;
181
169
Table Create Table
182
170
t1 CREATE TABLE `t1` (
183
`a` int(1) NOT NULL DEFAULT '0'
184
) ENGINE=MyISAM DEFAULT CHARSET=latin1
171
`a` int NOT NULL
172
) ENGINE=InnoDB
185
173
drop table t1;
186
174
create table t1 select 9223372036854775809 as 'a';
187
175
show create table t1;
188
176
Table Create Table
189
177
t1 CREATE TABLE `t1` (
190
`a` bigint(19) unsigned NOT NULL DEFAULT '0'
191
) ENGINE=MyISAM DEFAULT CHARSET=latin1
178
`a` bigint NOT NULL
179
) ENGINE=InnoDB
192
180
select * from t1;
193
181
a
194
9223372036854775809
182
-9223372036854775807
195
183
drop table t1;
196
184
DROP DATABASE IF EXISTS `scott`;
197
185
Warnings:
201
189
18446744073709551615,18446744073709551615,
202
190
18446744073709551615, 18446744073709551615
203
191
);
204
insert into t1 values (-1 | 0,-1 | 0,-1 | 0 ,-1 | 0);
192
insert into t1 values (-1,-1,-1,-1);
205
193
select * from t1;
206
194
a b c d
207
195
18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
208
18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
196
-1 -1 -1 -1
209
197
drop table t1;
210
create table t1 ( quantity decimal(2) unsigned);
211
insert into t1 values (500), (-500), (~0), (-1);
212
Warnings:
213
Warning 1264 Out of range value for column 'quantity' at row 1
214
Warning 1264 Out of range value for column 'quantity' at row 2
215
Warning 1264 Out of range value for column 'quantity' at row 3
216
Warning 1264 Out of range value for column 'quantity' at row 4
198
create table t1 ( quantity decimal(2));
199
insert into t1 values (50), (-50), (0), (-1);
217
200
select * from t1;
218
201
quantity
219
99
220
0
221
99
222
0
202
50
203
-50
204
0
205
-1
223
206
drop table t1;
224
207
CREATE TABLE t1 (
225
`col1` INT(1) NULL,
226
`col2` INT(2) NULL,
227
`col3` INT(3) NULL,
228
`col4` INT(4) NULL,
229
`col5` INT(5) NULL,
230
`col6` INT(6) NULL,
231
`col7` INT(7) NULL,
232
`col8` INT(8) NULL,
233
`col9` INT(9) NULL,
234
`col10` BIGINT(10) NULL,
235
`col11` BIGINT(11) NULL,
236
`col12` BIGINT(12) NULL,
237
`col13` BIGINT(13) NULL,
238
`col14` BIGINT(14) NULL,
239
`col15` BIGINT(15) NULL,
240
`col16` BIGINT(16) NULL,
241
`col17` BIGINT(17) NULL,
242
`col18` BIGINT(18) NULL,
208
`col1` INT NULL,
209
`col2` INT NULL,
210
`col3` INT NULL,
211
`col4` INT NULL,
212
`col5` INT NULL,
213
`col6` INT NULL,
214
`col7` INT NULL,
215
`col8` INT NULL,
216
`col9` INT NULL,
217
`col10` BIGINT NULL,
218
`col11` BIGINT NULL,
219
`col12` BIGINT NULL,
220
`col13` BIGINT NULL,
221
`col14` BIGINT NULL,
222
`col15` BIGINT NULL,
223
`col16` BIGINT NULL,
224
`col17` BIGINT NULL,
225
`col18` BIGINT NULL,
243
226
`col19` DECIMAL(19, 0) NULL,
244
227
`col20` DECIMAL(20, 0) NULL,
245
228
`col21` DECIMAL(21, 0) NULL,
338
321
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
339
322
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
340
323
DROP TABLE t1;
341
create table t1 (bigint_col bigint unsigned);
324
create table t1 (bigint_col bigint);
342
325
insert into t1 values (17666000000000000000);
343
326
select * from t1 where bigint_col=17666000000000000000;
344
327
bigint_col
345
17666000000000000000
328
-780744073709551616
346
329
select * from t1 where bigint_col='17666000000000000000';
347
330
bigint_col
348
17666000000000000000
349
331
drop table t1;
350
332
351
333
bug 19955 -- mod is signed with bigint
352
select cast(10000002383263201056 as unsigned) mod 50 as result;
334
select 10000002383263201056 mod 50 as result;
353
335
result
354
336
6
355
create table t1 (c1 bigint unsigned);
337
create table t1 (c1 bigint);
356
338
insert into t1 values (10000002383263201056);
357
339
select c1 mod 50 as result from t1;
358
340
result
359
6
341
-10
360
342
drop table t1;
361
select cast(19999999999999999999 as signed);
362
cast(19999999999999999999 as signed)
363
9223372036854775807
364
Warnings:
365
Error 1292 Truncated incorrect DECIMAL value: ''
366
select cast(-19999999999999999999 as signed);
367
cast(-19999999999999999999 as signed)
368
-9223372036854775808
369
Warnings:
370
Error 1292 Truncated incorrect DECIMAL value: ''
371
343
select -9223372036854775808;
372
344
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
373
def -9223372036854775808 8 20 20 N 32897 0 63
345
def -9223372036854775808 6 20 20 N 32897 0 63
374
346
-9223372036854775808
375
347
-9223372036854775808
376
348
select -(9223372036854775808);
377
349
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
378
def -(9223372036854775808) 8 20 20 N 32897 0 63
350
def -(9223372036854775808) 6 20 20 N 32897 0 63
379
351
-(9223372036854775808)
380
352
-9223372036854775808
381
353
select -((9223372036854775808));
382
354
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
383
def -((9223372036854775808)) 8 20 20 N 32897 0 63
355
def -((9223372036854775808)) 6 20 20 N 32897 0 63
384
356
-((9223372036854775808))
385
357
-9223372036854775808
386
358
select -(-(9223372036854775808));
387
359
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
388
def -(-(9223372036854775808)) 246 21 19 N 129 0 63
360
def -(-(9223372036854775808)) 253 21 19 N 129 0 63
389
361
-(-(9223372036854775808))
390
362
9223372036854775808
391
363
select --9223372036854775808, ---9223372036854775808, ----9223372036854775808;
397
369
create table t1 select -9223372036854775808 bi;
398
370
describe t1;
399
371
Field Type Null Key Default Extra
400
bi bigint(20) NO 0
372
bi bigint NO NULL
401
373
drop table t1;
402
374
create table t1 select -9223372036854775809 bi;
403
375
describe t1;
404
376
Field Type Null Key Default Extra
405
bi decimal(19,0) NO 0
377
bi decimal(19,0) NO NULL
406
378
drop table t1;
Loggerhead is a web-based interface for Breezy
Version: 2.0.1