summaryrefslogtreecommitdiff
path: root/mysql-test/t/bigint.test
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2003-02-04 01:05:39 +0200
committerunknown <monty@mashka.mysql.fi>2003-02-04 01:05:39 +0200
commitd6ca74d272a88a331a28cda1d578c6fb9c14d9da (patch)
tree534009eac955b290d4c8e82d4e106f06184ff8c0 /mysql-test/t/bigint.test
parent9b6726ae93c419e5b7be833e2167e3aea9593d1f (diff)
downloadmariadb-git-d6ca74d272a88a331a28cda1d578c6fb9c14d9da.tar.gz
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
Diffstat (limited to 'mysql-test/t/bigint.test')
-rw-r--r--mysql-test/t/bigint.test12
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;