diff options
Diffstat (limited to 'static/netbsd/man3/SQLITE_LIMIT_LENGTH.3')
| -rw-r--r-- | static/netbsd/man3/SQLITE_LIMIT_LENGTH.3 | 94 |
1 files changed, 94 insertions, 0 deletions
diff --git a/static/netbsd/man3/SQLITE_LIMIT_LENGTH.3 b/static/netbsd/man3/SQLITE_LIMIT_LENGTH.3 new file mode 100644 index 00000000..db12e1d4 --- /dev/null +++ b/static/netbsd/man3/SQLITE_LIMIT_LENGTH.3 @@ -0,0 +1,94 @@ +.Dd January 24, 2024 +.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 +.In sqlite3.h +.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 +.Fn 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. +If +.Fn 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. +.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 IMPLEMENTATION NOTES +These declarations were extracted from the +interface documentation at line 4068. +.Bd -literal +#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 +.Ed +.Sh SEE ALSO +.Xr sqlite3_limit 3 , +.Xr sqlite3_prepare 3 , +.Xr sqlite3_stmt 3 |