Bug #5447 Select does not find records

• Submitted: 7 Sep 2004 10:03
• Modified: 9 Sep 2004 7:25
• Reporter: Jochen Ollich
• Status: Closed
• 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