Feature Requests item #2869851, was opened at 2009-09-29 17:19 Message generated for change (Comment added) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2869851&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: Cross product count, algebra Initial Comment: I think it must be possible for a query like: select count(*) from bigdatabase1, bigdatabase2; To rewrite it to: select (select count(*) from bigdatabase1) * (select count(*) from bigdatabase2); ---------------------------------------------------------------------- >Comment By: Stefan de Konink (skinkie) Date: 2009-10-09 02:30 Message: Because I am seriously proud... I want to publish the patch first :D select count(*) from kvk, kvk; % . # table_name % L60 # name % wrd # type % 13 # length [ 5830679502400 ] Timer 2.650 msec 1 rows We have to work on some sort of overflow protection too... but that was already in the /real/ bugtracker :) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2869851&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
