[CALCITE-1419] Some of JDBC string functions are not working: LOCATE with 3 params, LTRIM, RTRIM

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.11.0
• Assignee: Jungtaek Lim
• Reporter: Jungtaek Lim
• Created: 07/Oct/16 07:18
• Updated: 14/Mar/23 20:38
• Resolved: 12/Oct/16 00:05

Description

Below three functions are not working properly:

{fn LOCATE(string1, string2 [, integer])}
{fn LTRIM(string)}
{fn RTRIM(string)}

They're on supported list on SQL reference page, but in SqlOperatorBaseTest.testJdbcFn(), thery're marked as 'not works' with the reason.

Either moving them to 'Not implemented' on page or fixing them is necessary.

What would be better?

Issue Links

• relates to: CALCITE-5585 Add STRPOS() Function (Enabled for BigQuery)