You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "xuyangzhong (Jira)" <ji...@apache.org> on 2021/09/17 08:21:00 UTC

[jira] [Created] (FLINK-24318) Casting a number to boolean has different results between 'select' fields and 'where' condition

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)