[
https://issues.apache.org/jira/browse/ASTERIXDB-2701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Till Westmann updated ASTERIXDB-2701:
-------------------------------------
Description:
HERE IS AN ERRONEOUS QUERY:
{noformat}
LET stop = ["is", "a", "and", "the", "of"]
FROM Messages AS msg, word_tokens(msg.message) AS word
WHERE NOT word IN ignore
GROUP BY word
SELECT word, COUNT(1) AS wordcnt
ORDER BY wordcnt DESC;
{noformat}
AND HERE IS ITS ERROR MESSAGE:
{noformat}
ASX1001: Syntax error: In line 3 >>LET stop = ["is", "a", "and", "the", "of"]<<
Encountered "stop" at column 5. [CompilationException]
{noformat}
AND HERE IS WHAT I WISH ITS ERROR MESSAGE WAS:
{noformat}
ASX1001: Syntax error: In line 3 >>LET stop = ["is", "a", "and", "the", "of"]<<
Encountered keyword "stop" at column 5. [CompilationException]
{noformat}
was:
HERE IS AN ERRONEOUS QUERY:
{{LET stop = ["is", "a", "and", "the", "of"]
FROM Messages AS msg, word_tokens(msg.message) AS word
WHERE NOT word IN ignore
GROUP BY word
SELECT word, COUNT(1) AS wordcnt
ORDER BY wordcnt DESC;}}
AND HERE IS ITS ERROR MESSAGE:
ASX1001: Syntax error: In line 3 >>LET stop = ["is", "a", "and", "the", "of"]<<
Encountered "stop" at column 5. [CompilationException]
AND HERE IS WHAT I WISH ITS ERROR MESSAGE WAS:
ASX1001: Syntax error: In line 3 >>LET stop = ["is", "a", "and", "the", "of"]<<
Encountered keyword "stop" at column 5. [CompilationException]
> Usability fix for error messages about keywords!
> ------------------------------------------------
>
> Key: ASTERIXDB-2701
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2701
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler, SQL - Translator SQL++
> Affects Versions: 0.9.4.1, 0.9.5
> Reporter: Michael J. Carey
> Assignee: Dmitry Lychagin
> Priority: Major
> Fix For: 0.9.7
>
>
> HERE IS AN ERRONEOUS QUERY:
> {noformat}
> LET stop = ["is", "a", "and", "the", "of"]
> FROM Messages AS msg, word_tokens(msg.message) AS word
> WHERE NOT word IN ignore
> GROUP BY word
> SELECT word, COUNT(1) AS wordcnt
> ORDER BY wordcnt DESC;
> {noformat}
> AND HERE IS ITS ERROR MESSAGE:
> {noformat}
> ASX1001: Syntax error: In line 3 >>LET stop = ["is", "a", "and", "the",
> "of"]<< Encountered "stop" at column 5. [CompilationException]
> {noformat}
> AND HERE IS WHAT I WISH ITS ERROR MESSAGE WAS:
> {noformat}
> ASX1001: Syntax error: In line 3 >>LET stop = ["is", "a", "and", "the",
> "of"]<< Encountered keyword "stop" at column 5. [CompilationException]
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
