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

[UDF] empty result from execute prepared statement in JS udf

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.1.0
    • 7.1.0
    • query
    • 7.1.0-1595
    • Untriaged
    • 1
    • Unknown

    Description

      To repro:

      • load travel-sample
      • create udf: curl -s -k -X POST http://172.23.104.91:8093/evaluator/v1/libraries/n1ql -u Administrator:password -H 'content-type: application/json' -d 'function execute_prepare() { var query = execute lyon_airport; var acc = []; for (const row of query) { acc.push(row); }

        return acc;}'

      • CREATE OR REPLACE FUNCTION execute_prepare() LANGUAGE JAVASCRIPT AS "execute_prepare" AT "n1ql" ;
      • prepare statement ( \set -query_context "default:"): prepare lyon_airport as SELECT airportname FROM `travel-sample`.inventory.airport WHERE city = "Lyon";
      • check prepare statement:
        cbq> select name, statement from system:prepareds where name like "lyon%";
      • {
            "requestID": "83afcfd4-bd4c-4346-9c7a-63776405d921",
            "signature": {
                "name": "json",
                "statement": "json"
            },
            "results": [
            {
                "name": "lyon_airport(default:)",
                "statement": "prepare lyon_airport as SELECT airportname FROM `travel-sample`.inventory.airport WHERE city = \"Lyon\";"
            }
            ],
            "status": "success",
         

      • execute function

      returns empty result set:

      cbq> execute function execute_prepare();
      {
          "requestID": "aaa3a63a-00b3-4a0c-a033-8c6cfdf31721",
          "signature": null,
          "results": [
          []
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "18.843017ms",
              "executionTime": "18.670471ms",
              "resultCount": 1,
              "resultSize": 2,
              "serviceLoad": 6
          }
      } 

       

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            pierre.regazzoni Pierre Regazzoni
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty