27553365372
78%

Ran 15 Jun 2026 02:56PM UTC

Jobs 1

Files 128

Run time 1min

Badge

Embed ▾

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

Build # 27553365372

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

Coverage Regressions

Lines	Coverage	∆	File
55	89.6	0.02%	contrib/babelfishpg_tsql/src/tsql_for/forxml.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	27553365372.1	15 Jun 2026 02:56PM UTC	128	76.95	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 27553365372
78%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Coverage Regressions

Jobs

Source Files on build 27553365372

babelfish-for-postgresql / babelfish_extensions / 27553365372 78%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Coverage Regressions

Jobs

Source Files on build 27553365372

babelfish-for-postgresql / babelfish_extensions / 27553365372
78%

README BADGES
x