Feature Requests item #2875293, was opened at 2009-10-09 02:58 Message generated for change (Settings changed) made by mr-meltdown 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: SQL: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 ------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
