You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2016/05/04 00:28:12 UTC
[jira] [Created] (CALCITE-1225) UNNEST with join
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)