[CALCITE-5959] Cast(200 as boolean) should return true(consistent with Postgres and Mysql)

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 1.35.0
• Assignee: Unassigned
• Reporter: LakeShen
• Created: 27/Aug/23 04:52
• Updated: 28/Aug/23 01:26
• Resolved: 28/Aug/23 01:19

Description

For the sql :

select cast(200 as boolean)  

The above results are true in Mysql and Postgres.

But in calcite,the result is false:

LogicalValues(tuples=[[{ false }]]) 

Issue Links

• duplicates: CALCITE-4782 Allow 'CAST(numeric AS BOOLEAN)' (if enabled by conformance)