]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
9 years agoAdd the slightly faster sqlite3DbMallocRawNN(db,n) routine for the majority oom-handling
drh [Fri, 5 Feb 2016 13:38:36 +0000 (13:38 +0000)] 
Add the slightly faster sqlite3DbMallocRawNN(db,n) routine for the majority
cases where db is guaranteed to be not NULL.

FossilOrigin-Name: 0a802e96ab06e2643834b83671fa8353da1a348d

9 years agoOOM failures on sqlite3_errmsg16() in an app-defined function are no longer
drh [Fri, 5 Feb 2016 04:50:27 +0000 (04:50 +0000)] 
OOM failures on sqlite3_errmsg16() in an app-defined function are no longer
benign.

FossilOrigin-Name: 9efb223f4ce8ccc00515f8f016f7c494c9ae5096

9 years agoMinor simplification of schema error reporting.
drh [Fri, 5 Feb 2016 02:50:11 +0000 (02:50 +0000)] 
Minor simplification of schema error reporting.

FossilOrigin-Name: a8846aeed9992c6c9f1c8bd6e996a4cbe891751e

9 years agoFurther performance improvements that fall out of the mallocFailed changes.
drh [Fri, 5 Feb 2016 02:42:54 +0000 (02:42 +0000)] 
Further performance improvements that fall out of the mallocFailed changes.

FossilOrigin-Name: d94416ddca8f7ed727dd335d38155ea5945a86b7

9 years agoImprovements to the way that OOM errors are processed.
drh [Fri, 5 Feb 2016 01:55:27 +0000 (01:55 +0000)] 
Improvements to the way that OOM errors are processed.

FossilOrigin-Name: c3ef03478a5788c855b3aef385d43ae7f494f440

9 years agoTemporarily back out the 0.5% performance improvement from
drh [Thu, 4 Feb 2016 19:50:33 +0000 (19:50 +0000)] 
Temporarily back out the 0.5% performance improvement from
check-in [632071bac5ff32].  Need a more elaborate solution that works
with reentrant virtual tables and SQL functions.

FossilOrigin-Name: 42736fb0adc82a0fb692850ff3dd3f9b501cbf1f

9 years agoFurther improve performance of unindexed fts5 prefix queries.
dan [Thu, 4 Feb 2016 19:45:19 +0000 (19:45 +0000)] 
Further improve performance of unindexed fts5 prefix queries.

FossilOrigin-Name: c9c6457d8ea911f6cc63967127e58da3146fd3ef

9 years agoAvoid running some particularly time-consuming tests as part of veryquick.test.
dan [Thu, 4 Feb 2016 17:31:03 +0000 (17:31 +0000)] 
Avoid running some particularly time-consuming tests as part of veryquick.test.

FossilOrigin-Name: f465944b75a800ddc6920229ad32c2f39ff91e19

9 years agoRemove unnecessary sets of db->mallocFailed.
drh [Thu, 4 Feb 2016 11:48:00 +0000 (11:48 +0000)] 
Remove unnecessary sets of db->mallocFailed.

FossilOrigin-Name: b787165b25a240fd5b4a5c7f73b395f30213a1d7

9 years agoUse sqlite3_malloc64() instead of sqlite3_malloc() in the spellfix extension.
drh [Thu, 4 Feb 2016 11:15:57 +0000 (11:15 +0000)] 
Use sqlite3_malloc64() instead of sqlite3_malloc() in the spellfix extension.

FossilOrigin-Name: 634d008c34bd237fc9cfb88dc291394fc5d31efa

9 years agoEscape control characters in JSON.
drh [Thu, 4 Feb 2016 10:28:57 +0000 (10:28 +0000)] 
Escape control characters in JSON.
Fix for ticket [ad2559db380abf8].

FossilOrigin-Name: 4f1b5229a3bbc9d40b7433a5eb3139d59d31dcb1

9 years agoRefinements to synchronous logic:
drh [Thu, 4 Feb 2016 09:48:12 +0000 (09:48 +0000)] 
Refinements to synchronous logic:
(1) Use PAGER_SYNCHRONOUS_FULL rather than the corresponding magic number.
(2) Honor SQLITE_NO_SYNC on xDelete calls with sync
(3) Count xDelete syncs during testing
(4) Fix #ifs on SQLITE_EXTRA_DURABLE so that directory syncs on journal
unlink are off by default.

FossilOrigin-Name: e3157cb5ad0d22758e766a95fb1463a7810f7d7f

