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

Posted to issues@calcite.apache.org by "Vladimir Steshin (Jira)" <ji...@apache.org> on 2023/08/10 14:15:00 UTC

[jira] [Updated] (CALCITE-5915) Missing SQL hints in not-expanded subqueries.

     [ https://issues.apache.org/jira/browse/CALCITE-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vladimir Steshin updated CALCITE-5915:
--------------------------------------
    Attachment: SqlHintsInSubqueriesWithDisabledExpanding.java

> Missing SQL hints in not-expanded subqueries. 
> ----------------------------------------------
>
>                 Key: CALCITE-5915
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5915
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Vladimir Steshin
>            Priority: Minor
>         Attachments: SqlHintsInSubqueriesWithDisabledExpanding.java
>
>
> The SQL hints might not be propagated in decorrelated subqueries when SqlToRelConverter#withExpand==false. This happens because hints are pushed down with _RelOptUtil#RelHintPropagateShuttle_ which travese through _RelNode#getInputs()_. But what if node is not accessible as other node’s input like _LogicalFilter#condition_? Then the shuttle skips such nodes. I found tah may happen in qubqueries. 
> Test attached.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)