[Bug]: Library entries matching Duplicate files from the provided DupeGuru file are not consistently being returned

[louisl4696]

Checklist

• [x] I am using an up-to-date version.
• [x] I have read the documentation.
• [x] I have searched existing issues.

TagStudio Version

Alpha 9.5.6

Operating System & Version

Windows 10

Description

In the context of finding duplicate files, when querying for a file by its path in the library, sometimes the application uses a LIKE operator, othertimes a operator. In my testing, the operator fails to return the matching Entry ID. My guess is that it may have something to do with capitalization or special characters in the file paths.

I was able to solve for myself this by hardcoding the use of the LIKE operator, but this is definitely not an ideal solution. See my thread in discord for more details.

Expected Behavior

All duplicate files present in both the library and the loaded DupeGuru file should appear in the dialog box no empty lists should appear in the dialog box

Steps to Reproduce

1. Navigate to Tools > Fix Duplicate Files > Load DupeGuru File
2. Load a dupeguru file
3. Click Mirror Entries
4. Observe

Logs

No response