This Day In History For 2020-08-07

1 Year Ago (more context)

2019-08-07
21:30		• Ticket [f8a7060e] Incorrect result for query that uses MIN() and a CAST on rowid status still Open with 7 other changes (artifact: 3bee902b user: drh)
20:20		• New ticket [f8a7060e]. (artifact: 99392c9c user: mrigger)
19:57		Remove use of the affinity() function from view.test, as it is only available in SQLITE_DEBUG builds. (check-in: 7f2246a1 user: dan tags: trunk)
18:34		Add "set TMP=%CD%" to the start of each msvc script output by releasetest_data.tcl. Otherwise, since binaries compiled with SQLITE_TEST all choose the same sequence of pseudo-random numbers, collisions between temp file names cause errors when running multiple tests in parallel. (check-in: f5d0436d user: dan tags: trunk)
17:45		Eliminate some more cases of redundant sorting in window-function queries. (check-in: 8158d2ac user: dan tags: trunk)
13:25		Do not make SQLITE_READ authorizer calls for tables without names, as all such tables will be internal-use-only tables for subqueries and whatnot. (check-in: 193c87fc user: drh tags: trunk)

3 Years Ago (more context)

2017-08-07
19:12		Avoid casting a value larger than 2^31 to a (size_t) or (SIZE_T) on systems where it is a 32-bit type. (check-in: b26d7a1c user: dan tags: trunk)
19:06		On Windows, avoid casting a value larger than 2^31 to a (SIZE_T) on systems where it is a 32-bit type. (Leaf check-in: f08d63b4 user: mistachkin tags: mmap-size-limit)
18:54		Fix a problem with handling SQLITE_FCNTL_MMAP_SIZE requests with a negative parameter in os_unix.c. (check-in: 4249fcf7 user: dan tags: mmap-size-limit)
18:51		• Edit [46c3085dcad6372a|46c3085d]: Move to branch mmap-size-limit. (artifact: 8e84a122 user: dan)
18:51		• Edit [46c3085dcad6372a|46c3085d]: Change background color to "#ffc0ff". Add tag "mmap-size-limit". (artifact: b4eb2328 user: dan)
18:27		Update bigmmap.test to account for builds that use "-DSQLITE_MAX_MMAP_SIZE=<integer-constant>LL". (check-in: 7c8b6f1c user: dan tags: mmap-size-limit)
18:13		Avoid casting a value larger than 2^31 to a (size_t) on systems where it is a 32-bit type. (check-in: 46c3085d user: dan tags: mmap-size-limit)
17:28		Fix an out-of-order test number. (check-in: 38f30091 user: mistachkin tags: trunk)
17:14		Add new test file "bigmmap.test". For testing builds with -DSQLITE_MAX_MMAP_SIZE > 2GB. (check-in: 17447062 user: dan tags: trunk)
14:15		Update this branch with latest trunk changes. (check-in: 17bc7ded user: dan tags: server-process-edition)
14:06		Fix a bug on this branch involving mmap mode and readonly transactions. (check-in: 355c594e user: dan tags: server-process-edition)

4 Years Ago (more context)

2016-08-07
18:52		Fix documentation typos. No changes to code. (check-in: ebc396a1 user: drh tags: trunk)

5 Years Ago (more context)

2015-08-07
20:57		Enhance the query planner so that it is able to use partial indexes that use AND-connected terms in the WHERE clause. (check-in: 06576590 user: drh tags: trunk)
20:06		Add a specially formatted comment to shell.c to make it easier for scripts to edit. No code changes. (check-in: 6d47b35a user: dan tags: trunk)
09:42		Within a write-transaction on a wal database in mmap mode, check the page-cache for an entry before the wal file. This can be faster if the wal file is very large. (Leaf check-in: 3a82c8e6 user: dan tags: mmap-wal-bigtrans)

10 Years Ago (more context)

2010-08-07
16:17		Fix minor problems and update comments in pager.c. (check-in: 92e45637 user: dan tags: experimental)
11:46		Merge in all changes up to the 3.7.0.1 release. (check-in: f88c6367 user: drh tags: apple-osx)
09:31		Fix a problem wherein changing the journal-mode immediately after leaving exclusive-locking mode could lead to the database being unlocked without clearing the changeCountDone flag. (check-in: 531abc80 user: dan tags: experimental)
05:15		Add test case 'cgt_pager_1', intended for use with callgrind to detect performance regression in the pager module, to threadtest3.c. (check-in: b5d46f1e user: dan tags: experimental)