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

Posted to dev@calcite.apache.org by "Paul Jackson (JIRA)" <ji...@apache.org> on 2018/01/10 19:38:00 UTC

[jira] [Created] (CALCITE-2131) Provide an option to NOT convert subquery to JOIN

Paul Jackson created CALCITE-2131:
-------------------------------------

             Summary: Provide an option to NOT convert subquery to JOIN
                 Key: CALCITE-2131
                 URL: https://issues.apache.org/jira/browse/CALCITE-2131
             Project: Calcite
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.15.0
            Reporter: Paul Jackson
            Assignee: Julian Hyde


It is not always valid to convert a subquery to a join. See https://issues.apache.org/jira/browse/CALCITE-2130 for a specific case.

Also, to ensure consistent behavior after conversion, some queries require the use of the SINGLE_VALUE function, which is not implemented for many dialects.

This improvement request is to expose some option that allows the user to indicate that the subquery should be retained rather than converted to a JOIN.




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)