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
-
For Gerrit Dashboard: MB-38292 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
123803,2 | MB-38292: Incorrect result with composite secondary index | mad-hatter | cbas-core | Status: MERGED | +2 | +1 |
156951,1 | Revert "MB-38292: Incorrect result with composite secondary index" | mad-hatter | cbas-core | Status: ABANDONED | 0 | 0 |