Eliminate NAME_CONST to Allow Index Usage

[Shaun Martinec]

This is the problem code in my stored function:

SET current_first_name = 'Joe';
SELECT id INTO current_id FROM names WHERE first_name = current_first_name LIMIT 1;

When Mysql is executing the statement, it gets rewritten as this and cannot use indexes:

SELECT id INTO current_id FROM names WHERE first_name = NAME_CONST( 'current_first_name', _utf8 'Joe' COLLATE 'utf8_unicode_ci' ) LIMIT 1;

How can I fix? The names table is utf8_unicode_ci, but the first_name column is ascii_general_ci.

Relevant ini params:

character-set-server=utf8
collation-server=utf8_unicode_ci
init-connect='SET NAMES utf8'