9 years agoIn the VDBE loop, only check for OOM errors at jumps rather than after every
drh [Wed, 3 Feb 2016 22:14:38 +0000 (22:14 +0000)] 
In the VDBE loop, only check for OOM errors at jumps rather than after every
opcode, for about a 0.5% performance increase.

FossilOrigin-Name: 632071bac5ff324a74cec9bdbba2deb60c0945e9

9 years agoImprove performance of fts5 prefix queries on detail=col tables.
dan [Wed, 3 Feb 2016 20:04:59 +0000 (20:04 +0000)] 
Improve performance of fts5 prefix queries on detail=col tables.

FossilOrigin-Name: ca11f46db047e7f131cef3893f73824758a2076b

9 years agoFix markup errors in comments used to generate the documentation - specifically
drh [Wed, 3 Feb 2016 19:52:06 +0000 (19:52 +0000)] 
Fix markup errors in comments used to generate the documentation - specifically
in the documentation on the OP_Seek opcode.

FossilOrigin-Name: ef252bc4b59d272460aaebdc0d4b8e347b0d25a8

9 years agoAdd "PRAGMA synchronous=EXTRA" which syncs the directory containing the
drh [Wed, 3 Feb 2016 19:20:15 +0000 (19:20 +0000)] 
Add "PRAGMA synchronous=EXTRA" which syncs the directory containing the
rollback journal when the rollback journal is deleted in order to commit a
transaction in DELETE mode.

FossilOrigin-Name: af92401826f5cf49e62c278f344ab75252a18da2

9 years agoEnhance the internal sqlite3VdbeAddOpList() interface to automatically update
drh [Wed, 3 Feb 2016 01:55:44 +0000 (01:55 +0000)] 
Enhance the internal sqlite3VdbeAddOpList() interface to automatically update
jump destinations.  Use this feature to simplify the AUTOINCREMENT code
generator.

FossilOrigin-Name: ae8b9d2edf1b5aef6108e729754911db7682b6a3

9 years agoAdd tests to restore full coverage of fts5 code.
dan [Tue, 2 Feb 2016 21:19:21 +0000 (21:19 +0000)] 
Add tests to restore full coverage of fts5 code.

FossilOrigin-Name: 063755c81574800e7db12a42e17d982a8c1e5181

9 years agoEnhance the performance of fts5 AND and OR queries.
dan [Tue, 2 Feb 2016 17:40:41 +0000 (17:40 +0000)] 
Enhance the performance of fts5 AND and OR queries.

FossilOrigin-Name: 62ea9e5ab8bc1a20245beebceb5ea62dcd7ec84e

9 years agoEnhance the comment on the sqlite3_index_constraint object to bring attention
drh [Tue, 2 Feb 2016 02:04:21 +0000 (02:04 +0000)] 
Enhance the comment on the sqlite3_index_constraint object to bring attention
to the fact than iColumn field can be negative for a rowid.

FossilOrigin-Name: d8b7b1996eefae7768bfcb82d4ff22c69392aa63

9 years agoChange the OP_SetCookie instruction to write the literal P3 value, not the
drh [Mon, 1 Feb 2016 21:48:34 +0000 (21:48 +0000)] 
Change the OP_SetCookie instruction to write the literal P3 value, not the
value in register P3.

FossilOrigin-Name: 6d7d4703ebf3754bec74123d5ba7e861a705f90f

9 years agoImprove performance of fts5 queries.
dan [Mon, 1 Feb 2016 20:12:41 +0000 (20:12 +0000)] 
Improve performance of fts5 queries.

FossilOrigin-Name: 2334e88244afe6387208be5d527aba9b5ddf4e4c

9 years agoNumber VDBE opcodes starting with 0 instead of 1, as this obviates the
drh [Mon, 1 Feb 2016 17:20:08 +0000 (17:20 +0000)] 
Number VDBE opcodes starting with 0 instead of 1, as this obviates the
lower-bound test on "switch(opcode){...}", making the code smaller and faster.

FossilOrigin-Name: 4c9222f75bfac47f5422fff86b2d69a61933b3a2

9 years agoUpdate walcrash.test to ensure that, during a particular test, enough data is written...
dan [Mon, 1 Feb 2016 16:36:47 +0000 (16:36 +0000)] 
Update walcrash.test to ensure that, during a particular test, enough data is written to cause SQLite to sync the wal file 14 times.

FossilOrigin-Name: 5d7c092869137a0ba69f93324fe4ed56a05b5985

9 years agoFix a problem causing the OR/covering-index optimization to be disabled if compile...
dan [Mon, 1 Feb 2016 13:58:56 +0000 (13:58 +0000)] 
Fix a problem causing the OR/covering-index optimization to be disabled if compile time parameter SQLITE_MAX_ATTACHED were set to greater than 30.

