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

Add an extension operator table with Oracle-specific operators

    Details

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

      Description

      Add a mechanism to allow connections to use additional operator tables, the first of which will be one with Oracle-specific functions. We don't aim to do every function.

      Important functions:

      • DECODE
      • NVL
      • RTRIM
      • LTRIM
      • LPAD
      • RPAD
      • TO_CHAR
      • TO_NUMBER
      • TO_DATE
      • TRUNC
      • SUBSTR (different from standard SUBSTRING)
      • INSTR

      Easy:

      • PI
      • DEGREES
      • RADIANS
      • SIGN
      • GREATEST
      • LEAST

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                julianhyde Julian Hyde
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: