[jira] [Resolved] (ASTERIXDB-1155) Limit clause won't work within a function

["Taewoo Kim (JIRA)" <ji...@apache.org>]

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

Taewoo Kim resolved ASTERIXDB-1155.
-----------------------------------
    Resolution: Fixed

> Limit clause won't work within a function
> -----------------------------------------
>
>                 Key: ASTERIXDB-1155
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1155
>             Project: Apache AsterixDB
>          Issue Type: Bug
>            Reporter: Steven Jacobs
>            Assignee: Taewoo Kim
>
> I can't find an example where a limit clause works within a function. Here is an example of one that doesn't work:
> DDL:
> drop dataverse emergencyTest if exists;
> create dataverse emergencyTest;
> use dataverse emergencyTest;
> create type EmergencyReport as {
> 	"id":int,
> 	"intensity":int
> }
> create dataset EmergencyReports(EmergencyReport)
> primary key id;
> //This works fine
> for $emergency in dataset EmergencyReports
> limit 1
> return $emergency.message
> //this fails
> create function mostIntenseEarthquakeNearLocation() {
> for $emergency in dataset EmergencyReports
> limit 1
> return $emergency.message
> };
> for $result in mostIntenseEarthquakeNearLocation()
> return $result;
> I've tried many combinations. Here is the top of the stack trace:
> at org.apache.asterix.aql.rewrites.CloneAndSubstituteVariablesVisitor.visitLimitClause(CloneAndSubstituteVariablesVisitor.java:285)
> 	at org.apache.asterix.aql.rewrites.CloneAndSubstituteVariablesVisitor.visitLimitClause(CloneAndSubstituteVariablesVisitor.java:1)
> 	at org.apache.asterix.aql.expression.LimitClause.accept(LimitClause.java:67)
> 	at org.apache.asterix.aql.rewrites.CloneAndSubstituteVariablesVisitor.visitFlworExpression(CloneAndSubstituteVariablesVisitor.java:117)
> 	at org.apache.asterix.aql.rewrites.CloneAndSubstituteVariablesVisitor.visitFlworExpression(CloneAndSubstituteVariablesVisitor.java:1)
> 	at org.apache.asterix.aql.expression.FLWOGRExpression.accept(FLWOGRExpression.java:82)
> 	at org.apache.asterix.aql.rewrites.InlineUdfsVisitor.inlineUdfsInExpr(InlineUdfsVisitor.java:341)
> 	at org.apache.asterix.aql.rewrites.InlineUdfsVisitor.visitForClause(InlineUdfsVisitor.java:220)
> 	at org.apache.asterix.aql.rewrites.InlineUdfsVisitor.visitForClause(InlineUdfsVisitor.java:1)
> 	at org.apache.asterix.aql.expression.ForClause.accept(ForClause.java:70)
> 	at org.apache.asterix.aql.rewrites.InlineUdfsVisitor.visitFlworExpression(InlineUdfsVisitor.java:194)
> 	at org.apache.asterix.aql.rewrites.InlineUdfsVisitor.visitFlworExpression(InlineUdfsVisitor.java:1)
> 	at org.apache.asterix.aql.expression.FLWOGRExpression.accept(FLWOGRExpression.java:82)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)