Bugs item #2494227, was opened at 2009-01-08 18:27 Message generated for change (Comment added) made by romulog 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: MonetDB5 "stable" Status: Closed Resolution: Wont Fix Priority: 5 Private: No Submitted By: dtstutz (dtstutz) Assigned to: Niels Nes (nielsnes) 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: 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 ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
