Feature Requests item #2875293, was opened at 2009-10-09 02:58 Message generated for change (Tracker Item Submitted) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2875293&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 - general Group: None Status: Open Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Nobody/Anonymous (nobody) Summary: rel_optimizer: apply min/max only on source table in join Initial Comment: =project ( =| group by ( =| | crossproduct ( =| | | table(sys.tralala) [ tralala.test as a.test, tralala.%TID% NOT NULL as a.%TID% ], =| | | table(sys.tralala) [ tralala.%TID% NOT NULL ] =| | ) =| ) [ ] [ max no nil (a.test) as L1 ] =) [ L1 ] => =project ( =| group by ( =| | table(sys.tralala) [ tralala.test as a.test, tralala.%TID% NOT NULL as a.%TID% ] =| ) [ ] [ max no nil (a.test) as L1 ] =) [ L1 ] The general solution should push down the aggregates min/max down to the tables where they operate upon and purge the remaining tables. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2875293&group_id=56967 ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) 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/devconference _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
