Bugs item #2494227, was opened at 2009-01-08 10:27 Message generated for change (Tracker Item Submitted) made by Item Submitter 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: Open Resolution: None 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. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2494227&group_id=56967 ------------------------------------------------------------------------------ Check out the new SourceForge.net Marketplace. It is the best place to buy or sell services for just about anything Open Source. http://p.sf.net/sfu/Xq1LFB _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
