This Day In History For 2020-02-04

1 Year Ago (more context)

2019-02-04
21:10		Early detection of implausibly sized records to avoid unnecessary large memory allocations. (check-in: 2c8769c69f user: drh tags: trunk)
21:02		Fix a problem with reloading the schema on this branch. (check-in: 5dfbef8349 user: dan tags: reuse-schema)
19:52		Mention the new -memtrace command-line option in the -help output of the CLI. (check-in: ada91aefe3 user: drh tags: trunk)
19:50		Add the -memtrace option to dbfuzz2. (check-in: 67fecbc79d user: drh tags: trunk)
19:45		Enhance dbfuzz2 so that with the -v option it shows the return code and error message for any failing SQL statements. (check-in: 3a127ef9f7 user: drh tags: trunk)
19:12		Ensure that the sqlite3_exec() callback gets the correct number of columns for a query, even if the schema changes out from under it. (check-in: a16ffb5a4b user: drh tags: trunk)
16:42		Do not run shmlock.test as part of the inmemory_journal permutation. (check-in: d3fea69cbb user: dan tags: trunk)
16:36		Update the test/fuzzdata8.db database with new interesting cases from dbsqlfuzz. (check-in: e467e4c8fa user: drh tags: trunk)
16:25		Fix problems with SAVEPOINT and related commands within transactions on a corrupt database that include fts5 or some other virtual tables. (check-in: b0da6e0dd1 user: dan tags: trunk)
14:53		Add the ".progress" command to the CLI. (check-in: ad84ca24ff user: drh tags: trunk)
14:00		Fix another potential buffer overread in fts5. (check-in: 14fba4cc5d user: dan tags: trunk)
11:54		Fix another corruption case in fts5. (check-in: e608085d3f user: dan tags: trunk)

2 Years Ago (more context)

2018-02-04
20:33		In the CLI, make sure sqlite3_initialize() is called correctly even for non-UTF8 hosts. (check-in: a3591fb541 user: drh tags: trunk)
01:30		Fix harmless compiler warning seen with MSVC. (check-in: 63a914410b user: mistachkin tags: trunk)
01:29		Move variable declaration in zipfile extension to fix MSVC compiler error. (check-in: ac6a32482e user: mistachkin tags: trunk)

3 Years Ago (more context)

2017-02-04
20:15		Simplification to the error handling to extension loading in sqlite3_open(). (check-in: ec8ff892ac user: drh tags: trunk)
17:33		Allow sqlite3session_apply() to apply changesets to tables that have been extended using ALTER TABLE ADD COLUMN. (check-in: b20ff81ff9 user: dan tags: trunk)
15:29		Merge recent trunk enhancements. (check-in: 6c3f09028f user: drh tags: apple-osx)
14:31		• Edit [e9c94a1f402ce51a|e9c94a1f40]: Mark "Closed". (artifact: ebdab3c130 user: drh)
14:30		Merge the latest trunk changes, especially the RTREE enhancement to use sqlite3_blob objects. (Leaf check-in: 61bd2a885d user: drh tags: sqlite3_blob_reset)
14:24		In RTREE, use an sqlite3_blob object rather than an sqlite3_stmt object for reading content out of the %_node shadow table. (check-in: 97ccf3e4de user: drh tags: trunk)
13:12		Close sqlite3_blob objects on xSync rather than waiting until xCommit. (Closed-Leaf check-in: 95ee745fce user: drh tags: rtree-blob-agressive-release)

4 Years Ago (more context)

2016-02-04
19:50		Temporarily back out the 0.5% performance improvement from check-in [632071bac5ff32]. Need a more elaborate solution that works with reentrant virtual tables and SQL functions. (check-in: 42736fb0ad user: drh tags: trunk)
19:45		Further improve performance of unindexed fts5 prefix queries. (check-in: c9c6457d8e user: dan tags: trunk)
17:31		Avoid running some particularly time-consuming tests as part of veryquick.test. (check-in: f465944b75 user: dan tags: trunk)
11:48		Remove unnecessary sets of db->mallocFailed. (check-in: b787165b25 user: drh tags: trunk)
11:15		Use sqlite3_malloc64() instead of sqlite3_malloc() in the spellfix extension. (check-in: 634d008c34 user: drh tags: trunk)
10:28		• Fixed ticket [ad2559db38]: JSON does not properly escape control characters plus 5 other changes (artifact: 0134f388c6 user: drh)
10:28		Escape control characters in JSON. Fix for ticket [ad2559db380abf8]. (check-in: 4f1b5229a3 user: drh tags: trunk)
10:14		• New ticket [ad2559db38] JSON does not properly escape control characters. (artifact: 9f98f0013a user: drh)
09:48		Refinements to synchronous logic: (1) Use PAGER_SYNCHRONOUS_FULL rather than the corresponding magic number. (2) Honor SQLITE_NO_SYNC on xDelete calls with sync (3) Count xDelete syncs during testing (4) Fix #ifs on SQLITE_EXTRA_DURABLE so that directory syncs on journal unlink are off by default. (check-in: e3157cb5ad user: drh tags: trunk)
02:34		Add and use the sqlite3VdbeZeroRegister() interface for coding the common operation of writing zero into a register. (Leaf check-in: 1c8d300189 user: drh tags: zero-register)

5 Years Ago (more context)

2015-02-04
23:51		Merge all changes from index_xinfo, including the move of the pragma table into the separate pragma.h file. (check-in: 21e95d28a5 user: drh tags: ota-update)
23:13		Merge all recent trunk changes, including the movement of the pragma table into the separate pragma.h header file. (Closed-Leaf check-in: 3af19f8444 user: drh tags: index_xinfo)
20:56		Fix a missing mutex in SQLITE_TESTCTRL_IMPOSTER. (check-in: 71691c4be5 user: drh tags: trunk)
19:20		Fix the error messages returned by ota if an update violates a unique constraint. (check-in: c4845a3b59 user: dan tags: ota-update)
16:32		Avoid a linear scan of the entire table when ota updates or deletes a row from a table with an external primary key index. (check-in: 1db198ccca user: dan tags: ota-update)
11:08		Fix a memory leak that could follow an OOM error in ota. (check-in: 0d5415f264 user: dan tags: ota-update)

10 Years Ago (more context)

2010-02-04
17:38		Fix a performance glitch that appears for large transactions. (check-in: 26cb1df735 user: drh tags: trunk)

15 Years Ago (more context)

2005-02-04
21:13		Detect and report a subtle case of database file corruption. (CVS 2313) (check-in: 9fc0a5cbf8 user: drh tags: trunk)
04:07		Remove code for SQL cursors. (CVS 2312) (check-in: 2eb9087055 user: danielk1977 tags: trunk)