1
77%
BABEL_6_X_DEV: 77%

Ran 21 Apr 2026 02:58PM UTC

Files 121

Run time 6s

Badge

Embed ▾

Committed 21 Apr 2026 02:18PM UTC coverage: 76.825% (+0.002%) from 76.823%

Job # 24727553804.1

Build Type

push

github

Committed by

web-flow

Commit Message

Fix missing xmlns:xsi namespace on elements when using FOR XML RAW('') with ELEMENTS XSINIL (#4765)

Currently, when using FOR XML RAW('') , ELEMENTS XSINIL (empty element name), Babelfish omits the xmlns:xsi namespace declaration from the output elements. T-SQL places xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" on every element when there is no row wrapper element, since there is no parent element to inherit the namespace from.

For example, SELECT 1 AS a, NULL AS b FOR XML RAW(''), ELEMENTS XSINIL produces:

Babelfish (before): <a>1</a><b xsi:nil="true"/>

T-SQL: <a xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">1</a> <b xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>

With this change, Babelfish now adds the xmlns:xsi namespace declaration to each element when RAW('') is used with ELEMENTS XSINIL, matching T-SQL behavior. This applies to both non-null elements and nil elements.

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

Coverage Stats

53065 of 69073 relevant lines covered (76.82%)

407783.54 hits per line

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

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 24727553804.1

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

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 24727553804.1

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

README BADGES
x