]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
16 years agoChange lock2.test so that it does not enter a busy loop if the child process exists...
danielk1977 [Fri, 1 May 2009 10:55:34 +0000 (10:55 +0000)] 
Change lock2.test so that it does not enter a busy loop if the child process exists unexpectedly. (CVS 6586)

FossilOrigin-Name: 164a7f5a45c3e7f7a73899678c374535b270b130

16 years agoRemove a NEVER() clause from a condition that is true at least once when running...
danielk1977 [Fri, 1 May 2009 06:19:21 +0000 (06:19 +0000)] 
Remove a NEVER() clause from a condition that is true at least once when running attachmalloc.test. (CVS 6585)

FossilOrigin-Name: 514efc7312d725c3fe35741e8c000526f3bdb3a6

16 years agoFix for tempdb.test so that it passes when running the inmemory_journal permutation...
danielk1977 [Fri, 1 May 2009 05:23:17 +0000 (05:23 +0000)] 
Fix for tempdb.test so that it passes when running the inmemory_journal permutation test. (CVS 6584)

FossilOrigin-Name: 0256187b512c5849ffae0644e6a42ec0ca2de894

16 years agoFix processing of BEFORE triggers on INSERT statements with RHS SELECTs
drh [Fri, 1 May 2009 02:08:04 +0000 (02:08 +0000)] 
Fix processing of BEFORE triggers on INSERT statements with RHS SELECTs
that insert a NULL into the INTEGER PRIMARY KEY.  Ticket #3832. (CVS 6583)

FossilOrigin-Name: 4a1f6a3a9ac8b476c86edac83b555adeef0be4e6

16 years agoMore cleanup, etc. to support MSVC compiles. (CVS 6582)
shane [Thu, 30 Apr 2009 17:45:33 +0000 (17:45 +0000)] 
More cleanup, etc. to support MSVC compiles. (CVS 6582)

FossilOrigin-Name: 2cd9655e7313671f2bbe8d4a6f13246cbbf61205

16 years agoDisable an always-false test in the attach.c module. (CVS 6581)
drh [Thu, 30 Apr 2009 17:38:37 +0000 (17:38 +0000)] 
Disable an always-false test in the attach.c module. (CVS 6581)

FossilOrigin-Name: 92b69481bd0eedf06599c40623b38a6f4990010a

16 years agoFix a problem with in-memory sub-journals and exclusive locking mode. Also a test...
danielk1977 [Thu, 30 Apr 2009 16:41:00 +0000 (16:41 +0000)] 
Fix a problem with in-memory sub-journals and exclusive locking mode. Also a test script problem introduced by (6575). (CVS 6580)

FossilOrigin-Name: d67af3f5a21329e133aa6cf2be745a9f8c1a6562

16 years agoDocumentation updates for sqlite3_set_authorizer(). No changes to code. (CVS 6579)
drh [Thu, 30 Apr 2009 15:59:56 +0000 (15:59 +0000)] 
Documentation updates for sqlite3_set_authorizer().  No changes to code. (CVS 6579)

FossilOrigin-Name: 41f39c3145f2659fdb636cae07cdd424a10ac6e9

16 years agoDisallow attaching the same database multiple times to the same db connection
drh [Thu, 30 Apr 2009 13:30:32 +0000 (13:30 +0000)] 
Disallow attaching the same database multiple times to the same db connection
in shared cache mode, since doing so leads to deadlock. (CVS 6578)

FossilOrigin-Name: 715f14f1dcaf604d4794bf3e18e245d4f8c5d5a9

16 years agoFix apparent typo on exclusive.test in the (6575) check-in. (CVS 6577)
drh [Thu, 30 Apr 2009 12:25:58 +0000 (12:25 +0000)] 
Fix apparent typo on exclusive.test in the (6575) check-in. (CVS 6577)

FossilOrigin-Name: 95d22405e096355ce815cdb0908c4ef04107b490

16 years agoChanges sqlite3TempInMemory() to take a const parameter. (CVS 6576)
drh [Thu, 30 Apr 2009 12:25:10 +0000 (12:25 +0000)] 
Changes sqlite3TempInMemory() to take a const parameter. (CVS 6576)

FossilOrigin-Name: aa29a14ca040db25dadbca787aa75be3b7588415

