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

[Michael J. Carey (Jira)]

Michael J. Carey created ASTERIXDB-2825:
-------------------------------------------

             Summary: Internal error with invalid hint syntax in an invoked 
SQL++ function
                 Key: ASTERIXDB-2825
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2825
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: *DB - AsterixDB, SQL - Translator SQL++
    Affects Versions: 0.9.6
            Reporter: Michael J. Carey
            Assignee: Dmitry Lychagin
             Fix For: 0.9.7


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;

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)