Yes, if you look at MB-50911, it says:
Sitaram Vemulapalli added a comment - 10/Feb/22 6:20 PM
|
Repro: Use primary index so that it will not use IndexScan on type.
|
|
check latency before and after fix and (ignore first attempt due to cold run)
|
|
WITH invals AS (ARRAY_RANGE(1,8192)) SELECT t.type FROM `travel-sample` t WHERE t.type NOT IN invals LIMIT 100;
|
So I had deleted all existing indexes leaving primary index (def_primary) before I ran the query.
Alternatively,
WITH invals AS (ARRAY_RANGE(1,8192)) SELECT t.type FROM `travel-sample` t use index(def_primary) WHERE t.type NOT IN invals LIMIT 100;
had also worked.
Build couchbase-server-7.0.4-7238 contains query commit a24e366 with commit message:
MB-51453Additional changes for IN-list handling