MySQL Forums
Forum List  »  Partitioning

ENUM partitioning options?
Posted by: Nicholas Semenkovich
Date: August 15, 2011 10:48AM

I'm trying to work around the ENUM partition bug (http://bugs.mysql.com/bug.php?id=39548)


I have a table that I'd like to partition on ENUM. Due to some dependencies, I can't easily convert the ENUM to any other type (TINYINT, etc.).

Is there any way to partition (even hackishly) on the ENUM so pruning works?

PARTITION BY LIST(ENUM COLUMN) fails with "The PARTITION function returns the wrong type"

PARTITON BY KEY(ENUM) claims to work, but it doesn't look like pruning ever happens ("EXPLAIN PARTITIONS" shows all partitions are always selected)


Are there any workarounds? CAST is no longer allowed -- does ABS(ENUM COLUMN) work for ENUM partitioning?

Options: ReplyQuote


Subject
Views
Written By
Posted
ENUM partitioning options?
3764
August 15, 2011 10:48AM
1595
August 16, 2011 09:50AM


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.