Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 5.0
    • None
    • query
    • None

    Description

      The documentation on PREPARE STATEMENT page https://developer.couchbase.com/documentation/server/current/n1ql/n1ql-language-reference/prepare.html describes extensively how to use prepare statement using REST API   

      I was using the Query workbench to test the PREPARE statement functionality as follow:

      prepare mq1 as SELECT * from `travel-sample` limit 2;

      I then not sure how I will invoke the named prepared statement mq1, so I tried

      execute mq1;

      that works.

      It would be useful to reference the location where we document Using Prepared Statement in Workbench or cbq. 

      More complicated scenario:

      prepare mq2 as SELECT * from `travel-sample` where type = $t limit 2;

      I then tried to figure out how to execute mq2 with bind variable value for $t, I could not guess the right syntax.

      Attachments

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

        Activity

          People

            guy.klages Guy Klages (Inactive)
            tai.tran Tai Tran (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty