/ All files named "src/vdbeInt.h"
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for src/vdbeInt.h

2020-11-26
17:54
[3ba661b0] part of check-in [d2de81a2] Merge latest changes from begin-concurrent-pnu into this branch. (check-in: [d2de81a2] user: dan branch: begin-concurrent-report, size: 27049)
2020-09-01
02:02
[1a928793] part of check-in [49b7631e] Improvements to the IN-early-out optimization so that it works more efficiently when there are two or more indexed IN clauses on a single table. (check-in: [49b7631e] user: drh branch: branch-3.28, size: 26507)
01:52
[3ca5e9fd] part of check-in [35505c68] Improvements to the IN-early-out optimization so that it works more efficiently when there are two or more indexed IN clauses on a single table. (check-in: [35505c68] user: drh branch: trunk, size: 26984)
2020-08-31
19:19
[541b6b9c] part of check-in [8301da31] An attempt to improve the performance of the IN-early-out optimization (see check-in [09fffbdf9f2f6ce3]) by avoiding unnecessary calls to the b-tree search algorithm in OP_IfNoHope when the index key is at hand and the same answer can be obtained by doing a quick key comparison. Update: Experiment did not work out. (check-in: [8301da31] user: drh branch: branch-3.28-in-early-out-fail, size: 26507)
16:31
[43341faf] part of check-in [e9d983c6] An attempt to improve the performance of the IN-early-out optimization (see check-in [09fffbdf9f2f6ce3]) by avoiding unnecessary calls to the b-tree search algorithm in OP_IfNoHope when the index key is at hand and the same answer can be obtained by doing a quick key comparison. Update 2020-08-31: This experiment did not work out. A better approach is now on trunk. (check-in: [e9d983c6] user: drh branch: in-early-out-fail, size: 26984)
2020-08-17
21:03
[f8dbb92c] part of check-in [0ecda433] When doing an UPDATE or DELETE using a multi-column index where only a few of the earlier columns of the index are useful for the index lookup, postpone doing the main table seek until after all WHERE clause constraints have been evaluated, in case those constraints can be covered by unused later terms of the index, thus avoiding unnecessary main table seeks. (check-in: [0ecda433] user: dan branch: branch-3.28, size: 26507)
2020-07-30
19:56
[808c4243] part of check-in [fd01e788] Merge begin-concurrent-pnu changes into this branch. (check-in: [fd01e788] user: dan branch: begin-concurrent-report, size: 27049)
2020-07-22
13:38
[762abffb] part of check-in [9ce1710a] Continuing work toward supporting unsigned 32-bit page numbers. (check-in: [9ce1710a] user: drh branch: larger-databases, size: 26984)
2020-07-17
11:07
[33b6a8e5] part of check-in [12a909fb] Bring this branch up to date with begin-concurrent-pnu. (check-in: [12a909fb] user: dan branch: begin-concurrent-report, size: 27049)
2020-04-02
13:08
[57141306] part of check-in [949eec25] Fix another harmless compiler warning. (check-in: [949eec25] user: drh branch: bytecode-function, size: 26984)
12:53
[01250089] part of check-in [cc54de35] Add a missing #ifdef to avoid a harmless compiler warning. (check-in: [cc54de35] user: drh branch: bytecode-function, size: 26983)
2020-03-23
20:58
[5f36e226] part of check-in [6819b86e] The bytecode() function now runs and sometimes works, but it untested and there are known problems. (check-in: [6819b86e] user: drh branch: bytecode-function, size: 26933)
17:24
[198e552a] part of check-in [2c4dd79f] Begin breaking appear the sqlite3VdbeList() routine into subroutines that can be reused by the bytecode() table. (check-in: [2c4dd79f] user: drh branch: bytecode-function, size: 26646)
2020-03-21
15:07
[0b728ee6] part of check-in [0d4d3c64] Change a bitfield in sqlite3_stmt into an unsigned character, for slightly smaller code and better performance. (check-in: [0d4d3c64] user: drh branch: trunk, size: 26588)
03:40
[37a1cb66] part of check-in [62aece66] Back out the sqlite3_stmt_mode() and EXPLAIN TABLES enhancements, but keep the other miscellaneous improvements to EXPLAIN that were implemented while adding the above: Turn magic numbers into symbolic constants. Add the sqlite3MemPrint() interface accessible to the debugger. Improve the performance and reduce the code size. (check-in: [62aece66] user: drh branch: explain-improvements, size: 26863)
2020-03-20
16:13
[1a8807b7] part of check-in [e9e17e21] Revamp the EXPLAIN infrastructure to facilitate sqlite3_stmt_mode(). The currently code mostly works, but there are test failures. This is an incremental check-in. (check-in: [e9e17e21] user: drh branch: sqlite3_stmt_mode, size: 26780)
2020-03-19
21:17
[a341e699] part of check-in [3cf7537b] Initial code for a proposed new sqlite3_stmt_mode() API. This is an incomplete snapshot of a work-in-progress. (check-in: [3cf7537b] user: drh branch: sqlite3_stmt_mode, size: 26728)
2020-03-06
20:51
[2e37b8fa] part of check-in [1c1f180e] Enhancement to log logical writes as well as reads. (check-in: [1c1f180e] user: dan branch: begin-concurrent-report, size: 26594)
2020-02-05
18:28
[a1714605] part of check-in [ae6dd8d3] Small size reduction and performance improvement in the sqlite3VdbeMemFromBtree() interface used to pull content out of the b-tree and into an sqlite3_value object. (check-in: [ae6dd8d3] user: drh branch: trunk, size: 26588)
2020-01-06
19:23
[30d3e8b9] part of check-in [69f6a7e4] Rewrite the (debugging use only) sqlite3VdbeMemPrettyPrint() function to use the safer StrAccum interface rather than writing directly into a static string buffer. Perhaps this will address ticket [bbd55a97e66ff50d], which we are unable to reproduce. (check-in: [69f6a7e4] user: drh branch: trunk, size: 26529)
2019-12-29
00:52
[e02ccac0] part of check-in [21ef6e99] Add the OP_FinishSeek opcode which completes an OP_DeferredSeek if the seek has not already completed. Also add the sqlite3WhereUsesDeferredSeek() interface to the query planner. The UPDATE implementation adds an OP_FinishSeek before running the final OP_Insert if one is needed. Ticket [ec8abb025e78f40c] and also an assertion fault reported by Yongheng. (check-in: [21ef6e99] user: drh branch: trunk, size: 26525)
2019-12-23
03:37
[1ccaf470] part of check-in [f347744e] Fix the OP_Cast operator so that when casting to TEXT, it always leaves the result in the encoding of the database. Ticket [0911b5d161b039c6]. Test cases in TH3. (check-in: [f347744e] user: drh branch: trunk, size: 26467)
2019-10-07
13:26
[bd589b8b] part of check-in [69a26ead] Fix a faulty assert() statement in the sqlite3VdbeMemExpandBlob() routine. (check-in: [69a26ead] user: drh branch: trunk, size: 26468)
2019-08-08
15:24
[e95de512] part of check-in [1e17ea2f] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 26447)
2019-07-11
19:22
[889c5227] part of check-in [d837ab0d] Move the sqlite3VdbeSerialType() routine in-line in the OP_MakeRecord opcode. Optimizing compilers were doing this already. By doing it manually, we can omit some redundant tests and make the whole thing run a million cycles faster and use about 80 bytes less code space. (check-in: [d837ab0d] user: drh branch: trunk, size: 26534)
2019-05-02
17:45
[3ba14553] part of check-in [48889530] Ensure that the typeof() function always returns SQLITE_FLOAT for floating point values even when the value is stored as an integer to save space. (check-in: [48889530] user: drh branch: trunk, size: 26491)
2019-05-01
18:59
[0e2c4495] part of check-in [5997d075] When values have real affinity and are converted into strings for CHECK constraints or index expressions, do the conversions into a real-number format even if the values are stored as integers for efficiency. This appears to fix ticket [ae0f637bddc5290b446]. (check-in: [5997d075] user: drh branch: trunk, size: 26491)
2019-04-26
17:20
[a9089cdf] part of check-in [1b25fa10] An experimental interface for retrieving the estimated cost and estimated number of output rows for a query. (check-in: [1b25fa10] user: drh branch: cost-est, size: 26590)
2019-04-07
18:04
[2c12704d] part of check-in [df58774e] Fix a faulty assert() in the sqlite3VdbeMemExpandBlob() routine. (check-in: [df58774e] user: drh branch: trunk, size: 26449)
2019-04-02
00:56
[d0c78ec6] part of check-in [f7ba2daf] Make sure the MEM_FromBind bit inthe Mem.flags field is not included in the MEM_TypeMask. This critical changes was omitted from the previous two check-ins by mistake, and so those check-ins are not fully functional. (check-in: [f7ba2daf] user: drh branch: trunk, size: 26307)
2019-03-29
11:13
[5ea6f654] part of check-in [98da62df] Initial implementation of the sqlite3_value_frombind() interface. (check-in: [98da62df] user: drh branch: value_frombind, size: 26307)
2018-12-28
20:48
[a76d5eed] part of check-in [891f1f72] Faster allocation of new sqlite3_stmt objects. (check-in: [891f1f72] user: drh branch: trunk, size: 26267)
20:14
[24975074] part of check-in [8f10efc2] Move the nOpAlloc field from Parse into Vdbe to avoid an extra pointer deference on the fast path in sqlite3VdbeAddOp3(). (check-in: [8f10efc2] user: drh branch: trunk, size: 26267)
2018-12-19
17:05
[e5080801] part of check-in [553a923c] Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. Cherrypick from commit [8201f4e1] on branch-3.18. (check-in: [553a923c] user: dan branch: branch-3.19, size: 24443)
16:03
[b4c31fcd] part of check-in [4cb67252] Add interfaces sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer() used to safely move pointer values through SQL without exposing underlying memory address information. Cherrypick from commit [8201f4e1] on branch-3.18. (check-in: [4cb67252] user: dan branch: branch-3.9, size: 22713)
2018-12-14
21:58
[fad23d9a] part of check-in [33a1924e] Experimental support for new sqlite3_bind_blob() and sqlite3_bind_text() interfaces that take an extra void* argument that is passed into the destructor in front of the object that is to be destroyed. (check-in: [33a1924e] user: drh branch: custom-destructors, size: 26272)
20:20
[538f6a69] part of check-in [b29e02f8] Add the OP_ColumnsUsed opcode (when compiled with SQLITE_ENABLE_COLUMN_USED_MASK) as a hint to the b-tree layer as to which columns of a btree cursor will be used. (Backport from 3.8.11) (check-in: [b29e02f8] user: drh branch: branch-3.8.9, size: 22370)
2018-12-07
16:32
[73f50519] part of check-in [0d8e1504] Fix the sqlite3_normalized_sql() interface so that it renders double-quoted string literals as "?". (check-in: [0d8e1504] user: drh branch: trunk, size: 26209)
2018-11-17
18:45
[edfb25fc] part of check-in [9fdd1868] Merge latest trunk changes into this branch. (check-in: [9fdd1868] user: dan branch: reuse-schema1, size: 25515)
14:26
[437e6c6a] part of check-in [5fff00b0] Fix harmless compiler warnings that appear with SQLITE_OMIT_EXPLAIN. (check-in: [5fff00b0] user: drh branch: trunk, size: 25457)
2018-11-15
21:20
[f7ffb424] part of check-in [31b6aee7] Fix some problems with the feature on this branch. Many problems remain. (check-in: [31b6aee7] user: dan branch: reuse-schema1, size: 25445)
2018-10-29
17:53
[8a52b8db] part of check-in [592b66e8] Add the sqlite3_normalized_sql() API. (check-in: [592b66e8] user: mistachkin branch: normalized_sql, size: 25387)
2018-08-29
20:24
[f1f35f70] part of check-in [f48e9feb] Also free up the MEM_RowSet bit in the Mem.flags field and have RowSet objects be destroyed using Mem.xDel. This change results in faster code. (check-in: [f48e9feb] user: drh branch: trunk, size: 25271)
18:47
[a660268d] part of check-in [62db5fd4] Free up the MEM_Frame bit in Mem.flags object. Store VdbeFrame objects as MEM_Blob with a special Mem.xDel pointer instead. (check-in: [62db5fd4] user: drh branch: trunk, size: 25307)
2018-08-04
16:54
[8ea493d9] part of check-in [80236e81] Remove more column-cache residue: The OP_SetColTab and OP_VerifyColTab opcodes and the associated SQLITE_DEBUG_COLUMNCACHE logic. (check-in: [80236e81] user: drh branch: omit-column-cache, size: 24962)
2018-07-24
22:02
[2a45270d] part of check-in [2bd59333] Do not abort running queries due to a CREATE INDEX statement. Allow them to run to completion before being reprepared. Fix for ticket [c694113e50321afdf9]. (check-in: [2bd59333] user: drh branch: trunk, size: 25152)
2018-06-22
20:51
[6b5cbd33] part of check-in [5f04b016] Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. (check-in: [5f04b016] user: dan branch: exp-window-functions, size: 25142)
2018-06-14
14:30
[d99f1c3d] part of check-in [5cf5f180] Merge latest trunk changes into this branch. (check-in: [5cf5f180] user: dan branch: exp-window-functions, size: 25104)
2018-06-13
16:52
[5d6f9294] part of check-in [f76dc33b] Pad out the sqlite3_value structure to be a multiple of 8 bytes. (check-in: [f76dc33b] user: drh branch: trunk, size: 25054)
2018-06-12
13:52
[4531c172] part of check-in [b2973f23] Improvements to SCopy correctness tracking when SQLITE_DEBUG is enabled. (check-in: [b2973f23] user: drh branch: trunk, size: 24981)
2018-06-11
17:35
[8ebc37ea] part of check-in [b37614a3] Add the OP_SetTabCol and OP_VerifyTabCol opcodes, only when compiling with SQLITE_DEBUG, to do run-time verification of the column cache. (check-in: [b37614a3] user: drh branch: trunk, size: 24973)
2018-06-07
20:35
[83fefe12] part of check-in [25102203] Merge latest trunk changes with this branch. (check-in: [25102203] user: dan branch: exp-window-functions, size: 25006)
2018-06-05
20:45
[d299d7a1] part of check-in [6bf251af] Add the OP_IfNoHope and OP_SeekHit opcodes used to reduce the number of unnecessary sqlite3BtreeMovetoUnpacked() calls when checking for an early exit on IN-operator loops. Futher optimizations are likely possible here. (check-in: [6bf251af] user: drh branch: multikey-opt-idea, size: 24956)
2018-06-04
08:28
[16884542] part of check-in [83d6416a] Merge latest trunk changes into this branch. (check-in: [83d6416a] user: dan branch: exp-window-functions, size: 24931)
2018-05-28
17:31
[42d3e65e] part of check-in [5a4542db] When compiling with SQLITE_DEBUG, add run-time checks to ensure that no statement aborts unless either there have been no writes or else there is a statement journal. (check-in: [5a4542db] user: drh branch: stmt-journal-testing, size: 24881)
2018-05-16
20:58
[3878856f] part of check-in [3781e520] Start of experimental implementation of SQL window functions. Does not yet work. (check-in: [3781e520] user: dan branch: exp-window-functions, size: 24640)
2018-02-26
15:27
[95f7adfd] part of check-in [a983fa85] Always interpret non-zero floating-point values as true even if their integer part is zero. Fix for ticket [36fae083b450e3af857a459e20]. (check-in: [a983fa85] user: drh branch: trunk, size: 24590)
2018-01-23
03:44
[8d7d07f1] part of check-in [edd4e687] Slightly faster function dispatch in the virtual machine by avoiding unnecessary reinitialization of variables that are already correctly initialized. (check-in: [edd4e687] user: drh branch: trunk, size: 24543)
2018-01-16
21:05
[c8cfbbc2] part of check-in [948a26b5] Remove an unused field from the internal definition of the sqlite3_context object. (check-in: [948a26b5] user: drh branch: trunk, size: 24729)
2018-01-12
21:00
[5442fc81] part of check-in [8b7be15e] Add the experimental sqlite3_value_nochange() interface usable by xUpdate methods of virtual tables to see if a column has actually changed values. (check-in: [8b7be15e] user: drh branch: sqlite3_value_nochange, size: 24808)
2018-01-11
17:04
[a0969c14] part of check-in [d444b1ff] Add the sqlite3_vtab_nochange() method which virtual table implementations can use to optimize UPDATEs. (check-in: [d444b1ff] user: drh branch: sqlite3_vtab_nochange, size: 24693)
2017-09-13
18:38
[207b6ac7] part of check-in [ebada072] Experimental sqlite3_stmt_retryable() interface. (check-in: [ebada072] user: drh branch: sqlite3_stmt_retryable, size: 24692)
2017-08-16
19:20
[1fe00770] part of check-in [f078deb2] Avoid a test for CURTYPE_BTREE in sqlite3VdbeCursorMoveto() in order to reduce the size and improve the performance of OP_Column. (check-in: [f078deb2] user: drh branch: trunk, size: 24614)
2017-07-27
15:53
[ff2b7db0] part of check-in [601ad679] Improved implementation of the destructor on pointer-passing interfaces. (check-in: [601ad679] user: drh branch: pointer-with-destructor, size: 24589)
03:48
[4f703405] part of check-in [3d9e841f] Add a destructor argument to sqlite3_bind_pointer() and sqlite3_result_pointer(). (check-in: [3d9e841f] user: drh branch: pointer-with-destructor, size: 24708)
2017-07-21
07:56
[b8770095] part of check-in [8201f4e1] Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This changes is a cherry-pick of [f0f49224] via [69906880cee] and is ultimately inspired by check-in [72de49f2]. (check-in: [8201f4e1] user: drh branch: branch-3.18, size: 24433)
07:45
[7209dc72] part of check-in [69906880] Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This changes is a cherry-pick of [f0f49224] with version-specific edits. That check-in was inspired by check-in [72de49f2]. (check-in: [69906880] user: drh branch: branch-3.9.2, size: 22713)
04:08
[7738dd1d] part of check-in [5a3022e0] Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This is a cherry-pick of [f0f49224] which was in turn inspired by [72de49f2]. (check-in: [5a3022e0] user: drh branch: branch-3.8.10, size: 22252)
03:23
[0d54df38] part of check-in [a66a5b39] Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This is a cherry-pick of [f0f492245e95], which is in turn inspired by check-in [72de49f2]. (check-in: [a66a5b39] user: drh branch: branch-3.8.6, size: 21325)
03:09
[0fb63a81] part of check-in [f0f49224] Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This changes is inspired by check-in [72de49f2] but is new implementation, not a cherry-pick. (check-in: [f0f49224] user: drh branch: branch-3.7.11, size: 21320)
2017-07-20
16:55
[e202dc9f] part of check-in [10556ee4] Experimental API sqlite3_stmt_refresh() to force a prepared statement to recompile if it needs to due to a schema change or other factor. (check-in: [10556ee4] user: drh branch: sqlite3_stmt_refresh, size: 24519)
2017-07-17
00:40
[19bd04a4] part of check-in [211cce04] Add an experimental "pointer type" parameter to sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer(). The pointer type is a string that must compare equal using strcmp() or else the pointer comes through as a NULL. (check-in: [211cce04] user: drh branch: pointer-types, size: 24444)
2017-07-15
10:44
[8912bdbc] part of check-in [d6a44b35] Add new interfaces sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer() used to safely move pointer values through SQL without exposing underlying memory address information. (check-in: [d6a44b35] user: drh branch: branch-3.17, size: 24347)
2017-07-13
17:34
[36b162cc] part of check-in [a54be6e0] Merge the latest changes from trunk. (check-in: [a54be6e0] user: drh branch: bind-pointer, size: 24431)
2017-07-12
12:19
[c8b3d970] part of check-in [783100b8] Compile cleanly with SQLITE_OMIT_UTF16. (check-in: [783100b8] user: drh branch: trunk, size: 24312)
2017-07-05
16:20
[d9637010] part of check-in [fcbd6abd] Make use of covering indexes in the OR optimization. (check-in: [fcbd6abd] user: drh branch: branch-3.8.9, size: 22371)
2017-06-30
23:09
[7420cd23] part of check-in [d9f4a831] Add APIs for binding pointers that can be used by app-defined functions. (check-in: [d9f4a831] user: drh branch: bind-pointer, size: 24394)
2017-06-29
15:24
[8dd7548d] part of check-in [03977248] Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as one bit in that argument. Use the new option in FTS3, FTS5, and RTREE. (check-in: [03977248] user: drh branch: trunk, size: 24275)
12:49
[a2d03f8b] part of check-in [b0b0c8f8] Add the SQLITE_STMTSTATUS_REPREPARE and SQLITE_STMTSTATUS_RUN options to sqlite3_stmt_status(). Use this for two new columns in the stmts virtual table. (check-in: [b0b0c8f8] user: drh branch: stmts-vtab, size: 24287)
2017-06-01
00:54
[ba7a9436] part of check-in [4a25c588] Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as one bit in that argument. (check-in: [4a25c588] user: drh branch: prepare_v3, size: 24275)
2017-05-30
18:34
[cdcdabad] part of check-in [e972a386] Change sqlite3BtreeNext() and sqlite3BtreePrevious() so that they return SQLITE_DONE if they have already reached the end (or beginning) of the table. This gives a performance increase and size reduction. (check-in: [e972a386] user: drh branch: trunk, size: 24287)
2017-05-10
19:42
[1ecdacc1] part of check-in [2be9850c] Rename fields of the internal AuxData object to make them unique and easier to search for. (check-in: [2be9850c] user: drh branch: trunk, size: 24294)
2017-04-09
19:23
[c070bc5c] part of check-in [19dd753f] Do not expose the name of the internal Mem object in the public interface defined by sqlite3.h. (check-in: [19dd753f] user: drh branch: trunk, size: 24294)
2017-03-24
17:59
[5db089ce] part of check-in [25560145] Fix the OP_Once opcode so that it works correctly for recursive triggers. Ticket [06796225f59c057cd120f1]. (check-in: [25560145] user: drh branch: trunk, size: 24284)
2017-02-18
20:05
[6186ba2b] part of check-in [c1adf959] Add an optimization to OP_Column to speed up sequential OP_Column instructions that read earlier fields from the same cursor. Attempt to reorder OP_Column opcodes so as to take advantage of this. (check-in: [c1adf959] user: dan branch: sort-column-opcodes, size: 24294)
2017-01-30
19:44
[4e4b15b2] part of check-in [856f8604] Experimental change to invoke the preupdate hook when WITHOUT ROWID tables are written. (check-in: [856f8604] user: dan branch: preupdate-without-rowid, size: 24228)
2017-01-21
15:58
[4cad10b6] part of check-in [ffda1d1e] Add extra (somewhat inefficient) trace callbacks for triggers if SQLITE_TRACE_TRIGGER is defined. (check-in: [ffda1d1e] user: dan branch: trigger-trace, size: 24319)
2016-12-23
03:59
[281cb703] part of check-in [68ecafa1] Use the VList object to replace Parse.azVar for tracking the mapping between SQL parameter names and parameter numbers. There is a performance improvement, though there are still a few hiccups in the current code. (check-in: [68ecafa1] user: drh branch: VList, size: 24154)
2016-12-10
12:58
[42e498db] part of check-in [8165f88b] Reorder the fields in the VdbeCursor object so that those that need to be bulk zeroed on allocation are grouped at the beginning, and the memset() only runs over those fields that really need it. (check-in: [8165f88b] user: drh branch: trunk, size: 24215)
2016-11-25
19:18
[9b498d3c] part of check-in [49ebc219] Refactor the sqlite3BtreeKey() and sqlite3BtreeData() internal interfaces into sqlite3BtreePayload() and sqlite3BtreePayloadChecked(), respectively. This is a continuation of the optimization started by check-in [2d831074cf]. The result is a slightly smaller and faster binary. (check-in: [49ebc219] user: drh branch: trunk, size: 24131)
2016-11-09
20:14
[29b25318] part of check-in [345b46be] Comment changes that attempt to better explain the behavior of the "seekResult" field on VdbeCursor objects and the seekResult parameter to sqlite3BtreeInsert() and the OPFLAG_USESEEKRESULT flag on insert opcodes. No changes to code. (check-in: [345b46be] user: drh branch: unpacked-IdxInsert, size: 24135)
2016-10-21
21:21
[d8a56a49] part of check-in [b861328a] In the sessions module, avoid recording a change if an UPDATE statement overwrites a column with REAL affinity containing an integer value with the same value. (check-in: [b861328a] user: dan branch: sessions-fix, size: 23905)
2016-10-01
00:37
[0a18713d] part of check-in [1e21bbe8] Avoid unnecessary zeroing of fields in the Vdbe object when it is allocated. (check-in: [1e21bbe8] user: drh branch: trunk, size: 23904)
2016-09-29
15:53
[581b737c] part of check-in [e2cd79aa] Clarification and typo-fixes in comments. No changes to code. (check-in: [e2cd79aa] user: drh branch: trunk, size: 23715)
2016-09-18
16:08
[d21f1472] part of check-in [6bf5ba10] Revise the implementation of OP_Once so that it is smaller, faster, and uses less memory. This also fixes an obscure bug introduced 3 days ago by check-in [5990a1bdb4a073]. (check-in: [6bf5ba10] user: drh branch: trunk, size: 24189)
2016-07-09
16:14
[c5938104] part of check-in [5471aca0] Fix various internal #defines to conform to new C-language naming restrictions, specifically that private-use macros names must not begin with "_". (check-in: [5471aca0] user: drh branch: trunk, size: 24432)
2016-03-30
12:56
[ddb15797] part of check-in [5ab46d76] Avoid compiler warnings and excess opcodes when SQLITE_ENABLE_PREUPDATE_HOOK is not used. Fix the EXPLAIN output for P4_TABLE opcodes. (check-in: [5ab46d76] user: drh branch: sessions, size: 24417)
2016-03-16
01:16
[9b704336] part of check-in [6a7ee04b] Merge all recent enhancements from trunk. (check-in: [6a7ee04b] user: drh branch: sessions, size: 24388)
00:36
[f88d3115] part of check-in [e0b116ed] Rearrange some internal fields in the sqlite3_stmt object to avoid a harmless TSAN warning. (check-in: [e0b116ed] user: drh branch: trunk, size: 23438)
2016-03-04
16:42
[a205ce1e] part of check-in [456df336] Merge recent enhancements from trunk. Default page size is 4096. Writes to statement journals are avoided. (check-in: [456df336] user: drh branch: sessions, size: 24388)
2016-02-26
04:13
[49a74fe5] part of check-in [3ef6a315] Ephemeral tables used to hold manifested views may not be unordered since they might be subject to an ordered comparison if they are part of a join. (check-in: [3ef6a315] user: drh branch: trunk, size: 23438)
2016-02-25
18:54
[177eca5a] part of check-in [b8659004] Merge all the latest changes from trunk. (check-in: [b8659004] user: drh branch: sessions, size: 24395)
2016-02-22
16:04
[84827a80] part of check-in [64386fa3] Always use the sqlite3VdbeDeleteAuxdata() routine for clearing auxdata on function parameter, rather than having a separate deleteAuxdataFromFrame() for doing the job for trigger frames. (check-in: [64386fa3] user: drh branch: trunk, size: 23445)
2016-02-19
18:54
[581e5bff] part of check-in [c4295725] Use a separate list of aux-data structures for each trigger program at the VDBE level. Fix for [dc9b1c91]. (check-in: [c4295725] user: dan branch: trunk, size: 23431)
2016-02-02
02:22
[2a8796b0] part of check-in [f3f92001] Merge all recent enhancements from trunk. (check-in: [f3f92001] user: drh branch: sessions, size: 24314)
2016-01-30
15:46
[4b69d545] part of check-in [2e9fb129] A different way to clear the subtype on VDBE registers when the value of the register is overwritten with new content. To fix [[f45ac567eaa9f93]. (check-in: [2e9fb129] user: dan branch: clear-subtype-flag, size: 23364)
14:53
[6c34fac6] part of check-in [ec653cbc] Take care to clear the subtype on VDBE registers when the value of the register is overwritten with new content. (check-in: [ec653cbc] user: drh branch: clear-subtype-fail, size: 23592)
13:32
[716df83a] part of check-in [85c46704] 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. (check-in: [85c46704] user: drh branch: trunk, size: 23178)
2016-01-29
20:58
[171fdc5f] part of check-in [6e3dcb6d] Different comment on the alternative cursor fields of VdbeCursor. (check-in: [6e3dcb6d] user: drh branch: covering-or, size: 23104)
19:29
[91f22c4d] part of check-in [a323ac3a] Experimental attempt to make better use of covering indexes within OR queries. (check-in: [a323ac3a] user: dan branch: covering-or, size: 23048)
2016-01-27
15:49
[40c72871] part of check-in [dde1db0d] 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. (check-in: [dde1db0d] user: drh branch: fordelete-assert, size: 23021)
2016-01-11
13:10
[1bff4eff] part of check-in [c4a858b2] Merge recent enhancements, and especially the WAL overwrite change, from trunk. (check-in: [c4a858b2] user: drh branch: sessions, size: 23897)
2016-01-07
16:06
[42eefa4f] part of check-in [d0214602] Have the vdbe layer call sqlite3BtreeEnter() on all b-trees in use from within sqlite3VdbeExec() even in SQLITE_THREADSAFE=0 builds. This ensures that BtShared.db is set correctly. (check-in: [d0214602] user: dan branch: shared-cache-fix, size: 22947)
2015-12-17
19:17
[06caadd9] part of check-in [896a06cc] Make the VdbeCursor object even smaller. But the resulting library is bigger and slower than trunk. This branch is a failed experiment. (check-in: [896a06cc] user: drh branch: optimize-vdbecursor, size: 22918)
17:30
[6c879b49] part of check-in [98b710c3] Reduce the size of the VdbeCursor object by a pointer (the pBt pointer used for ephemeral tables). (check-in: [98b710c3] user: drh branch: optimize-vdbecursor, size: 22825)
2015-12-02
20:40
[4f3b4680] part of check-in [d1a1278d] Merge recent enhancements from trunk. (check-in: [d1a1278d] user: drh branch: sessions, size: 23843)
2015-11-20
19:22
[75c2e82e] part of check-in [9b1d174d] Refactor the VdbeCursor object. It is now slightly smaller and faster and is easier to understand. (check-in: [9b1d174d] user: drh branch: trunk, size: 22893)
2015-10-30
16:50
[d6ae6e64] part of check-in [395a153f] Merge all the latest enhancements from trunk. (check-in: [395a153f] user: drh branch: sessions, size: 23855)
2015-10-16
20:53
[33403622] part of check-in [26fa091d] Merge recent enhancements from trunk. Version now 3.9.1. (check-in: [26fa091d] user: drh branch: cursor-hints, size: 22905)
14:54
[777dd76d] part of check-in [2ad72be1] Have the sqlite3VdbeSerialType() function go ahead and compute the serial length as well, since it is always needed. This avoids unnecessary calls to sqlite3VdbeSerialTypeLen(). (check-in: [2ad72be1] user: drh branch: trunk, size: 22610)
14:23
[5f813a19] part of check-in [33957248] Use a lookup table to compute the content length for serial types less than 128, for a 1.2% performance improvement. (check-in: [33957248] user: drh branch: trunk, size: 22604)
2015-09-15
17:31
[c1508eb4] part of check-in [66fe0683] Merge enhancements from trunk. (check-in: [66fe0683] user: drh branch: cursor-hints, size: 22859)
2015-09-14
10:47
[42fa3450] part of check-in [22ce9218] Merge the latest trunk enhancements. (check-in: [22ce9218] user: drh branch: sessions, size: 23514)
2015-09-10
20:34
[8b867eac] part of check-in [7b5be299] Experimental implementation of sqlite3_result_subtype() and sqlite3_value_subtype() interfaces. (check-in: [7b5be299] user: drh branch: subtypes, size: 22564)
2015-08-13
21:43
[9ad955ca] part of check-in [12640cb2] Convert the hint expression of the CursorHint opcode into a string for display by EXPLAIN. (check-in: [12640cb2] user: drh branch: cursor-hints-displayP4, size: 21906)
21:32
[7258d75f] part of check-in [20688471] Convert the hint expression of the CursorHint opcode into a string for display by EXPLAIN. (check-in: [20688471] user: drh branch: cursor-hints, size: 22808)
2015-06-30
16:29
[963c87c4] part of check-in [39936b33] Merge all the latest enhancements from trunk. This merge include FTS5 and a number of notable performance enhancements. (check-in: [39936b33] user: drh branch: sessions, size: 23463)
2015-06-26
18:16
[8b54e01a] part of check-in [2abc44eb] Cache the sqlite3_context structure in the P4 operand of VDBE programs for faster SQL function dispatch. (check-in: [2abc44eb] user: drh branch: trunk, size: 22513)
2015-06-17
18:18
[57197704] part of check-in [199bfb67] Merge all recent enhancements and fixes from trunk. (check-in: [199bfb67] user: drh branch: sessions, size: 23350)
2015-06-05
15:59
[20295e48] part of check-in [f167bba4] Add a new opcode to the VDBE that gives the b-tree a hint about the set of columns in a table or index that are actually used by the query. (check-in: [f167bba4] user: drh branch: column-usage-hint, size: 22400)
2015-05-21
17:24
[20e5edac] part of check-in [b3bb660a] Prevent a virtual table from being destroyed while it is in use. Also: replace Vdbe.inVtabMethod with sqlite3.nVDestroy. Simplify the EXPLAIN output for P4.pVtab to only show the sqlite3_vtab pointer. Cherrypick of [cbeb9a1aed8c]. (check-in: [b3bb660a] user: dan branch: branch-3.8.6, size: 21176)
2015-05-20
22:01
[50e29824] part of check-in [2007391c] Add the sqlite3_value_dup() and sqlite3_value_free() interfaces and use those to add the sqlite3_rtree_query_info.apSqlParam field to the query callback in R-Tree. (check-in: [2007391c] user: drh branch: sessions-value-dup, size: 23239)
21:28
[f0ccddac] part of check-in [a7ee40c4] Add the sqlite3_value_dup() and sqlite3_value_free() interfaces. Use these interfaces to enhance R-Tree to add the sqlite3_rtree_query_info.apSqlParam field. (check-in: [a7ee40c4] user: drh branch: value-dup, size: 22289)
2015-05-19
22:42
[0c025e70] part of check-in [0a0de8b7] Merge recent trunk changes, include the R-Tree enhancement that allows 8-byte BLOB arguments to geometry functions, and the fix for the TEXT affinity problem that could cause corrupt indexes. (check-in: [0a0de8b7] user: drh branch: sessions, size: 23102)
2015-05-15
04:13
[de3291a6] part of check-in [56ef98a0] Simplifications to error message processing. Fix a possible problem in error message formatting when vacuuming a database with a corrupt schema. (check-in: [56ef98a0] user: drh branch: trunk, size: 22152)
2015-03-24
19:02
[96e4303a] part of check-in [54aaa6f2] Merge all recent trunk enhancements into the sessions branch. (check-in: [54aaa6f2] user: drh branch: sessions, size: 23053)
12:51
[9cbaa84f] part of check-in [9faefb96] Replace the Vdbe.inVtabMethod field with the sqlite3.nVDestroy counter. (check-in: [9faefb96] user: drh branch: nVDestroy, size: 22103)
2015-02-21
15:13
[50fc184e] part of check-in [f36bb5fa] Merge all recent trunk changes into the sessions branch. (check-in: [f36bb5fa] user: drh branch: sessions, size: 23561)
2015-02-13
12:05
[bb56fd19] part of check-in [3c6ca414] Make sure the prepared statement auto-resets on extended error codes of SQLITE_BUSY and SQLITE_LOCKED even when compiled using SQLITE_OMIT_AUTORESET. (check-in: [3c6ca414] user: drh branch: trunk, size: 22611)
2014-11-18
21:20
[dc69f035] part of check-in [f09055f3] Merge recent trunk enhancements, including the read-after-ROLLBACK change and the addition of sqlite3_stmt_scanstatus() support, as well as various minor bug fixes. (check-in: [f09055f3] user: drh branch: sessions, size: 23459)
2014-11-06
04:42
[9bb69ff2] part of check-in [64ad5761] Add the SQLITE_SCANSTAT_SELECTID metric. Use it to improve the ".stmtscan on" output in the shell. (check-in: [64ad5761] user: drh branch: scanstatus, size: 22509)
03:55
[c32c1de2] part of check-in [f9684000] Change the SQLITE_SCANSTAT_EST parameter so that it returns a double for the estimated number of output rows per loop, rather than a 64-bit integer. Revise the output format for the ".scanstats on" in the shell to make use of this new capability. (check-in: [f9684000] user: drh branch: scanstatus, size: 22439)
2014-11-03
11:25
[539ba284] part of check-in [f5313e0c] Remove unused variable from struct WhereInfo. Add some explanatory comments to new code. (check-in: [f5313e0c] user: dan branch: scanstatus, size: 22432)
2014-11-01
21:00
[21570e5e] part of check-in [f13d6ba8] Minor performance enhancements to SQLITE_ENABLE_STMT_SCANSTATUS code. (check-in: [f13d6ba8] user: dan branch: scanstatus, size: 22435)
20:38
[ee8d44cb] part of check-in [9ea37422] If SQLITE_ENABLE_STMT_SCANSTATUS is defined, record the number of times each VDBE opcode is executed. Derive the values returned by sqlite3_stmt_scanstatus() from these records on demand. (check-in: [9ea37422] user: dan branch: scanstatus, size: 22370)
2014-10-31
20:11
[284b2294] part of check-in [6a9bab34] Add the experimental sqlite3_stmt_scanstatus() API. (check-in: [6a9bab34] user: dan branch: scanstatus, size: 21951)
14:53
[18756149] part of check-in [28b044a5] Merge recent trunk enhancements, and in particular the improvements to the b-tree balancing logic, into the sessions branch. (check-in: [28b044a5] user: drh branch: sessions, size: 22679)
2014-10-28
18:24
[acc36ac4] part of check-in [41cdd0c4] Modify the documentation for sqlite3_changes() to make it more testable. Add tests and minor fixes for the same. (check-in: [41cdd0c4] user: dan branch: trunk, size: 21729)
2014-10-23
17:26
[0fdc28cf] part of check-in [c6a5b67a] Add debugging code to count the number of iterations of each loop made as part of statement execution. (check-in: [c6a5b67a] user: dan branch: debug-loopcounters, size: 22220)
2014-10-14
13:41
[7254c20b] part of check-in [83d4114f] Merge recent trunk micro-optimizations and the DESC index GROUP BY ORDER BY bug fix into the sessions branch. (check-in: [83d4114f] user: drh branch: sessions, size: 22627)
2014-10-13
20:12
[e2a060a5] part of check-in [4b3b65ee] Use the padding word in the Mem object as temporary storage for serial_type value in OP_Record, and thus avoid a redundant computation of the serial_type for each column. (check-in: [4b3b65ee] user: drh branch: trunk, size: 21677)
16:02
[90c0ae53] part of check-in [c2799aec] Reduce the CPU load imposed by sqlit3VdbeCursorMoveto() by factoring out some of its functions and by avoiding unnecessary calls. (check-in: [c2799aec] user: drh branch: trunk, size: 21655)
2014-10-12
22:37
[e1173bd7] part of check-in [91384a7d] Remove the VdbeCursor.lastRowid cache of the current rowid, since maintaining the correct cache value uses more CPU cycles than just recomputing the rowid on the occasions when it is actually needed. Replace it with the VdbeCursor.aOffset field which used to be computed from VdbeCursor.aType when needed. Saves 100 bytes of code space and runs 0.2% faster. (check-in: [91384a7d] user: drh branch: trunk, size: 21612)
2014-10-01
01:52
[6d4bf3fd] part of check-in [2695772c] Merge the latest enhancements from trunk. (check-in: [2695772c] user: drh branch: sessions, size: 22627)
2014-09-30
12:33
[0b97a319] part of check-in [4ff51325] Remove the SQLITE_ENABLE_TREE_EXPLAIN compile-time option. Add alternative debugging display routines: sqlite3TreeViewExpr(), sqlite3TreeViewExprList(), and sqlite3TreeViewSelect(). (check-in: [4ff51325] user: drh branch: trunk, size: 21677)
2014-09-27
19:51
[7d151278] part of check-in [497367cb] Merge recent trunk changes (performance enhancements) into the sessions branch. (check-in: [497367cb] user: drh branch: sessions, size: 22777)
2014-09-25
13:17
[bb7f7ecf] part of check-in [3467049a] Simplifications to the SQL function and aggregate calling procedures. (check-in: [3467049a] user: drh branch: trunk, size: 21827)
2014-09-21
22:49
[0e6e8d18] part of check-in [6406b77f] Merge all recent trunk changes into the sessions branch. (check-in: [6406b77f] user: drh branch: sessions, size: 22826)
2014-09-19
00:43
[f177bed1] part of check-in [5b9b8987] Add the sqlite3VdbeMemClearAndResize() interface to be used in place of sqlite3VdbeMemGrow(). A C++ style comment was left in this check-in by mistake, and so it has been moved into a branch to avoid problems in any future bisects on windows. (check-in: [5b9b8987] user: drh branch: Cplusplus-comment, size: 21876)
2014-09-18
21:25
[1ac536d1] part of check-in [9c09ac35] Add the Mem.szMalloc element to the Mem object and use it to keep track of the size of the Mem.zMalloc allocation. (check-in: [9c09ac35] user: drh branch: trunk, size: 21824)
18:55
[1c31448d] part of check-in [55879932] Correct typos in comments. No changes to code. (check-in: [55879932] user: mistachkin branch: trunk, size: 21705)
17:52
[45a0b4c5] part of check-in [4c8c89d7] Merge the Mem.r value into the MemValue union as Mem.u.r. Hence, a Mem can now store an integer or a real but not both at the same time. Strings are still stored in a separate element Mem.z, for now. (check-in: [4c8c89d7] user: drh branch: trunk, size: 21725)
2014-09-17
16:41
[f90b0de6] part of check-in [fdddb477] In the Mem object, stop requiring that Mem.xDel be NULL when the MEM_Dyn bit is clear. Also reduce the amount of initialization of Mem objects. All for a small size reduction and performance increase. (check-in: [fdddb477] user: drh branch: micro-optimizations, size: 21680)
14:52
[9d398055] part of check-in [4e437844] Improved interface to the Mem object handling. Small size reduction and performance increase. (check-in: [4e437844] user: drh branch: micro-optimizations, size: 21622)
2014-09-16
14:55
[dc1743de] part of check-in [a10a6bba] Remove an unused parameter from sqlite3VdbeIdxRowid(). This is cosmetic only as the C-compiler optimizers were already omitting this parameter on amalgamation builds. (check-in: [a10a6bba] user: drh branch: micro-optimizations, size: 21761)
14:16
[0de8705e] part of check-in [0be3019e] Reorder the elements of the Mem object for a small size reduction and performance improvement. Moved into a branch because MSVC is unable to handle named structure initializer on nullMem. (check-in: [0be3019e] user: drh branch: micro-optimizations, size: 21771)
2014-09-08
15:04
[0dec00ac] part of check-in [c2885c6b] Merge support for large files on Android from trunk. (check-in: [c2885c6b] user: drh branch: sessions, size: 22663)
2014-09-06
16:39
[b4843c35] part of check-in [e62aab5e] Fix typos in comments. No code changes. (check-in: [e62aab5e] user: peter.d.reid branch: trunk, size: 21713)
2014-09-02
15:49
[872d39f6] part of check-in [d4cce2c7] Merge the latest trunk changes, including the multi-threaded sorter, into the sessions branch. (check-in: [d4cce2c7] user: drh branch: sessions, size: 22663)
2014-08-29
14:40
[cdc8e421] part of check-in [35c44a3c] Merge recent performance enhancements from trunk onto the threads branch. (check-in: [35c44a3c] user: drh branch: threads, size: 21713)
2014-08-27
14:14
[4653bb42] part of check-in [6c1ee3e3] In the sqlite3_context object, keep a pointer to the result value rather than storing the result value in the sqlite3_context object and using memcpy() to move the value back into its register after the function returns. This runs faster and saves over 500 bytes of code space. (check-in: [6c1ee3e3] user: drh branch: trunk, size: 21730)
2014-08-26
02:15
[6a50eb24] part of check-in [08ae974a] Merge recent performance enhancements and the CAST operator enhancements into the sessions branch. (check-in: [08ae974a] user: drh branch: sessions, size: 22680)
2014-08-25
22:43
[a1fcc0a0] part of check-in [6c8f86e4] Merge the CAST operator enhancements from trunk. (check-in: [6c8f86e4] user: drh branch: threads, size: 21713)
20:11
[df584004] part of check-in [91d8a8d0] Allow CAST expressions and unary "+" operators to be used in the DEFAULT argument of an ALTER TABLE ADD COLUMN and to be understand on the RHS of range constraints interpreted by STAT3/4. This involves a rewrite of the implementation of the CAST operator. (check-in: [91d8a8d0] user: drh branch: trunk, size: 21730)
13:27
[94f5cb24] part of check-in [dfdc900f] Merge the recent performance enhancements implemented on trunk into the threads branch. (check-in: [dfdc900f] user: drh branch: threads, size: 21676)
11:20
[20056cd5] part of check-in [3ca5846d] Change the name of the VdbeMemRelease() macro to VdbeMemReleaseExtern() to more accurately reflect what it does. Performance enhancement to the sqlite3VdbeMemRelease() function. (check-in: [3ca5846d] user: drh branch: trunk, size: 21693)
2014-08-23
17:21
[764a055b] part of check-in [25f2246b] Performance optimization in the applyAffinity() logic inside the VDBE. (check-in: [25f2246b] user: drh branch: trunk, size: 21687)
2014-07-29
12:40
[5eee1752] part of check-in [8f1beead] Merge recent trunk changes, and especially the fix for the R-Tree problem described in ticket [d2889096e7bdeac6]. (check-in: [8f1beead] user: drh branch: sessions, size: 22634)
2014-07-28
15:01
[8870adf0] part of check-in [163c247b] Merge recent trunk changes into the threads branch. (check-in: [163c247b] user: drh branch: threads, size: 21667)
2014-07-25
18:01
[f5513f2b] part of check-in [2230c74f] Add constraints (enforced only when SQLITE_DEBUG is enabled) on the use of OP_Next and OP_Prev. (check-in: [2230c74f] user: drh branch: trunk, size: 21684)
2014-07-24
16:54
[5e925f50] part of check-in [77068589] Merge all recent trunk changes into the threads branch. (check-in: [77068589] user: drh branch: threads, size: 21568)
16:23
[31b5cb53] part of check-in [a9db017e] Merge recent trunk changes into the sessions branch. (check-in: [a9db017e] user: drh branch: sessions, size: 22535)
2014-07-22
20:02
[f41a7cf5] part of check-in [77f412ca] Add the OP_ReopenIdx opcode that works like OP_OpenRead except that it becomes a no-op if the cursor is already open on the same index. Update the OR-optimization logic to make use of OP_ReopenIdx in order to avoid unnecessary cursor open requests sent to the B-Tree layer. (check-in: [77f412ca] user: drh branch: trunk, size: 21585)
2014-06-30
20:25
[027a5757] part of check-in [ae23a65e] Merge the latest trunk changes into the threads branch. (check-in: [ae23a65e] user: drh branch: threads, size: 21503)
20:02
[3c295f44] part of check-in [a5d94eab] Merge the latest trunk enhancements into the sessions branch. (check-in: [a5d94eab] user: drh branch: sessions, size: 22470)
2014-06-28
14:28
[5df5e9af] part of check-in [d186d1ac] Change the VDBE to export the sqlite3MemCompare() routine and thus free where.c from the dependency on vdbeInt.h. (check-in: [d186d1ac] user: drh branch: stat4-skipscan, size: 21520)
2014-04-18
13:40
[c78ace64] part of check-in [f8f72ecb] Fix harmless compiler warnings. (check-in: [f8f72ecb] user: drh branch: threads, size: 21566)
2014-04-03
16:35
[c05d4572] part of check-in [9515c834] Merge all recent changes from trunk, including the fix for the OP_SCopy-vs-OP_Copy problem. (check-in: [9515c834] user: drh branch: sessions, size: 22533)
2014-04-01
18:41
[ba106962] part of check-in [821d1ac4] When sorting data for a CREATE INDEX statement in single-threaded mode, assume that keys are delivered to the sorter in primary key order. Also fix various comments that had fallen out of date. (check-in: [821d1ac4] user: dan branch: threads, size: 21588)
2014-03-28
03:12
[e6d83e5b] part of check-in [7fa85eaa] Enhance the sqlite3VdbeRecordCompare() routines so that if they encounter database corruption, they will set the UnpackedRecord.isCorrupt field and return 0. The sqlite3BtreeMovetoUnpacked() routine detects this and returns SQLITE_CORRUPT, causing the corruption to be reported back to the top-level. (check-in: [7fa85eaa] user: drh branch: trunk, size: 21583)
2014-03-26
19:43
[faadf45c] part of check-in [fc8ca1a8] Merge in fixes (including the corrupt-database crash fix) and performance enhancements from trunk. (check-in: [fc8ca1a8] user: drh branch: sessions, size: 22539)
2014-03-19
17:41
[2b9a6849] part of check-in [7ce2daaf] Make it possible for block-sort to use the OP_SorterOpen sorter in addition to a generic OP_OpenEphemeral. (check-in: [7ce2daaf] user: drh branch: orderby-planning, size: 21589)
14:10
[aa7ea206] part of check-in [59742dd4] First attempt at getting block-sort to work. This is an incremental check-in. There are many problems still to be worked out. (check-in: [59742dd4] user: drh branch: orderby-planning, size: 21535)
2014-03-05
14:49
[aa52feb8] part of check-in [0828975d] Merge in various obscure bug fixes and the removal of Mem.memType from trunk. (check-in: [0828975d] user: drh branch: sessions, size: 22427)
01:29
[e54fc4f2] part of check-in [bac2820e] Experimental simplification of memory flags/type handling. (check-in: [bac2820e] user: mistachkin branch: noMemType, size: 21477)
2014-03-04
14:34
[3fecec24] part of check-in [7f51ad97] Merge the performance enhancements of trunk (and some obscure bug fixes) into the sessions branch. (check-in: [7f51ad97] user: drh branch: sessions, size: 22538)
2014-03-03
18:25
[9ccca0bc] part of check-in [ba899372] Fix compiler warnings. (check-in: [ba899372] user: drh branch: experimental, size: 21588)
2014-03-01
18:13
[d55cab85] part of check-in [44e1c337] Change the MEM_Dyn flag so that it means that Mem.xDel exists and must be used to free the string or blob. Add tighter invariant checks on Mem. (check-in: [44e1c337] user: drh branch: enhanced-mem-check, size: 21582)
16:24
[a82d5ab4] part of check-in [354699d5] Factor the Mem invariant checker into a separate procedure (rather than a macro) so that it can be more easily extended. (check-in: [354699d5] user: drh branch: enhanced-mem-check, size: 21584)
14:45
[fa0cadb9] part of check-in [4aeb3ae4] Add extra assert() statements trying to catch a Mem object in an inconsistent state. (check-in: [4aeb3ae4] user: drh branch: enhanced-mem-check, size: 22215)
2014-02-11
04:30
[9ad4950c] part of check-in [b0067926] Sync the latest trunk changes, and in particular the STAT4 IS NOT NULL fix. (check-in: [b0067926] user: drh branch: sessions, size: 22493)
2014-02-10
03:21
[5286af90] part of check-in [5708bc24] Faster and smaller implementation of sqlite3_value_type(). (check-in: [5708bc24] user: drh branch: trunk, size: 21543)
2014-02-08
23:20
[6714e9eb] part of check-in [1e64dd78] Do away with the "multi-register pseudo-table" abstration. Instead, just use an OP_SCopy to load results directory from the result registers of the co-routine. (check-in: [1e64dd78] user: drh branch: trunk, size: 21495)
2014-02-07
19:18
[b5d62957] part of check-in [a522f364] Change the OP_InitCoroutine instruction to jump over the co-routine implementation. (check-in: [a522f364] user: drh branch: coroutine-refactor, size: 21554)
13:20
[bd6d5e70] part of check-in [6fb74485] Add the OP_Undef and OP_IsUndef opcodes. With these, use the first register in the result register range as the flag to indicate EOF on an INSERT from a SELECT, rather than allocating a separate boolean register for that task. (check-in: [6fb74485] user: drh branch: coroutine-refactor, size: 21502)
2013-12-24
12:09
[08d79db1] part of check-in [cfd110bf] Merge the latest trunk changes into the sessions branch. (check-in: [cfd110bf] user: drh branch: sessions, size: 22450)
2013-12-23
19:09
[42db251e] part of check-in [c289a253] Move elements of the Vdbe object that are only used during statement preparation out into the Parse object. (check-in: [c289a253] user: drh branch: trunk, size: 21500)
2013-12-18
15:11
[8a4d2d69] part of check-in [4c6a659c] Show changes to the column cache when PRAGMA vdbe_addoptrace=ON is set. (check-in: [4c6a659c] user: drh branch: column-cache-debug, size: 21706)
2013-12-14
18:24
[062d6e86] part of check-in [32477642] Merge in all recent preformance enhancements from trunk. (check-in: [32477642] user: drh branch: sessions, size: 22556)
2013-12-11
11:00
[a7bc268f] part of check-in [a7e5fcd6] Fix harmless compiler warnings. (check-in: [a7e5fcd6] user: drh branch: trunk, size: 21606)
2013-12-10
21:38
[e103e922] part of check-in [079c04a5] Avoid unnecessary calls to sqlite3VdbeSerialType() from within sqlite3VdbeSerialPut(). (check-in: [079c04a5] user: drh branch: trunk, size: 21611)
2013-12-09
23:17
[7e38eef8] part of check-in [7277a769] Simplifications to the OP_MakeRecord opcode and the sqlite3VdbeSerialPut() helper function. (check-in: [7277a769] user: drh branch: trunk, size: 21606)
2013-11-26
18:00
[1a5c604f] part of check-in [fc9ae839] Merge in performance enhancements from trunk. (check-in: [fc9ae839] user: drh branch: sessions, size: 22561)
2013-11-21
21:59
[05fbda0e] part of check-in [4e8c5d07] Changes some offset and amount parameters from "int" to "u32" to avoid harmless signed/unsigned comparison warnings. (check-in: [4e8c5d07] user: drh branch: trunk, size: 21611)
01:04
[0ac03c79] part of check-in [93393993] Reduce the size of VdbeCursor again, this time without a performance hit. (check-in: [93393993] user: drh branch: OP_Column-refactor, size: 21611)
00:10
[7cb3c641] part of check-in [f8d5efcd] Unpack some fields, adding some space back to the VdbeCursor object, in order to help the code to run a little faster. (check-in: [f8d5efcd] user: drh branch: OP_Column-refactor, size: 21336)
2013-11-20
21:51
[fc6a1ca5] part of check-in [5f9d5068] Reduce the size of the VdbeCursor object from 144 to 120 bytes. (check-in: [5f9d5068] user: drh branch: OP_Column-refactor, size: 21336)
17:25
[fbae1c44] part of check-in [7c914e39] Refactoring the OP_Column opcode for improved performance and maintainability. (check-in: [7c914e39] user: drh branch: OP_Column-refactor, size: 21633)
02:53
[4044cd2e] part of check-in [5562cd34] Simplifications to the VdbeCursor object. (check-in: [5562cd34] user: drh branch: trunk, size: 21378)
2013-11-14
19:18
[40461ecb] part of check-in [7596d1bf] Merge the skip-scan optimization into the sessions branch. (check-in: [7596d1bf] user: drh branch: sessions, size: 22470)
2013-11-13
17:58
[62eb6803] part of check-in [8ce33f4c] Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify some of the other debugging logic. (check-in: [8ce33f4c] user: drh branch: trunk, size: 21520)
2013-11-11
22:55
[fe226d72] part of check-in [5addd123] Merge in the WITHOUT ROWID changes. A few tests are failing now. They will be fixed in a follow-on check-in. (check-in: [5addd123] user: drh branch: sessions, size: 22572)
2013-11-01
22:02
[f2fa3cec] part of check-in [302a8139] Size KeyInfo objects so that IdxInserts always compare the correct number of fields. (check-in: [302a8139] user: drh branch: omit-rowid, size: 21622)
2013-10-26
15:40
[42dcff74] part of check-in [086ec2a1] Work on the UPDATE and INSERT logic. This is an incremental check-in so that can switch over to trunk to work on an unrelated issue there. (check-in: [086ec2a1] user: drh branch: omit-rowid, size: 21617)
2013-10-10
20:13
[2eaf8a38] part of check-in [136445ba] Synchronize with the trunk. (check-in: [136445ba] user: drh branch: sessions, size: 22611)
2013-09-16
12:57
[ff57f67a] part of check-in [daf6ba41] The date and time functions use the exact same notion of "now" for every invocation within the same call to sqlite3_step(). (check-in: [daf6ba41] user: drh branch: trunk, size: 21661)
2013-08-20
13:02
[9bf236dc] part of check-in [3e403328] Merge performance enhancements and compiler warning fixes from trunk. (check-in: [3e403328] user: drh branch: sessions, size: 22534)
00:42
[cbe71b8b] part of check-in [d78c5d89] Performance optimizations in the VDBE and especially to the OP_Next and related opcodes. (check-in: [d78c5d89] user: drh branch: toTypeFuncs, size: 21584)
2013-08-19
23:18
[6931139c] part of check-in [d2efea16] Performance improvement to SQL function calls in the VDBE. (check-in: [d2efea16] user: drh branch: toTypeFuncs, size: 21584)
2013-08-02
20:44
[cc1974b9] part of check-in [7e1acb39] Merge in the latest trunk changes, including partial indexes, the MAX_PATH fix in os_win.c, and the sqlite3_cancel_auto_extension() API. (check-in: [7e1acb39] user: drh branch: sessions, size: 22465)
2013-07-18
17:12
[e9b7c6b1] part of check-in [71effa59] Ensure that all auxiliary data registered by calls to sqlite3_set_auxdata() is destroyed when the VM is halted. Partial fix for [406d3b2ef9]. DRH adds: Stray text accidentally inserted into vdbe.c just prior to the commit breaks the build. (check-in: [71effa59] user: dan branch: typo, size: 21515)
2013-07-11
15:03
[5e666c97] part of check-in [527121ac] Add the "defer_foreign_keys" pragma and the SQLITE_DBSTATUS_DEFERRED_FKS value for sqlite3_db_status(). This is a cherry-pick of a sequence of five checkins in the sessions branch between [1d44e5d3c2] and [d39e65fe70]. (check-in: [527121ac] user: drh branch: trunk, size: 21532)
2013-07-09
13:05
[11feb11e] part of check-in [af3ca4c6] Pull in all the latest changes from trunk. (check-in: [af3ca4c6] user: drh branch: sessions, size: 22482)
2013-07-03
19:53
[1ca0f9ae] part of check-in [1d44e5d3] Experimental change to the handling of foreign key constraint violations when applying a changeset: all foreign keys, immediate and deferred, are deferred until the end of the transaction (or sub-transaction) opened by the sqlite3changeset_apply(). A single call to the conflict-handler (if any) is made if any FK constraint violations are still present in the database at this point. The conflict-handler may choose to rollback the changeset or to apply it, constraint violations and all. (check-in: [1d44e5d3] user: dan branch: sessions, size: 22412)
2013-06-28
01:24
[aa185c6d] part of check-in [59f98c5c] Refactor the Vdbe.noIO field as Vdbe.bIsReader. The meaning is inverted. (check-in: [59f98c5c] user: drh branch: trunk, size: 21451)
2013-06-27
17:40
[9735fdf2] part of check-in [1937fd8e] Make sure that sqlite3_stmt_readonly reports false for PRAGMA journal_mode and PRAGMA wal_checkpoint. Ticket [a589ec069e3]. Also keep track of whether a prepared statement does no reading or writing. (check-in: [1937fd8e] user: drh branch: trunk, size: 21458)
2013-06-26
13:31
[cbecb801] part of check-in [086a1272] Bring the sessions branch up-to-date with all the latest trunk changes. (check-in: [086a1272] user: drh branch: sessions, size: 22331)
2013-06-25
22:01
[b8a76f7b] part of check-in [f1366bab] Add a new (experimental) sqlite3_stmt_status() verb that returns the number of VM steps. (check-in: [f1366bab] user: drh branch: status-vm-step, size: 21381)
2013-04-22
23:59
[a6b7a1fb] part of check-in [6994826c] Merge the latest trunk changes into the sessions branch. (check-in: [6994826c] user: drh branch: sessions, size: 22331)
2013-04-06
18:06
[c1e83026] part of check-in [c1d7304c] Increase the default SQLITE_MAX_SCHEMA_RETRY to 50. Make sure that macro covers every case where a prepared statement might need to be reprepared due to a schema change. The sqlite3_exec() interface now uses sqlite3_prepare_v2(). (check-in: [c1d7304c] user: drh branch: trunk, size: 21381)
2013-03-28
01:19
[bd76014f] part of check-in [ee35a897] Merge the changes for the 3.7.16.1 release candidate into the sessions branch. (check-in: [ee35a897] user: drh branch: sessions, size: 22125)
2013-03-24
22:56
[3bb8531d] part of check-in [8b44d6fb] Remove the SQLITE_OMIT_MERGE_SORT compile-time option and its related code. The merge sorter is now a required component. (check-in: [8b44d6fb] user: drh branch: trunk, size: 21175)
2013-02-13
13:42
[0112cab1] part of check-in [7e14dc73] Enhancements to the query planner to make use of indices for ORDER BY even when IN constraints are in the WHERE clause. Add extended error codes for all SQLITE_CONSTRAINT errors. (check-in: [7e14dc73] user: drh branch: sessions, size: 22511)
2013-02-07
09:33
[396bb03e] part of check-in [4a7b4ee0] Fix harmless compiler warnings. (check-in: [4a7b4ee0] user: drh branch: trunk, size: 21561)
2013-01-28
19:00
[c5b337e5] part of check-in [c2462a95] Issue an error message and quit (rather than overflowing a reference counter) if the number of references to a table exceeds the maximum due to nested UNION views. Fix for ticket [d58ccbb3f1]. (check-in: [c2462a95] user: drh branch: trunk, size: 21561)
2012-10-30
21:03
[2de43968] part of check-in [fce667f2] Pull all the latest trunk enhancements into the sessions branch. (check-in: [fce667f2] user: drh branch: sessions, size: 22511)
00:29
[79abf9b3] part of check-in [7af3acbb] Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table. (check-in: [7af3acbb] user: drh branch: subquery-as-coroutine, size: 21561)
2012-09-28
13:05
[39acf85f] part of check-in [6ca8eae1] Merge the latest trunk changes (especially "PRAGMA busy_timeout" and the ORDER BY query planner optimizations) into the sessions branch. (check-in: [6ca8eae1] user: drh branch: sessions, size: 22452)
2012-09-19
21:15
[573a43ab] part of check-in [94b48064] Tighter VDBE code for the WHERE_DISTINCT_ORDERED case of DISTINCT keyword handling. (check-in: [94b48064] user: drh branch: trunk, size: 21502)
2012-09-04
21:34
[a668b303] part of check-in [39f763bf] Avoid repeating calls to the sqlite3_trace() callback when the same statement is evaluted multiple times by sqlite3_step() due to an SQLITE_SCHEMA reprepare. (check-in: [39f763bf] user: drh branch: trunk, size: 21429)
2012-08-22
15:16
[3c238336] part of check-in [acdc7d12] Do not let the multi-core sorter use lookaside memory, which is not thread-safe. (check-in: [acdc7d12] user: drh branch: threads-sort-ex1, size: 21155)
2012-08-15
16:21
[3f5d9947] part of check-in [fc07a479] Merge all the latest trunk changes into the sessions branch. (check-in: [fc07a479] user: drh branch: sessions, size: 22151)
15:57
[4554c3a3] part of check-in [2bb8c492] Experimental change to speed up ORDER BY clauses that sort based on a single expression. (check-in: [2bb8c492] user: dan branch: sorter-exp, size: 21186)
2012-07-24
19:46
[986b6b11] part of check-in [d8da26f1] Mark parameters to sorter interfaces as const where appropriate. (check-in: [d8da26f1] user: drh branch: trunk, size: 21201)
2012-02-13
13:44
[634aa573] part of check-in [922bcbb4] Generalize the interrupt mechanism so that individual statements can be interrupted and so that codes other than just SQLITE_INTERRUPT can be returned as a consequence of an interrupt. (check-in: [922bcbb4] user: drh branch: generalize-interrupt, size: 21247)
2012-02-10
17:54
[f1956902] part of check-in [361fb66a] Pull all the latest trunk changes into the sessions branch. (check-in: [361fb66a] user: drh branch: sessions, size: 22121)
2012-02-02
21:02
[6ff4180a] part of check-in [f14e7f29] More structure packing for smaller objects and less memory usage. (check-in: [f14e7f29] user: drh branch: trunk, size: 21171)
17:35
[0f986e86] part of check-in [adb29232] For queries of the form "SELECT p, max(q) FROM t1", the value of column p returned is the one on the same row that holds the maximum value of q. (check-in: [adb29232] user: drh branch: output-minmax-row, size: 21171)
2012-02-01
19:03
[2e79ce66] part of check-in [a38d57a4] Very small performance enhancement and reduction in size of the sqlite3_stmt object. (check-in: [a38d57a4] user: drh branch: trunk, size: 21103)
2012-01-14
13:50
[1aa78a0c] part of check-in [01c84fd3] Update sessions branch with latest changes from trunk. (check-in: [01c84fd3] user: dan branch: sessions, size: 22123)
2012-01-08
22:18
[ef9b8584] part of check-in [fc9179e1] Fix typos in commands. Combine the ExpandBlob and expandBlob macros into one. (check-in: [fc9179e1] user: drh branch: trunk, size: 21173)
2012-01-05
13:02
[57ca039e] part of check-in [a9bcb432] Merge all of the latest trunk changes into the sessions branch. (check-in: [a9bcb432] user: drh branch: sessions, size: 22011)
2012-01-04
12:57
[88e4d5d7] part of check-in [e9d05cbb] Fix typos and comments and make minor changes to a few function names, as suggested by readership. (check-in: [e9d05cbb] user: drh branch: trunk, size: 21061)
2011-12-10
15:55
[48c158b2] part of check-in [bcbc7152] Import the experimental parse-tree explainer, with fixes, from the tree-explain branch. Disabled by default. Use SQLITE_ENABLE_TREE_EXPLAIN to turn it on. (check-in: [bcbc7152] user: drh branch: trunk, size: 21062)
14:44
[72222af1] part of check-in [1a360da0] Merge the latest trunk changes into tree-explain branch. (check-in: [1a360da0] user: drh branch: tree-explain, size: 21021)
2011-12-09
13:24
[23a9506c] part of check-in [557c6905] Modify the OP_Once opcode so that it works correctly in trigger sub-programs. This is a candidate fix for [7bbfb7d442]. (check-in: [557c6905] user: dan branch: trunk, size: 20436)
2011-12-06
19:44
[a2b8f177] part of check-in [79ae51c5] Begin adding the data-structure explaining subsystem. All is contained within (check-in: [79ae51c5] user: drh branch: tree-explain, size: 20778)
2011-10-31
14:34
[09dacf6f] part of check-in [23580718] Merge in all changes found in the version 3.7.9 release candidate. (check-in: [23580718] user: drh branch: sessions, size: 21143)
2011-10-27
15:19
[9498fc98] part of check-in [8f88cc4e] If an error occurs within sqlite3_step() on a statement prepared using sqlite3_prepare_v2(), transfer both the error code and error message to the database handle before sqlite3_step() returns (so that they are available via sqlite3_errcode() and sqlite3_errmsg(). Prior to this commit, only the error code was transfered. The error message was not available until after either sqlite3_reset() or sqlite3_finalize() had been called on the statement handle. (check-in: [8f88cc4e] user: dan branch: trunk, size: 20193)
2011-09-20
15:53
[425674f4] part of check-in [89272357] Add SQLITE_STMTSTATUS_CACHE_HIT/MISS and SQLITE_DB_STATUS_CACHE_HIT/MISS. For querying the number of pager cache hits and misses on a statement or connection basis. (check-in: [89272357] user: dan branch: cache-stats, size: 20154)
2011-09-14
19:41
[1400515b] part of check-in [c00e45ed] Merge latest changes from the trunk into the sessions branch. (check-in: [c00e45ed] user: dan branch: sessions, size: 21104)
2011-09-03
00:17
[693d6ac6] part of check-in [68e26c44] The build works again with -DSQLITE_OMIT_MERGE_SORT. The merge-sorter now avoids spilling to disk (letting the in-memory linked list grow without bound) if PRAGMA temp_store=3. (check-in: [68e26c44] user: drh branch: merge-sort, size: 20154)
2011-09-02
10:31
[a255da14] part of check-in [7769fb98] Instead of a temporary b-tree, use a linked-list and merge-sort to sort records in main memory in vdbesort.c. (check-in: [7769fb98] user: dan branch: merge-sort, size: 20154)
2011-09-01
15:32
[51a902e1] part of check-in [bab2e560] Experimental code-generator changes to utilize new opcodes for sorting. (check-in: [bab2e560] user: drh branch: merge-sort, size: 20043)
2011-08-29
02:49
[70767f65] part of check-in [ff71d20a] About a 1% overall performance improvement by using a macro to avoid no-op calls to sqlite3MemReleaseExternal(). (check-in: [ff71d20a] user: drh branch: experimental, size: 19986)
2011-08-26
19:20
[1b36e546] part of check-in [eb036d6f] Merge the latest trunk changes into the sessions branch. (check-in: [eb036d6f] user: drh branch: sessions, size: 20812)
2011-08-12
16:11
[f9250326] part of check-in [1a8498d8] Remove an unused parameter from a function in vdbesort.c. Fix some comments and other details in the same file. (check-in: [1a8498d8] user: dan branch: experimental, size: 19862)
15:02
[603b4ccc] part of check-in [4ced2394] Add the SQLITE_OMIT_MERGE_SORT pre-processor directive. To omit the code in vdbesort.c. (check-in: [4ced2394] user: dan branch: experimental, size: 19873)
2011-08-06
12:01
[de75338e] part of check-in [8051c176] In temp files used for merge sorting, store the size of each packed-memory-array at the start of the array itself. This is to avoid having to store the offsets of all arrays in the (potentially very large) file in main-memory. (check-in: [8051c176] user: dan branch: experimental, size: 19539)
2011-08-02
10:56
[9e38e4f8] part of check-in [7f339c0e] Minor fixes to vdbesort.c code in preparation for a major rework. (check-in: [7f339c0e] user: dan branch: experimental, size: 19534)
2011-07-12
14:28
[fb6c8600] part of check-in [30dbf0fe] Experimental support for speeding up CREATE INDEX commands using an offline merge sort. (check-in: [30dbf0fe] user: dan branch: experimental, size: 19352)
2011-06-20
10:44
[3de6588b] part of check-in [4c5e276c] Merge the latest trunk changes into the sessions branch. (check-in: [4c5e276c] user: drh branch: sessions, size: 19988)
2011-06-01
18:15
[ad84226c] part of check-in [b3aaf715] Refactor the SQL parameter processing so that parameter names for values that are optimized out of the prepare statement are not forgotten. (check-in: [b3aaf715] user: drh branch: trunk, size: 19038)
2011-04-06
22:33
[b95de012] part of check-in [435b57dc] Merge in the latest changes from the trunk. (check-in: [435b57dc] user: drh branch: sessions, size: 19996)
22:05
[fe8f58d3] part of check-in [614de91a] Fix a performance regression: Keep two btree masks in each prepared statement; one for btrees used and another for btrees that require locks. Only try to lock the btrees identified by the second mask. (check-in: [614de91a] user: drh branch: trunk, size: 19046)
2011-04-05
22:13
[3dec3d5b] part of check-in [45f20261] Merge the latest trunk changes into the sessions branch. (check-in: [45f20261] user: drh branch: sessions, size: 19923)
17:31
[53dfcaf5] part of check-in [242ce7cf] Remove the mutex counter and the logic that attempts to verify that btree mutexes are held continuously. We are not making that assumption at this time. (check-in: [242ce7cf] user: drh branch: trunk, size: 18973)
2011-04-04
13:19
[36dddc4c] part of check-in [95d53c44] Merge the latest changes of trunk into the session branch. (check-in: [95d53c44] user: drh branch: sessions, size: 19891)
00:14
[7e2f028e] part of check-in [d81708f7] Remove the BtreeMutexArray object - use the Vdbe.btreeMask field to accomplish the same result. Add a generation counter to btree mutexes in order to assert that mutexes are never temporarily dropped over a range of instructions in order to do deadlock avoidance in some subroutine. Lock all btrees in any Vdbe program that uses OP_ParseSchema. (check-in: [d81708f7] user: drh branch: trunk, size: 18941)
2011-04-02
20:01
[8ee9302e] part of check-in [3d6f2e82] Change the name of the "tAttachMask" datatype to "yDbMask". (check-in: [3d6f2e82] user: drh branch: trunk, size: 18981)
2011-03-23
22:48
[b6748a8a] part of check-in [9c3a6e47] Merge in all the latest changes from the trunk, and especially the interface changes to the SystemCall methods of the VFS. (check-in: [9c3a6e47] user: drh branch: sessions, size: 19931)
18:22
[e1c62546] part of check-in [7aaf8772] Increase the upper bound on SQLITE_MAX_ATTACHED from 30 to 62. (check-in: [7aaf8772] user: drh branch: trunk, size: 18981)
2011-03-19
08:38
[2cf77c1d] part of check-in [24d4d5dd] Fix a problem with INTEGER PRIMARY KEY columns and the pre-update hook. (check-in: [24d4d5dd] user: dan branch: sessions, size: 19931)
2011-03-16
19:59
[20d13da9] part of check-in [526545c4] Add the sqlite3_preupdate_new() API, for retrieving the new.* values from within a pre-update callback. (check-in: [526545c4] user: dan branch: sessions, size: 19716)
2011-03-08
19:22
[9dd04435] part of check-in [269a81a3] Add start of sessions feature. (check-in: [269a81a3] user: dan branch: sessions, size: 19504)
2011-03-01
18:42
[41b8e337] part of check-in [6145d7b8] Add the experimental sqlite3_preupdate_hook() API. (check-in: [6145d7b8] user: dan branch: sessions, size: 19485)
2011-01-07
02:50
[6e6f28e9] part of check-in [378a1d13] Reorder the fields in private structures in an effort to reduce alignment gaps and thus make the structures smaller, and to put frequently accessed fields first. Also update some obsolete comments. Valgrind shows a very slight performance improvement. (check-in: [378a1d13] user: drh branch: trunk, size: 18981)
2010-12-01
08:04
[1f2137b9] part of check-in [119ffe95] Avoid recursive calls to sqlite3VdbeMemRelease() when deleting VM frames used by trigger programs. (check-in: [119ffe95] user: dan branch: trunk, size: 19927)
2010-09-27
21:09
[7f4cf1b2] part of check-in [8b8e1732] Add assert() statements that fail when a shallow copy is accessed after the original has been modified. These assert() statements should detect the kinds of subtle SCopy bugs such as caused the fault in ticket [b351d95f9cd5ef17e9d9dbae18f]. (check-in: [8b8e1732] user: drh branch: bug-b351d95f9c, size: 19220)
2010-08-30
22:15
[a247bd54] part of check-in [4fead8e7] Provide hints to the btree layer during the creation of transient tables for when it is possible for those tables to use a hash rather than a binary tree. No use is currently made of those hints, though assert() statement verify their accuracy. (check-in: [4fead8e7] user: drh branch: trunk, size: 18723)
2010-07-26
12:05
[ffd68c4d] part of check-in [00e55102] Change the way SubProgram objects are deleted so that the code is the same for deletion and measurement. (check-in: [00e55102] user: dan branch: experimental, size: 18645)
2010-04-06
22:33
[19ebc8c2] part of check-in [abbf16e5] Veryquick.test is now working. The SQLITE_STMTSTATUS_AUTOINDEX counter added. (check-in: [abbf16e5] user: drh branch: experimental, size: 18570)
2010-02-25
14:56
[15d418f4] part of check-in [b8fbf427] Expire pragma statements when reset, even if they were not run to completion. (check-in: [b8fbf427] user: drh branch: branch-3.6.22, size: 18465)
14:47
[ae1e6ba0] part of check-in [78351d28] Expire pragma statements when reset, even if they were not run to completion. (check-in: [78351d28] user: drh branch: trunk, size: 18570)
2010-01-13
00:04
[e276691b] part of check-in [61df5986] Make the sqlite3_result_double() interface work the same as sqlite3_result_int64() when SQLITE_OMIT_FLOATING_POINT is defined. (check-in: [61df5986] user: drh branch: trunk, size: 18508)
2009-11-14
23:22
[d7ea821a] part of check-in [d622ac6a] Optimizations to the main loop inside sqlite3VdbeExec() to help VDBE byte code run a few percent faster. (check-in: [d622ac6a] user: drh branch: trunk, size: 18403)
2009-11-10
01:30
[59c65e7b] part of check-in [f6c045f6] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: [f6c045f6] user: drh branch: trunk, size: 18447)
2009-11-04
13:17
[53b430ad] part of check-in [24a4d520] Create a new datatype "ynVar" to hold "nVar" (number of variable) values. This is normally 16-bits can can be 32-bits if SQLITE_MAX_VARIABLE_NUMBER is large enough. (check-in: [24a4d520] user: drh branch: trunk, size: 18506)
2009-11-03
01:22
[aa08465e] part of check-in [16a24b44] All SQLITE_MAX_VARIABLE_NUMBER to exceed 32767. The sizes of some structures increase when the compile-time parameter is configured this way. (check-in: [16a24b44] user: drh branch: trunk, size: 18621)
2009-10-26
22:32
[97312570] part of check-in [2eeb6ed8] Remove additional obsolete code from the sqlite3_release_memory() logic. (check-in: [2eeb6ed8] user: drh branch: trunk, size: 18506)
2009-10-19
18:11
[8e07f435] part of check-in [2c50b3d5] Remove the sqlite3_reoptimize() API. The same functionality is now provided automatically to queries prepared using prepare_v2(). (check-in: [2c50b3d5] user: dan branch: trunk, size: 18592)
2009-10-15
18:35
[aafda2e9] part of check-in [9bd6f3d8] Add the experimental sqlite3_reoptimize() API. (check-in: [9bd6f3d8] user: dan branch: experimental, size: 18754)
2009-09-23
18:07
[7afb76c0] part of check-in [e0a48d53] Fix a problem with FK constraints that implicitly map to a composite primary key. (check-in: [e0a48d53] user: dan branch: trunk, size: 18482)
17:30
[03336c03] part of check-in [1a32149c] Do not check immediate foreign key constraints until the end of the statement. This matches the postgres behaviour. (check-in: [1a32149c] user: dan branch: trunk, size: 18487)
2009-09-19
17:00
[546ed25c] part of check-in [d5d39981] Check in implementation of foreign key constraints. (check-in: [d5d39981] user: dan branch: trunk, size: 18417)
2009-09-08
01:14
[004dbb28] part of check-in [52449a95] Code simplifications, especially to the pseudo-table logic, and comment improvements. (check-in: [52449a95] user: drh branch: trunk, size: 18217)
2009-09-01
12:16
[6094e60f] part of check-in [38a9327b] More fixes and comment updates. (check-in: [38a9327b] user: dan branch: trunk, size: 18267)
2009-08-30
11:42
[12919083] part of check-in [9eb91efd] Fixes for new triggers scheme. (check-in: [9eb91efd] user: dan branch: trunk, size: 17689)
2009-08-28
18:53
[9b62f705] part of check-in [9b9c1921] Changes to support recursive triggers. (check-in: [9b9c1921] user: dan branch: trunk, size: 18410)
2009-06-23
14:15
[831c254a] part of check-in [3ffc93d7] Simplifications to vdbe.c to promote better test coverage. (CVS 6802) (check-in: [3ffc93d7] user: drh branch: trunk, size: 17216)
2009-06-22
00:55
[7823eac6] part of check-in [16680f05] Simplifications to vdbe.c in support of coverage testing. (CVS 6794) (check-in: [16680f05] user: drh branch: trunk, size: 17206)
2009-06-19
14:06
[f5147efa] part of check-in [37ae5f5e] Reorganize and cleanup the prepared statement object. Remove code that has been commented out for ages and is no longer relevant to anything. (CVS 6786) (check-in: [37ae5f5e] user: drh branch: trunk, size: 17388)
2009-06-05
14:17
[37271282] part of check-in [38b20327] Take care that a corrupt variable-length integer does not cause 32-bit integer overflow when parsing a record format, nor cause excessively large memory allocations. (CVS 6719) (check-in: [38b20327] user: drh branch: trunk, size: 17607)
2009-05-04
11:42
[43183a2a] part of check-in [cac4f3d8] Speed up INSERT operations that add data to UNIQUE or PRIMARY KEY indexes by rationalizing duplicate seek operations. (CVS 6599) (check-in: [cac4f3d8] user: danielk1977 branch: trunk, size: 17615)
2009-04-22
02:15
[8726f7b4] part of check-in [e963bed0] Remove the rowhash object from the code. Rowset now fills its role. (CVS 6535) (check-in: [e963bed0] user: drh branch: trunk, size: 17476)
2009-04-21
09:02
[d3adfecc] part of check-in [f61e4cd9] Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) (check-in: [f61e4cd9] user: danielk1977 branch: trunk, size: 17611)
2009-04-10
12:55
[df5c5a1c] part of check-in [683e4bd7] Changes to ensure that when running in shared-cache mode with a non-threadsafe build, the correct busy-handler callback is always invoked. (CVS 6481) (check-in: [683e4bd7] user: danielk1977 branch: trunk, size: 17484)
2009-03-18
10:33
[53a2f469] part of check-in [a60f4191] Fix some cases where executing SQL from within a user-function callback could cause problems related to statement-transactions. (CVS 6355) (check-in: [a60f4191] user: danielk1977 branch: trunk, size: 17356)
2009-03-17
22:33
[87322289] part of check-in [18978583] Move the rowid cache out of VdbeCursor and into BtCursor. When multiple BtCursors are open on the same table, set their rowid cache all at the same time. Ticket #3731. (CVS 6354) (check-in: [18978583] user: drh branch: trunk, size: 17302)
2009-02-20
01:28
[d12bc259] part of check-in [58a18092] Reuse space left-over opcode space at the end of the VDBE opcode array to store memory cells, VDBE cursors, and other content needed by the VDBE. This reduces the memory required by a prepared statement. (CVS 6307) (check-in: [58a18092] user: drh branch: trunk, size: 17434)
2009-02-19
14:39
[9dd984cf] part of check-in [d9f6ffbc] Changes to reduce the heap space consumed by triggers, views and tables in the in-memory representation of the schema. Also to reduce the space used by prepared statements slightly. (CVS 6305) (check-in: [d9f6ffbc] user: danielk1977 branch: trunk, size: 17377)
2009-02-03
15:39
[13cb4868] part of check-in [a3c26077] Remove the text of the sqlite3VdbeMemSanity() routine, which was already commented out. (CVS 6238) (check-in: [a3c26077] user: drh branch: trunk, size: 17559)
2009-01-05
18:02
[5530e45f] part of check-in [b2131e86] Make sure the MEM_Zero flags is cleared whenever removing MEM_Blob. (CVS 6111) (check-in: [b2131e86] user: drh branch: trunk, size: 17616)
2008-12-09
02:51
[e6e80a99] part of check-in [1522c2c6] Suppress more silly compiler warnings. (CVS 5995) (check-in: [1522c2c6] user: drh branch: trunk, size: 17602)
2008-12-04
20:40
[1df957ab] part of check-in [39a0750b] Replace the VDBE Fifo object with the new RowSet object. (CVS 5977) (check-in: [39a0750b] user: drh branch: trunk, size: 17533)
2008-11-17
15:31
[6b108248] part of check-in [9939dd83] Modifications to avoid signed/unsigned warnings in vdbe.c. (CVS 5912) (check-in: [9939dd83] user: danielk1977 branch: trunk, size: 18497)
2008-11-05
16:37
[c9400778] part of check-in [51f04aaf] The COMMIT command now works even if there are pending queries, as long as the pending queries are reading and not writing the database. (CVS 5864) (check-in: [51f04aaf] user: drh branch: trunk, size: 18489)
2008-11-03
20:55
[1fd87002] part of check-in [fdb98fd8] Change the name of the Cursor object to VdbeCursor. (CVS 5857) (check-in: [fdb98fd8] user: drh branch: trunk, size: 18362)
2008-10-07
23:46
[a20f479e] part of check-in [de473efb] Add the experimental sqlite3_stmt_status() interface. (CVS 5781) (check-in: [de473efb] user: drh branch: trunk, size: 18318)
2008-08-13
19:11
[b48c74d8] part of check-in [0b92cbf5] Additional changes toward fixing ticket #3292. (CVS 5562) (check-in: [0b92cbf5] user: drh branch: trunk, size: 18245)
2008-08-02
03:50
[6f04c2bf] part of check-in [f1e44eb3] Additional coverage testing. Fix a segfault following OOM in sqltie3_load_extension(). (CVS 5523) (check-in: [f1e44eb3] user: drh branch: trunk, size: 19349)
2008-07-30
13:14
[ab27f964] part of check-in [aee63308] Remove unused sqlite3VdbeMemDynamicify() function from the VDBE. (CVS 5500) (check-in: [aee63308] user: drh branch: trunk, size: 19428)
2008-07-28
19:34
[1672cc13] part of check-in [e48f9697] Implement the "lookaside" memory allocation cache. Use of this cache makes the speed1.test script run about 15% faster. Added new interfaces to control the cache. (CVS 5488) (check-in: [e48f9697] user: drh branch: trunk, size: 19464)
2008-07-26
18:26
[3c12ae09] part of check-in [7aecabac] Fix a case where database corruption was causing an invalid reference. (CVS 5484) (check-in: [7aecabac] user: danielk1977 branch: trunk, size: 19399)
2008-06-25
00:12
[30535c1d] part of check-in [8bbfa978] The compound-select merge optimization passes quick.test with no errors. (CVS 5299) (check-in: [8bbfa978] user: drh branch: trunk, size: 19380)
2008-06-20
18:13
[723fb796] part of check-in [08311365] Add new Compare and Jump codes to the virtual machine. Use them in the implementation of aggregate queries. (CVS 5257) (check-in: [08311365] user: drh branch: trunk, size: 19456)
2008-06-06
15:04
[de321b2c] part of check-in [ef1956ee] Remove the subroutine return stack from the VDBE. Return addresses for subroutines are now stored in registers. (CVS 5191) (check-in: [ef1956ee] user: drh branch: trunk, size: 19380)
2008-05-16
04:51
[ede1a31c] part of check-in [81a8c70e] Add more version tags to files that lack them. Ticket #3120. (CVS 5137) (check-in: [81a8c70e] user: danielk1977 branch: trunk, size: 19535)
2008-05-01
17:03
[18aebaa7] part of check-in [227a6f67] Fix harmless compiler warnings. (CVS 5073) (check-in: [227a6f67] user: drh branch: trunk, size: 19468)
2008-04-18
09:01
[05316345] part of check-in [c448f15a] Allow OP_MoveGt and similar to use an array of registers instead of a serialized record. Modify one type of index range scan to use this. (CVS 5028) (check-in: [c448f15a] user: danielk1977 branch: trunk, size: 19422)
2008-03-28
15:44
[0b96efde] part of check-in [d0bf73d8] Changes to the Mem structure to reduce the frequency of freeing and reallocating the dynamic buffer. (CVS 4928) (check-in: [d0bf73d8] user: danielk1977 branch: trunk, size: 19405)
2008-03-27
17:59
[73a31629] part of check-in [1a58a870] Allow creation of ephemeral pseudo-tables - pseudo-tables that copy a pointer to a row when inserted instead of copying the row data. (CVS 4924) (check-in: [1a58a870] user: danielk1977 branch: trunk, size: 19288)
2008-03-26
18:34
[25844947] part of check-in [8c2f6952] Changes to delay freeing buffers associated with vdbe memory cells until either sqlite3_finalize() or sqlite3_release_memory() is called. (CVS 4922) (check-in: [8c2f6952] user: danielk1977 branch: trunk, size: 19263)
2008-03-25
17:23
[4d767f18] part of check-in [ee381b43] Modify the {quote: IdxDelete} opcode so that it takes an array of registers rather than a record formed using {quote: MakeRecord.} This avoids a needless packing and unpacking of the record to be deleted. (CVS 4916) (check-in: [ee381b43] user: drh branch: trunk, size: 19141)
00:22
[4bbec80d] part of check-in [0e1d84f2] Removed the direct btree tests - part of the ongoing effort to test by calling only public interfaces. Modify the sqlite3VdbeRecordCompare interface to used a pre-parsed second key - resulting in a 13% performance improvement on speed1p.test. (CVS 4911) (check-in: [0e1d84f2] user: drh branch: trunk, size: 18252)
2008-02-13
18:25
[76c81d05] part of check-in [990237e2] Where possible, avoid freeing buffers allocated for vdbe memory cells in case they can be reused. (CVS 4783) (check-in: [990237e2] user: danielk1977 branch: trunk, size: 18322)
2008-02-06
14:11
[969d360a] part of check-in [c2461620] Add the sqlite3_result_error_code() application interface. Use it in the ATTACH function so that a failed attach returns a proper error code. Ticket #2914. (CVS 4775) (check-in: [c2461620] user: drh branch: trunk, size: 18448)
2008-01-28
15:19
[b7a18349] part of check-in [50c9cf9b] Fix an incorrect comment on the Mem object in vdbeInt.h. (CVS 4752) (check-in: [50c9cf9b] user: drh branch: trunk, size: 18436)
2008-01-22
21:30
[6b4a4381] part of check-in [1a335e18] Add the fault injector module in fault.c. Use it as a basis for memory allocation failure testing. (CVS 4742) (check-in: [1a335e18] user: drh branch: trunk, size: 18436)
2008-01-17
16:22
[835e6f03] part of check-in [706b41b7] Registerification of the VDBE is complete. The operand stack has been removed from the code. All instructions operate out of registers only. (CVS 4718) (check-in: [706b41b7] user: drh branch: trunk, size: 18435)
2008-01-04
16:50
[31bd6865] part of check-in [042dcb96] Replace the NOPUSH_MASKs with a bit-vector mechanism that can contain several different properties about each opcode. (CVS 4677) (check-in: [042dcb96] user: drh branch: trunk, size: 18641)
2008-01-03
11:50
[869d0f55] part of check-in [7e8330c8] Change the VdbeOp.p4 union to include specific pointer types for the various values of VdbeOp.p4type. (CVS 4667) (check-in: [7e8330c8] user: danielk1977 branch: trunk, size: 18632)
2008-01-02
00:34
[2985f136] part of check-in [051ec01f] Begin setting a foundation on which to convert the VM from a stack-based to a register-based machine. Everything is still mostly stack based with this check-in. This change merely begins adding infrastructure to support a register-based architecture. (CVS 4652) (check-in: [051ec01f] user: drh branch: trunk, size: 18690)
2007-08-28
23:28
[630145b9] part of check-in [f84550be] The shared_err test runs with no errors. But a potential deadlock has been discovered and is still unfixed. (CVS 4317) (check-in: [f84550be] user: drh branch: trunk, size: 18704)
22:24
[a9dcd068] part of check-in [967ab229] Clean up the locking in the btree logic. (CVS 4316) (check-in: [967ab229] user: drh branch: trunk, size: 18679)
02:27
[0681e0b7] part of check-in [b8cc493b] Work toward correct btree locking in a multithreaded environment. (CVS 4307) (check-in: [b8cc493b] user: drh branch: trunk, size: 18607)
2007-08-27
23:26
[2bb602c9] part of check-in [dc80b2e1] Work around problem with forward declarations of constants in MSVC in the amalgamation. Ticket #2574. (CVS 4304) (check-in: [dc80b2e1] user: drh branch: trunk, size: 18554)
2007-08-21
19:33
[39fb069c] part of check-in [92872761] The sqlite3_value object now carries an sqlite3* pointer to use for recording malloc failures. This eliminates the need to pass sqlite3* pointers into many internal interfaces. Also added more mutexing. (CVS 4263) (check-in: [92872761] user: drh branch: trunk, size: 18836)
2007-08-16
12:24
[8e360d32] part of check-in [ba80ee59] Combine sqlite3DbOfVdbe() and sqlite3VdbeDb() into a single function. (CVS 4236) (check-in: [ba80ee59] user: drh branch: trunk, size: 18972)
10:09
[e0bd068c] part of check-in [77b16713] More work on refactoring of malloc() interfaces. There are still many errors. (CVS 4233) (check-in: [77b16713] user: danielk1977 branch: trunk, size: 19005)
04:30
[0629275f] part of check-in [deb7ecd6] Half-way through a major refactoring of the memory allocation. I have not even attempted to compile so I am certain there are countless errors. (CVS 4231) (check-in: [deb7ecd6] user: drh branch: trunk, size: 18860)
2007-06-27
15:53
[c3514903] part of check-in [37d1f9f3] Allow ALTER TABLE on virtual tables. (CVS 4142) (check-in: [37d1f9f3] user: danielk1977 branch: trunk, size: 18777)
2007-05-16
14:23
[7d2bf163] part of check-in [1d89be28] Omit some extra code when OMIT_INCRBLOB is defined. (CVS 4014) (check-in: [1d89be28] user: danielk1977 branch: trunk, size: 18700)
2007-05-08
21:45
[bddb7931] part of check-in [c5754530] Remove compiler warnings in the amalgamation. (CVS 3960) (check-in: [c5754530] user: drh branch: trunk, size: 18526)
20:59
[095222fe] part of check-in [5a0fe985] Disable tracing pragmas when not in debug mode. This eliminates an external dependency on stdout. (CVS 3959) (check-in: [5a0fe985] user: drh branch: trunk, size: 18518)
12:12
[77a17f1a] part of check-in [031a5915] Begin adding code to explicitly limit the size of strings and blobs. (CVS 3943) (check-in: [031a5915] user: drh branch: trunk, size: 18491)
2007-05-02
13:30
[cb02cbbc] part of check-in [e6d560dd] Add support for zero-blobs to the OP_MakeRecord opcode. First test cases of zeroblob functionality. (CVS 3897) (check-in: [e6d560dd] user: drh branch: trunk, size: 18459)
02:08
[10ff7c35] part of check-in [6f4f8ba7] Fix some compiler warnings. Add the (untested) zeroblob() SQL function. (CVS 3895) (check-in: [6f4f8ba7] user: drh branch: trunk, size: 18429)
01:34
[016c8084] part of check-in [7a01836d] Begin adding the zeroblob API to support incremental blob i/o. (CVS 3894) (check-in: [7a01836d] user: drh branch: trunk, size: 18393)
2007-03-30
11:23
[4b19fd8f] part of check-in [6b995259] Remove the anonymous union from the sqlite3_value structure since some compilers are unable to deal with it. (CVS 3758) (check-in: [6b995259] user: drh branch: trunk, size: 18270)
2007-03-26
22:05
[b2ca85ca] part of check-in [0b832e21] Modify sources to that they can be combined into a single sqlite3.c source file. Eliminate all type-pruned pointer warnings. (CVS 3722) (check-in: [0b832e21] user: drh branch: trunk, size: 18227)
2007-01-26
21:08
[13ba0712] part of check-in [93edd3b0] Make sure the vdbeInt.h file is not #included multiple times. Ticket #2194. (CVS 3608) (check-in: [93edd3b0] user: drh branch: trunk, size: 18179)
2006-11-09
00:24
[1ca07f2d] part of check-in [f1efae92] First cut at adding the sqlite3_prepare_v2() API. Test cases added, but more testing would be useful. Still need to update the documentation. (CVS 3506) (check-in: [f1efae92] user: drh branch: trunk, size: 18103)
2006-06-27
13:20
[e3eaab26] part of check-in [5612b287] Changes so that it will build with SQLITE_OMIT_VIRTUALTABLE=1. (CVS 3309) (check-in: [5612b287] user: drh branch: trunk, size: 17973)
2006-06-24
06:36
[37d74cc5] part of check-in [4acf7594] Clean up and clarify code in test8.c. (CVS 3289) (check-in: [4acf7594] user: danielk1977 branch: trunk, size: 18051)
2006-06-23
14:32
[be3396aa] part of check-in [a56bfa56] Allow xDestroy methods to execute "DROP TABLE" statements. (CVS 3287) (check-in: [a56bfa56] user: danielk1977 branch: trunk, size: 18051)
08:05
[de89a347] part of check-in [5d1d9071] Add tests and fixes for handling malloc() failures related to the virtual table feature. (CVS 3285) (check-in: [5d1d9071] user: danielk1977 branch: trunk, size: 17565)
2006-06-12
21:59
[6ccb7eaa] part of check-in [01096543] Added code to iterate through virtual tables. All regression tests pass but the new code is completely untested. (CVS 3219) (check-in: [01096543] user: drh branch: trunk, size: 17424)
2006-03-16
14:05
[85cd5f81] part of check-in [5048fae0] Make provisions in the code to support Provisions to support caching of serialized statements in the SSE extension. (CVS 3139) (check-in: [5048fae0] user: drh branch: trunk, size: 17310)
2006-02-24
02:53
[2109be6b] part of check-in [4b22e4b8] Remove unused parameters on internal APIs. Suppress warnings from CodeWarrior. (CVS 3110) (check-in: [4b22e4b8] user: drh branch: trunk, size: 17137)
2006-01-20
15:45
[eb3f86ab] part of check-in [fd4a6bb1] Fix and test the processing of sqlite3_result_error() withing aggregate functions. Allow errors to come from the step function (a new capability). Ticket #1632. (CVS 2981) (check-in: [fd4a6bb1] user: drh branch: trunk, size: 17155)
2006-01-07
18:48
[5451cf71] part of check-in [0ae46131] Invalidate all VDBE cursor row caches in between calls to sqlite3_step() since the emphemeral content that those caches point to might change if the statement is READ UNCOMMITTED. (CVS 2886) (check-in: [0ae46131] user: drh branch: trunk, size: 17156)
2005-12-29
19:23
[9b78ba00] part of check-in [ae301db8] Add serial-types 8 and 9 for integer constants of 0 and 1 that use zero bytes of storage. Make the default file format 4. Add the SQLITE_DEFAULT_FILE_FORMAT compile-time option to lower the default file format number so that newly created databases can be read and written by older versions of SQLite. (CVS 2845) (check-in: [ae301db8] user: drh branch: trunk, size: 16966)
2005-12-15
15:22
[7b8b8c5d] part of check-in [36229018] Add the sqlite3_update_hook() API. (CVS 2820) (check-in: [36229018] user: danielk1977 branch: trunk, size: 16876)
2005-11-25
02:43
[0055c37e] part of check-in [4dd7cfaa] Preserve 64-bit last insert rowids across triggers. (CVS 2779) (check-in: [4dd7cfaa] user: drh branch: trunk, size: 16800)
2005-11-14
22:29
[7824d7be] part of check-in [ce06c123] Create separate affinities for INTEGER and REAL. (CVS 2766) (check-in: [ce06c123] user: drh branch: trunk, size: 16800)
2005-11-01
15:48
[6eba0b96] part of check-in [e0d6f61c] Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now of type real, though an integer representation is still sometimes used internally for efficiency. (CVS 2753) (check-in: [e0d6f61c] user: drh branch: trunk, size: 16766)
2005-09-19
12:53
[7bedbb95] part of check-in [b2d1803c] Work around limitations of MSVC++ 6. Tickets #1429, #1437, and #1440. (CVS 2720) (check-in: [b2d1803c] user: drh branch: trunk, size: 16727)
2005-09-07
22:09
[3dd2a29c] part of check-in [c3ac5859] Bug fixes in aggregate processing. Fewer tests fail. (CVS 2663) (check-in: [c3ac5859] user: drh branch: trunk, size: 16727)
21:22
[15a32128] part of check-in [17039ec3] Rewrite the aggregate handling logic so that it runs in O(1) space. This is the first cut at the code. Many regression tests fail. (CVS 2662) (check-in: [17039ec3] user: drh branch: trunk, size: 16717)
2005-09-06
20:36
[7a6b3c1a] part of check-in [7ecf3654] Cleanup the processing of MEM_Agg elements. (CVS 2660) (check-in: [7ecf3654] user: drh branch: trunk, size: 18035)
2005-09-01
12:16
[52811a51] part of check-in [81259a01] All regression tests now pass with the new bounded-memory sort code. There is still lots of opportunity for optimization, however. (CVS 2654) (check-in: [81259a01] user: drh branch: trunk, size: 18161)
03:07
[c9dcaec8] part of check-in [09db0a24] Sorting is now done using a sorting index rather than loading the entire result set into memory and doing a merge sort. The old merge sort technique was a carry-over from SQLite version 1. The new method uses a bounded amount of memory and scales to much larger result sets. There are still errors: some 39 regression tests fail. (CVS 2653) (check-in: [09db0a24] user: drh branch: trunk, size: 18114)
2005-08-29
23:00
[e5f2855b] part of check-in [ed2ca087] Increase resolution of time-of-day on unix. Add an experimental sqlite3_profile() API. (CVS 2639) (check-in: [ed2ca087] user: drh branch: trunk, size: 18694)
2005-08-24
17:07
[89a7fa5d] part of check-in [881dcf5f] Additional defense against the rowid-fifo overflow problem. (CVS 2622) (check-in: [881dcf5f] user: drh branch: trunk, size: 18617)
2005-07-08
13:08
[9be9a6c4] part of check-in [94c120bb] Replace OP_List with OP_Fifo. This is the first step toward allowing recursive delete triggers and later foreign keys with cascading deletes. (CVS 2538) (check-in: [94c120bb] user: drh branch: trunk, size: 18617)
2005-06-12
21:35
[4312faf4] part of check-in [36f2da1f] Update older opcode names to be more meaningful in light of the latest code design. (CVS 2506) (check-in: [36f2da1f] user: drh branch: trunk, size: 18193)
2005-04-01
10:47
[4afaae2f] part of check-in [e8391491] Make the ORDER BY clause return equal elements in the same order they were seen (a stable sort). It was returning them in exactly the reverse order. (CVS 2439) (check-in: [e8391491] user: drh branch: trunk, size: 18270)
2005-03-29
13:07
[97b62807] part of check-in [7e54d3c7] Change 'stack' to the more descriptive 'no-push' in vdbe.c. (CVS 2429) (check-in: [7e54d3c7] user: danielk1977 branch: trunk, size: 18211)
08:26
[39beecdf] part of check-in [7d6818da] Reduce the space allocated for the runtime virtual machine stack. (CVS 2428) (check-in: [7d6818da] user: danielk1977 branch: trunk, size: 18214)
2005-01-29
08:32
[e80721cd] part of check-in [b1b50f31] Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) (check-in: [b1b50f31] user: danielk1977 branch: trunk, size: 18178)
2005-01-22
03:03
[24d411de] part of check-in [df648d50] Add the experimental sqlite3_expired() API. (CVS 2263) (check-in: [df648d50] user: drh branch: trunk, size: 18054)
2005-01-12
09:10
[f2b5f54d] part of check-in [2b3e21ce] Tests to improve coverage of vdbeaux.c. (CVS 2201) (check-in: [2b3e21ce] user: danielk1977 branch: trunk, size: 17984)
2004-12-07
12:29
[0f74561e] part of check-in [7b20f2b7] Remove the unused sqlite3_context.isStep element. (CVS 2156) (check-in: [7b20f2b7] user: drh branch: trunk, size: 17952)
2004-09-19
00:50
[6017100a] part of check-in [eb9b501a] Merge the ListPush and ListPop VDBE opcodes into ContextPush and ContextPop. (CVS 1972) (check-in: [eb9b501a] user: drh branch: trunk, size: 18007)
2004-09-06
17:24
[e09362d6] part of check-in [3ddf5a9d] Fix a naming conflict between sqlite versions 2 and 3. An open sqlite3 connection now *must* be called "sqlite3". You cannot call it "sqlite". This might break existing code. (CVS 1941) (check-in: [3ddf5a9d] user: drh branch: trunk, size: 17850)
2004-09-02
14:57
[f8df57a9] part of check-in [d1b29156] Transactions commit on the last sqlite3_step(), not on sqlite3_finalize(). This allows the sqlite3_step() to return SQLITE_BUSY if the commit is blocked by a lock. Ticket #885. (CVS 1928) (check-in: [d1b29156] user: drh branch: trunk, size: 17850)
2004-08-28
18:17
[aadadddc] part of check-in [5f8d2468] Memory handling fixes and optimizations in the VDBE. Ticket #862. (CVS 1909) (check-in: [5f8d2468] user: drh branch: trunk, size: 17903)
2004-08-21
17:54
[16322cbf] part of check-in [bd6649c5] Optimizations to the code generator. (CVS 1899) (check-in: [bd6649c5] user: drh branch: trunk, size: 17848)
2004-08-20
16:02
[5e57e36a] part of check-in [d3be0b7c] Add support for named wildcards in SQL statements. (CVS 1897) (check-in: [d3be0b7c] user: drh branch: trunk, size: 18145)
2004-07-24
14:35
[3d8e08c5] part of check-in [6db3f122] Fix more problems with deferred execution of CREATE. Still need to do DROP. There is now a memory leak. (CVS 1865) (check-in: [6db3f122] user: drh branch: trunk, size: 18034)
2004-06-30
11:14
[7160653a] part of check-in [0fedf74e] When a statement causes a ROLLBACK due to an ON CONFLICT clause, other active VMs abort. (CVS 1778) (check-in: [0fedf74e] user: drh branch: trunk, size: 18001)
2004-06-27
01:56
[d83fd738] part of check-in [ad65c6e2] Fix a bug in the handling of Mems inside of vdbe.c. (CVS 1745) (check-in: [ad65c6e2] user: drh branch: trunk, size: 17922)
2004-06-22
22:04
[22ab717b] part of check-in [e17ea666] Be careful to initialize the Mem.xDel field to zero for static Mems. (CVS 1671) (check-in: [e17ea666] user: drh branch: trunk, size: 17856)
12:13
[0b8eda5e] part of check-in [d98b1502] Patch around compilers that do not support "long long int". (CVS 1656) (check-in: [d98b1502] user: drh branch: trunk, size: 17856)
2004-06-21
10:45
[c0740932] part of check-in [4d02df63] Avoid opening a temp table for aggregate queries with no GROUP BY clause. (CVS 1649) (check-in: [4d02df63] user: danielk1977 branch: trunk, size: 17866)
06:50
[4d56da61] part of check-in [ae2f4a09] Update sqlite3_changes() to match the documentation and add sqlite3_total_changes(). (CVS 1645) (check-in: [ae2f4a09] user: danielk1977 branch: trunk, size: 17995)
2004-06-19
15:40
[d007ccad] part of check-in [70680a34] Clear up another zero-length array. This seems to fix the segfault in func-13.4 too. (CVS 1641) (check-in: [70680a34] user: drh branch: trunk, size: 17942)
15:22
[e472de98] part of check-in [fbfc3c95] Fix problems with the WatCom C compiler: Arrays must contain at least one element. sqlite3FreeX declared properly. Don't allow run-time expression (the SQLITE_UTF16NATIVE macro) in an array initializer. (CVS 1640) (check-in: [fbfc3c95] user: drh branch: trunk, size: 17895)
2004-06-18
06:02
[54af2e00] part of check-in [960f55f3] Fix a couple of gcc warnings. (CVS 1615) (check-in: [960f55f3] user: danielk1977 branch: trunk, size: 17101)
04:24
[96a6e88b] part of check-in [39a415ea] Optimisation for unicode encoding conversion routines. (CVS 1614) (check-in: [39a415ea] user: danielk1977 branch: trunk, size: 17061)
2004-06-15
13:36
[4e636b1b] part of check-in [59db58eb] Memory leak fixes for tests in file select1.test. (CVS 1599) (check-in: [59db58eb] user: danielk1977 branch: trunk, size: 16957)
11:40
[0aabcc77] part of check-in [e21a1813] Minor bugfixes and test case adjustments for version 2 test cases to work with version 3. (CVS 1598) (check-in: [e21a1813] user: danielk1977 branch: trunk, size: 17091)
2004-06-12
20:12
[ffc7b8ed] part of check-in [e42316f5] Speed up in the handling of VDBE cursors. (CVS 1578) (check-in: [e42316f5] user: drh branch: trunk, size: 17161)
18:12
[1cc767a6] part of check-in [f687977a] Improve the speed of OP_Column through better caching. (CVS 1577) (check-in: [f687977a] user: drh branch: trunk, size: 17095)
09:25
[c4ff480c] part of check-in [5903f538] (1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) (check-in: [5903f538] user: danielk1977 branch: trunk, size: 16895)
2004-06-11
13:19
[57b7001b] part of check-in [8d56118f] Have the vdbe aggregator use a btree table instead of a hash table. (CVS 1569) (check-in: [8d56118f] user: danielk1977 branch: trunk, size: 16769)
10:51
[e27e29ff] part of check-in [66835ee6] Fix various collation sequence issues. (CVS 1568) (check-in: [66835ee6] user: danielk1977 branch: trunk, size: 16458)
2004-06-09
21:01
[d4160585] part of check-in [39b4ba95] If a commit fails due to lock contention right after the COMMIT command, take the database back out of autocommit mode. Do not rollback. This gives the user the chance to try the COMMIT again. (CVS 1551) (check-in: [39b4ba95] user: drh branch: trunk, size: 16440)
2004-06-05
10:22
[ab592f23] part of check-in [c2899b43] Add the sqlite3_set_auxdata() and sqlite3_get_auxdata() APIs. (CVS 1532) (check-in: [c2899b43] user: danielk1977 branch: trunk, size: 16359)
2004-06-03
16:08
[9f5df0a2] part of check-in [d57e5252] Untested updates to support atomic multi-file transactions (CVS 1526) (check-in: [d57e5252] user: danielk1977 branch: trunk, size: 16138)
2004-06-02
01:22
[f19df224] part of check-in [165d69a0] Work toward combining the OP_MakeKey, OP_MakeIdxKey, and OP_MakeRecord opcodes into one. The work is incomplete. (CVS 1524) (check-in: [165d69a0] user: drh branch: trunk, size: 16131)
2004-05-31
18:51
[5d357541] part of check-in [adf7e29f] Change all SQLITE3 preprocessor macros to SQLITE. Documentation updates. (CVS 1511) (check-in: [adf7e29f] user: drh branch: trunk, size: 16195)
08:26
[51d37798] part of check-in [b8ed812c] Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) (check-in: [b8ed812c] user: danielk1977 branch: trunk, size: 16200)
2004-05-28
08:21
[c2bcd6e5] part of check-in [1b15b32b] Tables and indices use the same record format. (CVS 1482) (check-in: [1b15b32b] user: drh branch: trunk, size: 16268)
01:39
[57b64910] part of check-in [321f8c46] Remove the encoding argument from sqlite3VdbeSerialGet. Use the 32-bit version of sqlite3GetVarint for schema-level parameters. (CVS 1480) (check-in: [321f8c46] user: drh branch: trunk, size: 16168)
2004-05-27
19:59
[0c30699e] part of check-in [0c4d1388] Change the record format to include an extra varint at the beginning to record the number of bytes in the header. (CVS 1478) (check-in: [0c4d1388] user: drh branch: trunk, size: 16181)
09:28
[fab8bb7f] part of check-in [67a140cf] Various bugfixes. 68 Test cases still fail. (CVS 1471) (check-in: [67a140cf] user: danielk1977 branch: trunk, size: 16170)
03:12
[8941eb55] part of check-in [f33d15d9] Fixes to the MEM changes. The library now links. (CVS 1470) (check-in: [f33d15d9] user: drh branch: trunk, size: 16110)
01:53
[d62f70eb] part of check-in [dbdd1a7f] More MEM changes in the vdbe.c. Still will not compile. (CVS 1469) (check-in: [dbdd1a7f] user: drh branch: trunk, size: 16066)
2004-05-26
23:43
[8647afb4] part of check-in [68ef1702] Break Mem.flags into Mem.type and Mem.enc. (CVS 1466) (check-in: [68ef1702] user: drh branch: trunk, size: 15795)
23:25
[d7eda240] part of check-in [bba6684d] Refactoring of the vdbe Mem functions and the APIs that deal with them. The code will not compile in its current state. (CVS 1465) (check-in: [bba6684d] user: drh branch: trunk, size: 17785)
13:27
[1064ce17] part of check-in [ce8b1520] Ensure the type of an sqlite3_value* is not modified by calls to sqlite3_value_*() calls. (CVS 1463) (check-in: [ce8b1520] user: danielk1977 branch: trunk, size: 18739)
10:11
[653525b1] part of check-in [d5659f2e] Add some tests for the new API. Many more to come. (CVS 1462) (check-in: [d5659f2e] user: danielk1977 branch: trunk, size: 17754)
02:04
[c8706615] part of check-in [17e7db48] Use the new API calls more consistently. (CVS 1459) (check-in: [17e7db48] user: danielk1977 branch: trunk, size: 17644)
2004-05-25
12:05
[e500998a] part of check-in [8f6b20c2] Change a couple of symbol names for the new user function API. (CVS 1454) (check-in: [8f6b20c2] user: danielk1977 branch: trunk, size: 17641)
11:47
[a9a105b9] part of check-in [4eccae03] Use the new API for returning values and errors from user functions. (CVS 1453) (check-in: [4eccae03] user: danielk1977 branch: trunk, size: 17637)
01:13
[4dfeaaf7] part of check-in [b77c268e] Add manifest type aware versions of the min() and max() aggregates. (CVS 1452) (check-in: [b77c268e] user: danielk1977 branch: trunk, size: 16335)
2004-05-24
23:48
[7084fc1b] part of check-in [5c28ed5e] Aggregate functions also use sqlite_value* instead of const char * for arguments. (CVS 1451) (check-in: [5c28ed5e] user: danielk1977 branch: trunk, size: 16297)
2004-05-23
13:30
[6c2444a6] part of check-in [f47de3a9] Begin changing the vdbe so all stack values use the database encoding. (CVS 1444) (check-in: [f47de3a9] user: danielk1977 branch: trunk, size: 16283)
2004-05-22
21:30
[e3f2643c] part of check-in [18e690e4] Remove the OP_SetInsert opcode. (CVS 1443) (check-in: [18e690e4] user: drh branch: trunk, size: 14863)
03:05
[f40e8048] part of check-in [c4a82468] Steps towards UTF-16 databases. Some tests are failing because of this commit. (CVS 1433) (check-in: [c4a82468] user: danielk1977 branch: trunk, size: 14970)
2004-05-21
10:08
[8ed2272e] part of check-in [fc94575d] Further work on the new API. All the functions to execute queries are there now. (CVS 1427) (check-in: [fc94575d] user: danielk1977 branch: trunk, size: 14868)
2004-05-20
22:16
[cea492c1] part of check-in [a6cb09d7] Add internal support for collating sequences. This breaks 244 tests. (CVS 1420) (check-in: [a6cb09d7] user: drh branch: trunk, size: 14668)
13:54
[69a7dd04] part of check-in [5c1e47a2] sqlite3MemCompare now takes a CollSeq* argument. (CVS 1419) (check-in: [5c1e47a2] user: drh branch: trunk, size: 14525)
01:12
[97b95c62] part of check-in [e8f980d8] Add support for the new sqlite3_bind_*() APIs. (CVS 1410) (check-in: [e8f980d8] user: danielk1977 branch: trunk, size: 14499)
2004-05-19
14:56
[faaa6443] part of check-in [8f249c45] Change opcode names and comments to better describe the operation of the incrKey flag. OP_MoveTo becomes OP_MoveGe. (CVS 1407) (check-in: [8f249c45] user: drh branch: trunk, size: 14423)
11:24
[3f76e27b] part of check-in [45169ce0] Variable name change: azVar to apVar. (CVS 1404) (check-in: [45169ce0] user: drh branch: trunk, size: 14428)
10:36
[2097f78f] part of check-in [f71844bc] Tests for text encoding conversion functions. Also new sqlite3_bindXX APIs. (CVS 1403) (check-in: [f71844bc] user: danielk1977 branch: trunk, size: 14433)
2004-05-18
22:38
[5bac5f0f] part of check-in [ae37e8a0] Remove dead code from vdbeaux.c. Add comments describing desired changes to OP_Sort processing in select.c (CVS 1398) (check-in: [ae37e8a0] user: drh branch: trunk, size: 14574)
10:06
[b4ad3993] part of check-in [ad4a9641] Fix many problems with manifest types and column affinity. Most things are working now. (CVS 1393) (check-in: [ad4a9641] user: danielk1977 branch: trunk, size: 14604)
2004-05-16
11:15
[311c2a04] part of check-in [a4af838f] More changes to support the manifest type model. A few things are currently broken. (CVS 1385) (check-in: [a4af838f] user: danielk1977 branch: trunk, size: 14470)
2004-05-14
21:59
[67c3b2cf] part of check-in [d8bacc16] Allocates VDBE cursors one by one in separate memory so that pointers to cursors can persist through a realloc(). (CVS 1383) (check-in: [d8bacc16] user: drh branch: trunk, size: 14433)
21:12
[6740a3b8] part of check-in [8d9eab17] Cache record headers in the OP_Column opcode. (CVS 1382) (check-in: [8d9eab17] user: drh branch: trunk, size: 14432)
11:00
[03f4c364] part of check-in [dbfe6e93] Implement type affinity for table and index records (CVS 1375) (check-in: [dbfe6e93] user: danielk1977 branch: trunk, size: 13998)
2004-05-13
12:32
[d53f3807] part of check-in [da9b3dce] Change the OP_ListXX opcodes to use 64 bit integers (CVS 1372) (check-in: [da9b3dce] user: danielk1977 branch: trunk, size: 13928)
05:16
[66904cfb] part of check-in [9f2b6d9d] Manifest types in indices. At the moment indices use manifest typing, but some other parts of the SQL engine do not, which can lead to some strange results. (CVS 1368) (check-in: [9f2b6d9d] user: danielk1977 branch: trunk, size: 13928)
2004-05-12
15:15
[608a0b09] part of check-in [fb3c8030] Btree uses signed integers for the rowid. The intToKey() and keyToInt() macros are now no-ops. (CVS 1364) (check-in: [fb3c8030] user: drh branch: trunk, size: 13804)
07:33
[3610b51a] part of check-in [0242c9e4] Change the table record format to support manifest typing. (CVS 1361) (check-in: [0242c9e4] user: danielk1977 branch: trunk, size: 13937)
2004-05-11
03:11
[ff85e432] part of check-in [2fffd133] Internal symbols MEM_Dyn and MEM_AggCtx were defined as the same bit pattern. Change MEM_AggCtx to 0x1000. (CVS 1350) (check-in: [2fffd133] user: danielk1977 branch: trunk, size: 13898)
2004-05-10
23:29
[d5786e1c] part of check-in [bc5a2daf] Work toward getting the new btree.c integrated with vdbe.c. (CVS 1345) (check-in: [bc5a2daf] user: drh branch: trunk, size: 13898)
12:07
[2567223b] part of check-in [3af283f4] Add flags values to the Mem structure to accomodate BLOBs and to show the representation of strings. (CVS 1341) (check-in: [3af283f4] user: drh branch: trunk, size: 13841)
10:37
[742e2576] part of check-in [19b100ec] Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1339) (check-in: [19b100ec] user: danielk1977 branch: trunk, size: 13175)
07:17
[e4ab46c2] part of check-in [8a66a502] Add versions of OP_MakeRecord and OP_Column that use manifest typing (not activated yet). (CVS 1334) (check-in: [8a66a502] user: danielk1977 branch: trunk, size: 13174)
2004-05-09
23:23
[19926d40] part of check-in [d8d1c91e] Add a temporary sqlite2BtreeKeyCompare() function to help get regression tests passing again. (CVS 1332) (check-in: [d8d1c91e] user: danielk1977 branch: trunk, size: 13021)
2004-05-08
08:23
[4563dc1c] part of check-in [8af6474c] Change lots of internal symbols from sqliteXXX to sqlite3XXX so that the library links again. It doesn't work yet, due to changes in the btree layer calling convention. (CVS 1324) (check-in: [8af6474c] user: danielk1977 branch: trunk, size: 12949)
2004-02-20
22:53
[b40ff02c] part of check-in [3383413a] Fixed behaviour of last_insert_rowid() with triggers and add last_statement_change_count() function that works correctly with triggers. (CVS 1251) (check-in: [3383413a] user: rdc branch: trunk, size: 12934)
2004-02-14
23:59
[af83bd70] part of check-in [2dbc4593] Eliminate obsolete code associated with the older callback functionality. (CVS 1243) (check-in: [2dbc4593] user: drh branch: trunk, size: 12217)
2004-01-31
19:22
[8a3baf74] part of check-in [8273c74b] Rework internal data structures to make the VDBE about 15% smaller. (CVS 1203) (check-in: [8273c74b] user: drh branch: trunk, size: 12396)
2004-01-30
14:49
[6f12f5b9] part of check-in [c0faa1c6] Rework the VDBE data structures to combine string representations into the same structure with integer and floating point. This opens the door to significant optimizations. (CVS 1202) (check-in: [c0faa1c6] user: drh branch: trunk, size: 12599)
2004-01-07
18:52
[eab39bc2] part of check-in [d3e96da2] Defer the {quote: MoveTo} opcode in VDBE until the data is actually needed. Sometimes the data is never needed, resulting in a performance increase. On an indexed order search with a large OFFSET, queries times can be an order of magnitude faster. (CVS 1165) (check-in: [d3e96da2] user: drh branch: trunk, size: 13088)
2003-09-06
22:18
[2824bf88] part of check-in [990bb118] Update Makefile.in for the new vdbeaux.c file. Remove the experimental "sqlite_instantiate()" routine and replace it with "sqlite_bind()" which is more like ODBC and JDBC. (CVS 1095) (check-in: [990bb118] user: drh branch: trunk, size: 12479)
20:12
Added: [15cd0106] part of check-in [bfd69391] Split almost 1300 lines of code out of vdbe.c into separate files vdbeInt.h and vdbeaux.c. (CVS 1094) (check-in: [bfd69391] user: drh branch: trunk, size: 12345)