[teiid-issues] [JBoss JIRA] (TEIID-3821) Expand xml output types

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-3821.
-----------------------------------
    Fix Version/s: 8.12.2
                   8.13
       Resolution: Done


Added blob/varbinary output for xml, and expanded the validation of xml and text content types appropriately.  Did not add handling for array output yet as more research is needed as to what the correct approach is.

If hex output is needed, we may need to add an option clause similar to https://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0022188.html

Also was made for xmltable, but it may make sense to accept base64 binary by default instead to match the default output behavior.

> Expand xml output types
> -----------------------
>
>                 Key: TEIID-3821
>                 URL: https://issues.jboss.org/browse/TEIID-3821
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.12.2, 8.13
>
>
> XMLELEMENT/XMLFOREST, etc. should support outputting binary/blob as base64 binary.  Also array values could be output as a sequence - although support seems to be inconsistent there with other vendors.  
> Ideally XMLTABLE should support base64 binary in addition to hex binary as well.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)