*** DRAFT ***

SQLite Requirement Matrix Details
table_column_metadata.html

Index Summary Markup Original


R-60317-50382-07246-28388-21909-63634-29963-03313 tcl slt th3 src

The sqlite3_table_column_metadata(X,D,T,C,....) routine returns information about column C of table T in database D on database connection X.

th3/cov1/metadata01.test:41

/* IMP: R-60317-50382 */
# EVIDENCE-OF: R-60317-50382 The
# sqlite3_table_column_metadata(X,D,T,C,....) routine returns
# information about column C of table T in database D on database
# connection X.

R-37760-36374-21935-46380-43039-31326-26713-65030 tcl slt th3 src

The sqlite3_table_column_metadata() interface returns SQLITE_OK and fills in the non-NULL pointers in the final five arguments with appropriate values if the specified column exists.

th3/cov1/metadata01.test:46

/* IMP: R-37760-36374 */
# EVIDENCE-OF: R-37760-36374 The sqlite3_table_column_metadata()
# interface returns SQLITE_OK and fills in the non-NULL pointers in the
# final five arguments with appropriate values if the specified column
# exists.

R-14849-03112-38963-62729-29148-05524-00081-49320 tcl slt th3 src

The sqlite3_table_column_metadata() interface returns SQLITE_ERROR and if the specified column does not exist.

th3/cov1/metadata01.test:222

/* IMP: R-14849-03112 */
# EVIDENCE-OF: R-14849-03112 The sqlite3_table_column_metadata()
# interface returns SQLITE_ERROR and if the specified column does not
# exist.

R-63822-07193-39399-57145-23201-47133-55148-33056 tcl slt th3 src

If the column-name parameter to sqlite3_table_column_metadata() is a NULL pointer, then this routine simply checks for the existence of the table and returns SQLITE_OK if the table exists and SQLITE_ERROR if it does not.

th3/cov1/metadata01.test:239

/* IMP: R-63822-07193 */
# EVIDENCE-OF: R-63822-07193 If the column-name parameter to
# sqlite3_table_column_metadata() is a NULL pointer, then this routine
# simply checks for the existence of the table and returns SQLITE_OK if
# the table exists and SQLITE_ERROR if it does not.

R-47355-18032-54463-52994-47328-64569-52603-29032 tcl slt th3 src

The column is identified by the second, third and fourth parameters to this function.

th3/cov1/metadata01.test:51

/* IMP: R-47355-18032 */
# EVIDENCE-OF: R-47355-18032 The column is identified by the second,
# third and fourth parameters to this function.

R-23149-10450-31226-11876-31056-64303-42616-45384 tcl slt th3 src

The second parameter is either the name of the database (i.e. "main", "temp", or an attached database) containing the specified table or NULL.

th3/cov1/metadata01.test:70

/* IMP: R-23149-10450 */
# EVIDENCE-OF: R-23149-10450 The second parameter is either the name of
# the database (i.e. "main", "temp", or an attached database) containing
# the specified table or NULL.

R-15618-12639-40629-36536-35814-47765-39575-62705 tcl slt th3 src

If it is NULL, then all attached databases are searched for the table using the same algorithm used by the database engine to resolve unqualified table references.

th3/cov1/metadata01.test:74

/* IMP: R-15618-12639 */
# EVIDENCE-OF: R-15618-12639 If it is NULL, then all attached databases
# are searched for the table using the same algorithm used by the
# database engine to resolve unqualified table references.

R-27192-61982-03758-21332-41239-32834-09507-36997 tcl slt th3 src

The third and fourth parameters to this function are the table and column name of the desired column, respectively.

th3/cov1/metadata01.test:54

/* IMP: R-27192-61982 */
# EVIDENCE-OF: R-27192-61982 The third and fourth parameters to this
# function are the table and column name of the desired column,
# respectively.

R-20784-11852-57325-61888-34040-48421-29147-36386 tcl slt th3 src

