Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1419

Some of JDBC string functions are not working: LOCATE with 3 params, LTRIM, RTRIM

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.11.0
    • Component/s: None
    • Labels:
      None

      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?

        Attachments

          Activity

            People

            • Assignee:
              kabhwan Jungtaek Lim
              Reporter:
              kabhwan Jungtaek Lim
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: