MySQL search only finds whole-word exact matches
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	Legoktm
	Mar 29 2015, 9:28 AM

Description

T75854 asks for specifics, so searching for "hhvm stacktrace" (https://phabricator.wikimedia.org/maniphest/query/1DdIq5aa5Ei0/#R) does not bring up T89169. The bug contains both words I searched for.

Related Objects

Mentioned In: T679: Phabricator search does not search substrings
Mentioned Here: T98579: Search in Phabricator fails to find "WP:QT", "fr:WP:QT"
T75854: Fix provided search results in Wikimedia Phabricator
T89169: Log php fatals with full backtraces again (fatal.log on fluorine)

Event Timeline

Legoktm created this task.Mar 29 2015, 9:28 AM

Legoktm raised the priority of this task from to Medium.

Legoktm updated the task description. (Show Details)

Legoktm added a project: Phabricator.

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 29 2015, 9:28 AM

Actually that task only contains the plural form stacktraces. If you search for "hhvm stacktraces" it comes up... Hardly ideal.

The default search backend has no substring search, so the current results are correct.
This would be fixed by using ElasticSearch which we once already tried; see T75854#1053174

Aklapper lowered the priority of this task from Medium to Lowest.Mar 30 2015, 9:23 AM

Aklapper removed a parent task: T75854: Fix provided search results in Wikimedia Phabricator.

Aklapper set Security to None.

In T94338#1161585, @Aklapper wrote:

The default search backend has no substring search, so the current results are correct.

They're not correct. Correct results would include T89169.

And that doesn't make the task invalid. You asked "If there are still specific issues with the current, please bring them up in dedicated tasks with clear steps to reproduce", I found a specific issue that is reproducible, and filed a dedicated task for it.

If you're just going to close tasks as invalid, don't ask people to file them.

True, I should have written "words" instead of (sub)strings. Sorry for that.

Still this won't change until someone investigates time to fix and reintroduce the ElasticSearch backend...

Aklapper renamed this task from Searching for "hhvm stacktrace" does not bring up T89169 to ElasticSearch backend so searching for "hhvm stacktrace" will bring up T89169.Mar 31 2015, 12:31 PM

jayvdb subscribed.Apr 1 2015, 12:24 AM

In T94338#1166642, @Aklapper wrote:

True, I should have written "words" instead of (sub)strings. Sorry for that.

Still this won't change until someone investigates time to fix and reintroduce the ElasticSearch backend...

Why does it matter that it is fixed in elasticsearch? Someone could also fix it in the "default" search backend.

Nemo_bis renamed this task from ElasticSearch backend so searching for "hhvm stacktrace" will bring up T89169 to MySQL search only finds whole-word exact matches.May 15 2015, 6:32 AM

Nemo_bis updated the task description. (Show Details)

I documented the behaviour at https://www.mediawiki.org/w/index.php?title=Phabricator%2FHelp&type=revision&diff=1650699&oldid=1650693

Nemo_bis unsubscribed.Jun 16 2015, 12:51 PM

Restricted Application added a subscriber: scfc. · View Herald TranscriptJun 16 2015, 12:51 PM

Nnemo awarded a token.Aug 2 2015, 5:57 PM

Nnemo subscribed.

Aklapper merged a task: T127963: Search should reflect partial strings.Feb 24 2016, 2:44 PM

Aklapper added subscribers: Danny_B, StudiesWorld.

• mmodell added a project: Phabricator (Upstream).May 11 2016, 9:01 PM

• mmodell updated the task description. (Show Details)

Restricted Application added a subscriber: TerraCodes. · View Herald TranscriptMay 11 2016, 9:01 PM

Danny_B added a project: Upstream.May 23 2016, 6:02 PM