[
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)
