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

LAST BUILD BRANCH: query
DEFAULT BRANCH: BABEL_6_X_DEV
Ran
Files 121
Run time 5s
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
coverage: 76.632% (+0.03%) from 76.607%
17974351503.1

push

github

web-flow 
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>

51664 of 67418 relevant lines covered (76.63%)

382234.59 hits per line

Source Files on job 17974351503.1