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

Flex indexes not working for array fields

    XMLWordPrintable

Details

    • Bug
    • Resolution: User Error
    • Major
    • 7.0.0
    • Cheshire-Cat
    • query
    • 7.0.0-1814
    • Untriaged
    • Unknown

    Description

      Create travel-sample
      drop def_primary
      create fts index on array field public_likes with keyword analyzer

      we can verify our fts index is working properly by searching the index for public_likes:Julius Tromp I and seeing that we get results

      attempt to run this query
      select * from `travel-sample` USE INDEX (index2 USING FTS) where "Julius Tromp I" in public_likes

      {
      "errors": [

      { "code": 4000, "msg": "No index available on keyspace travel-sample that matches your query. Use CREATE INDEX or CREATE PRIMARY INDEX to create an index, or check that your expected index is online.", "query_from_user": "explain select * from `travel-sample` USE INDEX (index2 USING FTS) where \"Julius Tromp I\" in public_likes" }

      ]
      }

      Attachments

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

        Activity

          People

            ajay.bhullar Ajay Bhullar
            ajay.bhullar Ajay Bhullar
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty