Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update the change history and news. And make some minor fixes to requirements text. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
9778992724e997f1b41749c7ddb81d43 |
User & Date: | drh 2012-05-11 17:01:08.175 |
Context
2012-05-12
| ||
01:50 | Fix a typo in the file format documentation. (check-in: c1bf8efee7 user: drh tags: trunk) | |
2012-05-11
| ||
17:01 | Update the change history and news. And make some minor fixes to requirements text. (check-in: 9778992724 user: drh tags: trunk) | |
2012-04-20
| ||
12:52 | Many small updates and tweaks to the site in an effort to keep all information current. (check-in: d433035324 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
38 39 40 41 42 43 44 | http://www.sqlite.org/src/timeline</a>.</p> } hd_close_aux hd_enable_main 1 } } | | > > > > > > > > > > > | 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 | http://www.sqlite.org/src/timeline</a>.</p> } hd_close_aux hd_enable_main 1 } } chng {2012 May 14 (3.7.12)} { <li>Add the [SQLITE_DBSTATUS_CACHE_WRITE] option for [sqlite3_db_status()]. <li>Optimize the [typeof()] and [length()] SQL functions so that they avoid unnecessary reading of database content from disk. <li>Add the [FTS4 "merge" command], the [FTS4 "automerge" command], and the [FTS4 "integrity-check" command]. <li>Report the name of specific [CHECK] constraints that fail. <li>In the command-line shell, use popen() instead of fopen() if the first character of the argument to the ".output" command is "|". <li>Make use of OVERLAPPED in the windows [VFS] to avoid some system calls and thereby obtain a performance improvement. <li>More aggressive optimization of the AND operator when one side or the other is always false. <li>Add the [SQLITE_RTREE_INT_ONLY] compile-time option to force the [rtree | R*Tree Extension Module] to use integer instead of floating point values for both storage and computation. <li>Enhance the [PRAGMA integrity_check] command to use much less memory when processing multi-gigabyte databases. <li>New interfaces added to the test_quota.c add-on module. <li>Added the ".trace" dot-command to the command-line shell. <li>Allow virtual table constructors to be invoked recursively. <li>Improved optimization of ORDER BY clauses on compound queries. <li>Improved optimization of aggregate subqueries contained within an aggregate query. <li>Bug fix: Fix the [RELEASE] command so that it does not cancel pending queries. This repairs a problem introduced in 3.7.11. <li>Bug fix: Do not discard the DISTINCT as superfluous unless a subset of the result set is subject to a UNIQUE constraint <em>and</em> it none of the columns in that subset can be NULL. Ticket [http://www.sqlite.org/src/info/385a5b56b9 | 385a5b56b9]. <li>Bug fix: Do not optimize away an ORDER BY clause that has the same terms as a UNIQUE index unless those terms are also NOT NULL. Ticket [http://www.sqlite.org/src/info/2a5629202f | 2a5629202f]. } chng {2012 March 20 (3.7.11)} { <li>Enhance the [INSERT] syntax to allow multiple rows to be inserted via the VALUES clause. <li>Enhance the [CREATE VIRTUAL TABLE] command to support the |
︙ | ︙ |
Changes to pages/fileformat2.in.
︙ | ︙ | |||
1118 1119 1120 1121 1122 1123 1124 | <p>^There is a single row in the sqlite_sequence table for each ordinary table that uses AUTOINCREMENT. The name of the table (as it appears in sqlite_master.name) is in the sqlite_sequence.main field and the largest [INTEGER PRIMARY KEY] ever used by that table is in the sqlite_sequence.seq field. ^New automatically generated integer primary keys for AUTOINCREMENT tables are guaranteed to be larger than the sqlite_sequence.seq field for that table. | | | | | | 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 | <p>^There is a single row in the sqlite_sequence table for each ordinary table that uses AUTOINCREMENT. The name of the table (as it appears in sqlite_master.name) is in the sqlite_sequence.main field and the largest [INTEGER PRIMARY KEY] ever used by that table is in the sqlite_sequence.seq field. ^New automatically generated integer primary keys for AUTOINCREMENT tables are guaranteed to be larger than the sqlite_sequence.seq field for that table. ^(If the sqlite_sequence.seq field of an AUTOINCREMENT table is already at the largest integer value (9223372036854775807) then attempts to add new rows to that table with an automatically generated integer primary will fail with an [SQLITE_FULL] error.)^ ^The sqlite_sequence.seq field is automatically updated if required when new entries are added to an AUTOINCREMENT table. ^The sqlite_sequence row for an AUTOINCREMENT table is automatically deleted when the table is dropped. ^If the sqlite_sequence row for an AUTOINCREMENT table does not exist when the AUTOINCREMENT table is updated, then a new sqlite_sequence row is created. ^(If the sqlite_sequence.seq value for an AUTOINCREMENT table is manually set to something other than an integer and there is a subsequent attempt to insert the or update the AUTOINCREMENT table, then the behavior is undefined.)^ <p>^Application code is allowed to modify the sqlite_sequence table, to add new rows, to delete rows, or to modify existing rows. ^However, application code cannot create the sqlite_sequence table if it does not already exist. ^Application code can delete all entries from the sqlite_sequence table, but application code cannot drop the sqlite_sequence table. |
︙ | ︙ |
Changes to pages/lang.in.
︙ | ︙ | |||
186 187 188 189 190 191 192 | Section {ANALYZE} analyze ANALYZE BubbleDiagram analyze-stmt 1 </tcl> <p> ^The ANALYZE command gathers statistics about tables and indices and stores the collected information | | | | 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 | Section {ANALYZE} analyze ANALYZE BubbleDiagram analyze-stmt 1 </tcl> <p> ^The ANALYZE command gathers statistics about tables and indices and stores the collected information in [internal tables] of the database where the query optimizer can access the information and use it to help make better query planning choices. ^If no arguments are given, all attached databases are analyzed. ^If a database name is given as the argument, then all tables and indices in that one database are analyzed. ^If the argument is a table name, then only that table and the indices associated with that table are analyzed. ^If the argument is an index name, then only that one index is analyzed.</p> |
︙ | ︙ |
Changes to pages/news.in.
︙ | ︙ | |||
14 15 16 17 18 19 20 21 22 23 24 25 26 27 | hd_puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt regsub -all {[Tt]icket #(\d+)} $txt \ {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt hd_resolve "<blockquote>$txt</blockquote>" hd_puts "<hr width=\"50%\">" } newsitem {2012-March-20} {Version 3.7.11} { SQLite [version 3.7.11] is a regularly scheduled maintenance release which was rushed out early due to a [http://www.sqlite.org/src/info/b7c8682cc1 | bug in the query optimizer] introduced in the previous release. The bug is obscure - it changes a LEFT JOIN into an INNER JOIN in some cases when there is a 3-way join | > > > > > > | 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | hd_puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt regsub -all {[Tt]icket #(\d+)} $txt \ {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt hd_resolve "<blockquote>$txt</blockquote>" hd_puts "<hr width=\"50%\">" } newsitem {2012-May-14} {Version 3.7.12} { SQLite [version 3.7.12] is a regularly scheduled maintenance release. This release contains several new optimizations and bug fixes and upgrading is recommended. See the [version 3.7.12 | change summary] for details. } newsitem {2012-March-20} {Version 3.7.11} { SQLite [version 3.7.11] is a regularly scheduled maintenance release which was rushed out early due to a [http://www.sqlite.org/src/info/b7c8682cc1 | bug in the query optimizer] introduced in the previous release. The bug is obscure - it changes a LEFT JOIN into an INNER JOIN in some cases when there is a 3-way join |
︙ | ︙ |