*** DRAFT ***

SQLite Requirement Matrix Details
lang_createview.html

Index Summary Markup Original


R-61683-37731-34297-11836-20464-19187-38876-35885 tcl slt th3 src

Canonical usage: syntax/create-view-stmt.html

/* IMP: R-61683-37731 */
# EVIDENCE-OF: R-61683-37731 -- syntax diagram create-view-stmt

R-61628-17125-33025-56567-55142-03215-04610-55795 tcl slt th3 src

Canonical usage: syntax/select-stmt.html

/* IMP: R-61628-17125 */
# EVIDENCE-OF: R-61628-17125 -- syntax diagram select-stmt

R-47013-63517-59451-29791-27627-32329-00299-29666 tcl slt th3 src

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

/* IMP: R-47013-63517 */
# EVIDENCE-OF: R-47013-63517 -- syntax diagram common-table-expression

R-21508-23055-03544-43069-03700-52529-28655-04212 tcl slt th3 src

Canonical usage: syntax/compound-operator.html

/* IMP: R-21508-23055 */
# EVIDENCE-OF: R-21508-23055 -- syntax diagram compound-operator

R-63282-43996-47481-25333-53243-51474-00238-17595 tcl slt th3 src

Canonical usage: syntax/expr.html

/* IMP: R-63282-43996 */
# EVIDENCE-OF: R-63282-43996 -- syntax diagram expr

R-10696-30084-53665-51146-23084-19397-22440-65131 tcl slt th3 src

Canonical usage: syntax/filter.html

/* IMP: R-10696-30084 */
# EVIDENCE-OF: R-10696-30084 -- syntax diagram filter

R-31509-35291-02084-41894-63319-63663-58586-07091 tcl slt th3 src

Canonical usage: syntax/literal-value.html

/* IMP: R-31509-35291 */
# EVIDENCE-OF: R-31509-35291 -- syntax diagram literal-value

R-60581-03341-52039-04890-58008-25772-53660-37704 tcl slt th3 src

Canonical usage: syntax/raise-function.html

/* IMP: R-60581-03341 */
# EVIDENCE-OF: R-60581-03341 -- syntax diagram raise-function

R-31272-00274-62255-43298-23904-43777-05391-16185 tcl slt th3 src

Canonical usage: syntax/type-name.html

/* IMP: R-31272-00274 */
# EVIDENCE-OF: R-31272-00274 -- syntax diagram type-name

R-10061-51853-18488-63481-25877-45384-53744-51666 tcl slt th3 src

Canonical usage: syntax/signed-number.html

/* IMP: R-10061-51853 */
# EVIDENCE-OF: R-10061-51853 -- syntax diagram signed-number

R-23545-53633-60682-12631-15952-36070-08340-26441 tcl slt th3 src

Canonical usage: syntax/join-clause.html

/* IMP: R-23545-53633 */
# EVIDENCE-OF: R-23545-53633 -- syntax diagram join-clause

R-46541-20938-58372-53058-01043-12045-25030-53791 tcl slt th3 src

Canonical usage: syntax/join-constraint.html

/* IMP: R-46541-20938 */
# EVIDENCE-OF: R-46541-20938 -- syntax diagram join-constraint

R-27408-41206-06272-65057-49531-23299-28505-37113 tcl slt th3 src

Canonical usage: syntax/join-operator.html

/* IMP: R-27408-41206 */
# EVIDENCE-OF: R-27408-41206 -- syntax diagram join-operator

R-16212-04751-50585-08411-35285-00447-20753-02198 tcl slt th3 src

Canonical usage: syntax/ordering-term.html

/* IMP: R-16212-04751 */
# EVIDENCE-OF: R-16212-04751 -- syntax diagram ordering-term

R-62030-13484-53274-47431-56373-62021-33007-11272 tcl slt th3 src

Canonical usage: syntax/result-column.html

/* IMP: R-62030-13484 */
# EVIDENCE-OF: R-62030-13484 -- syntax diagram result-column

R-28724-59332-25400-14786-42579-47587-28356-56547 tcl slt th3 src

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

/* IMP: R-28724-59332 */
# EVIDENCE-OF: R-28724-59332 -- syntax diagram table-or-subquery

R-27989-13151-39943-32082-13046-13205-21280-24214 tcl slt th3 src

Canonical usage: syntax/window-defn.html

/* IMP: R-27989-13151 */
# EVIDENCE-OF: R-27989-13151 -- syntax diagram window-defn

R-16609-30688-17519-40340-07426-24422-28783-40081 tcl slt th3 src

Canonical usage: syntax/frame-spec.html

