Source Code
Not logged in

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

Open leaves:

22:39 Untested incremental check-in. Basic infrastructure for geopoly in place, except for the MATCH operator. Leaf check-in: b27451910b user: drh tags: rtree-geopoly
20:30 Fix "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window frame processing. Leaf check-in: b4e9c68669 user: dan tags: exp-window-functions
14:39 This is an untested proof-of-concept for enhancements to RTree that attempt to use sqlite3_value_nochange() to reduce the amount of work associated with UPDATE operations in cases where either the coordinates or the auxiliary data is unchanged. Leaf check-in: 6f7cfeff70 user: drh tags: rtree-update-optimization
03:46 Add SQLITE_LOCKED_VTAB and SQLITE_CORRUPT_SEQUENCE to sqlite3ErrName(). Also, use SQLITE_CORRUPT_BKPT in one more place. Leaf check-in: eac8888db3 user: mistachkin tags: errCodes
23:51 When doing a one-pass UPDATE or DELETE on virtual tables, close the cursor prior to running VUpdate. This allows one-pass to work on virtual tables that do not allow concurrent reads and writes. Enhance rtree to take advantage of this new capability. Leaf check-in: b816023ce0 user: drh tags: trunk
11:55 Merge latest trunk changes into this branch. Leaf check-in: 72f39efa9b user: dan tags: begin-concurrent-pnu
11:45 Merge latest trunk changes with this branch. Leaf check-in: ae86cf60b6 user: dan tags: begin-concurrent
02:23 Version 3.23.2 Leaf check-in: f139f6f07d user: drh tags: release, branch-3.23, version-3.23.2
13:32 Merge changes from trunk, especially the activation of the cell-overwrite optimization for indexes and WITHOUT ROWID tables. Leaf check-in: a016144b0e user: drh tags: apple-osx
01:18 The ".selecttrace 0x4000" command causes the AST to be output to stdout as a table with four columns. Leaf check-in: 2a75e631ee user: drh tags: ast-trace-demo
12:43 Add the SQLITE_DBCONFIG_RESET_DATABASE control as a replacement for the reset_database pragma. Resetting the database should be hard enough to do that it cannot be done by accident. Leaf check-in: ff836cb8b0 user: drh tags: reset-database
20:49 Better comments on the bindvtab.c implementation. All the two-argument version of the .set command. All bindings from .set and -D are still string. Leaf check-in: 7b2a65a654 user: drh tags: shell-bindings
20:18 Avoid unnecessary OP_Goto instructions on an upsert of a table that only has a single secondary index. Leaf check-in: 97dd21ab90 user: drh tags: upsert-opt
18:43 Fix an error in README-server-edition.html. Leaf check-in: 754ad35cd2 user: dan tags: server-process-edition
17:17 Fix an RBU problem causing errors when updating tables with default collation sequences that require quoting (e.g. COLLATE "ICU_root-u-kn-on"). Cherrypick of [eb4f452e]. Leaf check-in: 5dd61e1cbd user: dan tags: branch-3.22
16:59 Show symbolic SELECT names in EXPLAIN QUERY PLAN output when compiling with SQLITE_ENABLE_SELECTTRACE. Leaf check-in: 16c22ff818 user: drh tags: EQP-improvements
07:49 Fix a problem in test script thread001.test causing a spurious "-1 files were left open" error when run separately. Cherrypick of [1774f1c3b]. Leaf check-in: 6cf8172d94 user: dan tags: branch-3.19
20:09 Update zonefile file to mention the frame cache. Leaf check-in: 84e9351bbd user: dan tags: zonefile
20:00 On unix, the "PRAGMA fsync_interval=N" command causes an extra fdatasync() after writing N bytes of content, to force a write-queue flush in the underlying OS. This is an experimental hack that is not expected to land on trunk. Leaf check-in: b18cc5fee4 user: drh tags: write-queue-flush-hack
16:46 Enable the ".wheretrace" and ".selecttrace" options in the shell when configure is run using --enable-debug. This mirrors a similar change that has already occurred on trunk. Leaf check-in: c4f798b212 user: drh tags: branch-3.9.2
01:56 Enhance the PRAGMA noop_update statement so that the behavior persists across reprepare operations. Leaf check-in: c25da6de1d user: drh tags: noop-update-reprepare
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
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
02:47 Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. Leaf check-in: 2494132a2b user: drh tags: pragma-table-ipk
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
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
18:55 Version 3.21.0 Leaf check-in: 1a584e4999 user: drh tags: release, branch-3.21, version-3.21.0
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
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
14:03 The sqlite3_snapshot_describe() interface useful for debugging snapshot logic. Leaf check-in: 3fbfa9a8e8 user: drh tags: sqlite3_snapshot_describe
08:51 Merge latest trunk changes with this branch. Leaf check-in: 2e57335081 user: dan tags: shared-mapping-hack
18:38 Experimental sqlite3_stmt_retryable() interface. Leaf check-in: ebada0723a user: drh tags: sqlite3_stmt_retryable
18:49 Add the highly-experimental "PRAGMA noop_update=TRUE" command. Leaf check-in: de2e371757 user: drh tags: pragma-noop-update
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
17:32 Add the --enable-update-limit option to the ./configure script. Leaf check-in: f545db6c27 user: drh tags: begin-concurrent-branch-3.19
10:55 Instrumentation and changes in an effort to reduce thread contention. Leaf check-in: c93298d5ae user: drh tags: reduced-thread-contention
16:21 Version 3.20.1 Leaf check-in: 8d3a7ea6c5 user: drh tags: release, branch-3.20, version-3.20.1
19:44 mksourceid still does not work right. Leaf check-in: ca5dcb4a36 user: drh tags: mistake
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
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
12:04 Merge further enhancements to the batch-atomic-write subsystem. Leaf check-in: 4be4265d74 user: drh tags: batch-atomic-write-3.19
20:49 Disable the writecrash.test module on Windows. Leaf check-in: 4c0520d4df user: drh tags: batch-atomic-write
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
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
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
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
18:27 Disable compiler intrinsics when using the Intel C Compiler. Leaf check-in: dbb59f6156 user: drh tags: icc-fix
20:12 Fix bugs in test program tserver.c. Leaf check-in: 093b9108ea user: dan tags: server-edition
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
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
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
18:05 Add debugging functions btreePageOriginFile() and btreePageOriginOffset(). Leaf check-in: 214d238a47 user: dan tags: btree-debug
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
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
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
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
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
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
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
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
21:12 Experimental changes to permit a VFS to directly override the initial page size. Leaf check-in: 6413172435 user: mistachkin tags: pagePerSector
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
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
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
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
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
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
16:32 Version 3.16.2 Leaf check-in: a65a62893c user: drh tags: release, branch-3.16, version-3.16.2
07:46 Merge latest trunk changes into this branch. Leaf check-in: 391344d88a user: dan tags: changebatch
19:13 Version 3.15.2 Leaf check-in: bbd85d235f user: drh tags: release, branch-3.15, version-3.15.2
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
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
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
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
18:50 Version 3.14.2 Leaf check-in: 29dbef4b85 user: drh tags: release, branch-3.14, version-3.14.2
14:30 Questionable changes to support interruptible checkpoint in ZipVFS. Leaf check-in: c7a9f26d11 user: dan tags: interruptible-checkpoint
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
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
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
19:36 Add the experimental SQLITE_FCNTL_WIN32_GET_HANDLE file control. Leaf check-in: b6ddabe181 user: mistachkin tags: win32GetHandle
17:30 Version 3.12.2 Leaf check-in: 92dc59fd5a user: drh tags: release, branch-3.12.0, version-3.12.2
19:29 Work toward improving analysis and code generation for DISTINCT and aggregate queries. Leaf check-in: 129083bd5e user: drh tags: better-distinct-agg
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
00:44 Avoid unnecessary memset() operations in sqlite3PagerGet(). Leaf check-in: 0c97b80240 user: drh tags: pager-get-noinit
21:36 Version 3.9.3 Leaf check-in: dfbfd34b3f user: drh tags: release, branch-3.9, version-3.9.3
21:19 Fix some code and test coverage issues in fts5_index.c. Leaf check-in: 7635c68018 user: dan tags: fts5
19:55 Simplify the computation of Index.aAvgEq. Leaf check-in: c448873006 user: drh tags: analyze-worst-case
16:17 Version 3.11.1 Leaf check-in: f047920ce1 user: drh tags: release, branch-3.11, version-3.11.1
19:03 More compact implementation of PRAGMA onconflict, and some test cases. Leaf check-in: 3e5d38f5b3 user: drh tags: pragma-onconflict
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
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
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
15:27 Version 3.10.2 Leaf check-in: 17efb4209f user: drh tags: release, branch-3.10, version-3.10.2
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
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
19:23 Update some stale comments in delete.c. No changes to code. Leaf check-in: f59a33260c user: dan tags: onepass-delete-or
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
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
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
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
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
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
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
13:41 Add some extra timestamps to the experimental log output. Leaf check-in: b09e3ea7b8 user: dan tags: experimentalIoLog
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
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
19:05 Added test cases based on Bruce Momjian's talk on SQL NULLs. Leaf check-in: 68c168b5e5 user: drh tags: is-distinct-from
17:58 Merge trunk fixes. Leaf check-in: 1df8cbbea6 user: drh tags: view-optimization
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
04:52 Merge updates from trunk. Leaf check-in: 10ee36d012 user: mistachkin tags: get-trace
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
14:41 Prototype for an sqlite3_db_log() interface. Leaf check-in: 658e20f554 user: drh tags: sqlite3_db_log
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
08:28 Update this branch with the latest changes from sorter-opt. Leaf check-in: 08c0b19b89 user: dan tags: insert-select-opt
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
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
00:09 Backport the 'stdcall' related enhancements from trunk. Leaf check-in: cbb93d1aa1 user: mistachkin tags: stdcall-3.8.8
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
13:29 Version Leaf check-in: 9d6c1880fb user: drh tags: release, branch-3.8.8, version-
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
01:34 Version Leaf check-in: f66f7a17b7 user: drh tags: release, version-, branch-3.8.7
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
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
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
13:32 Remove support for Win9x. Leaf check-in: 169fc47e16 user: drh tags: drop-win9x-support
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
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
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
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
19:26 Fix harmless compiler warnings in MSVC. Leaf check-in: aa7e2041a3 user: drh tags: safer-malloc
17:17 Merge recent trunk changes into the orderby-planning branch. Leaf check-in: 8d8609d6c6 user: drh tags: orderby-planning
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
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
16:53 Version Leaf check-in: a611fa96c4 user: drh tags: release, version-, branch-3.8.4
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
15:05 Various fixes and test case updates so that veryquick.test passes again. Leaf check-in: f352ef57e3 user: dan tags: deferred-open
14:59 Change more OP_OpenEphemeral operations to OP_OpenHash. Leaf check-in: 881164cf6e user: drh tags: subquery-codegen-refactor
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
15:35 An experimental virtual tables for showing the content of internal schema objects. Leaf check-in: d1fbc6ca18 user: drh tags: schema2-vtab
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
16:53 Try to remember statistics from ANALYZE using LogEst instead of u64. Leaf check-in: 8e78557a40 user: drh tags: log-stats
19:08 VSIX tooling changes to support Visual Studio 2013. Leaf check-in: e8ac4a1227 user: mistachkin tags: branch-3.8.0
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
11:52 Version Leaf check-in: cbea02d938 user: drh tags: release, branch-3.7.16, version-
03:22 Backport the multi-process tester to the last released version. Leaf check-in: bf6ca21b36 user: mistachkin tags: branch-3.7.16
14:20 Minor changes to unixMapfile() function. Leaf check-in: 80c63443c4 user: dan tags: two-mappings
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
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
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
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
22:45 Merge the release including the fix for the LEFT JOIN problem into the sessions branch. Leaf check-in: 17644c0e33 user: drh tags: sessions-3.7.14
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
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
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
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
13:22 Minor tweaks to the hebrew transliteration tables. Leaf check-in: 7b6de5c35d user: drh tags: translit-tokenizer
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
11:07 Fix a problem with [f9c4a7c8f4] as applied to this branch. Leaf check-in: e6a04bf9f1 user: dan tags: branch-3.7.6
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
17:39 Version Leaf check-in: af0d91adf4 user: dan tags: release, branch-3.7.7, version-
15:34 Backport the localtime() failure patch from trunk. Ticket [bd484a090c8077]. Leaf check-in: 2f5b37122b user: drh tags: branch-3.6.1
11:26 Toward version 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
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
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
14:19 Changes which attempt to address an obscure SQLITE_PROTOCOL error. Leaf check-in: 1725aa7501 user: drh tags: wal-trace-375
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
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
12:31 Version Leaf check-in: 042a1abb03 user: drh tags: release, branch-3.7.0
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
23:08 The iInUseDB and iInUseMM variables do not need to be volatile. Leaf check-in: bb18f57852 user: drh tags: branch-3.5.9
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
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
13:26 Version Leaf check-in: 2a832b19b6 user: drh tags: release, branch_3_6_16
19:43 Fix a VDBE stack overflow issue with the UPDATE statement. Leaf check-in: 715cecb8c7 user: drh tags: branch-3.3.6
15:00 Version (CVS 6680) Leaf check-in: ab76d1a252 user: drh tags: branch_3_6_14, release
18:01 Version (CVS 5960) Leaf check-in: 30a2080777 user: drh tags: branch_3_6_6
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
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
16:20 Fix a date round-off problem in strftime(). Ticket #2153. (CVS 3575) Leaf check-in: 47fee16ba9 user: drh tags: version_2
17:27 Version 3.2.8 (CVS 2835) Leaf check-in: e61382aed4 user: drh tags: branch_3_2