This Day In History For 2020-08-04
1 Year Ago (more context)
|
2019-08-04
| ||
| 09:26 | • Edit [1bd4b97d6405c9b0|1bd4b97d]: Edit check-in comment. (artifact: aba6b05a user: drh) | |
2 Years Ago (more context)
|
2018-08-04
| ||
| 20:30 | Remove the column-cache from the code generator. The column-cache has been a persistent source of bugs for years and with recent improvements in the performance of OP_Column, it no longer provides a benefit. After the column cache is removed, the binary is almost 2KB smaller and the speed-check.sh performance test is over 3 million cycles faster. (check-in: cdff3af7 user: drh tags: trunk) | |
| 20:12 | Remove a testcase() that is no longer reachable without the column cache. Provide an assert() to help prove that the testcase is no longer reachable. (Closed-Leaf check-in: a500893b user: drh tags: omit-column-cache) | |
| 17:15 | Fix comments that were made obsolete by the removal of the column cache. (check-in: 2041231d user: drh tags: omit-column-cache) | |
| 16:54 | Remove more column-cache residue: The OP_SetColTab and OP_VerifyColTab opcodes and the associated SQLITE_DEBUG_COLUMNCACHE logic. (check-in: 80236e81 user: drh tags: omit-column-cache) | |
| 15:53 | Further logic simplifications that flow out of the omission of the column cache. (check-in: 7d9072b0 user: drh tags: omit-column-cache) | |
| 15:28 | Add test cases for the constant expression fix of the previous check-in. (check-in: 95db5bd9 user: drh tags: trunk) | |
| 15:16 | Ensure that all expressions that are to be evaluated once at the start of a prepared statement (the Parse.pConstExpr expressions) pass the sqlite3ExprIsConstantNotJoin() test. It is not sufficient to pass just the sqlite3ExprIsConstant() test as that would allow through column references that are bound to constants by the WHERE clause in the constant propagation optimization. This fixes a problem discovered by OSSFuzz. (check-in: 8bc7f84c user: drh tags: trunk) | |
| 14:30 | Remove additional traces of the column cache. (check-in: db6052e9 user: drh tags: omit-column-cache) | |
| 02:23 | • Edit [3f5f60cd75293302|3f5f60cd]: Edit check-in comment. (artifact: 6295c0af user: drh) | |
3 Years Ago (more context)
|
2017-08-04
| ||
| 20:27 | Add the swarm virtual table to the existing union virtual table module. (check-in: 0f6f6f03 user: drh tags: trunk) | |
| 20:15 | Add the optional non-found-callback to the swarm-vtab. (Closed-Leaf check-in: a94e2f60 user: drh tags: union-vtab) | |
| 17:39 | Add further test cases for swarmvtab. And minor code changes. (check-in: 0f82d3b9 user: dan tags: union-vtab) | |
| 16:16 | Add test cases and associated fixes for swarmvtab. (check-in: 7ae20eac user: dan tags: union-vtab) | |
| 08:24 | Add SQLITE_API qualifiers to public API functions in header file sqlite3rbu.h. (check-in: e11e6eb1 user: dan tags: trunk) | |
| 08:23 | Update script tool/mksqlite3c.tcl to avoid duplicating the SQLITE_API qualifier when copying sqlite3rbu.h into the amalgamation. (Closed-Leaf check-in: 61ab112f user: dan tags: sqlite3rbu.h-fix) | |
| 08:22 | • Edit [d8637badf63b90b6|d8637bad]: Move to branch sqlite3rbu.h-fix. Remove the "Closed" mark. (artifact: 8763ef27 user: dan) | |
4 Years Ago (more context)
|
2016-08-04
| ||
| 14:08 | Add extra logging calls to this branch. (check-in: 491f1ef3 user: dan tags: debug) | |
| 13:42 | • Edit [4ada023ca075628f|4ada023c]: Mark "Closed". Edit check-in comment. (artifact: 12312c69 user: drh) | |
| 13:39 | Merge all recent enhancements from trunk. (check-in: dacfff51 user: drh tags: apple-osx) | |
| 13:23 | Revert the SQLITE_APICALL changes for now. That changes needs further research before it is released. Deferred until 3.15. (check-in: 9adda385 user: drh tags: trunk) | |
| 12:35 | Add the experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option. When enabled, the "unknown function" error is suppressed for EXPLAIN and a no-op function named "unknown()" is substituted. This facilitiates using the command-line shell to analyze queries from applications that contain many application-defined functions that are not normally available to the shell. (check-in: b7f30a9f user: drh tags: trunk) | |
| 12:33 | Add the experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option. When enabled, the "unknown function" error is suppressed for EXPLAIN and a no-op function named "unknown()" is substituted. This facilitiates using the command-line shell to analyze queries from applications that contain many application-defined functions that are not normally available to the shell. (check-in: e22ca3cd user: drh tags: apple-osx) | |
| 09:13 | Merge the ORDER BY LIMIT fix, and other enhancements, from trunk. (check-in: bf5a9542 user: drh tags: apple-osx) | |
| 09:09 | Make sure the ORDER BY LIMIT optimization is not applied if the inner-most loop can only have a single iteration and is hence not really a loop. (check-in: 13e3bd3d user: drh tags: trunk) | |
| 01:47 | Add an experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option. This changes has been merged into main branches via cherry-pick. (Closed-Leaf check-in: 4ada023c user: drh tags: unknown-function) | |
5 Years Ago (more context)
|
2015-08-04
| ||
| 20:29 | Add new test file fts5_test_mi.c, containing an implementation of a function similar to FTS4 matchinfo() for FTS5. (check-in: 4f9520a9 user: dan tags: trunk) | |
| 19:06 | Improve the usage comment on sqlite3_analyzer: show the available switches. (check-in: 783f78e3 user: drh tags: trunk) | |
| 15:29 | Update the [showdb] program so that the database file is read directly (bypassing the SQLite VFS) only if the --raw option is specified. Otherwise, it is read using the default VFS. Also, the URI syntax may be used on the command line to specify the name of the database file to examine, so an alternative VFS may be requested using a URI parameter. (check-in: e3c6d4b6 user: dan tags: trunk) | |
| 15:23 | Update the [showdb] program so that the database file is read directly (bypassing the SQLite VFS) only if the --raw option is specified. Otherwise, it is read using the default VFS. An alternative VFS may be specified by specifying the database file to open using the URI syntax. (Closed-Leaf check-in: 9699e9bd user: dan tags: showdb-uri-option) | |
| 14:18 | In the sqlite3_analyzer.exe utility, show the depth of each btree and report the average fanout of indexes and WITHOUT ROWID tables. (check-in: cd997770 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2010-08-04
| ||
| 21:17 | If the outer loop of a join must be a full table scan, make sure that an incomplete ANALYZE does not trick the planner into use a table that might be indexable in an inner loop. Ticket [13f033c865f878] (check-in: e7a714b5 user: drh tags: trunk) | |
| 19:14 | Fix some problems with error recovery introduced while reworking pager state. (check-in: 77eaab6f user: dan tags: experimental) | |
| 18:43 | • New ticket [13f033c8] Performance regression. (artifact: 07edd854 user: drh) | |
| 17:03 | • Edit [042a1abb030a0711|042a1abb]: Change background color to "#ffc0d0". Edit check-in comment. Timestamp 2010-08-04 12:31:11. Add tag "release". (artifact: dec81aab user: drh) | |
| 12:31 | Version 3.7.0.1 (Leaf check-in: 042a1abb user: drh tags: release, branch-3.7.0) | |
| 12:19 | Update the version number to 3.7.0.1. (check-in: 5074b859 user: drh tags: branch-3.7.0) | |
| 12:13 | Backport fix [267492d3a7eff7b] for the performance regression caused by automatic indexing and reported by ticket [8011086c85c6c4040]. (check-in: 3f367fe0 user: drh tags: branch-3.7.0) | |
| 11:59 | Backport the [65b8636ac6e5] fix for ticket [51ae9cad317a1] to version 3.7.0. (check-in: dec70c63 user: drh tags: branch-3.7.0) | |
| 11:40 | • Ticket [51ae9cad] Database corruption by alternating writes from 3.7.0 and 3.6.23 status still Fixed with 1 other change (artifact: 19099f9f user: dan) | |
| 11:39 | • Fixed ticket [51ae9cad]. (artifact: 26a33213 user: dan) | |
| 11:39 | • Ticket [51ae9cad]: 3 changes (artifact: 93da284a user: dan) | |
| 11:34 | When opening a write-transaction on a database file that has been appended to or truncated by a pre-3.7.0 client, update the database-size field in the database header. Fix for [51ae9cad31]. (check-in: 65b8636a user: dan tags: trunk) | |
| 11:30 | • New ticket [51ae9cad] Database corruption by alternating writes from 3.7.0 and 3.6.23. (artifact: 254d411d user: drh) | |
20 Years Ago (more context)
|
2000-08-04
| ||
| 14:56 | :-) (CVS 128) (check-in: d53cccda user: drh tags: trunk) | |
| 13:52 | :-) (CVS 127) (check-in: 695fd68e user: drh tags: trunk) | |
| 13:51 | :-) (CVS 126) (check-in: e31be582 user: drh tags: trunk) | |
| 13:49 | :-) (CVS 1702) (check-in: 14785d94 user: drh tags: trunk) | |
| 13:49 | :-) (CVS 125) (check-in: ab9c533a user: drh tags: trunk) | |