Bugs item #2826015, was opened at 2009-07-23 10:44 Message generated for change (Comment added) made by matburt You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2826015&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Core Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Matthew W. Jones (matburt) Assigned to: Nobody/Anonymous (nobody) Summary: count distinct incorrect Initial Comment: With the latest May 2009 SP1 release I see this: create table testdistinct (testcol varchar(10)); ... inserts ... sql>select * from testdistinct ; +---------+ | testcol | +=========+ | test | | test | | test | | other | | other | | other | +---------+ 6 tuples sql>select distinct(testcol) from testdistinct ; +---------+ | testcol | +=========+ | test | | other | +---------+ 2 tuples sql>select count(distinct(testcol)) from testdistinct ; +----+ | L2 | +====+ | 6 | +----+ 1 tuple This seems incorrect, I would expect count() to return just 2. ---------------------------------------------------------------------- >Comment By: Matthew W. Jones (matburt) Date: 2009-07-23 14:36 Message: It does indeed work... but there should be a disparity between the two. sql>select count(distinct testcol) from testdistinct ; +----+ | L2 | +====+ | 2 | +----+ 1 tuple sql>select count(distinct(testcol)) from testdistinct ; +----+ | L3 | +====+ | 6 | +----+ 1 tuple ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2009-07-23 14:13 Message: select count ( distinct testcol) from testdistinct; seems to work just fine. ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2009-07-23 11:24 Message: I would expect the same. I added the test script to CVS: sql/src/test/BugTracker-2009/count_distinct.SF-2826015.sql ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2826015&group_id=56967 ------------------------------------------------------------------------------ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
