]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
18 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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

18 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

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

FossilOrigin-Name: ba5f4a55fad183a1698555b256f43f63451f5fc6

18 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

18 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

18 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

18 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

18 years agoMake sure autovacuum is turned off for malloc5.test. (CVS 3826)
drh [Sat, 7 Apr 2007 17:44:27 +0000 (17:44 +0000)] 
Make sure autovacuum is turned off for malloc5.test. (CVS 3826)

FossilOrigin-Name: 105a7efb090a5619e82a7e2931d4d3e080e6465a

18 years agoFor filesystem databases, do not store a list of pages in the statement journal in...
danielk1977 [Sat, 7 Apr 2007 15:03:17 +0000 (15:03 +0000)] 
For filesystem databases, do not store a list of pages in the statement journal in main memory. (CVS 3825)

FossilOrigin-Name: 0af764a02695281b0a7d70ef4e7f8229fd3d6a30

18 years agoChanges to test scripts to support alternative configurations. (CVS 3824)
drh [Fri, 6 Apr 2007 21:42:22 +0000 (21:42 +0000)] 
Changes to test scripts to support alternative configurations. (CVS 3824)

FossilOrigin-Name: 3471a2269fb6b3769b59b70992e6da3bdebea7df

18 years agoAdditional coverage testing. (CVS 3823)
drh [Fri, 6 Apr 2007 18:23:17 +0000 (18:23 +0000)] 
Additional coverage testing. (CVS 3823)

FossilOrigin-Name: 26b2e1aede3f776134b2d6e941d17a907843e650

18 years agoBinary file I/O infrastructure added and used to increase test coverage
drh [Fri, 6 Apr 2007 15:02:13 +0000 (15:02 +0000)] 
Binary file I/O infrastructure added and used to increase test coverage
for detection of corrupt database files. (CVS 3822)

FossilOrigin-Name: 479b3d965b19c3ec4cb72542718751debf8ff75c

18 years agoThe FOR EACH STATEMENT clause in a trigger is now a syntax error. It used
drh [Fri, 6 Apr 2007 11:26:00 +0000 (11:26 +0000)] 
The FOR EACH STATEMENT clause in a trigger is now a syntax error.  It used
to be silently ignored.  STATEMENT is no longer a keyword. (CVS 3821)

FossilOrigin-Name: 8e2559b4da6329d7c21925d0850f7f91a3731975

18 years agoTest coverage improvements. Over 90% of branches are now executed in
drh [Fri, 6 Apr 2007 02:32:33 +0000 (02:32 +0000)] 
Test coverage improvements.  Over 90% of branches are now executed in
both directions. (CVS 3820)

FossilOrigin-Name: a776d93ccae3bfa6e992cdd1387571dd21561f98

18 years agoChanges to increase test coverage. (CVS 3819)
drh [Fri, 6 Apr 2007 01:04:39 +0000 (01:04 +0000)] 
Changes to increase test coverage. (CVS 3819)

FossilOrigin-Name: fd4da6b13499af2397d52cb0f25f8ff6f2192431

18 years agoMake sure the sqlite3BtreePrevious() routine terminates properly if the
drh [Fri, 6 Apr 2007 01:03:32 +0000 (01:03 +0000)] 
Make sure the sqlite3BtreePrevious() routine terminates properly if the
table is deleted out from under it.  Ticket #2286.  This bug was discovered
while trying to increase test coverage from 98.5% to 99% - once again
showing the value of full coverage testing. (CVS 3818)

FossilOrigin-Name: bebf8d2f886ed9fe1b96e4cb11ab3de2f2f7d2c8

18 years agoFix the amalgamation so that it works with -DSQLITE_ENABLE_REDEF_IO. Change
drh [Thu, 5 Apr 2007 21:58:33 +0000 (21:58 +0000)] 
Fix the amalgamation so that it works with -DSQLITE_ENABLE_REDEF_IO.  Change
tclsqlite.c so that it can be appended to the amalgamation.  Create a new
amalgamation of header files for use by projects that want to redefine their
own I/O interface using -DSQLITE_ENABLE_REDEF_IO. (CVS 3817)

FossilOrigin-Name: f2caff870c81c08ec85aae72986c231ee986b251

