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

backslash at the end of string causing error

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.0.0
    • 6.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      https://forums.couchbase.com/t/couchbase-n1ql-updating-fields-containing-single-quotes-double-quotes-orbackslash/25350/9

      INSERT INTO default VALUES("k01",{"a":1});
      

      The following gives error

       
      UPDATE  default AS d USE KEYS  "k01" 
      SET description= "John's words  are \"Never give up\". blackslash \\", title="xyz";
      

      The following works.

      UPDATE  default AS d USE KEYS  "k01" 
      SET description= "John's words  are \"Never give up\". blackslash \\.", title="xyz";
      UPDATE  default AS d USE KEYS  "k01" 
      SET description= "John's words  are \"Never give up\". blackslash \\ ", title="xyz";
      UPDATE  default AS d USE KEYS  "k01" 
      SET description= "John's words  are \"Never give up\". blackslash \\", title='xyz';
      
      

      Attachments

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

        Activity

          People

            isha Isha Kandaswamy (Inactive)
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty