Search is worse with v5.6.0

[SDO]

Bug report

Hello again This time time reporting a bug as a paid user
I noticed that the search function is performing worse/not at all after the 5.6.0 update. My assumption: You changed it to look for ‘entire words’ instead of ‘contains’. In addition search does not update with every key typed. I am adding a few pictures so that it becomes obvious

Environment

• Platform: macOs m1 and m2 pro
• Platform version: Sonoma 14.0
• App Version: 5.6.0

How to reproduce

I have a note with the Title “Performance” and am trying to search for it

Typing in “perfor” and even pressing ‘enter’ or ‘search all’ does nothing

I have now added another letter ‘perform’ and now it is found

Searching for ‘formance’ yields nothing, hence my assumption that it is looking for whole words instead of ‘contains’

If you want me to check some other things let me know Overall I am very happy with the new update

[craftzdog (Takuya Matsuyama)]

Hi SDO,

Thanks for the report.
I haven’t changed the full-text search in v5.6.0.
and I guess it would be a duplicate question of:

Search not finding document correctly with incomplete words

Bug report Sometimes documents do not appear when I enter a part of the searched word only. → Environment Platform: macOS Platform version: Ventura 13.2 M1 Pro App Version: 5.5.3 How to reproduce Have a document named `Jupyter`` Then search for these words: jup → finds the document jupy → document NOT found jupyt → document found again Compare to the attached images: [Bildschirm­foto 2023-03-29 um 16.41.33] [Bildschirm­foto 2023-03-29 um 16.41.37] [Bildschirm­foto 2023-03-29…

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…

Could you check them?

[SDO]

Thank you, that explains it. However I find it weird that I did not notice this behavior at all with v5.5 but immediately with v5.6

[craftzdog (Takuya Matsuyama)]

that’s weird but I have changed nothing regarding the FTS.
That ‘formance’ yields nothing is an expected behavior of the Porter stemming algorithm, just like you can’t find pages including ‘performance’ by searching with the keyword ‘formance’ on Google.

[craftzdog (Takuya Matsuyama)]

Found that the prefix modifier hasn’t been added as of v5.6.0!
@SDO Sorry for my misunderstanding.
Check out the current discussion:

FTS prefix queries not working

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. All notes „cer" [Bildschirmfoto von Inkdrop (16-11-23, 09-39-19)] All notes „cert" [Bildschirmfoto von Inkdrop (16-11-23, 09-39-34)] Just Subnotebook “cert“ - these didn’t show up in all not…

Thanks again for letting me know!

[SDO]

Great to hear! This has been bugging me quite a bit

[craftzdog (Takuya Matsuyama)]

v5.6.2 has been released Thanks again for reporting as always.

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 …

[SDO]

Thank you again. Muuuuch better now Just one question whether this behaviour is normal:

writing “perform” finds the note now when it didn’t previously. Everything from p → perform finds the note.

However, performa|performan|performanc do not find the note. Is this expected behavior from the algorithm?

“performance” obviously works again

[craftzdog (Takuya Matsuyama)]

Yeah, I can see the similar behavior, too. And it looks like the expected behavior of the Porter stemming algorithm.
The only way to solve this is to use bi-gram/tri-gram but SQLite itself doesn’t support it natively.

[SDO]

understood. The way it works now is more than sufficient for my needs