drh 083310dfcc Change the weighting of binary searches on tables to 1/10th the cost of a ...

search on an index.  Change the assumed reduction in search space from a
indexed range constraint from 1/3rd to 1/4th.  Do not let the estimated 
number of rows drop below 1.

FossilOrigin-Name: 4847c6cb71423248b186ab7842b97c83e2f5fefd

2011-01-28 01:57:41 +00:00

..

alter.c

Fix some problems that can occur if a trigger has the same name as another database object.

2010-09-29 07:16:46 +00:00

analyze.c

Fix a null-pointer dereference that can occur on an OOM error while running

2011-01-04 20:06:33 +00:00

attach.c

Fix several harmless compiler warnings.

2010-09-28 14:26:36 +00:00

auth.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

backup.c

On a backup from a smaller to a larger page size, do not begin committing

2011-01-16 22:37:09 +00:00

bitvec.c

Make the size of a Bitvec object 512 bytes on all platforms, instead of

2010-08-05 11:56:01 +00:00

btmutex.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

btree.c

Do not raise an SQLITE_CORRUPT error in Recoverymode

2011-01-12 17:56:26 +00:00

btree.h

Add the checkpoint_fullfsync pragma which enables F_FULLFSYNC on checkpoint

2010-11-19 18:23:35 +00:00

btreeInt.h

Reorder the fields in private structures in an effort to reduce alignment

2011-01-07 02:50:40 +00:00

build.c

Fix some problems that can occur if a trigger has the same name as another database object.

2010-09-29 07:16:46 +00:00

callback.c

Updates to the requirements on the sqlite3_create_function() family of

2010-09-16 19:49:22 +00:00

complete.c

Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging

2010-02-23 17:36:32 +00:00

ctime.c

Add the SQLITE_OMIT_AUTORESET compile-time option which if enabled causes

2011-01-17 17:42:37 +00:00

date.c

Rework the text to numeric conversion routines so that they work with either

2010-09-30 00:50:49 +00:00

delete.c

Remove the Table.dbMem variable, as it is no longer being used for its original purpose.

2010-07-23 15:41:47 +00:00

expr.c

Add the ability to disable constant factoring using sqlite3_test_control().

2010-12-06 21:06:09 +00:00

fault.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

fkey.c

Continuing work toward detecting and fixing shallow-copy misuse.

2010-09-28 00:25:58 +00:00

func.c

When registering the built-in LIKE and GLOB functions, make sure that they

2010-12-15 18:54:37 +00:00

global.c

Make the result of an IN or NOT IN expression with an empty set on the

2010-07-14 18:24:06 +00:00

hash.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

hash.h

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

hwtime.h

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

insert.c

Fix the REPLACE conflict resolution so that it falls back to ABORT when

2010-08-03 13:08:54 +00:00

journal.c

Tweaks to the new shared-memory interface design - mostly comment changes.

2010-07-13 23:41:40 +00:00

legacy.c

Continuing improvements to error reporting and the sqlite3_log() routine.

2010-02-23 20:11:56 +00:00

lempar.c

Enhancements to lemon to generate more compact action tables and to avoid

2009-11-03 19:18:31 +00:00

loadext.c

Further changes to extension loading to support compile-time options.

2010-10-11 17:57:41 +00:00

main.c

Add support for the SQLITE_DEFAULT_FOREIGN_KEYS compile-time option.

2010-12-09 19:15:17 +00:00

malloc.c

Add additional DBSTATUS options for measuring the hit and miss rates against

2010-12-20 15:51:58 +00:00

mem0.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

mem1.c

Add evidence mark comments to source code. Add additional information to the

2010-08-31 15:27:32 +00:00

mem2.c

Add evidence mark comments to source code. Add additional information to the

2010-08-31 15:27:32 +00:00

mem3.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

mem5.c

Add evidence mark comments to source code. Add additional information to the

2010-08-31 15:27:32 +00:00

memjournal.c

Fix a comment typo in memjournal.c

2010-09-16 23:18:57 +00:00

mutex_noop.c

Make walIndexTryHdr() a private function. Fix an issue with SQLITE_MUTEX_NOOP.

2010-06-26 22:16:02 +00:00

mutex_os2.c

Add some 'const' markers to static data that is really constant.

2010-06-02 05:53:53 +00:00

mutex_unix.c

Changes to debugging code in mutex_unix.c and mutex_w32.c to make an assert() statement threadsafe.

2010-08-10 07:12:26 +00:00

mutex_w32.c

Changes to debugging code in mutex_unix.c and mutex_w32.c to make an assert() statement threadsafe.

2010-08-10 07:12:26 +00:00

mutex.c

Add some 'const' markers to static data that is really constant.

2010-06-02 05:53:53 +00:00

mutex.h

Fix some compiler warnings under MSVC.

2010-09-01 02:38:21 +00:00

notify.c

Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and

2010-07-24 16:34:37 +00:00

