Updated: 2025/Nov/16

Please read Privacy Policy. It's for your privacy.

SQLITE_LIMIT_LENGTH(3)     Library Functions Manual     SQLITE_LIMIT_LENGTH(3)

NAME
     SQLITE_LIMIT_LENGTH, SQLITE_LIMIT_SQL_LENGTH, SQLITE_LIMIT_COLUMN,
     SQLITE_LIMIT_EXPR_DEPTH, SQLITE_LIMIT_COMPOUND_SELECT,
     SQLITE_LIMIT_VDBE_OP, SQLITE_LIMIT_FUNCTION_ARG, SQLITE_LIMIT_ATTACHED,
     SQLITE_LIMIT_LIKE_PATTERN_LENGTH, SQLITE_LIMIT_VARIABLE_NUMBER,
     SQLITE_LIMIT_TRIGGER_DEPTH, SQLITE_LIMIT_WORKER_THREADS - run-Time limit
     categories

SYNOPSIS
     #include <sqlite3.h>

     #define SQLITE_LIMIT_LENGTH
     #define SQLITE_LIMIT_SQL_LENGTH
     #define SQLITE_LIMIT_COLUMN
     #define SQLITE_LIMIT_EXPR_DEPTH
     #define SQLITE_LIMIT_COMPOUND_SELECT
     #define SQLITE_LIMIT_VDBE_OP
     #define SQLITE_LIMIT_FUNCTION_ARG
     #define SQLITE_LIMIT_ATTACHED
     #define SQLITE_LIMIT_LIKE_PATTERN_LENGTH
     #define SQLITE_LIMIT_VARIABLE_NUMBER
     #define SQLITE_LIMIT_TRIGGER_DEPTH
     #define SQLITE_LIMIT_WORKER_THREADS

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.

     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.

IMPLEMENTATION NOTES
     These declarations were extracted from the interface documentation at
     line 4068.

     #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

SEE ALSO
     sqlite3_limit(3), sqlite3_prepare(3), sqlite3_stmt(3)

NetBSD 11.99                   January 24, 2024                   NetBSD 11.99