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

N1QL JS UDF:Execute of Prepared statement with Using clause does not work

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • Morpheus
    • 7.1.0
    • js-evaluator, query
    • None
    • Untriaged
    • 1
    • Unknown

    Description

      Execute of a prepared statement with using is giving error :USING clause does not evaluate to static values

       

      For e.g.:

       

      function doDelivery(w_id)
      {             var query= EXECUTE p1 using [$w_id];      }
      PREPARE p1 from select wid from default where wid=$1;
      create index ix1 on default(wid)
       
       
      

       

      cbq> execute function doDelivery(1);
      {
          "errors": [
             
      {             "code": 10109,             "msg": "Error executing function doDel2 (delivery:doDel2): Evaluator error Exceptions from JS code : run doDel2 failed:\nException: Error: Execution parameter error: USING clause does not evaluate to static values\nLocation }
       
      

       

      Attachments

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

        Activity

          People

            abhishek.jindal Abhishek Jindal
            kamini.jagtiani Kamini Jagtiani
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty