pagermon icon indicating copy to clipboard operation
pagermon copied to clipboard

Update SQLite3 Message Search query logic

Open bullseye555 opened this issue 1 year ago • 3 comments

Description

Update from MATCH (whole word results only) to LIKE (string results, regardless of where the string is in the decode) for SQLite3 Message Search string

Fixes #623

Type of change

  • [X] Bug fix (non-breaking change which fixes an issue)

How Has This Been Tested?

  • [X] Tested searching whole-words
  • [X] Tested searching for partial words
  • [X] Tested searching for numbers
  • [X] Tested searching for strings containing symbols (eg: @,#/*!$^&()-+.)

##NOTE: SQL wildcard symbols _ and % continue to function as wildcard symbols

Checklist:

  • [X] My code follows the style guidelines of this project
  • [X] I have performed a self-review of my own code
  • [X] I have commented my code, particularly in hard-to-understand areas
  • [X] I have updated changelog.md with changes made

bullseye555 avatar Dec 12 '24 01:12 bullseye555

Rebased to develop

DanrwAU avatar Apr 20 '25 02:04 DanrwAU

This bug exists on other database types also afaik. Any chance of a holistic fix across all DB types?

DanrwAU avatar Apr 20 '25 02:04 DanrwAU

We could switch from MATCH to LIKE in general. All three DBs systems currently supported would support LIKE, with the only (manageable) pinpoint being them not uniform with case sensitivity. We might want to have some way to make whole world search available though. I think it might be best to implement some sort of query language that enables searches as alias:"CITY" message:"FIRE" -message:"Test"

eopo avatar Apr 20 '25 12:04 eopo