This Day In History For 2025-05-14

1 Year Ago (more context)

2024-05-14
19:41		Optimize queries against fts5vocab(row) tables that do use the "cnt" column. (Closed-Leaf check-in: 96a591c202 user: dan tags: fts5-delay-tokenizer)
19:09		Avoid calculating the value of the "cnt" column for fts5vocab(row) queries that do not use it. (check-in: c0c91e306c user: dan tags: fts5-delay-tokenizer)
17:16		Have fts5 tables delay initializing the tokenizer until it is first used in all cases where the tokenizer is not "trigram". (check-in: ca4fdcb8ae user: dan tags: fts5-delay-tokenizer)

3 Years Ago (more context)

2022-05-14
19:05		Do not allow an index scan on an index-on-expression for a RIGHT JOIN because the index might not be positioned on the correct row when running the the right-join no-match loop. dbsqlfuzz 39ee60004ff027a9e2846cf76e02cd5ac0953739 (check-in: 2277f9ba70 user: drh tags: trunk)
17:40		Improved debugging comment generation for the OP_Column opcode. (check-in: 3e073bfddf user: drh tags: trunk)
15:59		Improvements to the decision of when to check ON constraints for an inner join that is an operand to a RIGHT JOIN. Fix for issue identify by forum post c06b10ad7e. (check-in: 9d17233c7d user: drh tags: trunk)

4 Years Ago (more context)

2021-05-14
20:01		Small performance improvement for sqlite3BtreeInsert(). (check-in: 4ae64484c5 user: drh tags: trunk)
15:37		Avoid adding superfluous virtual WHERE clause terms that might arise due to the constant propagation optimization. (check-in: cf63abbe55 user: drh tags: trunk)
14:26		Attempt the constant propagation optimization on any WHERE clause that has a top-level AND operator, even if the query is not a join. This is an attempt to partially address the concern raised in forum post 830d37b928. (check-in: e994c9f29f user: drh tags: trunk)
13:32		Fix an over-length source code comment in whereexpr.c. No logic changes. (check-in: af5eb902e7 user: drh tags: trunk)

5 Years Ago (more context)

2020-05-14
23:59		Fix a null pointer deference that can occur on a strange matchinfo() query. (check-in: a4dd148928 user: drh tags: trunk)
21:16		Do not allow a virtual table to be renamed into the name of one of its shadows. (check-in: eca0ba2cf4 user: drh tags: trunk)

10 Years Ago (more context)

2015-05-14
15:39		Increase the version number to 3.8.11. Upgrade autoconf from 2.62 to 2.69. (check-in: be438d049d user: drh tags: trunk)
15:17		Merge in the IS-operator enhancements and other recent changes from trunk. (check-in: 4f9229445c user: drh tags: sessions)
14:52		• Edit [82e5a6e088c58815|82e5a6e088]: Mark "Closed". (artifact: bd1b0a94ea user: drh)
14:51		• Edit [3997d47bb9c8593a|3997d47bb9]: Mark "Closed". (artifact: c16b3d139e user: drh)
14:51		• Edit [ce184c7bb1698864|ce184c7bb1]: Mark "Closed". (artifact: 2d16c16f27 user: drh)
14:51		• Edit [f668616a29686f3c|f668616a29]: Mark "Closed". (artifact: 20a24e2d88 user: drh)
14:51		• Edit [24aa20da222a9cc1|24aa20da22]: Mark "Closed". (artifact: 13657c2419 user: drh)
14:50		• Edit [66dddda06898abbf|66dddda068]: Mark "Closed". (artifact: 1ac0f5b834 user: drh)
14:32		The IS operator can now use indexes the same as the == operator. (check-in: 3428043cd0 user: drh tags: trunk)
14:03		A few more test cases for the IS operator. (Closed-Leaf check-in: f397c8622a user: drh tags: index-is-operator)
13:41		More test cases. Remove some invalid testcase() macros. Rearrange some code for improved testability. (check-in: b3676377b2 user: drh tags: index-is-operator)
13:18		Add testcase() macros. Get transitive WHERE clause constraints on IS operators working again. (check-in: d195d4a65d user: drh tags: index-is-operator)
09:53		Merge changes from the index-is-operator branch into this one. Drop the partial support added for IS on this branch by [52e73eec]. (check-in: 16ab9cafd0 user: dan tags: ota-update)
08:58		Merge latest trunk changes with this branch. (check-in: 299ed55c90 user: dan tags: ota-update)
01:05		A new implementation of indexing with the IS operator that works correctly when the IS operator is in the WHERE clause and the operands are from opposite sides of a LEFT JOIN. (check-in: 4541688b3f user: drh tags: index-is-operator)

15 Years Ago (more context)

2010-05-14
20:15		Fix a typo that (by bad luck) was not a syntax error but which caused some important lines of code to be skipped when SQLITE_DEBUG was not used. (check-in: 9ef99d97d2 user: drh tags: trunk)
19:24		• Fixed ticket [dd08e5a988]: Foreign key constraint fails to prevent consistency error. plus 2 other changes (artifact: d0c360fce3 user: drh)
19:24		Make sure the value of an INTEGER PRIMARY KEY column supplied to triggers and especially to FK constraints really contains the ROWID and not the NULL that is stored in the column itself. Ticket [dd08e5a988d00dec]. (check-in: 636f86095e user: drh tags: trunk)
18:20		• New ticket [dd08e5a988] Foreign key constraint fails to prevent consistency error.. (artifact: 9f47adfdd6 user: drh)
16:34		Pull in all the latest changes from the trunk. Update the win32 SHM methods to work with the new interface design. (Closed-Leaf check-in: 4b69f2cd31 user: drh tags: wal-win32)
14:52		Simplifications to the SHM implementation in os_unix.c, taking advantage of the removal of the LinuxThreads mess. (check-in: d1debe5def user: drh tags: trunk)
12:43		Simplify os_unix.c by removing support for LinuxThreads. Linux systems must either use NPTL or else not share database connections across threads. (check-in: e294b696ba user: drh tags: trunk)
11:30		Change the OSTRACEn() macro to OSTRACE(()). Also rename some internal fields and variables in os_unix.c to be more meaningful and searchable. (check-in: 5fe529f239 user: drh tags: trunk)
10:43		Fix test_osinst.c so that it does not depend on gettimeofday() unless SQLITE_OS_UNIX is defined and NO_GETTOD is not defined. (check-in: 2a4014b79b user: dan tags: trunk)
08:39		Add xShmXXX methods to test_osinst.c. (check-in: b8a9b37a3c user: dan tags: trunk)