Bug #3556 soundex not working correctly

• Submitted: 24 Apr 2004 13:26
• Modified: 28 Apr 2004 16:03
• Reporter: Edwin van Maastrigt
• Status: Closed
• Category: Server
• Severity: S3 (Non-critical)
• Version: 4.0.13
• OS: Linux (linux)
• Assigned to: Sergei Golubchik

[24 Apr 2004 13:26] Edwin van Maastrigt

Description:
From the documentation on the SOUNDEX function:

"All non-alphabetic characters are ignored in the given string."

This is not true.

mysql> SELECT SOUNDEX('aap');
        -> 'A100'
mysql> SELECT SOUNDEX('"aap"');
        -> '"100'

It is either a bug in the documentation or a bug in the soundex algorithme.

I think the last

How to repeat:
mysql> SELECT SOUNDEX('aap');
        -> 'A100'
mysql> SELECT SOUNDEX('"aap"');
        -> '"100'

[28 Apr 2004 16:03] Sergei Golubchik

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

Additional info:

fixed in 4.0.19