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:
None 
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 5:51] KARIM EL GENDY
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 ',",„,,, ّ َ ُ  ٌ ِ ٍ ْ
[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.