[CALCITE-6270] Support FORMAT in CAST from Numeric and BYTES to String (Enabled in BigQuery)

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Jerin John
• Created: 17/Feb/24 01:32
• Updated: 05/Apr/24 23:33

Description

Calcite is missing the formats available in the following CAST functions in BigQuery, not adding the complete list here please refer to the links to see the unsupported formats:

• Numeric to STRING - Represented as NUMERIC/INTEGER types in Calcite
• BYTES <-> STRING - Represented as BINARY/VARBINARY types in Calcite

Issue Links

• is related to: CALCITE-2980 Implement the FORMAT clause of the CAST operator
• is related to: CALCITE-6210 Cast to VARBINARY causes an assertion failure