[
https://issues.apache.org/jira/browse/FLINK-32471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17748089#comment-17748089
]
grandfisher commented on FLINK-32471:
-------------------------------------
HI,[~337361...@qq.com] please review
[PR|https://github.com/apache/flink/pull/23088].
> IS_NOT_NULL can add to SUITABLE_FILTER_TO_PUSH
> ----------------------------------------------
>
> Key: FLINK-32471
> URL: https://issues.apache.org/jira/browse/FLINK-32471
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Reporter: grandfisher
> Priority: Major
> Labels: pull-request-available
>
> According to FLINK-31273:
> The reason for the error is that other filters conflict with IS_NULL, but in
> fact it won't conflict with IS_NOT_NULL, because operators in
> SUITABLE_FILTER_TO_PUSH such as 'SqlKind.GREATER_THAN' has an implicit
> filter 'IS_NOT_NULL' according to SQL Semantics.
>
> So we think it is feasible to add IS_NOT_NULL to the SUITABLE_FILTER_TO_PUSH
> list.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
