[ASTERIXDB-1560] Misleading SQL++ error message when variables are undefined

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Component/s: *DB - AsterixDB, FAIL - Failure handling/reporting
• Assignee: Yingyi Bu
• Reporter: Michael J. Carey
• Created: 02/Aug/16 19:54
• Updated: 15/Aug/16 16:08
• Resolved: 15/Aug/16 16:08

Description

This query:
SELECT u.name AS uname, m.message AS message
FROM GleambookUsers u
UNNEST GleambookMessages m
WHERE m.authorId = user.id;

Yields this error message:
Cannot resolve ambiguous alias (variable) reference for identifier user [AlgebricksException]

The reference is undefined, not ambiguous, in this case.