drh 735406d945 Make sure the omit-noop-left-join optimization is not applied if columns ...

of the LEFT JOIN are used in the ORDER BY clause.  
Ticket [be84e357c035].  Increase version number to 3.8.0.2.

FossilOrigin-Name: cce541864d2216c875992fe22bcb009747f72128

2013-09-03 14:33:46 +00:00

..

alter.c

Shared-cache mode fixes for views and virtual tables.

2012-10-04 19:33:00 +00:00

analyze.c

Fix the ANALYZE command to work with partial indices.

2013-08-01 04:39:17 +00:00

attach.c

Adjust #ifdefs to get SQLITE_OMIT_AUTOMATIC_INDEX and SQLITE_OMIT_PAGER_PRAGMAS

2013-08-23 17:33:46 +00:00

auth.c

…

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

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

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

btree.h

Add the cache_spill pragma.

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

btreeInt.h

Performance optimizations in the VDBE and especially to the OP_Next and

2013-08-20 03:13:51 +00:00

build.c

Fixes for harmless compiler warnings.

2013-08-19 11:15:48 +00:00

callback.c

Consolidate all occurrences of the "no such collation sequence" error message

2012-10-05 14:43:40 +00:00

complete.c

Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging

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

ctime.c

Fix a compiler warning in sqlite3_compileoption_used().

2013-04-18 03:10:43 +00:00

date.c

The date/time functions return NULL if the xCurrentTime or

2011-10-12 23:13:43 +00:00

delete.c

Add the logic to keep partial indices up to date through DML statements and

2013-08-01 01:14:43 +00:00

expr.c

Candidate fix for [d666d600a6].

2013-08-21 12:04:32 +00:00

fault.c

…

fkey.c

Add the "defer_foreign_keys" pragma and the SQLITE_DBSTATUS_DEFERRED_FKS

2013-07-11 15:03:32 +00:00

func.c

Simplification to the StrAccum object and the sqlite3StrAccumAppend()

2013-08-21 21:12:10 +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

…

insert.c

Fill out an initial implementation of the sqlite3ExprImpliesExpr() function.

2013-08-01 13:04:46 +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

Add the cache_spill pragma.

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

malloc.c

Make sure lookaside memory allocations are unusable after they are freed.

2012-05-21 16:59:16 +00:00

mem0.c

…

mem1.c

Remove tab characters from source code files. Replace them with spaces.

2012-08-20 15:53:54 +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

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

Allow the SQLITE_API macro to apply to the sqlite3_win32_sleep function.

2012-06-18 17:15: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

Disable posix_fallocate() for all systems, all the time, unless the

2013-06-20 14:07:37 +00:00

os_win.c

Limit the number of memset() calls used when determining a temporary file name on Windows. Also, fix a harmless compiler warning.

2013-07-31 23:28:36 +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

Performance optimization: Avoid calling convertCompoundSelecctToSubquery()

2013-08-05 22:05:02 +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

Adjust #ifdefs to get SQLITE_OMIT_AUTOMATIC_INDEX and SQLITE_OMIT_PAGER_PRAGMAS

2013-08-23 17:33:46 +00:00

prepare.c

Make sure the sqlite3_prepare16 and sqlite3_prepare16_v2 interfaces do not

2013-07-16 23:26:43 +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

Make sure that GROUP BY terms select input column names in preference to

2013-08-15 22:40:21 +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

Performance optimization: Avoid calling convertCompoundSelecctToSubquery()

2013-08-05 22:05:02 +00:00

shell.c

Fix an off-by-one error that causes a quoted empty string at the end of

2013-08-29 13:23:59 +00:00

sqlite3.rc

Add Win32 version resources to the applicable binaries built by the MSVC makefile.

2012-09-03 10:32:32 +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 guard #ifndef to test_intarray.h to prevent harm if it is #included

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

sqliteInt.h

Simplification to the StrAccum object and the sqlite3StrAccumAppend()

2013-08-21 21:12:10 +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

…

tclsqlite.c

Make it easy to attach a debugger the test fixture process prior to any tests being run.

2013-08-15 08:06:15 +00:00

test1.c

Add a bit to the SQLITE_TESTCTRL_OPTIMIZATIONS option for sqlite3_file_control()

2013-06-28 17:29:25 +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

Many spelling fixes in comments. No changes to code.

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

test7.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

test8.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

test9.c

…

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

Remove the unused SQLITE_CURDIR macro.

2013-04-16 14:58:52 +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

Improved rounding accuracy on test-to-float conversions.

2012-06-19 00:45:16 +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

Add a version number to the sqlite3_pcache_methods2 object. Other PCACHE2

2011-11-13 21:44:03 +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

…

test_malloc.c

Add the "defer_foreign_keys" pragma and the SQLITE_DBSTATUS_DEFERRED_FKS

2013-07-11 15:03:32 +00:00

test_multiplex.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_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 support building with various SQLITE_OMIT_XXX options defined.

2011-04-06 17:54:31 +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

Fix a harmless compiler warning inside an assert() statement within test code.

2012-05-11 15:53:18 +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

…

tokenize.c

Updates to requirements marks. No code changes.

2013-08-02 23:40:45 +00:00

trigger.c

Many small harmless comment changes. Removal of obsolete comments and

2013-05-28 12:11:54 +00:00

update.c

Add the logic to keep partial indices up to date through DML statements and

2013-08-01 01:14:43 +00:00

utf.c

Remove an unnecessary parameter from sqlite3Utf8Read() resulting in a slight

2012-09-17 18:56:32 +00:00

util.c

Adjustment to an extreme corner case in the sqlite3Atoi64() routine.

2013-03-28 11:40:14 +00:00

vacuum.c

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

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

vdbe.c

If a virtual table xSync() returns an error message, copy it into a buffer allocated by sqlite3DbMalloc() before transfering it to Vdbe.zErrMsg.

2013-08-21 17:35:48 +00:00

vdbe.h

Refactor internal function name sqlite3VdbeGetValue() to

2013-08-01 12:21:58 +00:00

vdbeapi.c

Performance optimizations in the VDBE and especially to the OP_Next and

2013-08-20 03:13:51 +00:00

vdbeaux.c

If a virtual table xSync() returns an error message, copy it into a buffer allocated by sqlite3DbMalloc() before transfering it to Vdbe.zErrMsg.

2013-08-21 17:35:48 +00:00

vdbeblob.c

Increase the default SQLITE_MAX_SCHEMA_RETRY to 50. Make sure that macro

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

vdbeInt.h

Performance optimizations in the VDBE and especially to the OP_Next and

2013-08-20 03:13:51 +00:00

vdbemem.c

Update sqlite3MemCompare() to try common cases first, for a modest speed

2013-08-21 19:13:53 +00:00

vdbesort.c

Many small harmless comment changes. Removal of obsolete comments and

2013-05-28 12:11:54 +00:00

vdbetrace.c

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

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

vtab.c

If a virtual table xSync() returns an error message, copy it into a buffer allocated by sqlite3DbMalloc() before transfering it to Vdbe.zErrMsg.

2013-08-21 17:35:48 +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

Make sure the affinity and datatype of sub-subqueries are initialized

2013-04-25 00:57:10 +00:00

where.c

Make sure the omit-noop-left-join optimization is not applied if columns

2013-09-03 14:33:46 +00:00