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

With no qualifying search index SEARCH() function for vector queries resulting in random results

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Major
    • 7.6.2
    • 7.6.2
    • fts
    • None
    • Untriaged
    • 0
    • Unknown

    Description

      1. Create a default index. Vector fields are not indexed in default index
      2. Run an fts SEARCH query
        1. select car.Car, car.Color from carwhere SEARCH(c,{    "query": {        "match_none": {}    },    "knn": [{        "field": "color_rgb_vector",        "vector": [0,255,255],         "k": 3    }]}); 

      3. Getting random results

      [ { "Car": "Ferrari", "Color": "strawberry" }, { "Car": "Chevrolet", "Color": "deep brown" }, { "Car": "Saab", "Color": "british racing green" }, { "Car": "De Lorean", "Color": "light lilac" }, { "Car": "Rolls-Royce", "Color": "greeny yellow" }, { "Car": "Bentley", "Color": "lighter green" }, { "Car": "Citroen", "Color": "blush" }, { "Car": "Chevrolet", "Color": "rosy pink" }, { "Car": "Bentley", "Color": "dusky rose" }, { "Car": "Bentley", "Color": "dull blue" }, { "Car": "Rolls-Royce", "Color": "ugly purple" }, { "Car": "Bentley", "Color": "dark plum" }, { "Car": "Porsche", "Color": "pale aqua" }, { "Car": "Porsche", "Color": "grassy green" }, { "Car": "Volvo", "Color": "magenta" }, { "Car": "Daihatsu", "Color": "neon blue" }, { "Car": "Ferrari", "Color": "pale sky blue" }, { "Car": "Bentley", "Color": "deep lavender" }, { "Car": "Maserati", "Color": "deep sea blue" }, { "Car": "Honda", "Color": "camo" }, { "Car": "Rolls-Royce", "Color": "spearmint" }, { "Car": "Volvo", "Color": "white" }, { "Car": "Volvo", "Color": "sand" }, { "Car": "Bentley", "Color": "grey pink" }, { "Car": "Ferrari", "Color": "ocher" }, { "Car": "Audi", "Color": "medium pink" }, { "Car": "Ferrari", "Color": "aqua blue" }, { "Car": "Chevrolet", "Color": "bright lilac" }, { "Car": "Maserati", "Color": "dark seafoam green" }, { "Car": "Daihatsu", "Color": "light royal blue" }, { "Car": "Suzuki", "Color": "cobalt" }, { "Car": "De Lorean", "Color": "black" }, { "Car": "Porsche", "Color": "shit brown" }, { "Car": "Bentley", "Color": "orange yellow" }, { "Car": "Fiat", "Color": "pine green" }, { "Car": "Ford", "Color": "heliotrope" }, { "Car": "Saab", "Color": "purpleish blue" }, { "Car": "Maserati", "Color": "pale gold" }, { "Car": "Volvo", "Color": "off blue" }, { "Car": "Audi", "Color": "pastel yellow" }, { "Car": "Chevrolet", "Color": "coral" }, { "Car": "Chevrolet", "Color": "light khaki" }, { "Car": "Bentley", "Color": "mid green" }, { "Car": "Saab", "Color": "ugly yellow" }, { "Car": "Maserati", "Color": "light beige" }, { "Car": "Saab", "Color": "bottle green" }, { "Car": "De Lorean", "Color": "shit" }, { "Car": "Ford", "Color": "dull green" }, { "Car": "Bentley", "Color": "dark mint" }, { "Car": "Porsche", "Color": "pale" }, { "Car": "Porsche", "Color": "strawberry" }, { "Car": "Bentley", "Color": "swamp" }, a lotttt more documents
       

      If I create another index on vector fields I get correct results.

      [  {    "Car": "Daihatsu",    "Color": "cyan"  },  {    "Car": "Daihatsu",    "Color": "neon blue"  },  {    "Car": "Porsche",    "Color": "neon blue"  }] 

      Attachments

        Issue Links

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

          Activity

            People

              sarthak.dua Sarthak Dua
              sarthak.dua Sarthak Dua
              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