]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
16 years agoCorrect and clarify the documentation on the third parameter to
drh [Sun, 24 May 2009 11:07:49 +0000 (11:07 +0000)] 
Correct and clarify the documentation on the third parameter to
sqlite3_create_function(). (CVS 6672)

FossilOrigin-Name: 6b7929ed36fa14291b6cb09de5808100945ad7a0

16 years agoDo not transform a WHERE clause of the form "a = ? OR a = ?" to "a IN (?, ?)" if...
danielk1977 [Fri, 22 May 2009 15:43:26 +0000 (15:43 +0000)] 
Do not transform a WHERE clause of the form "a = ? OR a = ?" to "a IN (?, ?)" if "a" is a column of a virtual table. Ticket #3871. (CVS 6671)

FossilOrigin-Name: fad88e71cf195e703f7b56b13f0c1818fd0dac84

16 years agoAdd an assert() to pcache1.c to double-check that page cache buffer memory
drh [Fri, 22 May 2009 11:12:23 +0000 (11:12 +0000)] 
Add an assert() to pcache1.c to double-check that page cache buffer memory
is never allocated if pcache1 is not enabled.  Ticket #3872 (CVS 6670)

FossilOrigin-Name: 93369d91abe10975507ea9302c145e3ddd0c2c76

16 years agoAdditional changes to pcache1 to prevent the page buffer memory from being
drh [Fri, 22 May 2009 11:10:24 +0000 (11:10 +0000)] 
Additional changes to pcache1 to prevent the page buffer memory from being
configured if pcache1 is not enabled.  Ticket #3872. (CVS 6669)

FossilOrigin-Name: 5153ad19daf0f3b0334b2a06655142899203abbf

16 years agoMake sure sqlite3_shutdown() completely disables the default pager cache
drh [Fri, 22 May 2009 10:53:29 +0000 (10:53 +0000)] 
Make sure sqlite3_shutdown() completely disables the default pager cache
mechanism in pcache1.c.  Ticket #3872.  Also fix some comments associated
with configuring the page cache. (CVS 6668)

FossilOrigin-Name: 6240992cef5cb867d7a638f1906d05aa8efd0652

16 years agoAdd omitted word in the documentation for total_change_count().
drh [Fri, 22 May 2009 01:02:26 +0000 (01:02 +0000)] 
Add omitted word in the documentation for total_change_count().
ticket #3870. (CVS 6667)

FossilOrigin-Name: 3f6fd16f92a16445891142b0a7dc9f6d6dc06546

16 years agoFix an 8-byte alignment problem on HP/UX. Ticket #3869 (CVS 6666)
drh [Fri, 22 May 2009 01:00:12 +0000 (01:00 +0000)] 
Fix an 8-byte alignment problem on HP/UX.  Ticket #3869 (CVS 6666)

FossilOrigin-Name: fc64f8509299a398ac1513e1778f271083e3eabc

16 years agoSimplifications to expr.c in support of full coverage testing. (CVS 6665)
drh [Thu, 21 May 2009 20:41:32 +0000 (20:41 +0000)] 
Simplifications to expr.c in support of full coverage testing. (CVS 6665)

FossilOrigin-Name: 309adb5e22af2735b69460c164d870aea99c6da3

16 years agoIn the CLI in the ".dump" command, do not attempt to clear the sqlite_sequence
drh [Thu, 21 May 2009 15:15:00 +0000 (15:15 +0000)] 
In the CLI in the ".dump" command, do not attempt to clear the sqlite_sequence
table until the first row of content of that table is seen.  Ticket #3867 (CVS 6664)

FossilOrigin-Name: bedd5ad1942021ef2b3defde3ff3e8aead86137e

16 years agoIn the CLI, always "dump" the sqlite_sequence table last. Ticket #3867 (CVS 6663)
drh [Thu, 21 May 2009 14:51:03 +0000 (14:51 +0000)] 
In the CLI, always "dump" the sqlite_sequence table last.  Ticket #3867 (CVS 6663)

