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)