Strange behavior with a strange request

[Julien Palard]

Hi there !

Today, a dev in my company asked me about a strange behavior, but he doesn't noticied that its request were completely weird ... here it is, extremly simplified :

{{{
SELECT id FROM a_table
WHERE id > 0
GROUP BY id
AND id > 3
}}}

I can't understand how MySQL parses it cause I don't see any usage of AND after GROUP BY in the documentation ^-^

Strangely enouth, id > 0 (after the GROUP BY) there is only one result, and with an integer greater than 0, like "id > 2", there is two fields returned, the first, AND the first matching id > 2.

Any idea ? Is this a bug of a feature ? :-P