[ https://issues.apache.org/jira/browse/CALCITE-2440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16567657#comment-16567657 ]
Volodymyr Vysotskyi commented on CALCITE-2440: ---------------------------------------------- [~suez1224], the line of code you have provided in the Jira description, helped to fix a loss of field aliases for the cases of the queries where unnest was used in a non-root level. Could you please check a query you have provided? You are using column "a", does table "T" have such column, or you are trying to reference result of "unnest"? > SQL with UNNEST fail in volcano planner in some cases > ----------------------------------------------------- > > Key: CALCITE-2440 > URL: https://issues.apache.org/jira/browse/CALCITE-2440 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.17.0 > Reporter: Shuyi Chen > Assignee: Julian Hyde > Priority: Major > > After [CALCITE-2291|https://issues.apache.org/jira/browse/CALCITE-2291], > specifically, [this > line|https://github.com/apache/calcite/blob/7088dc7261d294b7c6d5c9f4463435e95f0b9c15/core/src/main/java/org/apache/calcite/sql2rel/SqlToRelConverter.java#L1952] > causes volcano planner to fail to find the best plan for query > {code:java} > SELECT a, s FROM T, UNNEST(T.c) as A (s) > {code} > . I'll try to write a unittest in Calcite to reproduce. [~cshi] [~vvysotskyi] > [~HanumathRao], can you provide some context? Thanks a lot. -- This message was sent by Atlassian JIRA (v7.6.3#76005)