-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.8.0
-
Component/s: None
-
Labels:None
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'.