Julian Hyde created CALCITE-1225:
------------------------------------
Summary: UNNEST with join
Key: CALCITE-1225
URL: https://issues.apache.org/jira/browse/CALCITE-1225
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
UNNEST does not seem to be able to reference a column from another table in the
same FROM clause. For example,
{code}
SELECT a.*, b.*
FROM table1 AS a,
UNNEST(a.items) AS b
{code}
gives {{table A not found}}.
org.apache.calcite.test.JdbcTest.testUnnestArrayColumn tests this but is
currently flagged 'Ignore'.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
