*** DRAFT ***

SQLite Requirement Matrix Details
lang_altertable.html

Index Summary Markup Original


R-35403-15921-01482-46319-62511-08471-58882-52506 tcl slt th3 src

Canonical usage: syntax/alter-table-stmt.html

th3/req1/altertable01.test:10

/* IMP: R-35403-15921 */
# EVIDENCE-OF: R-35403-15921 -- syntax diagram alter-table-stmt

R-07456-17111-24796-46400-60836-63045-36384-59086 tcl slt th3 src

Canonical usage: syntax/column-def.html

/* IMP: R-07456-17111 */
# EVIDENCE-OF: R-07456-17111 -- syntax diagram column-def

R-56059-09239-26018-63917-02977-43888-08683-25887 tcl slt th3 src

Canonical usage: syntax/column-constraint.html

/* IMP: R-56059-09239 */
# EVIDENCE-OF: R-56059-09239 -- syntax diagram column-constraint

R-18261-05736-40874-08637-62312-01294-07527-53761 tcl slt th3 src

Canonical usage: syntax/conflict-clause.html

th3/req1/conflict01.test:12

/* IMP: R-18261-05736 */
# EVIDENCE-OF: R-18261-05736 -- syntax diagram conflict-clause

R-61970-26480-33028-36412-61944-06610-41249-40014 tcl slt th3 src

Canonical usage: syntax/expr.html

/* IMP: R-61970-26480 */
# EVIDENCE-OF: R-61970-26480 -- syntax diagram expr

R-54197-31877-57350-43471-52348-15226-37714-44266 tcl slt th3 src

Canonical usage: syntax/raise-function.html

/* IMP: R-54197-31877 */
# EVIDENCE-OF: R-54197-31877 -- syntax diagram raise-function

R-19713-52738-52485-51770-14412-64430-18771-01641 tcl slt th3 src

Canonical usage: syntax/select-stmt.html

/* IMP: R-19713-52738 */
# EVIDENCE-OF: R-19713-52738 -- syntax diagram select-stmt

R-29190-16177-49676-56162-41955-57961-52271-56322 tcl slt th3 src

Canonical usage: syntax/common-table-expression.html

/* IMP: R-29190-16177 */
# EVIDENCE-OF: R-29190-16177 -- syntax diagram common-table-expression

R-60687-03927-28728-46307-01187-04245-57381-09290 tcl slt th3 src

Canonical usage: syntax/compound-operator.html

/* IMP: R-60687-03927 */
# EVIDENCE-OF: R-60687-03927 -- syntax diagram compound-operator

R-15218-64377-10732-10708-39996-49168-39639-07301 tcl slt th3 src

Canonical usage: syntax/join-clause.html

/* IMP: R-15218-64377 */
# EVIDENCE-OF: R-15218-64377 -- syntax diagram join-clause

R-59355-25880-50978-14585-20539-54763-44134-61379 tcl slt th3 src

Canonical usage: syntax/join-constraint.html

/* IMP: R-59355-25880 */
# EVIDENCE-OF: R-59355-25880 -- syntax diagram join-constraint

R-24999-30014-65347-53781-01089-16331-37334-22917 tcl slt th3 src

Canonical usage: syntax/join-operator.html

/* IMP: R-24999-30014 */
# EVIDENCE-OF: R-24999-30014 -- syntax diagram join-operator

R-54382-61764-64572-42659-14322-10734-05041-01494 tcl slt th3 src

Canonical usage: syntax/ordering-term.html

/* IMP: R-54382-61764 */
# EVIDENCE-OF: R-54382-61764 -- syntax diagram ordering-term

R-35473-09323-51070-49381-06532-56561-01297-03559 tcl slt th3 src

Canonical usage: syntax/result-column.html

/* IMP: R-35473-09323 */
# EVIDENCE-OF: R-35473-09323 -- syntax diagram result-column

R-45000-47812-33792-18048-40996-50849-16831-13312 tcl slt th3 src

Canonical usage: syntax/table-or-subquery.html

/* IMP: R-45000-47812 */
# EVIDENCE-OF: R-45000-47812 -- syntax diagram table-or-subquery

R-27190-32042-23820-53475-52169-33531-21572-25781 tcl slt th3 src

Canonical usage: syntax/foreign-key-clause.html

/* IMP: R-27190-32042 */
# EVIDENCE-OF: R-27190-32042 -- syntax diagram foreign-key-clause

R-47443-11280-39343-26300-13209-50193-13307-46522 tcl slt th3 src

Canonical usage: syntax/literal-value.html

/* IMP: R-47443-11280 */
# EVIDENCE-OF: R-47443-11280 -- syntax diagram literal-value

R-16446-38486-52659-45236-06548-25582-51186-33834 tcl slt th3 src

Canonical usage: syntax/signed-number.html

/* IMP: R-16446-38486 */
# EVIDENCE-OF: R-16446-38486 -- syntax diagram signed-number

R-27503-48393-50904-62536-02444-59493-56551-12481 tcl slt th3 src

Canonical usage: syntax/type-name.html

/* IMP: R-27503-48393 */
# EVIDENCE-OF: R-27503-48393 -- syntax diagram type-name

R-16446-38486-52659-45236-06548-25582-51186-33834 tcl slt th3 src

Canonical usage: syntax/signed-number.html

