29523958228
78%

Ran 16 Jul 2026 06:58PM UTC

Jobs 1

Files 128

Run time 1min

Badge

Embed ▾

Committed 16 Jul 2026 06:26PM UTC coverage: 77.644% (+0.003%) from 77.641%

Build # 29523958228

Build Type

push

github

Committed by

web-flow

Commit Message

Support RTE_NAMEDTUPLESTORE in FOR XML/JSON AUTO for trigger transition tables (#4897)

Currently, Babelfish's FOR XML AUTO and FOR JSON AUTO fail with "requires at least one table" when the query source is a named tuplestore specifically the INSERTED and DELETED transition tables inside AFTER triggers. With this change, these transition tables are now recognized as valid sources, and the query produces correct hierarchical XML/JSON output using the tuplestore name (e.g., "inserted", "deleted") as the element/object key name.

The fix was needed because PostgreSQL represents trigger transition tables as RTE_NAMEDTUPLESTORE range table entries, but the FOR AUTO valid-source check only accepted RTE_RELATION, RTE_SUBQUERY, RTE_CTE, RTE_GROUP, and user-defined RTE_FUNCTION.


Task: BABEL-6878
Signed-off-by: Rohit Bhagat <rohitbgt@amazon.com>

Coverage Stats

56028 of 72160 relevant lines covered (77.64%)

593209.8 hits per line

Coverage Regressions

Lines	Coverage	∆	File
169	90.37	0.0%	contrib/babelfishpg_tsql/src/pl_handler.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	29523958228.1	16 Jul 2026 06:58PM UTC	128	77.64	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 29523958228
78%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Coverage Regressions

Jobs

Source Files on build 29523958228

babelfish-for-postgresql / babelfish_extensions / 29523958228 78%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Coverage Regressions

Jobs

Source Files on build 29523958228

babelfish-for-postgresql / babelfish_extensions / 29523958228
78%

README BADGES
x