9859308048
74%
BABEL_5_X_DEV: 77%

Ran 09 Jul 2024 03:38PM UTC

Jobs 1

Files 114

Run time 1min

Badge

Embed ▾

Committed 09 Jul 2024 02:50PM UTC coverage: 73.419%. Remained the same

Build # 9859308048

Build Type

push

github

Committed by

web-flow

Commit Message

Include ordering for constraints on babelfish tables (#2688) (#2718)

Babelfish supports column ordering and NULLs ordering in table constraints but PG does not. It was implemented through special grammar rule and few dialect T-SQL dialect dependent logic in engine. Currently this is not handled in pg_dump so the information about column/nulls ordering gets lost during dump. Although, this information is available
in the underlying index for a UNIQUE/PRIMARY KEY constraint but this information anyway gets lost since the underlying index does not get dumped for a UNIQUE/PRIMARY KEY constraint, instead it is dumped as a constraint.

To fix this issue, we will now dump the underlying index of a UNIQUE/PRIMARY KEY constraint and make use of ALTER TABLE ADD CONSTRAINT USING snytax to add that as constraint. Postgres disallows creation of an constraint using index like this for non default sort ordering as native pg_dump does not handle such constraints. So we will need to bypass that check for Babelfish dump/restore with this special handling in bbf_dump.

Task: BABEL-4888
Signed-off-by: Rishabh Tanwar <ritanwar@amazon.com>

Engine PR: https://github.com/babelfish-for-postgresql/postgresql_modified_for_babelfish/pull/395

Run Details

42167 of 57433 relevant lines covered (73.42%)

108769.18 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	9859308048.1	09 Jul 2024 03:38PM UTC	114	73.42	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 9859308048
74%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 9859308048

babelfish-for-postgresql / babelfish_extensions / 9859308048 74% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 9859308048

babelfish-for-postgresql / babelfish_extensions / 9859308048
74%
BABEL_5_X_DEV: 77%

README BADGES
x