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
• Status: Verified
• Category: MySQL Server: Partitions
• Severity: S4 (Feature request)
• OS: Any
• CPU Architecture: Any
• Tags: DEFAULT, partition

[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.