[ASTERIXDB-1258] Sqlpp does not recognize recursive UDF calls

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Component/s: *DB - AsterixDB
• Assignee: Yingyi Bu
• Reporter: Murtadha Makki Al Hubail
• Created: 10/Jan/16 23:48
• Updated: 19/Jan/16 05:23
• Resolved: 19/Jan/16 05:23

Description

The following AQL statements correctly detect recursion on UDF (which is tested in runtimets/queries/cross-dataverse/cross-dv16). Whereas their equivelent Sqlpp statements throw the exception "SyntaxError: function testdv1.fun03@0 depends upon function testdv1.fun04@0 which is undefined"

drop dataverse testdv1 if exists;
create dataverse testdv1;

// UDF with no inputs
create function testdv1.fun01(){
testdv1.fun02()
}

// UDF with one input
create function testdv1.fun02(){
testdv1.fun03()
}

// UDF with two inputs
create function testdv1.fun03(){
testdv1.fun04()
}

create function testdv1.fun04(){
testdv1.fun02()
}

use dataverse testdv1;

testdv1.fun01()