]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
16 years agoFix the shared_err.test script so that it works if the device supports SQLITE_IOCAP_S...
danielk1977 [Mon, 15 Sep 2008 14:42:38 +0000 (14:42 +0000)] 
Fix the shared_err.test script so that it works if the device supports SQLITE_IOCAP_SAFEAPPEND. (CVS 5699)

FossilOrigin-Name: 38e5ea070a38fe1656e0f5c3024f28ce67eae725

16 years agoModify test_async.c to avoid using internal SQLite APIs. There are still some comment...
danielk1977 [Mon, 15 Sep 2008 14:08:04 +0000 (14:08 +0000)] 
Modify test_async.c to avoid using internal SQLite APIs. There are still some comments that need updating. (CVS 5698)

FossilOrigin-Name: 1d4fcaafd058bf1b726378e9ec308ecd8130fe1b

16 years agoCheck if error code ENOTSUP is supported before using it. Ticket #3375. (CVS 5697)
danielk1977 [Mon, 15 Sep 2008 04:20:31 +0000 (04:20 +0000)] 
Check if error code ENOTSUP is supported before using it. Ticket #3375. (CVS 5697)

FossilOrigin-Name: c32cb106c5d68e98f51f1eaf9ae0e2a3c36d00d6

16 years agoFix issues with bizarrely quoted column names. Tickets #3370, #3371,
drh [Sat, 13 Sep 2008 01:20:14 +0000 (01:20 +0000)] 
Fix issues with bizarrely quoted column names.  Tickets #3370, #3371,
and #3372. (CVS 5696)

FossilOrigin-Name: ced6bbd228b4a324ddb9c5ff15fd027811c8806a

16 years agoFix the NEAR connector in FTS3 so that it can take ranges in excess of 9.
drh [Fri, 12 Sep 2008 18:25:30 +0000 (18:25 +0000)] 
Fix the NEAR connector in FTS3 so that it can take ranges in excess of 9.
The maximum range is now 32767. (CVS 5695)

FossilOrigin-Name: 8e9b9553115c42dae38cad0612d98d9a0c453a5c

16 years agoDeclare the isInterrupted field of the sqlite3 structure to be volatile.
drh [Fri, 12 Sep 2008 16:03:47 +0000 (16:03 +0000)] 
Declare the isInterrupted field of the sqlite3 structure to be volatile.
Ticket #3369. (CVS 5694)

FossilOrigin-Name: 414da4ebcecbed37177aecf649ddd3d258af260d

16 years agoAdd a case to permutations.test to run tests with the IOCAP_SAFEAPPEND property set...
danielk1977 [Fri, 12 Sep 2008 10:22:40 +0000 (10:22 +0000)] 
Add a case to permutations.test to run tests with the IOCAP_SAFEAPPEND property set. (CVS 5693)

FossilOrigin-Name: 80bdaafa77ec5c967f633eaaf5ee6f493a6e5a56

16 years agoAdd a couple of (fconfigure) commands to configure the incremental blob channels...
danielk1977 [Thu, 11 Sep 2008 11:27:59 +0000 (11:27 +0000)] 
Add a couple of (fconfigure) commands to configure the incremental blob channels used by test file incrblob.test. This is required so that the tests work on windows and other platforms that have a default -translation mode other than 'lf'. (CVS 5692)

FossilOrigin-Name: 753caa20ca50bc42d747d934ccc61438790e7f32

16 years agoFix a couple of problems with variable initializations picked up by stricter compiler...
danielk1977 [Thu, 11 Sep 2008 10:29:15 +0000 (10:29 +0000)] 
Fix a couple of problems with variable initializations picked up by stricter compilers. (CVS 5691)

FossilOrigin-Name: f4293d148007515eaf8eb9738f62554a963abe8e

16 years agoFix some trivial cases where database corruption was causing an error code other...
danielk1977 [Wed, 10 Sep 2008 17:53:35 +0000 (17:53 +0000)] 
Fix some trivial cases where database corruption was causing an error code other than SQLITE_CORRUPT to be returned. (CVS 5690)

FossilOrigin-Name: 89fda074f6b4959c32f1083badba3c73cffb4995

16 years agoFix for handling database files corrupted in such a was as to make a b-tree page...
danielk1977 [Wed, 10 Sep 2008 14:45:57 +0000 (14:45 +0000)] 
Fix for handling database files corrupted in such a was as to make a b-tree page a direct or indirect descendant of itself. (CVS 5689)

FossilOrigin-Name: 93545861a70c190d67b0d1effdd8fe038d28811c

16 years agoDocumentation updates: Describe recursion capabilities for the various
drh [Wed, 10 Sep 2008 13:09:23 +0000 (13:09 +0000)] 
Documentation updates:  Describe recursion capabilities for the various
callbacks. (CVS 5688)

FossilOrigin-Name: edd80811d702bc0d7a25199d193c04ea057df4de

16 years agoAvoid deleting a file while it is still open in corrupt2.test. Not all platforms...
danielk1977 [Wed, 10 Sep 2008 11:28:37 +0000 (11:28 +0000)] 
Avoid deleting a file while it is still open in corrupt2.test. Not all platforms support this. (CVS 5687)

