Typing in text quickly into foreign key field deletes 2nd keystroke

[githubuser181226]

Hi. I've found an annoying bug.

In data view, in a cell of a column which is configured to be a foreign key, when typing in any text very quickly (example: "12345"), the 2nd keystroke ("2") gets automatically trimmed (leaving "1345").

This doesn't happen if you preface the process with F2 or Enter, or just type slowly.

To bypass the issue, I use LibreCalc to type in the data and then copy and paste it into SQLiteStudio, but obviously this is not optimal.

This could be related to the dropdown list control, specifically the process of populating it and/or its built in quicksearch functionality.

If a table the forign key is referencing has little to no data, the issue is very hard to catch or not present. The more the records in said table, the more frequent and easier to catch is this bug.

I'd really like to see a fix for that. Thank you in advance.

[githubuser181226]

I narrowed the case. The trimming happens when the FK column does not contain the typed in string, If I quickly enter an existing value it's left unaltered. Meaning, this issue most certainly relates to the quicksearch functionality of the foreign key dropdown, however it is not consistent, because sometimes the entire text starting with 2nd letter onwards is removed, but other times it's only the single 2nd letter, and sometimes it is 2nd and 3rd letter :/

[pawelsalawa]

I'm unable to reproduce it.

If you show a video recording how it happens, maybe I will get some idea on how to reproduce it and/or what may be the root cause.