]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
17 years agoMake sure aggregate functions can take any number of arguments up to the
drh [Wed, 18 Jun 2008 15:34:09 +0000 (15:34 +0000)] 
Make sure aggregate functions can take any number of arguments up to the
limit imposed by SQLITE_LIMIT_FUNCTION_ARGS.  Ticket #3179.  Modify
the group_concat() function to take an unlimited number of arguments in
order to facilitate testing this behavior. (CVS 5233)

FossilOrigin-Name: 70c6739f4e84b3433e14960346b54d0e9e0bb9c6

17 years agoAdd documentation on the sqlite3_mutex_methods object. (CVS 5232)
drh [Wed, 18 Jun 2008 13:47:03 +0000 (13:47 +0000)] 
Add documentation on the sqlite3_mutex_methods object. (CVS 5232)

FossilOrigin-Name: c3c7bfc9db6774824be14a1394e1842716dce8ec

17 years agoAdded new configuration options to query the low-level malloc interface
drh [Wed, 18 Jun 2008 13:27:46 +0000 (13:27 +0000)] 
Added new configuration options to query the low-level malloc interface
and to provide memory buffers for scratch, page-cache, and heap memory
allocators. (CVS 5231)

FossilOrigin-Name: e36201a352f832c97c5c0fcb872c1f094cac03d2

17 years agoAdd some test infrastructure and cases for the new mutex api. (CVS 5230)
danielk1977 [Wed, 18 Jun 2008 09:45:56 +0000 (09:45 +0000)] 
Add some test infrastructure and cases for the new mutex api. (CVS 5230)

FossilOrigin-Name: 262baee9952b28afe5dc77eb7365ebb11a480906

17 years agoRemove mem3.c and mem5.c from the amalgamation for the time being, since
drh [Wed, 18 Jun 2008 02:01:07 +0000 (02:01 +0000)] 
Remove mem3.c and mem5.c from the amalgamation for the time being, since
they do not currently work.  We will add them back later once they are fixed. (CVS 5229)

FossilOrigin-Name: 39b4e1ff4e3db3278c35eff10bbabdf4d87793a4

17 years agoAdd the SQLITE_CONFIG_MUTEX symbol for use with sqlite3_config(). (CVS 5228)
danielk1977 [Tue, 17 Jun 2008 18:57:49 +0000 (18:57 +0000)] 
Add the SQLITE_CONFIG_MUTEX symbol for use with sqlite3_config(). (CVS 5228)

FossilOrigin-Name: af1835bb5f5e3fb78d782c7c287e20db169e883f

17 years agoChange the mutex interface to be pluggable. This is an incremental checkin, there...
danielk1977 [Tue, 17 Jun 2008 17:21:18 +0000 (17:21 +0000)] 
Change the mutex interface to be pluggable. This is an incremental checkin, there are still changes to come. (CVS 5227)

FossilOrigin-Name: 597283637bcdc2398bf249b2bbc6ded47ad2de22

