asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael J. Carey (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (ASTERIXDB-1828) Ugly error message for bad quote characters!
Date Wed, 08 Mar 2017 20:11:38 GMT

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

Michael J. Carey updated ASTERIXDB-1828:
----------------------------------------
    Component/s: Web Interface
                 Translator - SQL++
                 Error Reporting
                 Compiler
                 AsterixDB

> Ugly error message for bad quote characters!
> --------------------------------------------
>
>                 Key: ASTERIXDB-1828
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1828
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: AsterixDB, Compiler, Error Reporting, Translator - SQL++, Web Interface
>         Environment: Mac OSX 
>            Reporter: Michael J. Carey
>            Assignee: Ian Maxon
>
> This sequence of steps:
> {noformat}
>     DROP DATAVERSE TinySocial2 IF EXISTS;
>     CREATE DATAVERSE TinySocial2;
>     USE TinySocial2;
>     CREATE TYPE GleambookMessageType AS {
>         messageId: int,
>         authorId: int,
>         inResponseTo: int?,
>         senderLocation: point?,
>         message: string
>     };
>     CREATE DATASET GleambookMessages(GleambookMessageType)
>         PRIMARY KEY messageId;
>     INSERT INTO GleambookMessages ([
>         {"messageId":1,"authorId":3,"inResponseTo”:2,”senderLocation":point("47.16,77.75"),"message":"
love sprint its shortcut-menu is awesome:)”},
>         {"messageId":2,"authorId":1,"inResponseTo":4,"senderLocation":point("41.66,80.87"),"message":"
dislike iphone its touch-screen is horrible"}
>     ]);
> {noformat}
> Yields this poor user experience due to all the quote escaping gobbledy gook:
> {noformat}
> Syntax error: In line 19 >>        {&quot;messageId&quot;:2,&quot;authorId&quot;:1,&quot;inResponseTo&quot;:4,&quot;senderLocation&quot;:point(&quot;41.66,80.87&quot;),&quot;message&quot;:&quot;
dislike iphone its touch-screen is horrible&quot;}<< Encountered <IDENTIFIER>
&quot;messageId&quot; at column 11.  [CompilationException]
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message