drh d24474475e Import the "PRAGMA vdbe_eqp" enhancement and the enhanced EXPLAIN formatting ...

the shell from trunk.  Fix a bug in skip-scan and add a test case to prevent
a regression.

FossilOrigin-Name: f668616a29686f3ce532731c534b168e536adbb5

2013-11-13 19:01:41 +00:00

..

alter.c

When possible, use the multi-column samples in sqlite_stat4 to estimate the number of index rows scanned by a query plan.

2013-08-06 20:01:43 +00:00

analyze.c

Add test cases for skip-scan. Enhance "do_test" so that if the expected result

2013-11-13 15:32:15 +00:00

attach.c

The sqlite3FixInit() routine cannot fail. So change the return type from "int"

2013-10-03 15:39:44 +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

Simplify the btreeGetPage() routine so that it uses a single flag parameter

2013-08-21 23:42:32 +00:00

bitvec.c

Many spelling fixes in comments. No changes to code.

2013-03-21 21:20:32 +00:00

btmutex.c

Fix a performance regression: Keep two btree masks in each prepared

2011-04-06 22:05:53 +00:00

btree.c

Allocate extra stack space for UnpackedRecord objects, reducing the need

2013-11-06 14:36:08 +00:00

btree.h

Add the cache_spill pragma.

2013-08-16 20:42:20 +00:00

btreeInt.h

Bring some file format comments in btreeInt.h up to date.

2013-10-01 20:29:30 +00:00

build.c

Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify

2013-11-13 17:58:23 +00:00

callback.c

Combine the FuncDef.iPrefEnc and FuncDef.flags fields into a single

2013-09-06 13:10:12 +00:00

complete.c

Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging

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

ctime.c

If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4.

2013-08-12 20:14:04 +00:00

date.c

Add requirements marks. No code changes.

2013-10-11 20:14:37 +00:00

delete.c

Performance improvement: Avoid unnecessary seeks on REPLACE INTO for a

2013-11-08 16:54:56 +00:00

expr.c

Reference count the KeyInfo object. Cache a copy of an appropriate KeyInfo

2013-11-06 19:59:23 +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

Fix harmless compiler warnings.

2013-11-08 17:13:23 +00:00

func.c

Updates to requirements marks. No changes to code.

2013-11-09 19:47:15 +00:00

global.c

Refactoring the mmap interface. The controlling pragma is now "mmap_size"

2013-04-15 17:03:42 +00:00

hash.c

More warning fixes.

2012-10-18 10:35:19 +00:00

hash.h

Many spelling fixes in comments. No changes to code.

2013-03-21 21:20:32 +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

Remove unreachable code, replacing it in most cases with assert() or NEVER()

2013-11-11 16:55:52 +00:00

journal.c

On atomic-write capable systems, if copying the contents of an in-memory journal to disk fails, close the (on disk) journal file before returning the error to the caller. This causes the subsequent rollback operation to use the in-memory journal. Fix for [df678d738adb].

2012-12-18 11:59:39 +00:00

legacy.c

Increase the default SQLITE_MAX_SCHEMA_RETRY to 50. Make sure that macro

2013-04-06 18:06:51 +00:00

lempar.c

Attempt to suppress warnings generated by Coverity.

2012-10-09 18:51:44 +00:00

loadext.c

Add the sqlite3_cancel_auto_extension(X) interface which will undo a prior

2013-07-15 17:02:28 +00:00

main.c

Make sure cached KeyInfo objects are only valid for a single database

2013-11-07 14:09:39 +00:00

malloc.c

Change the PRAGMA parser to use a binary search for the pragma name.

2013-09-13 16:36:46 +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

Adjust the SQLITE_MALLOCSIZE defines, primarily to make sure _msize gets used with MSVC when appropriate.

2013-11-12 21:37:04 +00:00

mem2.c

Fix harmless MSVC compiler warning with MEMDEBUG defined.

2013-08-31 05:13:22 +00:00

