Uploaded image for project: 'Couchbase C client library libcouchbase'
  1. Couchbase C client library libcouchbase
  2. CCBC-1107

Execute prepare statement fails with syntax error in handler

    XMLWordPrintable

Details

    • Bug
    • Resolution: User Error
    • Critical
    • 2.10.5
    • None
    • library
    • 1

    Description

      6.5.0 build 3694 

      • Create 4 node cluster(kv,eventing,n1ql,index)
      • Create prepare statement PREPARE test from DELETE from src_bucket where mutated=0
      • Deploy handler which executes above statement

      function OnUpdate(doc, meta) {
          log('document', doc);
          try{
          var query=Execute test;
          }catch(e){
              log(e);
          }
      //    query.execQuery();
      }
      function OnDelete(meta) {
          dst_bucket[meta.id]='deleted';
      }
      
      

      Observed: Mutation failed with syntax error, same executes fine from query workbench 

      {
      "requestID": "36cf0ac6-13e2-441e-8ad4-9b17530e2a72",
      "errors": [{"code":3000,"msg":"syntax error - at test"}],
      "status": "fatal",
      "metrics": {"elapsedTime": "322.903µs","executionTime": "234.598µs","resultCount": 0,"resultSize": 0,"errorCount": 1}
      } 

      Attachments

        Issue Links

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

          Activity

            People

              Gautham.Banasandra Gautham Banasandra (Inactive)
              vikas.chaudhary Vikas Chaudhary
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty