[ASTERIXDB-2825] Internal error with invalid hint syntax in an invoked SQL++ function

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.9.6
• Fix Version/s: 0.9.7
• Component/s: *DB - AsterixDB, SQL - Translator SQL++
• Assignee: Dmitry Lychagin
• Reporter: Michael J. Carey
• Created: 28/Jan/21 21:48
• Updated: 03/Feb/21 19:42
• Resolved: 03/Feb/21 19:42

Description

DROP FUNCTION EmpsIn(dno) IF EXISTS;
DROP FUNCTION EmpsInDepts() IF EXISTS;
DROP DATASET Emps IF EXISTS;
DROP Dataset Depts IF EXISTS;
DROP TYPE AnyT IF EXISTS;

CREATE TYPE AnyT AS {id: UUID};
CREATE DATASET Emps(AnyT)
PRIMARY KEY id AUTOGENERATED;
CREATE DATASET Depts(AnyT)
PRIMARY KEY id AUTOGENERATED;

INSERT INTO Emps ([
{"eno": 1, "ename":"Till", "job":"Manager", "dno":1},
{"eno": 2, "ename":"Dmitry", "job":"Architect", "dno":1},
{"eno": 3, "ename":"Eben", "job":"Designer", "dno":2}
]);

INSERT INTO Depts ([
{"dno": 1, "dname":"Analytics", "floor":2},
{"dno": 2, "ename":"UI", "floor":3}
]);

CREATE FUNCTION EmpsInDepts( )

{ SELECT * FROM Emps /*+ card=12000 */ AS emp, Depts /* card=1000 */ AS dept WHERE emp.dno /* jcard = 12:1 */ = dept.dno }

;

SELECT VALUE ed FROM EmpsInDepts() ed;  – error occurs here - may be intermittent (which seems very odd)