[jira] [Created] (OPTIQ-343) RelDecorrelator should build its own mappings, not inherit from SqlToRelConverter

["Julian Hyde (JIRA)" <ji...@apache.org>]

Julian Hyde created OPTIQ-343:
---------------------------------

             Summary: RelDecorrelator should build its own mappings, not inherit from SqlToRelConverter
                 Key: OPTIQ-343
                 URL: https://issues.apache.org/jira/browse/OPTIQ-343
             Project: Optiq
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


In order to get an efficient query to generate possible values of the correlation variable, we need to push filters into joins after sql-to-rel conversion but before decorrelation. But pushing filters messes up the mappings that are created by SqlToRelConverter and used by RelDecorrelator.

Currently Planner.onCopy is used to inform the planner about changes. But it cannot capture what PushFilterThroughJoinRule is doing.

I think the correct solution is to build the mappings needed by RelDecorrelator based on the current state of the RelNode tree. And re-build, if necessary, when a rule has fired.

Another benefit: it would be possible to use RelDecorrelator for queries not 



--
This message was sent by Atlassian JIRA
(v6.2#6252)