Bugs item #2582389, was opened at 2009-02-09 19:57 Message generated for change (Comment added) made by romulog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2582389&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: SQL "stable" Status: Open Resolution: None Priority: 5 Private: No Submitted By: Romulo Goncalves (romulog) Assigned to: Niels Nes (nielsnes) Summary: subtraction between two columns Initial Comment: I if run the following code: create table t2(id int, inst float); insert into t2 values(1, 0.2); insert into t2 values(1, 0.4); select l.id, r.inst, l.inst, (r.inst - l.inst) as diff from t2 l, t2 r where r.id = l.id order by inst limit 2; drop table t2; I get: MAPI = mone...@localhost:50000 QUERY = select l.id, r.inst, l.inst, (r.inst - l.inst) as diff from t2 l, t2 r where r.id = l.id order by inst limit 2; ERROR = !MALException:batcalc.CMDbatSUB:requires bats of identical size If I remove order by clause it works. To complete the report I also detected a crash similar to the one reported on bug: 2581617 cardinality of expression is wrong To see the crash just run the following query: select l.id, (r.inst - l.inst) as diff from t2 l, t2 r where r.id = l.id order by inst limit 2; ---------------------------------------------------------------------- >Comment By: Romulo Goncalves (romulog) Date: 2009-02-09 21:50 Message: Test added at: sql/src/test/BugTracker-2009/Tests/subtraction_between_two_columns.SF-2582389.sql ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2582389&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
