Uploaded image for project: 'Couchbase Documentation'
  1. Couchbase Documentation
  2. DOC-11945

Add documentation for a new way to reference Positional Parameters

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • Trinity
    • Trinity, Morpheus
    • query
    • None
    • 0

    Description

      A new way of referencing a positional parameter is by prefixing the number of the parameter with @. [ This is including the existing ways of referencing positional parameters ]

       

      Change - https://docs.couchbase.com/server/current/guides/prep-statements.html#placeholders

       

      Change "To add a positional parameter to a query, either enter a dollar sign $ followed by the number of the parameter, or enter a question mark ?"

       

      to "To add a positional parameter to a query, either enter a dollar sign $ or @ sign followed by the number of the parameter, or enter a question mark ?"

       

      Example :

      SELECT * FROM airline WHERE id > @1;

      Attachments

        Issue Links

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

          Activity

            People

              simon.dew Simon Dew
              dhanya.gowrish Dhanya Gowrish
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty