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

Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

    XMLWordPrintableJSON

Details

    Description

      Document Oracle-specific functions (DECODE, NVL, LTRIM, RTRIM, SUBSTR, GREATEST, LEAST) in the SQL reference.

      Same goes for MySQL-specific functions (e.g. JSON_TYPE).

      I don't think we should have separate lists of Oracle-specific functions and MySQL-specific functions. Because quite a few functions appear in more than one place. Better, I think, to have a concise annotation against each function which tables it occurs in.

      The current list of tables is standard, oracle, spatial, mysql. Perhaps also indicate whether a function is an extension to the SQL standard but still occurs in Calcite's default table.

      Attachments

        Issue Links

          Blocked

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-3016 Reorganize the operator tables

          • Major - Major loss of function.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-2876 Add MySQLSqlOperatorTable

          • Major - Major loss of function.
          • Closed
          relates to

          Sub-task - The sub-task of the issue CALCITE-3074 Move MySQL's JSON operators to SqlLibraryOperators

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2965 Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-2459 Add implementation of From_Base64 to SqlFunctions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-2460 Implement TO_BASE64 and FROM_BASE64 functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Task - A task that needs to be done. CALCITE-2867 JSON support

          • Major - Major loss of function.
          • In Progress

          Task - A task that needs to be done. CALCITE-2510 Add CHR built-in function (Oracle only)

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #1189

          Activity

            People

              julianhyde Julian Hyde
              julianhyde Julian Hyde
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h
                  1h