Details
-
Bug
-
Resolution: Fixed
-
Critical
-
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
For Gerrit Dashboard: MB-37078 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
118715,6 | MB-37078: Fix equality filter check for nil values of high and low | unstable | indexing | Status: MERGED | +2 | +1 |
118854,3 | MB-37078: Add functional tests for min/max aggregate optimisations | unstable | indexing | Status: MERGED | +2 | +1 |
118907,3 | MB-37078 Fix equality check for nil in fast count | unstable | indexing | Status: MERGED | +2 | +1 |
118930,2 | MB-37078: [Backport to mad-hatter] Fix equality filter check for nil values of high and low | mad-hatter | indexing | Status: MERGED | +2 | +1 |
118931,2 | MB-37078: [Backport to mad-hatter] Add functional tests for min/max aggregate optimisations | mad-hatter | indexing | Status: MERGED | +2 | +1 |
118941,1 | MB-37078: [Backport to mad-hatter] Fix equality check for nil in fast count | mad-hatter | indexing | Status: MERGED | +2 | +1 |