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: |
d585c58e71b23bb31275505e53b2f28f |
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
Changes to pages/changes.in.
︙ | ︙ | |||
27 28 29 30 31 32 33 | <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. | < < < | 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 | 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 | | < | < > > > > > > > > > > | 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 { |
︙ | ︙ |