Page MenuHomePhabricator
Create Task
Maniphest T6747

Add setup warning for ft_boolean_syntax for installs using MySQL search
Closed, ResolvedPublic
Actions

Description

If MySQL search is used, the MySQL value ft_boolean_syntax should be set to:

ft_boolean_syntax = ' |-><()~*:""&^'

This makes MySQL search default to "AND" (sensible, desired) instead of "OR" (basically useless).

One thing we've been having some difficulty with is that there doesn't seem to be the ability to search for keywords in Maniphest and require all the search terms to show up in each result. For example, our iOS QA engineer might want to search for all the tasks that have both "iOS" and "backup" but not just one or the other. If there were a way to do that, that'd be very helpful.

Revisions and Commits

rP Phabricator
ClosedD11030 setup warning for mysql with default boolean syntax

Related Objects

Event Timeline

ahoffer2 created this task.Dec 13 2014, 5:50 AM
ahoffer2 raised the priority of this task from to Needs Triage.
ahoffer2 updated the task description. (Show Details)
ahoffer2 added projects: Search, Maniphest.
ahoffer2 added subscribers: ahoffer2, epriestley.
qgil added a subscriber: qgil.Dec 13 2014, 10:56 AM
epriestley added a comment.Dec 13 2014, 1:24 PM

I think search already works like this? It depends on some configuration settings, but, for example, if you search for "search" on this install, you get 100+ results:

https://secure.phabricator.com/maniphest/query/D_ERwGYnPfxC/#R

Searching for "search words" returns only 4 results, i.e. the executed search is equivalent to "search AND words":

https://secure.phabricator.com/maniphest/query/L9BQBAq.aUPJ/#R

Am I misunderstanding?

ahoffer2 added a comment.Dec 13 2014, 11:07 PM

Huh, our install definitely treats it as an OR. Do you know which configuration settings I should be looking at to control it?

epriestley renamed this task from Create "all of these words" or AND based search to Add setup warning for ft_boolean_syntax for installs using MySQL search .Dec 14 2014, 11:38 AM
epriestley updated the task description. (Show Details)

If you're using the MySQL index (I think you are), the MySQL configuration value ft_boolean_syntax should be set per the edited task description. We'll add a setup warning to make this more clear to administrators.

Until that gets fixed, I would expect the search +ios +backup to behave like you want (that is, prefix each term with "+" to force AND mode).

ahoffer2 added a comment.Dec 15 2014, 1:05 AM

Thanks! The + thing didn't work but I've just asked the team that owns the Phabricator install to change the config setting.

epriestley mentioned this in T6780: Can't search an exact phrase in Phabricator.Dec 18 2014, 3:55 PM
fabe mentioned this in D11030: setup warning for mysql with default boolean syntax.Dec 22 2014, 2:55 PM
fabe added a revision: D11030: setup warning for mysql with default boolean syntax.Dec 22 2014, 2:55 PM
epriestley mentioned this in rP853ce5e92704: setup warning for mysql with default boolean syntax.Dec 22 2014, 8:57 PM
epriestley closed this task as Resolved.Dec 23 2014, 12:00 AM
epriestley claimed this task.

Presuming resolved by D11030.

Phabricator · Built by Phacility