Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
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'.