SQLite

Today In History
Login

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)