Filtering a column for "All of the following contains" incorrectly returns some NULL records; "Any of the following contains" is correct

[GaryMeyers1]

Describe the bug When the user is filtering a table with "All contains" logic, some records with NULL data are incorrectly returned. If the filter option is "Any contains", the filter returns the correct records.

To Reproduce

1. View the data of a table with a mixture of null and populated data for a column.
2. Click the Filter button.
3. Select the column from step 1 in the filter column dropdown, select the "contains" option in that dropdown, and enter a string to find in the text box. Make sure that the upper left corner option is "All of the following are true".
4. Click the Apply button.
5. See that there are a mixture of null and populated data in the filtered results.
6. Change the upper left corner option to "Any of the following are true".
7. Click the Apply button.
8. See that there are no records with null data in the filtered results.

Environment details (please complete the following information):

• Device: iMac
• OS: macOS Ventura 13.7.2
• SQLPro app Version: SQLPro for SQLite Version 2025.06 (Build 4386)

[hankinsoft]

Reproduced and fixed for the next build. Will be available late this week or early next.

[hankinsoft]

2025.07 has been released and should sort this. If you get the chance, please give it a try and let me know if that sorts it out.

[hankinsoft]

Closed, if you have any issues with this please let me know.