Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-1258

Sqlpp does not recognize recursive UDF calls

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: *DB - AsterixDB
    • Labels:
      None

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

        Attachments

          Activity

            People

            • Assignee:
              buyingyi Yingyi Bu
              Reporter:
              mhubail Murtadha Makki Al Hubail
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: