]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
8 years agoMake SQLITE_GET_MUTEX_TIME a proper noop on non-Win32/non-POSIX. mutexDbg2
mistachkin [Wed, 15 Feb 2017 01:02:10 +0000 (01:02 +0000)] 
Make SQLITE_GET_MUTEX_TIME a proper noop on non-Win32/non-POSIX.

FossilOrigin-Name: 4ca2b2f8f593b6995d929cf7e64b7b1459ac3c5c

8 years agoAnother compilation fix for POSIX.
mistachkin [Wed, 15 Feb 2017 00:52:50 +0000 (00:52 +0000)] 
Another compilation fix for POSIX.

FossilOrigin-Name: 82ef47ea88d59e0e97492d61c16a3a36f87e1efd

8 years agoMake fine time granularity work on POSIX.
mistachkin [Wed, 15 Feb 2017 00:45:53 +0000 (00:45 +0000)] 
Make fine time granularity work on POSIX.

FossilOrigin-Name: 79057716d9ab9e05acdc1f204940ddd540a8f2ef

8 years agoCompilation fix for POSIX.
mistachkin [Wed, 15 Feb 2017 00:02:02 +0000 (00:02 +0000)] 
Compilation fix for POSIX.

FossilOrigin-Name: 9964ad245f66cd04cb41338180b65923ef093094

8 years agoExperimental enhancements to mutex debugging.
mistachkin [Tue, 14 Feb 2017 23:58:30 +0000 (23:58 +0000)] 
Experimental enhancements to mutex debugging.

FossilOrigin-Name: 804817549cfecbe5e1c4cea605d54cb4164f9bb6

8 years agoClarification of the help text for the command-line shell.
drh [Tue, 14 Feb 2017 21:47:46 +0000 (21:47 +0000)] 
Clarification of the help text for the command-line shell.

FossilOrigin-Name: ca4f1e4962df64ae756c286f3795af7d6f692cdd

8 years agoEnable the SQLITE_ENABLE_NULL_TRIM option for WITHOUT ROWID tables.
drh [Tue, 14 Feb 2017 20:00:16 +0000 (20:00 +0000)] 
Enable the SQLITE_ENABLE_NULL_TRIM option for WITHOUT ROWID tables.

FossilOrigin-Name: 54836270c9c0bfa5910f7ad74ec238b9d7ddee5f

8 years agoMore realistic lengths of string values in speedtest1 with --testset orm.
drh [Tue, 14 Feb 2017 16:30:13 +0000 (16:30 +0000)] 
More realistic lengths of string values in speedtest1 with --testset orm.

FossilOrigin-Name: e4731fd65f9698817690b741cc454f25e8e871e6

8 years agoFix a testcase number on the ORM testset of speedtest1.
drh [Tue, 14 Feb 2017 15:58:58 +0000 (15:58 +0000)] 
Fix a testcase number on the ORM testset of speedtest1.

FossilOrigin-Name: 58b2f911eec2e3eb9944dd6d8573ff5c7bd43f70

8 years agoAdd the new "--testset orm" to the speedtest1 utility.
drh [Tue, 14 Feb 2017 15:57:11 +0000 (15:57 +0000)] 
Add the new "--testset orm" to the speedtest1 utility.

FossilOrigin-Name: 1836adc1d1f8e496ae0a07bf0fc933a19dc8fee5

8 years agoChange all legacy instances of "#if SQLITE_DEBUG" to "#ifdef SQLITE_DEBUG" for
drh [Mon, 13 Feb 2017 13:35:55 +0000 (13:35 +0000)] 
Change all legacy instances of "#if SQLITE_DEBUG" to "#ifdef SQLITE_DEBUG" for
consistency.

FossilOrigin-Name: 670f10b24230863688270d12ac519609ade2302b

8 years agoFix typos in using the MSVC_VERSION macro.
drh [Mon, 13 Feb 2017 13:26:33 +0000 (13:26 +0000)] 
Fix typos in using the MSVC_VERSION macro.

FossilOrigin-Name: f3b65926b1f439adb95e3bbce8e58785b8cf8427

8 years agoAvoid a duplication #define in FTS5
drh [Mon, 13 Feb 2017 13:20:02 +0000 (13:20 +0000)] 
Avoid a duplication #define in FTS5

FossilOrigin-Name: c447441cff1884d6fe5f0a76d64b3e7d908584a1

