SQLite
Timeline
Not logged in

20 timeline items occurring around 2013-11-07.

2013-11-08
00:16
[1d1d13b890] On the --summary output of wordcount, add the a PRAGMA integrity_check and a 64-bit checksum of the entire table. (user: drh, tags: trunk)
2013-11-07
23:23
[e938112d31] Add many new options to the wordcount test program: --delete, --pagesize, --cachesize, --commit, --nosync, and --journal. (user: drh, tags: trunk)
22:11
[9d870d5f0d] Closed-Leaf: Fix temporary directory separator handling for Cygwin. (user: mistachkin, tags: cygDirSep)
21:32
[404bd98fb4] Fix a compiler warning introduced by the previous check-in. (user: drh, tags: trunk)
21:25
[215307985590c] Enable the WHERE_ONEPASS_DESIRED optimization for UPDATE operations on WITHOUT ROWID tables. (user: drh, tags: trunk)
19:43
[8aa21e6791] Add the --stats and --summary options to the wordcount.c test program. (user: drh, tags: trunk)
18:40
[9ad5b74c26] Increase the version number to 3.8.2. (user: drh, tags: trunk)
18:37
[f02ee54630] Add the "wordcount.c" test program. (user: drh, tags: trunk)
16:08
[c80e229dd9] Add support for WITHOUT ROWID tables. This change also includes (1) standardization of the error message returned from run-time constraint errors, (2) improved EXPLAIN comments, (3) the SQLITE_ENABLE_EXPLAIN_COMMENTS option, (4) the SQLITE_ENABLE_MODULE_COMMENTS option, and (5) a bug fix (see 573cc27427) in the handling of REPLACE on the rowid when secondary indices use FAIL or IGNORE. (user: drh, tags: trunk)
14:09
[55eea1782a] Closed-Leaf: Make sure cached KeyInfo objects are only valid for a single database connection. Clear all cached KeyInfo objects on any collating sequence change. (user: drh, tags: omit-rowid)

2013-11-06
19:59
[defd5205a7] Reference count the KeyInfo object. Cache a copy of an appropriate KeyInfo for each index in the Index object, and reuse that one copy as much as possible. (user: drh, tags: omit-rowid)
16:28
[474555002d] Have the OP_NoConflict opcode set the VdbeCursor.seekResult variable. This speeds up subsequent OP_Insert and OP_IdxInsert opcodes. (user: dan, tags: omit-rowid)
14:52
[4be2b64b3e] Use ansi escape codes to use different colored text for opcode names in the output of [explain_i]: Red for opcodes that insert or delete b-tree elements, blue for opcodes that move cursors and green for the ResultRow opcode. (user: dan, tags: omit-rowid)
14:36
[a725a75f87] Allocate extra stack space for UnpackedRecord objects, reducing the need to malloc for them as often, and thereby get a performance improvement. (user: drh, tags: omit-rowid)
14:05
[d70c78814b] Minor optimization to the OP_Halt opcode. (user: drh, tags: omit-rowid)
12:56
[8f1709ff2d] Improved ORDER BY optimization for WITHOUT ROWID tables. (user: drh, tags: omit-rowid)
12:05
[6055dad2ba] Disable the OR optimization for WITHOUT ROWID tables, since it relies on the use of rowids. (user: drh, tags: omit-rowid)
11:46
[427612efc1] Remove an incorrect test case from conflict2.test. (user: drh, tags: omit-rowid)
02:36
[e9c1e419b7] Remove an unused variable. (user: drh, tags: omit-rowid)
2013-11-05
22:39
[03e7019e14] Make sure the query planner knows that the PRIMARY KEY index of a WITHOUT ROWID table is always a covering index. (user: drh, tags: omit-rowid)