This Day In History For 2020-09-09

1 Year Ago (more context)

2019-09-09
21:02		• New ticket [18458b1a] COLLATE issue in view. (artifact: 54e5ff4c user: mrigger)
20:18		• Closed ticket [a7debbe0]: BETWEEN issue in view plus 6 other changes (artifact: 2c6a62d6 user: dan)
20:17		Ensure the columns of views and sub-selects in the FROM clause of a select are always assigned implicit collation sequences, just as table columns are. Fix for [a7debbe0]. (check-in: b9ec7220 user: dan tags: trunk)
19:49		Ensure the columns of views and sub-selects in the FROM clause of a select are always assigned implicit collation sequences, just as table columns are. Possible fix for [a7debbe0]. (Closed-Leaf check-in: 1863b7bf user: dan tags: tkt-a7debbe0.)

2 Years Ago (more context)

2018-09-09
10:46		• New ticket [c94369ca] Wrong answer due to the LIKE optimization. (artifact: ffd4cb43 user: drh)

3 Years Ago (more context)

2017-09-09
22:46		Simplification and performance improvement to sqlite3_reset(). (check-in: b6425d01 user: drh tags: improved-integrity-check)
20:38		Improved detection of malformed records by PRAGMA integrity_check. (check-in: 8fa923ca user: drh tags: improved-integrity-check)
19:41		Enhance the vtab interface to handle IS, !=, IS NOT, IS NULL and IS NOT NULL constraints. (check-in: 34c8e952 user: dan tags: vtab-extra-ops)
08:03		Use a mutex-free PRNG for the random() and randomblob() SQL functions and for the randomness used during checkpoint operations. (Leaf check-in: e63d1a7c user: drh tags: mutex-free-randomness)
06:10		Merge trunk enhancements (check-in: 6a0b9d9d user: drh tags: apple-osx)
00:51		Fix harmless compiler warnings seen with MSVC. (check-in: faa22e29 user: mistachkin tags: trunk)

4 Years Ago (more context)

2016-09-09
20:26		Make the new file test_delete.c portable to MSVC on Windows. (Closed-Leaf check-in: 0e3ace39 user: mistachkin tags: test_delete)
20:23		Remove an unnecessary call to sqlite3VdbeMemExpandBlob() when casting to text. (check-in: 19e2e595 user: drh tags: trunk)
20:00		Add new file test_delete.c, containing test code for deleting an sqlite database. (check-in: fb0b95e9 user: dan tags: test_delete)
19:33		Performance improvements to the comparison operators in the bytecode engine. (check-in: 37803b19 user: drh tags: trunk)
15:12		Fix a out-of-order variable declaration for some compile-time configurations. (check-in: 6ac932c9 user: drh tags: trunk)
13:23		In releasetest.tcl, the --srcdir option is automatic, so no need to mention it in the --help output. (check-in: 2bdd838e user: drh tags: trunk)
13:17		Fix an obsolete comment in the releasetest.tcl source code. (check-in: afaaa276 user: drh tags: trunk)
12:29		In releasetest.tcl: Improved testing for uncommitted changes. If uncommitted changes are seen, exit immediately unless the --force option is used. (check-in: 9a14e6c4 user: drh tags: trunk)

5 Years Ago (more context)

2015-09-09
23:54		Fix harmless compiler warning in FTS5. (check-in: 86146a73 user: mistachkin tags: trunk)
19:44		Fix an assert() enabled by SQLITE_ENABLE_EXPENSIVE_ASSERT in wal.c. (check-in: 8d2ed150 user: dan tags: trunk)
19:27		Fix a possible NULL pointer deref when using SQLITE_ENABLE_MEMORY_MANAGEMENT. (check-in: 89bfdbfe user: drh tags: trunk)
17:23		Fix harmless compiler warning. (check-in: 280fd3a4 user: mistachkin tags: trunk)
17:17		Fix harmless compiler warnings in FTS5. (check-in: 2cdb1877 user: mistachkin tags: trunk)
13:28		• Fixed ticket [acd12990]: CREATE TABLE AS fails with a false report of database corruption plus 5 other changes (artifact: b2d6502f user: drh)
13:28		When running a CREATE TABLE AS, make the initial temporary sqlite_master entry for the new table a real record rather than a NULL, in case the query after the AS actually tries to read the sqlite_master table. Fix for ticket [acd12990885d9276]. (check-in: 4a18d8bd user: drh tags: trunk)
12:34		• New ticket [acd12990] CREATE TABLE AS fails with a false report of database corruption. (artifact: 16828871 user: drh)
08:15		Fix a bug in preprocessor macros within fts5_main.c. (check-in: 0eb2b952 user: dan tags: fts5-incompatible)

10 Years Ago (more context)

2010-09-09
23:42		Make sure MEMSTATUS is enabled at the beginning of the memsubsys2.test script. (check-in: c23b9721 user: drh tags: trunk)
23:40		Make sure MEMSTATUS is enabled at the beginning of the memsubsys2.test script. (check-in: cf23a354 user: drh tags: apple-osx)
23:31		The merge for check-in [415c448dc4] did not do exactly write, resulting in a subtle bug in the SQLITE_FCNTL_SIZE_HINT logic. This check-in is the fix. (check-in: badaaa18 user: drh tags: apple-osx)
19:02		Add test cases to e_select.test. (check-in: 5e73f7b2 user: dan tags: trunk)
18:25		Further updates to the sqlite3_pcache_methods documentation, plus the addition of a few evidence marks related to pcache. (check-in: 34edb54b user: drh tags: trunk)
17:43		Make sure memory statistics are enabled for the dbstatus.test script. (check-in: 35b943a0 user: drh tags: trunk)
15:48		Updates to the sqlite3_pcache_methods documentation. (check-in: b21425c4 user: drh tags: trunk)
11:33		Add WHERE clause tests to e_select.test. (check-in: 721b73fa user: dan tags: trunk)
10:00		Add tests for sub-select statements in the FROM clause of a SELECT to e_select.test. (check-in: 2c6b1ca9 user: dan tags: trunk)

15 Years Ago (more context)

2005-09-09
10:46		Enhanced disk-full tests. (CVS 2682) (check-in: 0288fa5d user: drh tags: trunk)
10:17		Detect errors returned by SetFilePointer on windows. (CVS 2681) (check-in: bc8c33f9 user: drh tags: trunk)
01:33		Infrastructure for the DISTINCT keyword in aggregate functions. But it does not work yet. If you try to use it you get an error message. (CVS 2680) (check-in: 4d62e36f user: drh tags: trunk)
01:32		Defend against disk I/O errors that happen during an sqlite3OsSeek(). (CVS 2679) (check-in: 461e3a0a user: drh tags: trunk)