int sqlite3_limit(sqlite3*, int id, int newVal);
R-46380-62105:[This interface allows the size of various constructs to be limited on a connection by connection basis. The first parameter is the database connection whose limit is to be set or queried. The second parameter is one of the limit categories that define a class of constructs to be size limited. The third parameter is the new limit for that construct. ]
R-52476-28732:[If the new limit is a negative number, the limit is unchanged. ] R-30189-54097:[For each limit category SQLITE_LIMIT_NAME there is a hard upper bound set at compile-time by a C preprocessor macro called SQLITE_MAX_NAME. (The "_LIMIT_" in the name is changed to "_MAX_".) ] R-51463-25634:[Attempts to increase a limit above its hard upper bound are silently truncated to the hard upper bound. ]
R-53341-35419:[Regardless of whether or not the limit was changed, the sqlite3_limit() interface returns the prior value of the limit. ] R-49755-52305:[Hence, to find the current value of a limit without changing it, simply invoke this interface with the third parameter set to -1. ]
New run-time limit categories may be added in future releases.
See also lists of Objects, Constants, and Functions.