diff options
| author | unknown <monty@donna.mysql.com> | 2001-01-17 03:15:20 +0200 |
|---|---|---|
| committer | unknown <monty@donna.mysql.com> | 2001-01-17 03:15:20 +0200 |
| commit | 5372aa60ce6c076297815958bbbec2180d919772 (patch) | |
| tree | 256b185f833ce2fac42471efe65aa7bde9b9a8da /mysql-test/t/having.test | |
| parent | f0a33e62a1ed70f3b2393e6548b7a128d7dea3e1 (diff) | |
| download | mariadb-git-5372aa60ce6c076297815958bbbec2180d919772.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
Docs/manual.texi:
Update of UDF functions
mysql-test/mysql-test-run.sh:
Added option --user
mysql-test/r/bdb.result:
Added more test to get better coverage
mysql-test/t/bdb.test:
Added more test to get better coverage
sql/field.cc:
Fixes for key packing in BDB
sql/field.h:
Fixes for key packing in BDB
sql/ha_berkeley.cc:
Fixed for bugs that was found when getting full code coverage
sql/ha_heap.cc:
Fixed problem with HEAP tables on windows
sql/log.cc:
Safety fix
sql/sql_select.cc:
Fixed bug with HAVING on empty tables
sql/table.cc:
Fixed problem with HEAP tables on windows
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; |