[
https://issues.apache.org/jira/browse/FLINK-16771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17066564#comment-17066564
]
Rui Li commented on FLINK-16771:
--------------------------------
I think the root cause is {{cast('123456789.123' as decimal(15,8))}} returns
null and the generated code doesn't properly handle this.
> NPE when filtering by decimal column
> ------------------------------------
>
> Key: FLINK-16771
> URL: https://issues.apache.org/jira/browse/FLINK-16771
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Reporter: Rui Li
> Priority: Major
>
> The following SQL can trigger the issue:
> {code}
> create table foo (d decimal(15,8));
> insert into foo values (cast('123.123' as decimal(15,8)));
> select * from foo where d>cast('123456789.123' as decimal(15,8));
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
