Documentation Source Text

Check-in [d585c58e71]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update the change log and the pragma documentation to reflect restoring PRAGMA index_list to its old behavior.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d585c58e71b23bb31275505e53b2f28fc6fc7c66
User & Date: drh 2013-10-12 20:43:54.566
Context
2013-10-14
13:15
Tweaks to the change log. Set an estimated release date for 3.8.1 of 2013-10-18. (check-in: c00394dd14 user: drh tags: trunk)
2013-10-12
20:43
Update the change log and the pragma documentation to reflect restoring PRAGMA index_list to its old behavior. (check-in: d585c58e71 user: drh tags: trunk)
13:10
Fix the PRAGMA defer_foreign_keys documentation to explain that deferral is disabled whenever a transaction completes. (check-in: 651b3720a7 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
<li>Take into account WHERE clause terms that cannot be used with indices.
<li>Estimate the sizes of table and index rows and use the smallest applicable B-Tree
    for full scans and "count(*)" operations.
</ul>
<li>Added support for [SQLITE_ENABLE_STAT4]
<li>Added support for "sz=NNN" parameters at the end of sqlite_stat1.stat fields
    used to specify the average length in bytes for table and index rows.
<li>Changed the [index_list pragma] so that it shows the estimated size of index
    rows and so that it shows a new row for the PRIMARY KEY index that gives the
    estimated size of table rows.
<li>Avoid running foreign-key constraint checks on an UPDATE if none of the
    modified columns are associated with foreign keys.
<li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option
<li>Added the win32-longpath VFS on windows.
<li>The [Date And Time Functions] are enhanced so that the current time
    (ex: julianday('now')) is always the same for multiple function invocations
    within the same [sqlite3_step()] call.







<
<
<







27
28
29
30
31
32
33



34
35
36
37
38
39
40
<li>Take into account WHERE clause terms that cannot be used with indices.
<li>Estimate the sizes of table and index rows and use the smallest applicable B-Tree
    for full scans and "count(*)" operations.
</ul>
<li>Added support for [SQLITE_ENABLE_STAT4]
<li>Added support for "sz=NNN" parameters at the end of sqlite_stat1.stat fields
    used to specify the average length in bytes for table and index rows.



<li>Avoid running foreign-key constraint checks on an UPDATE if none of the
    modified columns are associated with foreign keys.
<li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option
<li>Added the win32-longpath VFS on windows.
<li>The [Date And Time Functions] are enhanced so that the current time
    (ex: julianday('now')) is always the same for multiple function invocations
    within the same [sqlite3_step()] call.
Changes to pages/pragma.in.
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129










1130
1131
1132
1133
1134
1135
1136
    table. ^The third column of output is the name of the column being indexed.
    </p>
}

Pragma index_list {
    <p>^(<b>PRAGMA index_list(</b><i>table-name</i><b>);</b></p>
    <p>This pragma returns one row for each index associated with the
    given table.)^   ^The original table with its rowid key is considered
    an index with a NULL name for the purposes of this pragma.
    ^Columns of the result set include the
    index name, a flag to indicate whether or not the index is UNIQUE, and
    an estimate of the number of bytes in each row of the index.
    </p>
}











Pragma page_count {
    <p>^(<b>PRAGMA page_count;</b></p>
    <p>Return the total number of pages in the database file.</p>)^
}

Pragma table_info {







|
<

|
<


>
>
>
>
>
>
>
>
>
>







1116
1117
1118
1119
1120
1121
1122
1123

1124
1125

1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
    table. ^The third column of output is the name of the column being indexed.
    </p>
}

Pragma index_list {
    <p>^(<b>PRAGMA index_list(</b><i>table-name</i><b>);</b></p>
    <p>This pragma returns one row for each index associated with the
    given table.)^

    ^Columns of the result set include the
    index name and a flag to indicate whether or not the index is UNIQUE.

    </p>
}

Pragma stats {
    <p>^(<b>PRAGMA stats;</b>)^ </p>
    <p>This pragma returns auxiliary information about tables and
    indices.  The returned information is used during testing to help
    verify that the query planner is operating correctly.  The format
    and meaning of this pragma will likely change from one point release
    to the next. Because of its volatility, applications should avoid
    using this pragma.</p>
}

Pragma page_count {
    <p>^(<b>PRAGMA page_count;</b></p>
    <p>Return the total number of pages in the database file.</p>)^
}

Pragma table_info {