*** DRAFT ***

SQLite Requirement Matrix Details
c_limit_attached.html

Index Summary Markup Original


R-61987-00541-30628-29518-50059-37734-56753-06843 tcl slt th3 src

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

tcl/sqllimits1.test:253   th3/req1/limit01.test:27

/* IMP: R-61987-00541 */
# EVIDENCE-OF: R-61987-00541 SQLITE_LIMIT_LENGTH The maximum size of any
# string or BLOB or table row, in bytes.

R-09808-17554-50654-05359-25920-63839-21736-07612 tcl slt th3 src

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

tcl/sqllimits1.test:412   th3/req1/limit02.test:28

/* IMP: R-09808-17554 */
# EVIDENCE-OF: R-09808-17554 SQLITE_LIMIT_SQL_LENGTH The maximum length
# of an SQL statement, in bytes.

R-43996-29471-48886-45304-51416-12121-07825-19150 tcl slt th3 src

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.

tcl/sqllimits1.test:576   th3/req1/limit02.test:48

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

R-12723-08526-08318-37597-13416-02611-20506-59607 tcl slt th3 src

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

tcl/sqllimits1.test:688   th3/req1/limit02.test:114

/* IMP: R-12723-08526 */
# EVIDENCE-OF: R-12723-08526 SQLITE_LIMIT_EXPR_DEPTH The maximum depth
# of the parse tree on any expression.

R-07801-24468-36344-27295-15963-50909-61997-55720 tcl slt th3 src

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

th3/req1/limit02.test:132

/* IMP: R-07801-24468 */
# EVIDENCE-OF: R-07801-24468 SQLITE_LIMIT_COMPOUND_SELECT The maximum
# number of terms in a compound SELECT statement.

R-48764-26733-47009-14023-25431-43800-20632-23039 tcl slt th3 src

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.

th3/cov1/vdbe43.test:38   th3/req1/limit02.test:148

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

R-59001-45278-16450-29510-31593-00362-58308-30623 tcl slt th3 src

SQLITE_LIMIT_FUNCTION_ARG The maximum number of arguments on a function.

tcl/sqllimits1.test:750   th3/req1/limit02.test:160

/* IMP: R-59001-45278 */
# EVIDENCE-OF: R-59001-45278 SQLITE_LIMIT_FUNCTION_ARG The maximum
# number of arguments on a function.

R-41778-26203-39333-15071-00697-32758-59991-57440 tcl slt th3 src

SQLITE_LIMIT_ATTACHED The maximum number of attached databases.

tcl/sqllimits1.test:786   th3/req1/limit02.test:172

/* IMP: R-41778-26203 */
# EVIDENCE-OF: R-41778-26203 SQLITE_LIMIT_ATTACHED The maximum number of
# attached databases.

R-12940-37052-20666-01661-57871-26003-21807-26945 tcl slt th3 src

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

tcl/sqllimits1.test:836   th3/req1/limit02.test:187

/* IMP: R-12940-37052 */
# EVIDENCE-OF: R-12940-37052 SQLITE_LIMIT_LIKE_PATTERN_LENGTH The
# maximum length of the pattern argument to the LIKE or GLOB operators.

R-42363-29104-39854-61131-26966-39533-29446-04460 tcl slt th3 src

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

tcl/sqllimits1.test:812   th3/req1/limit02.test:215

/* IMP: R-42363-29104 */
# EVIDENCE-OF: R-42363-29104 SQLITE_LIMIT_VARIABLE_NUMBER The maximum
# index number of any parameter in an SQL statement.

R-61726-11117-39197-35640-53612-54106-15944-36516 tcl slt th3 src

SQLITE_LIMIT_TRIGGER_DEPTH The maximum depth of recursion for triggers.

th3/req1/limit02.test:226

/* IMP: R-61726-11117 */
# EVIDENCE-OF: R-61726-11117 SQLITE_LIMIT_TRIGGER_DEPTH The maximum
# depth of recursion for triggers.

R-19249-32353-33767-36599-40313-00705-24761-59859 tcl slt th3 src

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

tcl/sort4.test:29

/* IMP: R-19249-32353 */
# EVIDENCE-OF: R-19249-32353 SQLITE_LIMIT_WORKER_THREADS The maximum
# number of auxiliary worker threads that a single prepared statement
# may start.