Bug #1883 | While using "like" ... in "Big5" Server Characterset ... | ||
---|---|---|---|
Submitted: | 19 Nov 2003 0:08 | Modified: | 24 Dec 2003 5:04 |
Reporter: | her min-hua | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 3.23, 4.0, 4.1.1 | OS: | Other (sco-linux 4.0) |
Assigned to: | Alexander Barkov | CPU Architecture: | Any |
[19 Nov 2003 0:08]
her min-hua
[26 Nov 2003 12:18]
Dean Ellis
Verified with 3.23.58, 4.0.17 and 4.1.1. The problem only occurs if the column is indexed, and LIKE will not return results for 'pattern%' where the column value = pattern. Thank you.
[24 Dec 2003 5:04]
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 Additional info: I fixed this bug in 4.0 and 4.1 tree, also I added a test into 4.1.