mem3.c

Add a target to main.mk that will fail if the amalgamation contains any exported symbols that do not begin with "sqlite3_". Run this target from within releasetest.tcl. Add "static" to a couple of private functions in mem3.c.

2011-07-07 08:19:16 +00:00

mem5.c

Fix a few more minor comment typos. No changes to code.

2013-08-14 00:20:23 +00:00

memjournal.c

Make the MIN() and MAX() macros available in sqliteInt.h. Add TUNING

2013-06-13 15:16:53 +00:00

mutex_noop.c

Fix typos and comments and make minor changes to a few function names,

2012-01-04 12:57:45 +00:00

mutex_unix.c

Fix typos and comments and make minor changes to a few function names,

2012-01-04 12:57:45 +00:00

mutex_w32.c

Make names of private functions in the Win32 VFS consistent. Fix comment typo in Win32 mutex implementation.

2013-08-28 02:37:29 +00:00

mutex.c

Fix typos and comments and make minor changes to a few function names,

2012-01-04 12:57:45 +00:00

mutex.h

Remove support for OS/2 from the source tree.

2012-06-21 13:00:37 +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

The server1.test script should only run if mutexes are functional.

2011-08-31 19:40:58 +00:00

os_unix.c

Fix a problem in os_unix.c causing compilation failure if SQLITE_DEBUG and SQLITE_MAX_MMAP_SIZE=0 are both defined.

2013-10-31 18:49:58 +00:00

os_win.c

Fix several harmless compiler warnings.

2013-11-11 02:46:32 +00:00

os.c

Refactoring the mmap interface. The controlling pragma is now "mmap_size"

2013-04-15 17:03:42 +00:00

os.h

Remove the unused SQLITE_CURDIR macro.

2013-04-16 14:58:52 +00:00

pager.c

Simplify the btreeGetPage() routine so that it uses a single flag parameter

2013-08-21 23:42:32 +00:00

pager.h

Simplify the btreeGetPage() routine so that it uses a single flag parameter

2013-08-21 23:42:32 +00:00

parse.y

Simplification of the syntax: Merely append "WITHOUT rowid" to the end of

2013-10-21 02:14:45 +00:00

pcache1.c

Add some extra assert() statements to silence a few clang warnings.

2013-08-19 18:17:03 +00:00

pcache.c

Make sure large negative arguments to PRAGMA cache_size do not cause

2012-01-02 15:45:12 +00:00

pcache.h

Use mmap() to read from the database file in rollback mode. This branch is unix only for now.

2013-03-14 18:34:37 +00:00

pragma.c

Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify

2013-11-13 17:58:23 +00:00

prepare.c

Store the root page of the PRIMARY KEY index for a WITHOUT ROWID table in

2013-11-02 14:37:18 +00:00

printf.c

Simplification to the StrAccum object and the sqlite3StrAccumAppend()

2013-08-21 21:12:10 +00:00

random.c

Refactor the sqlite3_randomness() implementation for improved performance.

2013-08-21 22:09:25 +00:00

resolve.c

Fix harmless compiler warnings.

2013-11-08 17:13:23 +00:00

rowset.c

Fix all known instances of 'repeated the' style typos in comments. No changes to code.

2012-08-25 10:01:29 +00:00

select.c

A better (simpler) fix to the count(*) problem addressed in the previous

2013-11-12 15:33:40 +00:00

shell.c

Import the "PRAGMA vdbe_eqp" enhancement and the enhanced EXPLAIN formatting

2013-11-13 19:01:41 +00:00

sqlite3.rc

Readability improvements to the Win32 RC file.

2013-09-16 20:46:34 +00:00

sqlite3ext.h

Modify several extensions to use the new exported function naming. Fix some shared library compilation issues.

2013-07-04 23:53:56 +00:00

sqlite.h.in

Add a comment to the sqlite3_index_info structure indicating that the new

2013-11-11 23:26:34 +00:00

sqliteInt.h

Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify

