Bugs item #2494227, was opened at 2009-01-08 18:27 Message generated for change (Comment added) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2494227&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: SQL/Core >Group: SQL "stable" >Status: Open Resolution: Wont Fix >Priority: 6 Private: No Submitted By: dtstutz (dtstutz) >Assigned to: Romulo Goncalves (romulog) Summary: TypeException from having count(distinct colname) Initial Comment: sql>create table a (b int, c int); sql>insert into a (b, c) values (10, 100); Rows affected 1 sql>insert into a (b, c) values (10, 200); Rows affected 1 sql>select b, count(distinct c) from a group by b having count(distinct c) > 1; !TypeException:user.s1_2[37]:'group.derive' undefined in: (_50:any, grp50:any) := group.derive(ext49:any, _49:bat[:oid,:oid], _46:bat[:oid,:int]) !TypeException:user.s1_2[38]:'bat.mirror' undefined in: _53:any := bat.mirror(_50:any) !TypeException:user.s1_2[39]:'algebra.semijoin' undefined in: _54:any := algebra.semijoin(_46:bat[:oid,:int], _53:any) !TypeException:user.s1_2[40]:'aggr.count_no_nil' undefined in: _55:bat[:any,:int] := aggr.count_no_nil(_54:any, _49:bat[:oid,:oid], _43:bat[:oid,:oid]) !TypeException:user.s1_2[37]:'ext49' may not be used before being initialized +----+---------------+ | b |count_no_nil_c | +====+===============+ | 10 | 100 | +----+---------------+ I'm running Ubuntu 8.04.1. I'm sorry I can't easily find the details for the precompiled binary I'm using; hopefully this bug report can still be useful. If not, my apologies for cluttering the bug list. ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2009-02-16 11:54 Message: re-opened to remind us that we should consider adding a test ... Romulo volunteered ... ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2009-02-09 15:09 Message: Niels, There is no test to cover this bug, should it be created? If yes let me know and I will do it... ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2009-02-09 15:02 Message: The algebra version became the default one in the stable branch as well. So the bug can be closed. ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2009-01-26 20:23 Message: works in the soon to be released devel version. Please try using the mclient -G switch. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2494227&group_id=56967 ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
