[CALCITE-5662] CAST(BOOLEAN as INTEGER) throws a NumberFormatException

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Labels: pull-request-available
• Assignee: Oliver Lee
• Reporter: Oliver Lee
• Created: 19/Apr/23 18:17
• Updated: 28/Aug/23 01:28
• Resolved: 24/May/23 00:18

Description

Currently attempting to run SELECT CAST(BOOLEAN as INTEGER) will throw a NumberFormatException.

The BigQuery dialect allows casting boolean literals to the following: string, int64 , tinyint, smallint, bigint

src: https://cloud.google.com/bigquery/docs/reference/standard-sql/conversion_functions

Desired behavior:

SELECT CAST(TRUE as INTEGER) -> 1
SELECT CAST(TRUE as BIGINT) -> 1
SELECT CAST(FALSE as INTEGER) -> 0
SELECT CAST(null as INTEGER) -> null

Issue Links

• relates to: CALCITE-4782 Allow 'CAST(numeric AS BOOLEAN)' (if enabled by conformance)
• links to: GitHub Pull Request #3168