Closed Bug 455889 Opened 18 years ago Closed 12 years ago

[Mysql] 'Find a Specific Bug' can not find wide char bugs.

Categories

(Bugzilla :: Query/Bug List, defect)

Product:
Bugzilla
Component:
Query/Bug List
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED WORKSFORME

People

(Reporter: xiaoou.wu, Unassigned)

Details

https://landfill.bugzilla.org/bugzilla-3.2-branch/ Use 'Find a Specific Bug' to search word '测试', no result returns. actually, there should be serveral results.
Flags: blocking3.2?
Confirmed. The Advanced Search form finds them, though.
We should at least investigate this before releasing 3.2. It may turn out that the fix is too extensive and will have to wait for 3.4 or 3.2.1.
Flags: blocking3.2? → blocking3.2+
It seems that the ANSI strings will not work either, please try 'hello' for the result.
Maybe that's related, see http://dev.mysql.com/doc/refman/5.0/en/fulltext-natural-language.html: If words are not separated by delimiters (as in, for example, Chinese), the FULLTEXT parser cannot determine where a word begins or ends. To be able to add words or other indexed terms in such languages to a FULLTEXT index, you must preprocess them so that they are separated by some arbitrary delimiter such as “"”.
Unfortunately there is no Perl module capable of parsing all languages and determining what are "words." So unless there is some other solution, we won't be fixing this for 3.2 (or possibly ever?).
Flags: blocking3.2+ → blocking3.2-
(In reply to comment #3) > It seems that the ANSI strings will not work either, please try 'hello' for the > result. The reason hello doesn't work is because it's blacklisted by MySQL, see http://dev.mysql.com/doc/refman/5.0/en/fulltext-stopwords.html It's considered as a common word and so as an irrelevant one.
Bugzilla 3.2 is restricted to security bugs only. Moreover, this bug is either assigned to nobody or got no traction for several months now. Rather than retargetting it at each new release, I'm clearing the target milestone and the bug will be retargetted to some sensible release when someone starts fixing this bug for real (Bugzilla 3.8 more likely).
Target Milestone: Bugzilla 3.2 → ---
WFM with Bugzilla 3.6 and newer. Couldn't test on older releases.
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → WORKSFORME
You need to log in before you can comment on or make changes to this bug.