[
https://issues.apache.org/jira/browse/CALCITE-5247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-5247:
Labels: pull-request-available (was: )
> FilterJoinRule cannot simplify left join to inn
[
https://issues.apache.org/jira/browse/CALCITE-5247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benchao Li updated CALCITE-5247:
Description:
For the following query:
{code:sql}
SELECT
*
FROM
(
SELECT
A.C0 AS
[
https://issues.apache.org/jira/browse/CALCITE-5247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benchao Li updated CALCITE-5247:
Description:
For the following query:
{code:sql}
SELECT
*
FROM
(
SELECT
A.C0 AS
[
https://issues.apache.org/jira/browse/CALCITE-5247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benchao Li updated CALCITE-5247:
Summary: FilterJoinRule cannot simplify left join to inner join for `WHERE
RHS.C1 IS NOT NULL OR