Bug #88228 "ORDER BY Optimization" doc contradiction re: GROUP BY
Submitted: 25 Oct 2017 19:22 Modified: 15 Nov 2017 21:52
Reporter: Gillian Gunson (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[25 Oct 2017 19:22] Gillian Gunson 
Description:
In the docs page https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html

It contains this statement:

"By default, MySQL sorts all GROUP BY col1, col2, ... queries as if you specified ORDER BY col1, col2, ... in the query as well."

And then a few lines down, in a highlighted note:

"In MySQL 8.0, GROUP BY no longer sorts by default, so query results may differ from previous MySQL versions."

This is contradictory.

How to repeat:
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html

Suggested fix:
Change the "by default" to "In previous versions", or do whatever, I'm not a docs writer 😉
[25 Oct 2017 22:12] MySQL Verification Team 
Thank you for the bug report.
[15 Nov 2017 21:52] Paul DuBois 
Posted by developer:
 
Obsolete paragraph removed.

Thanks for pointing this out.