[CALCITE-877] Allow ROW as argument to COLLECT

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 07/Sep/15 18:32
• Updated: 27/Feb/24 22:24
• Resolved: 07/Oct/15 19:30

Description

We would like to build multisets of records, for instance all of the employees in a department:

SELECT deptno, COLLECT(ROW(ename, salary)) AS emps
FROM emp
GROUP BY deptno

Standard SQL only allows ROW inside a table constructor (i.e. a VALUES clause). A workaround is to create a user-defined type (CREATE TYPE; see http://www.oracle-developer.net/display.php?id=306) but it would be preferable to be able to create rows of anonymous type, so that the above SELECT statement just works.

Issue Links

• relates to: CALCITE-855 Allow UNNEST to have multiple arguments