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 >> {"messageId":2,"authorId":1,"inResponseTo":4,"senderLocation":point("41.66,80.87"),"message":" dislike iphone its touch-screen is horrible"}<< Encountered <IDENTIFIER> "messageId" at column 11. [CompilationException]
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)