AnsweredAssumed Answered

Search incorrectly returns records if the search string is longer than 109 characters, search for...

Question asked by domiller on Apr 21, 2014
Latest reply on Apr 28, 2014 by domiller

Summary

Search incorrectly returns records if the search string is longer than 109 characters, search for duplicates fails also

Product

FileMaker Pro

Version

13.0v2

Operating system version

Windows 8

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
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaab

and

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaac

(Note the b and c occur in character position 110).
Enter search mode, type ! and perform search.

*OR*

Do a simple search for either of the two strings

Expected result

There should be no duplicates found.

Searching for either string should return only that string.

Actual result

Search for duplicates returns both strings.

Searching for either string returns both strings.

Configuration information

If the difference in the string occurs in character position 109 or before, things work as expected.

Workaround

For the string search, doing an exact match (==) performs correctly.

I have not found a workaround for the duplicate search.

Outcomes