18 years agoAdd a target to the autoconf-generated makefile for amalgamation. (CVS 3816)
drh [Thu, 5 Apr 2007 18:34:58 +0000 (18:34 +0000)] 
Add a target to the autoconf-generated makefile for amalgamation. (CVS 3816)

FossilOrigin-Name: 204e7d38aeb40d126b80a869958ca79cd0902d83

18 years agoNew testfixture command: sqlite3_pager_refcounts. Returns a list of
drh [Thu, 5 Apr 2007 17:36:18 +0000 (17:36 +0000)] 
New testfixture command: sqlite3_pager_refcounts.  Returns a list of
integers which is the pager refcount for each pager in the database. (CVS 3815)

FossilOrigin-Name: 7338e68e0fd9263236f12f8911cb8293747dd1a4

18 years agoAlways truncate the pager cache when truncating the database file. Also reorganize...
danielk1977 [Thu, 5 Apr 2007 17:15:52 +0000 (17:15 +0000)] 
Always truncate the pager cache when truncating the database file. Also reorganize the code to check the change-counter after first obtaining a shared lock. (CVS 3814)

FossilOrigin-Name: 9dc4100eff71be579480ce7939c7da712d28f0ae

18 years agoUse the MEMDB macro instead of OMIT_MEMORYDB in pager_recycle(). (CVS 3813)
danielk1977 [Thu, 5 Apr 2007 14:29:42 +0000 (14:29 +0000)] 
Use the MEMDB macro instead of OMIT_MEMORYDB in pager_recycle(). (CVS 3813)

FossilOrigin-Name: 97c5159816e211d9c71aa68db7c5e01df535d6a4

18 years agoAvoid attempting to reclaim memory from in-memory databases in sqlite3_release_memory...
danielk1977 [Thu, 5 Apr 2007 13:12:13 +0000 (13:12 +0000)] 
Avoid attempting to reclaim memory from in-memory databases in sqlite3_release_memory(). (CVS 3812)

FossilOrigin-Name: c20f7563c0ffa1df47df5464f1f1cc4703ffa9b4

18 years agoAdd some assert() statements to pager.c. (CVS 3811)
danielk1977 [Thu, 5 Apr 2007 11:54:42 +0000 (11:54 +0000)] 
Add some assert() statements to pager.c. (CVS 3811)

FossilOrigin-Name: 973b2a5fb56a1ed1fd10d062edcb6e6dad13f001

18 years agoImprovements to coverage testing. (CVS 3810)
drh [Thu, 5 Apr 2007 11:25:58 +0000 (11:25 +0000)] 
Improvements to coverage testing. (CVS 3810)

FossilOrigin-Name: 38af156da83a8469080ddb75a9a286be33ff6bef

18 years agoCatch an IO error case introduced by (3808). (CVS 3809)
danielk1977 [Thu, 5 Apr 2007 08:40:32 +0000 (08:40 +0000)] 
Catch an IO error case introduced by (3808). (CVS 3809)

FossilOrigin-Name: 383a08e26083964e79bfe22156f5f554522fa1fb

18 years agoZero cached pages located beyond the end of the file before returning them. Ticket...
danielk1977 [Thu, 5 Apr 2007 05:46:14 +0000 (05:46 +0000)] 
Zero cached pages located beyond the end of the file before returning them. Ticket #2285. (CVS 3808)

FossilOrigin-Name: 5180810eeaa3dfe3d934af0732a920ae117ec69f

18 years agoTest coverage improvements. (CVS 3807)
drh [Wed, 4 Apr 2007 01:27:44 +0000 (01:27 +0000)] 
Test coverage improvements. (CVS 3807)

FossilOrigin-Name: 25f49acc5662ed8dd321b83a60aeeab93a37e129

18 years agoAdd Tcl (flush) commands to exclusive2.test, which is failing on some systems but...
danielk1977 [Tue, 3 Apr 2007 16:13:51 +0000 (16:13 +0000)] 
Add Tcl (flush) commands to exclusive2.test, which is failing on some systems but not others. (CVS 3806)

FossilOrigin-Name: 9e004c519a30257fe3230ac7af630d296e139c9e

