[CALCITE-4782] Allow 'CAST(numeric AS BOOLEAN)' (if enabled by conformance)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: xuyang
• Created: 17/Sep/21 03:11
• Updated: 28/Aug/23 20:11

Description

SQL:

// code placeholder
select * from xxx where cast(n as boolean)

In calcite, casting a non-zero number to boolean is always false, which is different with other databases. The other databases shows that casting zero to boolean is false and casting non-zero value to boolean is true.

Issue Links

• is duplicated by: CALCITE-5959 Cast(200 as boolean) should return true(consistent with Postgres and Mysql)
• is duplicated by: CALCITE-4777 Casting from DECIMAL to BOOLEAN throws an exception
• is duplicated by: CALCITE-4810 Failed to cast a double field (which isn't a literal) to boolean in the test case.
• is related to: CALCITE-5662 CAST(BOOLEAN as INTEGER) throws a NumberFormatException