Return to SQLITE_LIMIT_LENGTH.3 CVS log | Up to [cvs.NetBSD.org] / src / external / public-domain / sqlite / man |
File: [cvs.NetBSD.org] / src / external / public-domain / sqlite / man / SQLITE_LIMIT_LENGTH.3 (download)
Revision 1.4, Sat Mar 11 16:29:52 2017 UTC (7 years ago) by christos
merge 3.17.0 |
.Dd March 11, 2017 .Dt SQLITE_LIMIT_LENGTH 3 .Os .Sh NAME .Nm SQLITE_LIMIT_LENGTH , .Nm SQLITE_LIMIT_SQL_LENGTH , .Nm SQLITE_LIMIT_COLUMN , .Nm SQLITE_LIMIT_EXPR_DEPTH , .Nm SQLITE_LIMIT_COMPOUND_SELECT , .Nm SQLITE_LIMIT_VDBE_OP , .Nm SQLITE_LIMIT_FUNCTION_ARG , .Nm SQLITE_LIMIT_ATTACHED , .Nm SQLITE_LIMIT_LIKE_PATTERN_LENGTH , .Nm SQLITE_LIMIT_VARIABLE_NUMBER , .Nm SQLITE_LIMIT_TRIGGER_DEPTH , .Nm SQLITE_LIMIT_WORKER_THREADS .Nd Run-Time Limit Categories .Sh SYNOPSIS .Fd #define SQLITE_LIMIT_LENGTH .Fd #define SQLITE_LIMIT_SQL_LENGTH .Fd #define SQLITE_LIMIT_COLUMN .Fd #define SQLITE_LIMIT_EXPR_DEPTH .Fd #define SQLITE_LIMIT_COMPOUND_SELECT .Fd #define SQLITE_LIMIT_VDBE_OP .Fd #define SQLITE_LIMIT_FUNCTION_ARG .Fd #define SQLITE_LIMIT_ATTACHED .Fd #define SQLITE_LIMIT_LIKE_PATTERN_LENGTH .Fd #define SQLITE_LIMIT_VARIABLE_NUMBER .Fd #define SQLITE_LIMIT_TRIGGER_DEPTH .Fd #define SQLITE_LIMIT_WORKER_THREADS .Sh DESCRIPTION These constants define various performance limits that can be lowered at run-time using sqlite3_limit(). The synopsis of the meanings of the various limits is shown below. Additional information is available at Limits in SQLite. .Bl -tag -width Ds .It SQLITE_LIMIT_LENGTH The maximum size of any string or BLOB or table row, in bytes. .It SQLITE_LIMIT_SQL_LENGTH The maximum length of an SQL statement, in bytes. .It 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. .It SQLITE_LIMIT_EXPR_DEPTH The maximum depth of the parse tree on any expression. .It SQLITE_LIMIT_COMPOUND_SELECT The maximum number of terms in a compound SELECT statement. .It SQLITE_LIMIT_VDBE_OP The maximum number of instructions in a virtual machine program used to implement an SQL statement. This limit is not currently enforced, though that might be added in some future release of SQLite. .It SQLITE_LIMIT_FUNCTION_ARG The maximum number of arguments on a function. .It SQLITE_LIMIT_ATTACHED The maximum number of attached databases. .It SQLITE_LIMIT_LIKE_PATTERN_LENGTH The maximum length of the pattern argument to the LIKE or GLOB operators. .It SQLITE_LIMIT_VARIABLE_NUMBER The maximum index number of any parameter in an SQL statement. .It SQLITE_LIMIT_TRIGGER_DEPTH The maximum depth of recursion for triggers. .It SQLITE_LIMIT_WORKER_THREADS The maximum number of auxiliary worker threads that a single prepared statement may start. .El .Pp .Sh SEE ALSO .Xr sqlite3_stmt 3 , .Xr sqlite3_limit 3