18 years agoFix to Makefile.in so that "make test" works. (CVS 3805)
drh [Mon, 2 Apr 2007 22:19:38 +0000 (22:19 +0000)] 
Fix to Makefile.in so that "make test" works. (CVS 3805)

FossilOrigin-Name: f592dd2d997064cda57b549901a2bcc14498b650

18 years agoDo not use the second parameter to gettimeofday() on unix. Pass it a NULL. (CVS...
drh [Mon, 2 Apr 2007 18:06:57 +0000 (18:06 +0000)] 
Do not use the second parameter to gettimeofday() on unix.  Pass it a NULL. (CVS 3804)

FossilOrigin-Name: 96b678818c9a536b77f10b25256facf4bff1ff65

18 years agoFix a union initializer so that it works with the Borland compiler. (CVS 3803)
drh [Mon, 2 Apr 2007 17:54:56 +0000 (17:54 +0000)] 
Fix a union initializer so that it works with the Borland compiler. (CVS 3803)

FossilOrigin-Name: a067f78bf6a45d68ee1337115704cda2041919f4

18 years agoAdd a different form of I/O tests. So far has failed to expose new bugs. (CVS 3802)
danielk1977 [Mon, 2 Apr 2007 16:46:23 +0000 (16:46 +0000)] 
Add a different form of I/O tests. So far has failed to expose new bugs. (CVS 3802)

FossilOrigin-Name: 9e1295428f476dba21c28149c7983f66a9134559

18 years agoIf preprocessor macro OS_OTHER is defined, then ignore OS_UNIX, OS_WIN, and
drh [Mon, 2 Apr 2007 16:45:12 +0000 (16:45 +0000)] 
If preprocessor macro OS_OTHER is defined, then ignore OS_UNIX, OS_WIN, and
OS_OS2.  This makes it easier to add proprietary backends.. (CVS 3801)

FossilOrigin-Name: 4fdafd3f583b1ec4aa7fb6a9b5de2f52a375832b

18 years agoProvide a compile-time option to enable exclusive access mode by default. (CVS 3800)
drh [Mon, 2 Apr 2007 16:40:37 +0000 (16:40 +0000)] 
Provide a compile-time option to enable exclusive access mode by default. (CVS 3800)

FossilOrigin-Name: 93a41510f02dc5649dbbc22c4e4fbee545bd76d8

18 years agoVersion 3.3.14 (CVS 3799)
drh [Mon, 2 Apr 2007 15:31:48 +0000 (15:31 +0000)] 
Version 3.3.14 (CVS 3799)

FossilOrigin-Name: 3dbf4f98accf3f4fd78e39448e68dd3bd85bdf10

18 years agoChanges to the download page. (CVS 3798)
drh [Mon, 2 Apr 2007 15:29:32 +0000 (15:29 +0000)] 
Changes to the download page. (CVS 3798)

FossilOrigin-Name: de8055bcd678034b1ba1fe40d46a7fb60ee598f8

18 years agoUpdate the build scripts and the homepage in preparation for version 3.3.14. (CVS...
drh [Mon, 2 Apr 2007 15:04:34 +0000 (15:04 +0000)] 
Update the build scripts and the homepage in preparation for version 3.3.14. (CVS 3797)

FossilOrigin-Name: a154224b329423aef622be539f6e7dfb76dc4c21

18 years agoCover an extra case in sqlite3PagerMovepage(). (CVS 3796)
danielk1977 [Mon, 2 Apr 2007 14:19:16 +0000 (14:19 +0000)] 
Cover an extra case in sqlite3PagerMovepage(). (CVS 3796)

FossilOrigin-Name: 7313688bd03141381067c36800edf1621a2ea05e

18 years agoFix for #2281. This was a problem with the test-case only. (CVS 3795)
danielk1977 [Mon, 2 Apr 2007 12:29:01 +0000 (12:29 +0000)] 
Fix for #2281. This was a problem with the test-case only. (CVS 3795)

FossilOrigin-Name: c036db6251ca4671fc3388a4f37955c18adeca1d

18 years agoCover a corrupt-db case in pager.c. (CVS 3794)
danielk1977 [Mon, 2 Apr 2007 12:28:27 +0000 (12:28 +0000)] 
Cover a corrupt-db case in pager.c. (CVS 3794)

FossilOrigin-Name: 84077fa1602756339a262bc4ab51b6b487edc637

18 years agoIn the amalgamation, put date.c before os.c so that the time_t typedef
drh [Mon, 2 Apr 2007 12:22:44 +0000 (12:22 +0000)] 
In the amalgamation, put date.c before os.c so that the time_t typedef
can be correctly resolved by windows compilers. (CVS 3793)

FossilOrigin-Name: 9c5697c70fa850ea700e8cc0c918791a1628ab10

18 years agoIf an IO error is encountered on a commit, close the journal so that it
drh [Mon, 2 Apr 2007 11:22:22 +0000 (11:22 +0000)] 
If an IO error is encountered on a commit, close the journal so that it
persists and can (hopefully) rollback the failed transaction later. (CVS 3792)

FossilOrigin-Name: 22e10cc24e4407feb276abfa8cc9964f20c6e54a

18 years agoCorrectly handle the obscure case of a read-only hot-journal file. (CVS 3791)
danielk1977 [Mon, 2 Apr 2007 11:08:58 +0000 (11:08 +0000)] 
Correctly handle the obscure case of a read-only hot-journal file. (CVS 3791)

FossilOrigin-Name: 4d8c6bf44ec00ec04e615983cb33425ca2c3998a

18 years agoFix a resource leak introduced by the change-counter optimisation. Also add some...
danielk1977 [Mon, 2 Apr 2007 05:07:47 +0000 (05:07 +0000)] 
Fix a resource leak introduced by the change-counter optimisation. Also add some test coverage. (CVS 3790)

FossilOrigin-Name: ba0538a4977aefd6645554f1989f0a98b540b9cd

18 years agoUpdate the version number and change comments in preparation for the
drh [Mon, 2 Apr 2007 00:53:18 +0000 (00:53 +0000)] 
Update the version number and change comments in preparation for the
release of 3.3.14. (CVS 3789)

FossilOrigin-Name: d9f6fdb72b29354921e6de40df5ed4f86b158a01

18 years agoFix some warnings about unused and uninitialized variables. (CVS 3788)
drh [Sun, 1 Apr 2007 23:49:51 +0000 (23:49 +0000)] 
Fix some warnings about unused and uninitialized variables. (CVS 3788)

FossilOrigin-Name: 18aec1ddfb08b74f0ef9cf1215eac7af71449db3

18 years agoMake unix builds threadsafe by default. (CVS 3787)
drh [Sun, 1 Apr 2007 18:46:19 +0000 (18:46 +0000)] 
Make unix builds threadsafe by default. (CVS 3787)

FossilOrigin-Name: ddfc3b2df0b37be66fc55bb216cdcb6ba67aa7fd

18 years agoFix typos in the amalgamation builder script. (CVS 3786)
drh [Sun, 1 Apr 2007 01:57:41 +0000 (01:57 +0000)] 
Fix typos in the amalgamation builder script. (CVS 3786)

FossilOrigin-Name: a5070a2d11b4dad550a889d5fc005302208b6d75

18 years agoImprovements to the output of the speed tests. (CVS 3785)
drh [Sat, 31 Mar 2007 22:34:16 +0000 (22:34 +0000)] 
Improvements to the output of the speed tests. (CVS 3785)

FossilOrigin-Name: 1a4d8024b06488f17831b5d3d47e41c5f1134800

18 years agoRemove unreachable code from util.c. (CVS 3784)
drh [Sat, 31 Mar 2007 22:33:48 +0000 (22:33 +0000)] 
Remove unreachable code from util.c. (CVS 3784)

FossilOrigin-Name: 82b7a6f05c737f6ad4a21f354e55ec268fa1b032

18 years agoAdd the amalgamation generator to the makefile. (CVS 3783)
drh [Sat, 31 Mar 2007 22:29:05 +0000 (22:29 +0000)] 
Add the amalgamation generator to the makefile. (CVS 3783)

FossilOrigin-Name: a0f3c960fa3e958e12bc488451ee2d637562909b

18 years agoFix the amalgamation so that it can be compiled with REDEF_IO enabled. (CVS 3782)
drh [Sat, 31 Mar 2007 16:29:06 +0000 (16:29 +0000)] 
Fix the amalgamation so that it can be compiled with REDEF_IO enabled. (CVS 3782)

FossilOrigin-Name: 6a3d6142d8be18bf2a9913f0329bcce48867304b

18 years agoIncrease test coverage by statically defining SQLITE_BIGENDIAN and related
drh [Sat, 31 Mar 2007 15:27:59 +0000 (15:27 +0000)] 
Increase test coverage by statically defining SQLITE_BIGENDIAN and related
macros for ix86 platforms.  Still a run-time test for other architectures.
Need to add additional cases to cover other popular processors. (CVS 3781)

FossilOrigin-Name: 476e7c3fcc69d8b21d161c758aaa5ef7163abb15

18 years agoImproved test coverage for printf.c. (CVS 3780)
drh [Sat, 31 Mar 2007 15:02:49 +0000 (15:02 +0000)] 
Improved test coverage for printf.c. (CVS 3780)

FossilOrigin-Name: c2badb208ff1207a1471410965947893b070ea50

18 years agoThe XFER optimization works if the target table lacks an integer primary
drh [Sat, 31 Mar 2007 13:00:26 +0000 (13:00 +0000)] 
The XFER optimization works if the target table lacks an integer primary
key and is not empty as long as it has no indices.  It always has and
continues to work if the target table was empty. (CVS 3779)

FossilOrigin-Name: 2c62ffcb865655e8b91aaf81601548ea540c6088

18 years agoMore coverage for pager.c. (CVS 3778)
danielk1977 [Sat, 31 Mar 2007 10:00:48 +0000 (10:00 +0000)] 
More coverage for pager.c. (CVS 3778)

FossilOrigin-Name: 665b119a241a5a95f236b3ace1b25fc18ae6f0a3

18 years agoFix a long-standing memory leak in the hash table. The leak only appears
drh [Sat, 31 Mar 2007 03:59:23 +0000 (03:59 +0000)] 
Fix a long-standing memory leak in the hash table.  The leak only appears
following a malloc failure of a hash that copies its keys, which rarely
happens and so we have not previously noticed it. (CVS 3777)

FossilOrigin-Name: 2aae1964572f4d4d1eae090a997e0bd9a82a69b2

18 years agoFix a large memory leak in the btree layer
drh [Sat, 31 Mar 2007 02:36:44 +0000 (02:36 +0000)] 
Fix a large memory leak in the btree layer
that occurs following an I/O error when in shared cache mode. (CVS 3776)

FossilOrigin-Name: dce4cb84930116db99275f77141fd933bc84288e

18 years agoFix memory leaks in WHERE clause processing and in TRIGGER parsing. (CVS 3775)
drh [Sat, 31 Mar 2007 01:34:44 +0000 (01:34 +0000)] 
Fix memory leaks in WHERE clause processing and in TRIGGER parsing. (CVS 3775)

FossilOrigin-Name: 6736f4547c0cc2123d1a19ed2d6915712718d22e

18 years agoRemove vestiges of SQLITE_PROTOCOL from the test scripts. (CVS 3774)
drh [Fri, 30 Mar 2007 20:46:13 +0000 (20:46 +0000)] 
Remove vestiges of SQLITE_PROTOCOL from the test scripts. (CVS 3774)

FossilOrigin-Name: e5e8d56397acf041aeaf5361381eb22eb1554759

18 years agoRemove vestiges of the SQLITE_PROTOCOL error. (CVS 3773)
drh [Fri, 30 Mar 2007 20:43:40 +0000 (20:43 +0000)] 
Remove vestiges of the SQLITE_PROTOCOL error. (CVS 3773)

FossilOrigin-Name: 6dfd4a12a8a03c204505e7a211e179b7dd47e4fb

18 years agoFix a memory leak that occurs after a malloc failure in trigger parsing. (CVS 3772)
drh [Fri, 30 Mar 2007 20:40:34 +0000 (20:40 +0000)] 
Fix a memory leak that occurs after a malloc failure in trigger parsing. (CVS 3772)

FossilOrigin-Name: 407a85e69b7a1229218a5ce9a9e31255c7070294

18 years agoFix a memory leak in multi-database commit. Also enhance a comment that
drh [Fri, 30 Mar 2007 18:42:55 +0000 (18:42 +0000)] 
Fix a memory leak in multi-database commit.  Also enhance a comment that
explains why a particular valgrind error is harmless. (CVS 3771)

FossilOrigin-Name: 28c7ed1eb799203a569cdae97da974b347f39579

18 years agoCoverage testing for a few lines in pager.c. (CVS 3770)
danielk1977 [Fri, 30 Mar 2007 18:21:52 +0000 (18:21 +0000)] 
Coverage testing for a few lines in pager.c. (CVS 3770)

FossilOrigin-Name: c1aca18fad35be60066a08f5bd09772d24375af6

18 years agoRemove asserts on the existing of journal files in pager - asserts that
drh [Fri, 30 Mar 2007 17:18:50 +0000 (17:18 +0000)] 
Remove asserts on the existing of journal files in pager - asserts that
are not valid for certain kinds of simulated I/O errors or for async I/O. (CVS 3769)

FossilOrigin-Name: f5fad52a97a16faddc2701ea0e05a301974eda1a

18 years agoGet the memleak.test script working again after recent changes. (CVS 3768)
drh [Fri, 30 Mar 2007 17:17:51 +0000 (17:17 +0000)] 
Get the memleak.test script working again after recent changes. (CVS 3768)

FossilOrigin-Name: cd6ca078e3402f06836b6b510a4a431f576f7219

18 years agoCoverage tests for some pragmas. (CVS 3767)
danielk1977 [Fri, 30 Mar 2007 17:11:12 +0000 (17:11 +0000)] 
Coverage tests for some pragmas. (CVS 3767)

FossilOrigin-Name: eec7ab63beed875a3b16c3bf8d28ac4f296dfb4c

18 years agoAlways enable exclusive access mode for TEMP databases. This cannot be
drh [Fri, 30 Mar 2007 16:01:55 +0000 (16:01 +0000)] 
Always enable exclusive access mode for TEMP databases.  This cannot be
changed.  The locking_mode pragma has not effect on the TEMP database. (CVS 3766)

FossilOrigin-Name: 04d3b9098ed06d5be24253edde50ea61b4641df8

18 years agoCoverage improvements for where.c. (CVS 3765)
danielk1977 [Fri, 30 Mar 2007 14:56:34 +0000 (14:56 +0000)] 
Coverage improvements for where.c. (CVS 3765)

FossilOrigin-Name: df64894bacd8023cf3c5939f062c8463ff5cdc04

18 years agoCoverage improvements for where.c. (CVS 3764)
danielk1977 [Fri, 30 Mar 2007 14:56:34 +0000 (14:56 +0000)] 
Coverage improvements for where.c. (CVS 3764)

FossilOrigin-Name: 7e0aa964129612e2bad6fa45139d124f19cacd48

18 years agoTease apart the two phases of pager commit. (CVS 3763)
drh [Fri, 30 Mar 2007 14:46:01 +0000 (14:46 +0000)] 
Tease apart the two phases of pager commit. (CVS 3763)

FossilOrigin-Name: e5f17078a28b6a47d6943d40c526390c36258392

18 years agoRefactoring the btree and pager routines into distinct two-phase commit
drh [Fri, 30 Mar 2007 14:06:34 +0000 (14:06 +0000)] 
Refactoring the btree and pager routines into distinct two-phase commit
routines.  We've always done a two-phase commit - this change is just
making that more apparent in the code. (CVS 3762)

FossilOrigin-Name: 66b3ad09ea657d25d48cb75ec2671ea2dc1b6005

18 years agoMake yypMinor available to the stack overflow callbacks in lemon
drh [Fri, 30 Mar 2007 13:35:05 +0000 (13:35 +0000)] 
Make yypMinor available to the stack overflow callbacks in lemon
generated parsers.  This does not effect SQLite. (CVS 3761)

FossilOrigin-Name: 70c8c7e2ce5213778e63c200a6637849920deea6

18 years agoAvoid using the "clock" command in test scripts since it is a proc in Tcl8.5
drh [Fri, 30 Mar 2007 13:01:32 +0000 (13:01 +0000)] 
Avoid using the "clock" command in test scripts since it is a proc in Tcl8.5
and is thus not available to testfixture. (CVS 3760)

FossilOrigin-Name: 339941d83ae397d69084f41483afb1ea44d44967

18 years agoMove the sqlite3_temp_directory global variable out of the OS porting layer
drh [Fri, 30 Mar 2007 11:29:32 +0000 (11:29 +0000)] 
Move the sqlite3_temp_directory global variable out of the OS porting layer
and into main.c so that it is more accessible to non-standard OS porting
layers. (CVS 3759)

FossilOrigin-Name: 23653f7aab6609f69948a7366bef9ebd0fd4d0b1

18 years agoRemove the anonymous union from the sqlite3_value structure since some
drh [Fri, 30 Mar 2007 11:23:45 +0000 (11:23 +0000)] 
Remove the anonymous union from the sqlite3_value structure since some
compilers are unable to deal with it. (CVS 3758)

FossilOrigin-Name: 6b995259bc974519379dee55c1ef00d28c76bf21

18 years agoComment changes in btree.c and added a missing "else" in pragma.c. (CVS 3757)
drh [Fri, 30 Mar 2007 11:12:08 +0000 (11:12 +0000)] 
Comment changes in btree.c and added a missing "else" in pragma.c. (CVS 3757)

FossilOrigin-Name: 9a7d7e31908e9bac14a68bbc2fb4e1ca593ea234

18 years agoTest coverage a few extra lines in where.c. (CVS 3756)
danielk1977 [Fri, 30 Mar 2007 09:13:13 +0000 (09:13 +0000)] 
Test coverage a few extra lines in where.c. (CVS 3756)

FossilOrigin-Name: ea49ddf64aa6073b8018dc2faaf199704d359412

18 years agoExtra test cases to improve coverage of main.c. (CVS 3755)
danielk1977 [Fri, 30 Mar 2007 07:10:50 +0000 (07:10 +0000)] 
Extra test cases to improve coverage of main.c. (CVS 3755)

FossilOrigin-Name: 19fc3d78962d225d42372b9298be5921ec1fc8a1

18 years agoAssume any return code from fcntl() other than -1 is success. Formerly we
drh [Thu, 29 Mar 2007 20:19:58 +0000 (20:19 +0000)] 
Assume any return code from fcntl() other than -1 is success.  Formerly we
only assumed that 0 was success.  Ticket #2173. (CVS 3754)

FossilOrigin-Name: 8d0073c0e8408558dae39f789ac3fa2622b52365

18 years agoFix to token destructors in Lemon. This does not impact SQLite. Ticket #2175. ...
drh [Thu, 29 Mar 2007 20:13:53 +0000 (20:13 +0000)] 
Fix to token destructors in Lemon.  This does not impact SQLite.  Ticket #2175. (CVS 3753)

FossilOrigin-Name: 6195af49828bf04b61d24f116339780d3eb926a1

18 years agoAdd the sqlite3_clear_bindings() API to the loadable extension interface.
drh [Thu, 29 Mar 2007 18:46:00 +0000 (18:46 +0000)] 
Add the sqlite3_clear_bindings() API to the loadable extension interface.
Ticket #2135. (CVS 3752)

FossilOrigin-Name: 3111b43ec333f3342f9609bf441160040f3d1501

18 years agoBuffer updates per-transaction rather than per-update. If lots of
shess [Thu, 29 Mar 2007 18:41:03 +0000 (18:41 +0000)] 
Buffer updates per-transaction rather than per-update.  If lots of
updates happen within a single transaction, there was a lot of wasted
encode/decode overhead due to segment merges.  This code buffers
updates in memory and writes out larger level-0 segments.  It only
works when documents are presented in ascending order by docid.
Comparing a test set running 100 documents per transaction, the total
runtime is cut almost in half. (CVS 3751)

FossilOrigin-Name: 0229cba69698ab4b44f8583ef50a87c49422f8ec

18 years agoChange the name of PAGER_SECTOR_SIZE to SQLITE_DEFAULT_SECTOR_SIZE. Make
drh [Thu, 29 Mar 2007 18:19:52 +0000 (18:19 +0000)] 
Change the name of PAGER_SECTOR_SIZE to SQLITE_DEFAULT_SECTOR_SIZE.  Make
the new OS-layer interface routine for finding sector size optional. (CVS 3750)

FossilOrigin-Name: 0fb9af1d6e20bf25511c6d2097937cc11137776e