10113933136
75%

Ran 26 Jul 2024 04:23PM UTC

Jobs 1

Files 115

Run time 1min

Badge

Embed ▾

Committed 26 Jul 2024 03:40PM UTC coverage: 73.511%. Remained the same

Build # 10113933136

Build Type

push

github

Committed by

web-flow

Commit Message

Add System Catalog Views for Partitions Metadata (#2783)

This commit introduces support for the following system views:

sys.partitions: To provide information about the individual partitions present in the database for both partitioned and non-partitioned indexes/tables.
sys.data_spaces: To provide information about the data spaces utilized by partition schemes.
sys.destination_data_spaces: To provide information about the destination data spaces associated with partition schemes.
Furthermore, this commit also updates the definition of the following existing views:

sys.indexes: Updates the definition to list HEAP entries for partitioned tables and updates the data_space_id column to the ID of the associated partition scheme.
sys.index_columns: Updates the definition to list HEAP entries for partitioned tables and entries for indexes of partitioned tables, which will be used to find the partitioning column.
sys.filegroups: Updates the datatype of the name column from SYSNAME to NVARCHAR(128).
These views, along with sys.partition_functions, sys.partition_schemes, sys.partition_parameters, and sys.partition_range_values which was added in 1ad4181, provide comprehensive information about the partitioning configuration in the database.

Task:
BABEL-4970

Signed-off-by: Sumit Jaiswal sumiji@amazon.com

Run Details

43716 of 59469 relevant lines covered (73.51%)

125407.47 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	10113933136.1	26 Jul 2024 04:23PM UTC	115	73.51	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 10113933136
75%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 10113933136

babelfish-for-postgresql / babelfish_extensions / 10113933136 75%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 10113933136

babelfish-for-postgresql / babelfish_extensions / 10113933136
75%

README BADGES
x