8 years agoFix indexes on expressions so that they can be actually used with
drh [Sat, 11 Feb 2017 14:59:58 +0000 (14:59 +0000)] 
Fix indexes on expressions so that they can be actually used with
a COLLATE clause.

FossilOrigin-Name: e464b919f76520b45bb58983c6702db59d820ee4

8 years agoEnsure that indexed expressions with collating sequences are handled
drh [Sat, 11 Feb 2017 13:51:23 +0000 (13:51 +0000)] 
Ensure that indexed expressions with collating sequences are handled
correctly.  Proposed fix for ticket [eb703ba7b50c1a5].

FossilOrigin-Name: 9689d04b8250139e32078b2aa9748edcc6231bcd

8 years agoBump the version number up to 3.18.0.
drh [Fri, 10 Feb 2017 21:40:04 +0000 (21:40 +0000)] 
Bump the version number up to 3.18.0.

FossilOrigin-Name: 7520c238558346d421e3c24cb7d17a54d1aa56b2

8 years agoEnhance the LIKE optimization so that it works for arbitrary expressions on
drh [Fri, 10 Feb 2017 21:37:57 +0000 (21:37 +0000)] 
Enhance the LIKE optimization so that it works for arbitrary expressions on
the LHS as long as the pattern on the RHS does not begin with a digit or
a minus sign.

FossilOrigin-Name: 158290c0abafde67ee3f2363f0b6646887841df3

8 years agoAdd the "," flag to printf().
drh [Fri, 10 Feb 2017 19:38:36 +0000 (19:38 +0000)] 
Add the "," flag to printf().

FossilOrigin-Name: 064445b12f99f76e9a12957be97edd520ab3ae27

8 years agoCleanup the usage of the SQLITE_DISABLE_INTRINSIC compile-time option.
drh [Thu, 9 Feb 2017 17:12:22 +0000 (17:12 +0000)] 
Cleanup the usage of the SQLITE_DISABLE_INTRINSIC compile-time option.
Remove the SQLITE_RUNTIME_BYTEORDER compile-time option.  Use
-DSQLITE_BYTEORDER=0 instead.  Fix a bug in R-Tree that occurs when compiling
on a known little-endian machine without the use of intrinsic byteswapping
functions.

FossilOrigin-Name: 798fb9d70d2e5f95e64237b04d6692360133381a

8 years agoAvoid preparing a SELECT statement each time an UPDATE or DELETE by docid is
dan [Wed, 8 Feb 2017 19:12:36 +0000 (19:12 +0000)] 
Avoid preparing a SELECT statement each time an UPDATE or DELETE by docid is
executed against an fts3 table.

FossilOrigin-Name: 1afec5758b624e6a066d4e7ef50695095e9d7ff1

8 years agoAvoid preparing a SELECT statement each time an UPDATE or DELETE fts3-seekstmt-cache
dan [Wed, 8 Feb 2017 19:10:47 +0000 (19:10 +0000)] 
Avoid preparing a SELECT statement each time an UPDATE or DELETE
by docid is executed against an fts3 table.

FossilOrigin-Name: 9962c10a5c6672bd82b2bf640d878fcdac0b815a

8 years agoTypo fixes in comment. No changes to code.
mistachkin [Wed, 8 Feb 2017 18:13:46 +0000 (18:13 +0000)] 
Typo fixes in comment.  No changes to code.

FossilOrigin-Name: c09dd5c0befaf5028abfead8114bd74a30ffe5d4

8 years agoAlways invoke the xRoundup() method of the memory allocator before calling
drh [Wed, 8 Feb 2017 16:01:57 +0000 (16:01 +0000)] 
Always invoke the xRoundup() method of the memory allocator before calling
xMalloc().

FossilOrigin-Name: 77b470b0df73dc5ae5ad2f0170ef7c50558c7c88

8 years agoRound up the size of all memory allocations to a multiple of 8 bytes when
drh [Wed, 8 Feb 2017 12:18:05 +0000 (12:18 +0000)] 
Round up the size of all memory allocations to a multiple of 8 bytes when
using the system memory allocator.

FossilOrigin-Name: c46e06fab4465128ac3364bafef5fa3d016796d0

8 years agoWhen generating the hash on the sqlite_master table in dbselftest, use an
drh [Tue, 7 Feb 2017 21:44:40 +0000 (21:44 +0000)] 
When generating the hash on the sqlite_master table in dbselftest, use an
ORDER BY clause, since the sqlite_master table is reordered by VACUUM.

FossilOrigin-Name: c8bfd99b96608a08f934f46b4e1a4d0f1cc69ea7

