SQLite

Today In History
Login

This Day In History For 2021-01-26

2 Years Ago (more context)

2019-01-26
23:34
Ensure that the btree cursor is correctly set up prior to backing it up as part of a delete operation on a divider cell in an index. (check-in: a3ea1a822d user: drh tags: trunk)
21:05
Fix a broken assert() in fts3. Also some test script issues causing failures with builds that do not support fts3. (check-in: d59567dda2 user: dan tags: trunk)
21:01 Edit [75a8ed7a4227493c|75a8ed7a42]: Move to branch rollback-abort. (artifact: 07f21a04ad user: dan)
20:41
Fix another typo in fts3_common.tcl causing test failures in builds that do not support fts3. (Closed-Leaf check-in: 773b598608 user: dan tags: rollback-abort)
20:35
Fix a typo in fts3corrupt4.test causing it to fail if the build does not support fts3. (check-in: 5016303421 user: dan tags: rollback-abort)
19:09
Fix a broken assert() in fts3. (check-in: b8dd2d67b5 user: dan tags: rollback-abort)
18:10
If a write statement fails with OE_Abort, but there is no statement journal, roll the entire transaction back instead. (check-in: 75a8ed7a42 user: dan tags: rollback-abort)
17:47
Fix "PRAGMA journal_mode" so that if it fails because there is a transaction open, it does not roll that transaction back. (check-in: 9f39cb5b81 user: dan tags: rollback-abort)
16:37 Edit [d536be698d1c6479|d536be698d]: Move to branch rollback-abort. (artifact: 70e67ae14e user: dan)
16:34
Roll back the transaction if a write statement fails with OE_Abort but there is no open statement transaction. (check-in: d536be698d user: dan tags: rollback-abort)
15:40
Add the ".eqp trace" command to the CLI when using SQLITE_DEBUG, as a convenient shorthand for "PRAGMA vdbe_debug=ON" but with automatic indentation feature for program listings provided by the CLI. (check-in: 626502faa1 user: drh tags: trunk)

3 Years Ago (more context)

2018-01-26
23:48 Fixed ticket [80177f0c22]: Incorrect result when join condition uses a table-valued function plus 5 other changes (artifact: ca393f736f user: drh)
22:41
Fix the query planner so that it takes into account dependencies in the arguments to table-valued functions in subexpressions in the WHERE clause. Fix for ticket [80177f0c226ff54f6dd]. (check-in: 7daa687340 user: drh tags: trunk)
22:26 New ticket [80177f0c22] Incorrect result when join condition uses a table-valued function. (artifact: 8e86e0cc81 user: drh)
18:59
If the argument to table function zipfile() is a blob (not text), assume that it contains a zip file image to interpret, not the name of a file on disk. (check-in: 029ebcd30c user: dan tags: trunk)
18:37
Improve text-to-integer conversion in boundary cases. The sqlite3Atoi64() function always returns the minimum or maximum integer if the magnitude of the text value is too large. Trailing whitespace is now ignored. (check-in: ace0644a1a user: drh tags: trunk)

4 Years Ago (more context)

2017-01-26
21:30
Remove an unreachable branch in the error handling logic for sqlite3BtreePayloadChecked(). (check-in: 293bf3ed7e user: drh tags: trunk)
18:00
Improvement to the OP_Permutation opcode to prevent it from using CPU cycles for initialization in prepared statements that do not use that opcode. (check-in: b4a98f6556 user: drh tags: trunk)
17:26
Remove the obsolete lastRowid cache from the sqlite3VdbeExec() for a size reduction and performance improvement. (check-in: b480318465 user: drh tags: trunk)
17:11
Performance optimization in sqlite3VdbeCloseStatement(). (check-in: 1e96e5ec1e user: drh tags: trunk)
16:54
Performance optimization to sqlite3_blob_read(). (check-in: 7459f4b7ed user: drh tags: trunk)
16:27
Minor simplification and performance optimization for Direct Overflow Read. (check-in: 3e96d6efa8 user: drh tags: trunk)
02:26
Make SQLITE_DIRECT_OVERFLOW_READ work for in WAL mode as long as the page being read is not in the the -wal file. (check-in: 9879be1899 user: drh tags: trunk)
01:54
Enhancements to the kvtest utility program. Add the --jmode option. Improved output formatting. (check-in: 62a4851ccf user: drh tags: trunk)
00:58
Modify the ICU extension to use a static initializer, as VC++ complains about a dynamic initialization. Maybe the dynamic structure initialization is a GCC extension. This fixes a problem identified on the SQLite mailing list by Ziemowit Laski. (check-in: 50e60cb44f user: drh tags: trunk)

5 Years Ago (more context)

