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

[Steven Hawkins (Jira)]

Steven Hawkins created TEIID-5746:
-------------------------------------

             Summary: 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
             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)