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

["Sudheesh Katkam (JIRA)" <ji...@apache.org>]

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

Sudheesh Katkam updated CALCITE-823:
------------------------------------
    Attachment: CALCITE-823-0.patch

Attached a patch. I also opened a [pull request|https://github.com/apache/incubator-calcite/pull/128]. I am unable to change the status of the JIRA to REVIEWABLE or assign the JIRA to myself.

I made 'ALTER scope' part optional so implementors can assume a default scope (for Drill, we assume SESSION).

>From PostgreSQL, it looks like [RESET|http://www.postgresql.org/docs/8.4/static/sql-reset.html] (rather than UNSET) is available.

> 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)