[ 
https://issues.apache.org/jira/browse/ASTERIXDB-2825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17278154#comment-17278154
 ] 

ASF subversion and git services commented on ASTERIXDB-2825:
------------------------------------------------------------

Commit 67714e2ac334b6455e977298ac9cd1a65a88d1b7 in asterixdb's branch 
refs/heads/master from Dmitry Lychagin
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=67714e2 ]

[ASTERIXDB-2825][COMP] Improve warning reporting

- user model changes: no
- storage format changes: no
- interface changes: no

Details:
- Report warnings when parsing user-defined functions

Change-Id: Ifd5e4f694c2903dd46245baeba0b866fd7cecb90
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/9786
Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Reviewed-by: Ali Alsuliman <ali.al.solai...@gmail.com>
Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu>


> 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)

Reply via email to