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

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.13.6, 1.14.3, 1.15.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: xuyang
• Reporter: xuyang
• Created: 17/Sep/21 08:20
• Updated: 12/Aug/22 09:26
• Resolved: 20/Oct/21 09:33

Description

The same cast in the following two sql:

// SQL 1
SELECT cast(0.1 as boolean)

// SQL 2
SELECT * from test2 where cast(0.1 as boolean)

has different results.

The cast result in SQL 1 is true and the cast in SQL 2 is false.

Issue Links

• links to: GitHub Pull Request #17311