]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
19 years agoRefactoring. Split btreeInt.h off from btree.c. Split malloc.c off from
drh [Sat, 5 May 2007 11:48:52 +0000 (11:48 +0000)] 
Refactoring.  Split btreeInt.h off from btree.c.  Split malloc.c off from
util.c.  Expect much more to follow. (CVS 3926)

FossilOrigin-Name: ad549a40ed3500fb3d552ed19ff791d1280e0b62

19 years agoRefactoring. Split btreeInt.h off from btree.c. Split malloc.c off from
drh [Sat, 5 May 2007 11:48:52 +0000 (11:48 +0000)] 
Refactoring.  Split btreeInt.h off from btree.c.  Split malloc.c off from
util.c.  Expect much more to follow. (CVS 3925)

FossilOrigin-Name: 16041116aaaa2d52a289aa02a24bef579ba60896

19 years agoAdd documentation on the incremental vacuum feature. (CVS 3924)
drh [Fri, 4 May 2007 19:16:30 +0000 (19:16 +0000)] 
Add documentation on the incremental vacuum feature. (CVS 3924)

FossilOrigin-Name: b3e2cdaed3638f033437b5561705cb253449c392

19 years agoFix compilation and testing with OMIT_INCRBLOB defined. (CVS 3923)
danielk1977 [Fri, 4 May 2007 19:03:02 +0000 (19:03 +0000)] 
Fix compilation and testing with OMIT_INCRBLOB defined. (CVS 3923)

FossilOrigin-Name: a0f8adc692839d0645daf0630533a87b0543f6e8

19 years agoTest interaction of incremental io and other database writes. (CVS 3922)
danielk1977 [Fri, 4 May 2007 18:36:44 +0000 (18:36 +0000)] 
Test interaction of incremental io and other database writes. (CVS 3922)

FossilOrigin-Name: 4516416b4d38679ea7d259155f241e54c4c58d7d

19 years agoChange incremental vacuum to be triggered by a pragma rather than a command.
drh [Fri, 4 May 2007 18:30:40 +0000 (18:30 +0000)] 
Change incremental vacuum to be triggered by a pragma rather than a command.
We have a lot to learn about this yet and we do not want to paint ourselves
into a corner by commiting to specific syntax too early. (CVS 3921)

FossilOrigin-Name: b13e497a326697ab42b429993a1eee7df3c0c3eb

19 years agoTighter compression of the keyword hash table. (CVS 3920)
drh [Fri, 4 May 2007 17:07:52 +0000 (17:07 +0000)] 
Tighter compression of the keyword hash table. (CVS 3920)

FossilOrigin-Name: 681216767d7fabfccb0b12f6a81b18b6d1c252bf

19 years agoOptional parameter in the INCREMENTAL VACUUM statement specifies how many
drh [Fri, 4 May 2007 16:14:38 +0000 (16:14 +0000)] 
Optional parameter in the INCREMENTAL VACUUM statement specifies how many
pages to vacuum from the database. (CVS 3919)

FossilOrigin-Name: ed713f9ccb5d0f306a79ab9931e43db2327fb435

19 years agoGet tests working with SQLITE_OMIT_AUTOVACUUM=1. (CVS 3918)
drh [Fri, 4 May 2007 14:36:22 +0000 (14:36 +0000)] 
Get tests working with SQLITE_OMIT_AUTOVACUUM=1. (CVS 3918)

FossilOrigin-Name: b94d39e4d903bc34a9d0bbedd971677abc0ddfc0

19 years agoMake "incremental" a fallback token so that you can set
drh [Fri, 4 May 2007 14:14:45 +0000 (14:14 +0000)] 
Make "incremental" a fallback token so that you can set
"auto_vacuum=incremental"
without having to quote the "incremental". (CVS 3917)

FossilOrigin-Name: 9d7a2e2bb41e7baed2cdcf199cb04d7aef19c010

19 years agoEliminate all uses of sprintf() and strcpy(). These were not being
drh [Fri, 4 May 2007 13:15:55 +0000 (13:15 +0000)] 
Eliminate all uses of sprintf() and strcpy().  These were not being
misused.  But getting rid of them removes a library dependency.  And
it avoids warnings from the OpenBSD compiler.  Ticket #2336. (CVS 3916)

FossilOrigin-Name: ba4845b32bdf38e623c4f7246e6e327715bbba4b

19 years agoTest cases and corrections to IO and malloc() error handling in incremental blob...
danielk1977 [Fri, 4 May 2007 12:05:56 +0000 (12:05 +0000)] 
Test cases and corrections to IO and malloc() error handling in incremental blob IO functions. (CVS 3915)

FossilOrigin-Name: 641e55284e1ba6070073c83ac6ed78ffb29f7e60

19 years agoFix a formatting errror in I/O logging. (CVS 3914)
drh [Fri, 4 May 2007 12:01:02 +0000 (12:01 +0000)] 
Fix a formatting errror in I/O logging. (CVS 3914)

