MySQL Forums :: Partitioning :: BUG - ORDER BY when WHERE contains non partitioned index column

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