[CALCITE-1225] UNNEST with join

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.8.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 03/May/16 22:27
• Updated: 12/Jun/16 07:44
• Resolved: 04/May/16 18:00

Description

UNNEST does not seem to be able to reference a column from another table in the same FROM clause. For example,

SELECT a.*, b.*
FROM table1 AS a,
 UNNEST(a.items) AS b

gives table A not found.

org.apache.calcite.test.JdbcTest.testUnnestArrayColumn tests this but is currently flagged 'Ignore'.