babelfish-for-postgresql / babelfish_extensions / 29558588905

78%

BABEL_6_X_DEV: 78%

Build Type

push

github

Committed by web-flow

Commit Message

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

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

4 of 4 new or added lines in 1 file covered. (100.0%)

32 existing lines in 1 file now uncovered.

55950 of 72079 relevant lines covered (77.62%)

388612.87 hits per line