blob: 91997c811b5e8bc58d3e9b05d1e23642fde66fab (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
#
# Test of reading of bigint values
#
select 0,256,00000000000000065536,2147483647,-2147483648,2147483648,+4294967296;
select 922337203685477580,92233720368547758000;
select -922337203685477580,-92233720368547758000;
select 9223372036854775807,-009223372036854775808;
select +9999999999999999999,-9999999999999999999;
drop table if exists t1;
create table t1 (a bigint unsigned);
insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFF);
select * from t1;
drop table t1;
|
