Hi Jon!
>> However, you can force MySQL to require a full GROUP BY by using the
>> following parameter in the mysqld command line:
>>
>> --sql-mode=ONLY_FULL_GROUP_BY
>>
>> Or by forcing ANSI SQL compliance: --ansi
>
> Hmm, I understand the performance issue, but I generally think it's
> best to be as ANSI complient as possible. Would it be wrong to
> include an ANY function (as suggested)?
Well, I'm in no way a SQL guru or ANSI fan neither. I can imagine the
ANSI implementation was so restrictive for some reason (maybe formal
compliance or something). On the other hand, if you want to be as compliant
as possible to ANSI, you can't use any extra functions (Like 'ANY'). I think
the ANSI restriction is not a syntax restriction, but a semantic one. (Uh
oh, I don't think I got explained here: What I mean is ANSI guarantees a
strong semantic and not giving a chance to "indeterministic" actions). [Let
me see if you understand my english...] ;-)
> (But what is the ANSI explenation for having to include a full group
> by list? In the ANSI world you know _have to_ do like I said,
> specifically give the list of columns to group by.)
Sorry, I can't give an explanation. As I said, I suppose it is related
to some "formal definition" or something.
Cheers,
Jose Miguel.
