MacWorld 2003 May (DVD)/Macworld Resource DVD May 2003.toast/Data/Software/Bonus/Database/mysql-max-3.23.55.sit/mysql-max-3.23.55-apple-darwi.1/mysql-test/t/bigint.test

Text File | 2003-01-21 | 789 b | 23 lines | [TEXT/ttxt]

#
# Test of reading of bigint values
#
select 0,256,00000000000000065536,2147483647,-2147483648,2147483648,[phone];
select 9223372036854775807,-009223372036854775808;
select +9999999999999999999,-9999999999999999999;

#
# In 3.23 we have to disable the test of column to bigint as
# this fails on AIX powerpc (the resolution for double is not good enough)
# This will work on 4.0 as we then have internal handling of bigint variables.
#

drop table if exists t1;
create table t1 (a bigint unsigned not null, primary key(a));
insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFE);
select * from t1;
select * from t1 where a=18446744073709551615;
select * from t1 where a='18446744073709551615';
delete from t1 where a=18446744073709551615;
select * from t1;
drop table t1;