babelfish-for-postgresql / babelfish_extensions / 17738048093

78%

BABEL_6_X_DEV: 78%

push

github

Added support for sp_xml_preparedocument and sp_xml_removedocument procedures (#3461)

Currently babelfish does not support procedures like sp_xml_preparedocument and sp_xml_removedocument. This PR adds support for the sp_xml_preparedocument and sp_xml_removedocument procedures.
The procedure sp_xml_preparedocument parses an XML text given as input , stores it at session level and returns a handle to this document, which can be used to fetch the document.
Similarly , the purpose of sp_xml_removedocument is to remove the internal representation of the XML document and invalidate that handle which was created using the sp_xml_preparedocument procedure.

The syntax for the procedures is as folllows:

sp_xml_preparedocument hdoc OUTPUT [ , xmltext ] [ , xpath_namespaces ] [ ; ]

hdoc is the handle to the newly created document. hdoc is an integer.
xmltext is the given XML document in text format. The default value is NULL.
xpath_namespaces is a text parameter which specifies the namespace declarations that are used in row and column XPath expressions in OPENXML. The default value is NULL.
sp_xml_removedocument hdoc [ ; ]

The handle to the already existing created document. A handle that isn't valid returns an error. hdoc is an integer.
BABEL-1168

---------

Signed-off-by: Harsh Dubey <harshdu@amazon.com>
Co-authored-by: Harsh Dubey <harshdu@amazon.com>

199 of 225 new or added lines in 2 files covered. (88.44%)

50752 of 66459 relevant lines covered (76.37%)

383898.24 hits per line