8 years agoMSVC makefile enhancments for several command line tools and the session extensions.
mistachkin [Tue, 7 Feb 2017 21:09:34 +0000 (21:09 +0000)] 
MSVC makefile enhancments for several command line tools and the session extensions.

FossilOrigin-Name: fc1dfe870279531d77ffb18a9ca4b4dcbc7aab8d

8 years agoFix harmless compiler warnings in dbfuzz.
drh [Tue, 7 Feb 2017 21:00:44 +0000 (21:00 +0000)] 
Fix harmless compiler warnings in dbfuzz.

FossilOrigin-Name: 61242267824135a9d5438ec15e3352a2f21dc2fc

8 years agoFix harmless compiler warnings in kvtest.c
drh [Tue, 7 Feb 2017 20:57:00 +0000 (20:57 +0000)] 
Fix harmless compiler warnings in kvtest.c

FossilOrigin-Name: db6b39937dd9d6fcd5fcc582c8dd529caad755da

8 years agoThe dbselftest utility now generates hashes in the selftest table with --init.
drh [Tue, 7 Feb 2017 20:51:38 +0000 (20:51 +0000)] 
The dbselftest utility now generates hashes in the selftest table with --init.
It also accepts multiple database files on the command-line.

FossilOrigin-Name: e68829c9bbc69bf4a0dc057e0a6e977f2fac79be

8 years agoOmit fts5fault1.test from the inmemory_journal permutation.
dan [Tue, 7 Feb 2017 19:36:14 +0000 (19:36 +0000)] 
Omit fts5fault1.test from the inmemory_journal permutation.

FossilOrigin-Name: cb1e83f9583bf93ce7583d9f5e97272e2d43cfb8

8 years agoUpdate a test parameter in malloc5.test to account for the increase in default
dan [Tue, 7 Feb 2017 19:23:51 +0000 (19:23 +0000)] 
Update a test parameter in malloc5.test to account for the increase in default
lookaside buffer size.

FossilOrigin-Name: be82d5ae20ba62a165bdc28766a8dc8049abcac6

8 years agoAdd the initial version of the "dbselftest" utility program.
drh [Tue, 7 Feb 2017 17:36:12 +0000 (17:36 +0000)] 
Add the initial version of the "dbselftest" utility program.

FossilOrigin-Name: 1fcac8365e0f7bcfd55442d718da6626c864d45a

8 years agoUpdate an error message in corruptC.test.
dan [Tue, 7 Feb 2017 16:15:48 +0000 (16:15 +0000)] 
Update an error message in corruptC.test.

FossilOrigin-Name: 722e57fe61162a82b8001c7b1d3e06174caa90b9

8 years agoFix a build problem affecting non-amalgamation rtree builds.
dan [Tue, 7 Feb 2017 14:45:18 +0000 (14:45 +0000)] 
Fix a build problem affecting non-amalgamation rtree builds.

FossilOrigin-Name: bb7f445ba1df53cd4a169612b18fc533016102b7

8 years agoFix a test case to account for the fact that sqlite3_blob_reopen() now returns
dan [Tue, 7 Feb 2017 14:22:39 +0000 (14:22 +0000)] 
Fix a test case to account for the fact that sqlite3_blob_reopen() now returns
SQLITE_IOERR_NOMEM instead of SQLITE_NOMEM if an OOM occurs in the VFS layer.

FossilOrigin-Name: e11cc52389f61f6421179281877b119c02286121

8 years agoFix SQLITE_BYTEORDER #defines in R-Tree when compiled separately from the
drh [Tue, 7 Feb 2017 13:51:48 +0000 (13:51 +0000)] 
Fix SQLITE_BYTEORDER #defines in R-Tree when compiled separately from the
amalgamation.

FossilOrigin-Name: a136609c98ed3cc673c5a3c2578d49db3f2518d1

8 years agoMake the cellMargin() routine of R-Tree slightly smaller and faster while also
drh [Tue, 7 Feb 2017 12:58:38 +0000 (12:58 +0000)] 
Make the cellMargin() routine of R-Tree slightly smaller and faster while also
fixing a harmless compiler warning.

FossilOrigin-Name: 07fe6228208684d579c4f6c334c90eb6262a9233

8 years agoBack out [ec8ff892ac] which is causing missed OOM errors on some tests.
drh [Tue, 7 Feb 2017 03:44:42 +0000 (03:44 +0000)] 
Back out [ec8ff892ac] which is causing missed OOM errors on some tests.

