[CALCITE-5585] Add STRPOS() Function (Enabled for BigQuery)

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Labels: pull-request-available
• Assignee: Tanner Clary
• Reporter: Tanner Clary
• Created: 14/Mar/23 17:16
• Updated: 27/Jul/23 10:22
• Resolved: 23/Mar/23 04:40

Description

BigQuery supports the STRPOS() function with accepts 2 character strings as arguments. The function returns the 1-based position of the first occurrence of the second string within the first (example below). If no occurrence is found, the function returns 0. The function also supports binary strings with the same behavior. Note that STRPOS differs from the standard POSITION function in that it counts the position of the character in a binary string, not the position of a byte.

EXAMPLE: STRPOS("abc", "bc") would return: 2.
EXAMPLE: STRPOS("abc", "d") would return: 0.

BigQuery docs

Issue Links

• is related to: CALCITE-1419 Some of JDBC string functions are not working: LOCATE with 3 params, LTRIM, RTRIM
• links to: GitHub Pull Request #3114