Bug #5447 Select does not find records
Submitted: 7 Sep 2004 10:03 Modified: 9 Sep 2004 7:25
Reporter: Jochen Ollich Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: ISAM storage engine Severity:S2 (Serious)
Version:4.0.20d OS:Microsoft Windows (Windows XP)
Assigned to: Alexander Barkov CPU Architecture:Any

[7 Sep 2004 10:03] Jochen Ollich
Description:
I want to find authors which are written like "Poz...." 
MySQL does not find any
When I look for autors written like "Pozz..." MySQL will find

How to repeat:
Using my table "autoren"
Select * from autoren where autor like 'Poz%'
[7 Sep 2004 10:05] Jochen Ollich
Autoren

Attachment: autoren.frm (application/octet-stream, text), 8.36 KiB.

[7 Sep 2004 10:05] Jochen Ollich
Autoren

Attachment: autoren.MYD (application/octet-stream, text), 11.38 KiB.

[7 Sep 2004 10:06] Jochen Ollich
Autoren

Attachment: autoren.MYI (application/octet-stream, text), 11.00 KiB.

[7 Sep 2004 10:06] Jochen Ollich
Used My.ini

Attachment: my.ini (application/octet-stream, text), 482 bytes.

[9 Sep 2004 7:25] Alexander Barkov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html