Hi all, Arjen, there is no logic reason to require that all non aggregate expressions in the SELECT list are used in the GROUP BY.
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. 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) kind regards, Roland On Wed, Aug 20, 2008 at 1:22 PM, Arjen Lentz <[EMAIL PROTECTED]> wrote: > Hi Brian > > On 20/08/2008, at 3:59 PM, Brian Aker wrote: >> >> On Aug 19, 2008, at 9:38 PM, Rob Wultsch wrote: >> >>> ONLY_FULL_GROUP_BY was permanently set on or not configurable >> >> I am leaning toward it not being set. We don't have modes and at the >> moment it hard configured to accept. >> I am tempted to just leave it that way. > > > I want to get rid of the sql_modes, but let's fix each of them in a sane way > rather than simply not setting any. > I'd like to see the full group by bug/problem fixed, so it's effectively > set. > It's a misfeature similar to truncation of fields, lossy autocasting, and so > on. You get the idea. > In the realm of cleaning up stuff, I think we shouldn't just leave this, > even if it's a nasty one to fix; we could list it as a bug and leave it open > for now (with some compiler conditional to mark the magic spots), but I > wouldn't want to just accept it the way it is. > > > Regards, > Arjen. > -- > Arjen Lentz, Founder @ Open Query > Training and Expertise for MySQL in Australia and New Zealand > http://openquery.com.au/training/ (ph. +61-7-3103 0809) > > > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- Roland Bouman http://rpbouman.blogspot.com/ _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
