mattermost/mattermost

Inconsistent search results with wildcard

Open

#27 688 ouverte le 17 juil. 2024

Voir sur GitHub
 (4 commentaires) (0 réactions) (1 assigné)TypeScript (32 880 stars) (7 823 forks)batch import
Help Wanted

Description

Summary

Depending on whether I use "phpm*", "phpmy*", or "phpmya*" I get different search results for the term phpmyadmin

Steps to reproduce

In the search bar I type the above wildcard-abbreviated search terms.

  1. Searching for phpm*, I get a total of 9 messages, e.g.,:

    • "Already updated it on phpmyadmin. I left the type as a varchar [...]"
    • "[...] Already added it on phpmyadmin and the backend already assumes its existence."

  2. Searching for phpmy*, I get no results.

  3. Searching for phpmya* I get the same results as with 1. before.

Operating System

Windows 10 x64, Mattermost Desktop App Version 5.8.1 (latest)

Mattermost Server Version

Mattermost-Version: 9.9.1 Datenbankschema-Version: 121 Build-Nummer: 9683539226 Datenbank: postgres

Expected behavior

Return all messages that contain the word phpMyAdmin for all wildcard searches.

Observed behavior

Seemingly erratic results of matching messages versus no results at all.

Log Output

n/a

Additional Information

Screenshot search term phpm* Screenshot search term phpmy*

Possible fixes

🤷‍♂️

Guide contributeur

Stack technique
gotypescriptreactpostgresql
Domaine
searchbackend
Type d'issue
bug
DifficultéDifficulté estimée pour un nouveau contributeur, de 1 pour un très petit changement à 5 pour un travail expert.
3
Temps estiméFourchette de temps approximative pour investiguer, implémenter, tester et préparer une pull request.
1-3 hours
Statut d'activitéDisponibilité apparente de l'issue : fraîche, active, ancienne, bloquée ou en attente d'un mainteneur.
stale
ClartéClarté avec laquelle l'issue explique le changement attendu, les critères d'acceptation et la prochaine étape.
mostly clear
Prérequis
Understanding of search indexingFamiliarity with PostgreSQL full text search
Accessibilité débutantScore de 1 à 100 estimant l'accessibilité de cette issue pour un premier contributeur.
25
Direction de recherche
Investigate search query parsing in Mattermost, particularly wildcard handling. Check the database query generation for PostgreSQL full text search. Compare results between 'phpm*', 'phpmy*', and 'phpmya*' to identify where the filtering breaks. Look at relevant files in the server/search and app/search directories.