Summary

Document Search (Node Docs) does not give the expected result.

Steps to reproduce

Search for "soy" and for "sauce" after here:

https://dev.sub.gargantext.org/#/share/NodeTexts/188476

What is the current bug behavior?

• search for "soy" gives no result
• search for "sauce" gives 42 results and one can check "soy sauce" in data

What is the expected correct behavior?

• search for "soy" should give exact documents matching with "soy" ("sauce sauce" included).

Relevant logs and/or screenshots

To reproduce it locally you can import data.

Inside Database, ts_vector column (search) shows it is ‘soy’:106 ‘sp’:70 ‘specif’:92 ‘storag’:95 ‘streptomyc’:69 ‘studi’:2 ‘thick’:15,26,60 ‘thick-film’:14,25,59 ‘use’🈸

But ts_vector is not used: https://gitlab.iscpif.fr/gargantext/haskell-gargantext/blob/dev/src/Gargantext/Database/Query/Facet.hs#L201-227

Possible fixes

• why the ilike search is not working, fixing it ?
• if not possible, why not using results of ts_vector too (at first quick fix).

Then we could think about another service (see irc logs written by @cgenie )