Run-Time Limit Categories
\ #define SQLITE_LIMIT_LENGTH 0\ #define SQLITE_LIMIT_SQL_LENGTH 1\ #define SQLITE_LIMIT_COLUMN 2\ #define SQLITE_LIMIT_EXPR_DEPTH 3\ #define SQLITE_LIMIT_COMPOUND_SELECT 4\ #define SQLITE_LIMIT_VDBE_OP 5\ #define SQLITE_LIMIT_FUNCTION_ARG 6\ #define SQLITE_LIMIT_ATTACHED 7\ #define SQLITE_LIMIT_LIKE_PATTERN_LENGTH 8\ #define SQLITE_LIMIT_VARIABLE_NUMBER 9\ #define SQLITE_LIMIT_TRIGGER_DEPTH 10\ #define SQLITE_LIMIT_WORKER_THREADS 11\ #define SQLITE_LIMIT_PARSER_DEPTH 12\
These constants define various performance limits that can be lowered at run-time using sqlite3_limit(). A concise description of these limits follows, and additional information is available at Limits in SQLite.
SQLITE_LIMIT_LENGTH
The maximum size of any string or BLOB or table row, in bytes.
SQLITE_LIMIT_SQL_LENGTH
The maximum length of an SQL statement, in bytes.
SQLITE_LIMIT_COLUMN
The maximum number of columns in a table definition or in the result set of a SELECT or the maximum number of columns in an index or in an ORDER BY or GROUP BY clause.
SQLITE_LIMIT_EXPR_DEPTH
The maximum depth of the parse tree on any expression and the maximum nesting depth for subqueries and VIEWs
SQLITE_LIMIT_PARSER_DEPTH
The maximum depth of the LALR(1) parser stack used to analyze input SQL statements.
SQLITE_LIMIT_COMPOUND_SELECT
The maximum number of terms in a compound SELECT statement.
SQLITE_LIMIT_VDBE_OP
The maximum number of instructions in a virtual machine program used to implement an SQL statement. If sqlite3_prepare_v2() or the equivalent tries to allocate space for more than this many opcodes in a single prepared statement, an SQLITE_NOMEM error is returned.
SQLITE_LIMIT_FUNCTION_ARG
The maximum number of arguments on a function.
SQLITE_LIMIT_ATTACHED
The maximum number of attached databases.
SQLITE_LIMIT_LIKE_PATTERN_LENGTH
The maximum length of the pattern argument to the LIKE or GLOB operators.
SQLITE_LIMIT_VARIABLE_NUMBER
The maximum index number of any parameter in an SQL statement.
SQLITE_LIMIT_TRIGGER_DEPTH
The maximum depth of recursion for triggers, and the maximum nesting depth for separate triggers.
SQLITE_LIMIT_WORKER_THREADS
The maximum number of auxiliary worker threads that a single prepared statement may start.