ya know, it really helps when I reply all. (really, I am blonde, but I try hard to overcome it).
---------- Forwarded message ---------- From: Sheeri K. Cabral <[EMAIL PROTECTED]> Date: Aug 20, 2008 11:11 PM Subject: Re: [Drizzle-discuss] ONLY_FULL_GROUP_BY To: Roland Bouman <[EMAIL PROTECTED]> On 8/20/08, Roland Bouman <[EMAIL PROTECTED]> wrote: > > > The true fix would be to only allow non-aggregate expressions in the > SELECT list that are functionally dependent upon the GROUP BY list > (and this would be in accordance with the 1999 and 2003 versions of > the SQL standard). However, I fear that this is not a trivial fix. ++ (it'd be in accordance with the relational model too! Hey, I have a Master's Degree in CS, I get to dust it out every so often....at least, while I'm still paying for the damn thing I ought to be able to.) If I am right that implementing this fix is too much trouble, then I > am in favour of allowing non-aggregate expressions in the SELECT list > even if they do not appear in the GROUP BY list, i.e. stick to MySQLs > current behaviour. Forcing full group by will make writing queries a > good deal more cumbersome, and will in addition lead to extra work in > executing the query (at least I assume that the query execution engine > is not smarter than the parser and is forced to take all specified > expressions in the GROUP BY into account, which to me is just a > performance penalty for no good) ++ here too. kind regards, ++ here, too, why not? :) -Sheeri -- - Sheeri K. Cabral Note: Currently I work for The Pythian Group (http://www.pythian.com/ ), a remote DBA firm, and consulting would constitute a conflict of interest. However, I do recommend our work, and if you're looking for DBA work (I do MySQL work, but they have great Oracle and SQL Server DBAs too) right now, whether you need a few hours a week, or someone fulltime while you continue a job search. I have a webpage with tips on how to find a DBA: http://sheeri.net/how-to-find-a-dba/ I can recommend http://www.toomanyconnections.com as a good site to find MySQL (and Oracle) DBAs. If you're looking for web design, I recommend the small business my husband works for, http://www.digital-loom.com I regret that I have no other information for any other type of position, including developer, programmer and systems administrator.
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
