Bug #69363 I want to ADD partition in table but got "ERROR 1499 (HY000): Too many partitio"
Submitted: 31 May 2013 10:55 Modified: 31 May 2013 11:36
Reporter: sourabh parashar Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Partitions Severity:S2 (Serious)
Version:5.1.55 OS:Linux
Assigned to: CPU Architecture:Any
Tags: ERROR 1499 (HY000), partition error

[31 May 2013 10:55] sourabh parashar
Description:
when we execute following query on partitioned table of live mysql database server,
we got this error -
------
mysql>ALTER TABLE abc_xyz ADD PARTITION ( PARTITION p1025 VALUES LESS THAN(735488));
ERROR 1499 (HY000): Too many partitions (including subpartitions) were defined

How to repeat:
We got this first time, previously when we extend partition, we did not get any error from server.
[31 May 2013 11:36] Miguel Solorzano
Thank you for the bug report.

http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html#partitioning-limitati...

"Maximum number of partitions.  The maximum possible number of partitions for a given table (that does not use the NDB storage engine) is 1024. This number includes subpartitions. ......."