os_common.h

Change the OSTRACEn() macro to OSTRACE(()). Also rename some internal fields

2010-05-14 11:30:18 +00:00

os_os2.c

Fix a typo in the OS/2 vfs code.

2010-07-23 22:26:20 +00:00

os_unix.c

Do not include <sys/mmap.h> if SQLITE_OMIT_WAL is defined.

2010-12-22 21:48:50 +00:00

os_win.c

Reduce the amount of memory taken up by WAL mmaped regions under Windows.

2010-09-03 04:29:30 +00:00

os.c

Identify additional requirements in the sqlite3_vfs object documentation.

2010-09-01 19:29:57 +00:00

os.h

Change the name of the xShmClose VFS method to xShmUnmap, everywhere.

2010-07-14 00:14:30 +00:00

pager.c

Add back an ALWAYS() to regain full test coverage.

2011-01-17 02:24:12 +00:00

pager.h

Add the checkpoint_fullfsync pragma which enables F_FULLFSYNC on checkpoint

2010-11-19 18:23:35 +00:00

parse.y

Enhance the LIKE/GLOB query optimization so that it works as long as there

2010-07-22 17:49:52 +00:00

pcache1.c

Comment improvements in pcache1.c. No changes to code.

2011-01-19 21:58:56 +00:00

pcache.c

Further updates to the sqlite3_pcache_methods documentation, plus the addition

2010-09-09 18:25:34 +00:00

pcache.h

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

pragma.c

Fix the max_page_count pragma so that it will not set to a value smaller

2010-11-23 18:59:27 +00:00

prepare.c

Fix the max_page_count pragma so that it will not set to a value smaller

2010-11-23 18:59:27 +00:00

printf.c

Add the sqlite3_vsnprintf() interface.

2011-01-05 12:20:09 +00:00

random.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

resolve.c

Currently, if SQLite cannot find a table or index referred to by a query, it reloads the database schema from disk to see if the table or index has been added since the schema was cached in memory. Extend this behaviour to columns (which may have been added using ALTER TABLE) and fix some obscure cases related to tables and indexes (INDEXED BY, DROP TABLE etc.).

2010-06-28 10:15:19 +00:00

rowset.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

select.c

Change the type of a variable in struct SrcList so that it fits in a 100 byte lookaside buffer on a 64-bit architecture.

2010-12-01 19:00:48 +00:00

shell.c

Add test cases for the new lookaside hit and miss status outputs. Add

2010-12-21 21:28:38 +00:00

sqlite3ext.h

Make APIs added since version 3.6.0 accessible to loadable extensions.

2010-10-11 13:12:04 +00:00

sqlite.h.in

Do not use SQLITE_MUTEX_STATIC_MEM2 since it has been reused as STATIC_OPEN.

2011-01-18 15:17:57 +00:00

sqliteInt.h

Add additional DBSTATUS options for measuring the hit and miss rates against

2010-12-20 15:51:58 +00:00

sqliteLimit.h

Disable the SQLITE_MAX_PAGE_SIZE compile time option (it is now always set to 65536). Fix some other problems in test files.

2010-08-18 15:25:17 +00:00

status.c

Add additional DBSTATUS options for measuring the hit and miss rates against

2010-12-20 15:51:58 +00:00

table.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

tclsqlite.c

Have testfixture invoke C routine Zipvfs_Init() when creating a new interpreter if SQLITE_ENABLE_ZIPVFS is defined.

2010-12-29 18:24:38 +00:00

test1.c

Add the ability to disable constant factoring using sqlite3_test_control().

2010-12-06 21:06:09 +00:00

test2.c

Increase the maximum page size from 32k to 64k.

2010-08-12 02:41:12 +00:00

test3.c

Remove the sqlite3BtreeFactor() wrapper routine. All modules now call

2010-08-30 15:02:28 +00:00

test4.c

Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and

2010-07-24 16:34:37 +00:00

test5.c

Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and

2010-07-24 16:34:37 +00:00

test6.c

Change the name of the xShmClose VFS method to xShmUnmap, everywhere.

2010-07-14 00:14:30 +00:00

test7.c

Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and

2010-07-24 16:34:37 +00:00

test8.c

Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and

2010-07-24 16:34:37 +00:00

test9.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

test_async.c

Fix makefiles so that they build sqlite3_analyzer again. Tweaks to comments

2010-07-12 16:47:48 +00:00

test_autoext.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

test_backup.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

test_btree.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

test_config.c

Add the SQLITE_OMIT_AUTORESET compile-time option which if enabled causes

2011-01-17 17:42:37 +00:00

test_demovfs.c

Fix some non-ANSI C code in test_demovfs.c. Also change the same file so that attempting to delete a file that does not exist does not return an error.

2010-08-17 05:55:35 +00:00

test_devsym.c

Change the name of the xShmClose VFS method to xShmUnmap, everywhere.

