Feature Requests item #2926181, was opened at 2010-01-05 12:35 Message generated for change (Comment added) made by mlkersten You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2926181&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: Closed Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Nobody/Anonymous (nobody) Summary: SQL: Prevent clause, query by precomputing Initial Comment: In a query: select * from x where a like '%%'; it is obvious to see that this query could be rewritten to select * from x; The calculation of this like expression obviously takes time. The negative case might look even more fruitful, since it can prevent an entire query from running. ---------------------------------------------------------------------- >Comment By: Martin Kersten (mlkersten) Date: 2010-01-05 13:27 Message: This transformation is not generic enough to handle at the SQL level. It can be handled by the pcre library, providing a shortcut. ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2010-01-05 13:02 Message: stop filing rediculous feature requests? This is outside of the domain of the DBMS, the application can easily handle this. ---------------------------------------------------------------------- Comment By: Stefan de Konink (skinkie) Date: 2010-01-05 12:50 Message: If I shutdown my MonetDB public server, that would probably give a performance increase as well. Anything else in the New Year, Fabian? ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2010-01-05 12:44 Message: you can also just not emit such a stupid query ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2926181&group_id=56967 ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
