SQL calls via the plugin API cause a memory leak when the query includes brackets
Operating system version
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.
The result and an increase in memory usage that is never recovered.
Exact text of any error message(s) that appear
Don't use brackets. This often means using multiple queries which can be incredibly inefficient.