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

Add support for translate (expession, from_string, to_string)

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7.0
    • Fix Version/s: 1.8.0
    • Component/s: None
    • Labels:
      None

      Description

      Calcite follows the standard SQL reference.
      SQL reference, ISO/IEC 9075-2:2011(E), section 6.30

      <character transliteration> ::=
      TRANSLATE <left paren> <character value expression>
      USING <transliteration name> <right paren>

      Need to add support for translate (expession, from_string, to_string) alternative syntax.
      Ex: Add the Oracle-style TRANSLATE function to SqlStdOperatorTable
      (call it say TRANSLATE3, since it has 3 parameters)

        Attachments

          Activity

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              arina Arina Ielchiieva
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: