MySQL Forums
Forum List  »  Partitioning

Weird: explain partitions says a single row belong to two partitions...
Posted by: Christian Cunlif
Date: September 11, 2008 09:08AM

Hi,

I have a table partitioned with an int column ID.
I run the query:
explain partitions select ID, date from mypurchase where ID = 37

and it returns (in the partition column):
d_21, d_23
which corresponds to 2 partitions!!?

If I run a "SELECT partition_name, partition_description FROM information_schema.PARTITIONS WHERE ...", I get:
name description
d_20 35
d_21 37
d_23 39


So why does "explain partitions" return 2 partition for a single record? A bug?

Thanks for your help
Chris

Options: ReplyQuote


Subject
Views
Written By
Posted
Weird: explain partitions says a single row belong to two partitions...
5153
September 11, 2008 09:08AM


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.