Metadata is returned by writing to the memory locations passed as the 5th and subsequent parameters to this function.

th3/cov1/metadata01.test:58

/* IMP: R-20784-11852 */
# EVIDENCE-OF: R-20784-11852 Metadata is returned by writing to the
# memory locations passed as the 5th and subsequent parameters to this
# function.

R-07046-65439-53781-18565-05582-11236-16234-65526 tcl slt th3 src

Any of these arguments may be NULL, in which case the corresponding element of metadata is omitted.

th3/cov1/metadata01.test:67

/* IMP: R-07046-65439 */
# EVIDENCE-OF: R-07046-65439 Any of these arguments may be NULL, in
# which case the corresponding element of metadata is omitted.

R-17527-22739-13874-05126-20619-29164-21106-56855 tcl slt th3 src

Parameter Output
Type
Description

5th const char* Data type
6th const char* Name of default collation sequence
7th int True if column has a NOT NULL constraint
8th int True if column is part of the PRIMARY KEY
9th int True if column is AUTOINCREMENT

th3/cov1/metadata01.test:62

/* IMP: R-17527-22739 */
# EVIDENCE-OF: R-17527-22739 Parameter OutputType Description 5th const
# char* Data type 6th const char* Name of default collation sequence 7th
# int True if column has a NOT NULL constraint 8th int True if column is
# part of the PRIMARY KEY 9th int True if column is AUTOINCREMENT

R-18978-08031-62088-38924-17278-52934-19628-35993 tcl slt th3 src

The memory pointed to by the character pointers returned for the declaration type and collation sequence is valid until the next call to any SQLite API function.

th3/cov1/metadata01.test:78

/* IMP: R-18978-08031 */
# EVIDENCE-OF: R-18978-08031 The memory pointed to by the character
# pointers returned for the declaration type and collation sequence is
# valid until the next call to any SQLite API function.

R-16748-44311-29408-30496-47489-38562-34902-17551 tcl slt th3 src

If the specified table is actually a view, an error code is returned.

th3/cov1/metadata01.test:329

/* IMP: R-16748-44311 */
# EVIDENCE-OF: R-16748-44311 If the specified table is actually a view,
# an error code is returned.

R-16368-45976-00872-58854-24152-50721-64128-13057 tcl slt th3 src

If the specified column is "rowid", "oid" or "_rowid_" and the table is not a WITHOUT ROWID table and an INTEGER PRIMARY KEY column has been explicitly declared, then the output parameters are set for the explicitly declared column.

th3/cov1/metadata01.test:257

/* IMP: R-16368-45976 */
# EVIDENCE-OF: R-16368-45976 If the specified column is "rowid", "oid"
# or "_rowid_" and the table is not a WITHOUT ROWID table and an INTEGER
# PRIMARY KEY column has been explicitly declared, then the output
# parameters are set for the explicitly declared column.

R-43309-20049-45767-17244-13943-35472-42649-06268 tcl slt th3 src

If there is no INTEGER PRIMARY KEY column, then the outputs for the rowid are set as follows:

data type: "INTEGER"
collation sequence: "BINARY"
not null: 0
primary key: 1
auto increment: 0

th3/cov1/metadata01.test:296

/* IMP: R-43309-20049 */
# EVIDENCE-OF: R-43309-20049 If there is no INTEGER PRIMARY KEY column,
# then the outputs for the rowid are set as follows: data type:
# "INTEGER" collation sequence: "BINARY" not null: 0 primary key: 1 auto
# increment: 0

R-20796-14963-19630-14669-08622-46367-39917-03067 tcl slt th3 src

This function causes all database schemas to be read from disk and parsed, if that has not already been done, and returns an error if any errors are encountered while loading the schema.

th3/cov1/metadata01.test:344

/* IMP: R-20796-14963 */
# EVIDENCE-OF: R-20796-14963 This function causes all database schemas
# to be read from disk and parsed, if that has not already been done,
# and returns an error if any errors are encountered while loading the
# schema.