[
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)
