xuyangzhong created FLINK-24318:
-----------------------------------
Summary: Casting a number to boolean has different results between
'select' fields and 'where' condition
Key: FLINK-24318
URL: https://issues.apache.org/jira/browse/FLINK-24318
Project: Flink
Issue Type: Bug
Components: Table SQL / Planner
Reporter: xuyangzhong
Fix For: 1.15.0
The same cast in the following two sql:
{code:java}
// SQL 1
SELECT cast(0.1 as boolean)
// SQL 2
SELECT * from test2 where cast(0.1 as boolean)
{code}
has different results.
The cast result in SQL 1 is true and the cast in SQL 2 is false.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
