This Day In History For 2020-08-11

2 Years Ago (more context)

2018-08-11
20:46		Add the "atrc" test program. "Atrc" is short for "ALTER TABLE RENAME COLUMN". See the header comment on the program itself for further information. (check-in: ed64a55a user: drh tags: alter-table-rename-column)
20:38		If the new column name in an ALTER TABLE RENAME COLUMN statement is quoted, then also use quotes for the column name in the edited SQL statements. (check-in: ca5184a2 user: dan tags: alter-table-rename-column)
18:34		Avoid an assert() sometimes triggered by ALTER TABLE RENAME COLUMN in non-debug builds. (check-in: 520c1c75 user: dan tags: alter-table-rename-column)
17:49		Fix a bug causing ALTER TABLE RENAME COLUMN to fail when renaming an IPK column that is used in a CHECK constraint. (check-in: 6595c881 user: dan tags: alter-table-rename-column)
17:34		Fix a bug causing all ALTER TABLE RENAME COLUMN commands to fail if ANALYZE had been run on the database. Also prevent the user from renaming the columns of system tables. (check-in: ca644a28 user: dan tags: alter-table-rename-column)
13:40		Reload the entire schema after renaming a column in order to ensure that the schema for any tables for which parent key definitions were changed are reloaded. (check-in: f4497b01 user: dan tags: alter-table-rename-column)

3 Years Ago (more context)

2017-08-11
21:16		Fix a problem allowing a conflicting transaction to be committed in the case where more than one 32KB shared-memory page has been written to since the transaction was started. (check-in: 38dd9b50 user: dan tags: begin-concurrent)
20:22		Add another PAGERTRACE() macro to show when pages are added to Pager.pAllRead. No impact on production builds. (check-in: 11054cf5 user: drh tags: begin-concurrent)
19:31		Add a PAGERTRACE() macro to log when frames are written into the WAL file. This is for analysis only and is a no-op for production builds. (check-in: 39f39e3d user: drh tags: begin-concurrent)
19:16		Merge the latest enhancements from trunk. (check-in: 47e71695 user: drh tags: begin-concurrent)
18:59		Fix compiler warnings that arise if the PAGERTRACE macro is turned on. This changes does not affect production builds. (check-in: 831156a4 user: drh tags: trunk)
18:55		Improved comments in the header of the LSM1 vtab module. No code changes. (check-in: aa49926d user: drh tags: trunk)
18:42		• New ticket [88af8923] . (artifact: 180b8717 user: anonymous)
13:51		New test cases for LSM1. (check-in: cb0c49cb user: drh tags: trunk)
12:49		Convert the LSM1 virtual table to be WITHOUT ROWID and get UPDATE and DELETE operations working on it. (check-in: 2164031b user: drh tags: trunk)
03:47		Simplification to the like optimization logic. Remove unnecessary branches. (check-in: 9466d952 user: drh tags: trunk)

4 Years Ago (more context)

2016-08-11
19:12		Merge version 3.14 plus some subsequent patches (including the page-cache performance patch) from trunk. (check-in: d9f8918c user: drh tags: begin-concurrent)
18:53		Version 3.14.1 (check-in: a12d8059 user: drh tags: release, branch-3.14, version-3.14.1)
18:05		Add the "modeof=<filename>" URI parameter to os_unix.c - used to specify a file to copy permissions from when a new database is created. Also allow passing NULL as the second parameter to sqlite3rbu_vacuum(). (check-in: ed406d31 user: dan tags: trunk)
13:51		Fix a 1 byte buffer overwrite in the "sqldiff --rbu" command. (check-in: 1adb22f5 user: drh tags: branch-3.14)
13:08		Increase the version number to 3.14.1. (check-in: 34aed3a3 user: drh tags: branch-3.14)
13:03		Enhance sqlite3PcacheTruncate() to run faster in the common case where the cutoff is just a few pages less than the page number highwater mark. (check-in: 03dceaea user: drh tags: branch-3.14)
12:31		Merge recent changes from trunk. (check-in: 959677b9 user: drh tags: rowvalue)
12:01		Fix some problems with handling "no such collation sequence" errors. (check-in: 8278be06 user: dan tags: rowvalue)
09:55		Fix a 1 byte buffer overwrite in the "sqldiff --rbu" command. (check-in: ab83d707 user: dan tags: trunk)
01:24		Fix a harmless compiler warning in FTS5. (check-in: 2ea0c8b4 user: drh tags: trunk)

5 Years Ago (more context)

2015-08-11
18:18		Fix the retry mechanism on file locks. (check-in: 600df309 user: drh tags: apple-osx)
14:25		Merge fixes from the fts5NoWarn branch. (check-in: 61cb2fc6 user: dan tags: trunk)
13:41		Add some extra timestamps to the experimental log output. (Leaf check-in: b09e3ea7 user: dan tags: experimentalIoLog)
10:59		Add a tcl interface for the experimental logging functionality. (check-in: e844304d user: dan tags: experimentalIoLog)
01:45		Two more places where logging of freelist trunk pages is needed. (check-in: 56ff336e user: drh tags: experimentalIoLog)

10 Years Ago (more context)

2010-08-11
18:56		Improve coverage of pager.c. (check-in: 2fa05d01 user: dan tags: trunk)
12:26		Update an r-tree extension test case to account for recent changes to the query planner. Also fix a comment in rtree.c. (check-in: eaaca669 user: dan tags: trunk)
11:59		Use sqlite3DbFree() instead of sqlite3_free() to free any error message reported by the parser layer while attempting to parse a CREATE TABLE statement passed to sqlite3_declare_vtab(). (check-in: 7c674aab user: dan tags: trunk)
11:35		Fixes to tcl test files so that they work in auto-vacuum mode. (check-in: ea9eaf74 user: dan tags: trunk)
06:14		Fix memory allocation in proxy locking so that it works with SQLITE_MEMDEBUG. (check-in: f854cbe0 user: drh tags: trunk)
06:04		Merge experimental changes into trunk. (check-in: aa092ac9 user: dan tags: trunk)

15 Years Ago (more context)

2005-08-11
02:10		Improve the error message associated with SQLITE_FULL. Ticket #1353. Also remove error messages for obsolete error codes SQLITE_INTERNAL, SQLITE_NOTFOUND, and SQLITE_TOOBIG. (CVS 2580) (check-in: fa7403c7 user: drh tags: trunk)
01:25		Add 2005 open source award badge and news announcement. (CVS 2579) (check-in: 8e007f8c user: drh tags: trunk)