[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16830986#comment-16830986 ] 

Hongze Zhang commented on CALCITE-2846:
---------------------------------------

Thanks [~danny0405]. Can we include the spatial functions in the document changes too? Seems to be a nice addition to have.

> 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: Improvement
>          Components: site
>            Reporter: Julian Hyde
>            Assignee: Danny Chan
>            Priority: Major
>              Labels: documentation, pull-request-available
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> 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)