babelfish-for-postgresql / babelfish_extensions / 29575129651

77%

BABEL_6_X_DEV: 78%

push

github

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

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>

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

55798 of 72140 relevant lines covered (77.35%)

593084.55 hits per line