MySQL Forums
Forum List  »  Partitioning

Re: BUG - ORDER BY when WHERE contains non partitioned index column
Posted by: Mattias Jonsson
Date: June 24, 2008 04:07PM

Hi,

You have found a bug, I can repeat it the both current 5.1 and 6.0 development trees.

It looks like the server does not sort the result after retrieving the rows from the partitioned table, but instead might rely on the partitioning handler to return them in order (which is only true within each partition).

Please report it. If you want, I can do that for you.

Regards
Mattias Jonsson, Sun Microsystems, MySQL Software Engineer

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: BUG - ORDER BY when WHERE contains non partitioned index column
3136
June 24, 2008 04:07PM


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.