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

[Michael J. Carey (Jira)]

     [ 
https://issues.apache.org/jira/browse/ASTERIXDB-2825?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Michael J. Carey updated ASTERIXDB-2825:
----------------------------------------
    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)

 

  was:
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;

 


> 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
>            Priority: Critical
>             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;  – error occurs here - may be 
> intermittent (which seems very odd)
>  



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