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