Steven Hawkins created TEIID-4117:
-------------------------------------
Summary: Add explicit empty handling for array values in xmltable
Key: TEIID-4117
URL:
https://issues.jboss.org/browse/TEIID-4117
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.1
Currently we default to null on empty behavior, but it would be good to allow empty on
empty as well:
xmltable('/a' passing convert('<a></a>', xml) columns x
string[] path 'b')
will produce a null value, but in some cases you'd want to produce an empty array.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)