9842871771
76%
BABEL_5_X_DEV: 77%

Ran 08 Jul 2024 04:48PM UTC

Jobs 1

Files 114

Run time 1min

Badge

Embed ▾

Committed 08 Jul 2024 03:54PM UTC coverage: 73.199%. Remained the same

Build # 9842871771

Build Type

push

github

Committed by

web-flow

Commit Message

Include ordering for constraints on babelfish tables (#2688)

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

42877 of 58576 relevant lines covered (73.2%)

114384.39 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	9842871771.1	08 Jul 2024 04:48PM UTC	114	73.2	GitHub Action Run

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

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 9842871771

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

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 9842871771

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

README BADGES
x