From 703ed5044fd1b3d46ed6974d530aeb6deaf36f20 Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 17 Jan 2001 03:15:20 +0200 Subject: 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 --- mysql-test/t/having.test | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 mysql-test/t/having.test (limited to 'mysql-test/t/having.test') 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; -- cgit v1.2.1