Bug #13436 Partitions: most data types don't work
Submitted: 23 Sep 2005 17:34 Modified: 2 Dec 2009 13:52
Reporter: Peter Gulutzan Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: Partitions Severity:S4 (Feature request)
Version:5.1.2-alpha-debug OS:Linux (SUSE 9.2)
Assigned to: Mikael Ronström CPU Architecture:Any

[23 Sep 2005 17:34] Peter Gulutzan
Description:
I can only use variants of INT (tinyint, smallint, int, mediumint, bigint)
in partition clauses. Other data types don't work.

How to repeat:
mysql> CREATE TABLE T3 (s1 DECIMAL(1)) PARTITION BY HASH(s1);
ERROR 1461 (HY000): The PARTITION function returns the wrong type
[21 Aug 2008 10:26] Mattias Jonsson
All datatypes should work with KEY partitioning, but currently (5.1/6.0), only integers work with HASH/RANGE and LIST.

also see WL#3481
[2 Dec 2009 13:52] Mattias Jonsson
Most data types works with KEY() partitioning, or the new feature from WL#3352.