This Day In History For 2020-10-05

1 Year Ago (more context)

2019-10-05
23:29		• New ticket [8fe768e9c9] FTS integrity-check malfunctions. (artifact: ee64201279 user: mrigger)
21:09		• New ticket [b2d4edaffd] Comparison on view malfunctions. (artifact: 8a9e27d71a user: mrigger)
19:53		Omit the check for conflicting shared-cache locks in sqlite3Prepare() if the database connection uses no shared cache. We might be able to go back and remove this code completely, due to the newer Schema.iGeneration logic, but that will take more analysis. This check-in gives the speed benefit but not the reduction in code size. (check-in: 0b73a09270 user: drh tags: trunk)
19:37		Fix a problem in Makefile.msc on this branch. (check-in: ed3499a1a5 user: dan tags: osinst)
19:24		Optimization to sqlite3VtabUnlockList() for the common case when there is no work to do. (check-in: fc8d45086d user: drh tags: trunk)
19:17		Add a timestamp to each osinst log entry, to facilitate merging multiple log files. (check-in: c9519c0cec user: dan tags: osinst)
18:33		Call sqlite3Prepare() directly, rather than going through sqlite3_prepare(), when processing the sqlite_master.sql column for a schema. (check-in: cc49380ea7 user: drh tags: trunk)
17:29		Have sqlite3.c automatically turn on osinst logging for all connections. (check-in: eea231f81b user: dan tags: osinst)
15:28		Reorder two comparisons for a small performance gain in OP_Transaction. (check-in: d7667f6560 user: drh tags: trunk)
14:39		Performance optimization to the lookaside-memory disabling mechanism. (check-in: 17ce1c49cb user: drh tags: trunk)

2 Years Ago (more context)

2018-10-05
20:09		When the left-hand side of a WHERE clause contraint is a UNIQUE column, and that term of the WHERE clause is not used for indexing, assume that the term reduces the number of output rows by half. This is one proposed fix for ticket [e8b674241947eb3ba4] (Leaf check-in: 5c243eec7b user: drh tags: unique-constraint-weights)
15:10		Changes to geopoly to silience false-positive warnings coming out of clang. (check-in: 11d9015f31 user: drh tags: trunk)

3 Years Ago (more context)

2017-10-05
20:57		Fix compiler warnings that come up with SQLITE_OMIT_WAL. (check-in: 8ca0fa8dfe user: drh tags: trunk)
20:02		Fix a problem building with SQLITE_OMIT_WAL defined. (check-in: 373b0ace48 user: dan tags: trunk)
19:12		Fix the command-line shell so that the ".schema --indent" command does a better job of dealing with \r\n in the middle of a CREATE statement in the schema. (check-in: 4258fb578a user: drh tags: trunk)
18:14		Fix test case failures on this branch. (check-in: 16decc13af user: dan tags: wal2)
11:29		Disable the delta checksum verification in RBU by default. Reenable it using -DRBU_ENABLE_DELTA_CKSUM, if desired. (check-in: d22c99b6ba user: drh tags: trunk)

4 Years Ago (more context)

2016-10-05
20:14		Fix some compiler warnings in fts5. (check-in: b066637bb7 user: dan tags: trunk)
20:10		Fix harmless compiler warnings. (check-in: 2dde337512 user: drh tags: trunk)
15:04		Add a test case for the fix in [a596b7c6cc]. (check-in: b2ef39b11f user: dan tags: trunk)
15:02		Do not set MEM_Blob unless the appropriate fields of the Mem object have been correctly initialized. (check-in: a596b7c6cc user: drh tags: trunk)
01:33		Fix the backup_malloc.test script so that it works on Windows. (check-in: d080012daa user: drh tags: trunk)

5 Years Ago (more context)

2015-10-05
19:41		Improve performance of prefix queries without a prefix index on fts5 tables. (check-in: f2f0184e9e user: dan tags: trunk)
15:39		Update fts3 so that expressions to the left and right of a NOT operator are balanced. This prevents relatively small expressions (a dozen terms or so) that are children of NOT operators from triggering the "expression tree is too large" error. (check-in: d6b66cd7b8 user: dan tags: trunk)
11:57		Add fts5txt2db.tcl, a tool for creating sample fts4/5 databases from text files. (check-in: 44f1ce30d1 user: dan tags: trunk)

10 Years Ago (more context)

2010-10-05
18:22		Do not embedded #if inside an assert() statement. Fix for check-in [dca8763872a] (check-in: d7d4a94fc1 user: drh tags: trunk)
17:02		Have the pager change to at least WRITER_CACHEMOD state before marking any pages as dirty (instead of immediately after). Otherwise, if an error occurs, the pager may be left in WRITER_LOCKED state with dirty pages in the cache. (check-in: 471a4efbb7 user: dan tags: trunk)
15:41		If walLockExclusive() fails for reasons other than SQLITE_BUSY inside of walRestartLog() then propagate that error back up to the application. (check-in: 04dcba6b33 user: drh tags: trunk)
12:05		Avoid all memory allocation (and hence the possiblitity of OOM failure) in sqlite3_value_double() and sqlite3_column_double(). (check-in: 4afdf9705a user: drh tags: trunk)
11:33		Fix an assert() failing on OSX. (check-in: dca8763872 user: dan tags: trunk)
08:13		Prevent backcompat.test from mistaking directories for binary executables. (check-in: 717a1e50f0 user: dan tags: trunk)

15 Years Ago (more context)

2005-10-05
22:31		Make the SQLite logo on the website a hyperlink to the home page. Ticket #1471. (CVS 2745) (check-in: 9709f0f6bc user: drh tags: trunk)
11:41		Make sure pragma integrity_check does not report "ok" after first finding a bunch of errors. (CVS 2744) (check-in: efec04dedf user: drh tags: trunk)
11:35		Fix an assert or memory leak that occurs when trying to EXPLAIN a statement other than a SELECT that outputs results. Examples of such statements include PRAGMA integrity_check or INSERT/DELETE/UPDATE with PRAGMA count_changes=ON. (CVS 2743) (check-in: 533a85eee2 user: drh tags: trunk)
10:40		Changes to support TEA on cygwin. (CVS 2742) (check-in: e80fecc986 user: drh tags: trunk)
10:29		Another attempt to get fdatasync to be ignored on non-conforming posix systems. Now a system has to opt-in for fdatasync instead of opt-out. Ticket #1467. (CVS 2741) (check-in: 115340d4e8 user: drh tags: trunk)
02:13		Add the SQLITE_OMIT_GET_TABLE compile-time flag. (CVS 2740) (check-in: 6d4bc8f83b user: drh tags: trunk)