[ASTERIXDB-2701] Usability fix for error messages about keywords!

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.4.1, 0.9.5
• Fix Version/s: 0.9.8
• Component/s: COMP - Compiler, SQL - Translator SQL++
• Assignee: Dmitry Lychagin
• Reporter: Michael J. Carey
• Due: 21/Feb/20
• Created: 19/Feb/20 16:49
• Updated: 17/Feb/22 02:42

Description

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]