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

FTS index causing N1QL to report error

    XMLWordPrintable

Details

    • Untriaged
    • MacOSX 64-bit
    • Yes

    Description

      I can run this query successful
      Q1:

       select count (*), (distinct `Primary Type`)
      		 
       from `crime`
      		 
       group by `Primary Type`
      		 
       ORDER BY count(*)
      		 
        

       
      when I run any query with field Primary Type in where clause I get,

      Q2:

       select count (*)
      		 
       from `crime`
      		 
       where `Primary Type`="NARCOTICS"
      		 
       [
      		 
       
      		 
      { "code": 5000, "msg": "n1fty: refresh failed - cause: syntax error - at Primary", "query": "select count (*)\nfrom `crime` \nwhere `Primary Type`=\"NARCOTICS\"" }
      		 
       
      		 
      ]
      		 
        

      If I drop my FTS index the query works.   

       

      The crime bucket contains 1 million records, although the size of bucket shouldn't matter.

       

      FTS screen shot attached.  

      Attachments

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

        Activity

          People

            abhinav Abhi Dangeti
            mel Mel Boulos
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty