Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
complete.html

Index Summary Markup Original


R-00971-36933-64386-25480-59601-44057-12316-57384 tcl slt th3 src

These routines return 1 if the input string appears to be a complete SQL statement.

th3/cov1/complete01.test:13

/* IMP: R-00971-36933 */
# EVIDENCE-OF: R-00971-36933 These routines return 1 if the input string
# appears to be a complete SQL statement.

R-42660-47528-56905-42571-24684-45816-05890-54288 tcl slt th3 src

A statement is judged to be complete if it ends with a semicolon token and is not a prefix of a well-formed CREATE TRIGGER statement.

th3/cov1/complete01.test:63

/* IMP: R-42660-47528 */
# EVIDENCE-OF: R-42660-47528 A statement is judged to be complete if it
# ends with a semicolon token and is not a prefix of a well-formed
# CREATE TRIGGER statement.

R-62039-61571-24368-30333-11201-30520-56861-22686 tcl slt th3 src

Semicolons that are embedded within string literals or quoted identifier names or comments are not independent tokens (they are part of the token in which they are embedded) and thus do not count as a statement terminator.

th3/cov1/complete01.test:35

/* IMP: R-62039-61571 */
# EVIDENCE-OF: R-62039-61571 Semicolons that are embedded within string
# literals or quoted identifier names or comments are not independent
# tokens (they are part of the token in which they are embedded) and
# thus do not count as a statement terminator.

R-07444-33850-51822-16540-61383-01460-32210-48440 tcl slt th3 src

Whitespace and comments that follow the final semicolon are ignored.

th3/cov1/complete01.test:27

/* IMP: R-07444-33850 */
# EVIDENCE-OF: R-07444-33850 Whitespace and comments that follow the
# final semicolon are ignored.

R-25459-18529-03655-35597-46929-35137-47473-63058 tcl slt th3 src

These routines return 0 if the statement is incomplete.

th3/cov1/complete01.test:16

/* IMP: R-25459-18529 */
# EVIDENCE-OF: R-25459-18529 These routines return 0 if the statement is
# incomplete.

R-33035-16498-10379-54790-22685-33042-10966-12535 tcl slt th3 src

If a memory allocation fails, then SQLITE_NOMEM is returned.

th3/cov1/complete01.test:137

/* IMP: R-33035-16498 */
# EVIDENCE-OF: R-33035-16498 If a memory allocation fails, then
# SQLITE_NOMEM is returned.

R-33211-38833-64331-54724-35381-31821-05246-63257 tcl slt th3 src

These routines do not parse the SQL statements thus will not detect syntactically incorrect SQL.

th3/cov1/complete01.test:90

/* IMP: R-33211-38833 */
# EVIDENCE-OF: R-33211-38833 These routines do not parse the SQL
# statements thus will not detect syntactically incorrect SQL.

R-35921-30782-30597-38751-45197-16333-41298-65365 tcl slt th3 src

If SQLite has not been initialized using sqlite3_initialize() prior to invoking sqlite3_complete16() then sqlite3_initialize() is invoked automatically by sqlite3_complete16(). If that initialization fails, then the return value from sqlite3_complete16() will be non-zero regardless of whether or not the input SQL is complete.

th3/cov1/complete01.test:147

/* IMP: R-35921-30782 */
# EVIDENCE-OF: R-35921-30782 If SQLite has not been initialized using
# sqlite3_initialize() prior to invoking sqlite3_complete16() then
# sqlite3_initialize() is invoked automatically by sqlite3_complete16().
# If that initialization fails, then the return value from
# sqlite3_complete16() will be non-zero regardless of whether or not the
# input SQL is complete.