[CALCITE-5389] Add STARTS_WITH and ENDS_WITH functions (for BIG_QUERY compatibility)

• Type: Improvement
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 1.33.0
• Labels: pull-request-available
• Assignee: Oliver Lee
• Reporter: Oliver Lee
• Created: 17/Nov/22 23:26
• Updated: 07/Feb/23 22:33
• Resolved: 08/Dec/22 04:07

Description

Adding support for STARTS_WITH and ENDS_WITH SQL functions. They are for compatibility with BIG_QUERY, and are enabled only in the BigQuery function library (lib=bigquery in the connect string).

Issue Links

• relates to: CALCITE-5415 In ByteString, add startsWith and endsWith methods
• links to: GitHub Pull Request #2980