2 Replies Latest reply on Feb 25, 2011 4:50 AM by maartenvanthof

    SQL calls via the plugin API cause a memory leak when the query includes brackets

    SimonJoyner

      Summary

      SQL calls via the plugin API cause a memory leak when the query includes brackets

      Product

      FileMaker Pro

      Version

      11.0v2

      Operating system version

      OSX 10.6.6

      Description of the issue

      Using either ExecuteSQL or ExecuteFileSQL to run a query which includes brackets to indicate precedence results in a memory leak. Eventually this causes FileMaker Pro to crash.

      Steps to reproduce the problem

      Run a query such as "SELECT * FROM "MyTable" WHERE ( "Field1" = '1' AND "Field2" = '2')" against either of the plugin API functions.

      Expected result

      The result.

      Actual result

      The result and an increase in memory usage that is never recovered.

      Exact text of any error message(s) that appear

      n/a

      Workaround

      Don't use brackets. This often means using multiple queries which can be incredibly inefficient.