Page MenuHomePhabricator
Create Task
Maniphest T36255

MySQL search for titles without Lucene does not find filenames
Closed, ResolvedPublic
Actions

Description

In the default search (MySQL search without Lucene) 'foo' doesn't find "File:Foo.jpg" (only 'foo*' or 'foo.jpg' does). But 'bar' finds "File:Foo Bar Baz.jpg".

Is there a solution for this? Don't say users should truncate, the search should find it ;)

Version: unspecified
Severity: normal

Details

Reference
bz34255
Related Changes in Gerrit:
SubjectAuthorRepoBranchLines +/-
Search: improve file title indexTheDJmediawiki/coremaster+4 -0
Customize query in gerrit

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 22 2014, 12:14 AM
• bzimport added a project: MediaWiki-Search.
• bzimport set Reference to bz34255.
• bzimport added a subscriber: Unknown Object (MLST).
Subfader created this task.Feb 7 2012, 9:22 PM
• brooke added a comment.Feb 7 2012, 10:00 PM

Is that for title or content searches?

Subfader added a comment.Feb 7 2012, 10:26 PM

Title searches.

Subfader added a comment.Oct 14 2012, 10:27 PM

Wikipedia uses Lucene so nobody cares :(

TheDJ moved this task from Backlog to MySQL/Postgres/SQLite search on the MediaWiki-Search board.Sep 6 2025, 10:39 PM
Restricted Application added a project: Discovery-Search. · View Herald TranscriptSep 6 2025, 10:39 PM
Gehel removed a project: Discovery-Search.Sep 8 2025, 2:30 PM
Gehel subscribed.

Removed Discovery team as this is about MySQL search.

gerritbot added a comment.Sep 12 2025, 10:51 PM

Change #1187914 had a related patch set uploaded (by TheDJ; author: TheDJ):

[mediawiki/core@master] Search: improve file title index

https://gerrit.wikimedia.org/r/1187914

gerritbot added a project: Patch-For-Review.Sep 12 2025, 10:51 PM
gerritbot added a comment.Sep 17 2025, 7:23 AM

Change #1187914 merged by jenkins-bot:

[mediawiki/core@master] Search: improve file title index

https://gerrit.wikimedia.org/r/1187914

Maintenance_bot removed a project: Patch-For-Review.Sep 17 2025, 7:31 AM
ReleaseTaggerBot added a project: MW-1.45-notes (1.45.0-wmf.20; 2025-09-23).Sep 17 2025, 8:01 AM
TheDJ closed this task as Resolved.Sep 18 2025, 6:57 PM
TheDJ claimed this task.
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits