Bug #83359 Please support : COLUMNS Partitioning
Submitted: 13 Oct 2016 1:04 Modified: 31 Jan 2018 16:51
Reporter: 희원 이 Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:6.3.7, 6.3.10 OS:Any
Assigned to: CPU Architecture:Any
Tags: columns, partition, partitioning, table

[13 Oct 2016 1:04] 희원 이
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 

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

Thank you for the feature request!