amazon-aurora / babelfish_extensions / 15963897630

76%

main: 77%

push

github

Added support for sp_xml_preparedocument and sp_xml_removedocument procedures  (#75)

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

198 of 223 new or added lines in 2 files covered. (88.79%)

49625 of 65404 relevant lines covered (75.87%)

315127.98 hits per line