This Day In History For 2020-09-23
1 Year Ago (more context)
2019-09-23
| ||
12:38 | Omit the sqlite3IntTokens array constant for a code simplification. (check-in: f907395e user: drh tags: trunk) | |
11:58 | • Edit [82e5dcf5c1d500ed|82e5dcf5]: Edit check-in comment. (artifact: 888509c1 user: drh) | |
11:55 | • Fixed ticket [99cd4807]: Scalar subquery with "LIMIT 0" should return NULL plus 5 other changes (artifact: 9f208d7d user: drh) | |
11:55 | When a scalar subquery has a pre-existing "LIMIT X" then change it to "LIMIT X<>0" rather than just "LIMIT 1" so that if X is 0 the limit will still be zero. Ticket [99cd4807dc03f178]. Test cases in TH3. (check-in: 82e5dcf5 user: drh tags: trunk) | |
11:44 | • New ticket [99cd4807] Scalar subquery with "LIMIT 0" should return NULL. (artifact: 56f51649 user: drh) | |
2 Years Ago (more context)
2018-09-23
| ||
02:01 | Fix a faulty assert() in the validation logic for the LEFT JOIN strength reduction optimization. Problem found by OSSFuzz. (check-in: 2fd62fcc user: drh tags: trunk) | |
3 Years Ago (more context)
2017-09-23
| ||
07:46 | Experimental change so that snapshot transactions always lock the wal file - preventing writers or truncate-checkpointers from wrapping it. (Closed-Leaf check-in: d71eeaab user: dan tags: snapshots-lock-wal) | |
4 Years Ago (more context)
2016-09-23
| ||
21:36 | Add the EP_Leaf flag bit to the Expr.flags field to indicate Expr nodes that do not have substructure. Use that bit to avoid unnecessary recursion. (check-in: 8a6ea455 user: drh tags: trunk) | |
20:59 | Use sqlite3ExprAlloc() instead of sqlite3PExpr() for leaf nodes in the expression tree, where appropriate. This is both smaller and faster. (check-in: afac0709 user: drh tags: trunk) | |
18:13 | New test case for the ORDER BY LIMIT optimization. (check-in: 9a5a489d user: drh tags: trunk) | |
18:06 | Fix the ORDER BY LIMIT optimization backport so that it works when the ORDER BY uses the DESC direction. (check-in: 0c3cafb7 user: drh tags: branch-3.8.9) | |
5 Years Ago (more context)
2015-09-23
| ||
19:17 | Take care that the number of reserved bits per page is consistent between the source and destination databases when doing the back-copy on a VACUUM. (check-in: 5b61b72f user: drh tags: trunk) | |
16:41 | • Edit [7b84641e55654f8e|7b84641e]: Mark "Closed". (artifact: d3173abb user: mistachkin) | |
16:39 | • Edit [0ddb2532b2daaaf1|0ddb2532]: Mark "Closed". (artifact: 5f448179 user: mistachkin) | |
16:36 | • Edit [6b85f8cd4d87d616|6b85f8cd]: Mark "Closed". (artifact: 25626772 user: mistachkin) | |
16:35 | Merge updates from trunk. (check-in: 0a75ebd2 user: mistachkin tags: mutexInitIsInitReCheck) | |
16:33 | Correct superfluous whitespace difference. No functional changes. (check-in: 8d69983d user: mistachkin tags: mutexInitSimpleCmpSwap) | |
16:24 | Simplify thread-safety of mutex initialization. (check-in: da0587c5 user: mistachkin tags: mutexInitSimpleCmpSwap) | |
15:54 | Merge updates from trunk. (Closed-Leaf check-in: 6b85f8cd user: mistachkin tags: mutexInitCmpSwap) | |
11:59 | Capture AFL-generated fuzz tests for json1.c into the test/fuzzdata4.db file. (check-in: 10a214fd user: drh tags: trunk) | |
01:10 | Do not allow a comma at the end of a JSON array or object. (check-in: 7c7a3f3e user: drh tags: trunk) | |
10 Years Ago (more context)
2010-09-23
| ||
18:47 | Add tests to e_delete.test. (check-in: fab3b383 user: dan tags: trunk) | |
15 Years Ago (more context)
2005-09-23
| ||
21:11 | Fix an uninitialized structure member that was causing a malfunction when you used deeply nested and very complex views. Ticket #1449. (CVS 2733) (check-in: 352cc9f5 user: drh tags: trunk) | |