1
77%
BABEL_6_X_DEV: 77%

Ran 15 Jun 2026 02:56PM UTC

Files 128

Run time 11s

Badge

Embed ▾

Committed 15 Jun 2026 02:28PM UTC coverage: 76.947%. Remained the same

Job # 27553365372.1

Build Type

push

github

Committed by

web-flow

Commit Message

Fix xmlns:xsi placement for ELEMENTS XSINIL with ROOT in FOR XML RAW/PATH (#4855)

When using ELEMENTS XSINIL together with ROOT in FOR XML RAW or PATH mode, Babelfish was placing the
xmlns:xsi namespace declaration on each row element instead of on the ROOT element where it is expected to be at
ROOT element only.

Before:

<data xmlns:xsi="..."><row xmlns:xsi="..."><a>1</a><b xsi:nil="true"/></row></data>

After:

<data xmlns:xsi="..."><row><a>1</a><b xsi:nil="true"/></row></data>

When ROOT already carries the xmlns:xsi declaration, the per-row declaration is now suppressed. Without ROOT,
the per-row declaration is still emitted (matching T-SQL behavior for the no-ROOT case).

The aggregate state now tracks a has_root flag, set when the ROOT open-tag is emitted, and threads it into the
RAW and PATH emitters. When ROOT is present they skip the row-level xmlns:xsi since the ROOT already carries it;
without ROOT the existing emission is unchanged. The same flag also handles PATH('') with XSINIL (where xmlns
would otherwise repeat on each column element) and RAW('') with XSINIL — there the ROOT tag itself now
correctly includes xmlns:xsi.

Task: BABEL-6429

Signed-off-by: Japleen Kaur <amjj@amazon.com>

Coverage Stats

54384 of 70677 relevant lines covered (76.95%)

604659.94 hits per line

babelfish-for-postgresql / babelfish_extensions / 27553365372 / 1
77%
BABEL_6_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 27553365372.1

babelfish-for-postgresql / babelfish_extensions / 27553365372 / 1 77% BABEL_6_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 27553365372.1

babelfish-for-postgresql / babelfish_extensions / 27553365372 / 1
77%
BABEL_6_X_DEV: 77%

README BADGES
x