/* IMP: R-16446-38486 */
# EVIDENCE-OF: R-16446-38486 -- syntax diagram signed-number

R-32485-24703-27801-29483-21531-11705-09294-53002 tcl slt th3 src

The RENAME TO syntax changes the name of table-name to new-table-name.

th3/req1/altertable01.test:33

/* IMP: R-32485-24703 */
# EVIDENCE-OF: R-32485-24703 The RENAME TO syntax changes the name of
# table-name to new-table-name.

R-18692-17694-63404-11739-00590-02418-57066-37741 tcl slt th3 src

If the table being renamed has triggers or indices, then these remain attached to the table after it has been renamed.

th3/req1/altertable01.test:44

/* IMP: R-18692-17694 */
# EVIDENCE-OF: R-18692-17694 If the table being renamed has triggers or
# indices, then these remain attached to the table after it has been
# renamed.

R-17878-35294-47697-18266-55769-35956-00477-22042 tcl slt th3 src

However, if there are any view definitions, or statements executed by triggers that refer to the table being renamed, these are not automatically modified to use the new table name.

th3/req1/altertable01.test:64

/* IMP: R-17878-35294 */
# EVIDENCE-OF: R-17878-35294 However, if there are any view definitions,
# or statements executed by triggers that refer to the table being
# renamed, these are not automatically modified to use the new table
# name.

R-40827-27357-46487-27198-26867-15174-62736-47681 tcl slt th3 src

If foreign key constraints are enabled when a table is renamed, then any REFERENCES clauses in any table (either the table being renamed or some other table) that refer to the table being renamed are modified to refer to the renamed table by its new name.

th3/req1/altertable01.test:90

/* IMP: R-40827-27357 */
# EVIDENCE-OF: R-40827-27357 If foreign key constraints are enabled when
# a table is renamed, then any REFERENCES clauses in any table (either
# the table being renamed or some other table) that refer to the table
# being renamed are modified to refer to the renamed table by its new
# name.

R-10948-48115-30420-45129-26938-33308-29061-07454 tcl slt th3 src

The ADD COLUMN syntax is used to add a new column to an existing table.

th3/req1/altertable01.test:132

/* IMP: R-10948-48115 */
# EVIDENCE-OF: R-10948-48115 The ADD COLUMN syntax is used to add a new
# column to an existing table.

R-23336-07085-33379-01813-11813-48961-61224-20101 tcl slt th3 src

The new column is always appended to the end of the list of existing columns.

th3/req1/altertable01.test:135

/* IMP: R-23336-07085 */
# EVIDENCE-OF: R-23336-07085 The new column is always appended to the
# end of the list of existing columns.

R-14302-38934-55936-51388-09326-06316-22131-13547 tcl slt th3 src

The new column may take any of the forms permissible in a CREATE TABLE statement, with the following restrictions:

th3/req1/altertable01.test:138

/* IMP: R-14302-38934 */
# EVIDENCE-OF: R-14302-38934 The new column may take any of the forms
# permissible in a CREATE TABLE statement, with the following
# restrictions:

R-45735-05060-45707-02597-62787-16150-27278-23647 tcl slt th3 src

The column may not have a PRIMARY KEY or UNIQUE constraint.

th3/req1/altertable01.test:158

/* IMP: R-45735-05060 */
# EVIDENCE-OF: R-45735-05060 The column may not have a PRIMARY KEY or
# UNIQUE constraint.

R-37287-38238-38896-00540-17030-60706-04523-55035 tcl slt th3 src

The column may not have a default value of CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP, or an expression in parentheses.

th3/req1/altertable01.test:169

/* IMP: R-37287-38238 */
# EVIDENCE-OF: R-37287-38238 The column may not have a default value of
# CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP, or an expression in
# parentheses.

R-29868-13536-10966-03336-45139-07308-57583-25685 tcl slt th3 src

If a NOT NULL constraint is specified, then the column must have a default value other than NULL.

th3/req1/altertable01.test:187

/* IMP: R-29868-13536 */
# EVIDENCE-OF: R-29868-13536 If a NOT NULL constraint is specified, then
# the column must have a default value other than NULL.

R-13876-13274-06329-28290-52708-34927-05709-26395 tcl slt th3 src

If foreign key constraints are enabled and a column with a REFERENCES clause is added, the column must have a default value of NULL.

th3/req1/altertable01.test:197

/* IMP: R-13876-13274 */
# EVIDENCE-OF: R-13876-13274 If foreign key constraints are enabled and
# a column with a REFERENCES clause is added, the column must have a
# default value of NULL.

R-64634-29359-61184-64182-15828-53059-45249-47923 tcl slt th3 src

Note also that when adding a CHECK constraint, the CHECK constraint is not tested against preexisting rows of the table.

th3/req1/altertable01.test:212

/* IMP: R-64634-29359 */
# EVIDENCE-OF: R-64634-29359 Note also that when adding a CHECK
# constraint, the CHECK constraint is not tested against preexisting
# rows of the table.

R-41438-41245-47933-47570-18885-03208-62677-50789 tcl slt th3 src

This can result in a table that contains data that is in violation of the CHECK constraint.

th3/req1/altertable01.test:216

/* IMP: R-41438-41245 */
# EVIDENCE-OF: R-41438-41245 This can result in a table that contains
# data that is in violation of the CHECK constraint.