2010-07-14 00:14:30 +00:00

test_func.c

Changes to test code so that testfixture compiles when OMIT_SHARED_CACHE and OMIT_UTF16 are defined.

2010-01-07 11:27:30 +00:00

test_hexio.c

Add coverage test cases for fts3.

2009-12-12 09:51:25 +00:00

test_init.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

test_intarray.c

Fix a faulty function prototype in test_intarray.c.

2009-12-01 18:46:06 +00:00

test_intarray.h

Initial implementation and test cases for the "intarray" virtual table.

2009-11-10 17:24:37 +00:00

test_journal.c

Fix a memory leak in test_journal.c causing tests to fail.

2010-08-09 16:12:51 +00:00

test_loadext.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

test_malloc.c

Add test cases for the new lookaside hit and miss status outputs. Add

2010-12-21 21:28:38 +00:00

test_multiplex.c

Changed multiplex shim's xFilesize to return an error on mismatched chunk size.

2010-12-01 23:42:42 +00:00

test_mutex.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

test_onefile.c

Change the name of the xShmClose VFS method to xShmUnmap, everywhere.

2010-07-14 00:14:30 +00:00

test_osinst.c

Changes so that the xShmOpen VFS method is no longer required. Its job can be done by the first call to xShmMap. Rename xShmClose to xShmUnmap.

2010-07-13 18:44:03 +00:00

test_pcache.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

test_quota.c

Add tests to quota.test.

2010-09-01 18:00:09 +00:00

test_rtree.c

Fix a test module comment typo reported on the mailing list.

2010-10-31 22:47:15 +00:00

test_schema.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

test_server.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

test_stat.c

Tweaks to comments in pager.c. Fix two compiler warnings.

2010-08-14 12:42:45 +00:00

test_superlock.c

Work around restriction in Windows file locking.

2010-12-07 17:12:21 +00:00

test_tclvar.c

Make sure registers computed for the VFilter opcode are marked invalid

2009-11-23 21:23:45 +00:00

test_thread.c

Before calling Tcl_ExitThread() in a multi-threaded test, call Tcl_DoOneEvent() as many times as necessary to handle any queued events.

2010-07-06 10:55:44 +00:00

test_vfs.c

Fix a bug in test code (test_vfs.c).

2011-01-14 11:51:28 +00:00

test_wsd.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

tokenize.c

Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and

2010-07-24 16:34:37 +00:00

trigger.c

Change the way SubProgram objects are deleted so that the code is the same for deletion and measurement.

2010-07-26 12:05:17 +00:00

update.c

Provide hints to the btree layer during the creation of transient tables

2010-08-30 22:15:45 +00:00

utf.c

Modify the vdbe so that the comparison operator opcodes do not modify the data type of operands. Fix for [aa92c76cd4].

2010-03-05 16:32:12 +00:00

util.c

Fix the max_page_count pragma so that it will not set to a value smaller

2010-11-23 18:59:27 +00:00

vacuum.c

Add experimental branch disallowing VACUUM when there are one or more active SQL statements.

2010-09-24 09:32:45 +00:00

vdbe.c

Remove an over-zealous call to memAboutToChange() from OP_MustBeInt.

2010-12-03 18:57:17 +00:00

vdbe.h

Fix an issue with P4_MEM and the schema size measurement logic. Also fix

2010-07-26 13:57:59 +00:00

vdbeapi.c

Add the SQLITE_OMIT_AUTORESET compile-time option which if enabled causes

2011-01-17 17:42:37 +00:00

vdbeaux.c

Update the sqlite3_stmt_readonly() interface so that its output is

2010-12-08 18:30:19 +00:00

vdbeblob.c

Have sqlite3_blob_bytes() return 0 following a failed call to sqlite3_reopen_blob().

2010-12-06 17:11:05 +00:00

vdbeInt.h

Reorder the fields in private structures in an effort to reduce alignment

2011-01-07 02:50:40 +00:00

vdbemem.c

Add the ability to use indices when a range contraint is bounded on

2011-01-21 14:37:04 +00:00

vdbetrace.c

Initialize a variable (unnecessarily) to avoid a compiler warning.

2009-11-28 13:46:51 +00:00

vtab.c

Fix some segfaults that could occur in obscure circumstances where error messages contained characters that could be mistaken for printf format specifiers.

2010-10-21 15:12:44 +00:00

wal.c

Make wal_checkpoint a no-op if a prior checkpoint has already copied all

2010-12-16 02:06:29 +00:00

wal.h

If a database file with the WAL flag set is opened in exclusive-locking mode, use heap memory to store the wal-index instead of shared-memory.

2010-11-01 17:38:24 +00:00

walker.c

Remove the obsolete "$Id:$" RCS identifier strings from the source code.

2009-11-10 01:30:52 +00:00

where.c

Change the weighting of binary searches on tables to 1/10th the cost of a

2011-01-28 01:57:41 +00:00