Documentation Source Text
Check-in [b7385b0ef3]
Not logged in

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

Overview
SHA1 Hash:b7385b0ef34cdcba31a88588c72f59665f14ad65
Date: 2013-03-09 15:02:12
User: drh
Comment:Update change log and index for the 3-way join/affinity bug.
Tags And Properties
Changes
hide diffs unified diffs patch

Changes to pages/changes.in

70 <li>Improved error messages for invalid boolean arguments to dot-commands 70 <li>Improved error messages for invalid boolean arguments to dot-commands 71 in the [command-line shell]. 71 in the [command-line shell]. 72 <li>Improved error messages for "foreign key mismatch" showing the names of 72 <li>Improved error messages for "foreign key mismatch" showing the names of 73 the two tables involved. 73 the two tables involved. 74 <li>Remove all uses of umask() in the unix VFS. 74 <li>Remove all uses of umask() in the unix VFS. 75 <li>Added the [PRAGMA vdbe_addoptrace] and [PRAGMA vdbe_debug] commands. 75 <li>Added the [PRAGMA vdbe_addoptrace] and [PRAGMA vdbe_debug] commands. 76 76 > 77 <li>Bug fix: repair a long-standing problem that could cause incorrect query > 78 results in a 3-way or larger join that compared INTEGER fields against TEXT > 79 fields in two or more places. > 80 Ticket [http://www.sqlite.org/src/info/fc7bd6358f | fc7bd6358f] 77 <li>Bug fix: Issue an error message if the 16-bit reference counter on a 81 <li>Bug fix: Issue an error message if the 16-bit reference counter on a 78 view overflows due to an overly complex query. 82 view overflows due to an overly complex query. 79 <li>Bug fix: Avoid leaking memory on LIMIT and OFFSET clauses in deeply 83 <li>Bug fix: Avoid leaking memory on LIMIT and OFFSET clauses in deeply 80 nested UNION ALL queries. 84 nested UNION ALL queries. 81 <li>Bug fix: Make sure the schema is up-to-date prior to running pragmas 85 <li>Bug fix: Make sure the schema is up-to-date prior to running pragmas 82 table_info, index_list, index_info, and foreign_key_list. 86 table_info, index_list, index_info, and foreign_key_list. 83 } 87 }

Changes to pages/index.in

93 <td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td> 93 <td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td> 94 <td valign="top"> 94 <td valign="top"> 95 <h3>Current Status</h3> 95 <h3>Current Status</h3> 96 96 97 <p><ul> 97 <p><ul> 98 <li><a href="releaselog/3_7_16.html">Version 3.7.16</a> 98 <li><a href="releaselog/3_7_16.html">Version 3.7.16</a> 99 of SQLite is recommended for all new development. 99 of SQLite is recommended for all new development. 100 Upgrading from version 3.7.15.2 is optional. < 101 Upgrading from all other SQLite versions 100 Upgrading from all other SQLite versions 102 is recommended.</li> 101 is recommended.</li> 103 </ul></p> 102 </ul></p> 104 103 105 <h3>Common Links</h3> 104 <h3>Common Links</h3> 106 105 107 <p><ul> 106 <p><ul>