1.Dd March 11, 2017 2.Dt SQLITE_LIMIT_LENGTH 3 3.Os 4.Sh NAME 5.Nm SQLITE_LIMIT_LENGTH , 6.Nm SQLITE_LIMIT_SQL_LENGTH , 7.Nm SQLITE_LIMIT_COLUMN , 8.Nm SQLITE_LIMIT_EXPR_DEPTH , 9.Nm SQLITE_LIMIT_COMPOUND_SELECT , 10.Nm SQLITE_LIMIT_VDBE_OP , 11.Nm SQLITE_LIMIT_FUNCTION_ARG , 12.Nm SQLITE_LIMIT_ATTACHED , 13.Nm SQLITE_LIMIT_LIKE_PATTERN_LENGTH , 14.Nm SQLITE_LIMIT_VARIABLE_NUMBER , 15.Nm SQLITE_LIMIT_TRIGGER_DEPTH , 16.Nm SQLITE_LIMIT_WORKER_THREADS 17.Nd Run-Time Limit Categories 18.Sh SYNOPSIS 19.Fd #define SQLITE_LIMIT_LENGTH 20.Fd #define SQLITE_LIMIT_SQL_LENGTH 21.Fd #define SQLITE_LIMIT_COLUMN 22.Fd #define SQLITE_LIMIT_EXPR_DEPTH 23.Fd #define SQLITE_LIMIT_COMPOUND_SELECT 24.Fd #define SQLITE_LIMIT_VDBE_OP 25.Fd #define SQLITE_LIMIT_FUNCTION_ARG 26.Fd #define SQLITE_LIMIT_ATTACHED 27.Fd #define SQLITE_LIMIT_LIKE_PATTERN_LENGTH 28.Fd #define SQLITE_LIMIT_VARIABLE_NUMBER 29.Fd #define SQLITE_LIMIT_TRIGGER_DEPTH 30.Fd #define SQLITE_LIMIT_WORKER_THREADS 31.Sh DESCRIPTION 32These constants define various performance limits that can be lowered 33at run-time using sqlite3_limit(). 34The synopsis of the meanings of the various limits is shown below. 35Additional information is available at Limits in SQLite. 36.Bl -tag -width Ds 37.It SQLITE_LIMIT_LENGTH 38The maximum size of any string or BLOB or table row, in bytes. 39.It SQLITE_LIMIT_SQL_LENGTH 40The maximum length of an SQL statement, in bytes. 41.It SQLITE_LIMIT_COLUMN 42The maximum number of columns in a table definition or in the result 43set of a SELECT or the maximum number of columns in an index 44or in an ORDER BY or GROUP BY clause. 45.It SQLITE_LIMIT_EXPR_DEPTH 46The maximum depth of the parse tree on any expression. 47.It SQLITE_LIMIT_COMPOUND_SELECT 48The maximum number of terms in a compound SELECT statement. 49.It SQLITE_LIMIT_VDBE_OP 50The maximum number of instructions in a virtual machine program used 51to implement an SQL statement. 52This limit is not currently enforced, though that might be added in 53some future release of SQLite. 54.It SQLITE_LIMIT_FUNCTION_ARG 55The maximum number of arguments on a function. 56.It SQLITE_LIMIT_ATTACHED 57The maximum number of attached databases. 58.It SQLITE_LIMIT_LIKE_PATTERN_LENGTH 59The maximum length of the pattern argument to the LIKE or GLOB 60operators. 61.It SQLITE_LIMIT_VARIABLE_NUMBER 62The maximum index number of any parameter in an SQL statement. 63.It SQLITE_LIMIT_TRIGGER_DEPTH 64The maximum depth of recursion for triggers. 65.It SQLITE_LIMIT_WORKER_THREADS 66The maximum number of auxiliary worker threads that a single prepared statement 67may start. 68.El 69.Pp 70.Sh SEE ALSO 71.Xr sqlite3_stmt 3 , 72.Xr sqlite3_limit 3 73