It reminds me of bugs like this:
http://bugs.mysql.com/bug.php?id=45680 (wrong results when using index for lookup with implicitly casted values)
you're using varchar(1) but looking for a 3 char string.. if you increase the table varchar to longer value, or disable in the index, it returns expected.
It reminds me of bugs like this:
http:// bugs.mysql. com/bug. php?id= 45680
(wrong results when using index for lookup with implicitly casted values)
you're using varchar(1) but looking for a 3 char string..
if you increase the table varchar to longer value, or disable in the index, it returns expected.