17 years agoAdd internal interfaces: PageMalloc/PageFree and ScratchMalloc/ScratchFree. (CVS...
drh [Tue, 17 Jun 2008 15:12:00 +0000 (15:12 +0000)] 
Add internal interfaces:  PageMalloc/PageFree and ScratchMalloc/ScratchFree. (CVS 5226)

FossilOrigin-Name: 3e797d0ffe1af6f7512b3fb7b387418ac05671e0

17 years agoDo not allow a VACUUM to try to change the page_size on an encrypted database. (CVS...
drh [Tue, 17 Jun 2008 01:03:25 +0000 (01:03 +0000)] 
Do not allow a VACUUM to try to change the page_size on an encrypted database. (CVS 5225)

FossilOrigin-Name: d49e5020019093a5b8a4fbe09caeb84ecb538629

17 years agoClean up obfuscated code in sqlite3_table_column_meta_data().
drh [Mon, 16 Jun 2008 20:51:15 +0000 (20:51 +0000)] 
Clean up obfuscated code in sqlite3_table_column_meta_data().
Be sure to invoke sqlite3_initialize() within sqlite3_mprintf(). (CVS 5224)

FossilOrigin-Name: bb4edb53964559fc1cd69700beb72ecc29b58f37

17 years agoFix a recently introduced resource leak in test file incrblob2.test (forgot to close...
danielk1977 [Mon, 16 Jun 2008 14:36:01 +0000 (14:36 +0000)] 
Fix a recently introduced resource leak in test file incrblob2.test (forgot to close a blob handle). (CVS 5223)

FossilOrigin-Name: 88e1c6092e48c860950d3437f264785243bb67ed

17 years agoFix a problem with the incremental blob API. sqlite3_blob_open() was always reading...
danielk1977 [Mon, 16 Jun 2008 14:19:57 +0000 (14:19 +0000)] 
Fix a problem with the incremental blob API. sqlite3_blob_open() was always reading the data for the leftmost column of the row that the opened blob was stored in. If this column happened to contain a (the) large blob, sqlite would make a large memory allocation to read the data into. Which defeats the purpose of using incremental blobs. (CVS 5222)

FossilOrigin-Name: 1b9478da2f421c1270e76297324fff8037d2f231

17 years agoAdd a test to verify that IN(...) WHERE clause terms are not handled by virtual table...
danielk1977 [Mon, 16 Jun 2008 06:31:34 +0000 (06:31 +0000)] 
Add a test to verify that IN(...) WHERE clause terms are not handled by virtual table implemetations. (CVS 5221)

FossilOrigin-Name: 85483c8fb3b45281ce07e84349841fc80e560b1f

17 years agoContinuing work on the new memory allocation subsystem.
drh [Sun, 15 Jun 2008 02:51:47 +0000 (02:51 +0000)] 
Continuing work on the new memory allocation subsystem.
Added routines for temporary memory allocation.  Right the btree
balance mechanism to only do one temporary allocation at a time. (CVS 5220)

FossilOrigin-Name: 65fe7b62cfe7d11cd667681a64c96fe7b2fe5685

17 years agoContinuing progress on the new memory allocation subsystem. Added the
drh [Sat, 14 Jun 2008 16:56:21 +0000 (16:56 +0000)] 
Continuing progress on the new memory allocation subsystem.  Added the
sqlite3_mem_methods structure for defining new memory allocators at
run-time. (CVS 5219)

FossilOrigin-Name: f00305f4cd2f487f660f34a21c1c24a0b37c7275

17 years agoProgress toward implementation of sqlite3_config() and a rework of the
drh [Fri, 13 Jun 2008 18:24:27 +0000 (18:24 +0000)] 
Progress toward implementation of sqlite3_config() and a rework of the
mutex and memory allocation subsystems.  This is an incremental check-in. (CVS 5218)

FossilOrigin-Name: a03c5af115889f477e17187a198a7d2d40bc76bf

17 years agoEnhance zeroblob tests to use the sqlite3_memory_highwater in order to
drh [Thu, 12 Jun 2008 18:17:40 +0000 (18:17 +0000)] 
Enhance zeroblob tests to use the sqlite3_memory_highwater in order to
double-check that no large allocations are occurring. (CVS 5217)

FossilOrigin-Name: e93079be83a9df7328d9b910fcbdb762be7ec815

17 years agoFix a typo in the date/time function tests. Add additional cases to
drh [Thu, 12 Jun 2008 18:05:40 +0000 (18:05 +0000)] 
Fix a typo in the date/time function tests.  Add additional cases to
the zeroblob tests to make sure sqlite3_bind_zeroblob() does not use
excess memory. (CVS 5216)

FossilOrigin-Name: c1006fb1c817bc0b7fada873edb772abbf972012

17 years agoConvert the date/time functions to work with milliseconds since the
drh [Thu, 12 Jun 2008 16:35:38 +0000 (16:35 +0000)] 
Convert the date/time functions to work with milliseconds since the
julian epoch internally (instead of days since the epoch) in order to avoid
problems with floating-point roundoff error.  The interface is unchanged. (CVS 5215)

FossilOrigin-Name: ed35f8a98323dadb64b423615287fb24ea262ffb

17 years agoAdd another test to incrblob2.test. This test failed to reveal any new bugs. (CVS...
danielk1977 [Thu, 12 Jun 2008 14:42:06 +0000 (14:42 +0000)] 
Add another test to incrblob2.test. This test failed to reveal any new bugs. (CVS 5214)

FossilOrigin-Name: 20d8ea45afcddf22632c3de984147826d0616d3f

17 years agoAvoid unnecessary float->text->float conversions in date/time processing.
drh [Thu, 12 Jun 2008 13:50:00 +0000 (13:50 +0000)] 
Avoid unnecessary float->text->float conversions in date/time processing.
This change necessary to reproduce the problem reported by BareFoot. (CVS 5213)

FossilOrigin-Name: 6ec4d7653b1e67ba0951e909ee23fe774762d646

17 years agoAdd the ability to disable the "localtime" modifier in the date/time
drh [Thu, 12 Jun 2008 12:51:37 +0000 (12:51 +0000)] 
Add the ability to disable the "localtime" modifier in the date/time
functions.  This might be necessary for systems that do not support
localtime_r() or localtime_s(). (CVS 5212)

FossilOrigin-Name: 12f3ba11e72b2310abf51d040d5344c81fe5ebd3

17 years agoRemove obsolete code from the test_osinst.c module. (CVS 5211)
drh [Thu, 12 Jun 2008 12:40:13 +0000 (12:40 +0000)] 
Remove obsolete code from the test_osinst.c module. (CVS 5211)

FossilOrigin-Name: 699cec66cdae6818844612d69eb89aa8b93c3f1a

17 years agoCopy the latest VFS changes into the OS/2 implementation. This is a blind
drh [Thu, 12 Jun 2008 12:38:10 +0000 (12:38 +0000)] 
Copy the latest VFS changes into the OS/2 implementation.  This is a blind
edit - I have no way to compile or test OS/2. (CVS 5210)

FossilOrigin-Name: b60508ccbc3159e994bc988512d9dbec3932deb6

17 years agoAdded additional testcases for julianday calculations with midnight boundary for...
shane [Thu, 12 Jun 2008 05:16:14 +0000 (05:16 +0000)] 
Added additional testcases for julianday calculations with midnight boundary for UTC time. (CVS 5209)

FossilOrigin-Name: edd2cb00ae606858d8ae138c69eee7821b8cd6ea

17 years agoAdded x86_64 version of hwtime function. Ticket #3156. (CVS 5208)
shane [Thu, 12 Jun 2008 02:24:38 +0000 (02:24 +0000)] 
Added x86_64 version of hwtime function.  Ticket #3156. (CVS 5208)

FossilOrigin-Name: 0729f5c3d01200190897488f14aec413a5ea17f9

17 years agoRemoved all C++ style comments. Ticket #3172. (CVS 5207)
shane [Thu, 12 Jun 2008 02:16:44 +0000 (02:16 +0000)] 
Removed all C++ style comments. Ticket #3172. (CVS 5207)

FossilOrigin-Name: 59f72425eb9acd270110a6a739f98a045c555f23

17 years agoAdditional refinements to the new sqlite3_initialize() interface design. (CVS 5206)
drh [Thu, 12 Jun 2008 00:07:29 +0000 (00:07 +0000)] 
Additional refinements to the new sqlite3_initialize() interface design. (CVS 5206)

FossilOrigin-Name: 14a9b9453bc1c85785fcc44617af80912f5118c8

17 years agoAdjust the error-message text in corrupt7.test. (CVS 5205)
drh [Wed, 11 Jun 2008 18:56:42 +0000 (18:56 +0000)] 
Adjust the error-message text in corrupt7.test. (CVS 5205)

FossilOrigin-Name: 4a77ff5b588f4c83959591c208a8b20224b75a66

17 years agoFix an error in the previous commit found by corrupt7.test. (CVS 5204)
danielk1977 [Wed, 11 Jun 2008 18:27:55 +0000 (18:27 +0000)] 
Fix an error in the previous commit found by corrupt7.test. (CVS 5204)

FossilOrigin-Name: afcfba0a8ac46e1d86a0fa2f1fbaeefe8ef10f7d

17 years agoCheck that the offsets in the cell-offset array of a b-tree page are within range...
danielk1977 [Wed, 11 Jun 2008 18:15:29 +0000 (18:15 +0000)] 
Check that the offsets in the cell-offset array of a b-tree page are within range in sqlite3BtreeInit(). (CVS 5203)

FossilOrigin-Name: 82f27e28eeb6902b75e21afd8eb170465f680d7b

17 years agoAdd a test case for the database corruption in the form of cell offsets
drh [Wed, 11 Jun 2008 18:01:21 +0000 (18:01 +0000)] 
Add a test case for the database corruption in the form of cell offsets
out of range in an otherwise valid btree page. (CVS 5202)

FossilOrigin-Name: c569a6cf664e9a8095f616327719392fb8186d37

17 years agoUpdate utility program speedtest8inst1.c. (CVS 5201)
danielk1977 [Wed, 11 Jun 2008 11:00:31 +0000 (11:00 +0000)] 
Update utility program speedtest8inst1.c. (CVS 5201)

FossilOrigin-Name: 98bdc7b44db737d3b77aa76c139995d2b185cd85

17 years agoA completely new design for the sqlite3_initialize() and sqlite3_shutdown()
drh [Tue, 10 Jun 2008 17:41:44 +0000 (17:41 +0000)] 
A completely new design for the sqlite3_initialize() and sqlite3_shutdown()
interfaces. (CVS 5200)

FossilOrigin-Name: 7dfcd73dc8e97e0bdbe05a22d0ed22b25e5a2786

17 years agoInvalidate sqlite3_blob* handles whenever an SQL statement is used to delete or modif...
danielk1977 [Tue, 10 Jun 2008 17:30:26 +0000 (17:30 +0000)] 
Invalidate sqlite3_blob* handles whenever an SQL statement is used to delete or modify the rows containing the open blob. Previously, modifying the table containing the open blob in any way invalidated the handle. This was too restrictive. (CVS 5199)

FossilOrigin-Name: e339c91f8718482ce74fc53781091db95e69d4c3

17 years agoInitial attempt at defining the sqlite3_initialize() and sqlite3_shutdown()
drh [Mon, 9 Jun 2008 21:57:22 +0000 (21:57 +0000)] 
Initial attempt at defining the sqlite3_initialize() and sqlite3_shutdown()
interfaces. (CVS 5198)

FossilOrigin-Name: 220bfd1f5cef0dfa8b800faa814ad4dc1456ced4

17 years agoMoved declaration of int nPage; to top of block to silence picky compilers (MSVC...
shane [Mon, 9 Jun 2008 19:27:11 +0000 (19:27 +0000)] 
Moved declaration of int nPage; to top of block to silence picky compilers (MSVC). (CVS 5197)

FossilOrigin-Name: 120bffff747592f1ab6ed02713a712cc74c12528

17 years agoAdd test file incrblob2.test to test opening two blob handles on a single database...
danielk1977 [Mon, 9 Jun 2008 15:51:26 +0000 (15:51 +0000)] 
Add test file incrblob2.test to test opening two blob handles on a single database blob. (CVS 5196)

FossilOrigin-Name: c1d877feb530b5cdaad55da3dbbb7c2596a10c49

17 years agoChange the signature of sqlite3PagerPagecount() so that it can return an error code...
danielk1977 [Sat, 7 Jun 2008 08:58:22 +0000 (08:58 +0000)] 
Change the signature of sqlite3PagerPagecount() so that it can return an error code. (CVS 5195)

FossilOrigin-Name: e9f01c01866d302d81bf9ebc484ea6351cbc0f60

17 years agoDo not call xSync() from zeroJournalHdr() if the Pager.noSync flag is set (i.e. for...
danielk1977 [Sat, 7 Jun 2008 05:19:37 +0000 (05:19 +0000)] 
Do not call xSync() from zeroJournalHdr() if the Pager.noSync flag is set (i.e. for temp files). (CVS 5194)

FossilOrigin-Name: 9f5cbe29226151113e4565fcf8170317afe1b8c6

17 years agoAvoid attempting to delete the journal file of a temporary pager when closing the...
danielk1977 [Fri, 6 Jun 2008 16:14:02 +0000 (16:14 +0000)] 
Avoid attempting to delete the journal file of a temporary pager when closing the pager. It will be deleted automatically by the OS layer. (CVS 5193)

FossilOrigin-Name: de8b87d65a85c4dabe53281092d9a23555a8e2d6

17 years agoAdd the xGetLastError() member function to the sqlite3_vfs structure. It is neither...
danielk1977 [Fri, 6 Jun 2008 15:49:29 +0000 (15:49 +0000)] 
Add the xGetLastError() member function to the sqlite3_vfs structure. It is neither called nor implemented at this point. (CVS 5192)

FossilOrigin-Name: b8f1da52c303de20d40aa20a7a031728d5d69af5

17 years agoRemove the subroutine return stack from the VDBE. Return addresses
drh [Fri, 6 Jun 2008 15:04:36 +0000 (15:04 +0000)] 
Remove the subroutine return stack from the VDBE.  Return addresses
for subroutines are now stored in registers. (CVS 5191)

FossilOrigin-Name: ef1956eebcaf5aca51af8c3b406b1fd4b1f391a7

17 years agoRemove the xGetTempname() method from the vfs structure. Temp files are now opened...
danielk1977 [Fri, 6 Jun 2008 11:11:25 +0000 (11:11 +0000)] 
Remove the xGetTempname() method from the vfs structure. Temp files are now opened by passing a NULL pointer as the filename to xOpen(). (CVS 5190)

FossilOrigin-Name: 5173b3e816c7eb711cd21a9068bbafb9ebb7cff1

17 years agoReorganize some of the code that detects expression trees with a depth greater than...
danielk1977 [Thu, 5 Jun 2008 16:47:39 +0000 (16:47 +0000)] 
Reorganize some of the code that detects expression trees with a depth greater than EXPR_MAX_DEPTH so that they are detected earlier. This further reduces the opportunities for stack overflow. (CVS 5189)

FossilOrigin-Name: 16d4c53a8e4d3cfc1abac3b8bb44d8bfd9471e32

17 years agoModify the signatures of the sqlite3_vfs.xAccess and sqlite3_vfs.xCheckReservedLock...
danielk1977 [Thu, 5 Jun 2008 11:39:11 +0000 (11:39 +0000)] 
Modify the signatures of the sqlite3_vfs.xAccess and sqlite3_vfs.xCheckReservedLock functions. (CVS 5188)

FossilOrigin-Name: 4226ac54beea1b58de8ab7b9d768d999f50438a6

17 years agoFix another typo in the rtree README file. (CVS 5187)
drh [Wed, 4 Jun 2008 15:09:16 +0000 (15:09 +0000)] 
Fix another typo in the rtree README file. (CVS 5187)

FossilOrigin-Name: 9ab87b7b0d0195787f1527b5be1475fb89330f08

17 years agoFix a bug in the R-Tree documentation. (CVS 5186)
drh [Wed, 4 Jun 2008 14:20:09 +0000 (14:20 +0000)] 
Fix a bug in the R-Tree documentation. (CVS 5186)

FossilOrigin-Name: bb445a4b1fe43d7b3e8546a6510f4e3c3ecb500b

17 years agoAdd "pragma journal_size_limit", used to limit the space consumed by persistent journ...
danielk1977 [Wed, 4 Jun 2008 06:45:59 +0000 (06:45 +0000)] 
Add "pragma journal_size_limit", used to limit the space consumed by persistent journal files left in the file-system after a transaction has concluded in exclusive (or journal_mode=persist) mode. (CVS 5185)

FossilOrigin-Name: 5c59f469d0321c6a2e702ca2c61db012f63aeecc

17 years agoEnsure that vacuum3.test closes all opened database connections. Fix for #3157. ...
danielk1977 [Tue, 3 Jun 2008 07:34:09 +0000 (07:34 +0000)] 
Ensure that vacuum3.test closes all opened database connections. Fix for #3157. (CVS 5184)

FossilOrigin-Name: 654e3b3de8ddeba3e31e9677ec4086e9f73c3598

17 years agoAvoid passing a null pointer to sqlite3SetString in sqlite3RunParser. Fix for #3155...
danielk1977 [Mon, 2 Jun 2008 13:00:33 +0000 (13:00 +0000)] 
Avoid passing a null pointer to sqlite3SetString in sqlite3RunParser. Fix for #3155. (CVS 5183)

FossilOrigin-Name: 03b5e4581a075179c85e8c16b16fd24c151294d3

17 years agoFix typos in comments in vdbe.c. (CVS 5182)
shane [Fri, 30 May 2008 15:59:49 +0000 (15:59 +0000)] 
Fix typos in comments in vdbe.c. (CVS 5182)

FossilOrigin-Name: 0613569424995207c600279c0d2337d5d5a3658c

17 years agoFix typos in comments in sqlite.h.in. (CVS 5181)
shane [Fri, 30 May 2008 15:35:30 +0000 (15:35 +0000)] 
Fix typos in comments in sqlite.h.in. (CVS 5181)

FossilOrigin-Name: 47956f8ee997113a1765d27009504143e518cc69

17 years agoFix typos in comments in where.c. (CVS 5180)
drh [Fri, 30 May 2008 14:58:37 +0000 (14:58 +0000)] 
Fix typos in comments in where.c. (CVS 5180)

FossilOrigin-Name: 7cadb223cb79387a7def7762dc9e42028d14baf3

17 years agoConsolidated inline assembly versions of "hwtime()" into hwtime.h. Provided MSVC...
shane [Thu, 29 May 2008 20:22:37 +0000 (20:22 +0000)] 
Consolidated inline assembly versions of "hwtime()" into hwtime.h.  Provided MSVC version.  Modified code for consistent use of hwtime().  Changed implementation to use sqlite_uint64 and sqlite_int64 instead of unsigned long long int and long long int for MSVC compiler support. (CVS 5179)

FossilOrigin-Name: 19f5f571dd09c91b6e6a3f82857f54bd30791c03

17 years agoConsolidated inline assembly versions of "hwtime()" into hwtime.h. Provided MSVC...
shane [Thu, 29 May 2008 20:22:37 +0000 (20:22 +0000)] 
Consolidated inline assembly versions of "hwtime()" into hwtime.h.  Provided MSVC version.  Modified code for consistent use of hwtime().  Changed implementation to use sqlite_uint64 and sqlite_int64 instead of unsigned long long int and long long int for MSVC compiler support. (CVS 5178)

FossilOrigin-Name: 9883b406ce24eae93942ee5e6aab33fb6b05329f

17 years agoFix cosmetic issues spotted while working on ticket #3146 (CVS 5177)
drh [Thu, 29 May 2008 05:23:41 +0000 (05:23 +0000)] 
Fix cosmetic issues spotted while working on ticket #3146 (CVS 5177)

FossilOrigin-Name: 5f6eab65dba421a736659a6673a51a0e487d68ac

17 years agoMoved check and define for OS_WINCE from os_win.c to os.h (with the other OS_* define...
shane [Thu, 29 May 2008 03:54:26 +0000 (03:54 +0000)] 
Moved check and define for OS_WINCE from os_win.c to os.h (with the other OS_* defines).  This allows OS_WINCE to be available for mutex_w32.c which is included earlier than os_win.c in the almagamation. (CVS 5176)

FossilOrigin-Name: ad6a782e7c408f6c3ebff5f2715c629b75c8002d

17 years agoWhen initializing the sqlite_sequence entry for an AUTOINCREMENT table,
drh [Thu, 29 May 2008 03:20:59 +0000 (03:20 +0000)] 
When initializing the sqlite_sequence entry for an AUTOINCREMENT table,
make sure the value is an reasonable integer even if the initial insert
failed.  Ticket #3148. (CVS 5175)

FossilOrigin-Name: 7e6847852d4517b1d14bebb8f0ae4d938b0b6f6d

17 years agoFix an obsolete comment on the OP_Rowid opcode in the VDBE. (CVS 5174)
drh [Thu, 29 May 2008 03:12:54 +0000 (03:12 +0000)] 
Fix an obsolete comment on the OP_Rowid opcode in the VDBE. (CVS 5174)

FossilOrigin-Name: 0d55328e680e23aae36d8f32a05aa3815393ac1d

17 years agoOmit declaration for functions that are only used by asserts if asserts aren't being...
shane [Thu, 29 May 2008 03:01:23 +0000 (03:01 +0000)] 
Omit declaration for functions that are only used by asserts if asserts aren't being used (NDEBUG). (CVS 5173)

FossilOrigin-Name: 5afc445a0e49def38f198455ffce9266fc8724ad

17 years agoUnused functions in testfixture.exe with certain defines. (CVS 5172)
shane [Thu, 29 May 2008 02:57:47 +0000 (02:57 +0000)] 
Unused functions in testfixture.exe with certain defines. (CVS 5172)

FossilOrigin-Name: 5e3ff1bb37f7fbdc9b1414232bd78f096f89eced

17 years agosqlite3OsDl*() APIs can be omitted if SQLITE_OMIT_LOAD_EXTENSION defined. (CVS 5171)
shane [Thu, 29 May 2008 02:52:59 +0000 (02:52 +0000)] 
sqlite3OsDl*() APIs can be omitted if SQLITE_OMIT_LOAD_EXTENSION defined. (CVS 5171)

FossilOrigin-Name: 7c51a97dc11f20f7323a9dc5c04a3b84380cf8fb

17 years agoUse %llx instead of %x for 64 bit values (this only affects a debugging statement...
shane [Wed, 28 May 2008 18:01:44 +0000 (18:01 +0000)] 
Use %llx instead of %x for 64 bit values (this only affects a debugging statement). (CVS 5170)

FossilOrigin-Name: c81efc97bca58ebbd9500f990f7e45d133e1bd0b

17 years agoUpdate makefile.in so that makefiles generated by configure correctly copy in rtree...
shane [Wed, 28 May 2008 17:31:17 +0000 (17:31 +0000)] 
Update makefile.in so that makefiles generated by configure correctly copy in rtree source files to tsrc. (CVS 5169)

FossilOrigin-Name: e015fa44586b2444c78da413af50787e2690046e

17 years agoAdd another test case to vacuum3.test. (CVS 5168)
danielk1977 [Wed, 28 May 2008 16:00:43 +0000 (16:00 +0000)] 
Add another test case to vacuum3.test. (CVS 5168)

FossilOrigin-Name: d895e85e2f9b595e58562d57226404f72db89a60

17 years agoAdd a test to vacuum3.test to try to trick sqlite into using the wrong database page...
danielk1977 [Wed, 28 May 2008 14:08:17 +0000 (14:08 +0000)] 
Add a test to vacuum3.test to try to trick sqlite into using the wrong database page-size. Turns out there was no problem. (CVS 5167)

FossilOrigin-Name: 281589a22fa481b1dfcae69fc124458d240a0ae1

17 years agoAllow the SQLITE_MAX_EXPR_DEPTH compile-time parameter to be set to 0 in
drh [Wed, 28 May 2008 13:49:34 +0000 (13:49 +0000)] 
Allow the SQLITE_MAX_EXPR_DEPTH compile-time parameter to be set to 0 in
order to disable expression depth checking.  Ticket #3143. (CVS 5166)

FossilOrigin-Name: 5ceef40e397fc535173996404345b93f695e8cac

17 years agoIn test3.c, use type 'u32' instead of 'unsigned int' to remove a warning/error from...
shane [Tue, 27 May 2008 20:17:00 +0000 (20:17 +0000)] 
In test3.c, use type 'u32' instead of 'unsigned int' to remove a warning/error from native x86_64 compile. (CVS 5165)

FossilOrigin-Name: 02447e4e47659d70f014529e9baa3bf8ff75844c

17 years agoUpdated to use localtime_s() in Windows build environments that support it. Ticket...
shane [Tue, 27 May 2008 19:49:21 +0000 (19:49 +0000)] 
Updated to use localtime_s() in Windows build environments that support it.  Ticket #3126. (CVS 5164)

FossilOrigin-Name: 1518827e48bc3a259b6079a5a4b8dca47b265172

17 years agoExplicitly typedef Pgno as 'u32' instead of 'unsigned int' to remove a few warnings...
shane [Tue, 27 May 2008 18:11:44 +0000 (18:11 +0000)] 
Explicitly typedef Pgno as 'u32' instead of 'unsigned int' to remove a few warnings/errors from native x86_64 compile. (CVS 5163)

FossilOrigin-Name: b5fd8a239d787a126f775101760737781751f56e

17 years agoFix a bug in rtree that occurs when too many constraints are passed
drh [Tue, 27 May 2008 00:06:02 +0000 (00:06 +0000)] 
Fix a bug in rtree that occurs when too many constraints are passed
in on a query. (CVS 5162)

FossilOrigin-Name: 54b84a3ddba9d27814c2f613dd197f691ac549a4

17 years agoUse %w instead of %q when constructing shadow table names for rtree. (CVS 5161)
drh [Mon, 26 May 2008 20:49:02 +0000 (20:49 +0000)] 
Use %w instead of %q when constructing shadow table names for rtree. (CVS 5161)

FossilOrigin-Name: 78f4ba974d9b768b62391d8cd2ed407d49584cb8

17 years agoUpdate the amalgamation builder to incorporate the RTREE extension. (CVS 5160)
drh [Mon, 26 May 2008 20:19:25 +0000 (20:19 +0000)] 
Update the amalgamation builder to incorporate the RTREE extension. (CVS 5160)

FossilOrigin-Name: aa8eba3360c31182f5238e96b83a382374f40fab

17 years agoImport 'rtree' extension. (CVS 5159)
danielk1977 [Mon, 26 May 2008 18:41:54 +0000 (18:41 +0000)] 
Import 'rtree' extension. (CVS 5159)

FossilOrigin-Name: b104dcd6adadbd3fe15a348fe9d4d290119e139e

17 years agoFix the LIKE query optimizer so that it works with LIKE patterns
drh [Mon, 26 May 2008 18:33:40 +0000 (18:33 +0000)] 
Fix the LIKE query optimizer so that it works with LIKE patterns
ending in '@%' on NOCASE columns.  Ticket #3139. (CVS 5158)

FossilOrigin-Name: 33548744369643cc8843b74ad1fc1b7d5988d7a4

17 years agoFixed various typos, spelling, grammar, and formatting mistakes. Ticket #3124. ...
shane [Fri, 23 May 2008 17:21:09 +0000 (17:21 +0000)] 
Fixed various typos, spelling, grammar, and formatting mistakes.  Ticket #3124. (CVS 5157)

FossilOrigin-Name: 77d5a7aa1c7ea715298228ed2dbd0497cacbd0e4

17 years agoAdd a test case of preparing a statement with an nBytes parameter of 0
drh [Fri, 23 May 2008 14:49:49 +0000 (14:49 +0000)] 
Add a test case of preparing a statement with an nBytes parameter of 0
and where the previous byte of the string is zero.  Ticket #3134. (CVS 5156)

FossilOrigin-Name: 846a69acb59403438696000b4ffd588ab42b2f95

17 years agoDo not references zSql(-1) if nBytes==0 in sqlite3_prepare().
drh [Fri, 23 May 2008 14:32:18 +0000 (14:32 +0000)] 
Do not references zSql(-1) if nBytes==0 in sqlite3_prepare().
Ticket #3134. (CVS 5155)

FossilOrigin-Name: 2d2c53e5058412a5f484ac2ca5bcef596aed2a7b

17 years agoEnsure that the db.mallocFailed flag is cleared before sqlite3_errmsg16() returns...
danielk1977 [Thu, 22 May 2008 13:56:17 +0000 (13:56 +0000)] 
Ensure that the db.mallocFailed flag is cleared before sqlite3_errmsg16() returns. (CVS 5154)

FossilOrigin-Name: 0d47653a3c39b7cd41c7e6edd8c4b4543658412d

17 years agoAdd the "volatile" keyword to variables in the Pager structure used for
drh [Wed, 21 May 2008 15:38:14 +0000 (15:38 +0000)] 
Add the "volatile" keyword to variables in the Pager structure used for
synchronization when memory management is enabled. (CVS 5153)

FossilOrigin-Name: 25b9f3b9b2d996ab4582b22b695c4dbd94d09cc7

17 years agoUpdate sqlite3_open*() documentation on shared cache/filename matching relationship...
shane [Wed, 21 May 2008 15:01:21 +0000 (15:01 +0000)] 
Update sqlite3_open*() documentation on shared cache/filename matching relationship.  Ticket #3132. (CVS 5152)

FossilOrigin-Name: 235e384eca65d5007e8e0c440904eb254f9b976a

17 years agoFix the VACUUM command so that it does not modify the changes counts
drh [Wed, 21 May 2008 13:44:13 +0000 (13:44 +0000)] 
Fix the VACUUM command so that it does not modify the changes counts
reported by sqlite3_changes() or sqlite3_total_changes().  Update documentation
on sqlite3_changes() and sqlite3_total_changes() to state that
"DELETE FROM table" records a change count of zero. (CVS 5151)

FossilOrigin-Name: f5d61d7d982b58accaf33df4362ce4a5eb79307e

17 years agoFix OS/2 compilation for pre-C99 compilers. (CVS 5150)
pweilbacher [Tue, 20 May 2008 19:08:53 +0000 (19:08 +0000)] 
Fix OS/2 compilation for pre-C99 compilers. (CVS 5150)

FossilOrigin-Name: de8e67182d8f9d1f0b215da93a396b9467604a50

17 years agoCorrections to the documented behavior of sqlite3_last_insert_rowid().
drh [Tue, 20 May 2008 18:43:38 +0000 (18:43 +0000)] 
Corrections to the documented behavior of sqlite3_last_insert_rowid().
(This change is unrelated to the problem reported by Bram de Jong.  That
comes next.) (CVS 5149)

FossilOrigin-Name: 894085a59cdc60c34c8a3eb560d98bcb4a087cb1

17 years agoChanges to the error handling policies of sqlite3_exec() to make them
drh [Tue, 20 May 2008 15:44:30 +0000 (15:44 +0000)] 
Changes to the error handling policies of sqlite3_exec() to make them
more consistent.  Changes to the documentation on the error handling
polices of sqlite3_exec() so that the documentation and code agree. (CVS 5148)

FossilOrigin-Name: a0376c7907db8e2993ce48e484001e981fbbb187

17 years agoAdded more DST boundary checks for 2006 and 2007. Added check for suspect Windows...
shane [Tue, 20 May 2008 14:01:59 +0000 (14:01 +0000)] 
Added more DST boundary checks for 2006 and 2007.  Added check for suspect Windows DST implementations and warning about them.  Ticket #2322. (CVS 5147)

FossilOrigin-Name: 14226ff0a7af7b39a1089a17eeb5bbb8d09d778d

17 years agoUpdated test case for Windows to get around problems in ticket #3129. (CVS 5146)
shane [Tue, 20 May 2008 13:17:28 +0000 (13:17 +0000)] 
Updated test case for Windows to get around problems in ticket #3129. (CVS 5146)

FossilOrigin-Name: 2faf69ca1da43f8083b96675a4886648f10177d8

17 years agoDo not attempt to write a master journal name to the (non-existent) journal file...
danielk1977 [Tue, 20 May 2008 07:05:09 +0000 (07:05 +0000)] 
Do not attempt to write a master journal name to the (non-existent) journal file in "no-journal" mode. Fix for #3127. (CVS 5145)

FossilOrigin-Name: ffd4e50ab9b14fb7b686681c5e7a37b8355bbfca

17 years agoImprovements to API documentation. The sqlite3_exec() function now
drh [Mon, 19 May 2008 23:51:55 +0000 (23:51 +0000)] 
Improvements to API documentation.  The sqlite3_exec() function now
sets the result returned by sqlite3_errcode() when it receives an SQLITE_ABORT. (CVS 5144)

FossilOrigin-Name: f1df19ca17a09ab8d85a4a7eb04f3ce95a6722da

17 years agoSQLite stores native file names and paths for the database file. Under Windows,...
shane [Mon, 19 May 2008 20:11:39 +0000 (20:11 +0000)] 
SQLite stores native file names and paths for the database file.  Under Windows, (file normalize test.db) is expanded using UNIX type path separators which TCL recognizes interchangeably.   However, this means that the path reported by sqlite3_shared_cache_report doesn't match which causes the test case to fail.  Made minor change to test case to hopefully correct this on all platforms. (CVS 5143)

FossilOrigin-Name: 5ef61701398ce75e32cfaea2eacf2c3e80832ca0

17 years agoFix sqlite3Atoi64 to return true if handed a number of all zeros. The
drh [Mon, 19 May 2008 15:54:59 +0000 (15:54 +0000)] 
Fix sqlite3Atoi64 to return true if handed a number of all zeros.  The
failure to do this is benign as sqlite3Atoi64() is current used, but that
might change in the future so it is good to go ahead and fix the function
to return the correct result. (CVS 5142)

FossilOrigin-Name: bc90787583dd2dadff72d516de9720d4a36e7fd2

17 years agoIn the CLI, handle the compilation option -DOS_OS2=0 correctly. (CVS 5141)
drh [Mon, 19 May 2008 15:53:34 +0000 (15:53 +0000)] 
In the CLI, handle the compilation option -DOS_OS2=0 correctly. (CVS 5141)

FossilOrigin-Name: 70793be63c0c6dab42d48c096e0e051e37d7e788

17 years agoAdded test cases for corrupt 2-10 byte SerialTypeLen values. (CVS 5140)
shane [Mon, 19 May 2008 15:37:10 +0000 (15:37 +0000)] 
Added test cases for corrupt 2-10 byte SerialTypeLen values. (CVS 5140)

FossilOrigin-Name: 97ed2dd1dc9d8e8f837914277c080160d319591b

17 years agoDisable the column cache when coding values that will be passed to the xFilter()...
danielk1977 [Fri, 16 May 2008 15:40:40 +0000 (15:40 +0000)] 
Disable the column cache when coding values that will be passed to the xFilter() method of a virtual table, in case the xFilter() implementation modifies the type or encoding of the value. Ticket #3121. (CVS 5139)

FossilOrigin-Name: ecbc0d5deddc0ca0d1d2649e0134ee392266027e

17 years agoCheck that the encoding of values passed to sqlite3_bind_value() matches that of...
danielk1977 [Fri, 16 May 2008 15:24:58 +0000 (15:24 +0000)] 
Check that the encoding of values passed to sqlite3_bind_value() matches that of the database. (CVS 5138)

FossilOrigin-Name: e94a2883060b9ef59809ff4de9525d897d95546c

17 years agoAdd more version tags to files that lack them. Ticket #3120. (CVS 5137)
danielk1977 [Fri, 16 May 2008 04:51:54 +0000 (04:51 +0000)] 
Add more version tags to files that lack them. Ticket #3120. (CVS 5137)

FossilOrigin-Name: 81a8c70ed7a86abf286706fdbc251f31c9c53382

17 years agoAdd version tag comments to source files that lack them.
drh [Thu, 15 May 2008 19:43:52 +0000 (19:43 +0000)] 
Add version tag comments to source files that lack them.
Tickets #3118 and #3119. (CVS 5136)

FossilOrigin-Name: cf1fb2d850c3eebc2f92159a156695b61f023202

17 years agoAdd the "page_count" pragma. Returns a single integer - the number of pages in the...
danielk1977 [Thu, 15 May 2008 17:48:20 +0000 (17:48 +0000)] 
Add the "page_count" pragma. Returns a single integer - the number of pages in the specified database file. (CVS 5135)

FossilOrigin-Name: eb6985e69ce2a5e5e7361f6226d1cfc547fd441d

17 years agoIf a pager is already in the error-state when CommitPhaseOne() is called, exit early...
danielk1977 [Thu, 15 May 2008 11:08:07 +0000 (11:08 +0000)] 
If a pager is already in the error-state when CommitPhaseOne() is called, exit early. (CVS 5134)

FossilOrigin-Name: 443cf1056c73ae89d0efcc7a462455c078b3a4a8