You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Hans Zeller (JIRA)" <ji...@apache.org> on 2016/10/27 19:34:58 UTC

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

Hans Zeller created TRAFODION-2320:
--------------------------------------

             Summary: 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.4#6332)