]
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.