FossilOrigin-Name: a17712bf8d98dd485560f434a5350e6381cf1411

9 years agoMinor simplification to the OP_AutoCommit opcode. Fix some code comments
drh [Mon, 1 Feb 2016 13:21:13 +0000 (13:21 +0000)] 
Minor simplification to the OP_AutoCommit opcode.  Fix some code comments
related to transaction control.

FossilOrigin-Name: a9b6a0672f84dd205f9333951e4c2a608d027d71

9 years agoFix an assert() that might fail on a corrupt database.
drh [Mon, 1 Feb 2016 00:21:08 +0000 (00:21 +0000)] 
Fix an assert() that might fail on a corrupt database.

FossilOrigin-Name: 22eaced7274764eaf7ab4b5fc52cc2fcfc285708

9 years agoFix new test cases in stat.test so that they work with -DSQLITE_DEFAULT_AUTOVACUUM...
dan [Sat, 30 Jan 2016 21:09:02 +0000 (21:09 +0000)] 
Fix new test cases in stat.test so that they work with -DSQLITE_DEFAULT_AUTOVACUUM=1 builds.

FossilOrigin-Name: a2810cf65db13479e2ab255c37abac7841ee985d

9 years agoPerformance enhancement for fts5 column filter queries on detail=full tables.
dan [Sat, 30 Jan 2016 19:16:11 +0000 (19:16 +0000)] 
Performance enhancement for fts5 column filter queries on detail=full tables.

FossilOrigin-Name: 13fb4aa6a87c5c6258979953da82eedc1a7bf14f

9 years agoMerge the implementation of OP_IdxRowid and OP_Seek so that OP_Seek no longer
drh [Sat, 30 Jan 2016 16:59:56 +0000 (16:59 +0000)] 
Merge the implementation of OP_IdxRowid and OP_Seek so that OP_Seek no longer
requires the rowid register and a separate OP_IdxRowid call.  Shorter and
faster prepared statements result.

FossilOrigin-Name: 9bec50a1e7796a6e038db9b1cc7cc1e7e350bf74

9 years agoOnly honor the register subtype value if the MEM_Subtype flag is set.
drh [Sat, 30 Jan 2016 15:52:39 +0000 (15:52 +0000)] 
Only honor the register subtype value if the MEM_Subtype flag is set.
Revised and improved fix for ticket [f45ac567eaa9f9].

FossilOrigin-Name: 1f4c667f37d63fc3ef2e8f2581ecd3a66c054426

