| Bug #6715 | Non-alphanumeric characters are ignored in full-text search | ||
|---|---|---|---|
| Submitted: | 19 Nov 2004 8:02 | Modified: | 22 Feb 2005 11:03 |
| Reporter: | Kostyantyn Lukash | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S2 (Serious) |
| Version: | 4.0.22 | OS: | Windows (Windows XP Pro (Russian, SP1)) |
| Assigned to: | CPU Architecture: | Any | |
[22 Jan 2005 11:03]
Aleksey Kishkin
Kostyantyn, I see that our bug system deformates russian text and it's hard to understand your example. Could you please to write your bug report into file (say, in cp1251 or koi8) and attach this file to this bug record (section Files)? Thanx.
[23 Feb 2005 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: When query string in full-text search contain one non-alphanumeric character between alphanumerics or at the beginning or at the end of string, the results received are like there was not any of non-alphanumerics in query string at all. How to repeat: CREATE TABLE my_data ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(255), content TEXT, FULLTEXT (content) ); SELECT id, title, content FROM my_data WHERE MATCH (content) AGAINST ('те*кст') or SELECT id, title, content FROM my_data WHERE MATCH (content) AGAINST ('те,кст') return rows with just 'текст', and not 'те*кст' or 'те,кст' which I know for sure are absent in `my_data`.