Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
6.5.0
-
Untriaged
-
Centos 64-bit
-
-
Yes
Description
Build 6.5.0-4890
query
SELECT MIN(d.age) from default d USE INDEX (`travel_history_name_age`) UNNEST d.`travel_history` AS t where t = 'India' |
returns 45
query
SELECT MIN(d.age) from default d USE INDEX (`#primary`) UNNEST d.`travel_history` AS t where t = 'India' |
|
returns 28
Indexes definitions:
CREATE PRIMARY INDEX `#primary` ON `default` |
|
CREATE INDEX `name_age_travel_history` ON `default`(`name`,`age`,(all (array `t` for `t` in `travel_history` end))) |
|
CREATE INDEX `name_travel_history_age` ON `default`(`name`,(all (array `t` for `t` in `travel_history` end)),`age`) |
|
CREATE INDEX `travel_history_name_age` ON `default`((all (array `t` for `t` in `travel_history` end)),`name`,`age`) |
default bucket data is attached
logs are attached
Attachments
Issue Links
- is cloned by
-
MB-37274 [Backport 6.0.4] - Query: Different results for different indexes in use.
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Component/s | indexing [ 15110 ] |
Fix Version/s | Mad-Hatter [ 15037 ] |
Attachment | aa.sql [ 78410 ] |
Component/s | secondary-index [ 11211 ] | |
Component/s | query [ 10718 ] |
Assignee | Kamini Jagtiani [ kamini.jagtiani ] | Jeelan Poola [ jeelan.poola ] |
Is this a Regression? | Unknown [ 10452 ] | Yes [ 10450 ] |
Assignee | Jeelan Poola [ jeelan.poola ] | Amit Kulkarni [ amit.kulkarni ] |
Priority | Major [ 3 ] | Critical [ 2 ] |
Attachment | ExplainAlice.txt [ 78446 ] | |
Attachment | ExplainMH.txt [ 78447 ] |
Labels | approved-for-mad-hatter |
Due Date | 05/Dec/19 |
Link | This issue blocks MB-36676 [ MB-36676 ] |
VERIFICATION STEPS |
QE Testing:
Various scenarios around MIN aggregate queries (with index on multiple composite keys and multiple different filter values specified for each composite key). |
|
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Resolved [ 5 ] |
Status | Resolved [ 5 ] | Closed [ 6 ] |
Evgeny Makarenko Is this a regression? Can you please figure it out?