diff options
| author | monty@mashka.mysql.fi <> | 2003-02-04 21:52:14 +0200 |
|---|---|---|
| committer | monty@mashka.mysql.fi <> | 2003-02-04 21:52:14 +0200 |
| commit | 023d6dd39b9068ab8096c5ec60ab82bd10dbcee2 (patch) | |
| tree | bad5f8dd7f020cc76a4c5e0f19bd130e3fb4a735 /mysql-test/r/bigint.result | |
| parent | 6a32ae735541b4780a209e883430ded343115792 (diff) | |
| parent | 5ce0cd16b8b9fa05c781ac6ff4687133ed145d84 (diff) | |
| download | mariadb-git-023d6dd39b9068ab8096c5ec60ab82bd10dbcee2.tar.gz | |
Merge with 4.0.11
Diffstat (limited to 'mysql-test/r/bigint.result')
| -rw-r--r-- | mysql-test/r/bigint.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index 8bc383c6f4c..2037085dfdb 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -8,6 +8,9 @@ select 9223372036854775807,-009223372036854775808; select +9999999999999999999,-9999999999999999999; +9999999999999999999 -9999999999999999999 10000000000000000000 -10000000000000000000 +select 9223372036854775808+1; +9223372036854775808+1 +9223372036854775808 create table t1 (a bigint unsigned not null, primary key(a)); insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFE); select * from t1; @@ -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; |