• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

babelfish-for-postgresql / babelfish_extensions / 10096853962
76%
BABEL_5_X_DEV: 77%

Build:
Build:
LAST BUILD BRANCH: babel_6032
DEFAULT BRANCH: BABEL_5_X_DEV
Ran 25 Jul 2024 04:03PM UTC
Jobs 1
Files 115
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

25 Jul 2024 03:19PM UTC coverage: 73.51% (+0.2%) from 73.267%
10096853962

push

github

web-flow
Support Table and Index Partitioning in Babelfish (#2702)

This commit introduces Support for Table and Index Partitioning in Babelfish, enabling users to partition large tables and indexes using partition schemes.

Key Changes:

1. Partitioned Table Support:
   - Added syntax support for creating partitioned tables using the `CREATE TABLE ... on PARTITION_SCHEME (column)` statement.
   - Implemented support for partitioned table using partition scheme, where child partitions are implicitly created by looking up the metadata of the partition function and partitioning column values.
   - Restricted InsertBulk operations for partitioned tables as they are not supported yet.
   - Restricted users from modifying Babelfish partitioned tables to attach, detach, or modify partitions of these tables to maintain data consistency in the Babelfish catalog. Existing users who have created partitioned tables from the PostgreSQL endpoint can continue to modify, attach, and detach partitions as usual.
   - Introduced sys.babelfish_partition_depend catalog to track the dependency between partitioned tables and the partition schemes used to create them. The catalog maintains consistent table name even after RENAME or DROP TABLE operations.

2. Partitioned Index Support:
   - Added syntax support for creating partitioned indexes using the `CREATE INDEX ... ON PARTITION_SCHEME (column)` statement.
   - Implemented support for creating aligned partitioned indexes, where the index partitioning scheme aligns with the underlying table partitioning scheme.
   - Restricted the ability to create non-aligned partitioned indexes with custom partition schemes.

3. System Catalog Views:
   - Modified system catalog views to exclude listing child partitions for partitioned tables and indexes.
   - Modified system catalog views to list the partitioned table along with regular tables.
   - These changes ensures that only the parent partitioned object is listed in t... (continued)

421 of 434 new or added lines in 8 files covered. (97.0%)

1 existing line in 1 file now uncovered.

43493 of 59166 relevant lines covered (73.51%)

114742.57 hits per line

New Missed Lines in Diff

Lines Coverage ∆ File
1
80.28
0.63% contrib/babelfishpg_tsql/src/hooks.c
1
90.24
0.04% contrib/babelfishpg_tsql/src/pl_handler.c
11
96.22
contrib/babelfishpg_tsql/src/pltsql_partition.c

Uncovered Existing Lines

Lines Coverage ∆ File
1
85.97
-0.06% contrib/babelfishpg_tsql/src/tsqlUnsupportedFeatureHandler.cpp
Jobs
ID Job ID Ran Files Coverage
1 10096853962.1 25 Jul 2024 04:03PM UTC 115
73.51
GitHub Action Run
Source Files on build 10096853962
  • Tree
  • List 115
  • Changed 80
  • Source Changed 8
  • Coverage Changed 10
Coverage ∆ File Lines Relevant Covered Missed Hits/Line
  • Back to Repo
  • Github Actions Build #10096853962
  • f03c712a on github
  • Prev Build on BABEL_4_X_DEV (#10088092084)
  • Next Build on BABEL_4_X_DEV (#10099031439)
  • Delete
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2025 Coveralls, Inc