SQLite

Today In History
Login

This Day In History For 2020-04-03

1 Year Ago (more context)

2019-04-03
17:54
Add a defense-in-depth NEVER() test to the WAL cleanup code. (Leaf check-in: 1109942a50 user: drh tags: branch-3.27)
17:48
Add a defense-in-depth NEVER() test to the WAL cleanup code. (check-in: 8d3af2010f user: drh tags: trunk)
16:27
Fix a couple of problems with "RANGE BETWEEN <expr> PRECEDING AND <expr> PRECEDING" frames. (check-in: 39225cc775 user: dan tags: trunk)

2 Years Ago (more context)

2018-04-03
20:44
Fix an error message in speedtest1.c and make the "trigger" testset sensitive to the --size parameter. (check-in: 5a6fd9e015 user: drh tags: trunk)
20:00
Update speedtest1.c with new testset "trigger" based on the tests in speed4p.test. (check-in: 7b7fa5fa0d user: dan tags: trunk)
17:05
Fix a few small test script issues affecting SQLITE_TEMP_STORE=3 builds. (check-in: e171f3722f user: dan tags: trunk)
14:37 Ticket [fac496b617] Over-aggressive LEFT JOIN optimization on virtual tables status still Open with 5 other changes (artifact: 2466fb913e user: drh)
14:25
Fix the generate_series virtual table so that it correctly returns no rows if any of its constraints are NULL. Ticket [fac496b61722daf28]. (check-in: 3328e828e2 user: drh tags: trunk)
14:10 Edit [cbb977fe1908431f|cbb977fe19]: Edit check-in comment. (artifact: 94034fb540 user: drh)
14:04
Change the LEFT JOIN strength reduction optimization so that assumes that virtual table constraints can be true even if terms within the constraint are NULL. This works around dodgy virtual table implementations. Fix for ticket [fac496b61722daf2]. (check-in: cbb977fe19 user: drh tags: trunk)
13:38 Ticket [fac496b617] Over-aggressive LEFT JOIN optimization on virtual tables status still Open with 6 other changes (artifact: eedbb46e37 user: drh)
12:48 New ticket [fac496b617]. (artifact: fd18820b04 user: drh)

3 Years Ago (more context)

2017-04-03
14:07
Avoid an unnecessary call to sqlite3WhereGetMask() inside of whereShortCut(). (check-in: 5c11f4303f user: drh tags: trunk)
13:59
Do not attempt to run sync2.test with SQLITE_DISABLE_DIRSYNC builds. (check-in: 658f08ce84 user: dan tags: trunk)
13:33
Force a schema load prior to "PRAGMA optimize". (check-in: 86897c24c0 user: drh tags: trunk)
13:17
Fix typos in the documentation for OP_Column. (check-in: 777b43e64f user: drh tags: trunk)
12:04
Slightly smaller and faster implementation for vdbeSorterCompareInt(). (check-in: 84fa069c5b user: drh tags: trunk)

4 Years Ago (more context)

2016-04-03
22:44
Revise and enhance the Win32 string conversion routines. (check-in: 345860c921 user: mistachkin tags: altShellFix)
20:50
Replace the new fprintf() calls. (check-in: f76c3a0ca4 user: mistachkin tags: altShellFix)
20:45
Merge updates from trunk. (check-in: 566b551e5a user: mistachkin tags: altShellFix)

5 Years Ago (more context)

2015-04-03
20:33
Disable the SQLITE_FCNTL_WAL_BLOCK feature for now. It needs more work and is not yet ready for release. (check-in: 4ae9a3acc4 user: drh tags: trunk)
18:33
Add source code to the "showlocks" utility program in the tool/ subdirectory. (check-in: 6868cc66d2 user: drh tags: trunk)

10 Years Ago (more context)

2010-04-03
23:57 Verified ticket [775b39dd3c]: Poor query planning with virtual tables, joins and ORDER BY. plus 6 other changes (artifact: 136d8ef9fc user: anonymous)
23:49 Ticket [775b39dd3c]: 1 change (artifact: 58ca3c1451 user: anonymous)
13:08
Silently abandon a rollback if the journal has been truncated. (check-in: 7626f6c9ea user: drh tags: trunk)

15 Years Ago (more context)

2005-04-03
23:54
Apply Tcl 'nullvalue' patch from Stefan Finzel. (CVS 2441) (check-in: 9906ae37b9 user: danielk1977 tags: trunk)