MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Order By in FROM Subquery doesn't work in 5.7
Posted by: Rick James
Date: April 20, 2016 11:41PM

Does this explain the inner ORDER BY being thrown away:
https://mariadb.com/kb/en/mariadb/group-by-trick-has-been-optimized-away/
and does the comment provide a useful suggestion on how to work around it?

More on groupwise max:
http://mysql.rjweb.org/doc.php/groupwise_max

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 15, 2016 05:28AM
Re: Order By in FROM Subquery doesn't work in 5.7
Peter Brawley
April 15, 2016 10:24AM
Re: Order By in FROM Subquery doesn't work in 5.7
Rick James
April 15, 2016 03:38PM
Re: Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 16, 2016 12:21AM
Re: Order By in FROM Subquery doesn't work in 5.7
Peter Brawley
April 16, 2016 10:08AM
Re: Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 17, 2016 12:54AM
Re: Order By in FROM Subquery doesn't work in 5.7
Peter Brawley
April 17, 2016 04:28AM
Re: Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 18, 2016 10:43PM
Re: Order By in FROM Subquery doesn't work in 5.7
Peter Brawley
April 19, 2016 08:00AM
Re: Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 20, 2016 01:28AM
Re: Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 20, 2016 02:13AM
Re: Order By in FROM Subquery doesn't work in 5.7
Peter Brawley
April 20, 2016 11:00AM
Re: Order By in FROM Subquery doesn't work in 5.7
Rick James
April 20, 2016 11:41PM
Re: Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 22, 2016 04:03AM
Re: Order By in FROM Subquery doesn't work in 5.7
Aanya Dsouza
April 21, 2016 03:26AM
Re: Order By in FROM Subquery doesn't work in 5.7
Rick James
April 18, 2016 10:52PM
Re: Order By in FROM Subquery doesn't work in 5.7
Peter Brawley
April 19, 2016 07:55AM
Re: Order By in FROM Subquery doesn't work in 5.7
Mohammed Bilo
April 21, 2016 03:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.