[teiid-issues] [JBoss JIRA] (TEIID-5746) Add support for a multi-row array table

[Steven Hawkins (Jira)]

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

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


Added support directly into arraytable to remove the need for using the arrayiterate procedure.

> Add support for a multi-row array table
> ---------------------------------------
>
>                 Key: TEIID-5746
>                 URL: https://issues.jboss.org/browse/TEIID-5746
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 12.3
>
>
> When arraytable was added, we had only limited support for 1 dimensional arrays.  It should support both a single row and a multi-row (multi-dimensional) case.
> The proposal is for the syntax:
> arraytable([row|rows] ...)
> if it is not specified or row, it is a single row result.  If rows, then it will expect a multi-dimensional array and produce 1 row per element in the outer array.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)