16 years agoWhen SQLite is configured to use in-memory temp files (either by setting SQLITE_TEMP_...
danielk1977 [Thu, 30 Apr 2009 09:10:37 +0000 (09:10 +0000)] 
When SQLite is configured to use in-memory temp files (either by setting SQLITE_TEMP_STORE during compilation or using the temp_store pragma at run time), store statement/savepoint journals in memory also. Ticket #3825. (CVS 6575)

FossilOrigin-Name: 38f8c5a14cd221af9e115a0fea689f2ff39e30e5

16 years agoFix a memory leak introduced in the previous check-in. (CVS 6574)
drh [Thu, 30 Apr 2009 05:40:34 +0000 (05:40 +0000)] 
Fix a memory leak introduced in the previous check-in. (CVS 6574)

FossilOrigin-Name: f082bf36051fef92ddda0339777a00cd1f0ba988

16 years agoTake care not to leave a zombie attached database if the attachment fails
drh [Thu, 30 Apr 2009 05:19:04 +0000 (05:19 +0000)] 
Take care not to leave a zombie attached database if the attachment fails
due to an encoding mismatch.  Update attach logic to always use dynamically
allocated error message strings. (CVS 6573)

FossilOrigin-Name: a6cb4002ada311b56fa2b7430b98b9a0fa698a01

16 years agoRemove always-true tests from attach.c. In btree.c, always test the return
drh [Thu, 30 Apr 2009 01:22:41 +0000 (01:22 +0000)] 
Remove always-true tests from attach.c.  In btree.c, always test the return
from sqlite3PagerSetPagesize() since it might return SQLITE_NOMEM. (CVS 6572)

FossilOrigin-Name: 8bf60b24ffcf6ac15f41eaa7f976b810e0c66734

16 years agoRemove an always-true test from delete.c. Move the sqlite3OpenTable()
drh [Thu, 30 Apr 2009 00:11:09 +0000 (00:11 +0000)] 
Remove an always-true test from delete.c.  Move the sqlite3OpenTable()
routine from delete.c to insert.c since it is not used in delete.c. (CVS 6571)

FossilOrigin-Name: 71756dc870910665ef5fdbc7343bc3eedbe3ce65

16 years agoFixed compile for MSVC; removed compiler warnings; changes for NDEBUG build; minor...
shane [Wed, 29 Apr 2009 18:11:59 +0000 (18:11 +0000)] 
Fixed compile for MSVC;  removed compiler warnings; changes for NDEBUG build; minor code tweaks. (CVS 6570)

FossilOrigin-Name: e98b12425ff036b36165dfd2002e0530ca27a677

16 years agoModify the assemblePage() function in btree.c so that it runs slightly faster. (CVS...
danielk1977 [Wed, 29 Apr 2009 17:49:59 +0000 (17:49 +0000)] 
Modify the assemblePage() function in btree.c so that it runs slightly faster. (CVS 6569)

FossilOrigin-Name: 7ec42e989f1d4abdc6d52f8feebf51985f36b2bd

16 years agoUpdate the documentation on the sqlite3_changes() and sqlite3_total_changes()
drh [Wed, 29 Apr 2009 14:33:44 +0000 (14:33 +0000)] 
Update the documentation on the sqlite3_changes() and sqlite3_total_changes()
functions. (CVS 6568)

FossilOrigin-Name: 58c7bdb21c719bf06713ff8ffa7ee51cf1973712

16 years agoFix a case in where.c where a crash can follow a malloc failure. Also modify test...
danielk1977 [Wed, 29 Apr 2009 11:50:53 +0000 (11:50 +0000)] 
Fix a case in where.c where a crash can follow a malloc failure. Also modify test code in test8.c to check a return code that was being dropped (causing a test in vtab_err.test to fail). (CVS 6567)

FossilOrigin-Name: 9664e2b6c69271a7ca55af7812a186773a7c6592

16 years agoAdd a version of cellSizePtr() that is faster than using sqlite3BtreeParseCellPtr...
danielk1977 [Wed, 29 Apr 2009 11:31:47 +0000 (11:31 +0000)] 
Add a version of cellSizePtr() that is faster than using sqlite3BtreeParseCellPtr(). This speeds up balance_nonroot(). (CVS 6566)

FossilOrigin-Name: e8f7f7b787fe941093edaea44db4d361fad1e002

16 years agoSimplify a conditional expression in btree.c. (CVS 6565)
danielk1977 [Wed, 29 Apr 2009 06:27:56 +0000 (06:27 +0000)] 
Simplify a conditional expression in btree.c. (CVS 6565)

FossilOrigin-Name: fc3a5ac2353142082fe14d47f9c2b662407ea3f7

16 years agoFix an out-of-order test number in blob.test. Cosmetic change. No
drh [Tue, 28 Apr 2009 18:00:27 +0000 (18:00 +0000)] 
Fix an out-of-order test number in blob.test.  Cosmetic change.  No
changes to code.  Ticket #3830. (CVS 6564)

FossilOrigin-Name: e855654283a23d903fd531162655a8c4fa01775b

16 years agoFix asserts in hash.c so that zero-length symbols can be used. (CVS 6563)
drh [Tue, 28 Apr 2009 17:33:16 +0000 (17:33 +0000)] 
Fix asserts in hash.c so that zero-length symbols can be used. (CVS 6563)

FossilOrigin-Name: fe9f00aa369051beee09ab3d1a2e046a1f679a40

16 years agoWhen testing with TEMP_STORE=3 and the test pcache, only run 20 iterations in trans...
danielk1977 [Tue, 28 Apr 2009 16:37:59 +0000 (16:37 +0000)] 
When testing with TEMP_STORE=3 and the test pcache, only run 20 iterations in trans.test. Otherwise the test pcache runs out of memory. (CVS 6562)

FossilOrigin-Name: 0799b729a7fe50ee935ac3bd9f95118288d33f6e

16 years agoRemove an unused function declaration from hash.h. (CVS 6561)
drh [Tue, 28 Apr 2009 16:35:42 +0000 (16:35 +0000)] 
Remove an unused function declaration from hash.h. (CVS 6561)

FossilOrigin-Name: fcf70bb8b8ab7682d46fa7e75338dfd8ecf472a3

16 years agoFurther adjustment to rowhash.test to account for rowid collisions. (CVS 6560)
danielk1977 [Tue, 28 Apr 2009 15:48:08 +0000 (15:48 +0000)] 
Further adjustment to rowhash.test to account for rowid collisions. (CVS 6560)

FossilOrigin-Name: 94a23f993381412c7533878d44faa2f8e47e58ce

16 years agoSimplifications to the symbol table implementation in hash.c. For very small
drh [Tue, 28 Apr 2009 15:43:45 +0000 (15:43 +0000)] 
Simplifications to the symbol table implementation in hash.c.  For very small
symbol tables (less than 10 entries) a simple linked list is used instead
of a hash table.  Number of hash table buckets is limited to prevent large
allocations. (CVS 6559)

FossilOrigin-Name: 5c737835dec9e6038b304c198aa14337a6f23c1c

16 years agoHave sqlite3_create_collation() return MISUSE if passed an encoding value other than...
danielk1977 [Tue, 28 Apr 2009 15:35:38 +0000 (15:35 +0000)] 
Have sqlite3_create_collation() return MISUSE if passed an encoding value other than SQLITE_UTF8, SQLITE_UTF16LE, SQLITE_UTF16BE, SQLITE_UTF16 or SQLITE_UTF16_ALIGNED. (CVS 6558)

FossilOrigin-Name: 7975b6f2ec7736b3656a264c2f7e7e95ce7a78e4

16 years agoDo not store the zero string terminator as part of the name when holding
drh [Tue, 28 Apr 2009 13:01:09 +0000 (13:01 +0000)] 
Do not store the zero string terminator as part of the name when holding
symbols in the symbol table. (CVS 6557)

FossilOrigin-Name: 23d67af39227aeade2ea0292e1b8844eea580993

16 years agoAnother fix to the same assert as in (6555). It can also fail after a malloc error...
danielk1977 [Tue, 28 Apr 2009 12:08:15 +0000 (12:08 +0000)] 
Another fix to the same assert as in (6555). It can also fail after a malloc error. (CVS 6556)

FossilOrigin-Name: e096f90a57f0e0d1dbeaafc72762035ca55ab803

16 years agoFix an assert that could fail after a parse error in expr.c. (CVS 6555)
danielk1977 [Tue, 28 Apr 2009 11:10:39 +0000 (11:10 +0000)] 
Fix an assert that could fail after a parse error in expr.c. (CVS 6555)

FossilOrigin-Name: a37d1174eb80e9a09522b236afdb47283f312d06

16 years agoAvoid changing the pager journal-mode once a write-transaction is open, even if no...
danielk1977 [Tue, 28 Apr 2009 05:27:20 +0000 (05:27 +0000)] 
Avoid changing the pager journal-mode once a write-transaction is open, even if no database pages have been modified. (CVS 6554)

FossilOrigin-Name: ad8aba3eff90d42b936e3644f10cbbd431eebad8

16 years agoAdd test cases for sqlite3_complete with an EXPLAIN QUERY PLAN on a
drh [Tue, 28 Apr 2009 04:51:29 +0000 (04:51 +0000)] 
Add test cases for sqlite3_complete with an EXPLAIN QUERY PLAN on a
CREATE TRIGGER statement.  Ticket #3828. (CVS 6553)

FossilOrigin-Name: 6b86b40edadb9c9cbc0db5a43a8277434f9d7171

16 years agoMake sure sqlite3_open16() always zeros the db return pointer if
drh [Tue, 28 Apr 2009 04:47:31 +0000 (04:47 +0000)] 
Make sure sqlite3_open16() always zeros the db return pointer if
SQLite initialization fails. (CVS 6552)

FossilOrigin-Name: 057c7d171397e19c8f3ac2362ea45f2b4a50530c

16 years agoEnhance sqlite3_complete() so that it understands EXPLAIN QUERY PLAN.
drh [Tue, 28 Apr 2009 04:46:41 +0000 (04:46 +0000)] 
Enhance sqlite3_complete() so that it understands EXPLAIN QUERY PLAN.
Ticket #3828.  Testing is done in TH3. (CVS 6551)

FossilOrigin-Name: 3ac1b15f552fe005630e43a92fffa6a4abd6675d

16 years agoBring the documenation and implementation of sqlite3_collation_needed() into
drh [Mon, 27 Apr 2009 18:46:06 +0000 (18:46 +0000)] 
Bring the documenation and implementation of sqlite3_collation_needed() into
agreement.  Use a more efficient implementation of sqlite3ErrStr().
sqlite3_result_error_code() now calls sqlite3ErrStr() if no prior
error string was set. (CVS 6550)

FossilOrigin-Name: cb9af8293624da35c32077d0f46d5b0cf826dcf5

16 years agoTests for the new asynchronous IO API. (CVS 6549)
danielk1977 [Sat, 25 Apr 2009 08:39:14 +0000 (08:39 +0000)] 
Tests for the new asynchronous IO API. (CVS 6549)

FossilOrigin-Name: 11b2564e7159168cd0815bb9bc93688586fad1e0

16 years agoAdd another test case for the "x IS NULL" uniqueness problem of ticket #3824.
drh [Fri, 24 Apr 2009 20:32:31 +0000 (20:32 +0000)] 
Add another test case for the "x IS NULL" uniqueness problem of ticket #3824.
No changes to code.  This just double-checks that everything is working now. (CVS 6548)

FossilOrigin-Name: 3ceae3579bc42974865cf6fe0bc42001e786e894

16 years agoDequote the "from" table in a FOREIGN KEY definition (affects the output of "pragma...
danielk1977 [Fri, 24 Apr 2009 18:06:09 +0000 (18:06 +0000)] 
Dequote the "from" table in a FOREIGN KEY definition (affects the output of "pragma foreign_key_list). Fix for #3800. (CVS 6547)

FossilOrigin-Name: 600482d1619c07690b6517ded9655462bdab7538

16 years agoGet rid of the special RowSet processing in where.c and move that into
drh [Fri, 24 Apr 2009 15:46:21 +0000 (15:46 +0000)] 
Get rid of the special RowSet processing in where.c and move that into
clients.  Added the WHERE_DUPLICATES_OK option to eliminate an unnecessary
RowSet during DELETE with a WHERE clause containing ORs. (CVS 6546)

FossilOrigin-Name: 98606bee9e41b8969fb639fc43864e230185ca43

16 years agoMake sure that the optimizer realizes that an "x IS NULL" contraint does not
drh [Fri, 24 Apr 2009 14:51:42 +0000 (14:51 +0000)] 
Make sure that the optimizer realizes that an "x IS NULL" contraint does not
necessarily give a single-row result even on a UNIQUE index.  Ticket #3824. (CVS 6545)

FossilOrigin-Name: 207335fdbf992a2f5bc5982b3163a38016ba1b21

16 years agoMake selecting the asynchronous IO file-locking mode a runtime operation. Still untes...
danielk1977 [Fri, 24 Apr 2009 10:13:05 +0000 (10:13 +0000)] 
Make selecting the asynchronous IO file-locking mode a runtime operation. Still untested. (CVS 6544)

FossilOrigin-Name: 577277e84a05707b8c21aa08bc5fc314c1ac38ac

16 years agoImprove comments and documentation of the asynchronous IO VFS module. (CVS 6543)
danielk1977 [Fri, 24 Apr 2009 09:27:16 +0000 (09:27 +0000)] 
Improve comments and documentation of the asynchronous IO VFS module. (CVS 6543)

FossilOrigin-Name: 92bc6be2a86f8a68ceded2bc08fe7d6ff23b56fb

16 years agoos_win.c, winOpen(), changed to handle the SQLITE_OPEN_EXCLUSIVE flag and sharing...
shane [Thu, 23 Apr 2009 19:08:32 +0000 (19:08 +0000)] 
os_win.c, winOpen(), changed to handle the SQLITE_OPEN_EXCLUSIVE flag and sharing modes in the same manner as os_unix.c. Ticket #3821. (CVS 6542)

FossilOrigin-Name: 18fef3fcf61c137a89a83352f6769ed06845434a

16 years agoUpdated misc. test scripts for Windows testing with gcc/cygwin; (CVS 6541)
shane [Thu, 23 Apr 2009 18:42:04 +0000 (18:42 +0000)] 
Updated misc. test scripts for Windows testing with gcc/cygwin; (CVS 6541)

FossilOrigin-Name: 1e2c71596e3f7a69afc5b745c20b2e4e81bffda5

16 years agoRemove some incorrect async tests; (CVS 6540)
shane [Thu, 23 Apr 2009 18:41:25 +0000 (18:41 +0000)] 
Remove some incorrect async tests; (CVS 6540)

FossilOrigin-Name: 03af25b3ee001c1bf3e7a3218fad6ed311c7c259

16 years agoMove the asynchronous IO code from src/test_async.c to ext/async/. Refactor it to...
danielk1977 [Thu, 23 Apr 2009 14:58:39 +0000 (14:58 +0000)] 
Move the asynchronous IO code from src/test_async.c to ext/async/. Refactor it to be a standalone module and to support windows. (CVS 6539)

FossilOrigin-Name: e71fb0fb8d83b4453c3c1e84606bf58d04926809

16 years agoRework the column-cache mechanism to be more robust (and more correct).
drh [Thu, 23 Apr 2009 13:22:42 +0000 (13:22 +0000)] 
Rework the column-cache mechanism to be more robust (and more correct).
The column-alias cache is currently disabled, (CVS 6538)

FossilOrigin-Name: dd4d67a67454a3ff13c286a2a8360c5f0432c91d

16 years agoEliminate the OP_VRowid opcode. The regular OP_Rowid now work for both
drh [Wed, 22 Apr 2009 17:15:02 +0000 (17:15 +0000)] 
Eliminate the OP_VRowid opcode.  The regular OP_Rowid now work for both
regular and virtual tables. (CVS 6537)

FossilOrigin-Name: ecbef45011f1f98d940b2d3492941213d9f04172

16 years agoChange the OP_Rowid opcode so that a deferred OP_Seek is pending, it simply
drh [Wed, 22 Apr 2009 15:32:59 +0000 (15:32 +0000)] 
Change the OP_Rowid opcode so that a deferred OP_Seek is pending, it simply
pulls the rowid from the deferred seek target and does not actually move
the cursor or do a seek.  Other where.c cleanups. (CVS 6536)

FossilOrigin-Name: 1c508a99822caa383e7e24b5d09a9bddd2ee3a00

16 years agoRemove the rowhash object from the code. Rowset now fills its role. (CVS 6535)
drh [Wed, 22 Apr 2009 02:15:47 +0000 (02:15 +0000)] 
Remove the rowhash object from the code.  Rowset now fills its role. (CVS 6535)

FossilOrigin-Name: e963bed0fe3ce5fa32f04b930e5ed0956dc2aa47

16 years agoExtend the Rowset object to contain all the capabilities of Rowhash in
drh [Wed, 22 Apr 2009 00:47:00 +0000 (00:47 +0000)] 
Extend the Rowset object to contain all the capabilities of Rowhash in
addition to its legacy capabilities.  Use Rowset to replace Rowhash.
In addition to requiring less code, This removes the 2^32 result row
limitation, uses less memory, and gives better bounds on worst-case
performance.  The Rowhash implementation has yet to be removed. (CVS 6534)

FossilOrigin-Name: b101cf70b75c9772aaf50e0eadd0cfa37c84d193

16 years agoMove RowHashBlock.nUsed to RowHash.nUsed. Fix a typo in a comment in test_async.c...
danielk1977 [Tue, 21 Apr 2009 18:20:45 +0000 (18:20 +0000)] 
Move RowHashBlock.nUsed to RowHash.nUsed. Fix a typo in a comment in test_async.c. (CVS 6533)

FossilOrigin-Name: 799d31d99fd18a6f99862433384e37d6747ee5b3

16 years agoFix a segfault that followed a malloc failure introduced by (6527). (CVS 6532)
danielk1977 [Tue, 21 Apr 2009 17:23:04 +0000 (17:23 +0000)] 
Fix a segfault that followed a malloc failure introduced by (6527). (CVS 6532)

FossilOrigin-Name: 08e71b114087cfddd36c066265982172fcb41c9a

16 years agoAdjust the rowhash.test module so that it recovers gracefully in the rare
drh [Tue, 21 Apr 2009 17:13:38 +0000 (17:13 +0000)] 
Adjust the rowhash.test module so that it recovers gracefully in the rare
event of a rowid collision. (CVS 6531)

FossilOrigin-Name: 72e1680904a354811cd2956bd57769ee2482c8bb

16 years agoAllocate the initial RowHash object using lookaside. (CVS 6530)
drh [Tue, 21 Apr 2009 16:15:15 +0000 (16:15 +0000)] 
Allocate the initial RowHash object using lookaside. (CVS 6530)

FossilOrigin-Name: 9b30ab7199d8b51bdea8ec7f0410281527623673

16 years agoNew comments and minor refactoring of rowhash.c. (CVS 6529)
drh [Tue, 21 Apr 2009 15:05:18 +0000 (15:05 +0000)] 
New comments and minor refactoring of rowhash.c. (CVS 6529)

FossilOrigin-Name: b8cb4f3e2473afaee7c147a6b3f0972f69391a9a

16 years agoRemove a redundant test from sqlite3_shutdown(). (CVS 6528)
drh [Tue, 21 Apr 2009 12:02:56 +0000 (12:02 +0000)] 
Remove a redundant test from sqlite3_shutdown(). (CVS 6528)

FossilOrigin-Name: 6f481ceb503c7df74d9417a5a7f019ff56261ea8

16 years agoAttempt to optimize virtual table queries with 'OR' expressions in the WHERE clause...
danielk1977 [Tue, 21 Apr 2009 09:02:45 +0000 (09:02 +0000)] 
Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527)

FossilOrigin-Name: f61e4cd93682fd98bea2a71d346f9eaa68454390

16 years agoChange the journal_mode pragma so that it always returns the current
drh [Mon, 20 Apr 2009 17:43:03 +0000 (17:43 +0000)] 
Change the journal_mode pragma so that it always returns the current
journal mode, even on a failed attempt to change the journal mode.
Allow the journal mode to be changed as long as there is not a pending
transaction.  Ticket #3811. (CVS 6526)

FossilOrigin-Name: 419e320ae51639794335d19699f8e1189e524e7d

16 years agoAdd new tests to show that journal_mode=OFF works with locking_mode=EXCLUSIVE
drh [Mon, 20 Apr 2009 13:32:33 +0000 (13:32 +0000)] 
Add new tests to show that journal_mode=OFF works with locking_mode=EXCLUSIVE
as long as the journal_mode is set prior to the first transaction.
Ticket #3811. (CVS 6525)

FossilOrigin-Name: e62ac26f72224a4ba6c7dc5c32b7e4370461764d

16 years agoClarify the documentation to make it clear that sqlite3_interrupt() does not
drh [Mon, 20 Apr 2009 12:31:46 +0000 (12:31 +0000)] 
Clarify the documentation to make it clear that sqlite3_interrupt() does not
effect new SQL statements that are started after the running statement
count reaches zero.  Ticket #3815. (CVS 6524)

FossilOrigin-Name: 3182e8bf69eb4e5e4070930cb9c750942b1dc735

16 years agoDo not use deprecated interfaces internally when compiling with
drh [Mon, 20 Apr 2009 12:07:37 +0000 (12:07 +0000)] 
Do not use deprecated interfaces internally when compiling with
SQLITE_OMIT_DEPRECATED.  Ticket #3813. (CVS 6523)

FossilOrigin-Name: 7f17956dfbf3090fd5832378e77bd83a525fed9d

16 years agoSpeed improvements by avoiding unnecessary calls to fstat() and ftruncate(). (CVS...
drh [Mon, 20 Apr 2009 11:34:26 +0000 (11:34 +0000)] 
Speed improvements by avoiding unnecessary calls to fstat() and ftruncate(). (CVS 6522)

FossilOrigin-Name: 5b7e3a411a6f2fe296675de9467783f6625cff3f

16 years agoUpdate comments and remove unused code in btree.c. No functional changes. (CVS 6521)
drh [Sun, 19 Apr 2009 20:51:06 +0000 (20:51 +0000)] 
Update comments and remove unused code in btree.c.  No functional changes. (CVS 6521)

FossilOrigin-Name: bd860184909b7a9cc32c59770ebcee0efdc491f0

16 years agoMake extra calls to sqlite3_shutdown() be harmless no-ops. (CVS 6520)
drh [Sun, 19 Apr 2009 12:23:58 +0000 (12:23 +0000)] 
Make extra calls to sqlite3_shutdown() be harmless no-ops. (CVS 6520)

FossilOrigin-Name: d80822953c2d2f2fd7f6acdd3caa403c0decacc4

16 years agoRevise the implementation of sqlite3_initialize() slightly in order to make
drh [Fri, 17 Apr 2009 16:54:22 +0000 (16:54 +0000)] 
Revise the implementation of sqlite3_initialize() slightly in order to make
it more easily testable.  The functionality should be unchanged. (CVS 6519)

FossilOrigin-Name: bb1a390a3d2f79b27e3ec2514ae00f5b22dbfb06

16 years agoGet the behavior of SQLITE_HAVE_ISNAN right. It was reversed
drh [Fri, 17 Apr 2009 15:18:47 +0000 (15:18 +0000)] 
Get the behavior of SQLITE_HAVE_ISNAN right.  It was reversed
in check-in (6517).  Ticket #3809. (CVS 6518)

FossilOrigin-Name: 97c6ea2368556b2a9a914ba2322085e312598b15

16 years agoAdd the SQLITE_HAVE_ISNAN compile-time option which, if present, causes
drh [Fri, 17 Apr 2009 11:57:22 +0000 (11:57 +0000)] 
Add the SQLITE_HAVE_ISNAN compile-time option which, if present, causes
SQLite to use the math library isnan() function rather than its own homebrew
implementation of isnan(). (CVS 6517)

FossilOrigin-Name: 54d23521c37938b9d98f41f5547975c469c0c8f0

16 years agoCheck-in (6514) did not completely remove the obsolete test, resulting in a
drh [Fri, 17 Apr 2009 11:56:27 +0000 (11:56 +0000)] 
Check-in (6514) did not completely remove the obsolete test, resulting in a
segfault.  This check-in finishes the job.  Ticket #3802. (CVS 6516)

FossilOrigin-Name: c29b37ea36fe6a360807e66dffc467c66be00d38

16 years agoAdd NEVER and ALWAYS tags to conditionals in analyze.c that always false or
drh [Thu, 16 Apr 2009 17:45:47 +0000 (17:45 +0000)] 
Add NEVER and ALWAYS tags to conditionals in analyze.c that always false or
true. (CVS 6515)

FossilOrigin-Name: fbbc80eaf3bb3726b053d1050104b4ec602eb0c1

16 years agoRemove obsolete test from bindxfer.tcl. Ticket #3802. (CVS 6514)
drh [Thu, 16 Apr 2009 16:32:20 +0000 (16:32 +0000)] 
Remove obsolete test from bindxfer.tcl.  Ticket #3802. (CVS 6514)

FossilOrigin-Name: b1b096171812f77082b0b63e7ab0908c82d1d8bb

16 years agoChanges to alter.c to enable full branch coverage testing. (CVS 6513)
drh [Thu, 16 Apr 2009 16:30:17 +0000 (16:30 +0000)] 
Changes to alter.c to enable full branch coverage testing. (CVS 6513)

FossilOrigin-Name: 6a91ab08a55eacc77f69190e1126326f4da220af

16 years agoMake sure the 'unixepoch' converter in the date and time functions rounds
drh [Thu, 16 Apr 2009 12:58:03 +0000 (12:58 +0000)] 
Make sure the 'unixepoch' converter in the date and time functions rounds
to the nearest millisecond rather than truncating downward to the next
smaller millisecond.  Ticket #3808. (CVS 6512)

FossilOrigin-Name: e6e036b345b130c207716c4b81719b5b7c884a11

16 years agoIn a 3-fold compound SELECT make sure early code generation of the SELECTs
drh [Thu, 16 Apr 2009 00:24:23 +0000 (00:24 +0000)] 
In a 3-fold compound SELECT make sure early code generation of the SELECTs
to the right do not dereference non-existant columns in SELECTs on the left. (CVS 6511)

FossilOrigin-Name: 414f340809c487901fa913026a342b19a2956c0a

16 years agoFix the group_concat() function so that it inserts the separator string
drh [Wed, 15 Apr 2009 15:16:53 +0000 (15:16 +0000)] 
Fix the group_concat() function so that it inserts the separator string
even if the initial content strings are empty.  Ticket #3806. (CVS 6510)

FossilOrigin-Name: b83fbf15a3920755ed77dc9c91b4f00a86ddb9ac

16 years agoFix access violation on WinCE platforms. Ticket #3804. (CVS 6509)
shane [Wed, 15 Apr 2009 14:36:25 +0000 (14:36 +0000)] 
Fix access violation on WinCE platforms.  Ticket #3804. (CVS 6509)

FossilOrigin-Name: e203ad400dd61431b3e6b8219eb5357b6ca06561

16 years agoMark an branch in alter.c as always false. Only run the assert() on
drh [Wed, 15 Apr 2009 13:39:47 +0000 (13:39 +0000)] 
Mark an branch in alter.c as always false.  Only run the assert() on
the sqlite3_aggregate_count() function in func.c if the
SQLITE_OMIT_DEPRECATED compile-time option is off. (CVS 6508)

FossilOrigin-Name: c0bba77ae619e709f3fb068526073a4a83cf33b6

16 years agoDisable the temptrigger.test test script when shared cache is disabled.
drh [Wed, 15 Apr 2009 13:07:19 +0000 (13:07 +0000)] 
Disable the temptrigger.test test script when shared cache is disabled.
Ticket #3801. (CVS 6507)

FossilOrigin-Name: feedbce8f149820d082ecde4437109cc6b6ea0e3

16 years agonMax can be zero and subtracting 1 from an unsigned zero produces undesirable results...
aswift [Tue, 14 Apr 2009 18:44:38 +0000 (18:44 +0000)] 
nMax can be zero and subtracting 1 from an unsigned zero produces undesirable results (CVS 6506)

FossilOrigin-Name: a117d82dad82bc372bc1e3f1adb9540c1accf851

16 years agoChange the sqlite3_bind_value() implementation to use a default branch on
drh [Tue, 14 Apr 2009 12:58:20 +0000 (12:58 +0000)] 
Change the sqlite3_bind_value() implementation to use a default branch on
the type switch so that there are no untested jumps in the switch. (CVS 6505)

FossilOrigin-Name: d0a8bd6a53c5da0ac6b88818f82c7f7d330b527a

16 years agoReimplement the sqlite3_bind_value() interface so that it works when the
drh [Tue, 14 Apr 2009 12:43:33 +0000 (12:43 +0000)] 
Reimplement the sqlite3_bind_value() interface so that it works when the
value being bound comes from a different database connection. (CVS 6504)

FossilOrigin-Name: 3db0c7980668cf38165add13f833863cd00a0cfe

16 years agoEnhancements to virtual table documentation. Comment changes only. No changes to
drh [Mon, 13 Apr 2009 14:43:40 +0000 (14:43 +0000)] 
Enhancements to virtual table documentation.  Comment changes only. No changes to
code. (CVS 6503)

FossilOrigin-Name: b0b2b2831cc84d57e90bf587ebed600fa72926e9

16 years agoVersion 3.6.13 (CVS 6502)
drh [Mon, 13 Apr 2009 09:29:04 +0000 (09:29 +0000)] 
Version 3.6.13 (CVS 6502)

FossilOrigin-Name: 982cc7f4e7e2d8abfc2025dfbec7c1ce8f95383b

16 years agoRerun autoconf in preparation for 3.6.13. (CVS 6501)
drh [Mon, 13 Apr 2009 09:09:24 +0000 (09:09 +0000)] 
Rerun autoconf in preparation for 3.6.13. (CVS 6501)

FossilOrigin-Name: f683e222112339d1f7980276e403efda76a18ebf

16 years agoupdated Makefile.vxwSH4 and renamed it to Makefile.vxworks,
chw [Mon, 13 Apr 2009 08:14:03 +0000 (08:14 +0000)] 
updated Makefile.vxwSH4 and renamed it to Makefile.vxworks,
should now be able to support SH4 and PPC targets. (CVS 6500)

FossilOrigin-Name: e4a370c72dd3204be099a6706128507d5c06170c

16 years agoFix malloc5.test so it work on both 64-bit and 32-bit systems. The
drh [Sat, 11 Apr 2009 19:09:53 +0000 (19:09 +0000)] 
Fix malloc5.test so it work on both 64-bit and 32-bit systems.  The
::tcl_platform(wordSize) variable has to be used to adjust some memory
sizes. (CVS 6499)

FossilOrigin-Name: ea20f78edb50778c40ed7f03f894ab898f58d67c

16 years agoFix an obscure problem with recovery from I/O errors while rolling back. (CVS 6498)
drh [Sat, 11 Apr 2009 16:27:49 +0000 (16:27 +0000)] 
Fix an obscure problem with recovery from I/O errors while rolling back. (CVS 6498)

FossilOrigin-Name: 24ff486125b9ad62dd92314b62299093b55fe82b

16 years agoAdd a comments and an assert() to the virtual table implementation.
drh [Sat, 11 Apr 2009 16:27:19 +0000 (16:27 +0000)] 
Add a comments and an assert() to the virtual table implementation.
No functional changes. (CVS 6497)

FossilOrigin-Name: ac5d0c0aa1de687bde972fbf0db8f04508825205

16 years agoFix a case where a corrupt database could cause an assert() to fail. (CVS 6496)
danielk1977 [Sat, 11 Apr 2009 16:06:15 +0000 (16:06 +0000)] 
Fix a case where a corrupt database could cause an assert() to fail. (CVS 6496)

FossilOrigin-Name: 2c560e057e1da8a603efc36deea036f2392a4ab9

16 years agoAllocate a little extra scratch space for the memsubsys1 tests. The
drh [Sat, 11 Apr 2009 14:46:43 +0000 (14:46 +0000)] 
Allocate a little extra scratch space for the memsubsys1 tests.  The
extra space is needed in some configurations. (CVS 6495)

FossilOrigin-Name: 5484419294356b704c2c9064f36ed254875ca8c0

16 years agoIncrease the hard upper bound on the number of pcache pages in test_pcache
drh [Sat, 11 Apr 2009 11:38:53 +0000 (11:38 +0000)] 
Increase the hard upper bound on the number of pcache pages in test_pcache
when the test harness is compiled for in-memory temp tables.  Some of the
test cases need to extra memory to avoid unplanned out of memory errors. (CVS 6494)

FossilOrigin-Name: 7f2d6a0bd510801e011eb075f494194d9ebf568b

16 years agoReplace invocation of (really_finish_test) from async.test with (finish_test). Otherw...
danielk1977 [Sat, 11 Apr 2009 10:25:03 +0000 (10:25 +0000)] 
Replace invocation of (really_finish_test) from async.test with (finish_test). Otherwise a tcl exception may be thrown when running permutations. (CVS 6493)

FossilOrigin-Name: e6465e9da3d754833c21e0fb76c16a4efd047b91

16 years agoIn sqlite3PagerMovepage(), avoid holding a reference to page number X when calling...
danielk1977 [Sat, 11 Apr 2009 09:51:55 +0000 (09:51 +0000)] 
In sqlite3PagerMovepage(), avoid holding a reference to page number X when calling sqlite3PcacheRekey() to move another page to page number X. (CVS 6492)

FossilOrigin-Name: 4447c94f45b8abd833eb82b67233029088fd1a54

16 years agoRemove more unused branches from vdbeapi.c. (CVS 6491)
drh [Fri, 10 Apr 2009 23:11:31 +0000 (23:11 +0000)] 
Remove more unused branches from vdbeapi.c. (CVS 6491)

FossilOrigin-Name: 447e959594970a225a9b189e7e420ba9c3eedbdb

16 years agoIn the async test, make sure procedures do not get renamed over top of one
drh [Fri, 10 Apr 2009 20:55:13 +0000 (20:55 +0000)] 
In the async test, make sure procedures do not get renamed over top of one
another. (CVS 6490)

FossilOrigin-Name: b6430cc4297c426f89e68f180a2c50b9b1ecd8e3

16 years agoRemove unused branches from the vdbeapi.c module. (CVS 6489)
drh [Fri, 10 Apr 2009 20:32:00 +0000 (20:32 +0000)] 
Remove unused branches from the vdbeapi.c module. (CVS 6489)

FossilOrigin-Name: 7ae0fc7ea55dc5b5fbeef20f476a00f619bd3c5c

16 years agoIncrease the error tolerance when verifying the approximate size of a pseudo-random...
danielk1977 [Fri, 10 Apr 2009 18:41:01 +0000 (18:41 +0000)] 
Increase the error tolerance when verifying the approximate size of a pseudo-random database in backup_ioerr.test. Otherwise the test could fail depending on the PRNG seed. (CVS 6488)

FossilOrigin-Name: deda5ab35e7663ba5f30c08b16ef3393d7146816

16 years agoDo not run io.test as part of the inmemory_journal permutation. io.test uses the...
danielk1977 [Fri, 10 Apr 2009 18:32:29 +0000 (18:32 +0000)] 
Do not run io.test as part of the inmemory_journal permutation. io.test uses the tcl API to test for journal files in the file-system (which of course never exist when running with in-memory journals). (CVS 6487)

FossilOrigin-Name: 493f03bd73a15de994f69f23e9df8bb3ee4d20dc