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

SQLite FTS Query Syntax is not working as expected #227

Closed
astyled opened this issue Jun 24, 2023 · 1 comment
Closed

SQLite FTS Query Syntax is not working as expected #227

astyled opened this issue Jun 24, 2023 · 1 comment
Labels
bug Something isn't working
Milestone

Comments

@astyled
Copy link
Member

astyled commented Jun 24, 2023

After search rewrite in SQL, it was advised to use this syntax. However, it is not that useful when AND only works with the words standing near each other.

Additional context: trigram tokenizer.

@astyled astyled added the bug Something isn't working label Jun 24, 2023
@vednoc vednoc added this to the v2.0 release milestone Jun 24, 2023
@vednoc
Copy link
Member

vednoc commented Jun 24, 2023

For more context, @a0eoc searched for "debloat AND vk". As noted in https://sqlite.org/fts5.html#the_trigram_tokenizer, substring has to be three or more unicode characters. We could check the length of search keyword and show an error if that requirement isn't met. Additionally, we might want to show a similar error when advanced search syntax is used but no results are returned.

@astyled astyled changed the title SQLite Full-text Query Syntax is broken SQLite FTS Query Syntax is not working as expected Jun 24, 2023
@vednoc vednoc closed this as completed in 22b6c2d Jun 27, 2023
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
Status: Done
Development

No branches or pull requests

2 participants