Re^2: Seems to be a real monday

[McA]

Ups!

Is it really for sure that all these modules have a hash order bug? I didn't expect that.

Once we had a similar problem @work. One of the SQL gurus thought that using group by forces an order by which is not guaranteed. It was funny as soon as the database spat out the results in any order.

Best wishes
McA

[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 :-)