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:
- 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
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