FossilOrigin-Name: a0028d4808275cb1d020d56344d90b2a04603f4d

16 years agoAdd conditional 'extern "C"' block to sqlite3async.h. Ticket #3866. (CVS 6662)
danielk1977 [Thu, 21 May 2009 04:42:19 +0000 (04:42 +0000)] 
Add conditional 'extern "C"' block to sqlite3async.h. Ticket #3866. (CVS 6662)

FossilOrigin-Name: e4d1b117c90dca341bfa74291c7dfc2afca38cc6

16 years agoFix a memory leak that occurs when an out-of-memory error occurs while
drh [Wed, 20 May 2009 20:10:47 +0000 (20:10 +0000)] 
Fix a memory leak that occurs when an out-of-memory error occurs while
preparing a statement that has multiple virtual table updates within
triggers.  Other virtual table changes to support full-coverage testing. (CVS 6661)

FossilOrigin-Name: 02b77a582c65e0eb45eb1a9abbdeef11f52d7ce6

16 years agoRemove unused, undocumented, and untested error reporting logic from the
drh [Wed, 20 May 2009 16:22:02 +0000 (16:22 +0000)] 
Remove unused, undocumented, and untested error reporting logic from the
xFindFunction interface in virtual tables. (CVS 6660)

FossilOrigin-Name: 55d6ced262f5281076e4a68097ed21e150a9c225

16 years agoUpdates to the extension loading logic to support full coverage testing. (CVS 6659)
drh [Wed, 20 May 2009 02:40:45 +0000 (02:40 +0000)] 
Updates to the extension loading logic to support full coverage testing. (CVS 6659)

FossilOrigin-Name: 929cfbc66f6e2ea6b44417305d0f4ae36567c9bf

16 years agoChanges to select.c to facilitate full coverage testing. (CVS 6658)
drh [Tue, 19 May 2009 19:04:58 +0000 (19:04 +0000)] 
Changes to select.c to facilitate full coverage testing. (CVS 6658)

FossilOrigin-Name: f678ed34faab88f4e126e553119773386c7c84fa

16 years agoImprovements to the SQLITE_INT_TO_PTR macro to reduce the number of
drh [Tue, 19 May 2009 14:21:28 +0000 (14:21 +0000)] 
Improvements to the SQLITE_INT_TO_PTR macro to reduce the number of
warnings.  For some platforms it might be necessary to compile with
the -DHAVE_STDINT_H flag.  Ticket #3860. (CVS 6657)

FossilOrigin-Name: 1b0ee9d188c000a2331caae2e9c8b89b0bcbc0b0

16 years agoUpdate the showdb.c utility so that it works with databases larger than 4GiB. (CVS...
drh [Tue, 19 May 2009 03:21:52 +0000 (03:21 +0000)] 
Update the showdb.c utility so that it works with databases larger than 4GiB. (CVS 6656)

FossilOrigin-Name: 9675b6223645fe01b202cbefae63f3209a50efcc

16 years agoFix memdb.test so that it works when OMIT_AUTOVACUUM is defined. (CVS 6649)
danielk1977 [Mon, 18 May 2009 16:04:38 +0000 (16:04 +0000)] 
Fix memdb.test so that it works when OMIT_AUTOVACUUM is defined. (CVS 6649)

FossilOrigin-Name: 8c3c0c24c82606df41653dbf7324bf9f166c933a

16 years agoChanges to select.c in support of full coverage testing. (CVS 6647)
drh [Mon, 18 May 2009 15:46:07 +0000 (15:46 +0000)] 
Changes to select.c in support of full coverage testing. (CVS 6647)

FossilOrigin-Name: e225f365bd9353f753161887e05fe1eccaf9be1d

16 years agoFix a typo on a comment associated with check-in (6641) and ticket #3860. (CVS 6646)
drh [Mon, 18 May 2009 13:34:37 +0000 (13:34 +0000)] 
Fix a typo on a comment associated with check-in (6641) and ticket #3860. (CVS 6646)

FossilOrigin-Name: 43051e0315246d734a81ccef2cf1a0cc159f239b

16 years agoRemove debugging code accidently left in check-in (6642). Ticket #3862. (CVS 6645)
drh [Sun, 17 May 2009 15:29:31 +0000 (15:29 +0000)] 
Remove debugging code accidently left in check-in (6642).  Ticket #3862. (CVS 6645)

FossilOrigin-Name: 0d974613473b9d2af71638248a57036f903ef387

16 years agoTake care to free the memory for the ORDER BY clause on SELECT statements
drh [Sun, 17 May 2009 15:26:20 +0000 (15:26 +0000)] 
Take care to free the memory for the ORDER BY clause on SELECT statements
containing errors and contained within triggers.  Ticket #3863. (CVS 6644)

FossilOrigin-Name: dd665eac8c04259e44a95827ebd1f037460fe1b2

16 years agoFix a typo in the sqlite3_blob_open() documentation. (CVS 6643)
drh [Sun, 17 May 2009 12:07:47 +0000 (12:07 +0000)] 
Fix a typo in the sqlite3_blob_open() documentation. (CVS 6643)

FossilOrigin-Name: 92866482ef7cc91b5ac7bebec7e6edf900aa64c6

16 years agoTweaks and simplifications to select.c to facility full coverage testing. (CVS 6642)
drh [Sun, 17 May 2009 02:06:14 +0000 (02:06 +0000)] 
Tweaks and simplifications to select.c to facility full coverage testing. (CVS 6642)

FossilOrigin-Name: e3ccbc69babd05d45db8065f6612751eda1aa645

16 years agoAttempt to provide a version of the SQLITE_INT_TO_PTR macro that works
drh [Sat, 16 May 2009 17:38:21 +0000 (17:38 +0000)] 
Attempt to provide a version of the SQLITE_INT_TO_PTR macro that works
on both llvm-gcc-4.2 and MSVC.  Ticket #3860. (CVS 6641)

FossilOrigin-Name: ddee7ff23e9a396cab89d20ff9fc4cf3dfd4561c

16 years agoRe-enable file locking in async4.test. (CVS 6640)
danielk1977 [Fri, 15 May 2009 14:41:40 +0000 (14:41 +0000)] 
Re-enable file locking in async4.test. (CVS 6640)

FossilOrigin-Name: f7098187280866a56563c7614513a40becd172e0

16 years agoDocumentation enhancements for sqlite3_update_hook(), sqlite3_commit_hook(),
drh [Thu, 14 May 2009 22:37:47 +0000 (22:37 +0000)] 
Documentation enhancements for sqlite3_update_hook(), sqlite3_commit_hook(),
and the various incremental blob I/O routines.  No changes to code. (CVS 6639)

FossilOrigin-Name: e8ca932d8c7e1753c159041499355724d3e78b35

16 years agoChange the sqlite3_backup_finish() interface so that calling it with
drh [Thu, 14 May 2009 19:26:51 +0000 (19:26 +0000)] 
Change the sqlite3_backup_finish() interface so that calling it with
a NULL pointer is a harmless no-op.  One other change to backup.c to facilitate
full coverage testing. (CVS 6638)

FossilOrigin-Name: 06bc89177b3af20751d9567a68551d2d31c3fe8b

16 years agoDocumentation updates to better explain the SQLITE_OPEN_EXCLUSIVE flag. Ticket ...
shane [Thu, 14 May 2009 03:21:28 +0000 (03:21 +0000)] 
Documentation updates to better explain the SQLITE_OPEN_EXCLUSIVE flag.  Ticket #3855. (CVS 6637)

FossilOrigin-Name: 6bd44f36f46810eb9ce30c7780de6bcfe4aadf5f

16 years agoAdditional simplifications to build.c in support full coverage testing. (CVS 6636)
drh [Wed, 13 May 2009 22:58:28 +0000 (22:58 +0000)] 
Additional simplifications to build.c in support full coverage testing. (CVS 6636)

FossilOrigin-Name: 913d11149396d3dc797f1efeb4f7e60865483399

16 years agoRemove incorrect NEVER() macro in the previous check-in (6634). (CVS 6635)
drh [Wed, 13 May 2009 17:35:23 +0000 (17:35 +0000)] 
Remove incorrect NEVER() macro in the previous check-in (6634). (CVS 6635)

FossilOrigin-Name: c684957991fe45cbcb188d2a419501c3f1fdc93f

16 years agoChanges to build.c to help facilitate full coverage testing. (CVS 6634)
drh [Wed, 13 May 2009 17:21:13 +0000 (17:21 +0000)] 
Changes to build.c to help facilitate full coverage testing. (CVS 6634)

FossilOrigin-Name: 264ace50bbaec3468de0e42b2b8cebf9ce1d6682

16 years agoDo not run async4.test as part of the "journaltest" permutation. It specifically...
danielk1977 [Wed, 13 May 2009 14:46:09 +0000 (14:46 +0000)] 
Do not run async4.test as part of the "journaltest" permutation. It specifically tests that the asynchronous IO backend can be configured to violate the assumptions made by journaltest. (CVS 6633)

FossilOrigin-Name: b19bf39bbae96aeb6e742fb9fb1c33d0e251ad7f

16 years agoWhen locking a database file, check if any backup objects need to be restarted even...
danielk1977 [Wed, 13 May 2009 07:52:06 +0000 (07:52 +0000)] 
When locking a database file, check if any backup objects need to be restarted even if the page cache is empty. Ticket #3858. (CVS 6632)

FossilOrigin-Name: 90309008c35494c7a075fe76f7eb96b09a01d01b

16 years agoRemove debugging comments left in the prior check-in by mistake. (CVS 6631)
drh [Tue, 12 May 2009 18:00:37 +0000 (18:00 +0000)] 
Remove debugging comments left in the prior check-in by mistake. (CVS 6631)

FossilOrigin-Name: 8207056036e17b99ab660edd650c5a6de1353299

16 years agoMove the sqlite3MinimumFileFormat() routine from build.c over to alter.c
drh [Tue, 12 May 2009 17:46:53 +0000 (17:46 +0000)] 
Move the sqlite3MinimumFileFormat() routine from build.c over to alter.c
since alter.c is the only code that uses it.  Additional changes and
cleanup to build.c to facility coverage testing. (CVS 6630)

FossilOrigin-Name: 6fe3750a30ab432ed476c2ae6b58972187abc624

16 years agoMake sure the SQLITE_OPEN_EXCLUSIVE flag is ignored by sqlite3_open_v2().
drh [Tue, 12 May 2009 13:35:11 +0000 (13:35 +0000)] 
Make sure the SQLITE_OPEN_EXCLUSIVE flag is ignored by sqlite3_open_v2().
That flag is to be used by the VFS interface only.  Ticket #3855. (CVS 6629)

FossilOrigin-Name: c37f0279ebfaf76b4086e6d16b6e12633424c27d

16 years agoTweaks to build.c to facilitate coverage testing. (CVS 6628)
drh [Tue, 12 May 2009 00:40:12 +0000 (00:40 +0000)] 
Tweaks to build.c to facilitate coverage testing. (CVS 6628)

FossilOrigin-Name: 6572b438a02cc44546174e132dfbdc1d141cd451

16 years agoIf a virtual table constructor returns SQLITE_NOMEM, set the mallocFailed
drh [Mon, 11 May 2009 23:37:59 +0000 (23:37 +0000)] 
If a virtual table constructor returns SQLITE_NOMEM, set the mallocFailed
flag in the corresponding database connection to insure that the error
is propagated back to the top layer. (CVS 6627)

FossilOrigin-Name: 5635666f20358e854a76d244768198734afd4299

16 years agoRework the logic that generates a schema for tables created using
drh [Mon, 11 May 2009 20:53:28 +0000 (20:53 +0000)] 
Rework the logic that generates a schema for tables created using
"CREATE TABLE ... AS SELECT ...".  Instead of trying to copy the raw
datatype string from the right-hand side, just make the type one
of TEXT, INT, REAL, NUM, or nothing.  This is much simpler than
trying to parse and quote datatype strings.  Other minor
implifications to build.c are bundled with this change. (CVS 6626)

FossilOrigin-Name: 33cf83591e6e13875ef6ada5b8ac8ab07619d8bc

16 years agoEnhance the parser to allow nested parentheses in the module argument of
drh [Mon, 11 May 2009 18:22:30 +0000 (18:22 +0000)] 
Enhance the parser to allow nested parentheses in the module argument of
a CREATE VIRTUAL TABLE statement. (CVS 6625)

FossilOrigin-Name: 93772bd7f56a5158eb46a992ba932f4695cb219f

16 years agoConvert an always-true condition in hash.c into an assert(). (CVS 6624)
drh [Sat, 9 May 2009 23:29:12 +0000 (23:29 +0000)] 
Convert an always-true condition in hash.c into an assert(). (CVS 6624)

FossilOrigin-Name: 4237299935b8bf8c346aacba021113224813bcb9

16 years agoAdd the SQLITE_TESTCTRL_ASSERT and SQLITE_TESTCTRL_ALWAYS codes for the
drh [Sat, 9 May 2009 18:59:42 +0000 (18:59 +0000)] 
Add the SQLITE_TESTCTRL_ASSERT and SQLITE_TESTCTRL_ALWAYS codes for the
sqlite3_test_control() interface. (CVS 6623)

FossilOrigin-Name: 38df91c2edebee22d02b5f84260ee9e5e14db48e

16 years agoChange sqlite_blob_open() so that it zeros the output pBlob pointer when
drh [Sat, 9 May 2009 15:17:47 +0000 (15:17 +0000)] 
Change sqlite_blob_open() so that it zeros the output pBlob pointer when
it fails.  The other sqlite3_blob interfaces accept a NULL pointer as
input. (CVS 6622)

FossilOrigin-Name: 999d507b4432b518cfc7e02e5b0a2473cf1980f6

16 years agoChanges to the trigger.c module that facilitate full coverage testing. (CVS 6621)
drh [Sat, 9 May 2009 00:18:38 +0000 (00:18 +0000)] 
Changes to the trigger.c module that facilitate full coverage testing. (CVS 6621)

FossilOrigin-Name: 567ccc68cc8c73b952a91c71a0e00b08bb25c689

16 years agoFix a warning in the osx-specific part of os_unix.c. Ticket #3847. (CVS 6620)
danielk1977 [Fri, 8 May 2009 11:34:37 +0000 (11:34 +0000)] 
Fix a warning in the osx-specific part of os_unix.c. Ticket #3847. (CVS 6620)

FossilOrigin-Name: 254ca3273cfbd833de82296b4859e1ec5535e8be

16 years agoCorrectly update the cache page-count when discarding pages in the xTruncate() method...
danielk1977 [Fri, 8 May 2009 06:52:47 +0000 (06:52 +0000)] 
Correctly update the cache page-count when discarding pages in the xTruncate() method of the default pcache implementation. Otherwise the effective configured size of the cache shrinks each time xTruncate() is called. Fix for #3844. (CVS 6619)

FossilOrigin-Name: 88211ceeec01ee0d3e55231512be26dd672db099

16 years agoIf compiling FTS3 in the amalgamation, include the ctype.h header file.
drh [Thu, 7 May 2009 14:11:52 +0000 (14:11 +0000)] 
If compiling FTS3 in the amalgamation, include the ctype.h header file.
Ticket #3843. (CVS 6618)

FossilOrigin-Name: 660108ef7a3c45f735789ba1039be2c37a8b0d0e

16 years agoChange the sqlite3_create_function() family of routines to return
drh [Thu, 7 May 2009 13:43:49 +0000 (13:43 +0000)] 
Change the sqlite3_create_function() family of routines to return
SQLITE_MISUSE instead of SQLITE_ERROR if their parameters are incorrect. (CVS 6617)

FossilOrigin-Name: 866f13e28c6fdb98947e1c7a89b7855bb5bbdb96

16 years agoMake sure the iteration counter on aggregate functions is reset each
drh [Thu, 7 May 2009 12:17:33 +0000 (12:17 +0000)] 
Make sure the iteration counter on aggregate functions is reset each
time the aggregate is used in an correlated subquery.  Ticket #3841. (CVS 6616)

FossilOrigin-Name: 4a86de35d57a0c8720772c29431c86cd9be1fb9b

16 years agoVersion 3.6.14 (CVS 6615)
drh [Thu, 7 May 2009 02:26:07 +0000 (02:26 +0000)] 
Version 3.6.14 (CVS 6615)

FossilOrigin-Name: 469ad1ded35f5ff8ab2f6e8f776d73a9cea73527

16 years agoFix compiler warning found with gcc -Wextra. (CVS 6614)
drh [Wed, 6 May 2009 19:03:13 +0000 (19:03 +0000)] 
Fix compiler warning found with gcc -Wextra. (CVS 6614)

FossilOrigin-Name: 93bdbc5e2f9771a30358cde03f0d3cb708d73d48

16 years agoChanges to silence compiler warnings under MSVC. (CVS 6613)
shane [Wed, 6 May 2009 18:57:09 +0000 (18:57 +0000)] 
Changes to silence compiler warnings under MSVC. (CVS 6613)

FossilOrigin-Name: df599237e1ca8b4f361477a712cf761aa1fac3df

16 years agoFix three variable initialization problems found by valgrind. (CVS 6612)
drh [Wed, 6 May 2009 18:42:21 +0000 (18:42 +0000)] 
Fix three variable initialization problems found by valgrind. (CVS 6612)

FossilOrigin-Name: 37428435978027f6baffa552306dd5dc29ce5cd5

16 years agoupdated vxworks makefile for 3.6.14 release (CVS 6611)
chw [Wed, 6 May 2009 15:24:04 +0000 (15:24 +0000)] 
updated vxworks makefile for 3.6.14 release (CVS 6611)

FossilOrigin-Name: 5d4bffaabbf6a809938f115de266b382183a0a96

16 years agoAdd a short pause to force a context swap while waiting for a separate process
drh [Wed, 6 May 2009 00:52:40 +0000 (00:52 +0000)] 
Add a short pause to force a context swap while waiting for a separate process
to clear its lock in the lock4.test script. (CVS 6610)

FossilOrigin-Name: 4357e76d53f692cb7495fbde61b4b7580560f816

16 years agoFix the test case misc3-6.11 so that it works correctly on UTF16 databases
drh [Wed, 6 May 2009 00:49:00 +0000 (00:49 +0000)] 
Fix the test case misc3-6.11 so that it works correctly on UTF16 databases
after the fix of for ticket #3838, check-in (6603) (CVS 6609)

FossilOrigin-Name: c1e739e39b1df205f3beb4088ce7760a0d56359f

16 years agoMinor changes to the sqlite3_exec() implementation in legacy.c
drh [Tue, 5 May 2009 20:02:47 +0000 (20:02 +0000)] 
Minor changes to the sqlite3_exec() implementation in legacy.c
to facility full coverage testing. (CVS 6608)

FossilOrigin-Name: 9e3016c1846174a64833394a00a09335e8446de8

16 years agoBump the version number up to 3.6.14. (CVS 6607)
drh [Tue, 5 May 2009 18:01:58 +0000 (18:01 +0000)] 
Bump the version number up to 3.6.14. (CVS 6607)

FossilOrigin-Name: f4549904b22ff2340a5830cd67ed001d1c4730a1

16 years agoChanges to vacuum.c to facilitate full coverage testing. (CVS 6606)
drh [Tue, 5 May 2009 17:37:22 +0000 (17:37 +0000)] 
Changes to vacuum.c to facilitate full coverage testing. (CVS 6606)

FossilOrigin-Name: 866284654c1f163af4164fe8c698d30af32e4eaa

16 years agoMake sure the left-shift operator never overflows. (CVS 6605)
drh [Tue, 5 May 2009 15:46:43 +0000 (15:46 +0000)] 
Make sure the left-shift operator never overflows. (CVS 6605)

FossilOrigin-Name: 300da30178c46ab9f2ceb0c3e3ee3eac73d5d8e1

16 years agoChanges to update.c to facilitate full coverage testing. (CVS 6604)
drh [Tue, 5 May 2009 15:46:09 +0000 (15:46 +0000)] 
Changes to update.c to facilitate full coverage testing. (CVS 6604)

FossilOrigin-Name: 25a11b9ecae1befd3f58958d68f6346f1e1e47ad

16 years agoMake sure the default value on a column added using ALTER TABLE has the
drh [Tue, 5 May 2009 12:54:50 +0000 (12:54 +0000)] 
Make sure the default value on a column added using ALTER TABLE has the
correct encoding.  Ticket #3838. (CVS 6603)

FossilOrigin-Name: 7f89a860b7cd0993c36a8b0482c2bac950a875d6

16 years agoMake sure va_arg() does not occur on the same line as any "if" statement
drh [Mon, 4 May 2009 20:20:16 +0000 (20:20 +0000)] 
Make sure va_arg() does not occur on the same line as any "if" statement
or "?" operator. (CVS 6602)

FossilOrigin-Name: 3543be6e34ebff48b1b0c1710ae6fec557b09b52

16 years agoAvoid parsing cells that fit entirely on the b-tree page when searching a b-tree...
danielk1977 [Mon, 4 May 2009 19:01:26 +0000 (19:01 +0000)] 
Avoid parsing cells that fit entirely on the b-tree page when searching a b-tree index. (CVS 6601)

FossilOrigin-Name: 77a8239548722f702ead9d7c60df0d68180948fb

16 years agoChanges to auth.c to promote full coverage testing. (CVS 6600)
drh [Mon, 4 May 2009 18:01:39 +0000 (18:01 +0000)] 
Changes to auth.c to promote full coverage testing. (CVS 6600)

FossilOrigin-Name: c7615b44583c4b3afa45b57c6047478c18c234e9

16 years agoSpeed up INSERT operations that add data to UNIQUE or PRIMARY KEY indexes by rational...
danielk1977 [Mon, 4 May 2009 11:42:29 +0000 (11:42 +0000)] 
Speed up INSERT operations that add data to UNIQUE or PRIMARY KEY indexes by rationalizing duplicate seek operations. (CVS 6599)

FossilOrigin-Name: cac4f3d812f0a02ca5c1fa78d366f694403929a8

16 years agoWork toward cleaning up the authorizer interface. Work is on-going. This
drh [Mon, 4 May 2009 01:58:31 +0000 (01:58 +0000)] 
Work toward cleaning up the authorizer interface.  Work is on-going.  This
is an incremental check-in. (CVS 6598)

FossilOrigin-Name: 694662f7860179403e0cc55b45ae8afa45aa7dfb

16 years agoChanges to facility full coverage testing of util.c. (CVS 6597)
drh [Sun, 3 May 2009 20:23:53 +0000 (20:23 +0000)] 
Changes to facility full coverage testing of util.c. (CVS 6597)

FossilOrigin-Name: a612299092a48b38c5f9cf430bbcaf41777cbcb3

16 years agoMore changes to insert.c to facilitate full coverage testing. (CVS 6596)
drh [Sun, 3 May 2009 01:00:59 +0000 (01:00 +0000)] 
More changes to insert.c to facilitate full coverage testing. (CVS 6596)

FossilOrigin-Name: 46c4ec968bc22843c65744ab4a01ec7ac605567b

16 years agoSimplifications to the uniqueness constraint failure error message
drh [Sat, 2 May 2009 15:46:46 +0000 (15:46 +0000)] 
Simplifications to the uniqueness constraint failure error message
generation code. (CVS 6595)

FossilOrigin-Name: 8f3cac7682a0c992f95f7453aaf9a29b1fe35d6f

16 years agoRemove the aFKey hash table, which was not being used. Simplify the
drh [Sat, 2 May 2009 13:29:37 +0000 (13:29 +0000)] 
Remove the aFKey hash table, which was not being used.  Simplify the
FKey object.  Simplify the hash.c module since the copyKey parameter
formerly used only by aFKey is now no longer required. (CVS 6594)

FossilOrigin-Name: 80c43a355c6e482457abc2f9c3ad3a565cec55fb

16 years agoReduce the size of an integer literal in rowhash.tcl so that the test
drh [Sat, 2 May 2009 12:02:01 +0000 (12:02 +0000)] 
Reduce the size of an integer literal in rowhash.tcl so that the test
is able to run with the default TCL installation on Mac OS 10.5. (CVS 6593)

FossilOrigin-Name: 2229accef308db9feac4e1de16b57e7f680dbb1a

16 years agoWhen a cursor points at the last entry of an intkey btree after an insert, leave...
danielk1977 [Sat, 2 May 2009 10:03:09 +0000 (10:03 +0000)] 
When a cursor points at the last entry of an intkey btree after an insert, leave it there (instead of moving it to the tree root node). This speeds up statements of the form "INSERT INTO ... SELECT ..." that use auto-generated rowids. (CVS 6592)

FossilOrigin-Name: 9950c0a79c82eb7d8495b0b1a8fe117d566e2387

16 years agoDo not reset the cursor before seeking it in sqlite3BtreeInsert(). This speeds up...
danielk1977 [Sat, 2 May 2009 07:36:49 +0000 (07:36 +0000)] 
Do not reset the cursor before seeking it in sqlite3BtreeInsert(). This speeds up INSERT operations that use auto-generated rowid values. (CVS 6591)

FossilOrigin-Name: 20c4acc291def33980f584f882c76e85ee1c8238

16 years agoWhen checking indices for xfer compatibility, compare collating sequences
drh [Sat, 2 May 2009 00:28:19 +0000 (00:28 +0000)] 
When checking indices for xfer compatibility, compare collating sequences
by string, not by pointer. (CVS 6590)

FossilOrigin-Name: 7d2b80c7addc2d03d49647da9c6df9113f01349d

16 years agoRecord within the Token structure itself whether or not the token has
drh [Fri, 1 May 2009 21:13:36 +0000 (21:13 +0000)] 
Record within the Token structure itself whether or not the token has
been dequoted.  This steals one bit from the length of a token and
thus limits the size of tokens to 1GiB. (CVS 6589)

FossilOrigin-Name: 12bcb03d9b9e1a31c1a3c67cbb4263cc0af2f3d0

16 years agoFix an error message that is generated if the number of columns do not
drh [Fri, 1 May 2009 15:17:48 +0000 (15:17 +0000)] 
Fix an error message that is generated if the number of columns do not
match on an INSERT into a virtual table with hidden columns. (CVS 6588)

FossilOrigin-Name: 795b453c9a03c32d9d4cdf62823d2b9dd667cc44

16 years agoUpdate PRAGMA integrity_check so that it treats SQLITE_IOERR_NOMEM errors
drh [Fri, 1 May 2009 13:16:54 +0000 (13:16 +0000)] 
Update PRAGMA integrity_check so that it treats SQLITE_IOERR_NOMEM errors
from underlying components the same as SQLITE_NOMEM errors. (CVS 6587)

FossilOrigin-Name: 26444f2a4426d2e51464ef69ed83d3c78be2c11f

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