You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Liya Fan (Jira)" <ji...@apache.org> on 2020/11/02 03:35:00 UTC

[jira] [Commented] (CALCITE-4363) Need a utility to check if a SQL operator is standard

    [ https://issues.apache.org/jira/browse/CALCITE-4363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17224413#comment-17224413 ] 

Liya Fan commented on CALCITE-4363:
-----------------------------------

[~julianhyde] Thanks for your good suggestion. It seems like a more fundamental solution to the problem. 

> Need a utility to check if a SQL operator is standard
> -----------------------------------------------------
>
>                 Key: CALCITE-4363
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4363
>             Project: Calcite
>          Issue Type: Wish
>          Components: core
>            Reporter: Liya Fan
>            Assignee: Liya Fan
>            Priority: Major
>
> Currently, all standard SQL operators are defined in SqlStdOperatorTable.java as static members, not as enums. This makes it difficult to check if a SQL function is a standard one. 
> In many scenarios, we need such a check. For example, some optimizations can be performed, if we know the function is standard (not user-defined), because user-defined functions may have some unknown side-effects.
> To support the check, we only need to maintain a set that contains all standard operators. 
> Do you think such a utility should be supported?
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)