2016-01-26
23:32
Merge all recent trunk enhancements. (check-in: 9a71d56dce user: drh tags: btree-fordelete-flag)
20:19
Performance improvements for fts5, particularly detail=col mode. (check-in: a3d7b8ac53 user: dan tags: trunk)
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)
19:30
Improve the performance of fts5 column filters on detail=col tables. (check-in: 249a2d070c user: dan tags: fts5-perf)
17:08
Enhance fts5txt2db.tcl, a script used to generate fts5/fts4 databases for performance testing. (check-in: c646e40350 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)
14:48
Fix issues on unix with opening database files via symlinks that are not in the current working directory. And with nested symlinks. (check-in: 4003db4a49 user: dan tags: trunk)
13:56
Ensure that unixFullpathname() always nul-terminates its output buffer, even when returning an error. (Closed-Leaf check-in: 4a4385564d user: dan tags: follow-symlinks)
00:12
Remove an unused variable. (check-in: 1c2656c1d3 user: drh tags: follow-symlinks)

10 Years Ago (more context)

2011-01-26
19:46
Update all built-in VFSes to return SQLITE_OK for the SQLITE_FCNTL_SYNC_OMITTED file-control operation. Also change the xFileControl methods to return SQLITE_NOTFOUND for unrecognized operation codes. (check-in: 6f2c72a0f6 user: drh tags: trunk)
17:05 Edit [7e3fc2c833a5baa0|7e3fc2c833]: Move to branch blocking-checkpoint. (artifact: 67b821dc5a user: drh)
15:23
Update test file mutex1.test to account for [e3b500fb5d]. (check-in: c86e46f4fd user: dan tags: trunk)
13:42 Edit [f4b9003a2d3db88e|f4b9003a2d]: Mark "Closed". (artifact: 435005e4df user: drh)
13:41 Edit [2dc98d29995bef51|2dc98d2999]: Mark "Closed". (artifact: 4025872e2a user: drh)
13:41 Edit [2ea5bd1287227589|2ea5bd1287]: Mark "Closed". Edit check-in comment. (artifact: a6119dea0c user: drh)
13:41 Edit [76a0294ab4208a08|76a0294ab4]: Mark "Closed". (artifact: 4e238fbcbf user: drh)
13:40 Edit [4c3e137803f86ec5|4c3e137803]: Mark "Closed". (artifact: 3c0f304282 user: drh)
13:39 Edit [1a3e7417a2184188|1a3e7417a2]: Mark "Closed". (artifact: 28770137d1 user: drh)
13:39 Edit [149d2ae4a6fe2f86|149d2ae4a6]: Mark "Closed". Edit check-in comment. (artifact: 732bffe6f1 user: drh)
13:38 Edit [ad8df6c5ee0055cf|ad8df6c5ee]: Mark "Closed". (artifact: a90764af5e user: drh)
13:38 Edit [d1b3c54f42b1765e|d1b3c54f42]: Mark "Closed". Edit check-in comment. (artifact: 59d4ccf854 user: drh)
13:37 Edit [88b84bf18a4b2762|88b84bf18a]: Mark "Closed". (artifact: ca2fa3e0e9 user: drh)
13:37 Edit [228e7c34c6411467|228e7c34c6]: Mark "Closed". Edit check-in comment. (artifact: 63301229c4 user: drh)
13:28
More mutexes around another sqlite3StatusAdd() call. (check-in: e3b500fb5d user: drh tags: trunk)
13:24
Add a mutex around an sqlite3StatusAdd() call to prevent the pagecount overflow measurements from getting off in multithreaded applications. (check-in: 3d8b298dc2 user: drh tags: trunk)
07:25
Update mutex1.test so that it works with the memsubsys1 permutation (pagecache memory). Change a few instances of SQLITE_MUTEX_STATIC_LRU2 in comments and test code to STATIC_PMEM. (check-in: 456bd5c63b user: dan tags: trunk)
06:13
Changes to exclusive2.test to make it more deterministic. (check-in: 84b0c2bc71 user: dan tags: trunk)
00:07
Rename the PCache1.mxPinned field to n90pct (since it is 90% of nMax) in order to distinguish it from PGroup.mxPinned. Fix the computation of n90pct so that it does not overflow adversely on excessively large cache sizes. (check-in: c85202baac user: drh tags: trunk)

15 Years Ago (more context)

2006-01-26
14:29
Enhanced comments on the opcode.h building script. (CVS 3033) (check-in: 7ccebf68eb user: drh tags: trunk)
13:25
Fix an error in the collation sequence examples in datatype3.html. Ticket #1641. (CVS 3032) (check-in: 1658ea53c9 user: danielk1977 tags: trunk)
13:11
Add omittest.tcl script to automate testing compile-time OMIT symbols. (CVS 3031) (check-in: 540d28a7d3 user: danielk1977 tags: trunk)
10:35
Handle a malloc() failure in resizeOpArray(). (CVS 3030) (check-in: 5cecb4527b user: danielk1977 tags: trunk)