Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
This query, when run on the attached data:
USE TopicalBird;
SELECT btag, about FROM Chirps WHERE about IN
(SELECT Topics.tid FROM Topics WHERE name = 'Kindle' OR name = 'Surface') ;
Yields this error msg:
Cannot resolve ambiguous alias reference for undefined identifier name [AlgebricksException]
It's not obvious to naive users (or me ) why this is an ambiguous reference. Could we improve this error msg somehow? This may be a fairly typical error pattern for SQL --> SQL++ users – i.e., they are used to SQL's unqualified column-naming permissiveness, and will carry those habits into NoSQL-land and then be perplexed at times.