[ASTERIXDB-2211] Confusing name resolution related error message

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: COMP - Compiler, SQL - Translator SQL++
• Labels: triaged
• Assignee: Dmitry Lychagin
• Reporter: Michael J. Carey
• Created: 23/Dec/17 00:51
• Updated: 14/Mar/18 23:47

Description

From U-Washington a few months back (but still reproducible on our latest release):
This sequence of statements produces a weird error message - "Cannot find dataset prop3 in dataverse test nor an alias with name prop3 [AlgebricksException]". I tried to simplify it to eliminate the nested array of records, but doing that made everything work - so the problem lies therein...

DROP DATAVERSE test IF EXISTS;
CREATE DATAVERSE test;
USE test;
CREATE TYPE typeA AS

{ propA: string }

;
CREATE TYPE testType AS

{ prop1: string, prop2: [string], prop3: [typeA] }

;
CREATE DATASET test(testType) PRIMARY KEY prop1;
INSERT INTO test([

{ "prop1": "hello1", "prop2": ["world"], prop3:[] }

,
{ "prop1": "hello2", "prop2": ["world1", "world2"], prop3:

{ "propA": "a" }

},
{ "prop1": "hello3", "prop2": ["world1", "world2"], prop3: [

{ "propA": "a" }

,

{"propA": "A"}

] }
]);