Page MenuHomePhabricator

wrong query parser for tsearch2 (pgsql)
Closed, ResolvedPublic

Description

Author: cedric.villemain

Description:
it seems taht the query parser do the job for mysql not for pgsql :
operators in tsearch query are : () ! | & but + and - are used

I have patch include/SearchPostgres.php to rewrite using the above operators (I have made some tests,
but not all ....).

Know issue : if you search only by the absence of a word there is strange behaviour (I think this is
more mediawiki code than specific postgresql code)


Version: unspecified
Severity: minor

Details

Reference
bz8958

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
InvalidNone
ResolvedNone

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:32 PM
bzimport added a project: MediaWiki-Search.
bzimport set Reference to bz8958.
bzimport added a subscriber: Unknown Object (MLST).

cedric.villemain wrote:

rewrite using tsearch2 valid operators

make more test than I did ....

Attached:

Thanks for the patch - applied in r20040
Added notes about the <. >, and ~ operators - don't know if there
is an easy way for tsearch2 to implement them.

Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.