babelfish-for-postgresql / babelfish_extensions / 17905829066

77%

Build Type

push

github

Committed by web-flow

Commit Message

Added support OPENXML without WITH clause  (#4091)

This PR adds support for OPENXML without WITH Clause which provides an edge table which represent XML document structure in a single table.
The syntax of openxml without WITH clause is as follows :

OPENXML ( idoc int [ in ] , rowpattern nvarchar [ in ] [, flags byte [ in ] ] )

This support is added by implementing a C function OPENXML_SIMPLE which uses libxml2 APIs to parse the XML document and evaluate given XML document against row pattern. Also added function assign_ids to maintain unique ids for each nodes in XML document, and function add_node_details which traverse over all the evaluated XML nodes and fetches each node details and populate them in the form of rows.

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

Task: BABEL-6046

Signed-off-by: Rohit Bhagat rohitbgt@amazon.com

Run Details

363 of 389 new or added lines in 3 files covered. (93.32%)

59 existing lines in 2 files now uncovered.

51550 of 67294 relevant lines covered (76.6%)

380192.61 hits per line