[GH-ISSUE #3479] [Bug]: regex sql function incorrectly matches against null strings #27227

Closed
opened 2026-04-18 03:40:53 -05:00 by GiteaMirror · 0 comments
Owner

Originally created by @qedi-r on GitHub (Sep 21, 2024).
Original GitHub issue: https://github.com/actualbudget/actual/issues/3479

Verified issue does not already exist?

  • I have searched and found no existing issue
  • I will be providing steps how to reproduce the bug (in most cases this will also mean uploading a demo budget file)

What happened?

Steps to reproduce:

  • create a rule that matches on imported payee for "^nu.*"

Expected results:

  • only items that have the string starting with 'nu' appear
  • empty results do not appear

Actual results

  • items with empty imported payees show up as a positive match

image

Where are you hosting Actual?

Locally via Yarn

What browsers are you seeing the problem on?

Chrome

Operating System

None

Originally created by @qedi-r on GitHub (Sep 21, 2024). Original GitHub issue: https://github.com/actualbudget/actual/issues/3479 ### Verified issue does not already exist? - [X] I have searched and found no existing issue - [X] I will be providing steps how to reproduce the bug (in most cases this will also mean uploading a demo budget file) ### What happened? Steps to reproduce: * create a rule that matches on imported payee for "^nu.*" Expected results: * only items that have the string starting with 'nu' appear * empty results do not appear Actual results * items with empty imported payees show up as a positive match ![image](https://github.com/user-attachments/assets/c307d9b1-6bd9-4795-ab20-35c5ca7b5367) ### Where are you hosting Actual? Locally via Yarn ### What browsers are you seeing the problem on? Chrome ### Operating System None
GiteaMirror added the bug label 2026-04-18 03:40:53 -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#27227