Partly non-unique key on varchar field seems faulty.

[Thomas Kettenbach]

Hi,

on a simple table with only a varchar field and a non uniuqe
index on this field, the index seems to be faulty. For example
a word like "handgreschrieben" occures only once, when searched with
the index. After dropping the index and performing a full table
scan the correct occurence of this word is found. In my example it
was 256.

Here is what i did:
CREATE DATABASE testutf8 CHARACTER SET=utf8;
USE testutf8;
CREATE TABLE `utf8words` (
`wordentry` varchar(64) NOT NULL default '',
KEY `wordid` (`wordentry`(4))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOAD DATA LOCAL INFILE "wordlist.txt" INTO TABLE `utf8words`;

My word list was a concatenation of some ispell dictionary files
(with german words), converted to UTF8. I filled the table with
appox. 20Mio. rows. (original data was about 80000 rows, each word
should occure 256 times.)

TIA
Thomas