[ASTERIXDB-1537] Interesting lexer error in SQL++ translator

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: *DB - AsterixDB, AQL - Translator AQL
• Labels: soon
• Environment: Binary snapshot of recent Master on OSX
• Assignee: Dmitry Lychagin
• Reporter: Michael J. Carey
• Created: 19/Jul/16 19:07
• Updated: 23/Aug/17 17:28

Description

THIS QUERY:

use TinySocial;
set simfunction "edit-distance";
set simthreshold "3";
select gbu.id as id, gbu.name as name,
(select element

{ "chirpScreenname": cmu.screenName, "chirpName": cmu.name }

from ChirpMessages cm
with cmu as cm.user
where cmu.name ~= gbu.name
}) as similarUsers
from GleambookUsers gbu;

RESULTS IN THIS ERROR:

Error: org.apache.asterix.lang.sqlpp.parser.ParseException: Lexical error at line 14, column 9. Encountered "}" but state stack is empty.
==> }) as similarUsers