3 Replies Latest reply on Apr 28, 2014 1:05 PM by domiller

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

    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.