Attached is the patch to support the view part of the multilevel partitions. Users can perform all the operations except creating the partitions as a partitioned table. Users can create a partition table separately and attach it as a partition of another partition table.
Multilevel partitions are now manageable through the tree view except creating a partition table of existing partition (which you already mentioned).
One more problem that we already discussed that automatic tree refresh of the multilevel partitions is not working due to our structure which is going to be handled by the new RM.
- _get_children_nodes name can be changed as it more like private method but we are using it outside of the class itself.
Fixed.
- Stats of partition table is not displayed, but I think that is not related to this patch, so can be fixed later.
I have verified/confirmed that in the case of the Partitioned table, Statistics is visible only for the child node. In the case of the multilevel partitioned table, Statistics will only be available of the last child node which we are showing, so it's not a bug.
Thanks,
Khushboo
There are two problems mentioned in the RM. I have fixed the first one and we won't fix the second problem as by design we decided to show Partitions like Schema->Table->Partitions