FossilOrigin-Name: 2d37687a08a7b6b3a7f77f55a7c2e29a1f8731a8

19 years agoAdd compile-time option -DSQLITE_MIXED_ENDIAN_64BIT_FLOAT=1 that uses
drh [Fri, 4 May 2007 11:59:31 +0000 (11:59 +0000)] 
Add compile-time option -DSQLITE_MIXED_ENDIAN_64BIT_FLOAT=1 that uses
mixed-endian doubles.  This is needed on ARM7 to make database file
formats compatible with all other processors.  Tickets #2278 and #2335. (CVS 3913)

FossilOrigin-Name: 2a178d0c7950c9d403c0bc43c2043de945fb24e0

19 years agoRework accessPayload() function for clarity. (CVS 3912)
danielk1977 [Fri, 4 May 2007 08:32:13 +0000 (08:32 +0000)] 
Rework accessPayload() function for clarity. (CVS 3912)

FossilOrigin-Name: 42d07c70ec1eb6dd9619c97d753c9d2824aeae32

19 years agofix from Gentoo for allowing TCLLIBDIR to be overridden in env (CVS 3911)
vapier [Thu, 3 May 2007 20:06:11 +0000 (20:06 +0000)] 
fix from Gentoo for allowing TCLLIBDIR to be overridden in env (CVS 3911)

FossilOrigin-Name: e54a49e264ecd54083587f8d3b17cce4c811fddc

19 years agoTest some more incremental IO error cases. (CVS 3910)
danielk1977 [Thu, 3 May 2007 18:14:10 +0000 (18:14 +0000)] 
Test some more incremental IO error cases. (CVS 3910)

FossilOrigin-Name: 64705410bdf43b6283f7a7e59ce8c20d09cd46e4

19 years agoImprovements to I/O tracing output. Require -DSQLITE_ENABLE_IOTRACE when
drh [Thu, 3 May 2007 17:18:36 +0000 (17:18 +0000)] 
Improvements to I/O tracing output.  Require -DSQLITE_ENABLE_IOTRACE when
compiling shell.c in order to link in the I/O tracing capability. (CVS 3909)

FossilOrigin-Name: 8a43e1676fdd29903e0b3f9d3b05d217d42962b8

19 years agoGet the amalgamation builder working with incremental I/O. (CVS 3908)
drh [Thu, 3 May 2007 16:55:32 +0000 (16:55 +0000)] 
Get the amalgamation builder working with incremental I/O. (CVS 3908)

FossilOrigin-Name: 92b53601657be3f1be70873b2960cd97b97f72a1

19 years agoTest cases and minor bugfixes for incremental blob APIs. (CVS 3907)
danielk1977 [Thu, 3 May 2007 16:31:26 +0000 (16:31 +0000)] 
Test cases and minor bugfixes for incremental blob APIs. (CVS 3907)

FossilOrigin-Name: e12c522383bd40af375a52d2e68612c4dc7fd4db

19 years agoFix a bug where accessPayload() was calling PagerWrite() on the wrong page handle...
danielk1977 [Thu, 3 May 2007 13:11:32 +0000 (13:11 +0000)] 
Fix a bug where accessPayload() was calling PagerWrite() on the wrong page handle. Ticket #2332. (CVS 3906)

FossilOrigin-Name: cf9eeba7be64ad29cddd320832db10c799fb6e8e

19 years agoUse memmove() instead of memcpy() when moving between memory regions that
drh [Thu, 3 May 2007 13:02:26 +0000 (13:02 +0000)] 
Use memmove() instead of memcpy() when moving between memory regions that
might overlap.  Ticket #2334. (CVS 3905)

FossilOrigin-Name: 678d672b73cc7b7f563c15daee3831cb5bbd890e

19 years agoMinor bugfixes for incrblob mode. (CVS 3904)
danielk1977 [Thu, 3 May 2007 11:43:34 +0000 (11:43 +0000)] 
Minor bugfixes for incrblob mode. (CVS 3904)

FossilOrigin-Name: b84d597c902d60341607bc405440603868ac52c8

19 years agoMinor bugfixes for incrblob mode. (CVS 3903)
danielk1977 [Thu, 3 May 2007 11:43:33 +0000 (11:43 +0000)] 
Minor bugfixes for incrblob mode. (CVS 3903)

FossilOrigin-Name: db54a9466e3bea9c03740ce0b755cfa02bafaccd

19 years agoAllow CREATE TABLE to occur while other queries are running. DROP TABLE is
drh [Wed, 2 May 2007 17:54:55 +0000 (17:54 +0000)] 
Allow CREATE TABLE to occur while other queries are running.  DROP TABLE is
still prohibited, however, since we do not want to delete a table out
from under an running query. (CVS 3902)

FossilOrigin-Name: 5b4bf1fce4d589337cfb1b46d75c751bbdc607d5

19 years agoCombine the internal btree functions BtreePutData() and getPayload(). (CVS 3901)
danielk1977 [Wed, 2 May 2007 17:48:45 +0000 (17:48 +0000)] 
Combine the internal btree functions BtreePutData() and getPayload(). (CVS 3901)

