Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
lang_keywords.html

Index Summary Markup Original


R-58133-32721-60366-63441-61614-07001-53385-02322 tcl slt th3 src

A keyword in single quotes is a string literal.

th3/req1/keyword01.test:112

/* IMP: R-58133-32721 */
# EVIDENCE-OF: R-58133-32721 A keyword in single quotes is a string
# literal.

R-49991-12716-30919-42596-27111-39963-53414-21739 tcl slt th3 src

A keyword in double-quotes is an identifier.

th3/req1/keyword01.test:115

/* IMP: R-49991-12716 */
# EVIDENCE-OF: R-49991-12716 A keyword in double-quotes is an
# identifier.

R-15400-09401-11917-03904-29330-15741-54444-34897 tcl slt th3 src

A keyword enclosed in square brackets is an identifier.

th3/req1/keyword01.test:118

/* IMP: R-15400-09401 */
# EVIDENCE-OF: R-15400-09401 A keyword enclosed in square brackets is an
# identifier.

R-57064-52104-64431-17226-40317-39085-08319-65218 tcl slt th3 src

A keyword enclosed in grave accents (ASCII code 96) is an identifier.

th3/req1/keyword01.test:121

/* IMP: R-57064-52104 */
# EVIDENCE-OF: R-57064-52104 A keyword enclosed in grave accents (ASCII
# code 96) is an identifier.

R-33075-33190-25707-00729-29148-31049-04309-45993 tcl slt th3 src

If a keyword in single quotes (ex: 'key' or 'glob') is used in a context where an identifier is allowed but where a string literal is not allowed, then the token is understood to be an identifier instead of a string literal.

th3/req1/keyword01.test:143

/* IMP: R-33075-33190 */
# EVIDENCE-OF: R-33075-33190 If a keyword in single quotes (ex: 'key' or
# 'glob') is used in a context where an identifier is allowed but where
# a string literal is not allowed, then the token is understood to be an
# identifier instead of a string literal.

R-57360-40691-20822-63524-22530-36364-65033-34134 tcl slt th3 src

If a keyword in double quotes (ex: "key" or "glob") is used in a context where it cannot be resolved to an identifier but where a string literal is allowed, then the token is understood to be a string literal instead of an identifier.

th3/req1/keyword01.test:148

/* IMP: R-57360-40691 */
# EVIDENCE-OF: R-57360-40691 If a keyword in double quotes (ex: "key" or
# "glob") is used in a context where it cannot be resolved to an
# identifier but where a string literal is allowed, then the token is
# understood to be a string literal instead of an identifier.

R-38180-24846-43105-41785-31134-37616-17707-32594 tcl slt th3 src

Regardless of the compile-time configuration, any identifier that is not on the following 147-element list is not a keyword to the SQL parser in SQLite:

th3/req1/keyword01.test:24

/* IMP: R-38180-24846 */
# EVIDENCE-OF: R-38180-24846 Regardless of the compile-time
# configuration, any identifier that is not on the following 147-element
# list is not a keyword to the SQL parser in SQLite: ABORT ACTION ADD
# AFTER ALL ALTER ALWAYS ANALYZE AND AS ASC ATTACH AUTOINCREMENT BEFORE
# BEGIN BETWEEN BY CASCADE CASE CAST CHECK COLLATE COLUMN COMMIT
# CONFLICT CONSTRAINT CREATE CROSS CURRENT CURRENT_DATE CURRENT_TIME
# CURRENT_TIMESTAMP DATABASE DEFAULT DEFERRABLE DEFERRED DELETE DESC
# DETACH DISTINCT DO DROP EACH ELSE END ESCAPE EXCEPT EXCLUDE EXCLUSIVE
# EXISTS EXPLAIN FAIL FILTER FIRST FOLLOWING FOR FOREIGN FROM FULL
# GENERATED GLOB GROUP GROUPS HAVING IF IGNORE IMMEDIATE IN INDEX
# INDEXED INITIALLY INNER INSERT INSTEAD INTERSECT INTO IS ISNULL JOIN
# KEY LAST LEFT LIKE LIMIT MATCH MATERIALIZED NATURAL NO NOT NOTHING
# NOTNULL NULL NULLS OF OFFSET ON OR ORDER OTHERS OUTER OVER PARTITION
# PLAN PRAGMA PRECEDING PRIMARY QUERY RAISE RANGE RECURSIVE REFERENCES
# REGEXP REINDEX RELEASE RENAME REPLACE RESTRICT RETURNING RIGHT
# ROLLBACK ROW ROWS SAVEPOINT SELECT SET TABLE TEMP TEMPORARY THEN TIES
# TO TRANSACTION TRIGGER UNBOUNDED UNION UNIQUE UPDATE USING VACUUM
# VALUES VIEW VIRTUAL WHEN WHERE WINDOW WITH WITHOUT