This Day In History For 2023-11-06

1 Year Ago (more context)

2022-11-06
17:19		The recoverAssertMutexHeld() function is for testing and verification only and should be a harmless no-op for production builds. [forum/forumpost/b4f2c7d402|Forum post b4f2c7d402]. (check-in: d75504710c user: drh tags: trunk)
13:12		shell.c.in: on non-Windows platforms, check for $XDG_CONFIG_HOME/sqlite3/sqliterc before ~/.sqliterc, per request in forum post 7a16582b1e403c81. (Closed-Leaf check-in: 49c6e438a8 user: stephan tags: sqliterc-xdg-config)

2 Years Ago (more context)

2021-11-06
20:25		Add ALWAYS() to a branch made unreachable by the previous check-in. (check-in: 0dc963f63a user: drh tags: trunk)
18:22		Return an error if an attempt is made to drop an eponymous virtual table. (check-in: 889dea52de user: dan tags: trunk)
16:46		Merge further changes from trunk into this branch. (check-in: 700876b79c user: dan tags: wal2)
16:36		Merge change [6979efbf07d93e7a] from trunk to this branch. (check-in: 2bb2448d60 user: dan tags: wal2)
16:10		Merge changes from trunk into this branch. (check-in: 52667bce48 user: dan tags: wal2)
11:58		Add the rbu_exclusive_checkpoint query parameter to RBU. (Leaf check-in: c15806a45a user: drh tags: reuse-schema-3.36)
10:59		Avoid accessing the sqlite3_module.xShadowName field if (sqlite3_module.iVersion<3). (check-in: a024764cef user: drh tags: trunk)
10:51		• Edit [ca09148e13d33a74|ca09148e13]: Move to branch reuse-schema. (artifact: 59a23ff6f0 user: drh)
07:08		Avoid accessing the sqlite3_module.xShadowName field if (sqlite3_module.iVersion<3). (check-in: b1fc3de81e user: dan tags: reuse-schema)

3 Years Ago (more context)

2020-11-06
16:48		Add ALWAYS() to conditionals associated with SHM locking that are always true. (check-in: b599e89076 user: drh tags: trunk)

4 Years Ago (more context)

2019-11-06
23:10		• New ticket [299b50ba81] UPDATE on table with two generated columns and CHECK clause results in segfault. (artifact: 627b555460 user: mrigger)
22:20		• Fixed ticket [4fc08501f4]: Segfault when inserting into table with generated columns plus 6 other changes (artifact: 635c203d34 user: drh)
22:19		Change the way generated columns are computed so that no column is computed inside branch code that might not be taken. Ticket [4fc08501f4e56692] (check-in: 9e07b48934 user: drh tags: trunk)
19:25		Minor simplification to the changes from check-in [36c11ad51f]. (check-in: 7bc8205dd9 user: mistachkin tags: trunk)
17:31		• Fixed ticket [ce22a07731]: NULL WHERE condition unexpectedly results in row being fetched plus 6 other changes (artifact: d70a33c49d user: drh)
17:31		Fix the OP_DeferredSeek index-to-table column map in P4 so that it works with generated columns. Ticket [ce22a07731530118] (check-in: 36c11ad51f user: drh tags: trunk)
15:41		• New ticket [4fc08501f4] Segfault when inserting into table with generated columns. (artifact: 73daa54fdf user: mrigger)
15:16		• New ticket [ce22a07731] NULL WHERE condition unexpectedly results in row being fetched. (artifact: b13b7dce76 user: mrigger)
14:50		• Fixed ticket [2399f59861]: REPLACE on table with generated NOT NULL column results in segfault plus 6 other changes (artifact: 990c736a41 user: drh)
14:49		Fix the handling of NOT NULL constraint violations for generated columns in a REPLACE statement. Ticket [2399f5986134f79c] (check-in: 77b1c90add user: drh tags: trunk)

5 Years Ago (more context)

2018-11-06
20:08		Update the changesetfuzz program to fuzz changeset schemas as well as data. (check-in: 141a93c843 user: dan tags: changesetfuzz)
19:26		Enable DEFENSIVE mode by default for tests. This requires lots of case of turning DEFENSIVE off in order to dodgy things to the database for testing purposes. No all of those cases are yet handled, so "make test" does not run to completion. (check-in: a1d6c6712c user: drh tags: read-only-shadow)
15:57		Turn on defensive mode for running test scripts. Does not yet work. (check-in: 1c1d24edbb user: drh tags: read-only-shadow)
14:03		Only allow shadow table to be written from within a recursive SQL call. Omit the SQLITE_PREPARE_SHADOW flag. Some tests are failing because the tests depend on being able to write to shadow tables. (check-in: d890c65825 user: drh tags: read-only-shadow)
13:37		Add enforcement of read-only on shadow tables. This does not currently work since some virtual tables are attempting to update shadow tables using sqlite3_exec(). (check-in: f79b47c985 user: drh tags: read-only-shadow)

10 Years Ago (more context)

2013-11-06
19:59		Reference count the KeyInfo object. Cache a copy of an appropriate KeyInfo for each index in the Index object, and reuse that one copy as much as possible. (check-in: defd5205a7 user: drh tags: omit-rowid)
16:28		Have the OP_NoConflict opcode set the VdbeCursor.seekResult variable. This speeds up subsequent OP_Insert and OP_IdxInsert opcodes. (check-in: 474555002d user: dan tags: omit-rowid)
14:52		Use ansi escape codes to use different colored text for opcode names in the output of [explain_i]: Red for opcodes that insert or delete b-tree elements, blue for opcodes that move cursors and green for the ResultRow opcode. (check-in: 4be2b64b3e user: dan tags: omit-rowid)
14:36		Allocate extra stack space for UnpackedRecord objects, reducing the need to malloc for them as often, and thereby get a performance improvement. (check-in: a725a75f87 user: drh tags: omit-rowid)
14:05		Minor optimization to the OP_Halt opcode. (check-in: d70c78814b user: drh tags: omit-rowid)
12:56		Improved ORDER BY optimization for WITHOUT ROWID tables. (check-in: 8f1709ff2d user: drh tags: omit-rowid)
12:05		Disable the OR optimization for WITHOUT ROWID tables, since it relies on the use of rowids. (check-in: 6055dad2ba user: drh tags: omit-rowid)
11:46		Remove an incorrect test case from conflict2.test. (check-in: 427612efc1 user: drh tags: omit-rowid)
02:36		Remove an unused variable. (check-in: e9c1e419b7 user: drh tags: omit-rowid)

15 Years Ago (more context)

2008-11-06
15:33		Fix a bug in the CAST operator associated with the column cache. (CVS 5866) (check-in: 1b6a514044 user: drh tags: trunk)