This Day In History For 2020-08-04
1 Year Ago (more context)
|
2019-08-04
| ||
| 09:26 | • Edit [1bd4b97d6405c9b0|1bd4b97d64]: Edit check-in comment. (artifact: aba6b05a6c 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: cdff3af7be 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: a500893b6f user: drh tags: omit-column-cache) | |
| 17:15 | Fix comments that were made obsolete by the removal of the column cache. (check-in: 2041231d56 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: 80236e81ce user: drh tags: omit-column-cache) | |
| 15:53 | Further logic simplifications that flow out of the omission of the column cache. (check-in: 7d9072b027 user: drh tags: omit-column-cache) | |
| 15:28 | Add test cases for the constant expression fix of the previous check-in. (check-in: 95db5bd9fe 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: 8bc7f84c39 user: drh tags: trunk) | |
| 14:30 | Remove additional traces of the column cache. (check-in: db6052e972 user: drh tags: omit-column-cache) | |
| 02:23 | • Edit [3f5f60cd75293302|3f5f60cd75]: Edit check-in comment. (artifact: 6295c0af40 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: 0f6f6f03de user: drh tags: trunk) | |
| 20:15 | Add the optional non-found-callback to the swarm-vtab. (Closed-Leaf check-in: a94e2f600b user: drh tags: union-vtab) | |
| 17:39 | Add further test cases for swarmvtab. And minor code changes. (check-in: 0f82d3b9dd user: dan tags: union-vtab) | |
| 16:16 | Add test cases and associated fixes for swarmvtab. (check-in: 7ae20eac83 user: dan tags: union-vtab) | |
| 08:24 | Add SQLITE_API qualifiers to public API functions in header file sqlite3rbu.h. (check-in: e11e6eb1d9 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: 61ab112f32 user: dan tags: sqlite3rbu.h-fix) | |
| 08:22 | • Edit [d8637badf63b90b6|d8637badf6]: Move to branch sqlite3rbu.h-fix. Remove the "Closed" mark. (artifact: 8763ef27d4 user: dan) | |
4 Years Ago (more context)
|
2016-08-04
| ||
| 14:08 | Add extra logging calls to this branch. (check-in: 491f1ef36e user: dan tags: debug) | |
| 13:42 | • Edit [4ada023ca075628f|4ada023ca0]: Mark "Closed". Edit check-in comment. (artifact: 12312c693f user: drh) | |
| 13:39 | Merge all recent enhancements from trunk. (check-in: dacfff5140 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: 9adda38526 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: b7f30a9ff2 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: e22ca3cdd0 user: drh tags: apple-osx) | |
| 09:13 | Merge the ORDER BY LIMIT fix, and other enhancements, from trunk. (check-in: bf5a9542d0 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: 13e3bd3de6 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: 4ada023ca0 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: 4f9520a9dc user: dan tags: trunk) | |
| 19:06 | Improve the usage comment on sqlite3_analyzer: show the available switches. (check-in: 783f78e397 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: e3c6d4b6e7 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: 9699e9bd9a 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: cd99777001 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: e7a714b52c user: drh tags: trunk) | |
| 19:14 | Fix some problems with error recovery introduced while reworking pager state. (check-in: 77eaab6f77 user: dan tags: experimental) | |
| 18:43 | • New ticket [13f033c865] Performance regression. (artifact: 07edd854b5 user: drh) | |
| 17:03 | • Edit [042a1abb030a0711|042a1abb03]: Change background color to "#ffc0d0". Edit check-in comment. Timestamp 2010-08-04 12:31:11. Add tag "release". (artifact: dec81aab72 user: drh) | |
| 12:31 | Version 3.7.0.1 (Leaf check-in: 042a1abb03 user: drh tags: release, branch-3.7.0) | |
| 12:19 | Update the version number to 3.7.0.1. (check-in: 5074b85967 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: 3f367fe00e user: drh tags: branch-3.7.0) | |
| 11:59 | Backport the [65b8636ac6e5] fix for ticket [51ae9cad317a1] to version 3.7.0. (check-in: dec70c63d0 user: drh tags: branch-3.7.0) | |
| 11:40 | • Ticket [51ae9cad31] Database corruption by alternating writes from 3.7.0 and 3.6.23 status still Fixed with 1 other change (artifact: 19099f9f29 user: dan) | |
| 11:39 | • Fixed ticket [51ae9cad31]. (artifact: 26a33213e5 user: dan) | |
| 11:39 | • Ticket [51ae9cad31]: 3 changes (artifact: 93da284aea 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: 65b8636ac6 user: dan tags: trunk) | |
| 11:30 | • New ticket [51ae9cad31] Database corruption by alternating writes from 3.7.0 and 3.6.23. (artifact: 254d411d0d user: drh) | |
20 Years Ago (more context)
|
2000-08-04
| ||
| 14:56 | :-) (CVS 128) (check-in: d53cccda4f user: drh tags: trunk) | |
| 13:52 | :-) (CVS 127) (check-in: 695fd68eb6 user: drh tags: trunk) | |
| 13:51 | :-) (CVS 126) (check-in: e31be58248 user: drh tags: trunk) | |
| 13:49 | :-) (CVS 1702) (check-in: 14785d94fb user: drh tags: trunk) | |
| 13:49 | :-) (CVS 125) (check-in: ab9c533a3a user: drh tags: trunk) | |