2013-11-13 17:58:23 +00:00

sqliteLimit.h

Refactoring the mmap interface. The controlling pragma is now "mmap_size"

2013-04-15 17:03:42 +00:00

status.c

Add the "defer_foreign_keys" pragma and the SQLITE_DBSTATUS_DEFERRED_FKS

2013-07-11 15:03:32 +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

Remove unnecessary memset() calls from test code.

2013-10-03 11:27:56 +00:00

test1.c

Move the tointeger() and toreal() functions out of core and make them into

2013-10-14 21:14:42 +00:00

test2.c

More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes.

2013-04-29 03:09:10 +00:00

test3.c

More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes.

2013-04-29 03:09:10 +00:00

test4.c

More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes.

2013-04-29 03:09:10 +00:00

test5.c

Fix compiler warnings in the TCL test harness.

2012-01-30 18:00:31 +00:00

test6.c

Fix harmless compiler warnings.

2013-10-31 06:11:10 +00:00

test7.c

Changes to test code to make sure no server threads are left running after server1.test finishes.

2013-10-15 15:35:27 +00:00

test8.c

Fix an issue in the test8.c test module that arises because of the change

2013-10-05 20:18:25 +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

More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes.

2013-04-29 03:09:10 +00:00

test_autoext.c

Adjust #ifdefs in test_autoext.c so that it compiles with

2013-08-06 18:35:31 +00:00

test_backup.c

More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes.

2013-04-29 03:09:10 +00:00

test_btree.c

Have user interfaces report out the filename of in-memory databases as an

2012-05-27 01:19:04 +00:00

test_config.c

Enable some more tests on Windows.

2013-10-31 06:13:57 +00:00

test_demovfs.c

Adjust #ifdefs in test_autoext.c so that it compiles with

2013-08-06 18:35:31 +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_fs.c

Adjust #ifdefs in test_autoext.c so that it compiles with

2013-08-06 18:35:31 +00:00

test_func.c

Fixes for test code that was not working with utf16 databases. Run the analyze*.test scripts as part of the 'utf16' permutation test.

2013-08-16 14:48:23 +00:00

test_hexio.c

Fix harmless compiler warnings on x64 MSVC, mostly in test code, but also in

2012-04-19 18:04:28 +00:00

test_init.c

Remove unnecessary memset() calls from test code.

2013-10-03 11:27:56 +00:00

test_intarray.c

More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes.

2013-04-29 03:09:10 +00:00

test_intarray.h

Add a guard #ifndef to test_intarray.h to prevent harm if it is #included

2013-08-07 14:18:45 +00:00

test_journal.c

Fix harmless compiler warnings on x64 MSVC, mostly in test code, but also in

2012-04-19 18:04:28 +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

Fix several harmless compiler warnings. Fix a couple compiler issues with the shell.

2013-08-28 01:54:12 +00:00

test_multiplex.c

Merge the Cygwin directory separator fix. Also fix a C++-ism in the

2013-11-08 17:03:50 +00:00

test_multiplex.h

Add a guard #ifndef to test_intarray.h to prevent harm if it is #included

2013-08-07 14:18:45 +00:00

test_mutex.c

More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes.

2013-04-29 03:09:10 +00:00

test_onefile.c

Fix harmless compiler warnings on x64 MSVC, mostly in test code, but also in

2012-04-19 18:04:28 +00:00

test_osinst.c

Fix harmless compiler warnings on x64 MSVC, mostly in test code, but also in

2012-04-19 18:04:28 +00:00

test_pcache.c

Merge the PCACHE2 changes into trunk.

2011-11-16 18:08:07 +00:00

test_quota.c

More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes.

2013-04-29 03:09:10 +00:00

test_quota.h

Add sqlite3_quota_ferror() and sqlite3_quota_file_available() interfaces to

2012-06-05 13:56:15 +00:00

test_rtree.c

Add a missing '#include "tcl.h"' to test_rtree.c.

