[teiid-issues] [JBoss JIRA] (TEIID-3362) Additional language constructs for arrays

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-3362.
-----------------------------------
    Resolution: Done


We already added support for values with multiple row values -

VALUES (1, 2), (3, 4) 

To provide a quick way of producing rows.

So for this issue a new system procedure ARRAYITERATE was added -

select * from (call ARRAYITERATE((1, 2, 3, 4, 5))) as x

would produce 5 single column rows.  However for simplicity it is weakly typed.  It expects an object[] parameter, and produces an object result. So more than likely a cast will be needed in most scenarios.

> Additional language constructs for arrays
> -----------------------------------------
>
>                 Key: TEIID-3362
>                 URL: https://issues.jboss.org/browse/TEIID-3362
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.11
>
>
> Additional handling for arrays, such as an unnest function (columns to rows), a 2 dimensional form or arraytable, array concat etc. would be beneficial.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)