MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

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

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


Subject
Views
Written By
Posted
BUG - ORDER BY when WHERE contains non partitioned index column
4632
duke hound
June 22, 2008 11:35AM
Re: BUG - ORDER BY when WHERE contains non partitioned index column
3436
Mattias Jonsson
June 24, 2008 04:07PM
Re: BUG - ORDER BY when WHERE contains non partitioned index column
2746
duke hound
June 28, 2008 10:42AM


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.