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.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d585c58e71b23bb31275505e53b2f28fc6fc7c66
User & Date: drh 2013-10-12 20:43:54
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    27     27   <li>Take into account WHERE clause terms that cannot be used with indices.
    28     28   <li>Estimate the sizes of table and index rows and use the smallest applicable B-Tree
    29     29       for full scans and "count(*)" operations.
    30     30   </ul>
    31     31   <li>Added support for [SQLITE_ENABLE_STAT4]
    32     32   <li>Added support for "sz=NNN" parameters at the end of sqlite_stat1.stat fields
    33     33       used to specify the average length in bytes for table and index rows.
    34         -<li>Changed the [index_list pragma] so that it shows the estimated size of index
    35         -    rows and so that it shows a new row for the PRIMARY KEY index that gives the
    36         -    estimated size of table rows.
    37     34   <li>Avoid running foreign-key constraint checks on an UPDATE if none of the
    38     35       modified columns are associated with foreign keys.
    39     36   <li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option
    40     37   <li>Added the win32-longpath VFS on windows.
    41     38   <li>The [Date And Time Functions] are enhanced so that the current time
    42     39       (ex: julianday('now')) is always the same for multiple function invocations
    43     40       within the same [sqlite3_step()] call.

Changes to pages/pragma.in.

  1116   1116       table. ^The third column of output is the name of the column being indexed.
  1117   1117       </p>
  1118   1118   }
  1119   1119   
  1120   1120   Pragma index_list {
  1121   1121       <p>^(<b>PRAGMA index_list(</b><i>table-name</i><b>);</b></p>
  1122   1122       <p>This pragma returns one row for each index associated with the
  1123         -    given table.)^   ^The original table with its rowid key is considered
  1124         -    an index with a NULL name for the purposes of this pragma.
         1123  +    given table.)^
  1125   1124       ^Columns of the result set include the
  1126         -    index name, a flag to indicate whether or not the index is UNIQUE, and
  1127         -    an estimate of the number of bytes in each row of the index.
         1125  +    index name and a flag to indicate whether or not the index is UNIQUE.
  1128   1126       </p>
  1129   1127   }
         1128  +
         1129  +Pragma stats {
         1130  +    <p>^(<b>PRAGMA stats;</b>)^ </p>
         1131  +    <p>This pragma returns auxiliary information about tables and
         1132  +    indices.  The returned information is used during testing to help
         1133  +    verify that the query planner is operating correctly.  The format
         1134  +    and meaning of this pragma will likely change from one point release
         1135  +    to the next. Because of its volatility, applications should avoid
         1136  +    using this pragma.</p>
         1137  +}
  1130   1138   
  1131   1139   Pragma page_count {
  1132   1140       <p>^(<b>PRAGMA page_count;</b></p>
  1133   1141       <p>Return the total number of pages in the database file.</p>)^
  1134   1142   }
  1135   1143   
  1136   1144   Pragma table_info {