[ 
https://issues.apache.org/jira/browse/FLINK-36715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18004354#comment-18004354
 ] 

Sergey Nuyanzin commented on FLINK-36715:
-----------------------------------------

[~au_miner] are you sure?

In order to reproduce it you first need to drop RexUtil from Flink repo which 
is currently a WA for this

I don't know what kind of join you use in your test (broadcast, shuffle, 
nestedloop, etc...)
the test you can use to reproduce (after RexUtil removal)
{{org.apache.flink.table.planner.plan.batch.sql.join.JoinTestBase#testInnerJoinWithJoinConditionPushDown}}
  (there are also others)

> Changed behavior for filter push down for IS NOT DISTINCT FROM  after Calcite 
> upgrade to 1.33
> ---------------------------------------------------------------------------------------------
>
>                 Key: FLINK-36715
>                 URL: https://issues.apache.org/jira/browse/FLINK-36715
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / API, Table SQL / Planner
>            Reporter: Sergey Nuyanzin
>            Priority: Major
>
> After moving to 1.33 need to put RexUtil into Filnk repo to prevent a number 
> of failures (more than 30)
> like 
> {noformat}
> FlinkLogicalCalc(select=[CAST(0:BIGINT AS BIGINT) AS k, v, k AS k0, v0])
> +- FlinkLogicalJoin(condition=[true], joinType=[left])
>    :- FlinkLogicalCalc(select=[v], where=[=(k, 0:BIGINT)])
>    :  +- FlinkLogicalLegacyTableSourceScan(table=[[default_catalog, 
> default_database, src, source: [TestTableSource(k, v)]]], fields=[k, v])
>    +- FlinkLogicalValues(type=[RecordType(BIGINT k, VARCHAR(2147483647) v)], 
> tuples=[[]])
> This exception indicates that the query uses an unsupported SQL feature.
> Please check the documentation for the set of currently supported SQL 
> features.
> {noformat}
> This is a result of https://issues.apache.org/jira/browse/CALCITE-5336
> the jira issue is to adapt Flink behavior and to remove RexUtil after that 
> from Flink repo



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to