Bug #13436 Partitions: most data types don't work

• Submitted: 23 Sep 2005 19:34
• Modified: 2 Dec 14:52
• Reporter: Peter Gulutzan
• Status: Won't fix
• Category: Server: Partition
• Severity: S4 (Feature request)
• Version: 5.1.2-alpha-debug
• OS: Linux (SUSE 9.2)
• Assigned to: Mikael Ronstrom
• Target Version: TBD
• Triage: D5 (Feature request)

[23 Sep 2005 19: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 12: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 14:52] Mattias Jonsson

Most data types works with KEY() partitioning, or the new feature from WL#3352.