You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Michael J. Carey (JIRA)" <ji...@apache.org> on 2017/03/08 17:39:38 UTC

[jira] [Created] (ASTERIXDB-1828) Ugly error message for bad quote characters!

Michael J. Carey created ASTERIXDB-1828:
-------------------------------------------

             Summary: 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
         Environment: Mac OSX 
            Reporter: Michael J. Carey
            Assignee: Ian Maxon


This sequence of steps:

    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"}
    ]);

Yields this poor user experience due to all the quote escaping gobbledy gook:

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]





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