FossilOrigin-Name: 0611770d6a2fcb9fa0bedee19df9916820ae8f3b

8 years agoFix a minor typo in a comment in R-Tree. No changes to code.
drh [Tue, 7 Feb 2017 00:55:47 +0000 (00:55 +0000)] 
Fix a minor typo in a comment in R-Tree.  No changes to code.

FossilOrigin-Name: f77ee9e941f22b0b2e88871df4466fdde9cde131

8 years agoRemove a small amount of unnecessary code from R-Tree.
drh [Mon, 6 Feb 2017 16:52:32 +0000 (16:52 +0000)] 
Remove a small amount of unnecessary code from R-Tree.

FossilOrigin-Name: e5aea894267addb4dc9b21de24a20417b0be508a

8 years agoAdd the "max-limits" utility program to the tools/ subdirectory.
drh [Mon, 6 Feb 2017 15:27:44 +0000 (15:27 +0000)] 
Add the "max-limits" utility program to the tools/ subdirectory.

FossilOrigin-Name: c54173b6c1acbb41ed9c323099e94b8e02c6c895

8 years agoFix a bug in kvtest causing "init --variance 0" runs to generate single byte
dan [Mon, 6 Feb 2017 07:37:50 +0000 (07:37 +0000)] 
Fix a bug in kvtest causing "init --variance 0" runs to generate single byte
blob values only.

FossilOrigin-Name: 6b0276f968d3c6430076c6e540907cf840d0f398

8 years agoRemove incorrect testcase() macros from R-Tree.
drh [Mon, 6 Feb 2017 01:19:07 +0000 (01:19 +0000)] 
Remove incorrect testcase() macros from R-Tree.

FossilOrigin-Name: 853a58a75ecbd01ebbf7e07fbd8c4fc9bef54a99

8 years agoSimplification to the error handling to extension loading in
drh [Sat, 4 Feb 2017 20:15:51 +0000 (20:15 +0000)] 
Simplification to the error handling to extension loading in
sqlite3_open().

FossilOrigin-Name: ec8ff892ac9c6a8f81bcf69f1933f4bb69faa743

8 years agoAllow sqlite3session_apply() to apply changesets to tables that have been
dan [Sat, 4 Feb 2017 17:33:30 +0000 (17:33 +0000)] 
Allow sqlite3session_apply() to apply changesets to tables that have been
extended using ALTER TABLE ADD COLUMN.

FossilOrigin-Name: b20ff81ff9c8af500ea96e0ba9d34524220a89f1

8 years agoIn RTREE, use an sqlite3_blob object rather than an sqlite3_stmt object
drh [Sat, 4 Feb 2017 14:24:05 +0000 (14:24 +0000)] 
In RTREE, use an sqlite3_blob object rather than an sqlite3_stmt object
for reading content out of the %_node shadow table.

FossilOrigin-Name: 97ccf3e4de11ffea46993cb7fb7ab559b9810705

8 years agoClose sqlite3_blob objects on xSync rather than waiting until xCommit. rtree-blob-agressive-release
drh [Sat, 4 Feb 2017 13:12:12 +0000 (13:12 +0000)] 
Close sqlite3_blob objects on xSync rather than waiting until xCommit.

FossilOrigin-Name: 95ee745fceb4a48c683f34c404c380fe5e7d684a

8 years agoImproved performance and stack usage when processing VALUES clauses with
drh [Fri, 3 Feb 2017 20:54:57 +0000 (20:54 +0000)] 
Improved performance and stack usage when processing VALUES clauses with
a very large number of rows.

FossilOrigin-Name: 5706d4708a30eb54da0ecbb6eb02f54746c390d9

8 years agoAvoid a performance problem when very large "VALUES(..), (..), (..)" terms are recursive-selectdup
dan [Fri, 3 Feb 2017 19:16:39 +0000 (19:16 +0000)] 
Avoid a performance problem when very large "VALUES(..), (..), (..)" terms are
used in queries.

FossilOrigin-Name: f5306ad6816cc377036685cdae227e762885229c

8 years agoImproved tests for the carray() table-valued function.
drh [Fri, 3 Feb 2017 15:16:25 +0000 (15:16 +0000)] 
Improved tests for the carray() table-valued function.

FossilOrigin-Name: 83a099f139aba03edac19c890a0019e922032a25

8 years agoModify the sqlite3SelectDup() routine to avoid recursing on Select.pPrior.
dan [Fri, 3 Feb 2017 14:44:52 +0000 (14:44 +0000)] 
Modify the sqlite3SelectDup() routine to avoid recursing on Select.pPrior.

