Skip to content

Ensure fts is prefered over trigram and use union_all instead of union in user search query

rinpatch requested to merge fix/use-union-all into develop

Union does not guarantee that second query is appended to the first one so instead we add a search_type field and order by that before filtering by distinct user id. Also changed union to union_all because it is significantly faster and deduping is done by distinct anyway

Merge request reports