[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 ] 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)
[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: -- Description: 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. was: 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 shuttle skips such nodes. Test attached. > 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 > > > 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)
[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: -- Description: 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 shuttle skips such nodes. Test attached. was: 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_ which travese through _RelNode#getInputs()_. But what if node is not accessible as other node’s input like keeping in _LogicalFilter#condition_? Then the shuttle skips such nodes. Test attached. > 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 > > > 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 shuttle skips such > nodes. > Test attached. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[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: -- Description: 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_ which travese through _RelNode#getInputs()_. But what if node is not accessible as other node’s input like keeping in _LogicalFilter#condition_? Then the shuttle skips such nodes. Test attached. was: 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_ which travese through _RelNode#getInputs()_. But what if node is not accessible as other node’s input like keeping in _LogicalFilter#condition_? Then the shuttle skips such nodes. I found tah may happen in qubqueries. Test attached. > 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 > > > 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_ which travese through > _RelNode#getInputs()_. But what if node is not accessible as other node’s > input like keeping in _LogicalFilter#condition_? Then the shuttle skips such > nodes. > Test attached. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[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: -- Description: 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_ which travese through _RelNode#getInputs()_. But what if node is not accessible as other node’s input like keeping in _LogicalFilter#condition_? Then the shuttle skips such nodes. I found tah may happen in qubqueries. Test attached. was: 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_ 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. > 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 > > > 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_ which travese through > _RelNode#getInputs()_. But what if node is not accessible as other node’s > input like keeping in _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)
[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: -- Description: 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_ 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. was: 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. > 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 > > > 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_ 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)
[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)
[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: (was: 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)
[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)