FossilOrigin-Name: a7674ead5be986c66f7d61d598adc7e5728bcd30

8 years agoEnsure that all cursors have their positions saved prior to rolling back
drh [Thu, 2 Feb 2017 20:32:28 +0000 (20:32 +0000)] 
Ensure that all cursors have their positions saved prior to rolling back
a savepoint.

FossilOrigin-Name: 8e03a8e95fada5c24d369672a71f6e02288051da

8 years agoFix issues in the sha1 extension seen with MSVC.
mistachkin [Thu, 2 Feb 2017 19:24:05 +0000 (19:24 +0000)] 
Fix issues in the sha1 extension seen with MSVC.

FossilOrigin-Name: 5a0da77c22ebc7db5e63b1520d30f3ad97b9bb3b

8 years agoRemove the unused pReadNode prepared statement from each RTREE object.
drh [Thu, 2 Feb 2017 16:30:25 +0000 (16:30 +0000)] 
Remove the unused pReadNode prepared statement from each RTREE object.

FossilOrigin-Name: e51dc0ec60d45cd57564735b6b2bb254a588533e

8 years agoFix a potential uninitialized (though harmless) variable in RTREE.
drh [Thu, 2 Feb 2017 16:08:27 +0000 (16:08 +0000)] 
Fix a potential uninitialized (though harmless) variable in RTREE.

FossilOrigin-Name: a1c74e09d63aca630d022ed074866433eed6b493

8 years agoThe sqlite3_blob_close() interface can cause recursive invocations of
drh [Thu, 2 Feb 2017 15:35:54 +0000 (15:35 +0000)] 
The sqlite3_blob_close() interface can cause recursive invocations of
nodeBlobReset() in RTREE.  Make sure that does not cause problems.

FossilOrigin-Name: 88333441cbf26bfde2acebf2a3f75b5ebbdfb0ae

8 years agoChange RTREE so that the sqlite3_blob object is closed whenever the cursor
drh [Thu, 2 Feb 2017 14:40:06 +0000 (14:40 +0000)] 
Change RTREE so that the sqlite3_blob object is closed whenever the cursor
count drops to zero and there is not a pending write transaction.

FossilOrigin-Name: 9bb4eafe1a60176ed2e731bb7e3067c0b8a46615

8 years agoUse the sqlite3_blob interface for reading values from the %_node shadow
drh [Thu, 2 Feb 2017 02:28:45 +0000 (02:28 +0000)] 
Use the sqlite3_blob interface for reading values from the %_node shadow
table in RTREE.  This is a work in progress.  There are still some minor
problems.

FossilOrigin-Name: fc4917d730b29b0bf60fea5e0166728635783e9c

8 years agoThis is an experimental patch that ensures that all cursors have their position savepoint-rollback
drh [Thu, 2 Feb 2017 00:46:55 +0000 (00:46 +0000)] 
This is an experimental patch that ensures that all cursors have their position
saved prior to starting a ROLLBACK TO.

FossilOrigin-Name: 01d97e5b6502b1811b52a681f445e1aaae6c0ee6

8 years agoFix harmless compiler warnings seen with MSVC.
mistachkin [Wed, 1 Feb 2017 23:06:17 +0000 (23:06 +0000)] 
Fix harmless compiler warnings seen with MSVC.

FossilOrigin-Name: 0c66cf0f0a9ada2ddcb8d61001ef791b86226416

8 years agoBackout the change in [02f6293f27] as it causes MSVC to complain.
mistachkin [Wed, 1 Feb 2017 23:03:54 +0000 (23:03 +0000)] 
Backout the change in [02f6293f27] as it causes MSVC to complain.

FossilOrigin-Name: aaae74d06f4865818465cfdb440258ae8a5b985a

8 years agoFix C99-style variable declaration issue seen with older versions of MSVC.
mistachkin [Wed, 1 Feb 2017 22:59:29 +0000 (22:59 +0000)] 
Fix C99-style variable declaration issue seen with older versions of MSVC.

FossilOrigin-Name: 54d285464a222c59327eb6c917c1cc0125a55a27

8 years agoFix harmless compiler warnings seen with MSVC.
mistachkin [Wed, 1 Feb 2017 22:43:08 +0000 (22:43 +0000)] 
Fix harmless compiler warnings seen with MSVC.

FossilOrigin-Name: 997f765bc6706769ae15f3e719354473e02bd78b

