Vladimir Steshin created CALCITE-5915:
-----------------------------------------
Summary: 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
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)
