All posts by Chaithra Gopalareddy

About Chaithra Gopalareddy

Chaithra Gopalaredy has been working with MySQL database team since 2011. She is currently employed by Oracle, based in India, Bangalore. She is Principal Software Developer for the Optimizer Team of the MySQL database. She has a background in the database industry, working for Alcatel Lucent's DataBlitz main memory database in past.

Removal of implicit and explicit sorting for GROUP BY

In MySQL, historically GROUP BY was used to provide sorting as well. If a query specified GROUP BY, the result was sorted as if ORDER BY was present in the query.

MySQL here implicitly sorts the results from GROUP BY (i.e.…