Source Code
Leaves
Not logged in

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

Open leaves:

2018-01-16
02:38 Disable the ".archive" command tests in shell8.test if the CLI is compiled without ZLIB support. Leaf check-in: ce8bfe6c2b user: drh tags: trunk
2018-01-15
21:59 Merge the enhancements associated with the first 3.22.0 beta. Leaf check-in: c9d2ec51c8 user: drh tags: apple-osx
2018-01-13
14:07 Fix a typo in test file crash8.test. Leaf check-in: 4951d91d40 user: dan tags: branch-3.19
2018-01-12
00:30 Enable the one-pass optimization for DELETE and UPDATE on RTree. This is parked in a branch because is seems to make no measureable performance difference. Leaf check-in: 8b8314cb9b user: drh tags: rtree-one-pass
2018-01-08
20:04 Test cases for sqlite3_normalize(). Leaf check-in: 658f42257d user: drh tags: normalize
2018-01-04
18:36 Fix problem causing free-list corruption when merging free-lists for two concurrent transactions that have both used page X as an in-memory free-list trunk page, where X lies past the end of the initial database images. Leaf check-in: dc0fc2aa7c user: dan tags: begin-concurrent-pnu
2018-01-03
23:54 Fix compiler warnings on Windows. Leaf check-in: 512b8e40c4 user: drh tags: memdb
2018-01-01
16:59 Experiments with the regexp.c extension, trying to get it to report the exact substring that matches the RE. Leaf check-in: 3d6fba623a user: drh tags: regexp-span
2017-12-11
14:02 Abort on an invalid paramater to sqlite3BitvecSet(). Leaf check-in: 163c870950 user: drh tags: begin-concurrent
2017-11-28
02:47 Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. Leaf check-in: 2494132a2b user: drh tags: pragma-table-ipk
2017-11-21
23:47 An experimental optimization to DISTINCT that causes an immediate exit of the inner loop of a join following each output row if the inner loop does not contribute any columns to the result set. Leaf check-in: a33f88acd7 user: drh tags: distinct-early-out
2017-11-14
18:26 Fix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. This is a modified cherrypick of [dae4a97a]. Leaf check-in: b2679d3b7a user: dan tags: branch-3.8.9
2017-11-03
19:34 Fix some comments in new code on this branch. No changes to code. Leaf check-in: cbec1bfe4b user: dan tags: fcntl_shm_read
2017-10-24
18:55 Version 3.21.0 Leaf check-in: 1a584e4999 user: drh tags: release, branch-3.21, version-3.21.0
2017-10-10
20:11 Add new extension "bgckpt" in ext/misc/bgckpt.c. For experimenting with running wal2 mode checkpoints in a background thread. Leaf check-in: 6395544230 user: dan tags: wal2
2017-09-22
20:18 Merge in all the trunk enhancements of the previous 7 months. The LIKE optimization has stopped working when there is an ESCAPE - that problem will be addressed in a subsequent check-in. Leaf check-in: 8d2a1cca61 user: drh tags: est_count_pragma
2017-09-21
14:03 The sqlite3_snapshot_describe() interface useful for debugging snapshot logic. Leaf check-in: 3fbfa9a8e8 user: drh tags: sqlite3_snapshot_describe
2017-09-18
08:51 Merge latest trunk changes with this branch. Leaf check-in: 2e57335081 user: dan tags: shared-mapping-hack
2017-09-13
18:38 Experimental sqlite3_stmt_retryable() interface. Leaf check-in: ebada0723a user: drh tags: sqlite3_stmt_retryable
2017-09-12
18:49 Add the highly-experimental "PRAGMA noop_update=TRUE" command. Leaf check-in: de2e371757 user: drh tags: pragma-noop-update
2017-09-09
08:03 Use a mutex-free PRNG for the random() and randomblob() SQL functions and for the randomness used during checkpoint operations. Leaf check-in: e63d1a7cd3 user: drh tags: mutex-free-randomness
2017-08-29
17:52 Add a Tcl script to run the performance tests described in README-server-edition.html. Leaf check-in: 1b3df8ffc5 user: dan tags: server-process-edition
2017-08-28
17:32 Add the --enable-update-limit option to the ./configure script. Leaf check-in: f545db6c27 user: drh tags: begin-concurrent-branch-3.19
2017-08-27
10:55 Instrumentation and changes in an effort to reduce thread contention. Leaf check-in: c93298d5ae user: drh tags: reduced-thread-contention
2017-08-24
16:21 Version 3.20.1 Leaf check-in: 8d3a7ea6c5 user: drh tags: release, branch-3.20, version-3.20.1
2017-08-22
19:44 mksourceid still does not work right. Leaf check-in: ca5dcb4a36 user: drh tags: mistake
2017-08-09
20:35 Add experimental sqlite3_open_v2() flag SQLITE_OPEN_REUSE_SCHEMA. For sharing identical in-memory schema objects between connections. Leaf check-in: a625698048 user: dan tags: reuse-schema
2017-08-07
19:06 On Windows, avoid casting a value larger than 2^31 to a (SIZE_T) on systems where it is a 32-bit type. Leaf check-in: f08d63b413 user: mistachkin tags: mmap-size-limit
2017-07-31
12:04 Merge further enhancements to the batch-atomic-write subsystem. Leaf check-in: 4be4265d74 user: drh tags: batch-atomic-write-3.19
2017-07-28
20:49 Disable the writecrash.test module on Windows. Leaf check-in: 4c0520d4df user: drh tags: batch-atomic-write
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]. Leaf check-in: 8201f4e1c5 user: drh tags: branch-3.18
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]. Leaf check-in: 69906880ce user: drh tags: branch-3.9.2
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]. Leaf check-in: 5a3022e081 user: drh tags: branch-3.8.10
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]. Leaf check-in: a66a5b397b user: drh tags: branch-3.8.6
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. Leaf check-in: f0f492245e user: drh tags: branch-3.7.11
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. Leaf check-in: 10556ee454 user: drh tags: sqlite3_stmt_refresh
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. Leaf check-in: d6a44b352d user: drh tags: branch-3.17
2017-07-08
18:27 Disable compiler intrinsics when using the Intel C Compiler. Leaf check-in: dbb59f6156 user: drh tags: icc-fix
2017-06-28
20:12 Fix bugs in test program tserver.c. Leaf check-in: 093b9108ea user: dan tags: server-edition
2017-06-17
19:06 Avoid adding an artifical "LIMIT 1" on scalar subqueries that do not need it. This seems like a pointless optimization as it makes minimal run-time difference but does increase code complexity. Parked on a branch for historical reference. Leaf check-in: c21628e9c1 user: drh tags: subquery-limit-opt
2017-06-16
10:15 Failed version 3.18.1. Somehow I managed to omit the bug fix which was the entire purpose of 3.18.1 in the first place! Leaf check-in: e3038fbfc2 user: drh tags: mistake
2017-06-07
10:55 Cause the ANALYZE command to build sqlite_stat1 table entries for empty tables with the assumption that such tables really contain 10 elements. This gives better query plans for tables that are truely empty, but is likely to cause problems in legacy systems, so the change is kept off trunk. Some TCL tests fail on this check-in due to the new stat1 entries. Leaf check-in: c81f260c2d user: drh tags: analyze-empty-tables
2017-05-27
18:05 Add debugging functions btreePageOriginFile() and btreePageOriginOffset(). Leaf check-in: 214d238a47 user: dan tags: btree-debug
2017-03-08
23:29 Refactor the output logic in the CLI. Not sure we want to go this way. Just saving the work for historical reference, or in case I decide to come back to it. Leaf check-in: aacac90663 user: drh tags: shell-print-refactor
2017-03-07
14:47 Before beginning an incremental checkpoint in RBU, sync the directory containing the target database file. This ensures that the new directory entry created by renaming the *-oal file to *-wal is synced to disk. Cherrypick of [915a9a28]. Leaf check-in: 694fe0b22b user: dan tags: version-3.17.0-rbu-fixes
2017-02-21
14:04 The VDBE cycle counts for the sqlite3_progress_handler() callback are now cumulative. Leftovers from the previous statement are applied to the next statement. Leaf check-in: 7a62fc6abc user: drh tags: cumulative-progress-count
13:29 Proof of concept for a "PRAGMA vdbe_cycle_limit=N" command. When N>0, invoke sqlite3_interrupt() whenever any byte code program uses more than N virtual machine cycles. Leaf check-in: 9626b41e6e user: drh tags: vdbe_cycle_limit
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. Leaf check-in: c1adf95958 user: dan tags: sort-column-opcodes
2017-02-17
21:23 Increase the estimated cost of sorting when sorting wide results sets, to account for the extra storage space and I/O required for the external sort. Leaf check-in: 38298ef923 user: drh tags: apple-increased-sorting-cost
02:07 Merge fixes from trunk. Leaf check-in: 662e8ccf7e user: drh tags: increased-sorting-cost
2017-02-15
17:47 simple test cases for carray_asc. Leaf check-in: 1d4759c17c user: drh tags: carray_asc
01:02 Make SQLITE_GET_MUTEX_TIME a proper noop on non-Win32/non-POSIX. Leaf check-in: 4ca2b2f8f5 user: mistachkin tags: mutexDbg2
2017-02-08
19:10 Avoid preparing a SELECT statement each time an UPDATE or DELETE by docid is executed against an fts3 table. Leaf check-in: 9962c10a5c user: dan tags: fts3-seekstmt-cache
2017-02-04
14:30 Merge the latest trunk changes, especially the RTREE enhancement to use sqlite3_blob objects. Leaf check-in: 61bd2a885d user: drh tags: sqlite3_blob_reset
2017-01-23
21:12 Experimental changes to permit a VFS to directly override the initial page size. Leaf check-in: 6413172435 user: mistachkin tags: pagePerSector
2017-01-21
16:21 Fix problems in the previous commit. Leaf check-in: 74ad80eb74 user: dan tags: trigger-trace
15:30 A proof-of-concept for running sqlite3_blob_open() without using OP_Column when operating on a pure key/value table. This demo does not include any corrupt database checking. Uses about 3% fewer CPU cycles on a key/value performance test. Leaf check-in: 4cda3b305b user: drh tags: kv-access-opt-demo
2017-01-19
12:07 Add a prototype of the sqlite3_kv_reset() interface. Leaf check-in: 088c590379 user: drh tags: sqlite3_kv
11:52 Add test cases for the instrumentation on this branch. Fix some OOM handling issues in the same. Leaf check-in: 50ca94b919 user: dan tags: transaction-pages
2017-01-18
23:12 For Windows 8.x and higher, require the SQLITE_WIN32_WIN8_SECTOR_SIZE compile-time option in order to enable sector size determination. Leaf check-in: 47beb55c5b user: mistachkin tags: winSectorSize
2017-01-16
11:54 An example showing how to improve performance of sqlite3VdbeSerialPut() using the GCC intrinsic function __builtin_bswap64(). Leaf check-in: e42ed9b4ad user: drh tags: builtin-bswap64
2017-01-12
15:19 Test case macros to show that the previous check-in is well tested. Leaf check-in: bd8b977abb user: drh tags: extra-testcase-macros
2017-01-09
20:57 Merge latest changes from trunk, and also move the perf-counter into the inner loop of sqlite3BtreeMovetoUnpacked(). Leaf check-in: ff9eab9587 user: drh tags: vdbe-aux-perf
2017-01-06
16:32 Version 3.16.2 Leaf check-in: a65a62893c user: drh tags: release, branch-3.16, version-3.16.2
2016-12-07
07:46 Merge latest trunk changes into this branch. Leaf check-in: 391344d88a user: dan tags: changebatch
2016-11-28
19:13 Version 3.15.2 Leaf check-in: bbd85d235f user: drh tags: release, branch-3.15, version-3.15.2
2016-11-10
21:19 Break up the sqlite3BtreeMovetoUnpacked() routine into an eponymous routine and sqlite3BtreeMovetoIntkey(). Each routine specializes in a single kind of btree. Leaf check-in: 9a64a4f235 user: drh tags: split-moveto
2016-10-25
15:39 Enhance the "PRAGMA index_info" and "PRAGMA index_xinfo" statements so that they work on WITHOUT ROWID tables and provide information about the underlying index btree that implements the WITHOUT ROWID table. Leaf check-in: fe49fb0313 user: drh tags: index-info-on-table
2016-10-20
18:20 Add the ability for the PRAGMA statement to accept multiple arguments. Currently all arguments other than the first are ignored. Leaf check-in: fd81d8a430 user: drh tags: multi-arg-pragma
2016-10-17
23:44 Fix SQLITE_DBCONFIG_REQUIRE_TXN so that it allows BEGIN IMMEDAITE and BEGIN EXCLUSIVE to run outside of a transaction. Leaf check-in: 29997f797f user: drh tags: require-write-txn
19:00 Escape non-ASCII character from an ICU extension comment. Cherrypick of [5ec02ecf3d20ce7e]. Leaf check-in: a3a96c4da3 user: mistachkin tags: mutexDbg
2016-09-12
18:50 Version 3.14.2 Leaf check-in: 29dbef4b85 user: drh tags: release, branch-3.14, version-3.14.2
2016-08-13
14:30 Questionable changes to support interruptible checkpoint in ZipVFS. Leaf check-in: c7a9f26d11 user: dan tags: interruptible-checkpoint
2016-08-10
03:35 Try to make pcache1TruncateUnsafe() run faster for the case where iLimit is very close to iMaxKey. Leaf check-in: 9ab53605d5 user: drh tags: debug
2016-07-14
20:19 Experimental patch restore the slight bias in btree-balancing immediately after the change to reduces the amount of memcpy() work done by balancing. Leaf check-in: 46bd9533c0 user: drh tags: btree-balance-bias
2016-06-24
02:21 Provide for a separate default page size for TEMP and transient database files and initialize that separate default page size to 1024 instead of 4096. Leaf check-in: a2778ae494 user: drh tags: temp-page-size
2016-05-03
19:36 Add the experimental SQLITE_FCNTL_WIN32_GET_HANDLE file control. Leaf check-in: b6ddabe181 user: mistachkin tags: win32GetHandle
2016-04-18
17:30 Version 3.12.2 Leaf check-in: 92dc59fd5a user: drh tags: release, branch-3.12.0, version-3.12.2
2016-04-14
19:29 Work toward improving analysis and code generation for DISTINCT and aggregate queries. Leaf check-in: 129083bd5e user: drh tags: better-distinct-agg
2016-04-08
21:35 Attempt to treat the arguments to a table-valued function as if they occur in the ON clause of a LEFT JOIN rather than in the WHERE clause. But this causes undesirable behavior with generate_series, as demonstrated by test cases. This is an incremental check-in pending further work. Leaf check-in: 00ac73a01c user: drh tags: tabfunc-in-left-join
2016-04-05
00:44 Avoid unnecessary memset() operations in sqlite3PagerGet(). Leaf check-in: 0c97b80240 user: drh tags: pager-get-noinit
2016-03-31
21:36 Version 3.9.3 Leaf check-in: dfbfd34b3f user: drh tags: release, branch-3.9, version-3.9.3
2016-03-29
21:19 Fix some code and test coverage issues in fts5_index.c. Leaf check-in: 7635c68018 user: dan tags: fts5
2016-03-04
19:55 Simplify the computation of Index.aAvgEq. Leaf check-in: c448873006 user: drh tags: analyze-worst-case
2016-03-03
16:17 Version 3.11.1 Leaf check-in: f047920ce1 user: drh tags: release, branch-3.11, version-3.11.1
2016-02-27
19:03 More compact implementation of PRAGMA onconflict, and some test cases. Leaf check-in: 3e5d38f5b3 user: drh tags: pragma-onconflict
2016-02-04
02:34 Add and use the sqlite3VdbeZeroRegister() interface for coding the common operation of writing zero into a register. Leaf check-in: 1c8d300189 user: drh tags: zero-register
2016-02-02
00:59 Add the SQLITE_DBCONFIG_REQUIRE_WRITE_TXN connection setting, which if enabled requires all write operations to be enclosed within BEGIN ... COMMIT. Leaf check-in: 7453790c3b user: drh tags: require-write-txn
2016-01-26
20:08 Further minor performance improvements and code-size reductions related to fts5 column filters on detail=col tables. Leaf check-in: b4ac61aeee user: dan tags: fts5-perf
15:23 Change the automatic index mechanism so that it avoids creating transient indexes on columns that are known to have low cardinality. Leaf check-in: 12ef3a8f3d user: drh tags: autoindex-planning
2016-01-20
15:27 Version 3.10.2 Leaf check-in: 17efb4209f user: drh tags: release, branch-3.10, version-3.10.2
2015-12-30
20:50 Use the OvflOffset() macro to try to remove some magic numbers from btree.c. Leaf check-in: 1541607d45 user: drh tags: ovfloffset-macro
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. Leaf check-in: 896a06cc18 user: drh tags: optimize-vdbecursor
2015-12-12
19:23 Update some stale comments in delete.c. No changes to code. Leaf check-in: f59a33260c user: dan tags: onepass-delete-or
2015-11-21
17:53 Add a new OP_BColumn opcode where the cursor is guaranteed to be of type CURTYPE_BTREE and is thus able to skip some checks and run slightly faster. Leaf check-in: 093e0d10a8 user: drh tags: btree-column-opcode
2015-10-17
01:00 Change the code generator for UPDATE to generate code in an order that might run more efficiently in many cases. Leaf check-in: c6239bf943 user: drh tags: improved-update
2015-10-16
03:34 Whenever two or more OP_Column opcodes on the same cursor occur in succession, try to reordering them so that the one that extracts the right-most column is first, so that it will warm up the row cache for all those that follow. This gives a small performance boost. Leaf check-in: 08e8f04d12 user: drh tags: reorder-column-opcodes
2015-10-15
21:13 Merge updates from trunk. Leaf check-in: 4049368008 user: mistachkin tags: mutexInitIsInitReCheck
21:12 Merge updates from trunk. Leaf check-in: a447cf90dd user: mistachkin tags: mutexInitSimpleCmpSwap
20:17 Experiments with an OP_Unpack opcode that extracts multiple columns from a record without caching. Leaf check-in: 39ae92f5c6 user: drh tags: unpack-opcode
2015-09-28
23:45 Avoid unnecessary cursors and seeking when running a DELETE against a WITHOUT ROWID table. Leaf check-in: 70ec88b299 user: drh tags: delete-without-rowid-opt
2015-09-25
20:18 Fix a faulty assert() on the benign-malloc controller callback in test_malloc.c. Leaf check-in: 64f2cb8dd2 user: drh tags: malloc-testing
2015-08-13
21:43 Convert the hint expression of the CursorHint opcode into a string for display by EXPLAIN. Leaf check-in: 12640cb222 user: drh tags: cursor-hints-displayP4
2015-08-11
13:41 Add some extra timestamps to the experimental log output. Leaf check-in: b09e3ea7b8 user: dan tags: experimentalIoLog
2015-08-07
09:42 Within a write-transaction on a wal database in mmap mode, check the page-cache for an entry before the wal file. This can be faster if the wal file is very large. Leaf check-in: 3a82c8e6cb user: dan tags: mmap-wal-bigtrans
2015-06-20
18:13 Split out all four cases of cellSizePtr() into different methods, each optimized for the specific page type. This gives a 0.36% performance increase at a cost of about 300 bytes of code. Leaf check-in: 522502ec18 user: drh tags: btree-opt
2015-06-13
19:05 Added test cases based on Bruce Momjian's talk on SQL NULLs. Leaf check-in: 68c168b5e5 user: drh tags: is-distinct-from
2015-06-11
17:58 Merge trunk fixes. Leaf check-in: 1df8cbbea6 user: drh tags: view-optimization
2015-06-02
16:09 Add the built-in affinity() SQL function. This turns out to be not as useful as originally envisioned, so abandon it on a branch. Leaf check-in: 80889306bf user: drh tags: affinity-func
2015-05-13
04:52 Merge updates from trunk. Leaf check-in: 10ee36d012 user: mistachkin tags: get-trace
2015-05-02
18:25 Add the SQLITE_LIMIT_PRINTF_WIDTH setting for sqlite3_limit() and associated logic for preventing DOS attacks using printf() with oversized widths or precisions. Leaf check-in: f8b159794c user: drh tags: limit-printf-width
2015-04-22
14:41 Prototype for an sqlite3_db_log() interface. Leaf check-in: 658e20f554 user: drh tags: sqlite3_db_log
2015-04-15
19:13 Add the BtCursor.pPage field which is the current page to which the cursor points, for a very small performance gain. Leaf check-in: a200e1eae9 user: drh tags: btree-current-page-cache
2015-04-10
08:28 Update this branch with the latest changes from sorter-opt. Leaf check-in: 08c0b19b89 user: dan tags: insert-select-opt
2015-04-06
22:05 Detect and suppress an endless loops in clearDatabasePage() that might result from a corrupt database file. This is an edited cherry-pick from [30011ad2f55c] and [395bb3e677a]. Leaf check-in: e5f5ef008d user: drh tags: apple-osx-385
2015-03-30
19:56 Optimize CREATE INDEX, REINDEX and VACUUM statements by taking better advantage of the fact that index keys are being inserted into b-trees in sorted order. Leaf check-in: 763d2bc74b user: dan tags: mistake
2015-03-25
00:09 Backport the 'stdcall' related enhancements from trunk. Leaf check-in: cbb93d1aa1 user: mistachkin tags: stdcall-3.8.8
2015-02-26
14:27 In the command-line shell, change the units on the ".width" directive from bytes to characters. Leaf check-in: b1a9e2916f user: drh tags: cli-char-width
2015-02-25
13:29 Version 3.8.8.3 Leaf check-in: 9d6c1880fb user: drh tags: release, branch-3.8.8, version-3.8.8.3
2015-02-02
22:19 Add an experimental pragma "PRAGMA preload;" that preloads the pcache with the entire database file. Leaf check-in: 6dca23e64e user: drh tags: preload-pragma
2014-12-09
01:34 Version 3.8.7.4 Leaf check-in: f66f7a17b7 user: drh tags: release, version-3.8.7.4, branch-3.8.7
2014-10-23
17:26 Add debugging code to count the number of iterations of each loop made as part of statement execution. Leaf check-in: c6a5b67ae1 user: dan tags: debug-loopcounters
2014-10-02
09:27 Fix a segfault that could occur if an 'optimize' command was issued on an FTS table that contained at least one row but zero terms. Leaf check-in: b21746ac11 user: dan tags: branch-3.7.14
2014-09-29
18:47 Add the OPFLAG_MULTICOLUMN flag to the OP_Column opcode. Rearrange OP_Column instructions to take advantage of the new flag for a small performance increase Leaf check-in: 5e5d6e8680 user: drh tags: faster-OP_Column
2014-08-12
13:32 Remove support for Win9x. Leaf check-in: 169fc47e16 user: drh tags: drop-win9x-support
2014-07-31
17:47 Try to reuse sorter statements in fts5. Does not work due to circular references on VTable object. Leaf check-in: bc14e64bdf user: dan tags: save_sorter_stmt
2014-06-17
15:13 Small tweaks to the query planner to get it to try harder to use an index for sorting and to avoid using automatic indexes on constant terms. Leaf check-in: 2d9de154f8 user: drh tags: branch-3.8.3
2014-06-10
20:18 Proposed change to the fix for ticket [1c69be2dafc28b] such that legacy applications that were exploiting the older buggy behavior in SQLite continue to work. Leaf check-in: 401a0ca3dd user: drh tags: group-by-name-resolution
2014-05-28
09:56 Moved to "mistake" because this commit contains a typo causing a test to fail. Was: Add an extra test to further verify that the FTS notindexed option is working properly. Leaf check-in: 7d445e593a user: dan tags: mistake
2014-05-19
19:26 Fix harmless compiler warnings in MSVC. Leaf check-in: aa7e2041a3 user: drh tags: safer-malloc
2014-05-09
17:17 Merge recent trunk changes into the orderby-planning branch. Leaf check-in: 8d8609d6c6 user: drh tags: orderby-planning
2014-05-06
15:28 Experimental changes that reduce the size of Expr objects from 72 to 64 bytes each on x64 and from 48 to 44 bytes each on x32. Leaf check-in: 8ad0a123a2 user: drh tags: smaller-expr
2014-05-05
22:49 Add the "omit_check_constraints" pragma that causes the check constraint expressions to be omitted from the parse tree. Leaf check-in: f1a4bf01a2 user: drh tags: reduce-schema-size
2014-04-03
16:53 Version 3.8.4.3 Leaf check-in: a611fa96c4 user: drh tags: release, version-3.8.4.3, branch-3.8.4
2014-02-26
19:05 Only run the OP_OpenRead opcodes for a correlated subquery once, on the initial iteration. Keep the cursor open for subsequent runs. This was suppose to be a performance enhancement, but it is difficult to come up with a query where is makes a significant difference. Hence, the change is getting parked in a branch. Leaf check-in: 3ad687b7aa user: drh tags: open-only-once
2014-02-12
15:05 Various fixes and test case updates so that veryquick.test passes again. Leaf check-in: f352ef57e3 user: dan tags: deferred-open
2014-02-06
14:59 Change more OP_OpenEphemeral operations to OP_OpenHash. Leaf check-in: 881164cf6e user: drh tags: subquery-codegen-refactor
2014-01-28
00:49 Provide hints to the btree layer Next and Previous primitives to let them know if they can be no-ops if the underlying index is unique. Leaf check-in: a2c347faf9 user: drh tags: branch-3.8.2
2013-11-14
15:35 An experimental virtual tables for showing the content of internal schema objects. Leaf check-in: d1fbc6ca18 user: drh tags: schema2-vtab
2013-10-30
12:30 Have the shell ".timer on" command cause the shell to report wall-clock time for each query (as well as user and system CPU time). Leaf check-in: 5530cdc485 user: dan tags: shell-wall-clock
2013-10-07
16:53 Try to remember statistics from ANALYZE using LogEst instead of u64. Leaf check-in: 8e78557a40 user: drh tags: log-stats
2013-09-13
19:08 VSIX tooling changes to support Visual Studio 2013. Leaf check-in: e8ac4a1227 user: mistachkin tags: branch-3.8.0
2013-09-02
23:40 Add the experimental SQLITE_DEFAULT_INDEX_SHAPE=1 compile-time option that makes a much more pessimistic guess at the effectiveness of unanalyzed indices. Leaf check-in: d8daaba7da user: drh tags: index-shape-1
2013-04-12
11:52 Version 3.7.16.2 Leaf check-in: cbea02d938 user: drh tags: release, branch-3.7.16, version-3.7.16.2
2013-04-10
03:22 Backport the multi-process tester to the last released version. Leaf check-in: bf6ca21b36 user: mistachkin tags: branch-3.7.16
2013-04-01
14:20 Minor changes to unixMapfile() function. Leaf check-in: 80c63443c4 user: dan tags: two-mappings
2013-01-26
19:26 Add a single test case to fts4unicode.test to verify that title-case maps to lower case. Leaf check-in: 46f7c9301e user: drh tags: branch-3.7.15
2012-12-06
20:27 Cherrypick [79ef8e3c77] (Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements). Leaf check-in: 34aafb7436 user: dan tags: branch-3.7.9
2012-10-25
23:47 Further work on getting ssdsim to run. This is an incremental checkin to save my place while jumping off to work on other things. Leaf check-in: ae2f1627b1 user: drh tags: ssdsim
2012-10-16
21:08 An optimization that converts "a IN (b)" into "a==b". Seems to work, but needs additional test cases. Leaf check-in: 8b4c3c5e50 user: drh tags: degenerate_IN
2012-10-04
22:45 Merge the 3.7.14.1 release including the fix for the LEFT JOIN problem into the sessions branch. Leaf check-in: 17644c0e33 user: drh tags: sessions-3.7.14
2012-08-25
00:49 Backport check-in [62678be3df35cd]: When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. Leaf check-in: 865dfcbaa5 user: drh tags: branch-3.7.2
2012-08-22
15:16 Do not let the multi-core sorter use lookaside memory, which is not thread-safe. Leaf check-in: acdc7d1270 user: drh tags: threads-sort-ex1
2012-08-15
15:57 Experimental change to speed up ORDER BY clauses that sort based on a single expression. Leaf check-in: 2bb8c49261 user: dan tags: sorter-exp
2012-08-07
01:37 Parser bug fix: Make sure the table constraints allowed by prior releases can still be parsed, even if they are technically not allowed by the syntax diagram. This is a cherry-pick of [a1c014d8a87c8940b3], [38bf90af1ede6ee64e], and [e536ac041815b118c4]. Leaf check-in: 28aed847c6 user: drh tags: apple-osx-ml
2012-05-04
13:22 Minor tweaks to the hebrew transliteration tables. Leaf check-in: 7b6de5c35d user: drh tags: translit-tokenizer
2012-04-04
13:51 Fix the multiplexor logging so that it works with SQLITE_ENABLE_8_3_NAMES. Leaf check-in: 627eff32a2 user: drh tags: nx-devkit
2011-12-23
11:07 Fix a problem with [f9c4a7c8f4] as applied to this branch. Leaf check-in: e6a04bf9f1 user: dan tags: branch-3.7.6
2011-10-11
00:09 Patches to the apple-osx-377 branch so that it will compile and run on non-Mac unix platforms. Leaf check-in: b431a63437 user: drh tags: apple-osx-377
2011-06-28
17:39 Version 3.7.7.1. Leaf check-in: af0d91adf4 user: dan tags: release, branch-3.7.7, version-3.7.7.1
2011-06-21
15:34 Backport the localtime() failure patch from trunk. Ticket [bd484a090c8077]. Leaf check-in: 2f5b37122b user: drh tags: branch-3.6.1
2011-06-01
11:26 Toward version 3.7.5.1. This check-in updates the version number and also patches the pager so that it never spills cache while in WAL mode. The latter patch fixes ticket [2d1a5c67dfc23] and also prevents excessive WAL file sizes if the pager cache starts thrashing. A few test cases fail. Leaf check-in: 2e5a912ad7 user: drh tags: branch-3.7.5
2011-05-19
02:34 Bring the apple-wal-readonly branch up to date with the latest changes in apple-osx, and especially the fix for disappearing WAL transactions. Leaf check-in: 5791232778 user: drh tags: apple-wal-readonly
2011-02-23
14:33 Automatically retry system calls that fail with EINTR. This is a backport of the changes from [b9d29ea385bafc] and [af9ba2a6d2c379]. Leaf check-in: 8609a15dfa user: drh tags: branch-3.7.4
2011-02-19
14:19 Changes which attempt to address an obscure SQLITE_PROTOCOL error. Leaf check-in: 1725aa7501 user: drh tags: wal-trace-375
2011-01-05
13:07 Cherrypick the WAL error logging from the pre-3.7.5 line into a branch for version 3.7.2. Include the sqlite3_vsnprintf() interface. This checkin is intended for debugging and not for release. Leaf check-in: 6549e7672b user: drh tags: wal-trace-372
2010-10-02
01:01 Backport the very lastest R-Tree in order to take advantage of its enhanced robustness to corrupt databases. Leaf check-in: 29a681dd7b user: drh tags: apple-osx-3623
01:00 Fix the amalgamation builder so that it works with the rtree updates of the prior check-in. Leaf check-in: 265b0b29b8 user: drh tags: branch-3.6.23
2010-08-04
12:31 Version 3.7.0.1 Leaf check-in: 042a1abb03 user: drh tags: release, branch-3.7.0
2010-03-22
23:55 Sync the database file after a rollback. This is a cherrypick merge of check-in [b21b911f23]. Leaf check-in: 82dd61fccf user: drh tags: branch-3.6.22
2010-01-30
23:08 The iInUseDB and iInUseMM variables do not need to be volatile. Leaf check-in: bb18f57852 user: drh tags: branch-3.5.9
2009-12-16
23:28 Fix for the "(x AND y) OR z" bug backported to version 3.6.21. Leaf check-in: 867347323b user: drh tags: branch-3.6.21
2009-11-04
18:16 Edit [eb7a544fe49d1626|eb7a544fe4]: Change background color to "#ffc0d0". Edit check-in comment. Timestamp 2009-11-04 13:30:02. artifact: f228c7ca06 user: drh
2009-10-30
13:26 Version 3.6.16.1 Leaf check-in: 2a832b19b6 user: drh tags: release, branch_3_6_16
2009-09-03
19:43 Fix a VDBE stack overflow issue with the UPDATE statement. Leaf check-in: 715cecb8c7 user: drh tags: branch-3.3.6
2009-05-25
15:00 Version 3.6.14.2 (CVS 6680) Leaf check-in: ab76d1a252 user: drh tags: branch_3_6_14, release
2008-11-26
18:01 Version 3.6.6.2 (CVS 5960) Leaf check-in: 30a2080777 user: drh tags: branch_3_6_6
2007-08-14
13:20 Back-port critical soft heap limit fixes to version 3.3.17. The following check-ins were back-ported: (4031), (4037), (4097), (4202), (4203), (4207), (4208), (4214). (CVS 4222) Leaf check-in: f0029da32f user: drh tags: branch_3_3_17
2007-05-10
21:31 Backport the stack-size reduction patch in (3673) to version 3.3.13. (CVS 3979) Leaf check-in: e91012b603 user: drh tags: branch_3_3_13
2007-01-08
16:20 Fix a date round-off problem in strftime(). Ticket #2153. (CVS 3575) Leaf check-in: 47fee16ba9 user: drh tags: version_2
2005-12-19
17:27 Version 3.2.8 (CVS 2835) Leaf check-in: e61382aed4 user: drh tags: branch_3_2