diff options
| author | unknown <sasha@mysql.sashanet.com> | 2001-05-12 17:52:54 -0600 |
|---|---|---|
| committer | unknown <sasha@mysql.sashanet.com> | 2001-05-12 17:52:54 -0600 |
| commit | 64984296241873f90e39d744b59690c7b3b408bb (patch) | |
| tree | 21b4d45558a445f285ffe318246b699a11303126 /mysql-test/r/count_distinct2.result | |
| parent | 1d56c0324e21e0e1b92e46445a8896006cb9a8e8 (diff) | |
| download | mariadb-git-64984296241873f90e39d744b59690c7b3b408bb.tar.gz | |
fixes/optimizations for count(distinct)
more extensive testing of count(distinct)
sql/item_sum.cc:
fixes/optimizations for count(distinct)
Diffstat (limited to 'mysql-test/r/count_distinct2.result')
| -rw-r--r-- | mysql-test/r/count_distinct2.result | 72 |
1 files changed, 72 insertions, 0 deletions
diff --git a/mysql-test/r/count_distinct2.result b/mysql-test/r/count_distinct2.result new file mode 100644 index 00000000000..b2bcf11a37c --- /dev/null +++ b/mysql-test/r/count_distinct2.result @@ -0,0 +1,72 @@ +n1 +1 +2 +NULL +count(distinct n1) +2 +n2 +11 +12 +13 +NULL +count(distinct n2) +3 +s +one +two +NULL +count(distinct s) +2 +vs +eleven +twevle +thirteen +NULL +count(distinct vs) +3 +t +eleven +twelve +foo +bar +NULL +count(distinct t) +4 +n1 n2 +1 11 +2 11 +2 12 +2 13 +NULL 13 +2 NULL +count(distinct n1,n2) +4 +n1 s +1 one +2 two +NULL two +2 NULL +count(distinct n1,s) +2 +s n1 vs +one 1 eleven +two 2 eleven +two 2 twevle +two 2 thirteen +two NULL thirteen +NULL 2 thirteen +two 2 NULL +count(distinct s,n1,vs) +4 +s t +one eleven +two eleven +two twelve +two foo +two bar +NULL bar +two NULL +count(distinct s,t) +5 +count(distinct n1) count(distinct n2) +2 3 |