/ Timeline

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

12 check-ins using file www/changes.tcl version 31a8fec4

Partial fix for a problem with LEFT OUTER JOIN. It used to be that the test for the right-hand table not matching the left table occurred after all ON, USING, WHERE clause processing. The test should occur after ON and USING clauses are checked but before the WHERE clause is check. This fix works as long as the total number of "AND" separated terms in the ON, USING, and WHERE clause does not exceed 32. To do: make this work for any number of terms and add test cases. that (CVS 639) (check-in: 8b6574cf user: drh tags: trunk)
Fix a VDBE stack leak in LEFT OUTER JOIN. Fix a bug in the code generator for JOIN ... USING(...). (CVS 638) (check-in: d861489e user: drh tags: trunk)
An optimization: avoid the use of an intermediate table on UNION ALL if there is no ORDER BY clause. (CVS 637) (check-in: 8aa73ce6 user: drh tags: trunk)
Fix for bugs #77 and #80: Rework the LIMIT mechanism to be reentrant and to clean up the VDBE stack properly. (CVS 636) (check-in: 9d552310 user: drh tags: trunk)
Fix for ticket #76: Fix a database corruption that might occur when dropping tables or indices. (CVS 635) (check-in: 7936b032 user: drh tags: trunk)
Fix for ticket #78: Avoid an assertion failure when sqlite_close() to be called in the middle of a transaction. (CVS 634) (check-in: 2532792a user: drh tags: trunk)
Update the file-format change document to describes the changes between versions 2.4.12 and 2.5.0. (CVS 633) (check-in: d28a2ecc user: drh tags: trunk)
This patch contains the beginnings of the data-typing infrastructure. The new build-in TypeOf() function is added. New opcodes for doing pure text comparisons are added. Most changes are disabled pending the 2.6.0 release. (CVS 632) (check-in: cbbc858d user: drh tags: trunk)
Fix for ticket #73: The ORDER BY clause is significant for subqueries. This passes all regression tests, but more testing is needed to exercise all paths through the new code. (CVS 631) (check-in: 43c5aff5 user: drh tags: trunk)
Fix for ticket #75: Autoincrement INTEGER PRIMARY KEY fields on an INSERT even if the data is coming from a SELECT statement. (CVS 630) (check-in: d599f75b user: drh tags: trunk)
Version 2.5.1 (CVS 629) (check-in: 5e8a3131 user: drh tags: trunk)
The query optimizer now attempts to satisfy an ORDER BY clause using an index. Sorting is still used if there are no suitable indices. (CVS 628) (check-in: f09e19b4 user: drh tags: trunk)