Maniphest T12928

Tokens in the form "v0.1" are not handled well by the MySQL FULLTEXT index
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	epriestley
	Jul 19 2017, 3:08 PM

Tags

Referenced Files

	F5179578: Screen Shot 2017-09-12 at 8.07.24 AM.png
	Sep 12 2017, 3:07 PM

Subscribers

Description

Via support:

A query for example v0.1 does not find a task named example v0.1.

I believe the token v0.1 is being split on "." into v0 and 1 internally, and both terms are too short for indexing. I don't think there's anything we can really do to fix this that doesn't largely involve ripping the engine out and replacing it (see also T12819).

Revisions and Commits

rP Phabricator
	D18324	rPcfb86dddd2ef Warn users that compound terms separated by apostrophes don't work in the MySQL…
	D18254	rP018d1b77bf33 Identify compound short search tokens in the form "xx.yy" as unqueryable in the…

Related Objects
Search...

		Status	Assigned	Task
		Resolved	epriestley	T12974 Upgrading: "Ferret" Fulltext Engine
		Resolved	epriestley	T12819 InnoDB FULLTEXT appears to fail catastrophically once it reaches a moderate size
		Resolved	epriestley	T12928 Tokens in the form "v0.1" are not handled well by the MySQL FULLTEXT index

Event Timeline

epriestley created this task.Jul 19 2017, 3:08 PM

Herald added a subscriber: eadler. · View Herald TranscriptJul 19 2017, 3:08 PM

epriestley added a revision: D18254: Identify compound short search tokens in the form "xx.yy" as unqueryable in the search UI.Jul 20 2017, 4:10 PM

epriestley added a commit: rP018d1b77bf33: Identify compound short search tokens in the form "xx.yy" as unqueryable in the….Jul 20 2017, 9:24 PM

joshuaspence added a subscriber: joshuaspence.Jul 31 2017, 2:14 PM

epriestley added a revision: D18324: Warn users that compound terms separated by apostrophes don't work in the MySQL FULLTEXT index either.Aug 2 2017, 11:03 PM

epriestley added a commit: rPcfb86dddd2ef: Warn users that compound terms separated by apostrophes don't work in the MySQL….Aug 2 2017, 11:06 PM

epriestley added a parent task: T12819: InnoDB FULLTEXT appears to fail catastrophically once it reaches a moderate size.Aug 12 2017, 10:44 AM

epriestley mentioned this in T12819: InnoDB FULLTEXT appears to fail catastrophically once it reaches a moderate size.Aug 30 2017, 7:49 PM

epriestley mentioned this in T12974: Upgrading: "Ferret" Fulltext Engine.Sep 1 2017, 5:05 PM

epriestley added a parent task: T12974: Upgrading: "Ferret" Fulltext Engine.

This is resolved by the Ferret engine:

Screen Shot 2017-09-12 at 8.07.24 AM.png (661×593 px, 62 KB)