Bugs item #2862146, was opened at 2009-09-19 12:36 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2862146&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: Fixed Priority: 5 Private: No Submitted By: Alex Bo (alexbod) Assigned to: Niels Nes (nielsnes) Summary: Two COUNT(*) with LIMIT doesn't execute Initial Comment: This query doesn't work: SELECT COUNT (*) AS c1, COUNT (*) AS c2 FROM t2 limit 100 It throws the following exception: !TypeException:user.s5_3[21]:'algebra.semijoin' undefined in: _31:any := algebra.semijoin(_30:wrd, _28:wrd) !SQLException:SQLengine:Program contains errors The following queries do work: 1. Same but with only 1 aggregation field: SELECT COUNT (*) AS c1 FROM t2 limit 100 2. Same but without LIMIT: SELECT COUNT (*) AS c1, COUNT (*) AS c2 FROM t2 ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2009-09-19 18:54 Message: fixed the problem, we correctly handle single values with limits now. added test to src/test/BugTracker-2009/Tests/double_count_limit_bug.SF-2862146.sql ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2862146&group_id=56967 ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
