[
https://issues.jboss.org/browse/TEIID-3362?page=com.atlassian.jira.plugin...
]
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)