babelfish-for-postgresql / babelfish_extensions / 26873033882

77%

BABEL_6_X_DEV: 77%

push

github

Add support for the method .query() for XML data type (#4845)

Currently, Babelfish supports .exist() and .value() XML methods but .query() was unsupported and threw an error.
With this change, .query(xpath) is now supported and returns XML results (for XPath 1.0 compatible queries).

The implementation follows the same 3-stage architecture like .exist() and .value():

ANTLR rewriting: @x.query('/path') is rewritten to sys.bbf_xmlquery('/path', @x)
Grammar: BBF_XMLQUERY is mapped in gram-tsql-rule.y
PL/pgSQL function sys.bbf_xmlquery(): validates the input type, checks QUOTED_IDENTIFIER, calls PostgreSQL's
xpath(), and returns the result as XML

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

36 of 38 new or added lines in 3 files covered. (94.74%)

54284 of 70331 relevant lines covered (77.18%)

396574.01 hits per line