Details
-
Bug
-
Resolution: Fixed
-
Critical
-
6.0.4, 6.5.0
-
Untriaged
-
Unknown
-
CX Sprint 190
Description
To reproduce execute the following:
CREATE DATASET breweries ON `beer-sample`
|
WHERE `type` = "brewery";
|
|
create index country_missing_idx on breweries(country:string, some_missing_field:string);
|
The following query will return a wrong result of 0 matching documents because it is using the index:
select count(*) from breweries bw
|
where bw.country = 'United States';
|
If you drop the index, you should get the correct result of 875.
Attachments
Issue Links
- relates to
-
MB-38319 [CX] Use secondary indexes with composite key for prefix search
- Closed