[jira] [Closed] (TRAFODION-2320) Make subquery unnesting work with common subexpressions

["Hans Zeller (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-2320?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hans Zeller closed TRAFODION-2320.
----------------------------------

> Make subquery unnesting work with common subexpressions
> -------------------------------------------------------
>
>                 Key: TRAFODION-2320
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2320
>             Project: Apache Trafodion
>          Issue Type: Sub-task
>          Components: sql-cmp
>    Affects Versions: 2.1-incubating
>            Reporter: Hans Zeller
>            Assignee: Hans Zeller
>
> The subquery unnesting code relies on a certain structure of the query tree, with join and groupby nodes arranged in a certain way. If we have CommonSubExprRef nodes present in the tree, the unnesting logic doesn't recognize some of the patterns and subquery unnesting doesn't take place.
> Hopefully we can somehow ignore these extra nodes in subquery unnesting.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)