[jira] [Created] (ASTERIXDB-1876) UDF fails in select statement in SQL++

[Steven Jacobs (JIRA)]

Steven Jacobs created ASTERIXDB-1876:
----------------------------------------

             Summary: UDF fails in select statement in SQL++
                 Key: ASTERIXDB-1876
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1876
             Project: Apache AsterixDB
          Issue Type: Bug
            Reporter: Steven Jacobs
            Assignee: Yingyi Bu


drop dataverse channels if exists;
create dataverse channels;
use channels;

create type UserLocation as closed {
        recordId: integer,
        userName: string
}

create dataset UserLocations(UserLocation)
primary key recordId;

create function RecentEmergenciesNearUser(userName) {  
  (SELECT r AS report
  FROM EmergencyReports r, UserLocations l
  where l.userName = userName 
  and spatial_intersect(r.location,l.location))
}

select *
from channels.UserLocations location,
channels.RecentEmergenciesNearUser(location.userName) result;



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)