[CALCITE-6117] Converting SAFE_CAST from RexCall to SqlCall fails to add the type as an argument

• Type: Bug
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 1.37.0
• Labels: pull-request-available
• Assignee: Will Noble
• Reporter: Will Noble
• Created: 14/Nov/23 01:21
• Updated: 06/May/24 22:19
• Resolved: 29/Nov/23 21:43

Description

BigQuery's SAFE_CAST function operates much like CAST. Currently, the unparsing logic is broken because it does not use the special logic for CAST in SqlImplementor.callToSql that turns the rex call's return type into the sql call's second argument.

Issue Links

• links to: GitHub Pull Request #3520