[PR #5845] fix(#5840): transaction view with ? #13215

Closed
opened 2026-04-10 21:49:38 -05:00 by GiteaMirror · 0 comments
Owner

Original Pull Request: https://github.com/actualbudget/actual/pull/5845

State: closed
Merged: No


Fixes #5840
This PR fixes a bug where searching for a ? in the quick search would return all transactions instead of only the transactions containing a literal ?. The root cause of this issue was in the UNICODE_LIKE custom SQLite function, which was incorrectly treating ? as a single-character wildcard, similar to the _ character in SQL's LIKE operator. The fix involves modifying the unicodeLike function to no longer treat ? as a wildcard. Instead, it is now treated as a literal character. This is achieved by escaping the ? character when constructing the regular expression in the unicodeLike function.

**Original Pull Request:** https://github.com/actualbudget/actual/pull/5845 **State:** closed **Merged:** No --- Fixes #5840 This PR fixes a bug where searching for a ? in the quick search would return all transactions instead of only the transactions containing a literal `?`. The root cause of this issue was in the UNICODE_LIKE custom SQLite function, which was incorrectly treating `?` as a single-character wildcard, similar to the _ character in SQL's LIKE operator. The fix involves modifying the unicodeLike function to no longer treat `?` as a wildcard. Instead, it is now treated as a literal character. This is achieved by escaping the `?` character when constructing the regular expression in the unicodeLike function.
GiteaMirror added the pull-request label 2026-04-10 21:49:38 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#13215