AnsweredAssumed Answered

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

Question asked by SimonJoyner on Feb 6, 2011
Latest reply on Feb 25, 2011 by maartenvanthof

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.

Outcomes