1.Dd December 19, 2018 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. 52If sqlite3_prepare_v2() or the equivalent tries 53to allocate space for more than this many opcodes in a single prepared 54statement, an SQLITE_NOMEM error is returned. 55.It SQLITE_LIMIT_FUNCTION_ARG 56The maximum number of arguments on a function. 57.It SQLITE_LIMIT_ATTACHED 58The maximum number of attached databases. 59.It SQLITE_LIMIT_LIKE_PATTERN_LENGTH 60The maximum length of the pattern argument to the LIKE or GLOB 61operators. 62.It SQLITE_LIMIT_VARIABLE_NUMBER 63The maximum index number of any parameter in an SQL statement. 64.It SQLITE_LIMIT_TRIGGER_DEPTH 65The maximum depth of recursion for triggers. 66.It SQLITE_LIMIT_WORKER_THREADS 67The maximum number of auxiliary worker threads that a single prepared statement 68may start. 69.El 70.Pp 71.Sh SEE ALSO 72.Xr sqlite3_stmt 3 , 73.Xr sqlite3_limit 3 , 74.Xr sqlite3_prepare 3 75