[BACK]Return to SQLITE_LIMIT_LENGTH.3 CVS log [TXT][DIR] 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
Branch: MAIN
CVS Tags: prg-localcount2-base3, prg-localcount2-base2, prg-localcount2-base1, prg-localcount2-base, prg-localcount2, phil-wifi-base, pgoyette-localcount-20170426, pgoyette-localcount-20170320, pgoyette-compat-base, pgoyette-compat-1126, pgoyette-compat-1020, pgoyette-compat-0930, pgoyette-compat-0906, pgoyette-compat-0728, pgoyette-compat-0625, pgoyette-compat-0521, pgoyette-compat-0502, pgoyette-compat-0422, pgoyette-compat-0415, pgoyette-compat-0407, pgoyette-compat-0330, pgoyette-compat-0322, pgoyette-compat-0315, perseant-stdc-iso10646-base, perseant-stdc-iso10646, netbsd-8-base, netbsd-8-2-RELEASE, netbsd-8-1-RELEASE, netbsd-8-1-RC1, netbsd-8-0-RELEASE, netbsd-8-0-RC2, netbsd-8-0-RC1, netbsd-8, matt-nb8-mediatek-base, matt-nb8-mediatek, bouyer-socketcan-base1
Branch point for: phil-wifi, pgoyette-compat
Changes since 1.3: +1 -1 lines

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