Re^3: Seems to be a real monday

[soonix]

One of the SQL gurus thought that using group by forces an order by which is not guaranteed.

Ok, it's more than half a year later, but: MySQL does this by default, see http://www.pal-blog.de/entwicklung/mysql/did-you-know-group-by-order-by-null.html

[McA]

Hi,

thank you. But this is a MySQL speciality and not mandanted by the SQL spec.

More intersting: Look at the 5.6 version of that document http://dev.mysql.com/doc/refman/5.6/en/order-by-optimization.html:

Relying on implicit GROUP BY sorting in MySQL 5.6 is deprecated.

Regards
McA

[soonix]

Well, I stumbled over that blog entry and then over this thread, while searching for something different, and found it too funny to ignore :-)