SQL Statement Strings in eXtremeSQL

There is no simple limit on the length of SQL statements in eXtremeSQL. It depends on the API or tool being used.

When using the C API functions mcosql_execute_statement() or mcosql_execute_query() or the C++ class SqlEngine methods executeStatement() or executeQuery(), the statement of query string length is unlimited. The same applies to the corresponding statement and query execution methods in the JNI, Python and C# wrappers.

However, when using the eXtremeSQL interpreter SqlEngine::main() or xSQL (which uses this method internally), the maximum size of an SQL statement is limited to 64 Kb.

Also when using remote SQL, the statement size is limited by the size of the transmit buffer, which is specified in the C++ RemoteSqlEngine constructor (the default value is 64 Kb). This 64 Kb default is also present in the Java, Python and C# wrappers for remote SQL connections and for the SqlAggregator class.