1 Reply Latest reply on Apr 22, 2010 9:24 AM by TSGal

    FileMaker Pro 11 (Mac) crashes when using Execute SQL with some ODBC drivers and long SQL statements

    greglane

      Summary

      FileMaker Pro 11 (Mac) crashes when using Execute SQL with some ODBC drivers and long SQL statements

      Description of the issue

      The Execute SQL script step consistently crashes FileMaker Pro Advanced 11.0v1 on Mac OS X 10.6.3 when executing "long" SQL queries.When connecting to a MySQL 5.1 data source with the MySQL Connector-ODBC 5.1.6 driver, FileMaker Pro crashes when executing a query longer than 32,511 characters. A crash also occurs on Mac OS X 10.5.8, however the query length is inconsistent...sometimes as low as 3,839 characters.When connecting to a FileMaker Server Advanced 11 data source with the FileMaker ODBC driver, FileMaker Pro crashes when executing a query longer than 32,767 characters. This also occurs on Mac OS X 10.5.8.The crashes do not occur with the same software versions on Windows or with the Actual Technologies Open Source Databases 3.0.6 driver on Mac OS X. An FMSA 10 data source also works without crashing on both platforms. In these cases, error 1409 is returned when the maximum query length is exceeded. The maximum query length for the Execute SQL script step in FileMaker 11 for MySQL 5.1 data sources appears to be 262,144 characters. The maximum query length for the Execute SQL script step in FileMaker 11 for FMSA 11 data sources appears to be 32,767 characters. The maximum query length for the Execute SQL script step in FileMaker 11 for FMSA 10 data sources appears to be 262,144 characters.Example MySQL query:INSERT INTO myTable (myField) VALUES ('')Example FMSA query:INSERT INTO "myTable" ("myField") VALUES ('')