FossilOrigin-Name: 099adfd31167a78d803e2992e5f50cf4e292dd43

16 years agoFix some test script details so that the test suite runs with an SQLITE_DEFAULT_AUTOV...
danielk1977 [Wed, 10 Sep 2008 10:57:27 +0000 (10:57 +0000)] 
Fix some test script details so that the test suite runs with an SQLITE_DEFAULT_AUTOVACUUM=2 build. (CVS 5686)

FossilOrigin-Name: 300a64b725a111ee66e38de099314f03b064c6eb

16 years agoAdd fuzz3.test. For testing the library's response to corrupted database files. ...
danielk1977 [Tue, 9 Sep 2008 18:28:06 +0000 (18:28 +0000)] 
Add fuzz3.test. For testing the library's response to corrupted database files. (CVS 5685)

FossilOrigin-Name: 7fd4dd95791974b0ef6cf30a186b32df25ee2211

16 years agoCalling sqlite3_create_function with nArg==(-1) does not override prior
drh [Tue, 9 Sep 2008 12:31:33 +0000 (12:31 +0000)] 
Calling sqlite3_create_function with nArg==(-1) does not override prior
calls on the same function name with nArg>=0.  Ticket #3345.  Add the
new -argcount option to the "function" method in the TCL interface. (CVS 5684)

FossilOrigin-Name: 5aa5b8044a14f59559c1839dc0799b0d2f990809

