Index ref not used for multi-column IN - type or collation conversion warning
Bug #1642802 reported by
monty solomon
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | ||
|---|---|---|---|---|---|---|
| MySQL Server |
Unknown
|
Unknown
|
||||
| Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
| 5.5 |
New
|
Undecided
|
Unassigned | |||
| 5.6 |
Triaged
|
Medium
|
Unassigned | |||
| 5.7 |
Triaged
|
Medium
|
Unassigned | |||
Bug Description
We observed some unexpected performance issues and discovered that multi-column IN clause was not using the index due to a type or collation conversion.
Level: Warning
Code: 1739
Message: Cannot use ref access on index 'alternateId_
Revision history for this message
| monty solomon (monty+launchpad) wrote | #1 |
Revision history for this message
| monty solomon (monty+launchpad) wrote | #2 |
| tags: | added: upstream |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #3 |
To post a comment you must log in.
mysql Ver 14.14 Distrib 5.7.13-6, for Linux (x86_64) using 6.0
Server version: 5.7.13-6-log Percona Server (GPL), Release 6, Revision e3d58bb