[ https://issues.apache.org/jira/browse/CALCITE-5557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Oliver Lee updated CALCITE-5557: -------------------------------- Summary: Add SAFE_CAST (BigQuery compatibility) (was: Add SAFE_CAST (big BigQuery compatibility)) > Add SAFE_CAST (BigQuery compatibility) > -------------------------------------- > > Key: CALCITE-5557 > URL: https://issues.apache.org/jira/browse/CALCITE-5557 > Project: Calcite > Issue Type: New Feature > Reporter: Oliver Lee > Assignee: Oliver Lee > Priority: Minor > > Implement SAFE_CAST per BigQuery specifications > [https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#safe_casting] > Equivalent to CAST(), except it will return {{null}} instead of throwing an > exception if the casting fails. > {quote}SAFE_CAST('1' as INT) -> 1 > SAFE_CAST('a' as INT) -> NULL > SAFE_CAST("2022-12-12" as DATE) -> DATE('2022-12-12') > SAFE_CAST(1 AS BOOLEAN) -> true > SAFE_CAST('A' AS BOOLEAN) -> null > {quote} > -- This message was sent by Atlassian Jira (v8.20.10#820010)