[ https://issues.apache.org/jira/browse/CALCITE-2440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16583181#comment-16583181 ]
Shuyi Chen commented on CALCITE-2440: ------------------------------------- [~vvysotskyi], table "T" does contains column "a". Could you please point me to the unittest that causes the loss of field aliases? [~julianhyde], do you have any good suggestion for me to reproduce the issue in calcite to debug the volcano planner? I hit the issue when I upgrade Apache Flink to use Calcite 1.17. But Flink have many rules and it's hard to find out which set of rules cause the issue. Thanks a lot. > 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)