diff options
Diffstat (limited to 'mysql-test/r/having.result')
-rw-r--r-- | mysql-test/r/having.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/having.result b/mysql-test/r/having.result index cbd3fbfff4e..229604034d8 100644 --- a/mysql-test/r/having.result +++ b/mysql-test/r/having.result @@ -1,4 +1,11 @@ +drop table if exists t1; +create table t1 (a int); +select count(a) as b from t1 where a=0 having b > 0; b +insert into t1 values (null); +select count(a) as b from t1 where a=0 having b > 0; b +select count(a) as b from t1 where a=0 having b >=0; b 0 +drop table t1; |