Incorrect results on partitioned table with index_merge enabled
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Incomplete
|
High
|
Unassigned | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Incomplete
|
High
|
Unassigned |
Bug Description
The table has several indices and is partitioned by a date column.
When querying the table with index_merge (probably specifically index_merge_
When querying the table with index_merge (probably specifically index_merge_
If you remove the partitioning from the table, then you always get 1 row returned (correct), regardless of whether index_merge is enabled or not.
Running on: Percona Server with XtraDB (GPL), Release rc60.4, Revision 393
Use attached example database with the following queries:
SET SESSION OPTIMIZER_
SELECT * FROM EXAMPLE
WHERE 1=1
AND CAMPAIGN_
AND TEST='N'
AND AUTO='N'
AND MOST_RECENT='Y'
AND ISSUE='10';
SET SESSION OPTIMIZER_
SELECT * FROM EXAMPLE
WHERE 1=1
AND CAMPAIGN_
AND TEST='N'
AND AUTO='N'
AND MOST_RECENT='Y'
AND ISSUE='10';
Changed in percona-server: | |
status: | Incomplete → New |
tags: | added: upstream |
It can be a duplicate of upstream http:// bugs.mysql. com/bug. php?id= 69581. Please, check.