From d6ca74d272a88a331a28cda1d578c6fb9c14d9da Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 4 Feb 2003 01:05:39 +0200 Subject: Fixed bug in ulonglong parsing for constructs that only takes unsigned longlong as parameter. mysql-test/r/bigint.result: Test if big LONG_NUM mysql-test/t/bigint.test: Test if big LONG_NUM --- mysql-test/r/bigint.result | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'mysql-test/r/bigint.result') diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index 6afa74d20e2..8522ef0212f 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -7,6 +7,9 @@ select 9223372036854775807,-009223372036854775808; select +9999999999999999999,-9999999999999999999; +9999999999999999999 -9999999999999999999 10000000000000000000 -10000000000000000000 +select 9223372036854775808+1; +9223372036854775808+1 +9223372036854775808 drop table if exists t1; create table t1 (a bigint unsigned not null, primary key(a)); insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFE); @@ -52,3 +55,12 @@ select min(big),max(big),max(big)-1 from t1 group by a; min(big) max(big) max(big)-1 -1 9223372036854775807 9223372036854775806 drop table t1; +create table t1 (id bigint auto_increment primary key, a int) auto_increment=9999999999; +insert into t1 values (null,1); +select * from t1; +id a +9999999999 1 +select * from t1 limit 9999999999; +id a +9999999999 1 +drop table t1; -- cgit v1.2.1