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
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)
FossilOrigin-Name: cbbc858d973c2d515c6a2464981316549a241b73
This passes all regression tests, but more testing is needed to exercise
all paths through the new code. (CVS 631)
FossilOrigin-Name: 43c5aff5d078bce9292683cd40311e0dcc81ac14
NUMTEXT datatypes. Also change the version number to 2.5.0 in preparation
for an interim release. (CVS 625)
FossilOrigin-Name: 05783a9db585c1ead42135252dca97d2bc6e2118
Command template now is cmd FORMAT INT INT ?STRING?. When
STRING omitted a NULL is passed to sqlite_mprintf. (CVS 620)
FossilOrigin-Name: 8bc711571d752a81957007be22ed8a3c6877f676