This is probably a yet another consequence of bad fix for http://bugs.mysql.com/bug.php?id=28404 that still remains (and gives preference to index that allows to avoid ORDER BY with LIMIT N when N is small). it is hard to say is it a new or known bug, at least without a complete repeatable test case.
I'll try to create one and report upstream bug for it, and then let Oracle engineers decide.
This is probably a yet another consequence of bad fix for http:// bugs.mysql. com/bug. php?id= 28404 that still remains (and gives preference to index that allows to avoid ORDER BY with LIMIT N when N is small). it is hard to say is it a new or known bug, at least without a complete repeatable test case.
I'll try to create one and report upstream bug for it, and then let Oracle engineers decide.