Not logged in

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

Open leaves:

22:53 [b8218129bc] Leaf: More compiler warning fixes for GCC related to the auto-extension mechanism. (user: mistachkin, tags: trunk)
19:47 [cc3f6542be] Leaf: Fix further issues with multi-column IN(...) operators. Also some error handling cases surrounding row values. (user: dan, tags: rowvalue)
18:42 [9765744586] Leaf: Merge recent trunk fixes. (user: drh, tags: apple-osx)
11:47 [613c1ceaf4] Leaf: Temporarily add extra sqlite3_log() calls to this version to help with debugging a performance problem. (user: dan, tags: debug)
20:19 [46bd9533c0] Leaf: Experimental patch restore the slight bias in btree-balancing immediately after the change to reduces the amount of memcpy() work done by balancing. (user: drh, tags: btree-balance-bias)
08:32 [2c61b7ab18] Leaf: Fix a typo in test program bc_test1.c. (user: dan, tags: begin-concurrent)
02:21 [a2778ae494] Leaf: 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. (user: drh, tags: temp-page-size)
19:36 [b6ddabe181] Leaf: Add the experimental SQLITE_FCNTL_WIN32_GET_HANDLE file control. (user: mistachkin, tags: win32GetHandle)
15:44 [8183fa6829] Leaf: Merge the latest changes from trunk. (user: drh, tags: skip-ahead-distinct)
17:30 [92dc59fd5a] Leaf: Version 3.12.2 (user: drh, tags: release, branch-3.12.0, version-3.12.2)
19:29 [129083bd5e] Leaf: Work toward improving analysis and code generation for DISTINCT and aggregate queries. (user: drh, tags: better-distinct-agg)
21:35 [00ac73a01c] Leaf: 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. (user: drh, tags: tabfunc-in-left-join)
17:50 [b7570ac14d] Leaf: Add the SQLITE_DBCONFIG_REQUIRE_TXN argument for sqlite3_dbconfig() which when set requires an explicit transaction before updating the database. (user: drh, tags: require-write-txn)
00:44 [0c97b80240] Leaf: Avoid unnecessary memset() operations in sqlite3PagerGet(). (user: drh, tags: pager-get-noinit)
21:36 [dfbfd34b3f] Leaf: Version 3.9.3 (user: drh, tags: release, branch-3.9, version-3.9.3)
21:19 [7635c68018] Leaf: Fix some code and test coverage issues in fts5_index.c. (user: dan, tags: fts5)
09:42 [249cd361b8] Leaf: Update this branch with latest trunk changes. (user: dan, tags: schemalint)
19:55 [c448873006] Leaf: Simplify the computation of Index.aAvgEq. (user: drh, tags: analyze-worst-case)
16:17 [f047920ce1] Leaf: Version 3.11.1 (user: drh, tags: release, branch-3.11, version-3.11.1)
19:03 [3e5d38f5b3] Leaf: More compact implementation of PRAGMA onconflict, and some test cases. (user: drh, tags: pragma-onconflict)
13:35 [f92dc4187f] Leaf: LSM1: Fix the integer key encoding so that negative keys are in numeric order. (user: drh, tags: lsm-vtab)
02:34 [1c8d300189] Leaf: Add and use the sqlite3VdbeZeroRegister() interface for coding the common operation of writing zero into a register. (user: drh, tags: zero-register)
00:59 [7453790c3b] Leaf: Add the SQLITE_DBCONFIG_REQUIRE_WRITE_TXN connection setting, which if enabled requires all write operations to be enclosed within BEGIN ... COMMIT. (user: drh, tags: require-write-txn)
20:08 [b4ac61aeee] Leaf: Further minor performance improvements and code-size reductions related to fts5 column filters on detail=col tables. (user: dan, tags: fts5-perf)
15:23 [12ef3a8f3d] Leaf: Change the automatic index mechanism so that it avoids creating transient indexes on columns that are known to have low cardinality. (user: drh, tags: autoindex-planning)
15:27 [17efb4209f] Leaf: Version 3.10.2 (user: drh, tags: release, branch-3.10, version-3.10.2)
20:50 [1541607d45] Leaf: Use the OvflOffset() macro to try to remove some magic numbers from btree.c. (user: drh, tags: ovfloffset-macro)
19:17 [896a06cc18] Leaf: Make the VdbeCursor object even smaller. But the resulting library is bigger and slower than trunk. This branch is a failed experiment. (user: drh, tags: optimize-vdbecursor)
19:23 [f59a33260c] Leaf: Update some stale comments in delete.c. No changes to code. (user: dan, tags: onepass-delete-or)
17:53 [093e0d10a8] Leaf: 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. (user: drh, tags: btree-column-opcode)
01:00 [c6239bf943] Leaf: Change the code generator for UPDATE to generate code in an order that might run more efficiently in many cases. (user: drh, tags: improved-update)
03:34 [08e8f04d12] Leaf: 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. (user: drh, tags: reorder-column-opcodes)
21:13 [4049368008] Leaf: Merge updates from trunk. (user: mistachkin, tags: mutexInitIsInitReCheck)
21:12 [a447cf90dd] Leaf: Merge updates from trunk. (user: mistachkin, tags: mutexInitSimpleCmpSwap)
20:17 [39ae92f5c6] Leaf: Experiments with an OP_Unpack opcode that extracts multiple columns from a record without caching. (user: drh, tags: unpack-opcode)
23:45 [70ec88b299] Leaf: Avoid unnecessary cursors and seeking when running a DELETE against a WITHOUT ROWID table. (user: drh, tags: delete-without-rowid-opt)
20:18 [64f2cb8dd2] Leaf: Fix a faulty assert() on the benign-malloc controller callback in test_malloc.c. (user: drh, tags: malloc-testing)
21:43 [12640cb222] Leaf: Convert the hint expression of the CursorHint opcode into a string for display by EXPLAIN. (user: drh, tags: cursor-hints-displayP4)
13:41 [b09e3ea7b8] Leaf: Add some extra timestamps to the experimental log output. (user: dan, tags: experimentalIoLog)
09:42 [3a82c8e6cb] Leaf: 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. (user: dan, tags: mmap-wal-bigtrans)
18:13 [522502ec18] Leaf: 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. (user: drh, tags: btree-opt)
19:05 [68c168b5e5] Leaf: Added test cases based on Bruce Momjian's talk on SQL NULLs. (user: drh, tags: is-distinct-from)
17:58 [1df8cbbea6] Leaf: Merge trunk fixes. (user: drh, tags: view-optimization)
16:09 [80889306bf] Leaf: Add the built-in affinity() SQL function. This turns out to be not as useful as originally envisioned, so abandon it on a branch. (user: drh, tags: affinity-func)
17:24 [b3bb660af9] Leaf: Prevent a virtual table from being destroyed while it is in use. Also: replace Vdbe.inVtabMethod with sqlite3.nVDestroy. Simplify the EXPLAIN output for P4.pVtab to only show the sqlite3_vtab pointer. Cherrypick of [cbeb9a1aed8c]. (user: dan, tags: branch-3.8.6)
02:24 [000197cc4e] Leaf: Silently ignore any attempt to add a prefix index for prefixes zero bytes in size to an fts3/4 table. Or any prefix index size so large that it overflows a 32-bit signed integer. Cherrypick [ad4b19d2ac0889a] (user: drh, tags: branch-3.7.11)
18:17 [2ef4f3a5b1] Leaf: Version (user: drh, tags: release, branch-3.8.10, version-
04:52 [10ee36d012] Leaf: Merge updates from trunk. (user: mistachkin, tags: get-trace)
18:25 [f8b159794c] Leaf: Add the SQLITE_LIMIT_PRINTF_WIDTH setting for sqlite3_limit() and associated logic for preventing DOS attacks using printf() with oversized widths or precisions. (user: drh, tags: limit-printf-width)
14:41 [658e20f554] Leaf: Prototype for an sqlite3_db_log() interface. (user: drh, tags: sqlite3_db_log)
19:13 [a200e1eae9] Leaf: Add the BtCursor.pPage field which is the current page to which the cursor points, for a very small performance gain. (user: drh, tags: btree-current-page-cache)
08:28 [08c0b19b89] Leaf: Update this branch with the latest changes from sorter-opt. (user: dan, tags: insert-select-opt)
22:05 [e5f5ef008d] Leaf: 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]. (user: drh, tags: apple-osx-385)
19:56 [763d2bc74b] Leaf: 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. (user: dan, tags: mistake)
00:09 [cbb93d1aa1] Leaf: Backport the 'stdcall' related enhancements from trunk. (user: mistachkin, tags: stdcall-3.8.8)
14:27 [b1a9e2916f] Leaf: In the command-line shell, change the units on the ".width" directive from bytes to characters. (user: drh, tags: cli-char-width)
13:29 [9d6c1880fb] Leaf: Version (user: drh, tags: release, branch-3.8.8, version-
22:19 [6dca23e64e] Leaf: Add an experimental pragma "PRAGMA preload;" that preloads the pcache with the entire database file. (user: drh, tags: preload-pragma)
01:34 [f66f7a17b7] Leaf: Version (user: drh, tags: release, version-, branch-3.8.7)
17:26 [c6a5b67ae1] Leaf: Add debugging code to count the number of iterations of each loop made as part of statement execution. (user: dan, tags: debug-loopcounters)
09:27 [b21746ac11] Leaf: 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. (user: dan, tags: branch-3.7.14)
18:47 [5e5d6e8680] Leaf: 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 (user: drh, tags: faster-OP_Column)
13:32 [169fc47e16] Leaf: Remove support for Win9x. (user: drh, tags: drop-win9x-support)
17:47 [bc14e64bdf] Leaf: Try to reuse sorter statements in fts5. Does not work due to circular references on VTable object. (user: dan, tags: save_sorter_stmt)
15:13 [2d9de154f8] Leaf: 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. (user: drh, tags: branch-3.8.3)
20:18 [401a0ca3dd] Leaf: Proposed change to the fix for ticket [1c69be2dafc28b] such that legacy applications that were exploiting the older buggy behavior in SQLite continue to work. (user: drh, tags: group-by-name-resolution)
09:56 [7d445e593a] Leaf: 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. (user: dan, tags: mistake)
19:26 [aa7e2041a3] Leaf: Fix harmless compiler warnings in MSVC. (user: drh, tags: safer-malloc)
17:17 [8d8609d6c6] Leaf: Merge recent trunk changes into the orderby-planning branch. (user: drh, tags: orderby-planning)
15:28 [8ad0a123a2] Leaf: 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. (user: drh, tags: smaller-expr)
22:49 [f1a4bf01a2] Leaf: Add the "omit_check_constraints" pragma that causes the check constraint expressions to be omitted from the parse tree. (user: drh, tags: reduce-schema-size)
16:53 [a611fa96c4] Leaf: Version (user: drh, tags: release, version-, branch-3.8.4)
19:05 [3ad687b7aa] Leaf: 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. (user: drh, tags: open-only-once)
15:05 [f352ef57e3] Leaf: Various fixes and test case updates so that veryquick.test passes again. (user: dan, tags: deferred-open)
14:59 [881164cf6e] Leaf: Change more OP_OpenEphemeral operations to OP_OpenHash. (user: drh, tags: subquery-codegen-refactor)
00:49 [a2c347faf9] Leaf: 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. (user: drh, tags: branch-3.8.2)
15:35 [d1fbc6ca18] Leaf: An experimental virtual tables for showing the content of internal schema objects. (user: drh, tags: schema2-vtab)
12:30 [5530cdc485] Leaf: 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). (user: dan, tags: shell-wall-clock)
16:53 [8e78557a40] Leaf: Try to remember statistics from ANALYZE using LogEst instead of u64. (user: drh, tags: log-stats)
19:08 [e8ac4a1227] Leaf: VSIX tooling changes to support Visual Studio 2013. (user: mistachkin, tags: branch-3.8.0)
23:40 [d8daaba7da] Leaf: Add the experimental SQLITE_DEFAULT_INDEX_SHAPE=1 compile-time option that makes a much more pessimistic guess at the effectiveness of unanalyzed indices. (user: drh, tags: index-shape-1)
11:52 [cbea02d938] Leaf: Version (user: drh, tags: release, branch-3.7.16, version-
03:22 [bf6ca21b36] Leaf: Backport the multi-process tester to the last released version. (user: mistachkin, tags: branch-3.7.16)
14:20 [80c63443c4] Leaf: Minor changes to unixMapfile() function. (user: dan, tags: two-mappings)
19:26 [46f7c9301e] Leaf: Add a single test case to fts4unicode.test to verify that title-case maps to lower case. (user: drh, tags: branch-3.7.15)
20:27 [34aafb7436] Leaf: Cherrypick [79ef8e3c77] (Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements). (user: dan, tags: branch-3.7.9)
23:47 [ae2f1627b1] Leaf: Further work on getting ssdsim to run. This is an incremental checkin to save my place while jumping off to work on other things. (user: drh, tags: ssdsim)
21:08 [8b4c3c5e50] Leaf: An optimization that converts "a IN (b)" into "a==b". Seems to work, but needs additional test cases. (user: drh, tags: degenerate_IN)
22:45 [17644c0e33] Leaf: Merge the release including the fix for the LEFT JOIN problem into the sessions branch. (user: drh, tags: sessions-3.7.14)
00:49 [865dfcbaa5] Leaf: 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. (user: drh, tags: branch-3.7.2)
15:16 [acdc7d1270] Leaf: Do not let the multi-core sorter use lookaside memory, which is not thread-safe. (user: drh, tags: threads-sort-ex1)
15:57 [2bb8c49261] Leaf: Experimental change to speed up ORDER BY clauses that sort based on a single expression. (user: dan, tags: sorter-exp)
01:37 [28aed847c6] Leaf: 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]. (user: drh, tags: apple-osx-ml)
13:22 [7b6de5c35d] Leaf: Minor tweaks to the hebrew transliteration tables. (user: drh, tags: translit-tokenizer)
13:51 [627eff32a2] Leaf: Fix the multiplexor logging so that it works with SQLITE_ENABLE_8_3_NAMES. (user: drh, tags: nx-devkit)
11:07 [e6a04bf9f1] Leaf: Fix a problem with [f9c4a7c8f4] as applied to this branch. (user: dan, tags: branch-3.7.6)
00:09 [b431a63437] Leaf: Patches to the apple-osx-377 branch so that it will compile and run on non-Mac unix platforms. (user: drh, tags: apple-osx-377)
17:39 [af0d91adf4] Leaf: Version (user: dan, tags: release, branch-3.7.7, version-
15:34 [2f5b37122b] Leaf: Backport the localtime() failure patch from trunk. Ticket [bd484a090c8077]. (user: drh, tags: branch-3.6.1)
11:26 [2e5a912ad7] Leaf: 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. (user: drh, tags: branch-3.7.5)
02:34 [5791232778] Leaf: Bring the apple-wal-readonly branch up to date with the latest changes in apple-osx, and especially the fix for disappearing WAL transactions. (user: drh, tags: apple-wal-readonly)
14:33 [8609a15dfa] Leaf: Automatically retry system calls that fail with EINTR. This is a backport of the changes from [b9d29ea385bafc] and [af9ba2a6d2c379]. (user: drh, tags: branch-3.7.4)
14:19 [1725aa7501] Leaf: Changes which attempt to address an obscure SQLITE_PROTOCOL error. (user: drh, tags: wal-trace-375)
13:07 [6549e7672b] Leaf: 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. (user: drh, tags: wal-trace-372)
01:01 [29a681dd7b] Leaf: Backport the very lastest R-Tree in order to take advantage of its enhanced robustness to corrupt databases. (user: drh, tags: apple-osx-3623)
01:00 [265b0b29b8] Leaf: Fix the amalgamation builder so that it works with the rtree updates of the prior check-in. (user: drh, tags: branch-3.6.23)
12:31 [042a1abb03] Leaf: Version (user: drh, tags: release, branch-3.7.0)
23:55 [82dd61fccf] Leaf: Sync the database file after a rollback. This is a cherrypick merge of check-in [b21b911f23]. (user: drh, tags: branch-3.6.22)
23:08 [bb18f57852] Leaf: The iInUseDB and iInUseMM variables do not need to be volatile. (user: drh, tags: branch-3.5.9)
23:28 [867347323b] Leaf: Fix for the "(x AND y) OR z" bug backported to version 3.6.21. (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. (user: drh)
13:26 [2a832b19b6] Leaf: Version (user: drh, tags: release, branch_3_6_16)
19:43 [715cecb8c7] Leaf: Fix a VDBE stack overflow issue with the UPDATE statement. (user: drh, tags: branch-3.3.6)
15:00 [ab76d1a252] Leaf: Version (CVS 6680) (user: drh, tags: branch_3_6_14, release)
18:01 [30a2080777] Leaf: Version (CVS 5960) (user: drh, tags: branch_3_6_6)
13:20 [f0029da32f] Leaf: 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) (user: drh, tags: branch_3_3_17)
21:31 [e91012b603] Leaf: Backport the stack-size reduction patch in (3673) to version 3.3.13. (CVS 3979) (user: drh, tags: branch_3_3_13)
16:20 [47fee16ba9] Leaf: Fix a date round-off problem in strftime(). Ticket #2153. (CVS 3575) (user: drh, tags: version_2)
17:27 [e61382aed4] Leaf: Version 3.2.8 (CVS 2835) (user: drh, tags: branch_3_2)