The Ultimate Guide to High Availability with MariaDB

Comments - ORDER BY clause ignored in subquery

5 years, 10 months ago Mike Tutor
Re: ORDER BY clause ignored in subquery [Answer]

Further research on my part indicates that this is not a bug in MariaDB, but rather a 'feature'. See (https://mariadb.com/kb/en/library/why-is-order-by-in-a-from-subquery-ignored/).

That said, it would be nice if there were a run time variable or SQL_MODE that allowed for the previous behavior. This will cost us a fair amount of code change and may scuttle the migration all together.

 
7 months, 3 weeks ago Michael Widenius
Re: ORDER BY clause ignored in subquery

One way to force the ORDER BY is to add a LIMIT to the sub query. With LIMIT the server is forced to do the ORDER BY as it has to discard possible rows from the end.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.