Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
limit.html

Index Summary Markup Original


R-46380-62105-49403-51977-53564-35485-34919-25717 tcl slt th3 src

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.

th3/req1/limit01.test:9   th3/req1/limit02.test:9

/* IMP: R-46380-62105 */
# EVIDENCE-OF: 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-49113-60930-43191-11602-63829-33469 tcl slt th3 src

If the new limit is a negative number, the limit is unchanged.

src/main.c:2502   th3/req1/limit01.test:52

/* IMP: R-52476-28732 */
# EVIDENCE-OF: R-52476-28732 If the new limit is a negative number, the
# limit is unchanged.

R-30189-54097-58322-43687-36717-28803-52946-09131 tcl slt th3 src

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_".)

src/main.c:2477

/* IMP: R-30189-54097 */
# EVIDENCE-OF: 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-03361-45717-43677-30720-21925-17287 tcl slt th3 src

Attempts to increase a limit above its hard upper bound are silently truncated to the hard upper bound.

src/main.c:2504   th3/req1/limit01.test:79

/* IMP: R-51463-25634 */
# EVIDENCE-OF: R-51463-25634 Attempts to increase a limit above its hard
# upper bound are silently truncated to the hard upper bound.

R-53341-35419-60805-00614-53630-15165-00520-17900 tcl slt th3 src

Regardless of whether or not the limit was changed, the sqlite3_limit() interface returns the prior value of the limit.

src/main.c:2508   th3/req1/limit01.test:71

/* IMP: R-53341-35419 */
# EVIDENCE-OF: 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-50585-21714-21268-35296-20673-02389 tcl slt th3 src

Hence, to find the current value of a limit without changing it, simply invoke this interface with the third parameter set to -1.

th3/req1/limit01.test:44

/* IMP: R-49755-52305 */
# EVIDENCE-OF: 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.