Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-63147

function encountered an unexpected error: correlation reference xx is not in allowed.

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Yes

    Description

      create or replace function TEST_CTE_CORR(abc) {
       ( WITH CTE_1 AS ( Select 1 as CTE_1_Value ) ,
              CTE_2 AS ( Select c.*, abc from CTE_1 c ) 
         Select * from CTE_2 ) 
      };

       

      execute function TEST_CTE_CORR(123);
      {
          "requestID": "adbb8145-642d-411f-9591-98cc1b85e367",
          "signature": null,
          "results": [
          ],
          "errors": [
              {
                  "code": 10109,
                  "msg": "Error executing function 'TEST_CTE_CORR' ",
                  "reason": {
                      "_level": "exception",
                      "caller": "inline:143",
                      "code": 10103,
                      "icause": "Formalizer internal error: correlation reference CTE_1 is not in allowed",
                      "key": "function.internal.error",
                      "message": "Operation on function encountered an unexpected error: Formalizer internal error: correlation reference CTE_1 is not in allowed. Please collect the failing statement and contact support"
                  }
              }
          ],
          "status": "fatal",
          "metrics": {
              "elapsedTime": "1.980086ms",
              "executionTime": "1.809972ms",
              "resultCount": 0,
              "resultSize": 0,
              "serviceLoad": 3,
              "errorCount": 1
          }
      }

      Attachments

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty