Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug]: regex sql function incorrectly matches against null strings #3479

Closed
2 tasks done
qedi-r opened this issue Sep 21, 2024 · 0 comments · Fixed by #3480
Closed
2 tasks done

[Bug]: regex sql function incorrectly matches against null strings #3479

qedi-r opened this issue Sep 21, 2024 · 0 comments · Fixed by #3480
Labels
bug Something isn't working

Comments

@qedi-r
Copy link
Contributor

qedi-r commented Sep 21, 2024

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
@qedi-r qedi-r added the bug Something isn't working label Sep 21, 2024
@qedi-r qedi-r mentioned this issue Sep 21, 2024
Merged
@qedi-r qedi-r changed the title [Bug]: matches regex matches null [Bug]: regex sql function incorrectly matches against null strings Sep 21, 2024
@youngcw youngcw linked a pull request Sep 21, 2024 that will close this issue
update sql regexp to default to empty string when field is null #3480
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

update sql regexp to default to empty string when field is null qedi-r/actual
1 participant
@qedi-r