Bug #28861 Problem With full text search and some characters in boolean mode i want to igno
| Submitted: | 4 Jun 2007 5:51 | Modified: | 13 Jun 2007 8:33 |
|---|---|---|---|
| Reporter: | KARIM EL GENDY | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: FULLTEXT search | Severity: | S3 (Non-critical) |
| Version: | 4.1, 5.0, 5.1 | OS: | Any (Linux, Windows XPProfessional) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
| Tags: | ignore some characters before indexing | ||
[4 Jun 2007 8:06]
Sveta Smirnova
Thank you for the report. Verified as described.
[13 Jun 2007 8:33]
Sergey Vojtovich
A duplicate of BUG#19580. This problem is fixed since 5.1.12. We do not plan to fix it in 5.0/4.1.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: Arabic Problem With full text search and some characters in boolean mode i want to ignor some charcter before indexing the table like this ex in English for the word (Don't) it index with (dont) so the fulltext ignor the (') i want to change this list of characters and add another new characters ALSO THIS IS an example in english word but i think that it's the same that we have to ignore the („) & (“) TO GET ALL THE RECORD CREATE TABLE `fulltext_utf8` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `text` VARCHAR( 255 ) NOT NULL , FULLTEXT (`text`) ) ENGINE = MYISAM DEFAULT CHARSET=utf8; INSERT INTO `fulltext_utf8` VALUES (NULL , '„MySQL“'), (NULL , 'MySQL'); SELECT `id`, `text` FROM `fulltext_utf8` WHERE MATCH (`text`) AGAINST ('MySQL' IN BOOLEAN MODE); I hope you answer me asap How to repeat: Execute the following SQL queries: CREATE TABLE `fulltext_utf8` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `text` VARCHAR( 255 ) NOT NULL , FULLTEXT (`text`) ) ENGINE = MYISAM DEFAULT CHARSET=utf8; INSERT INTO `fulltext_utf8` VALUES (NULL , '„MySQL“'), (NULL , 'MySQL'); SELECT `id`, `text` FROM `fulltext_utf8` WHERE MATCH (`text`) AGAINST ('MySQL' IN BOOLEAN MODE); +----+-------+ | id | text | +----+-------+ | 2 | MySQL | +----+-------+ 1 row in set (0.00 sec) As you can see the SELECT statement only matches the second row, although it should match both rows. Suggested fix: EDIT THE LIST which have the ' character for ignoring and add the new chracters which we want to ignore in indexing IGNORE SOME CHRACTERS LIKE ',",„,,, ّ َ ُ ٌ ِ ٍ ْ