Fix for ticket #131: When a SELECT contains a GROUP BY clause it cannot
use an index for sorting. It has to sort as a separate operation after
the GROUP BY is complete. (CVS 702)
check-in: 18745c67 user: drh tags: trunk

Remove the restriction that a transaction cannot be started by one linuxthread
and continued by another. Leave in the documentation the warning about not
carrying a database connection across fork() but do not test for it any more.
Ticket #130. (CVS 701)
check-in: bdbdb866 user: drh tags: trunk

Fix for ticket #104: Make triggers on views work properly even after closing
and reopening the database. Also fixed an unrelated bug in the version
2.6.0 database format upgrade logic. The upgrade logic bug was found while
testing the trigger fixes. (CVS 697)
check-in: 04973fc2 user: drh tags: trunk

Fix for ticket #111: Update the documentation to explain that you may not
start a transaction in one thread and complete it in another thread under
Linux Threads where each thread has its own process ID. (CVS 695)
check-in: 0b0c0492 user: drh tags: trunk

Fix an assertion failure that occurs when attempting to delete all rows of
a table while the "count_changes" pragma is turned on. Up the version number
to 2.6.1. (CVS 690)
check-in: 612df004 user: drh tags: trunk

Make the automatic database upgrade work even if there are triggers. Add
tests for automatic upgrade and for failing if reading a more advanced version
of the database. Ticket #107. (CVS 682)
check-in: 0493e39c user: drh tags: trunk

Fix for ticket #107: Fix a design defect in indices that was causing queries
to fail when using an index on a column containing an empty string. This
fix is an incompatible file-format change. (CVS 681)
check-in: 20d152fc user: drh tags: trunk

Fix for ticket #105: Fix the UPDATE command so that it works properly with
indexed tables when there is a subquery in the WHERE clause. Add tests
to verify correct operation. (CVS 680)
check-in: bbca16f8 user: drh tags: trunk

Partial fix for ticket #96: Return SQLITE_MISUSE from sqlite_exec() if called
from a child process with an active transaction that was started in the parent. (CVS 675)
check-in: 72a609ec user: drh tags: trunk

Turn of the reporting of datatypes in the 4th callback argument unless the
SHOW_DATATYPES pragma is ON. Eliminate the NULL pointer that used to separate
the beginning of datatypes from the end of column names so that the callback
can test to see whether or not datatypes are provided. This is an
incompatible changes, but since the prior behavior was never documented, we
will let it in. (CVS 670)
check-in: b9872724 user: drh tags: trunk

When reporting back the datatype of columns, use the text of the datatype
as it appears in the CREATE TABLE statement, if available. Also: removed
the ".reindex" command from the shell. (CVS 669)
check-in: ff8b6f4e user: drh tags: trunk

In the BTree subsystem, when using pages from the freelist, attempt to select
pages close to related pages in order to keep data structures near each other
in the database file. This improves access speed in some circumstances. (CVS 667)
check-in: fd7e41f0 user: drh tags: trunk

More rollback problems: Fix two more errors introduced by checking (410) that
can cause database corruption after a ROLLBACK. Also add new tests to make
sure everything is working this time. (CVS 663)
check-in: f6e24d5c user: drh tags: trunk

Fix for ticket #92: Correct the sqliteExprCompare() function so that is takes
into account the iTable and iColumn fields of the Expr structure. Otherwise,
"min(a)" and "min(b)" will compare equal to each other in views. (CVS 658)
check-in: 85793a4f user: drh tags: trunk

Fix for ticket #84: If the WHERE clause is too complex, issue an error message
and refuse to do the SELECT. The cutoff is a WHERE clause with 100 terms. (CVS 650)
check-in: c07e493b user: drh tags: trunk

In the TCL interface, the "sqlite" command now always returns the address
of the "sqlite*" pointer that sqlite_open() returns. It used to do this
only when compiled with the SQLITE_TEST macro defined. (CVS 648)
check-in: 9ca63685 user: drh tags: trunk

Bug fix: When the database file grows in size during a transaction, make sure
the last page of the file gets written to disk even if that page is on the
free list and contains no data. Otherwise the disk file will be too small
which can lead to database corruption in subsequent transactions. (CVS 643)
check-in: 36fc0add user: drh tags: trunk

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 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

Add preliminary logic for the eventual move to having separate TEXT and
NUMTEXT datatypes. Also change the version number to 2.5.0 in preparation
for an interim release. (CVS 625)
check-in: 05783a9d user: drh tags: trunk