MySQL Forums
Forum List  »  Partitioning

Re: Inner Joins, Compostie Keys and Partition issues
Posted by: Phil Hildebrand
Date: May 22, 2008 09:48PM

I didn't see any active bugs for this type of data issue, outside of this one:

But that's specific to list partitions.

One thing is that is a bigint(20), and is an int(10). I wouldn't think that would be related, but it's probably not best.

Have you tried the query with

and responder id between 6 and 8 ? (if you get the expected results).

It seems to me this could be some kind of bug...

If you can test with the same data, I would alter the table and change your partition ranges, and see if you get the same results.

I assume it works fine when the table is not partitioned?

Options: ReplyQuote

Written By
Re: Inner Joins, Compostie Keys and Partition issues
May 22, 2008 09:48PM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.