FossilOrigin-Name: a100a5304b0e7cbbdb6dac71a39c78eb71d44a03

19 years agoMore fixes and improvements to the zeroblob() mechanism. (CVS 3900)
drh [Wed, 2 May 2007 16:51:59 +0000 (16:51 +0000)] 
More fixes and improvements to the zeroblob() mechanism. (CVS 3900)

FossilOrigin-Name: 83ab25014e890b1cc6ea08ca1ebeeee0078da466

19 years agoCache the location of overflow pages in cursors used for incremental blob IO. (CVS...
danielk1977 [Wed, 2 May 2007 16:48:37 +0000 (16:48 +0000)] 
Cache the location of overflow pages in cursors used for incremental blob IO. (CVS 3899)

FossilOrigin-Name: 349f1ea7895f06c40affc985a13aa6686dfdea07

19 years agoFix an invalid UTF8 encoding in the tests for the trim function. (CVS 3898)
drh [Wed, 2 May 2007 15:36:01 +0000 (15:36 +0000)] 
Fix an invalid UTF8 encoding in the tests for the trim function. (CVS 3898)

FossilOrigin-Name: 4dbbfff4a7d4be197aac19c80400dafe10dd5e58

19 years agoAdd support for zero-blobs to the OP_MakeRecord opcode.
drh [Wed, 2 May 2007 13:30:27 +0000 (13:30 +0000)] 
Add support for zero-blobs to the OP_MakeRecord opcode.
First test cases of zeroblob functionality. (CVS 3897)

FossilOrigin-Name: e6d560ddeeb48fb0cbd9f5a10612280b055baef7

19 years agoUse the pointer-map pages to make the incremental blob API more efficient. (CVS 3896)
danielk1977 [Wed, 2 May 2007 13:16:30 +0000 (13:16 +0000)] 
Use the pointer-map pages to make the incremental blob API more efficient. (CVS 3896)

FossilOrigin-Name: 93a3bf71d576096f4b5a3db256ca6f9b5521d137

19 years agoFix some compiler warnings. Add the (untested) zeroblob() SQL function. (CVS 3895)
drh [Wed, 2 May 2007 02:08:28 +0000 (02:08 +0000)] 
Fix some compiler warnings.  Add the (untested) zeroblob() SQL function. (CVS 3895)

FossilOrigin-Name: 6f4f8ba7ec15f214f36fa78e593dd4522ab717f5

19 years agoBegin adding the zeroblob API to support incremental blob i/o. (CVS 3894)
drh [Wed, 2 May 2007 01:34:31 +0000 (01:34 +0000)] 
Begin adding the zeroblob API to support incremental blob i/o. (CVS 3894)

FossilOrigin-Name: 7a01836dde45098796693bc6cb6045c4059adf1a

19 years agoEnable prefix-search in query-parsing and snippet generation. If the
shess [Tue, 1 May 2007 18:25:52 +0000 (18:25 +0000)] 
Enable prefix-search in query-parsing and snippet generation.  If the
character immediately after the end of a term is '*', that term is
marked for prefix matching.  Modify term comparison in
snippetOffsetsOfColumn() to respect isPrefix.  fts2n.test runs prefix
searching through some obvious test cases. (CVS 3893)

FossilOrigin-Name: 7c4c65924035d9f260f6b64eb92c5c6cf6c04b7b

19 years agoFirst approximation of incremental blob IO API. (CVS 3892)
danielk1977 [Tue, 1 May 2007 17:49:49 +0000 (17:49 +0000)] 
First approximation of incremental blob IO API. (CVS 3892)

FossilOrigin-Name: c444836e7b690c16dd6acff571c613a23beb42dc

19 years agoModify loadSegmentLeavesInt() to correctly handle prefix searching.
shess [Tue, 1 May 2007 17:14:59 +0000 (17:14 +0000)] 
Modify loadSegmentLeavesInt() to correctly handle prefix searching.
The new function docListUnion() is used to accumulate a union of the
hits for the matching terms, which will be merged across segments
using docListMerge(). (CVS 3891)

FossilOrigin-Name: 72c796307338c2751a91c30f6fb16989afbf3816

19 years agoThe pager takes the sector size to be the larger of the sector size
drh [Tue, 1 May 2007 16:59:48 +0000 (16:59 +0000)] 
The pager takes the sector size to be the larger of the sector size
reported by sqlite3OsSectorSize() and the page size. (CVS 3890)

FossilOrigin-Name: e5e6af55ccc5c1a8a9206b42f1dd7bf547cb97ca

19 years agoPropagate prefix flag through implementation of doclist query code.
shess [Mon, 30 Apr 2007 22:09:36 +0000 (22:09 +0000)] 
Propagate prefix flag through implementation of doclist query code.
Also implement correct prefix-handling for traversal of interior nodes
of segment tree.  A given prefix can span multiple children of an
interior node, and from there the branches need to be followed in
parallel. (CVS 3889)

FossilOrigin-Name: cae844a01a1d87ffb00bba8b4e7b62a92e633aa9

19 years agoFix a potential segfault following a malloc() failure during a call
drh [Mon, 30 Apr 2007 21:39:16 +0000 (21:39 +0000)] 
Fix a potential segfault following a malloc() failure during a call
to sqlite3_prepare() where the nBytes parameter is positive but less than
the length of the input SQL string. (CVS 3888)

FossilOrigin-Name: 27bf3fc3cf3c9c7acdbf9281a4669c9f642b0097

19 years agoLift docListMerge() call out of loadSegmentLeavesInt() for prefix
shess [Mon, 30 Apr 2007 17:52:51 +0000 (17:52 +0000)] 
Lift docListMerge() call out of loadSegmentLeavesInt() for prefix
search.  Doclists from multiple prefix matches will need a union merge
function, which will have to logically happen across a segment before
doclists are merged between segments. (CVS 3887)

FossilOrigin-Name: 7ddb82668906e33e2d6a796f2da1795032e036d5

19 years agoTry to avoid reading pages when moving overflow chains to the free-list. (CVS 3886)
danielk1977 [Mon, 30 Apr 2007 16:55:00 +0000 (16:55 +0000)] 
Try to avoid reading pages when moving overflow chains to the free-list. (CVS 3886)

FossilOrigin-Name: 8cccec68bd9073b2b19d3d31cf0b77b0ce76172e

19 years agoAdd some tests (and 2 resulting bug fixes) to incr vacuum mode. (CVS 3885)
danielk1977 [Sat, 28 Apr 2007 15:47:43 +0000 (15:47 +0000)] 
Add some tests (and 2 resulting bug fixes) to incr vacuum mode. (CVS 3885)

FossilOrigin-Name: 89b1b3f897bda1fffceb9cf72fa4d42b809ccb8e

19 years agoBreak interior-node and leaf-node readers apart in loadSegment().
shess [Fri, 27 Apr 2007 22:02:57 +0000 (22:02 +0000)] 
Break interior-node and leaf-node readers apart in loadSegment().
Previously, the code looped until the block was a leaf node as
indicated by a leading NUL.  Now the code loops until it finds a block
in the range of leaf nodes for this segment, then reads it using
LeavesReader.  This will make it easier to traverse a range of leaves
when doing a prefix search. (CVS 3884)

FossilOrigin-Name: 9466367d65f43d58020e709428268dc2ff98aa35

19 years agoInternationalize the TRIM functions. Ticket #2323. (CVS 3883)
drh [Fri, 27 Apr 2007 21:59:52 +0000 (21:59 +0000)] 
Internationalize the TRIM functions.  Ticket #2323. (CVS 3883)

FossilOrigin-Name: ff1f4e744728c8f55afae265246797b30fe98fb0

19 years agoLift code to traverse interior nodes out of loadSegment().
shess [Fri, 27 Apr 2007 21:24:18 +0000 (21:24 +0000)] 
Lift code to traverse interior nodes out of loadSegment().
Refactoring towards prefix searching. (CVS 3882)

FossilOrigin-Name: 25935db73877c0cb132acb30c2fed2544d0e5e32

19 years agoRefactor fts2 loadSegmentLeaf() in preparation for prefix-searching.
shess [Fri, 27 Apr 2007 21:01:59 +0000 (21:01 +0000)] 
Refactor fts2 loadSegmentLeaf() in preparation for prefix-searching.
Prefix-searching will want to accumulate data across multiple leaves
in the segment, using LeavesReader instead of LeafReader is the first
step in that direction. (CVS 3881)

FossilOrigin-Name: 22ffdae4b6f3d0ea584dafa5268af7aa6fdcdc6e

19 years agoMake sure sqlite3_value_bytes() does not reformat the content after a
drh [Fri, 27 Apr 2007 17:16:20 +0000 (17:16 +0000)] 
Make sure sqlite3_value_bytes() does not reformat the content after a
call to sqlite3_value_blob().  Add documentation to explain this hazard.
Add many new tests.  Ticket #2321. (CVS 3880)

FossilOrigin-Name: e92bd97a3726bbb7978489e2994747127c4aefcf

19 years agoExtra tests for incremental vacuum. (CVS 3879)
danielk1977 [Fri, 27 Apr 2007 07:55:37 +0000 (07:55 +0000)] 
Extra tests for incremental vacuum. (CVS 3879)

FossilOrigin-Name: 40ba6493e9e8ba135552a2a0943ab499713ac001

19 years agoModifications to btree integrity check so that it can be run inside a transaction...
danielk1977 [Fri, 27 Apr 2007 07:05:44 +0000 (07:05 +0000)] 
Modifications to btree integrity check so that it can be run inside a transaction after an incr vacuum. (CVS 3878)

FossilOrigin-Name: 4d4180d6474d8d74460fb9333580b9b60c89f353

19 years agoThe replace() function should return NULL if the second argument is an
drh [Fri, 27 Apr 2007 01:18:02 +0000 (01:18 +0000)] 
The replace() function should return NULL if the second argument is an
empty string.  Ticket #2324. (CVS 3877)

FossilOrigin-Name: e6a0c90dd9b4f7efe2153dd0c899b6e3d9846bd8

19 years agoAdd largely untested code for the incremental vacuum function. (CVS 3876)
danielk1977 [Thu, 26 Apr 2007 14:42:34 +0000 (14:42 +0000)] 
Add largely untested code for the incremental vacuum function. (CVS 3876)

FossilOrigin-Name: f6a6d2b8872c05089810b1e095f39011f3035408

19 years agoIn the pager, load the content of pages which were initialized with
drh [Thu, 26 Apr 2007 12:11:28 +0000 (12:11 +0000)] 
In the pager, load the content of pages which were initialized with
noContent==1 if they are subsequently requested with noContent==0. (CVS 3875)

FossilOrigin-Name: d0745a43b6e037d16e1ec38c7c4d961a80d1ef48

19 years agoFix segfaults that can occur if a malloc failure happens just before
drh [Wed, 25 Apr 2007 18:23:52 +0000 (18:23 +0000)] 
Fix segfaults that can occur if a malloc failure happens just before
a built-in function calls sqlite3_value_text(). (CVS 3874)

FossilOrigin-Name: 9cb0ed6ee9827bc6884a0195044d5b6ad0de698e

19 years agoDisable tests in misc7 that do not work on windows due to limitations of
drh [Wed, 25 Apr 2007 15:42:25 +0000 (15:42 +0000)] 
Disable tests in misc7 that do not work on windows due to limitations of
the windows file system. (CVS 3873)

FossilOrigin-Name: 66646d6fda067e19240808aef65fafd8fa177cdd

19 years agoVersion 3.3.17 (CVS 3872) version-3.3.17
drh [Wed, 25 Apr 2007 12:07:22 +0000 (12:07 +0000)] 
Version 3.3.17 (CVS 3872)

FossilOrigin-Name: 16979f4525652bfd6c6e5306eafc883bef3880aa

19 years agoFix a file descriptor leak in the exclusive2 test script. (CVS 3871)
drh [Wed, 25 Apr 2007 12:06:58 +0000 (12:06 +0000)] 
Fix a file descriptor leak in the exclusive2 test script. (CVS 3871)

FossilOrigin-Name: 2d2e68da74459340c262a6454fdd05149bc94c59

19 years agoPreparing for the release of 3.3.17. (CVS 3870)
drh [Wed, 25 Apr 2007 11:42:32 +0000 (11:42 +0000)] 
Preparing for the release of 3.3.17. (CVS 3870)

FossilOrigin-Name: e278c4ef601eebeb5a4f89baf8b29a6794c403f1

19 years agoFix duplicate test IDs in the test suite. No changes to code. Ticket #2319. (CVS...
drh [Wed, 25 Apr 2007 11:32:30 +0000 (11:32 +0000)] 
Fix duplicate test IDs in the test suite.  No changes to code.  Ticket #2319. (CVS 3869)

FossilOrigin-Name: 0935cdf82a0be599421881117a981d315933bb7e

19 years agoFix a bug in the sqlite3_changes() function reported on the mailing list. (CVS 3868)
drh [Wed, 25 Apr 2007 11:28:16 +0000 (11:28 +0000)] 
Fix a bug in the sqlite3_changes() function reported on the mailing list. (CVS 3868)

FossilOrigin-Name: 58ea768c3e9905bd9db137f1b31dd3dd6c6001d0

19 years agoThis fixes a missed case in check-in (3866). Do not apply patch (3866)
drh [Tue, 24 Apr 2007 17:35:59 +0000 (17:35 +0000)] 
This fixes a missed case in check-in (3866).  Do not apply patch (3866)
without also applying this patch. (CVS 3867)

FossilOrigin-Name: 66c2fa0836089f360b1c3343df84b73e8d89b293

19 years agoWhen the write_version flag in the database header is larger than what
drh [Tue, 24 Apr 2007 17:27:51 +0000 (17:27 +0000)] 
When the write_version flag in the database header is larger than what
the library understands, make the database read-only.  The old behavior
was to make the database unreadable. (CVS 3866)

FossilOrigin-Name: 10648e99929b4f640855433b6e47702687039286

19 years agoGet the build working with -DSQLITE_OMIT_UTF16=1. Ticket #2314. (CVS 3865)
drh [Mon, 23 Apr 2007 23:56:31 +0000 (23:56 +0000)] 
Get the build working with -DSQLITE_OMIT_UTF16=1.  Ticket #2314. (CVS 3865)

FossilOrigin-Name: 25c1c7aaa8ef203120c2c242cf72ce4750f78abd

19 years agoAdd the ability to turn the FTS2 module into an amalgamation. (CVS 3864)
drh [Sat, 21 Apr 2007 16:37:48 +0000 (16:37 +0000)] 
Add the ability to turn the FTS2 module into an amalgamation. (CVS 3864)

FossilOrigin-Name: 94374654ccabb391f5dcccfc88176ca677c5804e

19 years agoRemove the ARRAYSIZE macro from where.c to avoid a name conflict with
drh [Fri, 20 Apr 2007 12:22:01 +0000 (12:22 +0000)] 
Remove the ARRAYSIZE macro from where.c to avoid a name conflict with
microsoft header files.  Ticket #2311 (CVS 3863)

FossilOrigin-Name: 9389a15f35f854c88440e365d85b48af3ff76b00

19 years agoFix bug in fts2 handling of OR queries. When one doclist ends before
shess [Thu, 19 Apr 2007 18:36:32 +0000 (18:36 +0000)] 
Fix bug in fts2 handling of OR queries.  When one doclist ends before
the other, the code potentially tries to read past the end of the
doclist.  http://www.sqlite.org/cvstrac/tktview?tn=2309 (CVS 3862)

FossilOrigin-Name: dfac6082e8ffc52a85c4906107a7fc0e1aa9df82

19 years agoBetter fix than (3860) for the same problem. (3860) could leave file-handles open...
danielk1977 [Thu, 19 Apr 2007 14:48:37 +0000 (14:48 +0000)] 
Better fix than (3860) for the same problem. (3860) could leave file-handles open in some circumstances. (CVS 3861)

FossilOrigin-Name: 5ad645339b2a3a280651447dceda67645ff8e96d

19 years agoFix a crash that can occur if an error happens in a virtual table xSync() function...
danielk1977 [Thu, 19 Apr 2007 14:28:08 +0000 (14:28 +0000)] 
Fix a crash that can occur if an error happens in a virtual table xSync() function. (CVS 3860)

FossilOrigin-Name: d1afdd8c9c756409275c116e662fc1e04bbe829e

19 years agoComment changes in the ioerr tests. No changes to code. (CVS 3859)
drh [Thu, 19 Apr 2007 12:30:54 +0000 (12:30 +0000)] 
Comment changes in the ioerr tests.  No changes to code. (CVS 3859)

FossilOrigin-Name: b7ed0e1e88a019c830f56abb14658104a30a1c43

19 years agoFix a bug whereby sqlite3_prepare_v2() could return both an out-of-memory error and...
danielk1977 [Thu, 19 Apr 2007 11:09:01 +0000 (11:09 +0000)] 
Fix a bug whereby sqlite3_prepare_v2() could return both an out-of-memory error and a valid statement handle. (CVS 3858)

FossilOrigin-Name: 8795d11c3c5bb39d34bc5194621ce97097a320e7

19 years agoGet the build working with SQLITE_OMIT_SHARED_CACHE. Ticket #2307. (CVS 3857)
drh [Thu, 19 Apr 2007 00:24:34 +0000 (00:24 +0000)] 
Get the build working with SQLITE_OMIT_SHARED_CACHE.  Ticket #2307. (CVS 3857)

FossilOrigin-Name: b623538c559498b858fd9088faf0f3457b024968

19 years agoFix a && where & was intended. This is a real problem, but it would be
drh [Wed, 18 Apr 2007 17:07:57 +0000 (17:07 +0000)] 
Fix a && where & was intended.  This is a real problem, but it would be
very difficult to devise a test case where it might lead to an unexpected
result.  Ticket #2306. (CVS 3856)

FossilOrigin-Name: 7f9f0444ed1a85ed682b604fded535bff5be1535

19 years agoBetter handle malloc() failures in the "echo" virtual table test module. (CVS 3855)
danielk1977 [Wed, 18 Apr 2007 17:04:00 +0000 (17:04 +0000)] 
Better handle malloc() failures in the "echo" virtual table test module. (CVS 3855)

FossilOrigin-Name: 6881f9212fea0e0a98045b0acc60151eeaf5839e

19 years agoThe sqlite3_step() routine reports SQLITE_ERROR after a commit failure,
drh [Wed, 18 Apr 2007 16:45:24 +0000 (16:45 +0000)] 
The sqlite3_step() routine reports SQLITE_ERROR after a commit failure,
not SQLITE_DONE.  This fix only effects the legacy sqlite3_prepare()
interface.  It already worked correctly with sqlite3_prepare_v2(). (CVS 3854)

FossilOrigin-Name: 165dc72d7024258e225c8a7d60118071282f0f44

19 years agoVersion 3.3.16 (CVS 3853) version-3.3.16
drh [Wed, 18 Apr 2007 15:33:52 +0000 (15:33 +0000)] 
Version 3.3.16 (CVS 3853)

FossilOrigin-Name: 8c6b5adb5c9e0322098e15a162e80a98259d7f60

19 years agoFix an assertion failure caused by (3851). (CVS 3852)
danielk1977 [Wed, 18 Apr 2007 14:47:23 +0000 (14:47 +0000)] 
Fix an assertion failure caused by (3851). (CVS 3852)

FossilOrigin-Name: 24683f1d29c5d312d6cabe2dde52d7c0424f629a

19 years agoMinor changes (mainly to assert() macros) to handle malloc failure in vtab operations...
danielk1977 [Wed, 18 Apr 2007 14:24:32 +0000 (14:24 +0000)] 
Minor changes (mainly to assert() macros) to handle malloc failure in vtab operations. (CVS 3851)

FossilOrigin-Name: 175156d1fcaadab3b955597abb27f6b9043bbb5b

19 years agoBump the version number and update documents in preparation for 3.3.16. (CVS 3850)
drh [Wed, 18 Apr 2007 13:49:37 +0000 (13:49 +0000)] 
Bump the version number and update documents in preparation for 3.3.16. (CVS 3850)

FossilOrigin-Name: 852100a332d9f602e5f6285d2b7e19a3060c6162

19 years agoAvoid reloading the db schema after a failed OP_VerifyCookie if the in-memory schema...
danielk1977 [Tue, 17 Apr 2007 08:32:33 +0000 (08:32 +0000)] 
Avoid reloading the db schema after a failed OP_VerifyCookie if the in-memory schema cookie already matches the database file. (CVS 3849)

FossilOrigin-Name: 61c1d06d10257575e1406303af331bcc4d00deb0

19 years agoFix a memory leak introduced by (3842) associated with ticket #2296. (CVS 3848)
drh [Mon, 16 Apr 2007 17:07:55 +0000 (17:07 +0000)] 
Fix a memory leak introduced by (3842) associated with ticket #2296. (CVS 3848)

FossilOrigin-Name: cdc7608b8d590b2ca19be37f94f2cd17423ba8ac

19 years agoAdd test cases to make sure virtual tables cannot be used in shared-cache mode. ...
danielk1977 [Mon, 16 Apr 2007 15:49:41 +0000 (15:49 +0000)] 
Add test cases to make sure virtual tables cannot be used in shared-cache mode. (CVS 3847)

FossilOrigin-Name: 66e468adfcf0132e558a666b847ce7c1e024d6fd

19 years agoMake it clear in the docs that virtual tables and shared cache do not
drh [Mon, 16 Apr 2007 15:35:23 +0000 (15:35 +0000)] 
Make it clear in the docs that virtual tables and shared cache do not
play well together. (CVS 3846)

FossilOrigin-Name: 62ef2b1127e76eae0f76ac51f8238446763a3aac

19 years agoEnsure sqlite3_finalize() can be called from within the xDisconnect() method of virtu...
danielk1977 [Mon, 16 Apr 2007 15:06:25 +0000 (15:06 +0000)] 
Ensure sqlite3_finalize() can be called from within the xDisconnect() method of virtual tables. (CVS 3845)

FossilOrigin-Name: 8d6c3bfc4dfdd380a2915d778e256d3e49d22d72

19 years agoDetect database file changes using a 128-bit segment of the file header
drh [Mon, 16 Apr 2007 15:02:19 +0000 (15:02 +0000)] 
Detect database file changes using a 128-bit segment of the file header
that includes the change counter.  Ticket #2303. (CVS 3844)

FossilOrigin-Name: e44995debf2456e55b502783849e93a045a527c8

19 years agoUpdate the whentouse.html document to mention that less bitmap memory
drh [Sat, 14 Apr 2007 12:04:39 +0000 (12:04 +0000)] 
Update the whentouse.html document to mention that less bitmap memory
is used for larger page sizes. (CVS 3843)

FossilOrigin-Name: 2c8e2a5be34cdfe11ef22bd6f78ec0519f497392

19 years agoMatch ORDER BY terms to columns using names in compound queries. Make sure
drh [Fri, 13 Apr 2007 16:06:32 +0000 (16:06 +0000)] 
Match ORDER BY terms to columns using names in compound queries.  Make sure
this works for subqueries, especially in the right-hand side of an IN
operator. Ticket #2296. (CVS 3842)

FossilOrigin-Name: cfc6f933dc60ca88ae848f7f0c402e820437c2ff

19 years agoFix a bug in autovacuum introduced by (3839). (CVS 3841)
drh [Fri, 13 Apr 2007 04:01:58 +0000 (04:01 +0000)] 
Fix a bug in autovacuum introduced by (3839). (CVS 3841)

FossilOrigin-Name: e39efa195a28f1cd7431b0811bd908dc7af3c8b1

19 years agoAdditional tests designed to detect future performance regressions. (CVS 3840)
drh [Fri, 13 Apr 2007 03:23:21 +0000 (03:23 +0000)] 
Additional tests designed to detect future performance regressions. (CVS 3840)

FossilOrigin-Name: 764e7262b93a7a5073128ecd4db265b0c728a701

19 years agoFix multiple performance regressions (ticket #2298 among them)
drh [Fri, 13 Apr 2007 02:14:30 +0000 (02:14 +0000)] 
Fix multiple performance regressions (ticket #2298 among them)
and add tests to make sure they do not come back. (CVS 3839)

FossilOrigin-Name: 32bb2d5859906b4fb0f6083eedd7f3a81b9cf5e2

19 years agoChanges toward fixes for tickets #2296 and #2291. (CVS 3838)
drh [Thu, 12 Apr 2007 21:25:01 +0000 (21:25 +0000)] 
Changes toward fixes for tickets #2296 and #2291. (CVS 3838)

FossilOrigin-Name: 0dd3e2e47b09156838edfa4dea0d82f9cf22d94d

19 years agoGet the column affinities right when processing an IN operator where
drh [Thu, 12 Apr 2007 03:54:38 +0000 (03:54 +0000)] 
Get the column affinities right when processing an IN operator where
the right-hand side is a subquery with an ORDER BY clause.  Ticket #2295.
This bug has likely been present since version 3.0.0 and it has just now
been noticed, so it seems to be a obscure case. (CVS 3837)

FossilOrigin-Name: 4062ddf3c7f4fd150292304fa33ca76dc35571a1

19 years agoBlind check-in of changes to fix #2294 - I have no ability to test.
drh [Wed, 11 Apr 2007 17:54:03 +0000 (17:54 +0000)] 
Blind check-in of changes to fix #2294 - I have no ability to test.
Gentle wince users: please test this change and if it works leave a remark
on the #2294 ticket.  Tnx. (CVS 3836)

FossilOrigin-Name: ca56c3e2250eda0b312ab6f801b0fd95fb136bfa

19 years agoPreliminary fix for ticket #2291. This fixes the immediate problem. But
drh [Tue, 10 Apr 2007 18:17:55 +0000 (18:17 +0000)] 
Preliminary fix for ticket #2291.  This fixes the immediate problem.  But
we really need to write more tests for the xfer optimization in order to
look for other related problems before closing this ticket. (CVS 3835)

FossilOrigin-Name: 34fec312fd1aeabb04e07d6aa061991775c7b8a1

19 years agoBe careful not to use the result of sqlite3_value_blob() after changing
drh [Tue, 10 Apr 2007 13:51:17 +0000 (13:51 +0000)] 
Be careful not to use the result of sqlite3_value_blob() after changing
the representation of an object.  Ticket #2290. (CVS 3834)

FossilOrigin-Name: e14374e4e6f14a90ecb53c2e7c86908a220c6d68

19 years agoFix crash in delete when existing row has null fields. Previous code
shess [Mon, 9 Apr 2007 20:45:40 +0000 (20:45 +0000)] 
Fix crash in delete when existing row has null fields.  Previous code
assumed that the row had values in all columns, sigh.  Fixes bug
http://www.sqlite.org/cvstrac/tktview?tn=2289 . (CVS 3833)

FossilOrigin-Name: 81be7290a4db7b74a533aaf95c7389eb4bde6a88

19 years agoFix stack buffer overrun problem in the test harness. (CVS 3832)
drh [Mon, 9 Apr 2007 20:30:11 +0000 (20:30 +0000)] 
Fix stack buffer overrun problem in the test harness. (CVS 3832)

FossilOrigin-Name: cad9faf3ad99b68be4618dff4b3497b15b9e6d9d

19 years agoVersion 3.3.15 (CVS 3831) version-3.3.15
drh [Mon, 9 Apr 2007 13:49:33 +0000 (13:49 +0000)] 
Version 3.3.15 (CVS 3831)

FossilOrigin-Name: ba5f4a55fad183a1698555b256f43f63451f5fc6

19 years agoPerparations for the release of 3.3.15. (CVS 3830)
drh [Mon, 9 Apr 2007 13:18:46 +0000 (13:18 +0000)] 
Perparations for the release of 3.3.15. (CVS 3830)

FossilOrigin-Name: 8d0dea873d00404ad252d056422da2630f5e525f

19 years agoFix an obscure pager refcnt leak that occurs following a transient I/O
drh [Mon, 9 Apr 2007 12:45:02 +0000 (12:45 +0000)] 
Fix an obscure pager refcnt leak that occurs following a transient I/O
error. (CVS 3829)

FossilOrigin-Name: ce6f56ece8eab743d20cd2c0a84b4a266c4da2ff

19 years agoHave the pager call xReiniter() instead of xDestructor() to restore btree level state...
danielk1977 [Mon, 9 Apr 2007 11:20:54 +0000 (11:20 +0000)] 
Have the pager call xReiniter() instead of xDestructor() to restore btree level state after rolling back a page. (CVS 3828)

FossilOrigin-Name: 4e8941333ef053442877a2a696a2c68d403c7f4d

19 years agoWork around buggy TCL implementations in the exclusive2 test file. Ticket #2287...
drh [Sun, 8 Apr 2007 16:52:22 +0000 (16:52 +0000)] 
Work around buggy TCL implementations in the exclusive2 test file.  Ticket #2287 (CVS 3827)

FossilOrigin-Name: 5424fcc5f82e864e0a85a71e0ae39209200386c6