Search incorrectly returns records if the search string is longer than 109 characters, search for duplicates fails also
Operating system version
Description of the issue
Entering a simple search string for a find which is longer than 109 characters finds all records which match in the first 109 characters. Search for duplicates (!) performs similarly.
Steps to reproduce the problem
Create a table with a text field. Create two records with values
(Note the b and c occur in character position 110).
Enter search mode, type ! and perform search.
Do a simple search for either of the two strings
There should be no duplicates found.
Searching for either string should return only that string.
Search for duplicates returns both strings.
Searching for either string returns both strings.
If the difference in the string occurs in character position 109 or before, things work as expected.
For the string search, doing an exact match (==) performs correctly.
I have not found a workaround for the duplicate search.