diff options
| author | monty@hundin.mysql.fi <> | 2001-06-19 14:30:12 +0300 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2001-06-19 14:30:12 +0300 |
| commit | 72fb81e888b5c5f9c1c7917709568d61cfb6663f (patch) | |
| tree | 884d89c2f53eae988fe08259ab2953720d274ab2 /mysql-test/t/bigint.test | |
| parent | 16d50ca46d41060240dffc761f12144395150ff6 (diff) | |
| download | mariadb-git-72fb81e888b5c5f9c1c7917709568d61cfb6663f.tar.gz | |
Fixed bug in mysqlcheck when using --fast
Fixed problem when converting bigint to double.
Fixed bug in count(distinct null)
Fixed bug with empty BDB tables.
Diffstat (limited to 'mysql-test/t/bigint.test')
| -rw-r--r-- | mysql-test/t/bigint.test | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test index 9a819463f3f..6470b6f6a30 100644 --- a/mysql-test/t/bigint.test +++ b/mysql-test/t/bigint.test @@ -6,7 +6,11 @@ select 9223372036854775807,-009223372036854775808; select +9999999999999999999,-9999999999999999999; drop table if exists t1; -create table t1 (a bigint unsigned); -insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFF); +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; |