Bug #50566 Add "catch-all" (default) partition in partition by list
Submitted: 23 Jan 2010 14:17 Modified: 23 Jan 2010 14:43
Reporter: Egor Ivkin Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Partitions Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: DEFAULT, partition
Triage: Needs Triage: D5 (Feature request)

[23 Jan 2010 14:17] Egor Ivkin
Description:
Add "catch-all"(DEFAULT) partition in partition by list

How to repeat:
Exemple from Oracle Database: 

CREATE TABLE sales_list 
(salesman_id NUMBER(5), 
salesman_name VARCHAR2(30), 
sales_state VARCHAR2(20), 
sales_amount NUMBER(10), 
sales_date DATE) 
PARTITION BY LIST(sales_state) 
( 
PARTITION sales_west VALUES('California', 'Hawaii'), 
PARTITION sales_east VALUES ('New York', 'Virginia', 'Florida'), 
PARTITION sales_central VALUES('Texas', 'Illinois'), 
PARTITION sales_other VALUES(DEFAULT) 
);
[23 Jan 2010 14:43] Valeriy Kravchuk
Thank you for the feature request.
[8 Sep 2010 12:06] Mattias Jonsson
Will create a worklog and try to get it into development.
[27 Jan 2011 11:37] Mattias Jonsson
marked bug#59769 as a duplicate of this.
[27 Jan 2011 12:06] Mattias Jonsson
Created WL#5781 for this.