FTS prefix queries not working

[Thomas_Schlosser]

macOS Ventura 13.6
Inkdrop Version 5.6.0 (5.6.0) Apple Silicon

Search does crazy things:

• selected “all notes” finds less notes than in a sub/sub-notebook
• typing 3 letters find one note, adding a fourth letter finds 10 notes

Tried:

• Deleted app (by deleting app bundle from /Applications).
• rescnched from scratch

Did not try:

• X86 version on M1

No issues on my old MacMini and iPhone and iPad

[craftzdog (Takuya Matsuyama)]

Hi Thomas,

Thanks for the report. That’s weird.
It might sound like an FTS index issue.
Can you please try Developer → Rebuild FTS Index? It takes a while.
If it still doesn’t work, you could try removing the local database and sync it again by the following steps:

1. Quit the app
2. Open ~/Library/Application Support/inkdrop/
3. Move the local database with the following command:
   • mv db db.bak
4. Launch the app and let it sync again

@Thomas_Schlosser

typing 3 letters find one note, adding a fourth letter finds 10 notes

Depending on the query, it may work as you said because of Porter stemming algorithm . Here is the detail:

No partial match in full text search

Hi avis, Thank you for the question. That is basically intended behaviors for performance reasons. Regarding English words, it is based on Porter stemming algorithm which is a kind of English morphological word stemming algorithms used for the term normalisation process of full-text search index. You can search ‘doing’ with ‘do’ or ‘doing’ but can’t with ‘doi’. Just like you don’t get results containing ‘doing’ when searched with ‘doi’ on Google. SQLite’s FTS doesn’t work like grep for per…

Hope that helps.

[craftzdog (Takuya Matsuyama)]

Thomas’ reply via email (Please post a comment instead of replying to the notification email):

Thank you Takuya!

I tried both, but both did not change anything.
I deleted and reinstalled the app yesterday (but the DB was still there)

I attach 3 (new) screenshots to illustrate what I described.

1. All notes „cer"

2. All notes „cert"

3. Just Subnotebook “cert“ - these didn’t show up in all notes search.

---

ahhhhhhhhhhh I found that the prefix modifier is not enabled in the latest version!!!
I will enable it back in the next release.
Thanks for letting me know!

[craftzdog (Takuya Matsuyama)]

@Thomas_Schlosser
Could you try this patch?

https://inkdrop-dist.s3.ap-northeast-1.amazonaws.com/tmp/Inkdrop-5.6.2-beta.0-arm64-Mac_patch-1.zip

Hope it works!

[Thomas_Schlosser]

Great!

Thank you.

Thomas

[craftzdog (Takuya Matsuyama)]

Did the patch resolve your issue?

FTS prefix queries not working

@Thomas_Schlosser Could you try this patch? https://inkdrop-dist.s3.ap-northeast-1.amazonaws.com/tmp/Inkdrop-5.6.2-beta.0-arm64-Mac_patch-1.zip Hope it works!

[Thomas_Schlosser]

Thank you. Yes, a 1 minute test did show no more strange behavior!

BR, Thomas

[craftzdog (Takuya Matsuyama)]

Awesome! Thanks for checking it. I’ll prepare rolling it out officially soon

[craftzdog (Takuya Matsuyama)]

v5.6.2 has been released Thanks again for reporting.

Inkdrop Desktop v5.6.2

Hey Inkdroppers, Thanks for reporting bugs and other issues! This release is much more stable now. Download here Sign up here Bugfixes fix(note-list): The popup menu for opening notebook not working (Thanks Shogo-san) fix(keymap): Canceling multi-stroke keymaps not working (Thanks Markus and Kentaro) fix(editor): “Move to notebook” not working properly, where it randomly moves a previously opened note (Thanks Shimizu-san) fix(editor): Do not transform HTML into Markdown when pasting if it …