babelfish-for-postgresql / babelfish_extensions / 17974351503

78%

BABEL_6_X_DEV: 78%

Build Type

push

github

Committed by web-flow

Commit Message

Add support for OPENXML with WITH clause (#3820)

OPENXML provides a rowset view over an XML document. Since OPENXML is a rowset provider and it returns a set of
rows, we can use OPENXML in the FROM clause of a TSQL query just as we can use any other table, view, or table-
valued function. The WITH clause in OPENXML provides a rowset format (and additional mapping information as
required) by using either SchemaDeclaration or specifying an existing TableName.

Primary objective of this commit is to add support for OPENXML with WITH clause.

The syntax of openxml is as follows :

OPENXML ( idoc int [ in ] , rowpattern nvarchar [ in ], [ flags byte [ in ] ] )
    [ WITH ( SchemaDeclaration | TableName ) ]

Arguments:
idoc - The document handle of the internal representation of an XML document. The internal representation of an XML
document is created by calling sp_xml_preparedocument.
rowpattern - The XPath pattern used to identify the nodes to be processed as rows. The nodes come from the XML
document whose handle is passed in the idoc parameter.
flags - Indicates the mapping used between the XML data and the relational rowset, and how the spill-over column is
filled. flags is an optional input parameter.

The WITH clause provides a rowset format (and additional mapping information as required) by using either
SchemaDeclaration or specifying an existing TableName. If the optional WITH clause isn't specified, the results are
returned in an edge table format. Edge tables represent the fine-grained XML document structure (such as
element/attribute names, the document hierarchy, the namespaces, PIs, and so on) as a single table.

Engine PR : babelfish-for-postgresql/postgresql_modified_for_babelfish#587

Task: BABEL-3635, BABEL-6045
Signed-off-by: Harsh Dubey <harshdu@amazon.com>

Coverage Stats

110 of 122 new or added lines in 5 files covered. (90.16%)

1067 existing lines in 6 files now uncovered.

51664 of 67418 relevant lines covered (76.63%)

382234.59 hits per line