Description
When entering % or _ into a text filter input in the mobile app, all features are returned instead of treating these characters as literals. Both % and _ are SQL wildcard characters and must be escaped before being used in a filter query — they should match only features whose field value literally contains % or _, not act as wildcards returning everything.
Environment
[ ] Staging [x] PROD
Application (+ app version, build, operating system)
Mergin Maps iOS 2026.2.0, iOS 26.0
Steps to reproduce
- Open project
tester-ws-1/preview_mode_bug
- Navigate to the filter page
- Open a text filter (e.g.
Text-POI-notes) → enter % → apply
- Reset filter → open the same text filter → enter
_ → apply
Actual results
All features with non empty "notes" field are returned for both % and _ — the characters are interpreted as SQL wildcards (% = any string, _ = any single character).
Expected results
% and _ should be treated as literal characters. Only features whose field value literally contains % or _ should be returned. They must not act as SQL wildcards.
Screenshots or logs
—
Conclusion
Created by Claude and supervised by a human test analyst.
Description
When entering
%or_into a text filter input in the mobile app, all features are returned instead of treating these characters as literals. Both%and_are SQL wildcard characters and must be escaped before being used in a filter query — they should match only features whose field value literally contains%or_, not act as wildcards returning everything.Environment
[ ] Staging [x] PROD
Application (+ app version, build, operating system)
Mergin Maps iOS 2026.2.0, iOS 26.0
Steps to reproduce
tester-ws-1/preview_mode_bugText-POI-notes) → enter%→ apply_→ applyActual results
All features with non empty "notes" field are returned for both
%and_— the characters are interpreted as SQL wildcards (%= any string,_= any single character).Expected results
%and_should be treated as literal characters. Only features whose field value literally contains%or_should be returned. They must not act as SQL wildcards.Screenshots or logs
—
Conclusion
Created by Claude and supervised by a human test analyst.