9 years agoA different way to clear the subtype on VDBE registers when the value of the register... clear-subtype-flag
dan [Sat, 30 Jan 2016 15:46:03 +0000 (15:46 +0000)] 
A different way to clear the subtype on VDBE registers when the value of the register is overwritten with new content. To fix [[f45ac567eaa9f93].

FossilOrigin-Name: 2e9fb1295cd31fc29c97444c3dec82fef68e939f

9 years agoOutput subtype information on register traces for PRAGMA vdbe_trace.
drh [Sat, 30 Jan 2016 14:17:10 +0000 (14:17 +0000)] 
Output subtype information on register traces for PRAGMA vdbe_trace.

FossilOrigin-Name: 96b780209cc95c3f3769bb880591380d94bfe38d

9 years agoAdd the BTREE_FORDELETE and BTREE_AUXDELETE flags to the b-tree layer interface
drh [Sat, 30 Jan 2016 13:32:30 +0000 (13:32 +0000)] 
Add the BTREE_FORDELETE and BTREE_AUXDELETE flags to the b-tree layer interface
and use them.  Add assert() statement to verify that they are correct.

FossilOrigin-Name: 85c467041c9378cae3038756da815e9117ee8c7d

9 years agoSimplification and size reduction to the printf logic. Remove the bFlags
drh [Sat, 30 Jan 2016 12:50:25 +0000 (12:50 +0000)] 
Simplification and size reduction to the printf logic.  Remove the bFlags
parameter from sqlite3VXPrintf() and sqlite3XPrintf().  Use sqlite3XPrintf()
instead of sqlite3_snprintf() for rendering P4 values in EXPLAIN output.

FossilOrigin-Name: 0bdb41c45aa1cc8e5c136aaa6605d54b401483bd

9 years agoMake use of covering indexes in the OR optimization.
drh [Sat, 30 Jan 2016 02:10:38 +0000 (02:10 +0000)] 
Make use of covering indexes in the OR optimization.

FossilOrigin-Name: 9de3d7123007636aa97da1c70bc34344b0391078

9 years agoChange the P4_INTARRAY so that always begins with a length integer. Print covering-or
drh [Sat, 30 Jan 2016 00:45:18 +0000 (00:45 +0000)] 
Change the P4_INTARRAY so that always begins with a length integer.  Print
the content of the INTARRAY on EXPLAIN output.

FossilOrigin-Name: 6c520d5726e80b4251338c43c405270d150ea81e

9 years agoAdd tests for the change on this branch.
dan [Fri, 29 Jan 2016 21:16:13 +0000 (21:16 +0000)] 
Add tests for the change on this branch.

FossilOrigin-Name: 7cb697f82932a2581af69350117a29c9c8a2544f

9 years agoDifferent comment on the alternative cursor fields of VdbeCursor.
drh [Fri, 29 Jan 2016 20:58:40 +0000 (20:58 +0000)] 
Different comment on the alternative cursor fields of VdbeCursor.

FossilOrigin-Name: 6e3dcb6d7d960bb513d9a4a002b6cf5ab7159686

9 years agoExperimental attempt to make better use of covering indexes within OR queries.
dan [Fri, 29 Jan 2016 19:29:45 +0000 (19:29 +0000)] 
Experimental attempt to make better use of covering indexes within OR queries.

FossilOrigin-Name: a323ac3a9d42bd5cb38d724c7e1180584b91054c

9 years agoImprovements to FORDELETE processing, including bug fixes and adding btree-fordelete-flag
drh [Fri, 29 Jan 2016 19:04:11 +0000 (19:04 +0000)] 
Improvements to FORDELETE processing, including bug fixes and adding
assert() statements to help verify correct operation.

FossilOrigin-Name: 46080b0474363ca6594d2e5c249a280e2b4fc67a

9 years agoRemove a stray "exit" in a test script. fordelete-assert
drh [Fri, 29 Jan 2016 18:48:08 +0000 (18:48 +0000)] 
Remove a stray "exit" in a test script.

FossilOrigin-Name: 10c88bf9f2c238abbbb54797ee2327ab72713e6f

9 years agoAvoid unnecessary WHERE clause term tests when coding a join where one of the tables...
drh [Fri, 29 Jan 2016 18:11:04 +0000 (18:11 +0000)] 
Avoid unnecessary WHERE clause term tests when coding a join where one of the tables contains a OR constraint.

FossilOrigin-Name: 512caa1ad30e6f699e2d006d5ab7674d55d2c746

9 years agoPrepend "rc!=SQLITE_OK || " to the nExtraDelete assert() condition.
dan [Fri, 29 Jan 2016 18:04:31 +0000 (18:04 +0000)] 
Prepend "rc!=SQLITE_OK || " to the nExtraDelete assert() condition.

FossilOrigin-Name: 2a055ed0afd56e8c6b17cfc31e7808debe9ec765

9 years agoAvoid unnecessary WHERE clause term tests when coding a join where one OR-clause-improvement
drh [Fri, 29 Jan 2016 16:57:06 +0000 (16:57 +0000)] 
Avoid unnecessary WHERE clause term tests when coding a join where one
of the tables contains a OR constraint.

FossilOrigin-Name: ab94603974a0ad5342e5aee27603162652e70492

9 years agoAvoid two more instances of pointer arithmetic on freed pointers.
dan [Fri, 29 Jan 2016 08:38:35 +0000 (08:38 +0000)] 
Avoid two more instances of pointer arithmetic on freed pointers.

FossilOrigin-Name: 2910ef64097b890c9f8929bf609ea2827db7ac97

9 years agoModify the order of terms in an "if" condition to avoid implicitly comparing a dangli...
dan [Thu, 28 Jan 2016 18:22:46 +0000 (18:22 +0000)] 
Modify the order of terms in an "if" condition to avoid implicitly comparing a dangling pointer to NULL following an OOM error.

FossilOrigin-Name: 5372f800835da61736a64dcee8b476bbe7ee2e46

9 years agoModifications to ensure the nExtraDelete-related assert() statement does not fail.
dan [Thu, 28 Jan 2016 17:06:17 +0000 (17:06 +0000)] 
Modifications to ensure the nExtraDelete-related assert() statement does not fail.

FossilOrigin-Name: f43ff8f82d6c1239e6f9a32e7716421c1180ac74

9 years agoRemove a duplicate "p->magic = VDBE_MAGIC_RUN;" line from vdbeaux.c.
dan [Thu, 28 Jan 2016 08:58:45 +0000 (08:58 +0000)] 
Remove a duplicate "p->magic = VDBE_MAGIC_RUN;" line from vdbeaux.c.

FossilOrigin-Name: 688eb3b400a3f2f8005c341e8259f4c1485cb0ed

9 years agoFix for pthread detection in the configure scripts.
drh [Thu, 28 Jan 2016 02:47:32 +0000 (02:47 +0000)] 
Fix for pthread detection in the configure scripts.

FossilOrigin-Name: 47633ffdbfead3ce7b1f6560660df99f950d24f8

9 years agoMinor correction to the batch tool changes in the previous check-in.
mistachkin [Thu, 28 Jan 2016 00:04:32 +0000 (00:04 +0000)] 
Minor correction to the batch tool changes in the previous check-in.

FossilOrigin-Name: 7c89d75de1e8d44d7ebd8eac1320b50dd6c221a8

9 years agoMatch the MSVC batch build tool sub-routine 'fn_UnsetVariable' a bit more robust.
mistachkin [Wed, 27 Jan 2016 23:50:14 +0000 (23:50 +0000)] 
Match the MSVC batch build tool sub-routine 'fn_UnsetVariable' a bit more robust.

FossilOrigin-Name: 1edd5f31b9e6f91bb5434055a539428c000f1084

9 years agoChange the name of the BTREE_IDXDELETE flag to BTREE_AUXDELETE, to better
drh [Wed, 27 Jan 2016 16:26:25 +0000 (16:26 +0000)] 
Change the name of the BTREE_IDXDELETE flag to BTREE_AUXDELETE, to better
reflect its purpose.

FossilOrigin-Name: 1d3bf6bebdda9f96734bc139601e9b05344ea0b4

9 years agoFix tests in fordelete.test to test for the BTREE_AUXDELETE flag.
dan [Wed, 27 Jan 2016 16:17:41 +0000 (16:17 +0000)] 
Fix tests in fordelete.test to test for the BTREE_AUXDELETE flag.

FossilOrigin-Name: bbd25cf179df5bda1fe729928d6746248f06e46f

9 years agoAdd assert() statements on the nExtraDelete variable in vdbe.c to try to verify
drh [Wed, 27 Jan 2016 15:49:32 +0000 (15:49 +0000)] 
Add assert() statements on the nExtraDelete variable in vdbe.c to try to verify
that the FORDELETE and IDXDELETE flags are being generated correctly.  Those
flags are not currently generated correctly, and so the assert()s trip on this
check-in.

FossilOrigin-Name: dde1db0dd2e2cf04706117629756c352b178ebb8

9 years agoSupport building for Windows 10 desktop using 'MinCore.lib'.
mistachkin [Wed, 27 Jan 2016 07:28:33 +0000 (07:28 +0000)] 
Support building for Windows 10 desktop using 'MinCore.lib'.

FossilOrigin-Name: 4bf89891fbb076364dc45a6bf3246efa6bc33d5d

9 years agoMerge all recent trunk enhancements.
drh [Tue, 26 Jan 2016 23:32:55 +0000 (23:32 +0000)] 
Merge all recent trunk enhancements.

FossilOrigin-Name: 9a71d56dcea953cb965f1fdda9a8b8f158cdeff6

9 years agoPerformance improvements for fts5, particularly detail=col mode.
dan [Tue, 26 Jan 2016 20:19:55 +0000 (20:19 +0000)] 
Performance improvements for fts5, particularly detail=col mode.

FossilOrigin-Name: a3d7b8ac53f94d29a11362f193fd1967f30583df

9 years agoFurther minor performance improvements and code-size reductions related to fts5 colum... fts5-perf
dan [Tue, 26 Jan 2016 20:08:50 +0000 (20:08 +0000)] 
Further minor performance improvements and code-size reductions related to fts5 column filters on detail=col tables.

FossilOrigin-Name: b4ac61aeee976296e7719949cd4fb496147a29e8

9 years agoImprove the performance of fts5 column filters on detail=col tables.
dan [Tue, 26 Jan 2016 19:30:49 +0000 (19:30 +0000)] 
Improve the performance of fts5 column filters on detail=col tables.

FossilOrigin-Name: 249a2d070c34bf884a04cb248b9691e239f2871c

9 years agoEnhance fts5txt2db.tcl, a script used to generate fts5/fts4 databases for performance...
dan [Tue, 26 Jan 2016 17:08:22 +0000 (17:08 +0000)] 
Enhance fts5txt2db.tcl, a script used to generate fts5/fts4 databases for performance testing.

FossilOrigin-Name: c646e40350e5aa91abcf52de61fb31275bad38f9

9 years agoFix issues on unix with opening database files via symlinks that are not in the curre...
dan [Tue, 26 Jan 2016 14:48:02 +0000 (14:48 +0000)] 
Fix issues on unix with opening database files via symlinks that are not in the current working directory. And with nested symlinks.

FossilOrigin-Name: 4003db4a49c6b623750e56f626fa492c8402067f

9 years agoEnsure that unixFullpathname() always nul-terminates its output buffer, even when... follow-symlinks
dan [Tue, 26 Jan 2016 13:56:42 +0000 (13:56 +0000)] 
Ensure that unixFullpathname() always nul-terminates its output buffer, even when returning an error.

FossilOrigin-Name: 4a4385564dd3887a7953820b60c99d6ce289f96a

9 years agoRemove an unused variable.
drh [Tue, 26 Jan 2016 00:12:42 +0000 (00:12 +0000)] 
Remove an unused variable.

FossilOrigin-Name: 1c2656c1d37906230edc142d3a4253b16b6e925f

9 years agoAdd the ability to do Windows builds to the amalgamation tarball.
drh [Mon, 25 Jan 2016 23:24:38 +0000 (23:24 +0000)] 
Add the ability to do Windows builds to the amalgamation tarball.

FossilOrigin-Name: abd2b357c55fdcdbc8e66a81a3fbb7f822ea0a4f

9 years agoMinor changes to the autoconf/README.txt file. msvcMakeMin
drh [Mon, 25 Jan 2016 23:19:58 +0000 (23:19 +0000)] 
Minor changes to the autoconf/README.txt file.

FossilOrigin-Name: 6df8a9c00a9d067f67d492da7a4617908070c6c0

9 years agoFix a compiler warning about doing pointer arithmetic involving a NULL pointer
drh [Mon, 25 Jan 2016 22:08:11 +0000 (22:08 +0000)] 
Fix a compiler warning about doing pointer arithmetic involving a NULL pointer
even though the result of computation is never used.

FossilOrigin-Name: 7c49a9478bd36564e81d33458ca1f4063ddaca83

9 years agoOnly use lstat() if the HAVE_LSTAT macro is defined. Fix some test file issues.
dan [Mon, 25 Jan 2016 18:43:05 +0000 (18:43 +0000)] 
Only use lstat() if the HAVE_LSTAT macro is defined. Fix some test file issues.

FossilOrigin-Name: 8a6e4147a680ad6c5fdd588468b6daac82349d2c

9 years agoSimplify the unixFullpathname() function. This adds a dependency on lstat().
dan [Mon, 25 Jan 2016 18:05:49 +0000 (18:05 +0000)] 
Simplify the unixFullpathname() function. This adds a dependency on lstat().

FossilOrigin-Name: f71249d3db9242b8f38955db51a7a5789d002803

9 years agoFix issues on unix with opening database files via symlinks that are not in the curre...
dan [Mon, 25 Jan 2016 17:04:48 +0000 (17:04 +0000)] 
Fix issues on unix with opening database files via symlinks that are not in the current working directory. And with nested symlinks.

FossilOrigin-Name: 80398fd44fb232193450103808e1854e0eba5652

9 years agoReplace the OP_SetIfNotPos operator with OP_OffsetLimit in the VDBE, for
drh [Mon, 25 Jan 2016 15:57:29 +0000 (15:57 +0000)] 
Replace the OP_SetIfNotPos operator with OP_OffsetLimit in the VDBE, for
simpler and smaller code.

FossilOrigin-Name: 7ac017a498b6fb28343eef2d24e400c7800660d6

9 years agoAdd the SQLITE_EXTRA_DURABLE compile-time option.
drh [Mon, 25 Jan 2016 13:55:47 +0000 (13:55 +0000)] 
Add the SQLITE_EXTRA_DURABLE compile-time option.

FossilOrigin-Name: 30671345b1c1ee55a2d1aa17273213f1849efd81

9 years agoSmall simplification to the prepare statement opcode memory reuse logic.
drh [Mon, 25 Jan 2016 02:15:02 +0000 (02:15 +0000)] 
Small simplification to the prepare statement opcode memory reuse logic.
Easier to read, and slightly smaller and faster.

FossilOrigin-Name: 8a1deae497edf3fa43fa96152d140405398c5ed6

9 years agoSmall simplification and performance improvement in memsys5Free().
drh [Mon, 25 Jan 2016 01:07:59 +0000 (01:07 +0000)] 
Small simplification and performance improvement in memsys5Free().

FossilOrigin-Name: 0a9cff5c4822874b74e90bfca3963bc7e5c753a5

9 years agoAdd the SQLITE_SPELLFIX_STACKALLOC_SZ compile-time option to control how much
drh [Sat, 23 Jan 2016 22:55:53 +0000 (22:55 +0000)] 
Add the SQLITE_SPELLFIX_STACKALLOC_SZ compile-time option to control how much
stack space is available for use as the Wagner matrix in editDest3 of the
spellfix extension.

FossilOrigin-Name: dd0100dd87e2c7c70fabb2d3188f0906e605583d

9 years agoMore updates to the README.
mistachkin [Sat, 23 Jan 2016 21:57:46 +0000 (21:57 +0000)] 
More updates to the README.

FossilOrigin-Name: 9f02868df71d902a2b9118d0b06df18ee92b666b

9 years agoUpdates to the autoconf README file.
drh [Sat, 23 Jan 2016 20:43:48 +0000 (20:43 +0000)] 
Updates to the autoconf README file.

FossilOrigin-Name: 4ce60fa42d8486d219d40d25d785d7f2cabe5e06

9 years agoMove Makefile.min.msc into the autoconf subdir where it belongs and change
drh [Sat, 23 Jan 2016 20:34:27 +0000 (20:34 +0000)] 
Move Makefile.min.msc into the autoconf subdir where it belongs and change
its name to Makefile.msc.  Adjust build scripts accordingly.

FossilOrigin-Name: 12eb8db79697ef55228c78011d275f36f58271e1

9 years agoMinor coding style tweaks for the mkmsvcmin tool.
mistachkin [Sat, 23 Jan 2016 20:16:40 +0000 (20:16 +0000)] 
Minor coding style tweaks for the mkmsvcmin tool.

FossilOrigin-Name: c15e0fc4be08b92547bea1f1cac65581ef497409

9 years agoAdjust the amalgamation-tarball build process so that it includes the
drh [Sat, 23 Jan 2016 20:09:30 +0000 (20:09 +0000)] 
Adjust the amalgamation-tarball build process so that it includes the
MSVC makefile and the sqlite3.rc resource file.

FossilOrigin-Name: e420f3dc93a0e3364f0773950b7a125f5221a109

9 years agoImproved comments on the transformation script and on the generated Makefile.
drh [Sat, 23 Jan 2016 19:47:00 +0000 (19:47 +0000)] 
Improved comments on the transformation script and on the generated Makefile.

FossilOrigin-Name: c6e633ab73812fe38f3e969f1652f1b5759096e4

9 years agoUse the -integer option when sorting list elements.
mistachkin [Sat, 23 Jan 2016 19:24:19 +0000 (19:24 +0000)] 
Use the -integer option when sorting list elements.

FossilOrigin-Name: 949aa614e1401f6ab61cbb2e0469c60d764e6880

9 years agoFix an fts5 problem with using both xPhraseFirst() and xPhraseFirstColumn() within...
dan [Sat, 23 Jan 2016 18:51:59 +0000 (18:51 +0000)] 
Fix an fts5 problem with using both xPhraseFirst() and xPhraseFirstColumn() within a single statement in detail=col mode.

FossilOrigin-Name: 72d53699bf0dcdb9d2a22e229989d7435f061399

9 years agoChanges to spellfix to try to get it to use stack space instead of heap space
drh [Sat, 23 Jan 2016 18:24:52 +0000 (18:24 +0000)] 
Changes to spellfix to try to get it to use stack space instead of heap space
in cases where that makes sense.

FossilOrigin-Name: dfcebc7393a3a780ee9c4f257723c303bb633064

9 years agoMerge trunk changes (including fixes for warnings in fts5) with this branch.
dan [Sat, 23 Jan 2016 16:20:16 +0000 (16:20 +0000)] 
Merge trunk changes (including fixes for warnings in fts5) with this branch.

FossilOrigin-Name: ceccc9ad788fb4da9120915741995b9f088f85ff

9 years agoFix some signed/unsigned comparison compiler warnings in fts5.
dan [Sat, 23 Jan 2016 15:57:06 +0000 (15:57 +0000)] 
Fix some signed/unsigned comparison compiler warnings in fts5.

FossilOrigin-Name: 3be336aa893f9eb0837d7d66c83bab1489792b9a

9 years agoFix a problem involving detail=col and column filters.
dan [Sat, 23 Jan 2016 14:45:36 +0000 (14:45 +0000)] 
Fix a problem involving detail=col and column filters.

FossilOrigin-Name: 7558a0ad2276e91f2faced8ea405d9fdb4fa0c6e

9 years agoRemove an assert() that can be false if compiled with SQLITE_USE_ALLOCA.
drh [Sat, 23 Jan 2016 14:05:27 +0000 (14:05 +0000)] 
Remove an assert() that can be false if compiled with SQLITE_USE_ALLOCA.

FossilOrigin-Name: f0a551edf87ef061deae34d88b02c3b484ae9adc

9 years agoAdd tooling to create an MSVC Makefile capable of building the core library and shell...
mistachkin [Sat, 23 Jan 2016 07:53:04 +0000 (07:53 +0000)] 
Add tooling to create an MSVC Makefile capable of building the core library and shell only, using a pre-built amalgamation.

FossilOrigin-Name: c46f1a13cb00264d1164399059250884c7be4ea0

9 years agoMore work on the MSVC build.
mistachkin [Sat, 23 Jan 2016 00:07:51 +0000 (00:07 +0000)] 
More work on the MSVC build.

FossilOrigin-Name: a79c46bc61a35edbaf6112c26e8052314b0eb16a

9 years agoIn the TCL interface, if a database connection object was opened with
drh [Fri, 22 Jan 2016 23:17:51 +0000 (23:17 +0000)] 
In the TCL interface, if a database connection object was opened with
the -uri 1 option, then also honor URI filenames for the "backup" and
"restore" commands.

FossilOrigin-Name: a1c8116ced62d81f3f5ca26bbe0877e829d4cc56

9 years agoMore MSVC makefile cleanup.
mistachkin [Fri, 22 Jan 2016 22:16:50 +0000 (22:16 +0000)] 
More MSVC makefile cleanup.

FossilOrigin-Name: df22556fd75997111e52f96572da8379dfe948be

9 years agoExperimental performance enhancements for fts5.
dan [Fri, 22 Jan 2016 19:48:34 +0000 (19:48 +0000)] 
Experimental performance enhancements for fts5.

FossilOrigin-Name: b5a57b812fd6a734cf2a342bf0b730ae18912d73

9 years agoReenable the xCurrentTime and xGetLastError methods on the unix VFSes as long
drh [Fri, 22 Jan 2016 19:44:03 +0000 (19:44 +0000)] 
Reenable the xCurrentTime and xGetLastError methods on the unix VFSes as long
as SQLITE_OMIT_DEPRECATED is not defined.

FossilOrigin-Name: c11c85fdb6514cae54bb44945cc197dcaba72307

9 years agoAdd the sqlite3TokenInit() utility function.
drh [Fri, 22 Jan 2016 17:48:09 +0000 (17:48 +0000)] 
Add the sqlite3TokenInit() utility function.

FossilOrigin-Name: 7323175337b7ba85ac932ca892b28860f6a5b688

9 years agoHave the dbstat module dequote any argument passed to the CREATE VIRTUAL TABLE statem...
dan [Fri, 22 Jan 2016 15:44:07 +0000 (15:44 +0000)] 
Have the dbstat module dequote any argument passed to the CREATE VIRTUAL TABLE statement before attempting to match it against the names of attached databases.

FossilOrigin-Name: e60461e984b8df09256bb0d733dbfae52568a145

9 years agoEnable FTS4 when building the shell with the MSVC makefile.
mistachkin [Fri, 22 Jan 2016 04:22:36 +0000 (04:22 +0000)] 
Enable FTS4 when building the shell with the MSVC makefile.

FossilOrigin-Name: e4c07df557cd50786b05eecf011bf94708e6e31b

9 years agoFurther refinements to the MSVC makefile.
mistachkin [Fri, 22 Jan 2016 03:54:36 +0000 (03:54 +0000)] 
Further refinements to the MSVC makefile.

FossilOrigin-Name: 67625b963a6f5a0c6dff1a04a323e693569c2d94

9 years agoMSVC makefile enhancements for use with the Windows 10 SDK.
mistachkin [Fri, 22 Jan 2016 01:25:15 +0000 (01:25 +0000)] 
MSVC makefile enhancements for use with the Windows 10 SDK.

FossilOrigin-Name: ac2e9d3de54d299f92fc35927b6df6d3aaa2dc59

9 years agoFix typo in 'Makefile.in'.
mistachkin [Thu, 21 Jan 2016 18:56:10 +0000 (18:56 +0000)] 
Fix typo in 'Makefile.in'.

FossilOrigin-Name: 29a51c6dcc0ef7cab51aba0024e9c5bec89c6973