16 years agoFix a C++ism in pager.c (variable useAtomicWrite not declard at the top of its scope...
danielk1977 [Mon, 8 Sep 2008 15:35:06 +0000 (15:35 +0000)] 
Fix a C++ism in pager.c (variable useAtomicWrite not declard at the top of its scope). (CVS 5683)

FossilOrigin-Name: a6dee85b823355cb381163c93c8366aa4395ae6a

16 years agoFix a bug in r-tree related to internal nodes with one or more dimensions of size...
danielk1977 [Mon, 8 Sep 2008 11:07:03 +0000 (11:07 +0000)] 
Fix a bug in r-tree related to internal nodes with one or more dimensions of size zero. Ticket #3363. (CVS 5682)

FossilOrigin-Name: 8b600ed083d48784df4b1da1320a01bebbf233d7

16 years agoIf the 'rootpage' column of the sqlite_master table contains a NULL value, return...
danielk1977 [Mon, 8 Sep 2008 09:06:18 +0000 (09:06 +0000)] 
If the 'rootpage' column of the sqlite_master table contains a NULL value, return SQLITE_CORRUPT to the caller. (CVS 5681)

FossilOrigin-Name: a7b7b126e9e9b0cd2d68643d8dff321cf41ce2ee

16 years agoAdd header file sqliteicu.h to the ICU extension. This is analogous to the rtree...
danielk1977 [Mon, 8 Sep 2008 08:08:09 +0000 (08:08 +0000)] 
Add header file sqliteicu.h to the ICU extension. This is analogous to the rtree.h and fts3.h headers used by other extensions to declare their entry points. Fix for ticket #3361. (CVS 5680)

FossilOrigin-Name: 79364b963b348d5433da737b4e21e97952882389

16 years agoDeallocate a temp register allocated by codeEqualityTerm() in where.c. If it is not...
danielk1977 [Sat, 6 Sep 2008 14:19:11 +0000 (14:19 +0000)] 
Deallocate a temp register allocated by codeEqualityTerm() in where.c. If it is not deallocated, its value may be reused by the column-cache mechanism. However, by the time it is used, the value may have been clobbered by a sub-routine that also uses the same temp register. Fix for #3357. (CVS 5679)

FossilOrigin-Name: 7c0f638ef3d7ff9156f07d6fb01448453ffcf5ac

16 years agoChange pcache.test so that it works if sqlite is configured to create auto-vacuum...
danielk1977 [Fri, 5 Sep 2008 05:29:08 +0000 (05:29 +0000)] 
Change pcache.test so that it works if sqlite is configured to create auto-vacuum databases by default. (CVS 5678)

FossilOrigin-Name: 55e677569ec131c388841f6f453291f737738076

16 years agoFix a problem in btree.c preventing an OOM error from being propagated up to the...
danielk1977 [Fri, 5 Sep 2008 05:02:46 +0000 (05:02 +0000)] 
Fix a problem in btree.c preventing an OOM error from being propagated up to the caller. (CVS 5677)

FossilOrigin-Name: 0b8ee83f2ebadab099ccd6490f6995949dafdd6f

16 years agoAdd support for the SQLITE_THREADSAFE=2 and SQLITE_DEFAULT_MEMSTATUS compilation...
danielk1977 [Thu, 4 Sep 2008 17:17:38 +0000 (17:17 +0000)] 
Add support for the SQLITE_THREADSAFE=2 and SQLITE_DEFAULT_MEMSTATUS compilation options. (CVS 5676)

FossilOrigin-Name: 85c2a58901338c1c4652c2cbee51e5f48d289191

16 years agoMissing implementation for sqlite3TransferBindings(). (CVS 5675)
shane [Thu, 4 Sep 2008 12:03:42 +0000 (12:03 +0000)] 
Missing implementation for sqlite3TransferBindings(). (CVS 5675)

FossilOrigin-Name: 56d618957571f65e88375aad34a6e7dcf22508e1

16 years agoIf SQLITE_ENABLE_LOCKING_STYLE is defined, have the os_unix.c module offer the follow...
danielk1977 [Thu, 4 Sep 2008 06:22:25 +0000 (06:22 +0000)] 
If SQLITE_ENABLE_LOCKING_STYLE is defined, have the os_unix.c module offer the following extra VFS implementations for explicitly selecting a locking-style: "unix-none", "unix-afp", "unix-posix", "unix-flock" and "unix-dotfile". (CVS 5674)

FossilOrigin-Name: 6e8fb64639cc7451005d9f1dd2d0ef62576abbdd

16 years agoTemporarily revert to using sqlite3_transfer_bindings() internally. (CVS 5673)
danielk1977 [Thu, 4 Sep 2008 05:53:44 +0000 (05:53 +0000)] 
Temporarily revert to using sqlite3_transfer_bindings() internally. (CVS 5673)

FossilOrigin-Name: 690ff3853b4e46ac7126992c84455237e265fd98

16 years agoModified core to not call deprecated functions sqlite3_memory_alarm() and sqlite3_tra...
shane [Thu, 4 Sep 2008 04:32:49 +0000 (04:32 +0000)] 
Modified core to not call deprecated functions sqlite3_memory_alarm() and sqlite3_transfer_bindings() by adding sqlite3MemoryAlarm() and sqlite3TransferBindings().  sqlite3_memory_alarm() and sqlite3_transfer_bindings() are now simple wrappers for the new functions.  In prep for adding SQLITE_OMIT_DEPRECATED. (CVS 5672)

FossilOrigin-Name: 821c387d159fd86cedb56c1130f0416bf5c65e6c

16 years agoWork around an issue with the WINSCW compiler. (CVS 5671)
drh [Wed, 3 Sep 2008 17:11:16 +0000 (17:11 +0000)] 
Work around an issue with the WINSCW compiler. (CVS 5671)

FossilOrigin-Name: e333c3f4c3629dba05b58318e2cd0514843e5394

16 years agoMake the default threading mode multithread (-nomutex) in the TCL interface. (CVS...
drh [Wed, 3 Sep 2008 01:08:00 +0000 (01:08 +0000)] 
Make the default threading mode multithread (-nomutex) in the TCL interface. (CVS 5670)

FossilOrigin-Name: d9e826942673ad048d611c014bfbee39ab5535c8

16 years agoAdd support for SQLITE_OPEN_FULLMUTEX. (CVS 5669)
drh [Wed, 3 Sep 2008 00:43:15 +0000 (00:43 +0000)] 
Add support for SQLITE_OPEN_FULLMUTEX. (CVS 5669)

FossilOrigin-Name: f2f361a5e2fb81fb0f99e83ecf8bae9a750723b1

16 years agoIf a rollback fails, mark the database as corrupt. (CVS 5668)
drh [Wed, 3 Sep 2008 00:08:29 +0000 (00:08 +0000)] 
If a rollback fails, mark the database as corrupt. (CVS 5668)

FossilOrigin-Name: c8b24bd1be94b6d385e759a2f9e202be066578a0

16 years agoAPI documentation updates for threading mode. (CVS 5667)
drh [Tue, 2 Sep 2008 21:35:03 +0000 (21:35 +0000)] 
API documentation updates for threading mode. (CVS 5667)

FossilOrigin-Name: fa237c14c8551315ea8f239e89a81b7725675c81

16 years agoExplicitly initialize at least the first field of every struct. This is to work aroun...
danielk1977 [Tue, 2 Sep 2008 17:52:51 +0000 (17:52 +0000)] 
Explicitly initialize at least the first field of every struct. This is to work around compilers that don't like the syntax "struct XXX { ... } yyy = {};". (CVS 5666)

FossilOrigin-Name: 88bfdc87471e65ac5a262a794b8cdf3e563eb327

16 years agoFix the position of the SQLITE_WSD macro in the declaration of global variable vfsLis...
danielk1977 [Tue, 2 Sep 2008 17:18:51 +0000 (17:18 +0000)] 
Fix the position of the SQLITE_WSD macro in the declaration of global variable vfsList. (CVS 5665)

FossilOrigin-Name: e869446119724b9b1568b1f8e56e9f29ff6d3816

16 years agoFine tune the hard-coded values passed to sqlite3_init_wsd(). (CVS 5664)
danielk1977 [Tue, 2 Sep 2008 16:22:28 +0000 (16:22 +0000)] 
Fine tune the hard-coded values passed to sqlite3_init_wsd(). (CVS 5664)

FossilOrigin-Name: af5763eb65baa791a38f7e235624e4f63beac104

16 years agoAdd an extra 'const' qualifier to two arrays (in func.c and pragma.c) to ensure that...
danielk1977 [Tue, 2 Sep 2008 15:44:08 +0000 (15:44 +0000)] 
Add an extra 'const' qualifier to two arrays (in func.c and pragma.c) to ensure that they do not consume space in the data segment of the compiled object files. (CVS 5663)

FossilOrigin-Name: 43f757c9f01ccc6e6c7a404fbeb74f825f7a29ca

16 years agoMove the sqlite3SharedCacheEnabled global and the inProgress static variable (functio...
danielk1977 [Tue, 2 Sep 2008 14:07:24 +0000 (14:07 +0000)] 
Move the sqlite3SharedCacheEnabled global and the inProgress static variable (function sqlite3_initialize()) into the global sqlite3Config structure. This is required for the OMIT_WSD feature to work on some platforms. (CVS 5662)

FossilOrigin-Name: 88c82759946910b5ffdd5febc17356403f986c2e

16 years agoAdd a 'const' to the opcodeProperty array in vdbe.c. (CVS 5661)
danielk1977 [Tue, 2 Sep 2008 11:05:01 +0000 (11:05 +0000)] 
Add a 'const' to the opcodeProperty array in vdbe.c. (CVS 5661)

FossilOrigin-Name: 29c9a80294398a349bc7cf0fb84cd4ef8a9e2f60

16 years agoChange some more global variables to work with OMIT_WSD. (CVS 5660)
danielk1977 [Tue, 2 Sep 2008 10:22:00 +0000 (10:22 +0000)] 
Change some more global variables to work with OMIT_WSD. (CVS 5660)

FossilOrigin-Name: 46acaf58e11ebe69e4fb5f171d3ee29f056d8e68

16 years agoModify pcache.c to work with OMIT_WSD. (CVS 5659)
danielk1977 [Tue, 2 Sep 2008 09:38:06 +0000 (09:38 +0000)] 
Modify pcache.c to work with OMIT_WSD. (CVS 5659)

FossilOrigin-Name: 44def90d1bd4e37ab162e16f83e23d32e86b78ab

16 years agoContinuing work on adding full support for the SQLITE_OMIT_WSD
drh [Tue, 2 Sep 2008 00:52:52 +0000 (00:52 +0000)] 
Continuing work on adding full support for the SQLITE_OMIT_WSD
compile-time option. (CVS 5658)

FossilOrigin-Name: ef26ea5c46d3915d206f8ff7f82a24f4c8955f1f

16 years agoAdd define for INVALID_FILE_ATTRIBUTES if it is not already defined, as some older...
shane [Mon, 1 Sep 2008 22:15:18 +0000 (22:15 +0000)] 
Add define for INVALID_FILE_ATTRIBUTES if it is not already defined, as some older Windows compilers do not define it. (CVS 5657)

FossilOrigin-Name: e0461f8755daa9f57e056810de9ea347ff8dd986

16 years agoAdded (_MSC_VER>1200) to SQLITE_DEPRECATED and SQLITE_EXPERIMENTAL defines since...
shane [Mon, 1 Sep 2008 22:06:23 +0000 (22:06 +0000)] 
Added  (_MSC_VER>1200) to SQLITE_DEPRECATED and SQLITE_EXPERIMENTAL defines since __declspec(deprecated) isn't supported by VC 6 or earlier.  Ticket #3347. (CVS 5656)

FossilOrigin-Name: 4bcaed08a1b50aef9f4f8a447a35d8678df92050

16 years agoOmit prototype for and calls to sqlite3MaterializeView() if !defined(SQLITE_OMIT_VIE...
shane [Mon, 1 Sep 2008 21:59:42 +0000 (21:59 +0000)] 
Omit prototype for and calls to sqlite3MaterializeView() if  !defined(SQLITE_OMIT_VIEW) && !defined(SQLITE_OMIT_TRIGGER). (CVS 5655)

FossilOrigin-Name: 9cf484fc17944ffa14335e391112d82d2390d116

16 years agoConverted strcasecmp to sqlite3StrICmp. Test code only. (CVS 5654)
shane [Mon, 1 Sep 2008 20:38:12 +0000 (20:38 +0000)] 
Converted strcasecmp to sqlite3StrICmp.  Test code only. (CVS 5654)

FossilOrigin-Name: bdeefe37602f8b0cd7c63a8c1e52de319cc51bea

16 years agoModify the aBuiltinFunc array in func.c to use the WSD macros. (CVS 5653)
danielk1977 [Mon, 1 Sep 2008 19:14:02 +0000 (19:14 +0000)] 
Modify the aBuiltinFunc array in func.c to use the WSD macros. (CVS 5653)

FossilOrigin-Name: 846fff5f0902418cfce2915d2ccfe567481a1289

16 years agoBegin adding support for the SQLITE_OMIT_WSD macro. Some (many) WSD variables still...
danielk1977 [Mon, 1 Sep 2008 18:34:20 +0000 (18:34 +0000)] 
Begin adding support for the SQLITE_OMIT_WSD macro. Some (many) WSD variables still need wrappers added to them. (CVS 5652)

FossilOrigin-Name: 573d92abb9adb1c321ebc2fcadcf14374213b093

16 years agoRemove an unused function declaration from a header file. Ticket #3349. (CVS 5651)
drh [Mon, 1 Sep 2008 17:23:29 +0000 (17:23 +0000)] 
Remove an unused function declaration from a header file.  Ticket #3349. (CVS 5651)

FossilOrigin-Name: 7a577428b22918c232815e7998a623dbc47a8d41

16 years agoDefer deleting Table objects associated with flattened subqueries until
drh [Mon, 1 Sep 2008 15:52:10 +0000 (15:52 +0000)] 
Defer deleting Table objects associated with flattened subqueries until
all code has been generated, in case some expression node still references
the Table object.  Ticket #3346. (CVS 5650)

FossilOrigin-Name: d04d70336727a0db959c672e6c22cdaa0505dce5

16 years agoHave the rtree module set the estimatedCost output variable. Ticket #3312. (CVS 5649)
danielk1977 [Mon, 1 Sep 2008 12:46:59 +0000 (12:46 +0000)] 
Have the rtree module set the estimatedCost output variable. Ticket #3312. (CVS 5649)

FossilOrigin-Name: 483932c4e08901a11b7ab671073fd0a048b10d66

16 years agoChanged to used sqlite3_snprintf instead of snprintf (test code only). (CVS 5648)
shane [Sun, 31 Aug 2008 00:29:08 +0000 (00:29 +0000)] 
Changed to used sqlite3_snprintf instead of snprintf (test code only). (CVS 5648)

FossilOrigin-Name: d68791e35d13f5ae4befeb0bb5f8ccaf14fd3763

16 years agoVersion 3.6.2 (CVS 5647)
drh [Sat, 30 Aug 2008 16:34:19 +0000 (16:34 +0000)] 
Version 3.6.2 (CVS 5647)

FossilOrigin-Name: 88c51b9f1579707a8ec394eba61539fabd725e2a

16 years agoRun permutation subtests in sorted order. (CVS 5646)
drh [Sat, 30 Aug 2008 16:07:03 +0000 (16:07 +0000)] 
Run permutation subtests in sorted order. (CVS 5646)

FossilOrigin-Name: 4cd1bdf3ce8077e10dcd8ae4fe2df0dd9bb0f56b

16 years agoAdd some code to permutations.test to make sure no test file modifies the shared...
danielk1977 [Sat, 30 Aug 2008 13:25:10 +0000 (13:25 +0000)] 
Add some code to permutations.test to make sure no test file modifies the shared-cache setting. (CVS 5645)

FossilOrigin-Name: 8565b7c66525dc7808a2a266deb1a0d995c99917

16 years agoMake sure thread003.test waits for all spawned threads to finish before continuing...
danielk1977 [Sat, 30 Aug 2008 09:10:16 +0000 (09:10 +0000)] 
Make sure thread003.test waits for all spawned threads to finish before continuing. (CVS 5644)

FossilOrigin-Name: 87c7e82f54cd446721d553d5c48ca2571b063669

16 years agoremove private declaration of sqlite3_snprintf() in sqliteInt.h as there is already...
rse [Fri, 29 Aug 2008 18:42:30 +0000 (18:42 +0000)] 
remove private declaration of sqlite3_snprintf() in sqliteInt.h as there is already a public declaration in sqlite3.h (CVS 5643)

FossilOrigin-Name: 4113e778be7a1e3e7a67583913e137c66d88a190

16 years agoremove a doubled function declaration (the second just is just two lines below) ...
rse [Fri, 29 Aug 2008 18:40:15 +0000 (18:40 +0000)] 
remove a doubled function declaration (the second just is just two lines below) (CVS 5642)

FossilOrigin-Name: e5793110d5e3b8bc4d139fc21f0962ccd48cf10c

16 years agoMove a call to sqlite3_mutex_leave() to protect calls to sqlite3StatusAdd() related...
danielk1977 [Fri, 29 Aug 2008 17:56:12 +0000 (17:56 +0000)] 
Move a call to sqlite3_mutex_leave() to protect calls to sqlite3StatusAdd() related to scratch (SQLITE_CONFIG_SCRATCH) memory. (CVS 5641)

FossilOrigin-Name: 4e011ddf9e483e3f7c7427205e50f7c3e5616790

16 years agoModify tclsqlite.test so that it works reliably with tcl 8.5.4. (CVS 5640)
danielk1977 [Fri, 29 Aug 2008 15:54:56 +0000 (15:54 +0000)] 
Modify tclsqlite.test so that it works reliably with tcl 8.5.4. (CVS 5640)

FossilOrigin-Name: 790d329f5d18d361a5d6d34f46c269f8b4057cd9

16 years agoIn permutations.test, disable tests that depend on soft-heap-limit functionality...
danielk1977 [Fri, 29 Aug 2008 12:00:20 +0000 (12:00 +0000)] 
In permutations.test, disable tests that depend on soft-heap-limit functionality when running the memsubsys2 variant. It disables the soft-heap-limit. (CVS 5639)

FossilOrigin-Name: 047c7bdb9f37462c462071334f1cb9d3400917db

16 years agoIf a page is made eligible for recycling when more than the configured maximum number...
danielk1977 [Fri, 29 Aug 2008 09:10:02 +0000 (09:10 +0000)] 
If a page is made eligible for recycling when more than the configured maximum number of pages are allocated, free it immediately instead of adding it to the LRU list. (CVS 5638)

FossilOrigin-Name: 4b12922dcb4547bf3a7276d0542b2e1d12ad338d

16 years agoAvoid reevaluating WHERE and ORDER BY expressions that alias terms in the
drh [Fri, 29 Aug 2008 02:14:02 +0000 (02:14 +0000)] 
Avoid reevaluating WHERE and ORDER BY expressions that alias terms in the
result set.  Ticket #3343.  Note that aliased GROUP BY expressions are still
evaluated twice. (CVS 5637)

FossilOrigin-Name: ab0292caa5887cc1bdc0e8c9d3f3502b83975440

16 years agoFix ioerr5.test so that it works with the new pcache module. (CVS 5636)
danielk1977 [Thu, 28 Aug 2008 18:35:34 +0000 (18:35 +0000)] 
Fix ioerr5.test so that it works with the new pcache module. (CVS 5636)

FossilOrigin-Name: 83e6a75e7d70b4b01f0892924d7a8a49d5ef6bf2

16 years agoPartial fix for a bug in recovery from xStress failures in pcache. (CVS 5635)
drh [Thu, 28 Aug 2008 17:46:18 +0000 (17:46 +0000)] 
Partial fix for a bug in recovery from xStress failures in pcache. (CVS 5635)

FossilOrigin-Name: 44193b92770062271711570d8532fa5af5f5da54

16 years agoAvoid using (clock seconds) in thread003.test. It is not available if testfixture...
danielk1977 [Thu, 28 Aug 2008 13:55:10 +0000 (13:55 +0000)] 
Avoid using (clock seconds) in thread003.test. It is not available if testfixture is linked to tcl 8.5. (CVS 5634)

FossilOrigin-Name: b606263d0868aed267bcec623b9fe4d142099145

16 years agoUse ckfree() instead of sqlite3_free() to free an allocation made by ckalloc() in...
danielk1977 [Thu, 28 Aug 2008 13:15:49 +0000 (13:15 +0000)] 
Use ckfree() instead of sqlite3_free() to free an allocation made by ckalloc() in test_thread.c (test code only). (CVS 5633)

FossilOrigin-Name: 677ac144c8f7e2722fdf05da1431919d6a8bb45f

16 years agoFix mutex related bug in pcache.c to do with handling IO errors. (CVS 5632)
danielk1977 [Thu, 28 Aug 2008 11:12:09 +0000 (11:12 +0000)] 
Fix mutex related bug in pcache.c to do with handling IO errors. (CVS 5632)

FossilOrigin-Name: 5e304fed275137f98be56f475504422d1f5113a4

16 years agoEnable the disabled asserts added by (5629). Add extra tests to thread003.test. And...
danielk1977 [Thu, 28 Aug 2008 10:21:16 +0000 (10:21 +0000)] 
Enable the disabled asserts added by (5629). Add extra tests to thread003.test. And the required modifications to pcache.c. (CVS 5631)

FossilOrigin-Name: 473c09fac22ed2f56ea86150a60b9f0f2263c889

16 years agoFix a threads/mutex problem in pcache.c. (CVS 5630)
danielk1977 [Thu, 28 Aug 2008 08:31:48 +0000 (08:31 +0000)] 
Fix a threads/mutex problem in pcache.c. (CVS 5630)

FossilOrigin-Name: 1928f15b78eee0fbf0a8ecdbbdd38dbbde2942b8

16 years agoMiscellaneous cleanup in the new pcache code. (CVS 5629)
drh [Thu, 28 Aug 2008 02:26:07 +0000 (02:26 +0000)] 
Miscellaneous cleanup in the new pcache code. (CVS 5629)

FossilOrigin-Name: da1777259f53c2e20c7ced06bf6f2a550f0ea0fc

16 years agoIf any error occurs during sqlite3_open(), move the database handle into "sick" state...
danielk1977 [Wed, 27 Aug 2008 19:01:57 +0000 (19:01 +0000)] 
If any error occurs during sqlite3_open(), move the database handle into "sick" state. When in the sick state the user can use sqlite3_errcode() and sqlite3_errmsg(), but not much else. (CVS 5628)

FossilOrigin-Name: ce9c74eaab459ddde213c828e821940f5d6cb354

16 years agoAdd the trans2.test script designed to stress statement rollback and
drh [Wed, 27 Aug 2008 18:56:36 +0000 (18:56 +0000)] 
Add the trans2.test script designed to stress statement rollback and
no-write optimizations on large transactions with a small cache. (CVS 5627)

FossilOrigin-Name: 39c34e2238c27b2a2f4f0b896126ccbd299114c5

16 years agoDo not mark pages as clean when doing a statement journal rollback. (CVS 5626)
drh [Wed, 27 Aug 2008 18:03:20 +0000 (18:03 +0000)] 
Do not mark pages as clean when doing a statement journal rollback. (CVS 5626)

FossilOrigin-Name: 9d7722f4f357b96c37f950024f1e7e160e2c1252

16 years agoModifications to malloc5.test to account for the fact that sqlite3_release_memory...
danielk1977 [Wed, 27 Aug 2008 16:38:56 +0000 (16:38 +0000)] 
Modifications to malloc5.test to account for the fact that sqlite3_release_memory() no longer reclaims dirty pages. (CVS 5625)

FossilOrigin-Name: b01c65b065c62e3dd71e88866a953668b5e2f25f

16 years agoClear the $result variable prior to using it in corrupt2.test. (CVS 5624)
drh [Wed, 27 Aug 2008 16:14:20 +0000 (16:14 +0000)] 
Clear the $result variable prior to using it in corrupt2.test. (CVS 5624)

FossilOrigin-Name: 12f2d24f88e55d170dd7750e7904ff14e84e820e

16 years agoIn the test logic: load the md5sum() SQL function as a separate
drh [Wed, 27 Aug 2008 15:21:33 +0000 (15:21 +0000)] 
In the test logic: load the md5sum() SQL function as a separate
autoloaded extension. (CVS 5623)

FossilOrigin-Name: d4438251dd66c4168e09eb421a8c2081228357dd

16 years agoUse a bitvec object to store the set of pages with the 'always-rollback' property...
danielk1977 [Wed, 27 Aug 2008 15:16:33 +0000 (15:16 +0000)] 
Use a bitvec object to store the set of pages with the 'always-rollback' property for a transaction. (CVS 5622)

FossilOrigin-Name: 9e9325997e11a0368721ed7860f4c37de3502a9b

16 years agoRemove obsolete file: md5.c. This file had been removed years ago. It is
drh [Wed, 27 Aug 2008 13:31:09 +0000 (13:31 +0000)] 
Remove obsolete file: md5.c.  This file had been removed years ago.  It is
unclear how it got back into the repository. (CVS 5621)

FossilOrigin-Name: 45fc70bd9264d5bcd72c97017079ced4aac7729f

16 years agoRemove unreachable branches from pcache.c. (CVS 5620)
danielk1977 [Wed, 27 Aug 2008 09:44:39 +0000 (09:44 +0000)] 
Remove unreachable branches from pcache.c. (CVS 5620)

FossilOrigin-Name: 7de32498b349e046c5c886de255bbdefd6a7e8f7

16 years agoFix an issue with the permutation test script. (CVS 5619)
drh [Tue, 26 Aug 2008 23:08:04 +0000 (23:08 +0000)] 
Fix an issue with the permutation test script. (CVS 5619)

FossilOrigin-Name: 2e12aa3e078c0da9e418ff1f25a08f05cd03c07d

16 years agoIn the TCL interface, disable the authorizer when during a BEGIN, COMMIT,
drh [Tue, 26 Aug 2008 21:33:34 +0000 (21:33 +0000)] 
In the TCL interface, disable the authorizer when during a BEGIN, COMMIT,
or ROLLBACK associated with the transaction method. Ticket #3336. (CVS 5618)

FossilOrigin-Name: 7e1032ab0031ba535f37b6338a3ac81cb1449d76

16 years agoAll the page_size pragma to change the page size on a new :memory: database,
drh [Tue, 26 Aug 2008 21:07:26 +0000 (21:07 +0000)] 
All the page_size pragma to change the page size on a new :memory: database,
but not a vacuumed :memory: database.  Ticket #3335 (CVS 5617)

FossilOrigin-Name: 226a9056783247679fcf442e10807a1f2707f463

16 years agoDisable some very expensive asserts in pcache.c that are too slow for all.test. ...
danielk1977 [Tue, 26 Aug 2008 19:07:59 +0000 (19:07 +0000)] 
Disable some very expensive asserts in pcache.c that are too slow for all.test. (CVS 5616)

FossilOrigin-Name: 555dad900fad874099556d44c464ea9f64687ca0

16 years agoSimplify the pcache module by only recycling clean pages from 'other' caches. This...
danielk1977 [Tue, 26 Aug 2008 18:05:48 +0000 (18:05 +0000)] 
Simplify the pcache module by only recycling clean pages from 'other' caches. This commit causes errors in test files ioerr5.test and malloc5.test because they test recycling dirty pages from other caches. (CVS 5615)

FossilOrigin-Name: 9e511e161bcb077450d31fca5dd20c2557f103b3

16 years agoImplement a "counter" SQL function that can be used to insert a sequence
drh [Tue, 26 Aug 2008 14:42:14 +0000 (14:42 +0000)] 
Implement a "counter" SQL function that can be used to insert a sequence
number each row of a result set.  Currently in the test harness only, but
a candidate to move into the core. (CVS 5614)

FossilOrigin-Name: c84d46c71233bbf869513f433b1d18cbd7f2a35e

16 years agoDo not flatten subqueries where the subquery has a LIMIT and the outer
drh [Tue, 26 Aug 2008 12:56:14 +0000 (12:56 +0000)] 
Do not flatten subqueries where the subquery has a LIMIT and the outer
query has a WHERE clause.  Ticket #3334. (CVS 5613)

FossilOrigin-Name: 4995a1d1c9530be9ce647d338169620cd95a72eb

16 years agoAdd the SQLITE_OPEN_FULLMUTEX definition to sqlite3.h. It currently is not
drh [Mon, 25 Aug 2008 21:23:01 +0000 (21:23 +0000)] 
Add the SQLITE_OPEN_FULLMUTEX definition to sqlite3.h.  It currently is not
valid for anything.  This is merely to reserve the number. (CVS 5612)

FossilOrigin-Name: 3b6ffb4492b6c43897692c49dcccbfb55963a46c

16 years agoFix obscure permutation test problems. (CVS 5611)
drh [Mon, 25 Aug 2008 19:09:01 +0000 (19:09 +0000)] 
Fix obscure permutation test problems. (CVS 5611)

FossilOrigin-Name: aa92a1bec3d6bbcc59680ba13fed51ada9249d4c

16 years agoFix bug in the premutation testing that was causing many permutations from
drh [Mon, 25 Aug 2008 17:23:29 +0000 (17:23 +0000)] 
Fix bug in the premutation testing that was causing many permutations from
begin skipped.  There are now 16 errors reported by the permutation test. (CVS 5610)

FossilOrigin-Name: 4ad096bda1fc5c7b66f71ff5b32a4085c9a40574

16 years agoPick up a small performance increase by eliminating the pcacheRef() function. (CVS...
danielk1977 [Mon, 25 Aug 2008 14:49:42 +0000 (14:49 +0000)] 
Pick up a small performance increase by eliminating the pcacheRef() function. (CVS 5609)

FossilOrigin-Name: e3840fbf0adf824941a4b9b3cac3a869f195d6f8

16 years agoAdditional coverage testing in the new name resolver module. (CVS 5608)
drh [Mon, 25 Aug 2008 12:14:08 +0000 (12:14 +0000)] 
Additional coverage testing in the new name resolver module. (CVS 5608)

FossilOrigin-Name: 0d61960afd35721d6d07acd75288c20d2cd6fda1

16 years agoTwo if statements should be asserts. GCC was silently ignoring them,
drh [Mon, 25 Aug 2008 12:08:22 +0000 (12:08 +0000)] 
Two if statements should be asserts.  GCC was silently ignoring them,
hence the problem did not show up in coverage testing.
Ticket #3333. (CVS 5607)

FossilOrigin-Name: 635933b1cae6c43656260555089952e2925c3292

16 years agoFix a segfault that can occur when running integrity_check on a corrupt db. (CVS...
danielk1977 [Mon, 25 Aug 2008 11:57:16 +0000 (11:57 +0000)] 
Fix a segfault that can occur when running integrity_check on a corrupt db. (CVS 5606)

FossilOrigin-Name: eae959ede1b2b50190c60de9249cf141c3031ce2

16 years agoIf the sector size is greater than the database page size, SQLite journals all pages...
danielk1977 [Mon, 25 Aug 2008 07:12:28 +0000 (07:12 +0000)] 
If the sector size is greater than the database page size, SQLite journals all pages that lie within a sector before writing to any of them. This change ensure that a journal sync does not occur halfway through journalling the set of pages that belong to a single sector. (CVS 5605)

FossilOrigin-Name: 16f612d61e00938f29ecae4ebfe598be7a8709a8

16 years agoInstead of marking a page as clean when sqlite3PagerDontWrite() is called, set a...
danielk1977 [Sat, 23 Aug 2008 18:53:08 +0000 (18:53 +0000)] 
Instead of marking a page as clean when sqlite3PagerDontWrite() is called, set a dedictated flag - PGHDR_DONT_WRITE. (CVS 5604)

FossilOrigin-Name: a323bd29a600abddbcc2cc9961ab84d82cccc5e5

16 years agoDo not incorrectly detect corruption when an auto-vacuum database is converted to...
danielk1977 [Sat, 23 Aug 2008 16:17:55 +0000 (16:17 +0000)] 
Do not incorrectly detect corruption when an auto-vacuum database is converted to a non-auto-vacuum database within a vacuum. Ticket #3332. (CVS 5603)

FossilOrigin-Name: cb869946d68f2abbd1322fababbe4aa74a4e08aa

16 years agoquieting compiler warning about pointer/int conversion size mismatch (CVS 5602)
aswift [Fri, 22 Aug 2008 18:41:37 +0000 (18:41 +0000)] 
quieting compiler warning about pointer/int conversion size mismatch (CVS 5602)

FossilOrigin-Name: f8a70501c234545b3030144ac6bcbfaa0d2b0069

16 years agoRemove dead code. (CVS 5601)
drh [Fri, 22 Aug 2008 17:34:45 +0000 (17:34 +0000)] 
Remove dead code. (CVS 5601)

FossilOrigin-Name: 6de9c084fc533fbb22af6a4cd3e4e9a461b13876

16 years agoadd legacy.lo back (in alphabetical order) (CVS 5600)
pweilbacher [Fri, 22 Aug 2008 17:28:45 +0000 (17:28 +0000)] 
add legacy.lo back (in alphabetical order) (CVS 5600)

FossilOrigin-Name: a861aa73c4913c468315e6b5c5a2706150082280