1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
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
|
