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)
