diff options
author | monty@mashka.mysql.fi <> | 2003-02-04 01:05:39 +0200 |
---|---|---|
committer | monty@mashka.mysql.fi <> | 2003-02-04 01:05:39 +0200 |
commit | 59400e211f2e23a9d19948585da00007248862df (patch) | |
tree | 534009eac955b290d4c8e82d4e106f06184ff8c0 /mysql-test/t/bigint.test | |
parent | 3d067e7d734986351d419b1504e13981389b8c8a (diff) | |
download | mariadb-git-59400e211f2e23a9d19948585da00007248862df.tar.gz |
Fixed bug in ulonglong parsing for constructs that only takes unsigned longlong as parameter.
Diffstat (limited to 'mysql-test/t/bigint.test')
-rw-r--r-- | mysql-test/t/bigint.test | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test index 15c61c2c0dc..023e50b7677 100644 --- a/mysql-test/t/bigint.test +++ b/mysql-test/t/bigint.test @@ -4,7 +4,7 @@ select 0,256,00000000000000065536,2147483647,-2147483648,2147483648,+4294967296; select 9223372036854775807,-009223372036854775808; select +9999999999999999999,-9999999999999999999; - +select 9223372036854775808+1; # # 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) @@ -35,3 +35,13 @@ alter table t1 modify big bigint not null; select min(big),max(big),max(big)-1 from t1; select min(big),max(big),max(big)-1 from t1 group by a; drop table t1; + +# +# Test problem with big values fir auto_increment +# + +create table t1 (id bigint auto_increment primary key, a int) auto_increment=9999999999; +insert into t1 values (null,1); +select * from t1; +select * from t1 limit 9999999999; +drop table t1; |