8 years agoAdd an option to the MSVC makefile to enable treating warnings as errors.
mistachkin [Wed, 1 Feb 2017 22:32:49 +0000 (22:32 +0000)] 
Add an option to the MSVC makefile to enable treating warnings as errors.

FossilOrigin-Name: 6a378c29b43d61313ca9daa599e59d8eeeed9a27

8 years agoUnwind the RTREE dimension loop inside of rtreeCallbackConstraint().
drh [Wed, 1 Feb 2017 17:08:56 +0000 (17:08 +0000)] 
Unwind the RTREE dimension loop inside of rtreeCallbackConstraint().

FossilOrigin-Name: 4854ea9c18e7d8066c90b41568d0fae97b01ea6d

8 years agoCompletely unroll the dimension loop inside of cellArea() in RTREE.
drh [Wed, 1 Feb 2017 16:41:30 +0000 (16:41 +0000)] 
Completely unroll the dimension loop inside of cellArea() in RTREE.

FossilOrigin-Name: 3c4c0126c287f844220b65e00fec17c059fbb7c8

8 years agoPrecompute the nDim2 value in the Rtree object and use that to make loops
drh [Wed, 1 Feb 2017 15:49:02 +0000 (15:49 +0000)] 
Precompute the nDim2 value in the Rtree object and use that to make loops
over coordinates faster.

FossilOrigin-Name: f1f3c8cc733a05c12dd980f2dfa0ab4ccd76c04b

8 years agoUse compiler intrinsic functions (when available) for byteswapping in RTREE.
drh [Wed, 1 Feb 2017 15:24:32 +0000 (15:24 +0000)] 
Use compiler intrinsic functions (when available) for byteswapping in RTREE.

FossilOrigin-Name: 82fcd54a5941c20895ffc22d8009c1ebdae44eda

8 years agoFix the build by making the OPFLAG_ISNOOP macro available unconditionally.
drh [Wed, 1 Feb 2017 15:19:29 +0000 (15:19 +0000)] 
Fix the build by making the OPFLAG_ISNOOP macro available unconditionally.

FossilOrigin-Name: 510933cb24c5bf883265af3a6075e60a4b5ffa37

8 years agoUpdate the documentation comment in sqlite.h.in for sqlite3_preupdate_hook().
dan [Wed, 1 Feb 2017 14:19:43 +0000 (14:19 +0000)] 
Update the documentation comment in sqlite.h.in for sqlite3_preupdate_hook().

FossilOrigin-Name: 7f8570208c06c056d426e9299d9930181a0464f8

8 years agoChanges so that the pre-update hook and the sessions module work with WITHOUT
dan [Wed, 1 Feb 2017 14:10:24 +0000 (14:10 +0000)] 
Changes so that the pre-update hook and the sessions module work with WITHOUT
ROWID tables.

FossilOrigin-Name: 964bdc27f8f1b1db2e5c0c2a65c8156614cbe087

8 years agoMore RTREE performance optimizations related to decoding values.
drh [Wed, 1 Feb 2017 02:25:28 +0000 (02:25 +0000)] 
More RTREE performance optimizations related to decoding values.

FossilOrigin-Name: c5395e7496d0cd593f5e16ee5f6719d020dc0c66

8 years agoImproved comments on the statGet() implementation in ANALYZE. No changes
drh [Wed, 1 Feb 2017 01:34:15 +0000 (01:34 +0000)] 
Improved comments on the statGet() implementation in ANALYZE.  No changes
to code.

FossilOrigin-Name: 9663eea2a16bb4eec71476d307a3722a768308c3

8 years agoR-TREE optimization: unwrap the coordinate decode loop in
drh [Tue, 31 Jan 2017 21:22:03 +0000 (21:22 +0000)] 
R-TREE optimization: unwrap the coordinate decode loop in
rtreeCallbackConstraint().

FossilOrigin-Name: 0bf7b51896ec441f62490964c7a44a3c75c6b7e2

8 years agoVery small performance improvements and size reductions in
drh [Tue, 31 Jan 2017 19:10:42 +0000 (19:10 +0000)] 
Very small performance improvements and size reductions in
sqlite3VdbeExec() and blobSeekToRow().

FossilOrigin-Name: 85dddf2b453b8afaf1f485b96084d31e22f97dda

8 years agoSimplifications to blobSeekToRow(). micro-optimizations
drh [Tue, 31 Jan 2017 19:02:15 +0000 (19:02 +0000)] 
Simplifications to blobSeekToRow().