/* IMP: R-16609-30688 */
# EVIDENCE-OF: R-16609-30688 -- syntax diagram frame-spec

R-13439-14752-32196-09382-64767-42844-00603-31803 tcl slt th3 src

The CREATE VIEW command assigns a name to a pre-packaged SELECT statement.

th3/req1/view01.test:11

/* IMP: R-13439-14752 */
# EVIDENCE-OF: R-13439-14752 The CREATE VIEW command assigns a name to a
# pre-packaged SELECT statement.

R-63075-15970-39501-22460-58793-43455-08281-02350 tcl slt th3 src

Once the view is created, it can be used in the FROM clause of another SELECT in place of a table name.

th3/req1/view01.test:14

/* IMP: R-63075-15970 */
# EVIDENCE-OF: R-63075-15970 Once the view is created, it can be used in
# the FROM clause of another SELECT in place of a table name.

R-23992-54131-34297-51092-28105-58242-15143-29320 tcl slt th3 src

If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and "VIEW" then the view that is created is only visible to the database connection that created it and is automatically deleted when the database connection is closed.

th3/req1/view01.test:27

/* IMP: R-23992-54131 */
# EVIDENCE-OF: R-23992-54131 If the "TEMP" or "TEMPORARY" keyword occurs
# in between "CREATE" and "VIEW" then the view that is created is only
# visible to the database connection that created it and is
# automatically deleted when the database connection is closed.

R-20124-57769-12967-06011-36499-08186-14693-61176 tcl slt th3 src

If a schema-name is specified, then the view is created in the specified database.

th3/req1/view01.test:46

/* IMP: R-20124-57769 */
# EVIDENCE-OF: R-20124-57769 If a schema-name is specified, then the
# view is created in the specified database.

R-11564-19849-41478-44833-06358-20754-48496-53228 tcl slt th3 src

It is an error to specify both a schema-name and the TEMP keyword on a VIEW, unless the schema-name is "temp".

/* IMP: R-11564-19849 */
# EVIDENCE-OF: R-11564-19849 It is an error to specify both a
# schema-name and the TEMP keyword on a VIEW, unless the schema-name is
# "temp".

R-63159-49573-46616-00271-21180-18293-63861-41327 tcl slt th3 src

If no schema name is specified, and the TEMP keyword is not present, the VIEW is created in the main database.

th3/req1/view01.test:49   th3/req1/view01.test:89

/* IMP: R-63159-49573 */
# EVIDENCE-OF: R-63159-49573 If no schema name is specified, and the
# TEMP keyword is not present, the VIEW is created in the main database.

R-16775-34716-48016-59856-43563-01952-64923-08515 tcl slt th3 src

You cannot DELETE, INSERT, or UPDATE a view.

slt/slt_lang_createview.test:65   th3/req1/view01.test:120

/* IMP: R-16775-34716 */
# EVIDENCE-OF: R-16775-34716 You cannot DELETE, INSERT, or UPDATE a
# view.

R-05363-17893-60997-09697-28202-47991-52787-63067 tcl slt th3 src

Views are read-only in SQLite.

th3/req1/view01.test:118

/* IMP: R-05363-17893 */
# EVIDENCE-OF: R-05363-17893 Views are read-only in SQLite.

R-16876-26469-56495-43773-04643-04870-06914-01150 tcl slt th3 src

However, in many cases you can use an INSTEAD OF trigger on the view to accomplish the same thing.

/* IMP: R-16876-26469 */
# EVIDENCE-OF: R-16876-26469 However, in many cases you can use an
# INSTEAD OF trigger on the view to accomplish the same thing.

R-10484-47921-51855-29245-64644-01052-63397-23881 tcl slt th3 src

Views are removed with the DROP VIEW command.

slt/slt_lang_createview.test:108   th3/req1/view01.test:104

/* IMP: R-10484-47921 */
# EVIDENCE-OF: R-10484-47921 Views are removed with the DROP VIEW
# command.

R-49858-53293-55345-56898-28930-13121-51128-08876 tcl slt th3 src

If a column-name list follows the view-name, then that list determines the names of the columns for the view.

/* IMP: R-49858-53293 */
# EVIDENCE-OF: R-49858-53293 If a column-name list follows the
# view-name, then that list determines the names of the columns for the
# view.

R-36185-29671-26091-33323-34163-48928-21638-35689 tcl slt th3 src

If the column-name list is omitted, then the names of the columns in the view are derived from the names of the result-set columns in the select-stmt.

/* IMP: R-36185-29671 */
# EVIDENCE-OF: R-36185-29671 If the column-name list is omitted, then
# the names of the columns in the view are derived from the names of the
# result-set columns in the select-stmt.