Implement Sub-Partitioning and Detach Partition

Description

Continuation of ticket and implement the following enhancement:

  • Allow definition of second partition key column for sub-partition of table.

  • Add IsAttached flag to AD_TablePartition and support detach/attach of partition.

Test Case for sub-partition:

  1. Checked Partition flag for table AD_ChangeLog.

  2. Navigate to column AD_Client_ID, checked Partition Key and select List as the partitioning method. Partition sequence default to 10.

  3. Navigate to column Created, checked Partition Key, select Range as partitioning method and enter 6 month for partition range interval. Partition sequence default to 20.

  4. Run Create/Update Partition process.

  5. Table partition tab will be updated with primary partition created for column AD_Client_ID and sub-partition created for column Created.

Environment

None

Activity

Carlos Ruiz 
April 2, 2024 at 9:06 PM

I see this error in eclipse log frequently in a vanilla database, I haven't traced but I think is when I try to create new columns:

Heng Sin Low 
January 3, 2024 at 1:32 PM
(edited)

Will update the wiki documentation for Table Partitioning (the wiki doc link at IDEMPIERE-5943)

Carlos Ruiz 
January 3, 2024 at 1:11 PM

Hi - do this require documentation?

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

Created December 20, 2023 at 11:03 AM
Updated June 1, 2024 at 3:18 PM
Resolved April 3, 2024 at 10:06 AM