diff options
| author | monty@donna.mysql.com <> | 2001-01-17 03:15:20 +0200 |
|---|---|---|
| committer | monty@donna.mysql.com <> | 2001-01-17 03:15:20 +0200 |
| commit | 0732f7475eb4775fcfff20257bbe386b38e51a99 (patch) | |
| tree | 256b185f833ce2fac42471efe65aa7bde9b9a8da /mysql-test/t/having.test | |
| parent | 5f4a3f51675240ac05daaba50926740e380e5016 (diff) | |
| download | mariadb-git-0732f7475eb4775fcfff20257bbe386b38e51a99.tar.gz | |
Fixed for bugs that was found when getting full code coverage of BDB
Fixed bug with HEAP tables on windows
Fixed bug with HAVING on empty tables
Diffstat (limited to 'mysql-test/t/having.test')
| -rw-r--r-- | mysql-test/t/having.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/having.test b/mysql-test/t/having.test new file mode 100644 index 00000000000..a952f5e8d5c --- /dev/null +++ b/mysql-test/t/having.test @@ -0,0 +1,10 @@ +# test of problems with having (Reported by Mark Rogers) +# + +drop table if exists t1; +create table t1 (a int); +select count(a) as b from t1 where a=0 having b > 0; +insert into t1 values (null); +select count(a) as b from t1 where a=0 having b > 0; +select count(a) as b from t1 where a=0 having b >=0; +drop table t1; |