Bug #83359 Please support : COLUMNS Partitioning

• Submitted: 13 Oct 2016 1:04
• Modified: 31 Jan 2018 16:51
• Reporter: 희원 이
• Status: Verified
• Category: MySQL Workbench: Modeling
• Severity: S4 (Feature request)
• Version: 6.3.7, 6.3.10
• OS: Any
• CPU Architecture: Any
• Tags: columns, partition, partitioning, table

[13 Oct 2016 1:04] 희원 이

Description:
MWB didn't support advanced partitioning, but support basic partitioning. 

for example "partition by range/list (...)" is basic function since MySQL-5.1, 
and now "partition by range/list columns (...)"is advanced function since MySQL-5.5 

So, I request MWB needs upgrade partition functionality. 

Best regards.

Ref : MySQL 5.7 Reference Manual / ... / COLUMNS Partitioning 
http://dev.mysql.com/doc/refman/5.7/en/partitioning-columns.html

How to repeat:
1. MWB modeler doesn't have "RANGE COLUMNS" or "LIST COLUMNS" in "Partition By:" option,
but have RANGE or LIST.

2. If I altered SOURCE table partition with "range/list columns" and execute "Synchronize Model", MWB makes weird result.

Suggested fix:
Please support advanced table partitioning.

[31 Jan 2018 16:51] MySQL Verification Team

Hello!!

Thank you for the feature request!

Thanks,
Umesh