FossilOrigin-Name: 495ea824093ff535734c22c3115384c08f855c02

8 years agoAdd a speed-test program for the sessions module. preupdate-without-rowid
dan [Tue, 31 Jan 2017 17:31:30 +0000 (17:31 +0000)] 
Add a speed-test program for the sessions module.

FossilOrigin-Name: 25f1275fe3e940c1d9a7b013cb3744304b2eda1e

8 years agoRemove a C99-style comment. Fixes to the kvtest-speed.sh script.
drh [Tue, 31 Jan 2017 16:49:01 +0000 (16:49 +0000)] 
Remove a C99-style comment.  Fixes to the kvtest-speed.sh script.

FossilOrigin-Name: 91eb6b628e278d20eccc647293e5b30765163e12

8 years agoRemove another unnecessary local variable initialization from sqlite3VdbeExec()
drh [Tue, 31 Jan 2017 16:43:36 +0000 (16:43 +0000)] 
Remove another unnecessary local variable initialization from sqlite3VdbeExec()

FossilOrigin-Name: 2361b03b61311aab9b9ec9de040bbb73be31be0d

8 years agoRemove an unnecessary initialization of the pOp variable in sqlite3VdbeExec().
drh [Tue, 31 Jan 2017 16:34:51 +0000 (16:34 +0000)] 
Remove an unnecessary initialization of the pOp variable in sqlite3VdbeExec().

FossilOrigin-Name: 02f6293f278f7b0a0f4876f5c6a0f4dc42620d79

8 years agoAdd the "stat" command to kvtest.c. Also add the --variance option to the
drh [Tue, 31 Jan 2017 15:29:05 +0000 (15:29 +0000)] 
Add the "stat" command to kvtest.c.  Also add the --variance option to the
"init" command.  Add the tool/kvtest-speed.sh script used for doing
performance testing on key/value access patterns.

FossilOrigin-Name: b63deed600b1a457a6960ebad5645f4de9c56e5d

8 years agoFix a typo in a comment.
drh [Tue, 31 Jan 2017 15:27:04 +0000 (15:27 +0000)] 
Fix a typo in a comment.

FossilOrigin-Name: bd22bf9cbe028e9811ca3afaadafd90312cb0fc9

8 years agoMerge latest trunk with this branch.
dan [Tue, 31 Jan 2017 14:08:04 +0000 (14:08 +0000)] 
Merge latest trunk with this branch.

FossilOrigin-Name: 4a592abbc555fd3b70979b551b00c2ba631253df

8 years agoFurther minor enhancement and size reduction in
drh [Tue, 31 Jan 2017 12:41:48 +0000 (12:41 +0000)] 
Further minor enhancement and size reduction in
sqlite3ExprAssignVarNumber().

FossilOrigin-Name: eacfdcf25796ea29b5e63499c3d7397498305ad9

8 years agoPerformance optimization in sqlite3ExprAssignVarNumber().
drh [Tue, 31 Jan 2017 03:52:34 +0000 (03:52 +0000)] 
Performance optimization in sqlite3ExprAssignVarNumber().

FossilOrigin-Name: 5987ca1ff94ed3c1666f783bb15b16158aa7e1db

8 years agoExperimental change to invoke the preupdate hook when WITHOUT ROWID tables are
dan [Mon, 30 Jan 2017 19:44:53 +0000 (19:44 +0000)] 
Experimental change to invoke the preupdate hook when WITHOUT ROWID tables are
written.

FossilOrigin-Name: 856f8604c59c8fdd9bfb7d86fc0e212f091ab49a

8 years agoFix building with SQLITE_OMIT_FOREIGN_KEY defined.
dan [Mon, 30 Jan 2017 11:38:19 +0000 (11:38 +0000)] 
Fix building with SQLITE_OMIT_FOREIGN_KEY defined.

FossilOrigin-Name: e93d2c49a44af994ff10cc9cc7eafacd5a4f73ab

8 years agoIn the amalgamation, allocate the parser engine object from stack rather than
drh [Sat, 28 Jan 2017 20:46:37 +0000 (20:46 +0000)] 
In the amalgamation, allocate the parser engine object from stack rather than
from heap, for improved performance.  This only happens in the amalgamation,
since otherwise the sqlite3RunParser() routine does not know the object size.

FossilOrigin-Name: 4fe879d4b5da6ae0688a7a99004683a234966597

