This Day In History For 2022-01-25

1 Year Ago (more context)

2021-01-25
21:24		Add an extra log message in the case of an SQLITE_CORRUPT_INDEX error. (check-in: 0571c24177 user: drh tags: trunk)

3 Years Ago (more context)

2019-01-25
20:09		• Fixed ticket [bb4bdb9f7f]: Zeroblob truncated by an index on an expression plus 6 other changes (artifact: a2fbfd41cb user: drh)
20:09		Do not accidently truncate zeroblob values when doing an arithmetic operation. Fix for ticket [bb4bdb9f7f654b0bb9f34cfba]. (check-in: 13f6942eb0 user: drh tags: trunk)
20:01		• New ticket [bb4bdb9f7f] Zeroblob truncated by an index on an expression. (artifact: f81a07993d user: drh)
19:29		Reinitialize debugging information on registers of a trigger prior to each invocation of the trigger. This prevents false-positives from the sqlite3VdbeMemAboutToChange() test logic. (check-in: 98b3b97573 user: drh tags: trunk)
18:17		Fix harmless compiler warnings. (check-in: 3ff220ad37 user: drh tags: trunk)
18:17		Fix the assert_fts3_nc() macro so that it works for test builds that omit SQLITE_DEBUG. (check-in: b10df2b569 user: drh tags: trunk)
17:51		Fix harmless compiler warnings in fuzzcheck (check-in: a825396657 user: drh tags: trunk)
17:26		Fix a segfault that could follow an OOM when querying a table that has one or more columns with default values "true" or "false". (check-in: 202f9919c2 user: dan tags: trunk)
16:54		Fix asan warnings in fts5 triggered by corrupt databases - passing NULL to memcmp, out-of-range left-shift values and signed integer overflow. (check-in: 93f8ec146d user: dan tags: trunk)
14:48		Add an assert_fts3_nc() macro to fts3 - for assert() conditions that are only true when it is guaranteed that the fts3 database is not corrupt. (check-in: 3498908cd7 user: dan tags: trunk)
14:23		Extend fuzzcheck so that it can process dbsqlfuzz cases. Add a collection of interesting dbsqlfuzz cases to the standard test suite. (check-in: e2991a7ecf user: drh tags: trunk)
14:16		Fix the xFetch method of the "memdb" VFS (used by deserialize) so that it is robust against corrupt database file. (Closed-Leaf check-in: 2c1ef40e78 user: drh tags: dbsqlfuzz-in-fuzzcheck)
13:42		Fix a couple of assert() statments in btree.c that could fail with corrupt databases. (check-in: 5eb5e8289f user: dan tags: trunk)
13:16		• Changes to wiki page "checkin/718ead555b09892f3cbaddb1775ede4acfa4a2986d69f15da1270c433e5dd578" (artifact: b76247d687 user: drh)
13:03		In fuzzcheck, activate vdbe_debug for dbsqlfuzz cases when using the -vvvvv verbosity level or above. (check-in: 2e6f7c2ace user: drh tags: dbsqlfuzz-in-fuzzcheck)
04:43		Improved automatic detection of dbsqlfuzz cases in fuzzcheck. (check-in: 1ef24e89c9 user: drh tags: dbsqlfuzz-in-fuzzcheck)
04:00		Add the ability to process dbsqlfuzz cases in fuzzcheck and add an initial set of interesting dbsqlfuzz cases. (check-in: fb9074ff45 user: drh tags: dbsqlfuzz-in-fuzzcheck)

4 Years Ago (more context)

2018-01-25
20:50		Reorganize zipfile.c code to make it easier to add support for in-memory zip archive processing. (check-in: 30b9258294 user: dan tags: trunk)
01:20		Slightly smaller and faster implementation of OP_If and OP_IfNot. (check-in: 6ab42934e2 user: drh tags: trunk)

5 Years Ago (more context)

2017-01-25
20:59		• Edit [4801bd59a01dcc11|4801bd59a0]: Edit check-in comment. (artifact: 40110994ad user: drh)
20:55		Trim NULL values off the end of records when the SQLITE_ENABLE_NULL_TRIM compile-time option is used. Increase the size of the P5 operand to 16 bits. Fix a problem with short records in the sessions extension. (check-in: 4801bd59a0 user: drh tags: trunk)
19:04		• Fixed ticket [e6e962d6b0]: sqlite3_blob_reopen() misbehavior on ALTER-ed table plus 5 other changes (artifact: 3850384c85 user: drh)
18:53		Fix another pre-update hook issue, this time in sqlite3preupdate_old(). (Closed-Leaf check-in: c7651d21bf user: dan tags: trim-nulls)
18:12		Fix a test script problem in exclusive2.test causing it to fail on this branch. (check-in: f66614dc78 user: dan tags: trim-nulls)
17:44		Fix a problem with the pre-update hook on this branch. (check-in: 6fc4fbfa29 user: dan tags: trim-nulls)
14:58		Experimental enhancement to automatically trim NULL values from the end of records, for a reduced disk footprint. This change also involves increasing the P5 operand from 8 to 16 bits. (check-in: 118ded403b user: drh tags: trim-nulls)
14:38		Ensure that sqlite3_blob_reopen() correctly handles short rows. Fix for ticket [e6e962d6b0f06f46e]. (check-in: 8cd1a4451c user: drh tags: trunk)
13:54		Fix SQLITEINT_H macro usage in two extensions. (check-in: 0803390c15 user: drh tags: trunk)
04:41		Ensure that sqlite3_blob_reopen() correctly handles short rows. Proposed fix for ticket [e6e962d6b0f06f46e]. Further testing needed. (Closed-Leaf check-in: 57d8dad35c user: drh tags: blob_reopen-fix)
04:28		• New ticket [e6e962d6b0] sqlite3_blob_reopen() misbehavior on ALTER-ed table. (artifact: a6d71ce73f user: drh)

10 Years Ago (more context)

2012-01-25
22:09		• Edit [2a7170f03c746473|2a7170f03c]: Edit check-in comment. (artifact: 38c5513857 user: drh)
22:08		Cherrypick the FTS fix in [c05c3fd20d9] into the nx-devkit branch. Ticket [edb497982c]. (check-in: 2a7170f03c user: drh tags: nx-devkit)
20:43		Only invalidate the schema when the OP_ParseSchema opcode fails, not on any general failure of a vdbe program. (check-in: 11f68d997d user: drh tags: trunk)
19:07		• Edit [c05c3fd20d93f430|c05c3fd20d]: Edit check-in comment. (artifact: 982ac8d3e3 user: dan)
19:04		• New ticket [edb497982c] FTS n-character prefix query returns incorrect results when using an n+1 character prefix index.. (artifact: 4cd1b8659f user: dan)
16:29		Fix an FTS problem triggered by querying for an N character prefix using an N+1 character prefix index after rows have been deleted from the FTS table. Fix for [edb497982c]. (check-in: c05c3fd20d user: dan tags: trunk)

15 Years Ago (more context)

2007-01-25
16:56		Fix an additional problem with the IS NULL optimization on LEFT JOINs. Ticket #2189. See also ticket #2177. (CVS 3602) (check-in: 358dd82d3a user: drh tags: trunk)