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)