[jira] [Assigned] (CALCITE-2846) Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

["Hongze Zhang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-2846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hongze Zhang reassigned CALCITE-2846:
-------------------------------------

    Assignee: Hongze Zhang

> Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference
> -------------------------------------------------------------------------------
>
>                 Key: CALCITE-2846
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2846
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Hongze Zhang
>            Priority: Major
>
> Document Oracle-specific functions (DECODE, NVL, LTRIM, RTRIM, SUBSTR, GREATEST, LEAST) in the [SQL reference|https://calcite.apache.org/docs/reference.html].
> 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.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)