/ Leaves
Login

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

Open leaves:

2019-04-24
17:04
New test cases in test/fuzzdata8.db. Leaf check-in: 7be6222c user: drh tags: trunk
2019-04-23
20:48
Have ".recover" handle "\r" and "\n" in the same way as ".dump". Leaf check-in: f95f0f02 user: dan tags: dbdata
15:21
Minor simplification of NULL value handling for STAT4. Cherrypick of [69bad9257f8db6a2] from trunk. Leaf check-in: 442c177d user: mistachkin tags: branch-3.28
2019-04-18
17:37
Undo change to 'analyze9.test' because the extra output can be useful for debugging. Leaf check-in: f3081e59 user: mistachkin tags: msvc
2019-04-15
15:35
Merge recent changes from trunk into reuse-schema Leaf check-in: 5c6c9e7f user: drh tags: reuse-schema
15:28
Merge all recent enhancements. Leaf check-in: 1cd536ec user: drh tags: begin-concurrent-pnu-wal2
15:17
Merge the latest trunk enhancements. Leaf check-in: 8950f119 user: drh tags: wal2
15:07
Merge the latest enhancements from trunk. Leaf check-in: 6caaaf21 user: drh tags: begin-concurrent-pnu
14:59
Merge the latest enhancements from trunk. Leaf check-in: 7c328e88 user: drh tags: begin-concurrent
14:49
Bring in the latest enhancements from trunk. Leaf check-in: 378230ae user: drh tags: apple-osx
2019-04-12
20:33
Add the socketvfs test extension. Leaf check-in: f5b3ce94 user: dan tags: socketvfs
2019-04-04
22:05
Add the vtab enable/disable options to the sqlite3_db_config TCL command in the testfixture. Leaf check-in: c7052428 user: drh tags: disable-vtab
2019-04-03
17:54
Add a defense-in-depth NEVER() test to the WAL cleanup code. Leaf check-in: 1109942a user: drh tags: branch-3.27
2019-03-20
20:27
Experimental change to apply affinity before running CHECK constraints on an INSERT. Note that in the CHECK constraints, REAL affinity really is REAL affinity, and not numeric affinity. This causes failures in some tests that are assuming affinity is applied after CHECK constraints. Leaf check-in: 9ef69d18 user: drh tags: apply-affinity-first
2019-02-21
18:11
Fix OOM handling in sqlite3NestedParse(). Leaf check-in: e6e9dd5c user: dan tags: nested-parse-oom
2019-02-08
20:55
Use a fast compiler-provided memory barrier exclusively, if such a memory barrier is available. Leaf check-in: df66fec9 user: drh tags: faster-memory-barrier
2019-01-24
16:51
While PRAGMA full_column_names is off (the default) do not make changes to the short_column_names pragma when computing the column names for subqueries. Leaf check-in: 718ead55 user: drh tags: literal-column-names
2019-01-22
18:20
Add the SQLITE_ENABLE_EARLY_CURSOR_CLOSE compile-time option which causes read cursors to be closed after their usefulness ends during a two-pass UPDATE. Leaf check-in: 8790368b user: mistachkin tags: branch-3.26
2019-01-11
15:22
Merge documentation changes from branch "begin-concurrent" into this branch. Leaf check-in: 41e742bd user: dan tags: begin-concurrent-wal2
2019-01-06
01:46
Give symbolic names to the special prepared statements used to implement incremental blob I/O. Leaf check-in: 2a1cc632 user: drh tags: named-blob-I/O
2018-12-28
21:40
Merge performance enhancements and other patches. Leaf check-in: 44e1b55a user: drh tags: factor-out-scalar-subselect
2018-12-26
14:23
Fix a problem with corrupt fts3 database detection introduced by [27199380]. Leaf check-in: ceeb4fba user: dan tags: branch-3.22
2018-12-24
15:15
Merge latest trunk with this branch. Leaf check-in: 606b1ead user: dan tags: mutexfree-shmlock
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. Leaf check-in: 553a923c user: dan tags: branch-3.19
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. Leaf check-in: 4cb67252 user: dan tags: branch-3.9
01:38
Add extra defenses against strategically corrupt databases to fts3/4. Leaf check-in: 4bb21d82 user: drh tags: branch-3.18
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. Leaf check-in: 33a1924e user: drh tags: custom-destructors
20:28
Add a missing OP_ColumnsUsed opcode to code for expressions like "? IN (SELECT ...)" in cases where expression can use an index that may contain NULL values. (Backported fix from version 3.14.0). Leaf check-in: 11368e67 user: drh tags: branch-3.8.9
2018-12-10
16:53
Merge latest mutexfree-shmlock changes into this branch. Leaf check-in: 186b376e user: dan tags: begin-concurrent-pnu-mutexfree-shmlock
16:49
Fix issues with the new normalizer. Leaf check-in: 057d7d40 user: drh tags: normalize-refactor
2018-12-06
20:18
Experimental changes to (optionally) allow double-quoted strings to be checked against known identifiers. Leaf check-in: 73a6b8c1 user: mistachkin tags: normalize_v4
2018-12-04
21:16
When compiled with SQLITE_ENABLE_NORMALIZE, always have sqlite3_exec() enable the SQLITE_PREPARE_NORMALIZE flag. Leaf check-in: 28643d83 user: mistachkin tags: execWithNormalize
01:18
Attempt to make the parser a little faster by storing the ON and USING clause in a single OnUsing object. Leaf check-in: 6770ed08 user: drh tags: on-using-opt
2018-11-23
13:21
Make the winTruncate() method of the windows VFS be a no-op if there are outstanding references to the memory-mapped pages. Otherwise, memory might be deleted out from under those references when the file is remapped during the truncate operation. Leaf check-in: 8576ccb4 user: drh tags: branch-3.25
2018-11-20
16:02
Consolidate the two sqlite3SchemaToIndex() routines. Leaf check-in: dfab7170 user: dan tags: reuse-schema1
2018-10-06
14:33
Ensure each ALTER TABLE statement makes just a single SQLITE_ALTER_TABLE call to the authorizer function. Leaf check-in: dac28547 user: dan tags: alter-auth-callbacks
2018-10-05
20:09
When the left-hand side of a WHERE clause contraint is a UNIQUE column, and that term of the WHERE clause is not used for indexing, assume that the term reduces the number of output rows by half. This is one proposed fix for ticket [e8b674241947eb3ba4] Leaf check-in: 5c243eec user: drh tags: unique-constraint-weights
2018-10-04
18:17
The 0x8000 optimization flag associated with SQLITE_TESTCTRL_OPTIMIZATIONS causes a large penalty (200) to be added to all sorting costs, which encourages the query planner avoid using the sorter. This flag can be used in experiments to help come up with a more accurate estimate of the true cost of sorting. Leaf check-in: 857a1b01 user: drh tags: query-planner-debug
2018-09-27
14:24
Minor enhancement to the pager so that it remembers if the underlying database files is immutable. Leaf check-in: 64db614e user: drh tags: immutable-pager
2018-09-19
20:14
Reduce the size of Expr to 64-bytes. This works somewhat, but there are test failures. More importantly, the size reduction from 80- to 64-bytes has not lowered the schema memory usage, but it has made the code a little bigger and a little slower. So the initial evidence is that this Expr refactoring experiment is not working... Leaf check-in: 24b0f66a user: drh tags: expr-simplify
18:17
A minor code simplification, saved in a branch for future reference. Leaf check-in: 5e458f4a user: drh tags: minor-altertab-simplification
2018-07-20
18:01
Experimental change to ANALYZE so that when computing values for sqlite_stat1, it uses the maximum number for the number of rows having equivalent values, rather than the average. Leaf check-in: 085f17e1 user: drh tags: stat1-max
2018-07-10
15:55
Experimental planner change to avoid a skip-scan if a regular index scan on the same index columns can be done instead. Leaf check-in: 350f29ea user: dan tags: exp-begin-concurrent-pnu
2018-07-04
14:28
Experimental planner change to avoid a skip-scan if a regular index scan on the same index columns can be done instead. Leaf check-in: 32924446 user: dan tags: exp-avoid-expensive-skipscan
2018-06-30
18:54
Have the tokenizer handle fallback for tokens "OVER" and "FILTER" in the same way as it does for "WINDOW". Leaf check-in: 12d819e1 user: dan tags: weak-fallback
2018-06-21
23:43
Improved context for error_log message coming from sqlite3_prepare(). Leaf check-in: 64df1189 user: drh tags: ieee754
2018-06-19
19:16
The file_control_ofd_locks TCL command in testfixture distinguishes between OFD locks unavailable on the platform and OFD locks not used. Leaf check-in: 87a9e9d7 user: drh tags: ofd-locks
2018-06-06
00:36
Attempt to optimize the resolveExprStep() routine by mapping Expr opcodes into a subset of opcodes that resolveExprStep() cares about and only calling the routine when those opcodes are encountered. Is slightly faster, but it seems like the very slight performance bump is not worth the added complexity. Saved on a dead-end branch for historical reference. Leaf check-in: bad4d7a0 user: drh tags: dead-end
2018-05-26
18:03
Experimental change that allows overloaded functions to be analyzed by the xBestIndex method and used by the xFilter method of a virtual table. Leaf check-in: a353b1d7 user: drh tags: vtab-func-constraint
2018-05-25
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: 6f7cfeff 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: eac8888d user: mistachkin tags: errCodes
2018-05-09
02:23
Version 3.23.2 Leaf check-in: f139f6f0 user: drh tags: release, branch-3.23, version-3.23.2
2018-05-01
01:18
The ".selecttrace 0x4000" command causes the AST to be output to stdout as a table with four columns. Leaf check-in: 2a75e631 user: drh tags: ast-trace-demo
2018-04-28
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: ff836cb8 user: drh tags: reset-database
2018-04-27
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: 7b2a65a6 user: drh tags: shell-bindings
2018-04-19
20:18
Avoid unnecessary OP_Goto instructions on an upsert of a table that only has a single secondary index. Leaf check-in: 97dd21ab user: drh tags: upsert-opt
2018-03-31
18:43
Fix an error in README-server-edition.html. Leaf check-in: 754ad35c user: dan tags: server-process-edition
2018-03-19
16:59
Show symbolic SELECT names in EXPLAIN QUERY PLAN output when compiling with SQLITE_ENABLE_SELECTTRACE. Leaf check-in: 16c22ff8 user: drh tags: EQP-improvements
2018-02-27
20:09
Update zonefile README.md file to mention the frame cache. Leaf check-in: 84e9351b user: dan tags: zonefile
2018-02-15
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: b18cc5fe user: drh tags: write-queue-flush-hack
2018-02-02
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: c4f798b2 user: drh tags: branch-3.9.2
2018-01-23
01:56
Enhance the PRAGMA noop_update statement so that the behavior persists across reprepare operations. Leaf check-in: c25da6de user: drh tags: noop-update-reprepare
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: 8b8314cb user: drh tags: rtree-one-pass
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: 3d6fba62 user: drh tags: regexp-span
2017-11-28
02:47
Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. Leaf check-in: 2494132a 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: a33f88ac user: drh tags: distinct-early-out
2017-10-24
18:55
Version 3.21.0 Leaf check-in: 1a584e49 user: drh tags: release, branch-3.21, version-3.21.0
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: 8d2a1cca user: drh tags: est_count_pragma
2017-09-21
14:03
The sqlite3_snapshot_describe() interface useful for debugging snapshot logic. Leaf check-in: 3fbfa9a8 user: drh tags: sqlite3_snapshot_describe
2017-09-18
08:51
Merge latest trunk changes with this branch. Leaf check-in: 2e573350 user: dan tags: shared-mapping-hack
2017-09-13
18:38
Experimental sqlite3_stmt_retryable() interface. Leaf check-in: ebada072 user: drh tags: sqlite3_stmt_retryable
2017-09-12
18:49
Add the highly-experimental "PRAGMA noop_update=TRUE" command. Leaf check-in: de2e3717 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: e63d1a7c user: drh tags: mutex-free-randomness
2017-08-28
17:32
Add the --enable-update-limit option to the ./configure script. Leaf check-in: f545db6c 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: c93298d5 user: drh tags: reduced-thread-contention
2017-08-24
16:21
Version 3.20.1 Leaf check-in: 8d3a7ea6 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: ca5dcb4a user: drh tags: mistake
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: f08d63b4 user: mistachkin tags: mmap-size-limit
2017-07-31
12:04
Merge further enhancements to the batch-atomic-write subsystem. Leaf check-in: 4be4265d user: drh tags: batch-atomic-write-3.19
2017-07-28
20:49
Disable the writecrash.test module on Windows. Leaf check-in: 4c0520d4 user: drh tags: batch-atomic-write
2017-07-21
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: 5a3022e0 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: a66a5b39 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: f0f49224 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: 10556ee4 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: d6a44b35 user: drh tags: branch-3.17
2017-07-08
18:27
Disable compiler intrinsics when using the Intel C Compiler. Leaf check-in: dbb59f61 user: drh tags: icc-fix
2017-06-28
20:12
Fix bugs in test program tserver.c. Leaf check-in: 093b9108 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: c21628e9 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: e3038fbf 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: c81f260c user: drh tags: analyze-empty-tables
2017-05-27
18:05
Add debugging functions btreePageOriginFile() and btreePageOriginOffset(). Leaf check-in: 214d238a 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: aacac906 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: 694fe0b2 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: 7a62fc6a 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: 9626b41e 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: c1adf959 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: 38298ef9 user: drh tags: apple-increased-sorting-cost
02:07
Merge fixes from trunk. Leaf check-in: 662e8ccf user: drh tags: increased-sorting-cost
2017-02-15
17:47
simple test cases for carray_asc. Leaf check-in: 1d4759c1 user: drh tags: carray_asc
01:02
Make SQLITE_GET_MUTEX_TIME a proper noop on non-Win32/non-POSIX. Leaf check-in: 4ca2b2f8 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: 9962c10a 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: 61bd2a88 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: 64131724 user: mistachkin tags: pagePerSector
2017-01-21
16:21
Fix problems in the previous commit. Leaf check-in: 74ad80eb 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: 4cda3b30 user: drh tags: kv-access-opt-demo
2017-01-19
12:07
Add a prototype of the sqlite3_kv_reset() interface. Leaf check-in: 088c5903 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: 50ca94b9 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: 47beb55c 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: e42ed9b4 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: bd8b977a 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: ff9eab95 user: drh tags: vdbe-aux-perf
2017-01-06
16:32
Version 3.16.2 Leaf check-in: a65a6289 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: 391344d8 user: dan tags: changebatch
2016-11-28
19:13
Version 3.15.2 Leaf check-in: bbd85d23 user: drh tags: release, version-3.15.2, branch-3.15
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: 9a64a4f2 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: fe49fb03 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: fd81d8a4 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: 29997f79 user: drh tags: require-write-txn
19:00
Escape non-ASCII character from an ICU extension comment. Cherrypick of [5ec02ecf3d20ce7e]. Leaf check-in: a3a96c4d user: mistachkin tags: mutexDbg
2016-09-12
18:50
Version 3.14.2 Leaf check-in: 29dbef4b 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: c7a9f26d 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: 9ab53605 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: 46bd9533 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: a2778ae4 user: drh tags: temp-page-size
2016-05-03
19:36
Add the experimental SQLITE_FCNTL_WIN32_GET_HANDLE file control. Leaf check-in: b6ddabe1 user: mistachkin tags: win32GetHandle
2016-04-18
17:30
Version 3.12.2 Leaf check-in: 92dc59fd 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: 129083bd 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: 00ac73a0 user: drh tags: tabfunc-in-left-join
2016-04-05
00:44
Avoid unnecessary memset() operations in sqlite3PagerGet(). Leaf check-in: 0c97b802 user: drh tags: pager-get-noinit
2016-03-29
21:19
Fix some code and test coverage issues in fts5_index.c. Leaf check-in: 7635c680 user: dan tags: fts5
2016-03-04
19:55
Simplify the computation of Index.aAvgEq. Leaf check-in: c4488730 user: drh tags: analyze-worst-case
2016-03-03
16:17
Version 3.11.1 Leaf check-in: f047920c 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: 3e5d38f5 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: 1c8d3001 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: 7453790c 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: b4ac61ae 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: 12ef3a8f user: drh tags: autoindex-planning
2016-01-20
15:27
Version 3.10.2 Leaf check-in: 17efb420 user: drh tags: release, version-3.10.2, branch-3.10
2015-12-30
20:50
Use the OvflOffset() macro to try to remove some magic numbers from btree.c. Leaf check-in: 1541607d 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: 896a06cc user: drh tags: optimize-vdbecursor
2015-12-12
19:23
Update some stale comments in delete.c. No changes to code. Leaf check-in: f59a3326 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: 093e0d10 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: c6239bf9 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: 08e8f04d user: drh tags: reorder-column-opcodes
2015-10-15
21:13
Merge updates from trunk. Leaf check-in: 40493680 user: mistachkin tags: mutexInitIsInitReCheck
21:12
Merge updates from trunk. Leaf check-in: a447cf90 user: mistachkin tags: mutexInitSimpleCmpSwap
20:17
Experiments with an OP_Unpack opcode that extracts multiple columns from a record without caching. Leaf check-in: 39ae92f5 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: 70ec88b2 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: 64f2cb8d 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: 12640cb2 user: drh tags: cursor-hints-displayP4
2015-08-11
13:41
Add some extra timestamps to the experimental log output. Leaf check-in: b09e3ea7 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: 3a82c8e6 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: 522502ec 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: 68c168b5 user: drh tags: is-distinct-from
2015-06-11
17:58
Merge trunk fixes. Leaf check-in: 1df8cbbe 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: 80889306 user: drh tags: affinity-func
2015-05-13
04:52
Merge updates from trunk. Leaf check-in: 10ee36d0 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: f8b15979 user: drh tags: limit-printf-width
2015-04-22
14:41
Prototype for an sqlite3_db_log() interface. Leaf check-in: 658e20f5 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: a200e1ea 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: 08c0b19b 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: e5f5ef00 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: 763d2bc7 user: dan tags: mistake
2015-03-25
00:09
Backport the 'stdcall' related enhancements from trunk. Leaf check-in: cbb93d1a 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: b1a9e291 user: drh tags: cli-char-width
2015-02-25
13:29
Version 3.8.8.3 Leaf check-in: 9d6c1880 user: drh tags: release, version-3.8.8.3, branch-3.8.8
2015-02-02
22:19
Add an experimental pragma "PRAGMA preload;" that preloads the pcache with the entire database file. Leaf check-in: 6dca23e6 user: drh tags: preload-pragma
2014-12-09
01:34
Version 3.8.7.4 Leaf check-in: f66f7a17 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: c6a5b67a 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: b21746ac 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: 5e5d6e86 user: drh tags: faster-OP_Column
2014-08-12
13:32
Remove support for Win9x. Leaf check-in: 169fc47e 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: bc14e64b 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: 2d9de154 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: 401a0ca3 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: 7d445e59 user: dan tags: mistake
2014-05-19
19:26
Fix harmless compiler warnings in MSVC. Leaf check-in: aa7e2041 user: drh tags: safer-malloc
2014-05-09
17:17
Merge recent trunk changes into the orderby-planning branch. Leaf check-in: 8d8609d6 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: 8ad0a123 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: f1a4bf01 user: drh tags: reduce-schema-size
2014-04-03
16:53
Version 3.8.4.3 Leaf check-in: a611fa96 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: 3ad687b7 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: f352ef57 user: dan tags: deferred-open
2014-02-06
14:59
Change more OP_OpenEphemeral operations to OP_OpenHash. Leaf check-in: 881164cf 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: a2c347fa 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: d1fbc6ca 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: 5530cdc4 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: 8e78557a user: drh tags: log-stats
2013-09-13
19:08
VSIX tooling changes to support Visual Studio 2013. Leaf check-in: e8ac4a12 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: d8daaba7 user: drh tags: index-shape-1
2013-04-12
11:52
Version 3.7.16.2 Leaf check-in: cbea02d9 user: drh tags: release, version-3.7.16.2, branch-3.7.16
2013-04-10
03:22
Backport the multi-process tester to the last released version. Leaf check-in: bf6ca21b user: mistachkin tags: branch-3.7.16
2013-04-01
14:20
Minor changes to unixMapfile() function. Leaf check-in: 80c63443 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: 46f7c930 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: 34aafb74 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: ae2f1627 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: 8b4c3c5e 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: 17644c0e 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: 865dfcba 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: acdc7d12 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: 2bb8c492 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: 28aed847 user: drh tags: apple-osx-ml
2012-05-04
13:22
Minor tweaks to the hebrew transliteration tables. Leaf check-in: 7b6de5c3 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: 627eff32 user: drh tags: nx-devkit
2011-12-23
11:07
Fix a problem with [f9c4a7c8f4] as applied to this branch. Leaf check-in: e6a04bf9 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: b431a634 user: drh tags: apple-osx-377
2011-06-28
17:39
Version 3.7.7.1. Leaf check-in: af0d91ad user: dan tags: release, version-3.7.7.1, branch-3.7.7
2011-06-21
15:34
Backport the localtime() failure patch from trunk. Ticket [bd484a090c8077]. Leaf check-in: 2f5b3712 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: 2e5a912a 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: 57912327 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: 8609a15d 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: 1725aa75 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: 6549e767 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: 29a681dd 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: 265b0b29 user: drh tags: branch-3.6.23
2010-08-04
12:31
Version 3.7.0.1 Leaf check-in: 042a1abb 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: 82dd61fc 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: bb18f578 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: 86734732 user: drh tags: branch-3.6.21
2009-10-30
13:26
Version 3.6.16.1 Leaf check-in: 2a832b19 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: 715cecb8 user: drh tags: branch-3.3.6
2009-05-25
15:00
Version 3.6.14.2 (CVS 6680) Leaf check-in: ab76d1a2 user: drh tags: branch_3_6_14, release
2008-11-26
18:01
Version 3.6.6.2 (CVS 5960) Leaf check-in: 30a20807 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: f0029da3 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: e91012b6 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: 47fee16b user: drh tags: version_2
2005-12-19
17:27
Version 3.2.8 (CVS 2835) Leaf check-in: e61382ae user: drh tags: branch_3_2