diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-01-16 17:38:38 +0200 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-01-16 17:38:38 +0200 |
| commit | 4d8e73c8186e13d2136d15716cfeaedc55965e05 (patch) | |
| tree | f0b8464ee2d3fcb57c8c4fe4de1ec5a91e090f3d /mysql-test/t/having.test | |
| parent | 47bd8d19fd9a6eb8d6a314452db4a916a84adae9 (diff) | |
| parent | bdec5458aebded82d52cb535810ad73be244b690 (diff) | |
| download | mariadb-git-4d8e73c8186e13d2136d15716cfeaedc55965e05.tar.gz | |
merged 5.0-bugteam -> 5.1-bugteam
Diffstat (limited to 'mysql-test/t/having.test')
| -rw-r--r-- | mysql-test/t/having.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/having.test b/mysql-test/t/having.test index 683abfd3783..af9af4fe1fc 100644 --- a/mysql-test/t/having.test +++ b/mysql-test/t/having.test @@ -432,3 +432,14 @@ select f1 from t1 having max(f1)=f1; select f1 from t1 group by f1 having max(f1)=f1; set session sql_mode=''; drop table t1; + + +# +# Bug #38637: COUNT DISTINCT prevents NULL testing in HAVING clause +# +CREATE TABLE t1 ( a INT, b INT); +INSERT INTO t1 VALUES (1, 1), (2,2), (3, NULL); +SELECT b, COUNT(DISTINCT a) FROM t1 GROUP BY b HAVING b is NULL; +DROP TABLE t1; + +--echo End of 5.0 tests |