[jira] [Commented] (CALCITE-823) Parser support to reset an option

["Julian Hyde (JIRA)" <ji...@apache.org>]

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

Julian Hyde commented on CALCITE-823:
-------------------------------------

I wouldn't necessarily do what Postgres does. But I see that [Oracle uses RESET]http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams004.htm] also.

I made a few comments on the pull request - can you fix these? Also please modify reference.md. With those changes, patch looks good.

> Parser support to reset an option
> ---------------------------------
>
>                 Key: CALCITE-823
>                 URL: https://issues.apache.org/jira/browse/CALCITE-823
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>            Reporter: Sudheesh Katkam
>            Assignee: Julian Hyde
>         Attachments: CALCITE-823-0.patch
>
>
> Specifically these statements:
> {code}
> ALTER scope RESET `option name`
> ALTER scope RESET ALL
> RESET `option name`
> RESET ALL
> SET `option name`
> {code}
> Additional tasks:
> + Make scope optional
> + Option name should be a CompoundIdentifier



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)