From 63847496f14c813a5d80efd5b7de0f1294ffe1e3 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 16:07:11 +0200 Subject: Adding upstream version 3.45.1. Signed-off-by: Daniel Baumann --- www/c3ref/c_limit_attached.html | 205 ++++++++++++++++++++++++++++++++++++++++ 1 file changed, 205 insertions(+) create mode 100644 www/c3ref/c_limit_attached.html (limited to 'www/c3ref/c_limit_attached.html') diff --git a/www/c3ref/c_limit_attached.html b/www/c3ref/c_limit_attached.html new file mode 100644 index 0000000..1a4e7cf --- /dev/null +++ b/www/c3ref/c_limit_attached.html @@ -0,0 +1,205 @@ + + + + + +Run-Time Limit Categories + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ + +
+

SQLite C Interface

 +

Run-Time Limit Categories

+
+
+#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
+
+

+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.

+ +

+ +
SQLITE_LIMIT_LENGTH
+
The maximum size of any string or BLOB or table row, in bytes.

+ +

+

SQLITE_LIMIT_SQL_LENGTH
+
The maximum length of an SQL statement, in bytes.

+ +

+

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.

+ +

+

SQLITE_LIMIT_EXPR_DEPTH
+
The maximum depth of the parse tree on any expression.

+ +

+

SQLITE_LIMIT_COMPOUND_SELECT
+
The maximum number of terms in a compound SELECT statement.

+ +

+

SQLITE_LIMIT_VDBE_OP
+
The maximum number of instructions in a virtual machine program +used to implement an SQL statement. If 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.

+ +

+

SQLITE_LIMIT_FUNCTION_ARG
+
The maximum number of arguments on a function.

+ +

+

SQLITE_LIMIT_ATTACHED
+
The maximum number of attached databases.

+ +

+ +

SQLITE_LIMIT_LIKE_PATTERN_LENGTH
+
The maximum length of the pattern argument to the LIKE or +GLOB operators.

+ +

+ +

SQLITE_LIMIT_VARIABLE_NUMBER
+
The maximum index number of any parameter in an SQL statement.

+ +

+

SQLITE_LIMIT_TRIGGER_DEPTH
+
The maximum depth of recursion for triggers.

+ +

+

SQLITE_LIMIT_WORKER_THREADS
+
The maximum number of auxiliary worker threads that a single +prepared statement may start.
+
+

See also lists of + Objects, + Constants, and + Functions.

+ -- cgit v1.2.3