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/r/having.result | |
| parent | 47bd8d19fd9a6eb8d6a314452db4a916a84adae9 (diff) | |
| parent | bdec5458aebded82d52cb535810ad73be244b690 (diff) | |
| download | mariadb-git-4d8e73c8186e13d2136d15716cfeaedc55965e05.tar.gz | |
merged 5.0-bugteam -> 5.1-bugteam
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 a5a96fd4958..9c3cc8fc89e 100644 --- a/mysql-test/r/having.result +++ b/mysql-test/r/having.result @@ -424,3 +424,10 @@ select f1 from t1 group by f1 having max(f1)=f1; f1 set session sql_mode=''; drop table t1; +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; +b COUNT(DISTINCT a) +NULL 1 +DROP TABLE t1; +End of 5.0 tests |