babelfish-for-postgresql / babelfish_extensions / 9613188327

75%

Build Type

push

github

Committed by web-flow

Commit Message

Support Partition Function and Partition Scheme in Babelfish (#2587)

This commit introduces support for Partition Functions and Partition Schemes in Babelfish. To manage the metadata related to these features, the following system catalogs have been added:

sys.babelfish_partition_function: This catalog stores the metadata for Partition Functions, which define the partitioning logic based on boundary values and option.

sys.babelfish_partition_scheme: This catalog stores the metadata for Partition Schemes, which define the partition function mapping for a partitioned table.

sys.babelfish_partition_depend: This catalog tracks the dependencies between Partition Schemes and the partitioned tables created using those schemes.

Additionally, this commit adds support for the following system views related to partition functions and schemes:

sys.partition_schemes: This view provides information about the defined partition schemes in the database.
sys.partition_functions: This view provides information about the defined partition functions in the database.
sys.partition_range_values: This view provides the boundary values defined for each range partition function.
sys.partition_parameters: This view provides information about the parameters used by partition functions.

Engine PR: babelfish-for-postgresql/postgresql_modified_for_babelfish#379

Task: BABEL-4910, BABEL-4967
Signed-off-by: Sumit Jaiswal <sumiji@amazon.com>

Run Details

475 of 554 new or added lines in 12 files covered. (85.74%)

2 existing lines in 1 file now uncovered.

42825 of 58498 relevant lines covered (73.21%)

110670.71 hits per line