8 years agoFix a couple comment typos. No changes to code.
mistachkin [Sat, 28 Jan 2017 19:53:51 +0000 (19:53 +0000)] 
Fix a couple comment typos.  No changes to code.

FossilOrigin-Name: 2a2e7d86b275c970726f642a37a098950a3b906e

8 years agoAvoid redundant table b-tree cursor seeks in UPDATE statements that use the
dan [Sat, 28 Jan 2017 19:45:34 +0000 (19:45 +0000)] 
Avoid redundant table b-tree cursor seeks in UPDATE statements that use the
two-pass strategy.

FossilOrigin-Name: dc555b1039c6930f6d15355c698ff917a85e8056

8 years agoUpdates to the sqlite3_blob documentation. No changes to code.
drh [Sat, 28 Jan 2017 15:26:14 +0000 (15:26 +0000)] 
Updates to the sqlite3_blob documentation.  No changes to code.

FossilOrigin-Name: 426b440a5745f9c431c6a3d9ba542af61a6a83fb

8 years agoIn the speed-check.sh script, automatically invoke "fossil test-diff --tk" on
drh [Sat, 28 Jan 2017 13:40:55 +0000 (13:40 +0000)] 
In the speed-check.sh script, automatically invoke "fossil test-diff --tk" on
the cachegrind output against trunk, if not generating a trunk run.

FossilOrigin-Name: aa1ab37100a91ab4bb91d50a1267c26967efcb21

8 years agoFix a typo in the docs for sqlite3_update_hook().
dan [Sat, 28 Jan 2017 06:50:15 +0000 (06:50 +0000)] 
Fix a typo in the docs for sqlite3_update_hook().

FossilOrigin-Name: 7c029655cc3369a1e46741fdd3701d36d420b28b

8 years agoAdd the sha1.c loadable extension that implements the sha1() and sha1_query()
drh [Fri, 27 Jan 2017 19:27:38 +0000 (19:27 +0000)] 
Add the sha1.c loadable extension that implements the sha1() and sha1_query()
SQL functions.

FossilOrigin-Name: 24e77c1cef163a9822635570b3211789ff23d5c9

8 years agoFix a problem causing the pre-update hook to be invoked by DROP TABLE
dan [Fri, 27 Jan 2017 17:02:26 +0000 (17:02 +0000)] 
Fix a problem causing the pre-update hook to be invoked by DROP TABLE
statements.

FossilOrigin-Name: fbb6bf1b69cfd581b4ffd778c344e3fbd9c9406f

8 years agoAlternative ICU fix (compare to check-in [50e60cb4]) that avoids casting
drh [Fri, 27 Jan 2017 13:14:12 +0000 (13:14 +0000)] 
Alternative ICU fix (compare to check-in [50e60cb4]) that avoids casting
integers to pointers.

FossilOrigin-Name: d9752c8f7c55426fd7d2b877c5cc3784f93b5349

8 years agoIn the command-line shell, enhance the ".mode" command so that it restores the
drh [Fri, 27 Jan 2017 01:52:42 +0000 (01:52 +0000)] 
In the command-line shell, enhance the ".mode" command so that it restores the
default column and row separators for modes "line", "list", "column", and
"tcl".

FossilOrigin-Name: 58f02e6eae8fc9e2577fe435b0282fb46af3960d

8 years agoAnother micro-optimization in accessPayload(). Slightly smaller and faster.
drh [Fri, 27 Jan 2017 01:25:00 +0000 (01:25 +0000)] 
Another micro-optimization in accessPayload().  Slightly smaller and faster.

FossilOrigin-Name: c012619b65d70b4ef6cf33532ef57d7f8ba42d74

8 years agoPerformance optimization in accessPayload().
drh [Fri, 27 Jan 2017 01:13:49 +0000 (01:13 +0000)] 
Performance optimization in accessPayload().

FossilOrigin-Name: ebb1fd98d4e448aa6d8f1e5be7ddc5bedb3db95b

8 years agoSimplify the accessPayload() routine so that it always populates the overflow
drh [Fri, 27 Jan 2017 00:31:59 +0000 (00:31 +0000)] 
Simplify the accessPayload() routine so that it always populates the overflow
page cache.  In the one case where populating the page cache can lead to
problems, simply invalidate the cache as soon as accessPayload() returns.
This simplification reduces code size and helps accessPayload() to run a
little faster.  This backs out the eOp==2 mode of accessPayload() added by
check-in [da59198505].

FossilOrigin-Name: 68e7a8c6765649195ef1ad9407d87d44a307b462