You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Murtadha Hubail (JIRA)" <ji...@apache.org> on 2017/09/01 05:01:14 UTC

[jira] [Resolved] (ASTERIXDB-2050) Enforce a Semicolon After Each SQL++ Statement

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

Murtadha Hubail resolved ASTERIXDB-2050.
----------------------------------------
    Resolution: Fixed

> Enforce a Semicolon After Each SQL++ Statement
> ----------------------------------------------
>
>                 Key: ASTERIXDB-2050
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2050
>             Project: Apache AsterixDB
>          Issue Type: Improvement
>          Components: SQL - Translator SQL++
>            Reporter: Murtadha Hubail
>            Assignee: Murtadha Hubail
>
> Currently, only queries must be followed by a semicolon in SQL++ and it's optional to follow DDLs/DMLs with one. While this gives some flexibly to the user, it could lead to many unintentional errors and ambiguity.
> For example, when this is executed:
> {code:java}
> create dataverse x + 1 + 1;
> {code}
> The dataverse 'x' will be created and the following will be returned:
> {code:java}
> 2
> {code}
> The proposed solution to eliminate this ambiguity is to enforce a semicolon after every SQL++ statement.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)