use an index for sorting. It has to sort as a separate operation after
the GROUP BY is complete. (CVS 702)
FossilOrigin-Name: 18745c67acdf7ebec378f5538174117970e9f5cc
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)
FossilOrigin-Name: bdbdb866f2e76abd1f8f545adadc9a900ed0cd1a
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)
FossilOrigin-Name: 04973fc2a6a0c93877de7e564618e0e9fcffc06c
a table while the "count_changes" pragma is turned on. Up the version number
to 2.6.1. (CVS 690)
FossilOrigin-Name: 612df004017b241651074ee859096dd0ee5062b8
tests for automatic upgrade and for failing if reading a more advanced version
of the database. Ticket #107. (CVS 682)
FossilOrigin-Name: 0493e39c1cbbe4a38e990a2370181a79606af222
to fail when using an index on a column containing an empty string. This
fix is an incompatible file-format change. (CVS 681)
FossilOrigin-Name: 20d152fcddb4fa53556a9c93c7a869600a7c5183
indexed tables when there is a subquery in the WHERE clause. Add tests
to verify correct operation. (CVS 680)
FossilOrigin-Name: bbca16f88d00cd33ac7229edf3ee4623eff6e62f
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)
FossilOrigin-Name: b98727246d5fcc1b097b577be498a77e954c5dc4
as it appears in the CREATE TABLE statement, if available. Also: removed
the ".reindex" command from the shell. (CVS 669)
FossilOrigin-Name: ff8b6f4ee8099a7170cb786b8ead9a3e42ab5869
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)
FossilOrigin-Name: fd7e41f0eed80fb1c7e18eb84834ec3cea74a649
can cause database corruption after a ROLLBACK. Also add new tests to make
sure everything is working this time. (CVS 663)
FossilOrigin-Name: f6e24d5ccbcfcf5863ffbd65860dafa2f5663e99
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)
FossilOrigin-Name: 85793a4f03250166c21007cab3525709592d0866
of the "sqlite*" pointer that sqlite_open() returns. It used to do this
only when compiled with the SQLITE_TEST macro defined. (CVS 648)
FossilOrigin-Name: 9ca6368525fe81fe9c78c6911f4d23009ce858d5
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)
FossilOrigin-Name: 36fc0add660f9f3676783765d37280aa874caecb
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)
FossilOrigin-Name: 8b6574cfa86daaae910f8f3ee3c4723a21fb9e53