2013-08-05 12:31:41 +00:00

test_schema.c

Modify several extensions to use the new exported function naming. Fix some shared library compilation issues.

2013-07-04 23:53:56 +00:00

test_server.c

Changes to test code to make sure no server threads are left running after server1.test finishes.

2013-10-15 15:35:27 +00:00

test_sqllog.c

Enhanced documentation for the SQLITE_CONFIG_SQLLOG mechanism and the

2013-04-22 13:51:09 +00:00

test_stat.c

A pair of sqlite3_analyzer bug fixes: (1) quote strings in the SQL at the end

2013-11-02 11:34:58 +00:00

test_superlock.c

Work around restriction in Windows file locking.

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

test_syscall.c

In test file test_syscall.c, include sqliteInt.h before any tcl or system include files. This ensures that the magical defines in sqliteInt.h really do enable large file support (and set things up so that sizeof(off_t)==8).

2013-05-17 16:41:15 +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

More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes.

2013-04-29 03:09:10 +00:00

test_vfs.c

Comment and preprocessor macro cleanup.

2013-07-29 15:54:06 +00:00

test_vfstrace.c

Add the SQLITE_FCNTL_TEMPFILENAME file control that asks the underlying VFS

2012-12-06 19:01:42 +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

Store the root page of the PRIMARY KEY index for a WITHOUT ROWID table in

2013-11-02 14:37:18 +00:00

trigger.c

Add the SQLITE_ENABLE_EXPLAIN_COMMENTS compile-time option to enable extra

2013-10-30 02:28:23 +00:00

update.c

Remove unreachable code, replacing it in most cases with assert() or NEVER()

2013-11-11 16:55:52 +00:00

utf.c

Remove the unused sqlite3Utf8to16() utility function.

2013-08-07 15:57:24 +00:00

util.c

Begin an experimental refactoring to estimate the average number of bytes

2013-10-05 18:16:02 +00:00

vacuum.c

Get VACUUM and the xfer optimization working with WITHOUT ROWID.

2013-10-23 16:03:07 +00:00

vdbe.c

Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify

2013-11-13 17:58:23 +00:00

vdbe.h

Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify

2013-11-13 17:58:23 +00:00

vdbeapi.c

The date and time functions use the exact same notion of "now" for every

2013-09-16 12:57:19 +00:00

vdbeaux.c

Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify

2013-11-13 17:58:23 +00:00

vdbeblob.c

Many new test cases added, that mostly work. Currently 18 errors in

2013-11-02 22:09:48 +00:00

vdbeInt.h

Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify

2013-11-13 17:58:23 +00:00

vdbemem.c

Reference count the KeyInfo object. Cache a copy of an appropriate KeyInfo

2013-11-06 19:59:23 +00:00

vdbesort.c

Size KeyInfo objects so that IdxInserts always compare the correct number of

2013-11-01 22:02:56 +00:00

vdbetrace.c

Refactor names of fields in the sqlite3 object: "activeVdbeCnt" becomes

2013-06-27 23:54:02 +00:00

vtab.c

Combine the FuncDef.iPrefEnc and FuncDef.flags fields into a single

2013-09-06 13:10:12 +00:00

wal.c

Add extended error code SQLITE_BUSY_SNAPSHOT - returned in WAL mode when a read-transaction cannot be upgraded to a write-transaction because it is reading from a snapshot other than the most recently committed.

2013-06-27 11:46:27 +00:00

wal.h

Minor fixes for compilation with SQLITE_OMIT_WAL defined.

2013-05-02 17:37:31 +00:00

walker.c

Increase the number of bits available in Expr.flags. Other tweaks aimed at

2013-09-12 16:50:49 +00:00

where.c

Import the "PRAGMA vdbe_eqp" enhancement and the enhanced EXPLAIN formatting

2013-11-13 19:01:41 +00:00

whereInt.h

Improve the way that skip-scan loops are constructued. Add test cases.

2013-11-13 16:58:54 +00:00