[CALCITE-5384] Implement LEFT/RIGHT String functions for BigQuery

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Assignee: Unassigned
• Reporter: Tanner Clary
• Created: 15/Nov/22 22:15
• Updated: 16/Nov/22 17:17
• Resolved: 16/Nov/22 17:17

Description

Implement support for the following BigQuery functions:

• LEFT(value, length)
  • Returns the leftmost length characters of value. If length is zero, an empty string or byte will be returned. If length is greater than length(value), value will be returned. If length is negative, an error will be returned.
• RIGHT(value, length)
  • Returns the rightmost length characters of value. Follows the same edge-case behavior as LEFT().

Issue Links

• is a child of: CALCITE-3005 Implement string functions: LEFT, RIGHT