[CALCITE-5989] Type inference for RPAD and LPAD functions (BIGQUERY) is incorrect

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.35.0
• Fix Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Mihai Budiu
• Created: 09/Sep/23 01:38
• Updated: 10/Nov/23 11:34
• Resolved: 29/Sep/23 20:25

Description

The type inference uses the type `ReturnTypes.ARG0_NULLABLE_VARYING` for the output.
This means that the output cannot be longer than arg0. This bug surfaces when the query is optimized.

Issue Links

• is related to: CALCITE-5813 Type inference for sql functions REPEAT, SPACE, XML_TRANSFORM, and XML_EXTRACT is incorrect
• is related to: CALCITE-5451 Implement LPAD() and RPAD() functions
• links to: GitHub Pull Request #3420