diff options
Diffstat (limited to 'mysql-test/r/count_distinct.result')
| -rw-r--r-- | mysql-test/r/count_distinct.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/count_distinct.result b/mysql-test/r/count_distinct.result index 81976d268ef..16460580d6c 100644 --- a/mysql-test/r/count_distinct.result +++ b/mysql-test/r/count_distinct.result @@ -48,3 +48,8 @@ select t1.f1,count(distinct t2.f2),count(distinct 1,NULL) from t1 left join t2 o f1 count(distinct t2.f2) count(distinct 1,NULL) 1 0 0 drop table t1,t2; +create table t1 (f int); +select count(distinct f) from t1; +count(distinct f) +0 +drop table t1; |