Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fulltext search ignores words shorter than 3 characters #33

Open
maciejjan opened this issue May 15, 2023 · 1 comment
Open

Fulltext search ignores words shorter than 3 characters #33

maciejjan opened this issue May 15, 2023 · 1 comment
Assignees
Labels
bug Something isn't working

Comments

@maciejjan
Copy link
Collaborator

This is because of the lower bound on word length in the index, see: https://mariadb.com/kb/en/full-text-index-overview/#excluded-results

The variable innodb_ft_min_token_size should be set to a lower value. Unfortunately it's not a dynamic variable, so it has to be done either on the command line or in the configuration file. Thus we need to build an own Docker image of MariaDB with this configuration.

@maciejjan maciejjan added the bug Something isn't working label May 15, 2023
@maciejjan maciejjan self-assigned this May 15, 2023
@maciejjan
Copy link
Collaborator Author

maciejjan commented May 15, 2023

Example queries:

  • "ei itke" - too many results, only "itke" considered
  • +ei +itke - no results
  • ei - no results

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant