/ File History
Login

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

History of src/vdbeInt.h

2019-05-02
17:45
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. file: [3ba14553] check-in: [48889530] user: drh branch: trunk, size: 26491
2019-05-01
18:59
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]. file: [0e2c4495] check-in: [5997d075] user: drh branch: trunk, size: 26491
2019-04-26
17:20
An experimental interface for retrieving the estimated cost and estimated number of output rows for a query. file: [a9089cdf] check-in: [1b25fa10] user: drh branch: cost-est, size: 26590
2019-04-07
18:04
Fix a faulty assert() in the sqlite3VdbeMemExpandBlob() routine. file: [2c12704d] check-in: [df58774e] user: drh branch: trunk, size: 26449
2019-04-02
00:56
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. file: [d0c78ec6] check-in: [f7ba2daf] user: drh branch: trunk, size: 26307
2019-03-29
11:13
Initial implementation of the sqlite3_value_frombind() interface. file: [5ea6f654] check-in: [98da62df] user: drh branch: value_frombind, size: 26307
2018-12-28
20:48
Faster allocation of new sqlite3_stmt objects. file: [a76d5eed] check-in: [891f1f72] user: drh branch: trunk, size: 26267
20:14
Move the nOpAlloc field from Parse into Vdbe to avoid an extra pointer deference on the fast path in sqlite3VdbeAddOp3(). file: [24975074] check-in: [8f10efc2] user: drh branch: trunk, size: 26267
2018-12-19
17:05
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. file: [e5080801] check-in: [553a923c] user: dan branch: branch-3.19, size: 24443
16:03
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. file: [b4c31fcd] check-in: [4cb67252] user: dan branch: branch-3.9, size: 22713
2018-12-14
21:58
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. file: [fad23d9a] check-in: [33a1924e] user: drh branch: custom-destructors, size: 26272
20:20
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) file: [538f6a69] check-in: [b29e02f8] user: drh branch: branch-3.8.9, size: 22370
2018-12-07
16:32
Fix the sqlite3_normalized_sql() interface so that it renders double-quoted string literals as "?". file: [73f50519] check-in: [0d8e1504] user: drh branch: trunk, size: 26209
2018-11-17
18:45
Merge latest trunk changes into this branch. file: [edfb25fc] check-in: [9fdd1868] user: dan branch: reuse-schema1, size: 25515
14:26
Fix harmless compiler warnings that appear with SQLITE_OMIT_EXPLAIN. file: [437e6c6a] check-in: [5fff00b0] user: drh branch: trunk, size: 25457
2018-11-15
21:20
Fix some problems with the feature on this branch. Many problems remain. file: [f7ffb424] check-in: [31b6aee7] user: dan branch: reuse-schema1, size: 25445
2018-10-29
17:53
Add the sqlite3_normalized_sql() API. file: [8a52b8db] check-in: [592b66e8] user: mistachkin branch: normalized_sql, size: 25387
2018-08-29
20:24
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. file: [f1f35f70] check-in: [f48e9feb] user: drh branch: trunk, size: 25271
18:47
Free up the MEM_Frame bit in Mem.flags object. Store VdbeFrame objects as MEM_Blob with a special Mem.xDel pointer instead. file: [a660268d] check-in: [62db5fd4] user: drh branch: trunk, size: 25307
2018-08-04
16:54
Remove more column-cache residue: The OP_SetColTab and OP_VerifyColTab opcodes and the associated SQLITE_DEBUG_COLUMNCACHE logic. file: [8ea493d9] check-in: [80236e81] user: drh branch: omit-column-cache, size: 24962
2018-07-24
22:02
Do not abort running queries due to a CREATE INDEX statement. Allow them to run to completion before being reprepared. Fix for ticket [c694113e50321afdf9]. file: [2a45270d] check-in: [2bd59333] user: drh branch: trunk, size: 25152
2018-06-22
20:51
Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. file: [6b5cbd33] check-in: [5f04b016] user: dan branch: exp-window-functions, size: 25142
2018-06-14
14:30
Merge latest trunk changes into this branch. file: [d99f1c3d] check-in: [5cf5f180] user: dan branch: exp-window-functions, size: 25104
2018-06-13
16:52
Pad out the sqlite3_value structure to be a multiple of 8 bytes. file: [5d6f9294] check-in: [f76dc33b] user: drh branch: trunk, size: 25054
2018-06-12
13:52
Improvements to SCopy correctness tracking when SQLITE_DEBUG is enabled. file: [4531c172] check-in: [b2973f23] user: drh branch: trunk, size: 24981
2018-06-11
17:35
Add the OP_SetTabCol and OP_VerifyTabCol opcodes, only when compiling with SQLITE_DEBUG, to do run-time verification of the column cache. file: [8ebc37ea] check-in: [b37614a3] user: drh branch: trunk, size: 24973
2018-06-07
20:35
Merge latest trunk changes with this branch. file: [83fefe12] check-in: [25102203] user: dan branch: exp-window-functions, size: 25006
2018-06-05
20:45
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. file: [d299d7a1] check-in: [6bf251af] user: drh branch: multikey-opt-idea, size: 24956
2018-06-04
08:28
Merge latest trunk changes into this branch. file: [16884542] check-in: [83d6416a] user: dan branch: exp-window-functions, size: 24931
2018-05-28
17:31
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. file: [42d3e65e] check-in: [5a4542db] user: drh branch: stmt-journal-testing, size: 24881
2018-05-16
20:58
Start of experimental implementation of SQL window functions. Does not yet work. file: [3878856f] check-in: [3781e520] user: dan branch: exp-window-functions, size: 24640
2018-02-26
15:27
Always interpret non-zero floating-point values as true even if their integer part is zero. Fix for ticket [36fae083b450e3af857a459e20]. file: [95f7adfd] check-in: [a983fa85] user: drh branch: trunk, size: 24590
2018-01-23
03:44
Slightly faster function dispatch in the virtual machine by avoiding unnecessary reinitialization of variables that are already correctly initialized. file: [8d7d07f1] check-in: [edd4e687] user: drh branch: trunk, size: 24543
2018-01-16
21:05
Remove an unused field from the internal definition of the sqlite3_context object. file: [c8cfbbc2] check-in: [948a26b5] user: drh branch: trunk, size: 24729
2018-01-12
21:00
Add the experimental sqlite3_value_nochange() interface usable by xUpdate methods of virtual tables to see if a column has actually changed values. file: [5442fc81] check-in: [8b7be15e] user: drh branch: sqlite3_value_nochange, size: 24808
2018-01-11
17:04
Add the sqlite3_vtab_nochange() method which virtual table implementations can use to optimize UPDATEs. file: [a0969c14] check-in: [d444b1ff] user: drh branch: sqlite3_vtab_nochange, size: 24693
2017-09-13
18:38
Experimental sqlite3_stmt_retryable() interface. file: [207b6ac7] check-in: [ebada072] user: drh branch: sqlite3_stmt_retryable, size: 24692
2017-08-16
19:20
Avoid a test for CURTYPE_BTREE in sqlite3VdbeCursorMoveto() in order to reduce the size and improve the performance of OP_Column. file: [1fe00770] check-in: [f078deb2] user: drh branch: trunk, size: 24614
2017-07-27
15:53
Improved implementation of the destructor on pointer-passing interfaces. file: [ff2b7db0] check-in: [601ad679] user: drh branch: pointer-with-destructor, size: 24589
03:48
Add a destructor argument to sqlite3_bind_pointer() and sqlite3_result_pointer(). file: [4f703405] check-in: [3d9e841f] user: drh branch: pointer-with-destructor, size: 24708
2017-07-21
07:56
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]. file: [b8770095] check-in: [8201f4e1] user: drh branch: branch-3.18, size: 24433
07:45
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]. file: [7209dc72] check-in: [69906880] user: drh branch: branch-3.9.2, size: 22713
04:08
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]. file: [7738dd1d] check-in: [5a3022e0] user: drh branch: branch-3.8.10, size: 22252
03:23
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]. file: [0d54df38] check-in: [a66a5b39] user: drh branch: branch-3.8.6, size: 21325
03:09
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. file: [0fb63a81] check-in: [f0f49224] user: drh branch: branch-3.7.11, size: 21320
2017-07-20
16:55
Experimental API sqlite3_stmt_refresh() to force a prepared statement to recompile if it needs to due to a schema change or other factor. file: [e202dc9f] check-in: [10556ee4] user: drh branch: sqlite3_stmt_refresh, size: 24519
2017-07-17
00:40
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. file: [19bd04a4] check-in: [211cce04] user: drh branch: pointer-types, size: 24444
2017-07-15
10:44
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. file: [8912bdbc] check-in: [d6a44b35] user: drh branch: branch-3.17, size: 24347
2017-07-13
17:34
Merge the latest changes from trunk. file: [36b162cc] check-in: [a54be6e0] user: drh branch: bind-pointer, size: 24431
2017-07-12
12:19
Compile cleanly with SQLITE_OMIT_UTF16. file: [c8b3d970] check-in: [783100b8] user: drh branch: trunk, size: 24312
2017-07-05
16:20
Make use of covering indexes in the OR optimization. file: [d9637010] check-in: [fcbd6abd] user: drh branch: branch-3.8.9, size: 22371
2017-06-30
23:09
Add APIs for binding pointers that can be used by app-defined functions. file: [7420cd23] check-in: [d9f4a831] user: drh branch: bind-pointer, size: 24394
2017-06-29
15:24
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. file: [8dd7548d] check-in: [03977248] user: drh branch: trunk, size: 24275
12:49
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. file: [a2d03f8b] check-in: [b0b0c8f8] user: drh branch: stmts-vtab, size: 24287
2017-06-01
00:54
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. file: [ba7a9436] check-in: [4a25c588] user: drh branch: prepare_v3, size: 24275
2017-05-30
18:34
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. file: [cdcdabad] check-in: [e972a386] user: drh branch: trunk, size: 24287
2017-05-10
19:42
Rename fields of the internal AuxData object to make them unique and easier to search for. file: [1ecdacc1] check-in: [2be9850c] user: drh branch: trunk, size: 24294
2017-04-09
19:23
Do not expose the name of the internal Mem object in the public interface defined by sqlite3.h. file: [c070bc5c] check-in: [19dd753f] user: drh branch: trunk, size: 24294
2017-03-24
17:59
Fix the OP_Once opcode so that it works correctly for recursive triggers. Ticket [06796225f59c057cd120f1]. file: [5db089ce] check-in: [25560145] user: drh branch: trunk, size: 24284
2017-02-18
20:05
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. file: [6186ba2b] check-in: [c1adf959] user: dan branch: sort-column-opcodes, size: 24294
2017-01-30
19:44
Experimental change to invoke the preupdate hook when WITHOUT ROWID tables are written. file: [4e4b15b2] check-in: [856f8604] user: dan branch: preupdate-without-rowid, size: 24228
2017-01-21
15:58
Add extra (somewhat inefficient) trace callbacks for triggers if SQLITE_TRACE_TRIGGER is defined. file: [4cad10b6] check-in: [ffda1d1e] user: dan branch: trigger-trace, size: 24319
2016-12-23
03:59
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. file: [281cb703] check-in: [68ecafa1] user: drh branch: VList, size: 24154
2016-12-10
12:58
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. file: [42e498db] check-in: [8165f88b] user: drh branch: trunk, size: 24215
2016-11-25
19:18
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. file: [9b498d3c] check-in: [49ebc219] user: drh branch: trunk, size: 24131
2016-11-09
20:14
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. file: [29b25318] check-in: [345b46be] user: drh branch: unpacked-IdxInsert, size: 24135
2016-10-21
21:21
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. file: [d8a56a49] check-in: [b861328a] user: dan branch: sessions-fix, size: 23905
2016-10-01
00:37
Avoid unnecessary zeroing of fields in the Vdbe object when it is allocated. file: [0a18713d] check-in: [1e21bbe8] user: drh branch: trunk, size: 23904
2016-09-29
15:53
Clarification and typo-fixes in comments. No changes to code. file: [581b737c] check-in: [e2cd79aa] user: drh branch: trunk, size: 23715
2016-09-18
16:08
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]. file: [d21f1472] check-in: [6bf5ba10] user: drh branch: trunk, size: 24189
2016-07-09
16:14
Fix various internal #defines to conform to new C-language naming restrictions, specifically that private-use macros names must not begin with "_". file: [c5938104] check-in: [5471aca0] user: drh branch: trunk, size: 24432
2016-03-30
12:56
Avoid compiler warnings and excess opcodes when SQLITE_ENABLE_PREUPDATE_HOOK is not used. Fix the EXPLAIN output for P4_TABLE opcodes. file: [ddb15797] check-in: [5ab46d76] user: drh branch: sessions, size: 24417
2016-03-16
01:16
Merge all recent enhancements from trunk. file: [9b704336] check-in: [6a7ee04b] user: drh branch: sessions, size: 24388
00:36
Rearrange some internal fields in the sqlite3_stmt object to avoid a harmless TSAN warning. file: [f88d3115] check-in: [e0b116ed] user: drh branch: trunk, size: 23438
2016-03-04
16:42
Merge recent enhancements from trunk. Default page size is 4096. Writes to statement journals are avoided. file: [a205ce1e] check-in: [456df336] user: drh branch: sessions, size: 24388
2016-02-26
04:13
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. file: [49a74fe5] check-in: [3ef6a315] user: drh branch: trunk, size: 23438
2016-02-25
18:54
Merge all the latest changes from trunk. file: [177eca5a] check-in: [b8659004] user: drh branch: sessions, size: 24395
2016-02-22
16:04
Always use the sqlite3VdbeDeleteAuxdata() routine for clearing auxdata on function parameter, rather than having a separate deleteAuxdataFromFrame() for doing the job for trigger frames. file: [84827a80] check-in: [64386fa3] user: drh branch: trunk, size: 23445
2016-02-19
18:54
Use a separate list of aux-data structures for each trigger program at the VDBE level. Fix for [dc9b1c91]. file: [581e5bff] check-in: [c4295725] user: dan branch: trunk, size: 23431
2016-02-02
02:22
Merge all recent enhancements from trunk. file: [2a8796b0] check-in: [f3f92001] user: drh branch: sessions, size: 24314
2016-01-30
15:46
A different way to clear the subtype on VDBE registers when the value of the register is overwritten with new content. To fix [[f45ac567eaa9f93]. file: [4b69d545] check-in: [2e9fb129] user: dan branch: clear-subtype-flag, size: 23364
14:53
Take care to clear the subtype on VDBE registers when the value of the register is overwritten with new content. file: [6c34fac6] check-in: [ec653cbc] user: drh branch: clear-subtype-fail, size: 23592
13:32
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. file: [716df83a] check-in: [85c46704] user: drh branch: trunk, size: 23178
2016-01-29
20:58
Different comment on the alternative cursor fields of VdbeCursor. file: [171fdc5f] check-in: [6e3dcb6d] user: drh branch: covering-or, size: 23104
19:29
Experimental attempt to make better use of covering indexes within OR queries. file: [91f22c4d] check-in: [a323ac3a] user: dan branch: covering-or, size: 23048
2016-01-27
15:49
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. file: [40c72871] check-in: [dde1db0d] user: drh branch: fordelete-assert, size: 23021
2016-01-11
13:10
Merge recent enhancements, and especially the WAL overwrite change, from trunk. file: [1bff4eff] check-in: [c4a858b2] user: drh branch: sessions, size: 23897
2016-01-07
16:06
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. file: [42eefa4f] check-in: [d0214602] user: dan branch: shared-cache-fix, size: 22947
2015-12-17
19:17
Make the VdbeCursor object even smaller. But the resulting library is bigger and slower than trunk. This branch is a failed experiment. file: [06caadd9] check-in: [896a06cc] user: drh branch: optimize-vdbecursor, size: 22918
17:30
Reduce the size of the VdbeCursor object by a pointer (the pBt pointer used for ephemeral tables). file: [6c879b49] check-in: [98b710c3] user: drh branch: optimize-vdbecursor, size: 22825
2015-12-02
20:40
Merge recent enhancements from trunk. file: [4f3b4680] check-in: [d1a1278d] user: drh branch: sessions, size: 23843
2015-11-20
19:22
Refactor the VdbeCursor object. It is now slightly smaller and faster and is easier to understand. file: [75c2e82e] check-in: [9b1d174d] user: drh branch: trunk, size: 22893
2015-10-30
16:50
Merge all the latest enhancements from trunk. file: [d6ae6e64] check-in: [395a153f] user: drh branch: sessions, size: 23855
2015-10-16
20:53
Merge recent enhancements from trunk. Version now 3.9.1. file: [33403622] check-in: [26fa091d] user: drh branch: cursor-hints, size: 22905
14:54
Have the sqlite3VdbeSerialType() function go ahead and compute the serial length as well, since it is always needed. This avoids unnecessary calls to sqlite3VdbeSerialTypeLen(). file: [777dd76d] check-in: [2ad72be1] user: drh branch: trunk, size: 22610
14:23
Use a lookup table to compute the content length for serial types less than 128, for a 1.2% performance improvement. file: [5f813a19] check-in: [33957248] user: drh branch: trunk, size: 22604
2015-09-15
17:31
Merge enhancements from trunk. file: [c1508eb4] check-in: [66fe0683] user: drh branch: cursor-hints, size: 22859
2015-09-14
10:47
Merge the latest trunk enhancements. file: [42fa3450] check-in: [22ce9218] user: drh branch: sessions, size: 23514
2015-09-10
20:34
Experimental implementation of sqlite3_result_subtype() and sqlite3_value_subtype() interfaces. file: [8b867eac] check-in: [7b5be299] user: drh branch: subtypes, size: 22564
2015-08-13
21:43
Convert the hint expression of the CursorHint opcode into a string for display by EXPLAIN. file: [9ad955ca] check-in: [12640cb2] user: drh branch: cursor-hints-displayP4, size: 21906
21:32
Convert the hint expression of the CursorHint opcode into a string for display by EXPLAIN. file: [7258d75f] check-in: [20688471] user: drh branch: cursor-hints, size: 22808
2015-06-30
16:29
Merge all the latest enhancements from trunk. This merge include FTS5 and a number of notable performance enhancements. file: [963c87c4] check-in: [39936b33] user: drh branch: sessions, size: 23463
2015-06-26
18:16
Cache the sqlite3_context structure in the P4 operand of VDBE programs for faster SQL function dispatch. file: [8b54e01a] check-in: [2abc44eb] user: drh branch: trunk, size: 22513
2015-06-17
18:18
Merge all recent enhancements and fixes from trunk. file: [57197704] check-in: [199bfb67] user: drh branch: sessions, size: 23350
2015-06-05
15:59
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. file: [20295e48] check-in: [f167bba4] user: drh branch: column-usage-hint, size: 22400
2015-05-21
17:24
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]. file: [20e5edac] check-in: [b3bb660a] user: dan branch: branch-3.8.6, size: 21176
2015-05-20
22:01
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. file: [50e29824] check-in: [2007391c] user: drh branch: sessions-value-dup, size: 23239
21:28
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. file: [f0ccddac] check-in: [a7ee40c4] user: drh branch: value-dup, size: 22289
2015-05-19
22:42
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. file: [0c025e70] check-in: [0a0de8b7] user: drh branch: sessions, size: 23102
2015-05-15
04:13
Simplifications to error message processing. Fix a possible problem in error message formatting when vacuuming a database with a corrupt schema. file: [de3291a6] check-in: [56ef98a0] user: drh branch: trunk, size: 22152
2015-03-24
19:02
Merge all recent trunk enhancements into the sessions branch. file: [96e4303a] check-in: [54aaa6f2] user: drh branch: sessions, size: 23053
12:51
Replace the Vdbe.inVtabMethod field with the sqlite3.nVDestroy counter. file: [9cbaa84f] check-in: [9faefb96] user: drh branch: nVDestroy, size: 22103
2015-02-21
15:13
Merge all recent trunk changes into the sessions branch. file: [50fc184e] check-in: [f36bb5fa] user: drh branch: sessions, size: 23561
2015-02-13
12:05
Make sure the prepared statement auto-resets on extended error codes of SQLITE_BUSY and SQLITE_LOCKED even when compiled using SQLITE_OMIT_AUTORESET. file: [bb56fd19] check-in: [3c6ca414] user: drh branch: trunk, size: 22611
2014-11-18
21:20
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. file: [dc69f035] check-in: [f09055f3] user: drh branch: sessions, size: 23459
2014-11-06
04:42
Add the SQLITE_SCANSTAT_SELECTID metric. Use it to improve the ".stmtscan on" output in the shell. file: [9bb69ff2] check-in: [64ad5761] user: drh branch: scanstatus, size: 22509
03:55
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. file: [c32c1de2] check-in: [f9684000] user: drh branch: scanstatus, size: 22439
2014-11-03
11:25
Remove unused variable from struct WhereInfo. Add some explanatory comments to new code. file: [539ba284] check-in: [f5313e0c] user: dan branch: scanstatus, size: 22432
2014-11-01
21:00
Minor performance enhancements to SQLITE_ENABLE_STMT_SCANSTATUS code. file: [21570e5e] check-in: [f13d6ba8] user: dan branch: scanstatus, size: 22435
20:38
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. file: [ee8d44cb] check-in: [9ea37422] user: dan branch: scanstatus, size: 22370
2014-10-31
20:11
Add the experimental sqlite3_stmt_scanstatus() API. file: [284b2294] check-in: [6a9bab34] user: dan branch: scanstatus, size: 21951
14:53
Merge recent trunk enhancements, and in particular the improvements to the b-tree balancing logic, into the sessions branch. file: [18756149] check-in: [28b044a5] user: drh branch: sessions, size: 22679
2014-10-28
18:24
Modify the documentation for sqlite3_changes() to make it more testable. Add tests and minor fixes for the same. file: [acc36ac4] check-in: [41cdd0c4] user: dan branch: trunk, size: 21729
2014-10-23
17:26
Add debugging code to count the number of iterations of each loop made as part of statement execution. file: [0fdc28cf] check-in: [c6a5b67a] user: dan branch: debug-loopcounters, size: 22220
2014-10-14
13:41
Merge recent trunk micro-optimizations and the DESC index GROUP BY ORDER BY bug fix into the sessions branch. file: [7254c20b] check-in: [83d4114f] user: drh branch: sessions, size: 22627
2014-10-13
20:12
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. file: [e2a060a5] check-in: [4b3b65ee] user: drh branch: trunk, size: 21677
16:02
Reduce the CPU load imposed by sqlit3VdbeCursorMoveto() by factoring out some of its functions and by avoiding unnecessary calls. file: [90c0ae53] check-in: [c2799aec] user: drh branch: trunk, size: 21655
2014-10-12
22:37
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. file: [e1173bd7] check-in: [91384a7d] user: drh branch: trunk, size: 21612
2014-10-01
01:52
Merge the latest enhancements from trunk. file: [6d4bf3fd] check-in: [2695772c] user: drh branch: sessions, size: 22627
2014-09-30
12:33
Remove the SQLITE_ENABLE_TREE_EXPLAIN compile-time option. Add alternative debugging display routines: sqlite3TreeViewExpr(), sqlite3TreeViewExprList(), and sqlite3TreeViewSelect(). file: [0b97a319] check-in: [4ff51325] user: drh branch: trunk, size: 21677
2014-09-27
19:51
Merge recent trunk changes (performance enhancements) into the sessions branch. file: [7d151278] check-in: [497367cb] user: drh branch: sessions, size: 22777
2014-09-25
13:17
Simplifications to the SQL function and aggregate calling procedures. file: [bb7f7ecf] check-in: [3467049a] user: drh branch: trunk, size: 21827
2014-09-21
22:49
Merge all recent trunk changes into the sessions branch. file: [0e6e8d18] check-in: [6406b77f] user: drh branch: sessions, size: 22826
2014-09-19
00:43
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. file: [f177bed1] check-in: [5b9b8987] user: drh branch: Cplusplus-comment, size: 21876
2014-09-18
21:25
Add the Mem.szMalloc element to the Mem object and use it to keep track of the size of the Mem.zMalloc allocation. file: [1ac536d1] check-in: [9c09ac35] user: drh branch: trunk, size: 21824
18:55
Correct typos in comments. No changes to code. file: [1c31448d] check-in: [55879932] user: mistachkin branch: trunk, size: 21705
17:52
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. file: [45a0b4c5] check-in: [4c8c89d7] user: drh branch: trunk, size: 21725
2014-09-17
16:41
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. file: [f90b0de6] check-in: [fdddb477] user: drh branch: micro-optimizations, size: 21680
14:52
Improved interface to the Mem object handling. Small size reduction and performance increase. file: [9d398055] check-in: [4e437844] user: drh branch: micro-optimizations, size: 21622
2014-09-16
14:55
Remove an unused parameter from sqlite3VdbeIdxRowid(). This is cosmetic only as the C-compiler optimizers were already omitting this parameter on amalgamation builds. file: [dc1743de] check-in: [a10a6bba] user: drh branch: micro-optimizations, size: 21761
14:16
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. file: [0de8705e] check-in: [0be3019e] user: drh branch: micro-optimizations, size: 21771
2014-09-08
15:04
Merge support for large files on Android from trunk. file: [0dec00ac] check-in: [c2885c6b] user: drh branch: sessions, size: 22663
2014-09-06
16:39
Fix typos in comments. No code changes. file: [b4843c35] check-in: [e62aab5e] user: peter.d.reid branch: trunk, size: 21713
2014-09-02
15:49
Merge the latest trunk changes, including the multi-threaded sorter, into the sessions branch. file: [872d39f6] check-in: [d4cce2c7] user: drh branch: sessions, size: 22663
2014-08-29
14:40
Merge recent performance enhancements from trunk onto the threads branch. file: [cdc8e421] check-in: [35c44a3c] user: drh branch: threads, size: 21713
2014-08-27
14:14
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. file: [4653bb42] check-in: [6c1ee3e3] user: drh branch: trunk, size: 21730
2014-08-26
02:15
Merge recent performance enhancements and the CAST operator enhancements into the sessions branch. file: [6a50eb24] check-in: [08ae974a] user: drh branch: sessions, size: 22680
2014-08-25
22:43
Merge the CAST operator enhancements from trunk. file: [a1fcc0a0] check-in: [6c8f86e4] user: drh branch: threads, size: 21713
20:11
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. file: [df584004] check-in: [91d8a8d0] user: drh branch: trunk, size: 21730
13:27
Merge the recent performance enhancements implemented on trunk into the threads branch. file: [94f5cb24] check-in: [dfdc900f] user: drh branch: threads, size: 21676
11:20
Change the name of the VdbeMemRelease() macro to VdbeMemReleaseExtern() to more accurately reflect what it does. Performance enhancement to the sqlite3VdbeMemRelease() function. file: [20056cd5] check-in: [3ca5846d] user: drh branch: trunk, size: 21693
2014-08-23
17:21
Performance optimization in the applyAffinity() logic inside the VDBE. file: [764a055b] check-in: [25f2246b] user: drh branch: trunk, size: 21687
2014-07-29
12:40
Merge recent trunk changes, and especially the fix for the R-Tree problem described in ticket [d2889096e7bdeac6]. file: [5eee1752] check-in: [8f1beead] user: drh branch: sessions, size: 22634
2014-07-28
15:01
Merge recent trunk changes into the threads branch. file: [8870adf0] check-in: [163c247b] user: drh branch: threads, size: 21667
2014-07-25
18:01
Add constraints (enforced only when SQLITE_DEBUG is enabled) on the use of OP_Next and OP_Prev. file: [f5513f2b] check-in: [2230c74f] user: drh branch: trunk, size: 21684
2014-07-24
16:54
Merge all recent trunk changes into the threads branch. file: [5e925f50] check-in: [77068589] user: drh branch: threads, size: 21568
16:23
Merge recent trunk changes into the sessions branch. file: [31b5cb53] check-in: [a9db017e] user: drh branch: sessions, size: 22535
2014-07-22
20:02
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. file: [f41a7cf5] check-in: [77f412ca] user: drh branch: trunk, size: 21585
2014-06-30
20:25
Merge the latest trunk changes into the threads branch. file: [027a5757] check-in: [ae23a65e] user: drh branch: threads, size: 21503
20:02
Merge the latest trunk enhancements into the sessions branch. file: [3c295f44] check-in: [a5d94eab] user: drh branch: sessions, size: 22470
2014-06-28
14:28
Change the VDBE to export the sqlite3MemCompare() routine and thus free where.c from the dependency on vdbeInt.h. file: [5df5e9af] check-in: [d186d1ac] user: drh branch: stat4-skipscan, size: 21520
2014-04-18
13:40
Fix harmless compiler warnings. file: [c78ace64] check-in: [f8f72ecb] user: drh branch: threads, size: 21566
2014-04-03
16:35
Merge all recent changes from trunk, including the fix for the OP_SCopy-vs-OP_Copy problem. file: [c05d4572] check-in: [9515c834] user: drh branch: sessions, size: 22533
2014-04-01
18:41
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. file: [ba106962] check-in: [821d1ac4] user: dan branch: threads, size: 21588
2014-03-28
03:12
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. file: [e6d83e5b] check-in: [7fa85eaa] user: drh branch: trunk, size: 21583
2014-03-26
19:43
Merge in fixes (including the corrupt-database crash fix) and performance enhancements from trunk. file: [faadf45c] check-in: [fc8ca1a8] user: drh branch: sessions, size: 22539
2014-03-19
17:41
Make it possible for block-sort to use the OP_SorterOpen sorter in addition to a generic OP_OpenEphemeral. file: [2b9a6849] check-in: [7ce2daaf] user: drh branch: orderby-planning, size: 21589
14:10
First attempt at getting block-sort to work. This is an incremental check-in. There are many problems still to be worked out. file: [aa7ea206] check-in: [59742dd4] user: drh branch: orderby-planning, size: 21535
2014-03-05
14:49
Merge in various obscure bug fixes and the removal of Mem.memType from trunk. file: [aa52feb8] check-in: [0828975d] user: drh branch: sessions, size: 22427
01:29
Experimental simplification of memory flags/type handling. file: [e54fc4f2] check-in: [bac2820e] user: mistachkin branch: noMemType, size: 21477
2014-03-04
14:34
Merge the performance enhancements of trunk (and some obscure bug fixes) into the sessions branch. file: [3fecec24] check-in: [7f51ad97] user: drh branch: sessions, size: 22538
2014-03-03
18:25
Fix compiler warnings. file: [9ccca0bc] check-in: [ba899372] user: drh branch: experimental, size: 21588
2014-03-01
18:13
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. file: [d55cab85] check-in: [44e1c337] user: drh branch: enhanced-mem-check, size: 21582
16:24
Factor the Mem invariant checker into a separate procedure (rather than a macro) so that it can be more easily extended. file: [a82d5ab4] check-in: [354699d5] user: drh branch: enhanced-mem-check, size: 21584
14:45
Add extra assert() statements trying to catch a Mem object in an inconsistent state. file: [fa0cadb9] check-in: [4aeb3ae4] user: drh branch: enhanced-mem-check, size: 22215
2014-02-11
04:30
Sync the latest trunk changes, and in particular the STAT4 IS NOT NULL fix. file: [9ad4950c] check-in: [b0067926] user: drh branch: sessions, size: 22493
2014-02-10
03:21
Faster and smaller implementation of sqlite3_value_type(). file: [5286af90] check-in: [5708bc24] user: drh branch: trunk, size: 21543
2014-02-08
23:20
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. file: [6714e9eb] check-in: [1e64dd78] user: drh branch: trunk, size: 21495
2014-02-07
19:18
Change the OP_InitCoroutine instruction to jump over the co-routine implementation. file: [b5d62957] check-in: [a522f364] user: drh branch: coroutine-refactor, size: 21554
13:20
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. file: [bd6d5e70] check-in: [6fb74485] user: drh branch: coroutine-refactor, size: 21502
2013-12-24
12:09
Merge the latest trunk changes into the sessions branch. file: [08d79db1] check-in: [cfd110bf] user: drh branch: sessions, size: 22450
2013-12-23
19:09
Move elements of the Vdbe object that are only used during statement preparation out into the Parse object. file: [42db251e] check-in: [c289a253] user: drh branch: trunk, size: 21500
2013-12-18
15:11
Show changes to the column cache when PRAGMA vdbe_addoptrace=ON is set. file: [8a4d2d69] check-in: [4c6a659c] user: drh branch: column-cache-debug, size: 21706
2013-12-14
18:24
Merge in all recent preformance enhancements from trunk. file: [062d6e86] check-in: [32477642] user: drh branch: sessions, size: 22556
2013-12-11
11:00
Fix harmless compiler warnings. file: [a7bc268f] check-in: [a7e5fcd6] user: drh branch: trunk, size: 21606
2013-12-10
21:38
Avoid unnecessary calls to sqlite3VdbeSerialType() from within sqlite3VdbeSerialPut(). file: [e103e922] check-in: [079c04a5] user: drh branch: trunk, size: 21611
2013-12-09
23:17
Simplifications to the OP_MakeRecord opcode and the sqlite3VdbeSerialPut() helper function. file: [7e38eef8] check-in: [7277a769] user: drh branch: trunk, size: 21606
2013-11-26
18:00
Merge in performance enhancements from trunk. file: [1a5c604f] check-in: [fc9ae839] user: drh branch: sessions, size: 22561
2013-11-21
21:59
Changes some offset and amount parameters from "int" to "u32" to avoid harmless signed/unsigned comparison warnings. file: [05fbda0e] check-in: [4e8c5d07] user: drh branch: trunk, size: 21611
01:04
Reduce the size of VdbeCursor again, this time without a performance hit. file: [0ac03c79] check-in: [93393993] user: drh branch: OP_Column-refactor, size: 21611
00:10
Unpack some fields, adding some space back to the VdbeCursor object, in order to help the code to run a little faster. file: [7cb3c641] check-in: [f8d5efcd] user: drh branch: OP_Column-refactor, size: 21336
2013-11-20
21:51
Reduce the size of the VdbeCursor object from 144 to 120 bytes. file: [fc6a1ca5] check-in: [5f9d5068] user: drh branch: OP_Column-refactor, size: 21336
17:25
Refactoring the OP_Column opcode for improved performance and maintainability. file: [fbae1c44] check-in: [7c914e39] user: drh branch: OP_Column-refactor, size: 21633
02:53
Simplifications to the VdbeCursor object. file: [4044cd2e] check-in: [5562cd34] user: drh branch: trunk, size: 21378
2013-11-14
19:18
Merge the skip-scan optimization into the sessions branch. file: [40461ecb] check-in: [7596d1bf] user: drh branch: sessions, size: 22470
2013-11-13
17:58
Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify some of the other debugging logic. file: [62eb6803] check-in: [8ce33f4c] user: drh branch: trunk, size: 21520
2013-11-11
22:55
Merge in the WITHOUT ROWID changes. A few tests are failing now. They will be fixed in a follow-on check-in. file: [fe226d72] check-in: [5addd123] user: drh branch: sessions, size: 22572
2013-11-01
22:02
Size KeyInfo objects so that IdxInserts always compare the correct number of fields. file: [f2fa3cec] check-in: [302a8139] user: drh branch: omit-rowid, size: 21622
2013-10-26
15:40
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. file: [42dcff74] check-in: [086ec2a1] user: drh branch: omit-rowid, size: 21617
2013-10-10
20:13
Synchronize with the trunk. file: [2eaf8a38] check-in: [136445ba] user: drh branch: sessions, size: 22611
2013-09-16
12:57
The date and time functions use the exact same notion of "now" for every invocation within the same call to sqlite3_step(). file: [ff57f67a] check-in: [daf6ba41] user: drh branch: trunk, size: 21661
2013-08-20
13:02
Merge performance enhancements and compiler warning fixes from trunk. file: [9bf236dc] check-in: [3e403328] user: drh branch: sessions, size: 22534
00:42
Performance optimizations in the VDBE and especially to the OP_Next and related opcodes. file: [cbe71b8b] check-in: [d78c5d89] user: drh branch: toTypeFuncs, size: 21584
2013-08-19
23:18
Performance improvement to SQL function calls in the VDBE. file: [6931139c] check-in: [d2efea16] user: drh branch: toTypeFuncs, size: 21584
2013-08-02
20:44
Merge in the latest trunk changes, including partial indexes, the MAX_PATH fix in os_win.c, and the sqlite3_cancel_auto_extension() API. file: [cc1974b9] check-in: [7e1acb39] user: drh branch: sessions, size: 22465
2013-07-18
17:12
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. file: [e9b7c6b1] check-in: [71effa59] user: dan branch: typo, size: 21515
2013-07-11
15:03
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]. file: [5e666c97] check-in: [527121ac] user: drh branch: trunk, size: 21532
2013-07-09
13:05
Pull in all the latest changes from trunk. file: [11feb11e] check-in: [af3ca4c6] user: drh branch: sessions, size: 22482
2013-07-03
19:53
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. file: [1ca0f9ae] check-in: [1d44e5d3] user: dan branch: sessions, size: 22412
2013-06-28
01:24
Refactor the Vdbe.noIO field as Vdbe.bIsReader. The meaning is inverted. file: [aa185c6d] check-in: [59f98c5c] user: drh branch: trunk, size: 21451
2013-06-27
17:40
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. file: [9735fdf2] check-in: [1937fd8e] user: drh branch: trunk, size: 21458
2013-06-26
13:31
Bring the sessions branch up-to-date with all the latest trunk changes. file: [cbecb801] check-in: [086a1272] user: drh branch: sessions, size: 22331
2013-06-25
22:01
Add a new (experimental) sqlite3_stmt_status() verb that returns the number of VM steps. file: [b8a76f7b] check-in: [f1366bab] user: drh branch: status-vm-step, size: 21381
2013-04-22
23:59
Merge the latest trunk changes into the sessions branch. file: [a6b7a1fb] check-in: [6994826c] user: drh branch: sessions, size: 22331
2013-04-06
18:06
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(). file: [c1e83026] check-in: [c1d7304c] user: drh branch: trunk, size: 21381
2013-03-28
01:19
Merge the changes for the 3.7.16.1 release candidate into the sessions branch. file: [bd76014f] check-in: [ee35a897] user: drh branch: sessions, size: 22125
2013-03-24
22:56
Remove the SQLITE_OMIT_MERGE_SORT compile-time option and its related code. The merge sorter is now a required component. file: [3bb8531d] check-in: [8b44d6fb] user: drh branch: trunk, size: 21175
2013-02-13
13:42
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. file: [0112cab1] check-in: [7e14dc73] user: drh branch: sessions, size: 22511
2013-02-07
09:33
Fix harmless compiler warnings. file: [396bb03e] check-in: [4a7b4ee0] user: drh branch: trunk, size: 21561
2013-01-28
19:00
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]. file: [c5b337e5] check-in: [c2462a95] user: drh branch: trunk, size: 21561
2012-10-30
21:03
Pull all the latest trunk enhancements into the sessions branch. file: [2de43968] check-in: [fce667f2] user: drh branch: sessions, size: 22511
00:29
Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table. file: [79abf9b3] check-in: [7af3acbb] user: drh branch: subquery-as-coroutine, size: 21561
2012-09-28
13:05
Merge the latest trunk changes (especially "PRAGMA busy_timeout" and the ORDER BY query planner optimizations) into the sessions branch. file: [39acf85f] check-in: [6ca8eae1] user: drh branch: sessions, size: 22452
2012-09-19
21:15
Tighter VDBE code for the WHERE_DISTINCT_ORDERED case of DISTINCT keyword handling. file: [573a43ab] check-in: [94b48064] user: drh branch: trunk, size: 21502
2012-09-04
21:34
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. file: [a668b303] check-in: [39f763bf] user: drh branch: trunk, size: 21429
2012-08-22
15:16
Do not let the multi-core sorter use lookaside memory, which is not thread-safe. file: [3c238336] check-in: [acdc7d12] user: drh branch: threads-sort-ex1, size: 21155
2012-08-15
16:21
Merge all the latest trunk changes into the sessions branch. file: [3f5d9947] check-in: [fc07a479] user: drh branch: sessions, size: 22151
15:57
Experimental change to speed up ORDER BY clauses that sort based on a single expression. file: [4554c3a3] check-in: [2bb8c492] user: dan branch: sorter-exp, size: 21186
2012-07-24
19:46
Mark parameters to sorter interfaces as const where appropriate. file: [986b6b11] check-in: [d8da26f1] user: drh branch: trunk, size: 21201
2012-02-13
13:44
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. file: [634aa573] check-in: [922bcbb4] user: drh branch: generalize-interrupt, size: 21247
2012-02-10
17:54
Pull all the latest trunk changes into the sessions branch. file: [f1956902] check-in: [361fb66a] user: drh branch: sessions, size: 22121
2012-02-02
21:02
More structure packing for smaller objects and less memory usage. file: [6ff4180a] check-in: [f14e7f29] user: drh branch: trunk, size: 21171
17:35
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. file: [0f986e86] check-in: [adb29232] user: drh branch: output-minmax-row, size: 21171
2012-02-01
19:03
Very small performance enhancement and reduction in size of the sqlite3_stmt object. file: [2e79ce66] check-in: [a38d57a4] user: drh branch: trunk, size: 21103
2012-01-14
13:50
Update sessions branch with latest changes from trunk. file: [1aa78a0c] check-in: [01c84fd3] user: dan branch: sessions, size: 22123
2012-01-08
22:18
Fix typos in commands. Combine the ExpandBlob and expandBlob macros into one. file: [ef9b8584] check-in: [fc9179e1] user: drh branch: trunk, size: 21173
2012-01-05
13:02
Merge all of the latest trunk changes into the sessions branch. file: [57ca039e] check-in: [a9bcb432] user: drh branch: sessions, size: 22011
2012-01-04
12:57
Fix typos and comments and make minor changes to a few function names, as suggested by readership. file: [88e4d5d7] check-in: [e9d05cbb] user: drh branch: trunk, size: 21061
2011-12-10
15:55
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. file: [48c158b2] check-in: [bcbc7152] user: drh branch: trunk, size: 21062
14:44
Merge the latest trunk changes into tree-explain branch. file: [72222af1] check-in: [1a360da0] user: drh branch: tree-explain, size: 21021
2011-12-09
13:24
Modify the OP_Once opcode so that it works correctly in trigger sub-programs. This is a candidate fix for [7bbfb7d442]. file: [23a9506c] check-in: [557c6905] user: dan branch: trunk, size: 20436
2011-12-06
19:44
Begin adding the data-structure explaining subsystem. All is contained within file: [a2b8f177] check-in: [79ae51c5] user: drh branch: tree-explain, size: 20778
2011-10-31
14:34
Merge in all changes found in the version 3.7.9 release candidate. file: [09dacf6f] check-in: [23580718] user: drh branch: sessions, size: 21143
2011-10-27
15:19
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. file: [9498fc98] check-in: [8f88cc4e] user: dan branch: trunk, size: 20193
2011-09-20
15:53
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. file: [425674f4] check-in: [89272357] user: dan branch: cache-stats, size: 20154
2011-09-14
19:41
Merge latest changes from the trunk into the sessions branch. file: [1400515b] check-in: [c00e45ed] user: dan branch: sessions, size: 21104
2011-09-03
00:17
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. file: [693d6ac6] check-in: [68e26c44] user: drh branch: merge-sort, size: 20154
2011-09-02
10:31
Instead of a temporary b-tree, use a linked-list and merge-sort to sort records in main memory in vdbesort.c. file: [a255da14] check-in: [7769fb98] user: dan branch: merge-sort, size: 20154
2011-09-01
15:32
Experimental code-generator changes to utilize new opcodes for sorting. file: [51a902e1] check-in: [bab2e560] user: drh branch: merge-sort, size: 20043
2011-08-29
02:49
About a 1% overall performance improvement by using a macro to avoid no-op calls to sqlite3MemReleaseExternal(). file: [70767f65] check-in: [ff71d20a] user: drh branch: experimental, size: 19986
2011-08-26
19:20
Merge the latest trunk changes into the sessions branch. file: [1b36e546] check-in: [eb036d6f] user: drh branch: sessions, size: 20812
2011-08-12
16:11
Remove an unused parameter from a function in vdbesort.c. Fix some comments and other details in the same file. file: [f9250326] check-in: [1a8498d8] user: dan branch: experimental, size: 19862
15:02
Add the SQLITE_OMIT_MERGE_SORT pre-processor directive. To omit the code in vdbesort.c. file: [603b4ccc] check-in: [4ced2394] user: dan branch: experimental, size: 19873
2011-08-06
12:01
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. file: [de75338e] check-in: [8051c176] user: dan branch: experimental, size: 19539
2011-08-02
10:56
Minor fixes to vdbesort.c code in preparation for a major rework. file: [9e38e4f8] check-in: [7f339c0e] user: dan branch: experimental, size: 19534
2011-07-12
14:28
Experimental support for speeding up CREATE INDEX commands using an offline merge sort. file: [fb6c8600] check-in: [30dbf0fe] user: dan branch: experimental, size: 19352
2011-06-20
10:44
Merge the latest trunk changes into the sessions branch. file: [3de6588b] check-in: [4c5e276c] user: drh branch: sessions, size: 19988
2011-06-01
18:15
Refactor the SQL parameter processing so that parameter names for values that are optimized out of the prepare statement are not forgotten. file: [ad84226c] check-in: [b3aaf715] user: drh branch: trunk, size: 19038
2011-04-06
22:33
Merge in the latest changes from the trunk. file: [b95de012] check-in: [435b57dc] user: drh branch: sessions, size: 19996
22:05
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. file: [fe8f58d3] check-in: [614de91a] user: drh branch: trunk, size: 19046
2011-04-05
22:13
Merge the latest trunk changes into the sessions branch. file: [3dec3d5b] check-in: [45f20261] user: drh branch: sessions, size: 19923
17:31
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. file: [53dfcaf5] check-in: [242ce7cf] user: drh branch: trunk, size: 18973
2011-04-04
13:19
Merge the latest changes of trunk into the session branch. file: [36dddc4c] check-in: [95d53c44] user: drh branch: sessions, size: 19891
00:14
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. file: [7e2f028e] check-in: [d81708f7] user: drh branch: trunk, size: 18941
2011-04-02
20:01
Change the name of the "tAttachMask" datatype to "yDbMask". file: [8ee9302e] check-in: [3d6f2e82] user: drh branch: trunk, size: 18981
2011-03-23
22:48
Merge in all the latest changes from the trunk, and especially the interface changes to the SystemCall methods of the VFS. file: [b6748a8a] check-in: [9c3a6e47] user: drh branch: sessions, size: 19931
18:22
Increase the upper bound on SQLITE_MAX_ATTACHED from 30 to 62. file: [e1c62546] check-in: [7aaf8772] user: drh branch: trunk, size: 18981
2011-03-19
08:38
Fix a problem with INTEGER PRIMARY KEY columns and the pre-update hook. file: [2cf77c1d] check-in: [24d4d5dd] user: dan branch: sessions, size: 19931
2011-03-16
19:59
Add the sqlite3_preupdate_new() API, for retrieving the new.* values from within a pre-update callback. file: [20d13da9] check-in: [526545c4] user: dan branch: sessions, size: 19716
2011-03-08
19:22
Add start of sessions feature. file: [9dd04435] check-in: [269a81a3] user: dan branch: sessions, size: 19504
2011-03-01
18:42
Add the experimental sqlite3_preupdate_hook() API. file: [41b8e337] check-in: [6145d7b8] user: dan branch: sessions, size: 19485
2011-01-07
02:50
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. file: [6e6f28e9] check-in: [378a1d13] user: drh branch: trunk, size: 18981
2010-12-01
08:04
Avoid recursive calls to sqlite3VdbeMemRelease() when deleting VM frames used by trigger programs. file: [1f2137b9] check-in: [119ffe95] user: dan branch: trunk, size: 19927
2010-09-27
21:09
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]. file: [7f4cf1b2] check-in: [8b8e1732] user: drh branch: bug-b351d95f9c, size: 19220
2010-08-30
22:15
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. file: [a247bd54] check-in: [4fead8e7] user: drh branch: trunk, size: 18723
2010-07-26
12:05
Change the way SubProgram objects are deleted so that the code is the same for deletion and measurement. file: [ffd68c4d] check-in: [00e55102] user: dan branch: experimental, size: 18645
2010-04-06
22:33
Veryquick.test is now working. The SQLITE_STMTSTATUS_AUTOINDEX counter added. file: [19ebc8c2] check-in: [abbf16e5] user: drh branch: experimental, size: 18570
2010-02-25
14:56
Expire pragma statements when reset, even if they were not run to completion. file: [15d418f4] check-in: [b8fbf427] user: drh branch: branch-3.6.22, size: 18465
14:47
Expire pragma statements when reset, even if they were not run to completion. file: [ae1e6ba0] check-in: [78351d28] user: drh branch: trunk, size: 18570
2010-01-13
00:04
Make the sqlite3_result_double() interface work the same as sqlite3_result_int64() when SQLITE_OMIT_FLOATING_POINT is defined. file: [e276691b] check-in: [61df5986] user: drh branch: trunk, size: 18508
2009-11-14
23:22
Optimizations to the main loop inside sqlite3VdbeExec() to help VDBE byte code run a few percent faster. file: [d7ea821a] check-in: [d622ac6a] user: drh branch: trunk, size: 18403
2009-11-10
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [59c65e7b] check-in: [f6c045f6] user: drh branch: trunk, size: 18447
2009-11-04
13:17
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. file: [53b430ad] check-in: [24a4d520] user: drh branch: trunk, size: 18506
2009-11-03
01:22
All SQLITE_MAX_VARIABLE_NUMBER to exceed 32767. The sizes of some structures increase when the compile-time parameter is configured this way. file: [aa08465e] check-in: [16a24b44] user: drh branch: trunk, size: 18621
2009-10-26
22:32
Remove additional obsolete code from the sqlite3_release_memory() logic. file: [97312570] check-in: [2eeb6ed8] user: drh branch: trunk, size: 18506
2009-10-19
18:11
Remove the sqlite3_reoptimize() API. The same functionality is now provided automatically to queries prepared using prepare_v2(). file: [8e07f435] check-in: [2c50b3d5] user: dan branch: trunk, size: 18592
2009-10-15
18:35
Add the experimental sqlite3_reoptimize() API. file: [aafda2e9] check-in: [9bd6f3d8] user: dan branch: experimental, size: 18754
2009-09-23
18:07
Fix a problem with FK constraints that implicitly map to a composite primary key. file: [7afb76c0] check-in: [e0a48d53] user: dan branch: trunk, size: 18482
17:30
Do not check immediate foreign key constraints until the end of the statement. This matches the postgres behaviour. file: [03336c03] check-in: [1a32149c] user: dan branch: trunk, size: 18487
2009-09-19
17:00
Check in implementation of foreign key constraints. file: [546ed25c] check-in: [d5d39981] user: dan branch: trunk, size: 18417
2009-09-08
01:14
Code simplifications, especially to the pseudo-table logic, and comment improvements. file: [004dbb28] check-in: [52449a95] user: drh branch: trunk, size: 18217
2009-09-01
12:16
More fixes and comment updates. file: [6094e60f] check-in: [38a9327b] user: dan branch: trunk, size: 18267
2009-08-30
11:42
Fixes for new triggers scheme. file: [12919083] check-in: [9eb91efd] user: dan branch: trunk, size: 17689
2009-08-28
18:53
Changes to support recursive triggers. file: [9b62f705] check-in: [9b9c1921] user: dan branch: trunk, size: 18410
2009-06-23
14:15
Simplifications to vdbe.c to promote better test coverage. (CVS 6802) file: [831c254a] check-in: [3ffc93d7] user: drh branch: trunk, size: 17216
2009-06-22
00:55
Simplifications to vdbe.c in support of coverage testing. (CVS 6794) file: [7823eac6] check-in: [16680f05] user: drh branch: trunk, size: 17206
2009-06-19
14:06
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) file: [f5147efa] check-in: [37ae5f5e] user: drh branch: trunk, size: 17388
2009-06-05
14:17
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) file: [37271282] check-in: [38b20327] user: drh branch: trunk, size: 17607
2009-05-04
11:42
Speed up INSERT operations that add data to UNIQUE or PRIMARY KEY indexes by rationalizing duplicate seek operations. (CVS 6599) file: [43183a2a] check-in: [cac4f3d8] user: danielk1977 branch: trunk, size: 17615
2009-04-22
02:15
Remove the rowhash object from the code. Rowset now fills its role. (CVS 6535) file: [8726f7b4] check-in: [e963bed0] user: drh branch: trunk, size: 17476
2009-04-21
09:02
Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) file: [d3adfecc] check-in: [f61e4cd9] user: danielk1977 branch: trunk, size: 17611
2009-04-10
12:55
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) file: [df5c5a1c] check-in: [683e4bd7] user: danielk1977 branch: trunk, size: 17484
2009-03-18
10:33
Fix some cases where executing SQL from within a user-function callback could cause problems related to statement-transactions. (CVS 6355) file: [53a2f469] check-in: [a60f4191] user: danielk1977 branch: trunk, size: 17356
2009-03-17
22:33
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) file: [87322289] check-in: [18978583] user: drh branch: trunk, size: 17302
2009-02-20
01:28
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) file: [d12bc259] check-in: [58a18092] user: drh branch: trunk, size: 17434
2009-02-19
14:39
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) file: [9dd984cf] check-in: [d9f6ffbc] user: danielk1977 branch: trunk, size: 17377
2009-02-03
15:39
Remove the text of the sqlite3VdbeMemSanity() routine, which was already commented out. (CVS 6238) file: [13cb4868] check-in: [a3c26077] user: drh branch: trunk, size: 17559
2009-01-05
18:02
Make sure the MEM_Zero flags is cleared whenever removing MEM_Blob. (CVS 6111) file: [5530e45f] check-in: [b2131e86] user: drh branch: trunk, size: 17616
2008-12-09
02:51
Suppress more silly compiler warnings. (CVS 5995) file: [e6e80a99] check-in: [1522c2c6] user: drh branch: trunk, size: 17602
2008-12-04
20:40
Replace the VDBE Fifo object with the new RowSet object. (CVS 5977) file: [1df957ab] check-in: [39a0750b] user: drh branch: trunk, size: 17533
2008-11-17
15:31
Modifications to avoid signed/unsigned warnings in vdbe.c. (CVS 5912) file: [6b108248] check-in: [9939dd83] user: danielk1977 branch: trunk, size: 18497
2008-11-05
16:37
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) file: [c9400778] check-in: [51f04aaf] user: drh branch: trunk, size: 18489
2008-11-03
20:55
Change the name of the Cursor object to VdbeCursor. (CVS 5857) file: [1fd87002] check-in: [fdb98fd8] user: drh branch: trunk, size: 18362
2008-10-07
23:46
Add the experimental sqlite3_stmt_status() interface. (CVS 5781) file: [a20f479e] check-in: [de473efb] user: drh branch: trunk, size: 18318
2008-08-13
19:11
Additional changes toward fixing ticket #3292. (CVS 5562) file: [b48c74d8] check-in: [0b92cbf5] user: drh branch: trunk, size: 18245
2008-08-02
03:50
Additional coverage testing. Fix a segfault following OOM in sqltie3_load_extension(). (CVS 5523) file: [6f04c2bf] check-in: [f1e44eb3] user: drh branch: trunk, size: 19349
2008-07-30
13:14
Remove unused sqlite3VdbeMemDynamicify() function from the VDBE. (CVS 5500) file: [ab27f964] check-in: [aee63308] user: drh branch: trunk, size: 19428
2008-07-28
19:34
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) file: [1672cc13] check-in: [e48f9697] user: drh branch: trunk, size: 19464
2008-07-26
18:26
Fix a case where database corruption was causing an invalid reference. (CVS 5484) file: [3c12ae09] check-in: [7aecabac] user: danielk1977 branch: trunk, size: 19399
2008-06-25
00:12
The compound-select merge optimization passes quick.test with no errors. (CVS 5299) file: [30535c1d] check-in: [8bbfa978] user: drh branch: trunk, size: 19380
2008-06-20
18:13
Add new Compare and Jump codes to the virtual machine. Use them in the implementation of aggregate queries. (CVS 5257) file: [723fb796] check-in: [08311365] user: drh branch: trunk, size: 19456
2008-06-06
15:04
Remove the subroutine return stack from the VDBE. Return addresses for subroutines are now stored in registers. (CVS 5191) file: [de321b2c] check-in: [ef1956ee] user: drh branch: trunk, size: 19380
2008-05-16
04:51
Add more version tags to files that lack them. Ticket #3120. (CVS 5137) file: [ede1a31c] check-in: [81a8c70e] user: danielk1977 branch: trunk, size: 19535
2008-05-01
17:03
Fix harmless compiler warnings. (CVS 5073) file: [18aebaa7] check-in: [227a6f67] user: drh branch: trunk, size: 19468
2008-04-18
09:01
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) file: [05316345] check-in: [c448f15a] user: danielk1977 branch: trunk, size: 19422
2008-03-28
15:44
Changes to the Mem structure to reduce the frequency of freeing and reallocating the dynamic buffer. (CVS 4928) file: [0b96efde] check-in: [d0bf73d8] user: danielk1977 branch: trunk, size: 19405
2008-03-27
17:59
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) file: [73a31629] check-in: [1a58a870] user: danielk1977 branch: trunk, size: 19288
2008-03-26
18:34
Changes to delay freeing buffers associated with vdbe memory cells until either sqlite3_finalize() or sqlite3_release_memory() is called. (CVS 4922) file: [25844947] check-in: [8c2f6952] user: danielk1977 branch: trunk, size: 19263
2008-03-25
17:23
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) file: [4d767f18] check-in: [ee381b43] user: drh branch: trunk, size: 19141
00:22
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) file: [4bbec80d] check-in: [0e1d84f2] user: drh branch: trunk, size: 18252
2008-02-13
18:25
Where possible, avoid freeing buffers allocated for vdbe memory cells in case they can be reused. (CVS 4783) file: [76c81d05] check-in: [990237e2] user: danielk1977 branch: trunk, size: 18322
2008-02-06
14:11
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) file: [969d360a] check-in: [c2461620] user: drh branch: trunk, size: 18448
2008-01-28
15:19
Fix an incorrect comment on the Mem object in vdbeInt.h. (CVS 4752) file: [b7a18349] check-in: [50c9cf9b] user: drh branch: trunk, size: 18436
2008-01-22
21:30
Add the fault injector module in fault.c. Use it as a basis for memory allocation failure testing. (CVS 4742) file: [6b4a4381] check-in: [1a335e18] user: drh branch: trunk, size: 18436
2008-01-17
16:22
Registerification of the VDBE is complete. The operand stack has been removed from the code. All instructions operate out of registers only. (CVS 4718) file: [835e6f03] check-in: [706b41b7] user: drh branch: trunk, size: 18435
2008-01-04
16:50
Replace the NOPUSH_MASKs with a bit-vector mechanism that can contain several different properties about each opcode. (CVS 4677) file: [31bd6865] check-in: [042dcb96] user: drh branch: trunk, size: 18641
2008-01-03
11:50
Change the VdbeOp.p4 union to include specific pointer types for the various values of VdbeOp.p4type. (CVS 4667) file: [869d0f55] check-in: [7e8330c8] user: danielk1977 branch: trunk, size: 18632
2008-01-02
00:34
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) file: [2985f136] check-in: [051ec01f] user: drh branch: trunk, size: 18690
2007-08-28
23:28
The shared_err test runs with no errors. But a potential deadlock has been discovered and is still unfixed. (CVS 4317) file: [630145b9] check-in: [f84550be] user: drh branch: trunk, size: 18704
22:24
Clean up the locking in the btree logic. (CVS 4316) file: [a9dcd068] check-in: [967ab229] user: drh branch: trunk, size: 18679
02:27
Work toward correct btree locking in a multithreaded environment. (CVS 4307) file: [0681e0b7] check-in: [b8cc493b] user: drh branch: trunk, size: 18607
2007-08-27
23:26
Work around problem with forward declarations of constants in MSVC in the amalgamation. Ticket #2574. (CVS 4304) file: [2bb602c9] check-in: [dc80b2e1] user: drh branch: trunk, size: 18554
2007-08-21
19:33
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) file: [39fb069c] check-in: [92872761] user: drh branch: trunk, size: 18836
2007-08-16
12:24
Combine sqlite3DbOfVdbe() and sqlite3VdbeDb() into a single function. (CVS 4236) file: [8e360d32] check-in: [ba80ee59] user: drh branch: trunk, size: 18972
10:09
More work on refactoring of malloc() interfaces. There are still many errors. (CVS 4233) file: [e0bd068c] check-in: [77b16713] user: danielk1977 branch: trunk, size: 19005
04:30
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) file: [0629275f] check-in: [deb7ecd6] user: drh branch: trunk, size: 18860
2007-06-27
15:53
Allow ALTER TABLE on virtual tables. (CVS 4142) file: [c3514903] check-in: [37d1f9f3] user: danielk1977 branch: trunk, size: 18777
2007-05-16
14:23
Omit some extra code when OMIT_INCRBLOB is defined. (CVS 4014) file: [7d2bf163] check-in: [1d89be28] user: danielk1977 branch: trunk, size: 18700
2007-05-08
21:45
Remove compiler warnings in the amalgamation. (CVS 3960) file: [bddb7931] check-in: [c5754530] user: drh branch: trunk, size: 18526
20:59
Disable tracing pragmas when not in debug mode. This eliminates an external dependency on stdout. (CVS 3959) file: [095222fe] check-in: [5a0fe985] user: drh branch: trunk, size: 18518
12:12
Begin adding code to explicitly limit the size of strings and blobs. (CVS 3943) file: [77a17f1a] check-in: [031a5915] user: drh branch: trunk, size: 18491
2007-05-02
13:30
Add support for zero-blobs to the OP_MakeRecord opcode. First test cases of zeroblob functionality. (CVS 3897) file: [cb02cbbc] check-in: [e6d560dd] user: drh branch: trunk, size: 18459
02:08
Fix some compiler warnings. Add the (untested) zeroblob() SQL function. (CVS 3895) file: [10ff7c35] check-in: [6f4f8ba7] user: drh branch: trunk, size: 18429
01:34
Begin adding the zeroblob API to support incremental blob i/o. (CVS 3894) file: [016c8084] check-in: [7a01836d] user: drh branch: trunk, size: 18393
2007-03-30
11:23
Remove the anonymous union from the sqlite3_value structure since some compilers are unable to deal with it. (CVS 3758) file: [4b19fd8f] check-in: [6b995259] user: drh branch: trunk, size: 18270
2007-03-26
22:05
Modify sources to that they can be combined into a single sqlite3.c source file. Eliminate all type-pruned pointer warnings. (CVS 3722) file: [b2ca85ca] check-in: [0b832e21] user: drh branch: trunk, size: 18227
2007-01-26
21:08
Make sure the vdbeInt.h file is not #included multiple times. Ticket #2194. (CVS 3608) file: [13ba0712] check-in: [93edd3b0] user: drh branch: trunk, size: 18179
2006-11-09
00:24
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) file: [1ca07f2d] check-in: [f1efae92] user: drh branch: trunk, size: 18103
2006-06-27
13:20
Changes so that it will build with SQLITE_OMIT_VIRTUALTABLE=1. (CVS 3309) file: [e3eaab26] check-in: [5612b287] user: drh branch: trunk, size: 17973
2006-06-24
06:36
Clean up and clarify code in test8.c. (CVS 3289) file: [37d74cc5] check-in: [4acf7594] user: danielk1977 branch: trunk, size: 18051
2006-06-23
14:32
Allow xDestroy methods to execute "DROP TABLE" statements. (CVS 3287) file: [be3396aa] check-in: [a56bfa56] user: danielk1977 branch: trunk, size: 18051
08:05
Add tests and fixes for handling malloc() failures related to the virtual table feature. (CVS 3285) file: [de89a347] check-in: [5d1d9071] user: danielk1977 branch: trunk, size: 17565
2006-06-12
21:59
Added code to iterate through virtual tables. All regression tests pass but the new code is completely untested. (CVS 3219) file: [6ccb7eaa] check-in: [01096543] user: drh branch: trunk, size: 17424
2006-03-16
14:05
Make provisions in the code to support Provisions to support caching of serialized statements in the SSE extension. (CVS 3139) file: [85cd5f81] check-in: [5048fae0] user: drh branch: trunk, size: 17310
2006-02-24
02:53
Remove unused parameters on internal APIs. Suppress warnings from CodeWarrior. (CVS 3110) file: [2109be6b] check-in: [4b22e4b8] user: drh branch: trunk, size: 17137
2006-01-20
15:45
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) file: [eb3f86ab] check-in: [fd4a6bb1] user: drh branch: trunk, size: 17155
2006-01-07
18:48
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) file: [5451cf71] check-in: [0ae46131] user: drh branch: trunk, size: 17156
2005-12-29
19:23
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) file: [9b78ba00] check-in: [ae301db8] user: drh branch: trunk, size: 16966
2005-12-15
15:22
Add the sqlite3_update_hook() API. (CVS 2820) file: [7b8b8c5d] check-in: [36229018] user: danielk1977 branch: trunk, size: 16876
2005-11-25
02:43
Preserve 64-bit last insert rowids across triggers. (CVS 2779) file: [0055c37e] check-in: [4dd7cfaa] user: drh branch: trunk, size: 16800
2005-11-14
22:29
Create separate affinities for INTEGER and REAL. (CVS 2766) file: [7824d7be] check-in: [ce06c123] user: drh branch: trunk, size: 16800
2005-11-01
15:48
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) file: [6eba0b96] check-in: [e0d6f61c] user: drh branch: trunk, size: 16766
2005-09-19
12:53
Work around limitations of MSVC++ 6. Tickets #1429, #1437, and #1440. (CVS 2720) file: [7bedbb95] check-in: [b2d1803c] user: drh branch: trunk, size: 16727
2005-09-07
22:09
Bug fixes in aggregate processing. Fewer tests fail. (CVS 2663) file: [3dd2a29c] check-in: [c3ac5859] user: drh branch: trunk, size: 16727
21:22
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) file: [15a32128] check-in: [17039ec3] user: drh branch: trunk, size: 16717
2005-09-06
20:36
Cleanup the processing of MEM_Agg elements. (CVS 2660) file: [7a6b3c1a] check-in: [7ecf3654] user: drh branch: trunk, size: 18035
2005-09-01
12:16
All regression tests now pass with the new bounded-memory sort code. There is still lots of opportunity for optimization, however. (CVS 2654) file: [52811a51] check-in: [81259a01] user: drh branch: trunk, size: 18161
03:07
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) file: [c9dcaec8] check-in: [09db0a24] user: drh branch: trunk, size: 18114
2005-08-29
23:00
Increase resolution of time-of-day on unix. Add an experimental sqlite3_profile() API. (CVS 2639) file: [e5f2855b] check-in: [ed2ca087] user: drh branch: trunk, size: 18694
2005-08-24
17:07
Additional defense against the rowid-fifo overflow problem. (CVS 2622) file: [89a7fa5d] check-in: [881dcf5f] user: drh branch: trunk, size: 18617
2005-07-08
13:08
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) file: [9be9a6c4] check-in: [94c120bb] user: drh branch: trunk, size: 18617
2005-06-12
21:35
Update older opcode names to be more meaningful in light of the latest code design. (CVS 2506) file: [4312faf4] check-in: [36f2da1f] user: drh branch: trunk, size: 18193
2005-04-01
10:47
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) file: [4afaae2f] check-in: [e8391491] user: drh branch: trunk, size: 18270
2005-03-29
13:07
Change 'stack' to the more descriptive 'no-push' in vdbe.c. (CVS 2429) file: [97b62807] check-in: [7e54d3c7] user: danielk1977 branch: trunk, size: 18211
08:26
Reduce the space allocated for the runtime virtual machine stack. (CVS 2428) file: [39beecdf] check-in: [7d6818da] user: danielk1977 branch: trunk, size: 18214
2005-01-29
08:32
Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) file: [e80721cd] check-in: [b1b50f31] user: danielk1977 branch: trunk, size: 18178
2005-01-22
03:03
Add the experimental sqlite3_expired() API. (CVS 2263) file: [24d411de] check-in: [df648d50] user: drh branch: trunk, size: 18054
2005-01-12
09:10
Tests to improve coverage of vdbeaux.c. (CVS 2201) file: [f2b5f54d] check-in: [2b3e21ce] user: danielk1977 branch: trunk, size: 17984
2004-12-07
12:29
Remove the unused sqlite3_context.isStep element. (CVS 2156) file: [0f74561e] check-in: [7b20f2b7] user: drh branch: trunk, size: 17952
2004-09-19
00:50
Merge the ListPush and ListPop VDBE opcodes into ContextPush and ContextPop. (CVS 1972) file: [6017100a] check-in: [eb9b501a] user: drh branch: trunk, size: 18007
2004-09-06
17:24
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) file: [e09362d6] check-in: [3ddf5a9d] user: drh branch: trunk, size: 17850
2004-09-02
14:57
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) file: [f8df57a9] check-in: [d1b29156] user: drh branch: trunk, size: 17850
2004-08-28
18:17
Memory handling fixes and optimizations in the VDBE. Ticket #862. (CVS 1909) file: [aadadddc] check-in: [5f8d2468] user: drh branch: trunk, size: 17903
2004-08-21
17:54
Optimizations to the code generator. (CVS 1899) file: [16322cbf] check-in: [bd6649c5] user: drh branch: trunk, size: 17848
2004-08-20
16:02
Add support for named wildcards in SQL statements. (CVS 1897) file: [5e57e36a] check-in: [d3be0b7c] user: drh branch: trunk, size: 18145
2004-07-24
14:35
Fix more problems with deferred execution of CREATE. Still need to do DROP. There is now a memory leak. (CVS 1865) file: [3d8e08c5] check-in: [6db3f122] user: drh branch: trunk, size: 18034
2004-06-30
11:14
When a statement causes a ROLLBACK due to an ON CONFLICT clause, other active VMs abort. (CVS 1778) file: [7160653a] check-in: [0fedf74e] user: drh branch: trunk, size: 18001
2004-06-27
01:56
Fix a bug in the handling of Mems inside of vdbe.c. (CVS 1745) file: [d83fd738] check-in: [ad65c6e2] user: drh branch: trunk, size: 17922
2004-06-22
22:04
Be careful to initialize the Mem.xDel field to zero for static Mems. (CVS 1671) file: [22ab717b] check-in: [e17ea666] user: drh branch: trunk, size: 17856
12:13
Patch around compilers that do not support "long long int". (CVS 1656) file: [0b8eda5e] check-in: [d98b1502] user: drh branch: trunk, size: 17856
2004-06-21
10:45
Avoid opening a temp table for aggregate queries with no GROUP BY clause. (CVS 1649) file: [c0740932] check-in: [4d02df63] user: danielk1977 branch: trunk, size: 17866
06:50
Update sqlite3_changes() to match the documentation and add sqlite3_total_changes(). (CVS 1645) file: [4d56da61] check-in: [ae2f4a09] user: danielk1977 branch: trunk, size: 17995
2004-06-19
15:40
Clear up another zero-length array. This seems to fix the segfault in func-13.4 too. (CVS 1641) file: [d007ccad] check-in: [70680a34] user: drh branch: trunk, size: 17942
15:22
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) file: [e472de98] check-in: [fbfc3c95] user: drh branch: trunk, size: 17895
2004-06-18
06:02
Fix a couple of gcc warnings. (CVS 1615) file: [54af2e00] check-in: [960f55f3] user: danielk1977 branch: trunk, size: 17101
04:24
Optimisation for unicode encoding conversion routines. (CVS 1614) file: [96a6e88b] check-in: [39a415ea] user: danielk1977 branch: trunk, size: 17061
2004-06-15
13:36
Memory leak fixes for tests in file select1.test. (CVS 1599) file: [4e636b1b] check-in: [59db58eb] user: danielk1977 branch: trunk, size: 16957
11:40
Minor bugfixes and test case adjustments for version 2 test cases to work with version 3. (CVS 1598) file: [0aabcc77] check-in: [e21a1813] user: danielk1977 branch: trunk, size: 17091
2004-06-12
20:12
Speed up in the handling of VDBE cursors. (CVS 1578) file: [ffc7b8ed] check-in: [e42316f5] user: drh branch: trunk, size: 17161
18:12
Improve the speed of OP_Column through better caching. (CVS 1577) file: [1cc767a6] check-in: [f687977a] user: drh branch: trunk, size: 17095
09:25
(1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) file: [c4ff480c] check-in: [5903f538] user: danielk1977 branch: trunk, size: 16895
2004-06-11
13:19
Have the vdbe aggregator use a btree table instead of a hash table. (CVS 1569) file: [57b7001b] check-in: [8d56118f] user: danielk1977 branch: trunk, size: 16769
10:51
Fix various collation sequence issues. (CVS 1568) file: [e27e29ff] check-in: [66835ee6] user: danielk1977 branch: trunk, size: 16458
2004-06-09
21:01
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) file: [d4160585] check-in: [39b4ba95] user: drh branch: trunk, size: 16440
2004-06-05
10:22
Add the sqlite3_set_auxdata() and sqlite3_get_auxdata() APIs. (CVS 1532) file: [ab592f23] check-in: [c2899b43] user: danielk1977 branch: trunk, size: 16359
2004-06-03
16:08
Untested updates to support atomic multi-file transactions (CVS 1526) file: [9f5df0a2] check-in: [d57e5252] user: danielk1977 branch: trunk, size: 16138
2004-06-02
01:22
Work toward combining the OP_MakeKey, OP_MakeIdxKey, and OP_MakeRecord opcodes into one. The work is incomplete. (CVS 1524) file: [f19df224] check-in: [165d69a0] user: drh branch: trunk, size: 16131
2004-05-31
18:51
Change all SQLITE3 preprocessor macros to SQLITE. Documentation updates. (CVS 1511) file: [5d357541] check-in: [adf7e29f] user: drh branch: trunk, size: 16195
08:26
Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) file: [51d37798] check-in: [b8ed812c] user: danielk1977 branch: trunk, size: 16200
2004-05-28
08:21
Tables and indices use the same record format. (CVS 1482) file: [c2bcd6e5] check-in: [1b15b32b] user: drh branch: trunk, size: 16268
01:39
Remove the encoding argument from sqlite3VdbeSerialGet. Use the 32-bit version of sqlite3GetVarint for schema-level parameters. (CVS 1480) file: [57b64910] check-in: [321f8c46] user: drh branch: trunk, size: 16168
2004-05-27
19:59
Change the record format to include an extra varint at the beginning to record the number of bytes in the header. (CVS 1478) file: [0c30699e] check-in: [0c4d1388] user: drh branch: trunk, size: 16181
09:28
Various bugfixes. 68 Test cases still fail. (CVS 1471) file: [fab8bb7f] check-in: [67a140cf] user: danielk1977 branch: trunk, size: 16170
03:12
Fixes to the MEM changes. The library now links. (CVS 1470) file: [8941eb55] check-in: [f33d15d9] user: drh branch: trunk, size: 16110
01:53
More MEM changes in the vdbe.c. Still will not compile. (CVS 1469) file: [d62f70eb] check-in: [dbdd1a7f] user: drh branch: trunk, size: 16066
2004-05-26
23:43
Break Mem.flags into Mem.type and Mem.enc. (CVS 1466) file: [8647afb4] check-in: [68ef1702] user: drh branch: trunk, size: 15795
23:25
Refactoring of the vdbe Mem functions and the APIs that deal with them. The code will not compile in its current state. (CVS 1465) file: [d7eda240] check-in: [bba6684d] user: drh branch: trunk, size: 17785
13:27
Ensure the type of an sqlite3_value* is not modified by calls to sqlite3_value_*() calls. (CVS 1463) file: [1064ce17] check-in: [ce8b1520] user: danielk1977 branch: trunk, size: 18739
10:11
Add some tests for the new API. Many more to come. (CVS 1462) file: [653525b1] check-in: [d5659f2e] user: danielk1977 branch: trunk, size: 17754
02:04
Use the new API calls more consistently. (CVS 1459) file: [c8706615] check-in: [17e7db48] user: danielk1977 branch: trunk, size: 17644
2004-05-25
12:05
Change a couple of symbol names for the new user function API. (CVS 1454) file: [e500998a] check-in: [8f6b20c2] user: danielk1977 branch: trunk, size: 17641
11:47
Use the new API for returning values and errors from user functions. (CVS 1453) file: [a9a105b9] check-in: [4eccae03] user: danielk1977 branch: trunk, size: 17637
01:13
Add manifest type aware versions of the min() and max() aggregates. (CVS 1452) file: [4dfeaaf7] check-in: [b77c268e] user: danielk1977 branch: trunk, size: 16335
2004-05-24
23:48
Aggregate functions also use sqlite_value* instead of const char * for arguments. (CVS 1451) file: [7084fc1b] check-in: [5c28ed5e] user: danielk1977 branch: trunk, size: 16297
2004-05-23
13:30
Begin changing the vdbe so all stack values use the database encoding. (CVS 1444) file: [6c2444a6] check-in: [f47de3a9] user: danielk1977 branch: trunk, size: 16283
2004-05-22
21:30
Remove the OP_SetInsert opcode. (CVS 1443) file: [e3f2643c] check-in: [18e690e4] user: drh branch: trunk, size: 14863
03:05
Steps towards UTF-16 databases. Some tests are failing because of this commit. (CVS 1433) file: [f40e8048] check-in: [c4a82468] user: danielk1977 branch: trunk, size: 14970
2004-05-21
10:08
Further work on the new API. All the functions to execute queries are there now. (CVS 1427) file: [8ed2272e] check-in: [fc94575d] user: danielk1977 branch: trunk, size: 14868
2004-05-20
22:16
Add internal support for collating sequences. This breaks 244 tests. (CVS 1420) file: [cea492c1] check-in: [a6cb09d7] user: drh branch: trunk, size: 14668
13:54
sqlite3MemCompare now takes a CollSeq* argument. (CVS 1419) file: [69a7dd04] check-in: [5c1e47a2] user: drh branch: trunk, size: 14525
01:12
Add support for the new sqlite3_bind_*() APIs. (CVS 1410) file: [97b95c62] check-in: [e8f980d8] user: danielk1977 branch: trunk, size: 14499
2004-05-19
14:56
Change opcode names and comments to better describe the operation of the incrKey flag. OP_MoveTo becomes OP_MoveGe. (CVS 1407) file: [faaa6443] check-in: [8f249c45] user: drh branch: trunk, size: 14423
11:24
Variable name change: azVar to apVar. (CVS 1404) file: [3f76e27b] check-in: [45169ce0] user: drh branch: trunk, size: 14428
10:36
Tests for text encoding conversion functions. Also new sqlite3_bindXX APIs. (CVS 1403) file: [2097f78f] check-in: [f71844bc] user: danielk1977 branch: trunk, size: 14433
2004-05-18
22:38
Remove dead code from vdbeaux.c. Add comments describing desired changes to OP_Sort processing in select.c (CVS 1398) file: [5bac5f0f] check-in: [ae37e8a0] user: drh branch: trunk, size: 14574
10:06
Fix many problems with manifest types and column affinity. Most things are working now. (CVS 1393) file: [b4ad3993] check-in: [ad4a9641] user: danielk1977 branch: trunk, size: 14604
2004-05-16
11:15
More changes to support the manifest type model. A few things are currently broken. (CVS 1385) file: [311c2a04] check-in: [a4af838f] user: danielk1977 branch: trunk, size: 14470
2004-05-14
21:59
Allocates VDBE cursors one by one in separate memory so that pointers to cursors can persist through a realloc(). (CVS 1383) file: [67c3b2cf] check-in: [d8bacc16] user: drh branch: trunk, size: 14433
21:12
Cache record headers in the OP_Column opcode. (CVS 1382) file: [6740a3b8] check-in: [8d9eab17] user: drh branch: trunk, size: 14432
11:00
Implement type affinity for table and index records (CVS 1375) file: [03f4c364] check-in: [dbfe6e93] user: danielk1977 branch: trunk, size: 13998
2004-05-13
12:32
Change the OP_ListXX opcodes to use 64 bit integers (CVS 1372) file: [d53f3807] check-in: [da9b3dce] user: danielk1977 branch: trunk, size: 13928
05:16
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) file: [66904cfb] check-in: [9f2b6d9d] user: danielk1977 branch: trunk, size: 13928
2004-05-12
15:15
Btree uses signed integers for the rowid. The intToKey() and keyToInt() macros are now no-ops. (CVS 1364) file: [608a0b09] check-in: [fb3c8030] user: drh branch: trunk, size: 13804
07:33
Change the table record format to support manifest typing. (CVS 1361) file: [3610b51a] check-in: [0242c9e4] user: danielk1977 branch: trunk, size: 13937
2004-05-11
03:11
Internal symbols MEM_Dyn and MEM_AggCtx were defined as the same bit pattern. Change MEM_AggCtx to 0x1000. (CVS 1350) file: [ff85e432] check-in: [2fffd133] user: danielk1977 branch: trunk, size: 13898
2004-05-10
23:29
Work toward getting the new btree.c integrated with vdbe.c. (CVS 1345) file: [d5786e1c] check-in: [bc5a2daf] user: drh branch: trunk, size: 13898
12:07
Add flags values to the Mem structure to accomodate BLOBs and to show the representation of strings. (CVS 1341) file: [2567223b] check-in: [3af283f4] user: drh branch: trunk, size: 13841
10:37
Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1339) file: [742e2576] check-in: [19b100ec] user: danielk1977 branch: trunk, size: 13175
07:17
Add versions of OP_MakeRecord and OP_Column that use manifest typing (not activated yet). (CVS 1334) file: [e4ab46c2] check-in: [8a66a502] user: danielk1977 branch: trunk, size: 13174
2004-05-09
23:23
Add a temporary sqlite2BtreeKeyCompare() function to help get regression tests passing again. (CVS 1332) file: [19926d40] check-in: [d8d1c91e] user: danielk1977 branch: trunk, size: 13021
2004-05-08
08:23
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) file: [4563dc1c] check-in: [8af6474c] user: danielk1977 branch: trunk, size: 12949
2004-02-20
22:53
Fixed behaviour of last_insert_rowid() with triggers and add last_statement_change_count() function that works correctly with triggers. (CVS 1251) file: [b40ff02c] check-in: [3383413a] user: rdc branch: trunk, size: 12934
2004-02-14
23:59
Eliminate obsolete code associated with the older callback functionality. (CVS 1243) file: [af83bd70] check-in: [2dbc4593] user: drh branch: trunk, size: 12217
2004-01-31
19:22
Rework internal data structures to make the VDBE about 15% smaller. (CVS 1203) file: [8a3baf74] check-in: [8273c74b] user: drh branch: trunk, size: 12396
2004-01-30
14:49
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) file: [6f12f5b9] check-in: [c0faa1c6] user: drh branch: trunk, size: 12599
2004-01-07
18:52
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) file: [eab39bc2] check-in: [d3e96da2] user: drh branch: trunk, size: 13088
2003-09-06
22:18
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) file: [2824bf88] check-in: [990bb118] user: drh branch: trunk, size: 12479
20:12
Split almost 1300 lines of code out of vdbe.c into separate files vdbeInt.h and vdbeaux.c. (CVS 1094) file: [15cd0106] check-in: [bfd69391] user: drh branch: trunk, size: 12345 Added