drh
52afa8ff09
Merge the latest trunk changes, especially the RTREE enhancement to use
...
sqlite3_blob objects.
FossilOrigin-Name: 61bd2a885da45e7fa4f02ea1c44d6706faa6bf46
2017-02-04 14:30:57 +00:00
dan
067cd837fb
Avoid a performance problem when very large "VALUES(..), (..), (..)" terms are
...
used in queries.
FossilOrigin-Name: f5306ad6816cc377036685cdae227e762885229c
2017-02-03 19:16:39 +00:00
dan
a7466205ca
Modify the sqlite3SelectDup() routine to avoid recursing on Select.pPrior.
...
FossilOrigin-Name: a7674ead5be986c66f7d61d598adc7e5728bcd30
2017-02-03 14:44:52 +00:00
drh
c5fd65d3f7
Add the sqlite3_blob_reset() interface. Enhance the behavior of sqlite3_blob
...
objects so that they can go active again after encountering an error by
rerunning sqlite3_blob_reopen(). More work needed on the documentation.
FossilOrigin-Name: 53b77838f05b4805b956b5763c75af434662fb20
2017-02-02 23:57:40 +00:00
drh
2343c7eb3f
This is an experimental patch that ensures that all cursors have their position
...
saved prior to starting a ROLLBACK TO.
FossilOrigin-Name: 01d97e5b6502b1811b52a681f445e1aaae6c0ee6
2017-02-02 00:46:55 +00:00
mistachkin
6890d3e458
Fix harmless compiler warnings seen with MSVC.
...
FossilOrigin-Name: 0c66cf0f0a9ada2ddcb8d61001ef791b86226416
2017-02-01 23:06:17 +00:00
mistachkin
5f7b95f73b
Backout the change in [02f6293f27] as it causes MSVC to complain.
...
FossilOrigin-Name: aaae74d06f4865818465cfdb440258ae8a5b985a
2017-02-01 23:03:54 +00:00
mistachkin
2e52532217
Fix harmless compiler warnings seen with MSVC.
...
FossilOrigin-Name: 997f765bc6706769ae15f3e719354473e02bd78b
2017-02-01 22:43:08 +00:00
drh
1650fcb1b5
Fix the build by making the OPFLAG_ISNOOP macro available unconditionally.
...
FossilOrigin-Name: 510933cb24c5bf883265af3a6075e60a4b5ffa37
2017-02-01 15:19:29 +00:00
dan
f6c69221e3
Update the documentation comment in sqlite.h.in for sqlite3_preupdate_hook().
...
FossilOrigin-Name: 7f8570208c06c056d426e9299d9930181a0464f8
2017-02-01 14:19:43 +00:00
dan
f62154d4ac
Changes so that the pre-update hook and the sessions module work with WITHOUT
...
ROWID tables.
FossilOrigin-Name: 964bdc27f8f1b1db2e5c0c2a65c8156614cbe087
2017-02-01 14:10:24 +00:00
drh
35497fccbe
Improved comments on the statGet() implementation in ANALYZE. No changes
...
to code.
FossilOrigin-Name: 9663eea2a16bb4eec71476d307a3722a768308c3
2017-02-01 01:34:15 +00:00
drh
baf5dec700
Simplifications to blobSeekToRow().
...
FossilOrigin-Name: 495ea824093ff535734c22c3115384c08f855c02
2017-01-31 19:02:15 +00:00
drh
0caad09585
Remove a C99-style comment. Fixes to the kvtest-speed.sh script.
...
FossilOrigin-Name: 91eb6b628e278d20eccc647293e5b30765163e12
2017-01-31 16:49:01 +00:00
drh
d59bcbdee7
Remove another unnecessary local variable initialization from sqlite3VdbeExec()
...
FossilOrigin-Name: 2361b03b61311aab9b9ec9de040bbb73be31be0d
2017-01-31 16:43:36 +00:00
drh
78a9e92ecf
Remove an unnecessary initialization of the pOp variable in sqlite3VdbeExec().
...
FossilOrigin-Name: 02f6293f278f7b0a0f4876f5c6a0f4dc42620d79
2017-01-31 16:34:51 +00:00
drh
1379521f4a
Fix a typo in a comment.
...
FossilOrigin-Name: bd22bf9cbe028e9811ca3afaadafd90312cb0fc9
2017-01-31 15:27:04 +00:00
dan
6abc7a6b37
Merge latest trunk with this branch.
...
FossilOrigin-Name: 4a592abbc555fd3b70979b551b00c2ba631253df
2017-01-31 14:08:04 +00:00
drh
8e74e7ba4c
Further minor enhancement and size reduction in
...
sqlite3ExprAssignVarNumber().
FossilOrigin-Name: eacfdcf25796ea29b5e63499c3d7397498305ad9
2017-01-31 12:41:48 +00:00
drh
18814dfb7e
Performance optimization in sqlite3ExprAssignVarNumber().
...
FossilOrigin-Name: 5987ca1ff94ed3c1666f783bb15b16158aa7e1db
2017-01-31 03:52:34 +00:00
dan
cb9a364390
Experimental change to invoke the preupdate hook when WITHOUT ROWID tables are
...
written.
FossilOrigin-Name: 856f8604c59c8fdd9bfb7d86fc0e212f091ab49a
2017-01-30 19:44:53 +00:00
dan
e7eeeb99f7
Fix building with SQLITE_OMIT_FOREIGN_KEY defined.
...
FossilOrigin-Name: e93d2c49a44af994ff10cc9cc7eafacd5a4f73ab
2017-01-30 11:38:19 +00:00
drh
d26cc54183
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
2017-01-28 20:46:37 +00:00
mistachkin
51b15c3871
Fix a couple comment typos. No changes to code.
...
FossilOrigin-Name: 2a2e7d86b275c970726f642a37a098950a3b906e
2017-01-28 19:53:51 +00:00
dan
f64ece143c
Avoid redundant table b-tree cursor seeks in UPDATE statements that use the
...
two-pass strategy.
FossilOrigin-Name: dc555b1039c6930f6d15355c698ff917a85e8056
2017-01-28 19:45:34 +00:00
drh
6034d47618
Updates to the sqlite3_blob documentation. No changes to code.
...
FossilOrigin-Name: 426b440a5745f9c431c6a3d9ba542af61a6a83fb
2017-01-28 15:26:14 +00:00
dan
2d2e4f3895
Fix a typo in the docs for sqlite3_update_hook().
...
FossilOrigin-Name: 7c029655cc3369a1e46741fdd3701d36d420b28b
2017-01-28 06:50:15 +00:00
dan
50133dea28
Fix a problem causing the pre-update hook to be invoked by DROP TABLE
...
statements.
FossilOrigin-Name: fbb6bf1b69cfd581b4ffd778c344e3fbd9c9406f
2017-01-27 17:02:26 +00:00
drh
7aee83b935
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
2017-01-27 01:52:42 +00:00
drh
6ee610bfc0
Another micro-optimization in accessPayload(). Slightly smaller and faster.
...
FossilOrigin-Name: c012619b65d70b4ef6cf33532ef57d7f8ba42d74
2017-01-27 01:25:00 +00:00
drh
cdf360a0d5
Performance optimization in accessPayload().
...
FossilOrigin-Name: ebb1fd98d4e448aa6d8f1e5be7ddc5bedb3db95b
2017-01-27 01:13:49 +00:00
drh
42e28f12a3
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
2017-01-27 00:31:59 +00:00
drh
945b094632
Remove an unreachable branch in the error handling logic for
...
sqlite3BtreePayloadChecked().
FossilOrigin-Name: 293bf3ed7e40745349c83b202b27ed1b48517e1a
2017-01-26 21:30:00 +00:00
drh
b7dab70a92
Improvement to the OP_Permutation opcode to prevent it from using CPU cycles
...
for initialization in prepared statements that do not use that opcode.
FossilOrigin-Name: b4a98f65564a0d9fba2fef95ebd00a39b3e1e572
2017-01-26 18:00:00 +00:00
drh
fae58d51ce
Remove the obsolete lastRowid cache from the sqlite3VdbeExec() for a size
...
reduction and performance improvement.
FossilOrigin-Name: b4803184652e5f4f823c1521412bc480baeb3dbf
2017-01-26 17:26:44 +00:00
drh
d08406477a
Performance optimization in sqlite3VdbeCloseStatement().
...
FossilOrigin-Name: 1e96e5ec1ee617cb5b5cbdc5a2ee79c8cc35821d
2017-01-26 17:11:18 +00:00
drh
83ec2761fa
Performance optimization to sqlite3_blob_read().
...
FossilOrigin-Name: 7459f4b7ed4007d9ec44c3bf0fcba04f5f8540a9
2017-01-26 16:54:47 +00:00
drh
8bb9fd3b45
Minor simplification and performance optimization for Direct Overflow Read.
...
FossilOrigin-Name: 3e96d6efa867b765c8acf1454014b1e71b2e4f21
2017-01-26 16:27:32 +00:00
drh
d930b5cb06
Make SQLITE_DIRECT_OVERFLOW_READ work for in WAL mode as long as the page
...
being read is not in the the -wal file.
FossilOrigin-Name: 9879be1899adf5634f551a2077b15ccb1133e4e3
2017-01-26 02:26:02 +00:00
drh
d447dced96
Trim NULL values off the end of records when the SQLITE_ENABLE_TRIM_NULLS
...
compile-time option is used. Increase the size of the P5 operand to 16 bits.
Fix a problem with short records in the sessions extension.
FossilOrigin-Name: 4801bd59a01dcc11a3eb9e776e7599b36f162d2a
2017-01-25 20:55:11 +00:00
dan
7271d7a19c
Fix another pre-update hook issue, this time in sqlite3preupdate_old().
...
FossilOrigin-Name: c7651d21bfdfd9b8cf04b26e0264bc58c03d247f
2017-01-25 18:53:27 +00:00
dan
2a86c1962c
Fix a problem with the pre-update hook on this branch.
...
FossilOrigin-Name: 6fc4fbfa29cfa795edf32e4a1f2d0eceb3007f68
2017-01-25 17:44:13 +00:00
drh
585ce1923c
Experimental enhancement to automatically trim NULL values from the end of
...
records, for a reduced disk footprint. This change also involves increasing
the P5 operand from 8 to 16 bits.
FossilOrigin-Name: 118ded403b95050b74ae2b03919c43d614094a32
2017-01-25 14:58:27 +00:00
drh
210b0d0eb3
Ensure that sqlite3_blob_reopen() correctly handles short rows.
...
Proposed fix for ticket [e6e962d6b0f06f46e]. Further testing needed.
FossilOrigin-Name: 57d8dad35c2a9ab635e954dce7f3986ae1ca8ed2
2017-01-25 04:41:34 +00:00
drh
6aabff38e9
Optimization: Try to avoid unnecessary btree searching when repositioning
...
a cursor to the next row.
FossilOrigin-Name: ee793d30c1dc1f78f49e6230d17750eceedbd8ed
2017-01-23 16:56:18 +00:00
dan
65c4c0b02d
Add the missing SQLITE_API symbol to test_delete.c (it is not added
...
automatically as this file is not part of the amalgamation).
FossilOrigin-Name: 7a4f512ddf9e7e718389c80930d6268ab598459c
2017-01-23 15:58:09 +00:00
drh
38305ab55f
Fix an uninitialized variable in the command-line shell.
...
FossilOrigin-Name: 06b8001ade62bc59e6ae20f761167a81d85a4272
2017-01-22 16:34:35 +00:00
mistachkin
35f30d3398
Fixes to documentation comments in the public header file.
...
FossilOrigin-Name: 772dcb08f400f20d4dbfb74df39de78da24ee5fd
2017-01-22 02:04:05 +00:00
drh
7f11afaba1
A better implementation of the moveto-neighbor optimization that checks for
...
nearby rows on adjacent pages.
FossilOrigin-Name: 2c4ecb85a475b9063aa8a3bb517ac181a7ded649
2017-01-21 21:47:54 +00:00
drh
451e76d5b5
B-tree optimization: When seeking on a rowid table that has already been
...
positioned, check to see if the new row happens to be the next row on the
same leaf page. That is a reasonably common case, and if it is true it
avoids a full binary search.
FossilOrigin-Name: 8e5cfb2039126da7689c4b1c88760f10e1234eaf
2017-01-21 16:54:19 +00:00
