[
https://issues.apache.org/jira/browse/CALCITE-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
LakeShen updated CALCITE-5915:
------------------------------
Attachment: image-2023-08-13-23-11-56-589.png
> 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,
> image-2023-08-13-23-11-56-589.png
>
>
> Not sure if it is a bug becuase the query plans in this case might not be
> final and require further expanding, but the SQL hints might not be
> propagated to subqueries when SqlToRelConverter#withExpand==false. This
> happens because hints are pushed down with
> _RelOptUtil#RelHintPropagateShuttle_ and
> _RelOptUtil#SubTreeHintPropagateShuttle_ which travese through
> _RelNode#getInputs()_. But what if node is not accessible as other node’s
> input like keeping in _LogicalFilter#condition_? Then the shuttles skip such
> nodes.
> Test attached.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
