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

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

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

Till updated ASTERIXDB-1828:
----------------------------
    Description: 
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}



  was:
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]




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