[
https://issues.jboss.org/browse/TEIID-4117?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-4117.
-----------------------------------
Fix Version/s: (was: 9.1)
Resolution: Rejected
While a logical change, this doesn't warrant modifying the already non-standard
handling of array types - as it can easily be worked around in the projection above by
using ifnull/nvl.
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
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)