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

[CX] Incorrect Error message for REGEXP_REPLACE and REPLACE

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 6.0.0
    • CBAS DP
    • analytics
    • Analytics Version: 261
    • Untriaged
    • Unknown
    • CX Sprint 111, CX Sprint 112, CX Sprint 115

    Description

      Query issued:
       select name, REGEXP_REPLACE(email, 'e', 'a', 2) as mail from default_shadow;
       
      Error message:
      	"requestID": "ace5406e-1726-470b-9499-9ca013ce3baa",
      	"signature": "*",
      	"errors": [{ 
      	"code": "1",
      	"msg": "The input type for input argument 3(AInt64) is not expected."
      	}],
      	"status": "fatal",
      	"metrics": {
      		"elapsedTime": "6.653293ms",
      		"executionTime": "6.129812ms",
      		"resultCount": "0",
      		"resultSize": "0"
       
      Above query works well for n1ql
      
      

      Attachments

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

        Activity

          People

            dmitry.lychagin Dmitry Lychagin (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty