]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
16 years agoWhen opening a zero-size database on unix, write one byte into the file before
drh [Wed, 30 Jul 2008 17:28:04 +0000 (17:28 +0000)] 
When opening a zero-size database on unix, write one byte into the file before
interrogating the inode number.  This works around issues with msdos
filesystems mounted on OS-X.  Ticket #3260. (CVS 5504)

FossilOrigin-Name: a480a8845fb3b49967de0790b30e6250c824b9be

16 years agoIn the unix OS implementation, replace inode hash tables with linked lists. (CVS...
drh [Wed, 30 Jul 2008 15:27:54 +0000 (15:27 +0000)] 
In the unix OS implementation, replace inode hash tables with linked lists. (CVS 5503)

FossilOrigin-Name: db4022db64dc5864e6f1d0a20672183879ad43aa

16 years agoImplicit string->numeric conversion should go to an integer value when
drh [Wed, 30 Jul 2008 13:27:10 +0000 (13:27 +0000)] 
Implicit string->numeric conversion should go to an integer value when
possible.  Ticket #3257. (CVS 5502)

FossilOrigin-Name: da0e4bff30a77f72ae283406b547401c2ebb42c5

16 years agoMake sure everything is deallocated before calling sqlite3_shutdown().
drh [Wed, 30 Jul 2008 13:15:46 +0000 (13:15 +0000)] 
Make sure everything is deallocated before calling sqlite3_shutdown().
Ticket #3259. (CVS 5501)

FossilOrigin-Name: 4a6ee88697ddc28e0c7df1954d1526de18191827

16 years agoRemove unused sqlite3VdbeMemDynamicify() function from the VDBE. (CVS 5500)
drh [Wed, 30 Jul 2008 13:14:55 +0000 (13:14 +0000)] 
Remove unused sqlite3VdbeMemDynamicify() function from the VDBE. (CVS 5500)

FossilOrigin-Name: aee63308312bcebb79e15cfdf942ee23694444b0

16 years agoBackport http://www.sqlite.org/cvstrac/chngview?cn=5489 from fts3.
shess [Tue, 29 Jul 2008 20:38:17 +0000 (20:38 +0000)] 
Backport http://www.sqlite.org/cvstrac/chngview?cn=5489 from fts3.
Re-used prepared statement from fts2 cursor. (CVS 5499)

FossilOrigin-Name: 02870ed21dae2601a656b2f30c3ca0041e9cb60f

16 years agoAdd some simple tests to make sure that the different fulltextFilter
shess [Tue, 29 Jul 2008 20:24:46 +0000 (20:24 +0000)] 
Add some simple tests to make sure that the different fulltextFilter
query paths are being exercised. (CVS 5498)

FossilOrigin-Name: ae96d960e6e31315d25c7e5c3fb8363ed1b35350

16 years agofinally make temporary and journal files hidden in release builds on OS/2 (CVS 5497)
pweilbacher [Tue, 29 Jul 2008 18:49:28 +0000 (18:49 +0000)] 
finally make temporary and journal files hidden in release builds on OS/2 (CVS 5497)

FossilOrigin-Name: c449a95c4f7abd2bfb92bed0e3a9ae874350ce79

16 years agorecursively call os2Open() with the incoming VFS pointer, in case it gets used in...
pweilbacher [Tue, 29 Jul 2008 18:38:47 +0000 (18:38 +0000)] 
recursively call os2Open() with the incoming VFS pointer, in case it gets used in the future (CVS 5496)

FossilOrigin-Name: 6eac49f046d089dac90c0bf72e8c3fc583694dcd

16 years agomove os2FullPathname() so that it can be used in os2Open() directly (CVS 5495)
pweilbacher [Tue, 29 Jul 2008 18:35:53 +0000 (18:35 +0000)] 
move os2FullPathname() so that it can be used in os2Open() directly (CVS 5495)

FossilOrigin-Name: 2455e45484eff85bf9fd78dadd1e934f2bbe210a

16 years agoEnhancements to the pagecache malloc test configuration. Changes to the
drh [Tue, 29 Jul 2008 14:29:06 +0000 (14:29 +0000)] 
Enhancements to the pagecache malloc test configuration.  Changes to the
speed test scripts to use the new test enhancements. (CVS 5494)

FossilOrigin-Name: 0ce39c21f32958ae53c00dc8bbf8cdd453f2d90e

16 years agoIncrease the version number to 3.6.1. (CVS 5493)
drh [Tue, 29 Jul 2008 14:28:04 +0000 (14:28 +0000)] 
Increase the version number to 3.6.1. (CVS 5493)

FossilOrigin-Name: ec09b551e8279e791070515e1f2413f44dc67ea5

16 years agoUse a macro to make sure that the calls to sqlite3Utf8Read() from MemTranslate()...
danielk1977 [Tue, 29 Jul 2008 11:25:14 +0000 (11:25 +0000)] 
Use a macro to make sure that the calls to sqlite3Utf8Read() from MemTranslate() are inlined. This speeds up converting from utf8 to utf16. (CVS 5492)

FossilOrigin-Name: 78a623bbb17e35bcb902d3ea1d0b963570588d2d

16 years agoAdd a missing "finish_test" to the end of misc5.test. (CVS 5491)
danielk1977 [Tue, 29 Jul 2008 10:26:45 +0000 (10:26 +0000)] 
Add a missing "finish_test" to the end of misc5.test. (CVS 5491)

FossilOrigin-Name: 89216b166924e831dd6264dd60f8da42cef7deee

16 years agoSpeed up OP_Column by eliminating some double handling. (CVS 5490)
danielk1977 [Tue, 29 Jul 2008 10:18:57 +0000 (10:18 +0000)] 
Speed up OP_Column by eliminating some double handling. (CVS 5490)

FossilOrigin-Name: 9ebee8401b68a2bcd49dc750ac394258d554b499

16 years agoRe-used prepared statement from fts3 cursor. Previously, each call to
shess [Tue, 29 Jul 2008 01:13:02 +0000 (01:13 +0000)] 
Re-used prepared statement from fts3 cursor.  Previously, each call to
fulltextFilter() finalized any existing prepared statement and
prepared a new one.  In the case where idxNum has not changed, simply
reseting the statement suffices.  This provides an order of magnitude
speedup in incoming joins against docid. (CVS 5489)

FossilOrigin-Name: a08a5f2b1256b8a93beca5a359ccfc28d403efa3

16 years agoImplement the "lookaside" memory allocation cache. Use of this cache makes
drh [Mon, 28 Jul 2008 19:34:53 +0000 (19:34 +0000)] 
Implement the "lookaside" memory allocation cache.  Use of this cache makes
the speed1.test script run about 15% faster.  Added new interfaces to
control the cache. (CVS 5488)

FossilOrigin-Name: e48f9697e9fea339e150ddc32940760027dd07d9

16 years agoAdd mem6.c to Makefile.in. Ticket #3253. (CVS 5487)
danielk1977 [Mon, 28 Jul 2008 05:26:32 +0000 (05:26 +0000)] 
Add mem6.c to Makefile.in. Ticket #3253. (CVS 5487)

FossilOrigin-Name: 51be2e4463ca32f290feb610f59553b55bc67a5c

16 years agoIn the documentation for SQLITE_CONFIG_MEMSTATUS, make it clear that the 'boolean...
danielk1977 [Mon, 28 Jul 2008 05:22:35 +0000 (05:22 +0000)] 
In the documentation for SQLITE_CONFIG_MEMSTATUS, make it clear that the 'boolean' argument passed to sqlite3_config() is actually of type int. Ticket #3252. (CVS 5486)

FossilOrigin-Name: 1ffdd46f0bf5c82c652dedf74660e913b5699b18

16 years agoRemove a branch that could not be taken from OP_IsUnique. (CVS 5485)
danielk1977 [Sat, 26 Jul 2008 18:47:27 +0000 (18:47 +0000)] 
Remove a branch that could not be taken from OP_IsUnique. (CVS 5485)

FossilOrigin-Name: 75c2a532f4dfd7eee5136fbb79f8e20dbc666fad

16 years agoFix a case where database corruption was causing an invalid reference. (CVS 5484)
danielk1977 [Sat, 26 Jul 2008 18:26:10 +0000 (18:26 +0000)] 
Fix a case where database corruption was causing an invalid reference. (CVS 5484)

FossilOrigin-Name: 7aecabacf924ad8c1f9f4e707d0c56e433e3a434

16 years agoAdd an SQLITE_OMIT_LOCALTIME around the "utc" modifier in date/time functions. (CVS...
drh [Fri, 25 Jul 2008 16:39:24 +0000 (16:39 +0000)] 
Add an SQLITE_OMIT_LOCALTIME around the "utc" modifier in date/time functions. (CVS 5483)

FossilOrigin-Name: 71486e93b274b7ca954314dd3e4146192a8b6d79

16 years agoFurther performance improvements to mem6.c. (CVS 5482)
danielk1977 [Fri, 25 Jul 2008 16:07:00 +0000 (16:07 +0000)] 
Further performance improvements to mem6.c. (CVS 5482)

FossilOrigin-Name: 4528f7b1cce2d009f1bf32bfb8eeaf3ce5531f41

16 years agoAdd the capability to track the maximum depth of the LALR(1) parser stack
drh [Fri, 25 Jul 2008 15:39:03 +0000 (15:39 +0000)] 
Add the capability to track the maximum depth of the LALR(1) parser stack
so that critical applications can check to see if they are getting close
to limits. (CVS 5481)

FossilOrigin-Name: ef0250f3dc769a4acd534f31fa06d90922d4145b

16 years agoFix the corrupt7 tests to track changes in the integrity check error message. (CVS...
drh [Fri, 25 Jul 2008 14:53:17 +0000 (14:53 +0000)] 
Fix the corrupt7 tests to track changes in the integrity check error message. (CVS 5480)

FossilOrigin-Name: 22177dac2e3cd9acafe7fcc71674a675fdd098ff

16 years agoIncrease limits on memsubsys1 tests to accomodate the larger structure
drh [Fri, 25 Jul 2008 13:39:08 +0000 (13:39 +0000)] 
Increase limits on memsubsys1 tests to accomodate the larger structure
sizes on 64-bit platforms. (CVS 5479)

FossilOrigin-Name: f7720f1bfcc6dcdd60002520e10f545a6f0eb126

16 years agoRequire the SQLITE_ENABLE_INSTVFS symbol in order to compile testfixture
drh [Fri, 25 Jul 2008 13:32:44 +0000 (13:32 +0000)] 
Require the SQLITE_ENABLE_INSTVFS symbol in order to compile testfixture
with sqlite3_instvfs enabled.  This allows fulltest to run on platforms
for which we do not have a working hwtime.h (ex: ppc, s390).  Change
requested from the SuSE team. (CVS 5478)

FossilOrigin-Name: 16c164e79c2033347a36d6f7150eb8d2e0497c78

16 years agoMake the libtclsqlite3.la shared library depend on a separate
drh [Fri, 25 Jul 2008 12:49:44 +0000 (12:49 +0000)] 
Make the libtclsqlite3.la shared library depend on a separate
libsqlite3.la shared library.  I think this flies in the face of the
whole SQLite philosophy of minimal dependencies, but on the other hand,
few people use that shared library and the capability has been requested
from the SuSE team. (CVS 5477)

FossilOrigin-Name: 83484b42bf353535567e245a92f40096b63b342f

16 years agoFix a build problem on tclsqlite in Makefile.in. (CVS 5476)
drh [Fri, 25 Jul 2008 12:39:23 +0000 (12:39 +0000)] 
Fix a build problem on tclsqlite in Makefile.in. (CVS 5476)

FossilOrigin-Name: e7a604807f9f3f92920b2bac403d2dd368dfa102

16 years agoSpeed up the xFree() method of the mem6.c allocator by storing the offset from the...
danielk1977 [Fri, 25 Jul 2008 10:40:18 +0000 (10:40 +0000)] 
Speed up the xFree() method of the mem6.c allocator by storing the offset from the pointer to the start of its chunk in a header field. (CVS 5475)

FossilOrigin-Name: 0de54891d4901dec929459d27004efe87106ffa2

16 years agoChange mem6.c to use the malloc() and free() functions directly, instead of going...
danielk1977 [Fri, 25 Jul 2008 09:24:13 +0000 (09:24 +0000)] 
Change mem6.c to use the malloc() and free() functions directly, instead of going via another sqlite3_mem_methods structure. (CVS 5474)

FossilOrigin-Name: cfa65e23df8b6f33884f533492b84dd1985db4d4

16 years agoUpdates to mem6.c allocator. (CVS 5473)
danielk1977 [Fri, 25 Jul 2008 08:48:59 +0000 (08:48 +0000)] 
Updates to mem6.c allocator. (CVS 5473)

FossilOrigin-Name: 43a4cae2acea33d1a17c0037516e9c27fb7e8e91

16 years agoReduce the size of the parser allocation. Add additional instrumentation
drh [Thu, 24 Jul 2008 23:34:07 +0000 (23:34 +0000)] 
Reduce the size of the parser allocation.  Add additional instrumentation
to mem2.  speed1*.test uses scratch malloc. (CVS 5472)

FossilOrigin-Name: 599a9dea8fc97d0e7f09e67c9954de8cc1b8748e

16 years agoUse a new algorithm for sqlite3Strlen that is slightly slower but is more
drh [Thu, 24 Jul 2008 17:06:48 +0000 (17:06 +0000)] 
Use a new algorithm for sqlite3Strlen that is slightly slower but is more
like to work on a mixture of 32- and 64-bit systems.  Ticket #3237, #3248. (CVS 5471)

FossilOrigin-Name: cb1876d8dc102be74be98dd57ac14ee67be8e8e2

16 years agoUpdate the implementation of sqlite3ResultSetOfSelect() to (hopefully) make
drh [Thu, 24 Jul 2008 15:50:41 +0000 (15:50 +0000)] 
Update the implementation of sqlite3ResultSetOfSelect() to (hopefully) make
it clearer that malloc failures cannot possibly result in a crash.
Ticket #3247. (CVS 5470)

FossilOrigin-Name: 7455310931787ddc72d677ba6c471b67af9418a8

16 years agoDo not run capi3.test or capi3c.test when testing memsys6. (CVS 5469)
danielk1977 [Thu, 24 Jul 2008 10:32:30 +0000 (10:32 +0000)] 
Do not run capi3.test or capi3c.test when testing memsys6. (CVS 5469)

FossilOrigin-Name: e0a101117ca44f0cce555b5db667286729fd2ad4

16 years agoAdd a mutex to mem6.c to make it threadsafe. (CVS 5468)
danielk1977 [Thu, 24 Jul 2008 10:11:27 +0000 (10:11 +0000)] 
Add a mutex to mem6.c to make it threadsafe. (CVS 5468)

FossilOrigin-Name: 9b97ce60c63c8b8afa43496a97917afd5fc26c71

16 years agoAdd mem6.c, a new allocator. More to come. (CVS 5467)
danielk1977 [Thu, 24 Jul 2008 08:20:40 +0000 (08:20 +0000)] 
Add mem6.c, a new allocator. More to come. (CVS 5467)

FossilOrigin-Name: 192bc192185a7b475ef9331e2a4a0dc68083ec03

16 years agoError messages from virtual tables store on the sqlite3_vtab->zErrMsg field
drh [Wed, 23 Jul 2008 21:07:25 +0000 (21:07 +0000)] 
Error messages from virtual tables store on the sqlite3_vtab->zErrMsg field
are reported back up to the application interface and memory is reclaimed. (CVS 5466)

FossilOrigin-Name: 4a9dd5e782a363e93d4705fa3671bc6cf0bb5a33

16 years agoRemove stray breakpoints from test scripts. (CVS 5465)
drh [Wed, 23 Jul 2008 20:28:13 +0000 (20:28 +0000)] 
Remove stray breakpoints from test scripts. (CVS 5465)

FossilOrigin-Name: cb5e75dfa5c7048bd0994afac19846f70bfa7a4d

16 years agoClarify in the documentation that the database connection pointer to
drh [Wed, 23 Jul 2008 18:25:56 +0000 (18:25 +0000)] 
Clarify in the documentation that the database connection pointer to
sqlite3_next_stmt() must not be NULL.  Ticket #3244. (CVS 5464)

FossilOrigin-Name: a7d64e86e84cf16c9742e6b012a0b96d9c6b2ba1

16 years agoRead the sqlite3_vtab.zErrMsg after each call to a virtual table
drh [Wed, 23 Jul 2008 18:17:32 +0000 (18:17 +0000)] 
Read the sqlite3_vtab.zErrMsg after each call to a virtual table
method and transfer any error into the database connection.
Fix the fts2.test and fts3.test scripts to that they return
silently rather than failing the test sequence if the appropriate
FTS implementation is unavailable. (CVS 5463)

FossilOrigin-Name: e2c6771d44f1b4fee16ef90e91c3498be2a7d2b1

16 years agoUpdate requirements derivation information in sqlite.h.in. (CVS 5462)
drh [Wed, 23 Jul 2008 15:40:06 +0000 (15:40 +0000)] 
Update requirements derivation information in sqlite.h.in. (CVS 5462)

FossilOrigin-Name: d6202907e70d902e967ba116012c274154f30b8d

16 years agoQuick typo fix. No changes to code. (CVS 5461)
mihailim [Wed, 23 Jul 2008 13:42:26 +0000 (13:42 +0000)] 
Quick typo fix. No changes to code. (CVS 5461)

FossilOrigin-Name: dfa8b456630089d385f89c145ae709be85424cd7

16 years agoDocumentation updates. (CVS 5460)
drh [Wed, 23 Jul 2008 00:52:55 +0000 (00:52 +0000)] 
Documentation updates. (CVS 5460)

FossilOrigin-Name: fe8e9f53f4bcedf2e8a657f33eb9a0939ef74c95

16 years agoBe a bit more susicious of invalid results from the tokenizer.
shess [Tue, 22 Jul 2008 23:54:50 +0000 (23:54 +0000)] 
Be a bit more susicious of invalid results from the tokenizer.
Backports check-in (4514) from fts3. (CVS 5459)

FossilOrigin-Name: 311aeb9c2b75c420a37198a93e353c72e9166747

16 years agoImplement optimize() function.
shess [Tue, 22 Jul 2008 23:49:44 +0000 (23:49 +0000)] 
Implement optimize() function.
Backports check-in (5417) from fts3. (CVS 5458)

FossilOrigin-Name: c16900dc7603cab30f8729b25361bc88bb37ae43

16 years agoDelete all fts2 index data the table becomes empty.
shess [Tue, 22 Jul 2008 23:41:26 +0000 (23:41 +0000)] 
Delete all fts2 index data the table becomes empty.
Backports check-in (5413) from fts3. (CVS 5457)

FossilOrigin-Name: 4c98179be258319f441ae4e123cf59af77e96409

16 years agofts2 functions for testing scripts.
shess [Tue, 22 Jul 2008 23:32:27 +0000 (23:32 +0000)] 
fts2 functions for testing scripts.
Backports (5340) from fts3. (CVS 5456)

FossilOrigin-Name: 4e47394be9dfbf0f9309e55eb6c6a3a517ea2006

16 years agoChange prefix search from O(N*M) to O(NlogM).
shess [Tue, 22 Jul 2008 23:08:40 +0000 (23:08 +0000)] 
Change prefix search from O(N*M) to O(NlogM).
Backports (4599) from fts3. (CVS 5455)

FossilOrigin-Name: 3f614453d2d7c753a5963b027fe8618b50b4f6b9

16 years agoChanges fts2 to use only sqlite3_malloc() and not system malloc.
shess [Tue, 22 Jul 2008 22:57:54 +0000 (22:57 +0000)] 
Changes fts2 to use only sqlite3_malloc() and not system malloc.
Backports (4554) and (4555) from fts3. (CVS 5454)

FossilOrigin-Name: ecf2dec66cb979cb7d8db3b7ce5c64cab57fe2bb

16 years agofts2.c buildTerms() passes -1 for nInput.
shess [Tue, 22 Jul 2008 22:20:50 +0000 (22:20 +0000)] 
fts2.c buildTerms() passes -1 for nInput.
Backports (4511) from fts3. (CVS 5453)

FossilOrigin-Name: d562515e1cdd05212674516033c64b5f5668b799

16 years agoCleanup the hash functions in FTS2.
shess [Tue, 22 Jul 2008 22:15:47 +0000 (22:15 +0000)] 
Cleanup the hash functions in FTS2.
Backports (4440) from fts3. (CVS 5452)

FossilOrigin-Name: e31d2f875c13ee41742c9aaee6291662cdbbf863

16 years agoDocumentation updates. No changes to code. (CVS 5451)
drh [Tue, 22 Jul 2008 18:45:08 +0000 (18:45 +0000)] 
Documentation updates.  No changes to code. (CVS 5451)

FossilOrigin-Name: e58b49779bfd4a9e88e8c6b0a929c97167b718b3

16 years agowinGetLastError support added. Consolidated getLastErrorMsg() support. Removed...
shane [Tue, 22 Jul 2008 05:32:03 +0000 (05:32 +0000)] 
winGetLastError support added.  Consolidated getLastErrorMsg() support.  Removed some more WINCE dead code similar to instance in ticket #3232.   Added error return on SystemTimeToFileTime() failure. (CVS 5450)

FossilOrigin-Name: c0a5cf38eea80640e42c612ce6f4850c98f70638

16 years agoChanged a few loop counters to unsigned ints to remove compiler warnings. (CVS 5449)
shane [Tue, 22 Jul 2008 05:18:00 +0000 (05:18 +0000)] 
Changed a few loop counters to unsigned ints to remove compiler warnings. (CVS 5449)

FossilOrigin-Name: 16f51f9b39c46659b4be4afd7f0d8ec325469e7b

16 years agoAdded comment on floating point precision compile option for MSVC. (CVS 5448)
shane [Tue, 22 Jul 2008 05:15:52 +0000 (05:15 +0000)] 
Added comment on floating point precision compile option for MSVC. (CVS 5448)

FossilOrigin-Name: e20f2b8c6a13aa826703441cf340d0ee03bf9f64

16 years agoAdd assertion check for NaN support at startup. (CVS 5447)
shane [Tue, 22 Jul 2008 05:13:30 +0000 (05:13 +0000)] 
Add assertion check for NaN support at startup. (CVS 5447)

FossilOrigin-Name: 8474cde34b3fcb99cd5908fddb8528d0db331cdf

16 years ago"configure" support updated. Removed unused features. Added parsing of CFLAGS and...
shane [Tue, 22 Jul 2008 05:05:01 +0000 (05:05 +0000)] 
"configure" support updated.  Removed unused features.  Added parsing of CFLAGS and CPPFLAGS to extract OMIT options to pass to lemon and mkkeywordhash. (CVS 5446)

FossilOrigin-Name: c67aa5057deda6419e1f205118bf09957d599c15

16 years agoflattenSubquery() needed if either SQLITE_OMIT_SUBQUERY or SQLITE_OMIT_VIEW not defin...
shane [Tue, 22 Jul 2008 05:00:55 +0000 (05:00 +0000)] 
flattenSubquery() needed if either SQLITE_OMIT_SUBQUERY or SQLITE_OMIT_VIEW not defined. (CVS 5445)

FossilOrigin-Name: 1ffe7a995733fe91534a3ed81d2640fd7e6ebaa6

16 years agoReduce the number of "#ifndef SQLITE_OMIT_AUTOVACUUM" conditions in btree.c by using...
danielk1977 [Sat, 19 Jul 2008 14:25:15 +0000 (14:25 +0000)] 
Reduce the number of "#ifndef SQLITE_OMIT_AUTOVACUUM" conditions in btree.c by using the ISAUTOVACUUM macro instead. (CVS 5444)

FossilOrigin-Name: a560c61849cb669ab03ba4a63b23369db234f329

16 years agoTo ensure SQLITE_THREADSAFE is always defined, have test_mutex.c include sqliteInt...
danielk1977 [Sat, 19 Jul 2008 13:43:23 +0000 (13:43 +0000)] 
To ensure SQLITE_THREADSAFE is always defined, have test_mutex.c include sqliteInt.h. (CVS 5443)

FossilOrigin-Name: d8be91e2d2737dcb0e82e6c8a6a3f4827bc98d63

16 years agoImprove the performance of balance_nonroot() on auto-vacuum databases by reducing...
danielk1977 [Sat, 19 Jul 2008 11:49:07 +0000 (11:49 +0000)] 
Improve the performance of balance_nonroot() on auto-vacuum databases by reducing the number of calls to ptrmapPut(). (CVS 5442)

FossilOrigin-Name: 9992b1aecdbbc7a260f00cb6ef78b500aeab22df

16 years agoRemove dead code from os_win.c. Ticket #3232. (CVS 5441)
drh [Fri, 18 Jul 2008 23:47:43 +0000 (23:47 +0000)] 
Remove dead code from os_win.c.  Ticket  #3232. (CVS 5441)

FossilOrigin-Name: 5c5c1f72797e4ceb229b8e3a7c65e5f173bb9e1a

16 years agoUse the actual size of memory allocations to update the memory status
drh [Fri, 18 Jul 2008 18:56:16 +0000 (18:56 +0000)] 
Use the actual size of memory allocations to update the memory status
counters.  Fix the roundup() function of mem3 to be much closer to the
actual allocation size.  Ticket #3226. (CVS 5440)

FossilOrigin-Name: 5c22132eb171058f30ec5b7562b8164611236748

16 years agoFix SQLITE_OMIT_AUTOVACUUM so that it works again. Ticket #3228. (CVS 5439)
drh [Fri, 18 Jul 2008 17:16:26 +0000 (17:16 +0000)] 
Fix SQLITE_OMIT_AUTOVACUUM so that it works again.  Ticket #3228. (CVS 5439)

FossilOrigin-Name: 3b2dd417f9dab3cae3ab3693629a65a2c90f00e9

16 years agoMake sure expression spans are set correctly for "x.*" expressions in
drh [Fri, 18 Jul 2008 17:03:52 +0000 (17:03 +0000)] 
Make sure expression spans are set correctly for "x.*" expressions in
the result set of a SELECT.  Ticket #3229. (CVS 5438)

FossilOrigin-Name: 17a9984e7668be388c4042c070718a02b284a336

16 years agoPerformance improvement: reduce the number of calls to ptrmapPageno() made by ptrmapP...
danielk1977 [Fri, 18 Jul 2008 09:34:57 +0000 (09:34 +0000)] 
Performance improvement: reduce the number of calls to ptrmapPageno() made by ptrmapPut() and ptrmapGet(). (CVS 5437)

FossilOrigin-Name: d807fb271340901bbf3e06de23d91132422d1408

16 years agoSpeed up sqlite3_finalize() by removing redundant code. (CVS 5436)
danielk1977 [Fri, 18 Jul 2008 08:10:47 +0000 (08:10 +0000)] 
Speed up sqlite3_finalize() by removing redundant code. (CVS 5436)

FossilOrigin-Name: c94318b982e9bb5b4c743cf8d5659f9eec697366

16 years agoInit zFullCp to prevent crashes in case DosQueryPathInfo() fails. (CVS 5435)
pweilbacher [Fri, 18 Jul 2008 05:36:28 +0000 (05:36 +0000)] 
Init zFullCp to prevent crashes in case DosQueryPathInfo() fails. (CVS 5435)

FossilOrigin-Name: 70685b2ae8bbb8ab4316a762e1c1cc59b8032e0b

16 years agoThe zeroPage() routine in btree.c need not actually zero the whole page,
drh [Fri, 18 Jul 2008 03:32:51 +0000 (03:32 +0000)] 
The zeroPage() routine in btree.c need not actually zero the whole page,
just the header. (CVS 5434)

FossilOrigin-Name: c69633ec6977becfbd0a72854473b7f4515fb931

16 years agoOmit the check for cell-pointer consistency in sqlite3BtreeInitPage()
drh [Fri, 18 Jul 2008 02:44:17 +0000 (02:44 +0000)] 
Omit the check for cell-pointer consistency in sqlite3BtreeInitPage()
for a 2.5% performance gain. (CVS 5433)

FossilOrigin-Name: b88087e69dffb743c5b552703e14a030349cf65b

16 years agoOptimization to sqltie3BtreeParseCellPtr. 0.3% performance increase. (CVS 5432)
drh [Fri, 18 Jul 2008 00:57:33 +0000 (00:57 +0000)] 
Optimization to sqltie3BtreeParseCellPtr.  0.3% performance increase. (CVS 5432)

FossilOrigin-Name: 77e099ad7de84fe07dfeb4c045c769653dd13b93

16 years agoSimplify the b-tree logic by taking advantage of the fact that all b-trees
drh [Thu, 17 Jul 2008 18:39:57 +0000 (18:39 +0000)] 
Simplify the b-tree logic by taking advantage of the fact that all b-trees
are either intkey+leafdata or zerodata. (CVS 5431)

FossilOrigin-Name: 29d3bfd7c9a68078385354394052612bf812859b

16 years agoFix the test harness so that it does not try to link against
drh [Thu, 17 Jul 2008 17:34:19 +0000 (17:34 +0000)] 
Fix the test harness so that it does not try to link against
sqlite3_mutex_alloc() if compiled with -DSQLITE_THREADSAFE=0. (CVS 5430)

FossilOrigin-Name: 26a203d894edd0091ac60862956e42d22167011e

16 years agoGet rid of the debug output, and make pre-C99 compilers happy with sqlite3_os_init...
pweilbacher [Wed, 16 Jul 2008 19:30:37 +0000 (19:30 +0000)] 
Get rid of the debug output, and make pre-C99 compilers happy with sqlite3_os_init() on OS/2. (CVS 5429)

FossilOrigin-Name: 08fe49f62f8a91c36ad4bb9a1d8c89806c37f600

16 years agoMake sure the auxiliary database connection is closed after every test. (CVS 5428)
drh [Wed, 16 Jul 2008 18:35:45 +0000 (18:35 +0000)] 
Make sure the auxiliary database connection is closed after every test. (CVS 5428)

FossilOrigin-Name: e60bb6a179c6e674db2b9362e2ccdefaa3bc17f4

16 years agoMore improvements to the 64-bit integer conversion testing in func.test. (CVS 5427)
drh [Wed, 16 Jul 2008 18:20:09 +0000 (18:20 +0000)] 
More improvements to the 64-bit integer conversion testing in func.test. (CVS 5427)

FossilOrigin-Name: 632bb3c73443606bd2c7a5eadf0f4b8971a2b41e

16 years agoEliminate some unnecessary IO during a commit in full auto-vacuum mode. (CVS 5426)
danielk1977 [Wed, 16 Jul 2008 18:17:55 +0000 (18:17 +0000)] 
Eliminate some unnecessary IO during a commit in full auto-vacuum mode. (CVS 5426)

FossilOrigin-Name: 1d01c02ab04f9cc0eb6a2a46a24d3ea63a617d5b

16 years agoFix a test in func.test so that it works on machines that lack long double. (CVS...
drh [Wed, 16 Jul 2008 18:04:36 +0000 (18:04 +0000)] 
Fix a test in func.test so that it works on machines that lack long double. (CVS 5425)

FossilOrigin-Name: 8686959d4289dc0bf9e1c353b948f26cca5a9a65

16 years agoVersion 3.6.0 (CVS 5423)
drh [Wed, 16 Jul 2008 14:44:40 +0000 (14:44 +0000)] 
Version 3.6.0 (CVS 5423)

FossilOrigin-Name: 1841aee6045b00cf4ab7b8485f5ab537d5fcd272

16 years agoAllow the r-tree extension to be compiled as part of the amalgamation. (CVS 5424)
drh [Wed, 16 Jul 2008 14:43:34 +0000 (14:43 +0000)] 
Allow the r-tree extension to be compiled as part of the amalgamation. (CVS 5424)

FossilOrigin-Name: 5c26f63e476be3e18b2acdec5dd459da3bfceefa

16 years agoFix a bug in the error reporting of sqlite3_table_column_metadata(). (CVS 5422)
drh [Wed, 16 Jul 2008 14:02:32 +0000 (14:02 +0000)] 
Fix a bug in the error reporting of sqlite3_table_column_metadata(). (CVS 5422)

FossilOrigin-Name: 7eba18c3a5c91be2ca2b6cf9e4e04a2791e1f7b2

16 years agoUpdate the "experimental" markings on C/C++ interfaces. (CVS 5421)
drh [Wed, 16 Jul 2008 13:29:51 +0000 (13:29 +0000)] 
Update the "experimental" markings on C/C++ interfaces. (CVS 5421)

FossilOrigin-Name: 96e95aa5e6c237bb9330900c2e1ac446158eca46

16 years agoFix a bug in the HOMEGROWN_RECURSIVE_MUTEX implementation for unix.
drh [Wed, 16 Jul 2008 12:33:23 +0000 (12:33 +0000)] 
Fix a bug in the HOMEGROWN_RECURSIVE_MUTEX implementation for unix.
Ticket #3224. (CVS 5420)

FossilOrigin-Name: 9af2514c83782b4745bf48a4f82ff83111fa5535

16 years agoActivate testing of mem3 and mem5. Fix problems found. Tickets #3223
drh [Wed, 16 Jul 2008 12:25:32 +0000 (12:25 +0000)] 
Activate testing of mem3 and mem5.  Fix problems found.  Tickets #3223
and #3225.  Other test configuration changes. (CVS 5419)

FossilOrigin-Name: a3a7820540f6f2285e6c83cac84383fc7d60d267

16 years agoWork around bugs in older versions of the OS/2 conversion library by trying to minimi...
pweilbacher [Tue, 15 Jul 2008 22:59:04 +0000 (22:59 +0000)] 
Work around bugs in older versions of the OS/2 conversion library by trying to minimize calls to UniCreateUconvObject() etc. Use global uconv objects instead. (CVS 5418)

FossilOrigin-Name: 80e42183066b53129778ae8cbb16e495f7a82990

16 years agoImplement optimize() function. This merges all segments in the fts
shess [Tue, 15 Jul 2008 21:32:07 +0000 (21:32 +0000)] 
Implement optimize() function.  This merges all segments in the fts
index into a single segment, including dropping delete cookies. (CVS 5417)

FossilOrigin-Name: b22e187bc2b38bd219dd0feba19b97279bd83089

16 years agoUpdate column naming rules. Ticket #3221. Rules for column naming
drh [Tue, 15 Jul 2008 20:56:17 +0000 (20:56 +0000)] 
Update column naming rules.  Ticket #3221.  Rules for column naming
are still subject to change (except for the AS rule which we promise to
keep the same) but are more consistent now.  And the rules are tested
using a new test script. (CVS 5416)

FossilOrigin-Name: 61f6e19755b85bcb065f85fc425c2172badea308

16 years agoContinuing work on improved test coverage. (CVS 5415)
drh [Tue, 15 Jul 2008 14:47:18 +0000 (14:47 +0000)] 
Continuing work on improved test coverage. (CVS 5415)

FossilOrigin-Name: c942a38e9aa80770e7e2819e51b43fa7aa854d71

16 years agoIncreased test coverage. (CVS 5414)
drh [Tue, 15 Jul 2008 00:27:34 +0000 (00:27 +0000)] 
Increased test coverage. (CVS 5414)

FossilOrigin-Name: 7cf91e08c08ce515c24c738c7d079f5b81eebee6

16 years agoDelete all fts3 index data the table becomes empty. Previously,
shess [Mon, 14 Jul 2008 20:43:15 +0000 (20:43 +0000)] 
Delete all fts3 index data the table becomes empty.  Previously,
deleting all rows from an fts3 table would leave a bunch of index data
describing the terms of the original data, plus deletions of those
terms, perhaps with some amount of it merged together so the deletions
knocked out the originals.  Even when all rows were deleted that
original data would hang out, though eventually it would mostly be
overwritten if new data contained the same set of terms. (CVS 5413)

FossilOrigin-Name: 8b872e426091d9ef108e52dbec0d968ed7452907

16 years agoAdd a new test script to exercise the deadlock avoidance code in the
drh [Mon, 14 Jul 2008 19:39:16 +0000 (19:39 +0000)] 
Add a new test script to exercise the deadlock avoidance code in the
btree mutex logic. (CVS 5412)

FossilOrigin-Name: 7d5e1c4375599a913d23e5954fa63c10ac9d7688

16 years agoFix a typo in the documentation. Ticket #3219. (CVS 5411)
drh [Mon, 14 Jul 2008 18:38:17 +0000 (18:38 +0000)] 
Fix a typo in the documentation.  Ticket #3219. (CVS 5411)

FossilOrigin-Name: 3dc72a46171020c62e6028d113b0e0f5ab05d159

16 years agoHave the rtree extension publish two virtual table types: "rtree" and "rtree_i32...
danielk1977 [Mon, 14 Jul 2008 15:37:00 +0000 (15:37 +0000)] 
Have the rtree extension publish two virtual table types: "rtree" and "rtree_i32". rtree_i32 stores coordinate data as 32-bit signed integers. rtree uses 32-bit real (floating point) values. (CVS 5410)

FossilOrigin-Name: c060a9a6beca455bdceee9ce6ca71a7262f98a5f

16 years agoRemove the malloc2.test script since it was designed for use in versions
drh [Mon, 14 Jul 2008 15:11:20 +0000 (15:11 +0000)] 
Remove the malloc2.test script since it was designed for use in versions
of SQLite that predate SQLite's ability to recover from out-of-memory
errors automatically.  Removing this script causes no reduction in
test coverage and removes potential problems reported by ticket #3213. (CVS 5409)

FossilOrigin-Name: 5bfc962533995530a0ef0875556f9f46e8dbf68b

16 years agoWrite sqlite3_initialize() calls in sqlite3_malloc() within
drh [Mon, 14 Jul 2008 12:52:53 +0000 (12:52 +0000)] 
Write sqlite3_initialize() calls in sqlite3_malloc() within
SQLITE_OMIT_AUTOINIT.  Ticket #3217. (CVS 5408)

FossilOrigin-Name: 4961b0bbe8b9cf5fb27de7f2514e8ab399a00134

16 years agoFix a bug introduced by check-in (5406). Ticket #3216. (CVS 5407)
drh [Mon, 14 Jul 2008 12:38:20 +0000 (12:38 +0000)] 
Fix a bug introduced by check-in (5406).  Ticket #3216. (CVS 5407)

FossilOrigin-Name: 518a24aa3e042782fbf2e805cf080b61e58a8150

16 years agoWork around a bug in Borland C. Ticket #3216. (CVS 5406)
drh [Mon, 14 Jul 2008 12:30:54 +0000 (12:30 +0000)] 
Work around a bug in Borland C.  Ticket #3216. (CVS 5406)

FossilOrigin-Name: 2c24e50da6f6c19dee105823125157db73bdd515

16 years agoFix additional typos in comments within lemon. Ticket #3215. (CVS 5405)
drh [Mon, 14 Jul 2008 12:27:51 +0000 (12:27 +0000)] 
Fix additional typos in comments within lemon.  Ticket #3215. (CVS 5405)

FossilOrigin-Name: 372147699585ca4bd11100983de924f63c5cfce5