MySQL Server

Index not used for the implicit integer to string conversion

Bug #1642804 reported by monty solomon
6
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
Invalid
Undecided
Unassigned

Bug Description

When using the implicit conversion between integer and string the index is not used. When using the explicit conversion between integer and string the index is used.

The index is used for the implicit string to integer conversion.

  Level: Warning
   Code: 1739
Message: Cannot use ref access on index 'alternateId_objectType' due to type or collation conversion on field 'alternateId'

  Level: Warning
   Code: 1739
Message: Cannot use range access on index 'alternateId_objectType' due to type or collation conversion on field 'alternateId'

Tags: upstream
Revision history for this message
monty solomon (monty+launchpad) wrote :

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

Revision history for this message
monty solomon (monty+launchpad) wrote :

Details in upstream bug https://bugs.mysql.com/bug.php?id=83857

Laurynas Biveinis (laurynas-biveinis)
tags: added: upstream
Revision history for this message
monty solomon (monty+launchpad) wrote :

Upstream claims this is not a bug.

Laurynas Biveinis (laurynas-biveinis)
Changed in percona-server:
status: New → Invalid
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3603

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.