SQLite

Today In History
Login

This Day In History For 2019-07-22

1 Year Ago (more context)

2018-07-22
21:23
Fix more harmless compiler warnings seen with MSVC. (check-in: edab5666f8 user: mistachkin tags: trunk)
21:08
Another minor revision to the 'fulltestonly' set of tests. (check-in: 61f8e2a4c6 user: mistachkin tags: trunk)
20:24
Fix harmless compiler warning. (check-in: ead4762dfc user: mistachkin tags: trunk)
06:25
In the Win32 VFS, when truncating a file, unmap it first. (check-in: 21510a66dc user: mistachkin tags: trunk)
00:45
Remove an unused branch in the FK logic. (Closed-Leaf check-in: 523ff77925 user: drh tags: dropViewNoStat)

2 Years Ago (more context)

2017-07-22
20:12
Add a test for the outcome of a process crash within an xWrite VFS method call. (check-in: eb8718006c user: dan tags: batch-atomic-write)
16:58
Add the "atomic-batch-write" permutation to permutations.test. This permutation fails if not run on a file-system that supports atomic-batch-writes. (check-in: 9f1b83fae9 user: dan tags: batch-atomic-write)
16:32
Keep batch-atomic-writes turned on for journal_mode=MEMORY, but turn them off for synchronous=OFF. Refuse to compile with both SQLITE_MMAP_READWRITE and SQLITE_ENABLE_BATCH_ATOMIC_WRITE. Fix up some comments in the commit logic. (check-in: 2e80e19e4f user: drh tags: batch-atomic-write)
16:00
Omit unused batch-atomic-write code if SQLITE_ENABLE_BATCH_ATOMIC_WRITE is not defined. (check-in: a89b62c496 user: drh tags: batch-atomic-write)

3 Years Ago (more context)

2016-07-22
21:35
Revise a warning fix from the previous check-in to improve clarity. Also, fix an incorrect test prefix (typo). (check-in: f50a3fd660 user: mistachkin tags: trunk)
21:26
Fix harmless compiler warnings seen with MSVC. (check-in: 8bb6e6fced user: mistachkin tags: trunk)
20:45
Be sure to hold the database connection mutex while calling sqlite3VdbeExpand() from within sqlite3_expanded_sql(). (check-in: 527b5ba68c user: drh tags: sqlite3_trace_v2)
20:20
Add requirements marks to the sqlite3_expanded_sql() documentation. (check-in: 409535e6df user: drh tags: sqlite3_trace_v2)
17:58
Merge latest trunk changes with this branch. (check-in: 60fed5cdd4 user: dan tags: rowvalue)
10:09
Fix a problem with upper case module names in the "sqldiff --vtab" command. (check-in: 87e25fc472 user: dan tags: trunk)

5 Years Ago (more context)

2014-07-22
22:46
When running ANALYZE, it is not necessary to check the right-most key column for changes since that column will always change if none of the previous columns have. (check-in: 48f40861db user: drh tags: trunk)
20:02
Add the OP_ReopenIdx opcode that works like OP_OpenRead except that it becomes a no-op if the cursor is already open on the same index. Update the OR-optimization logic to make use of OP_ReopenIdx in order to avoid unnecessary cursor open requests sent to the B-Tree layer. (check-in: 77f412caf0 user: drh tags: trunk)
19:14
The optimization of check-in [b67a6e33f2] does not work (it generates incorrect VDBE code) if an OR term is AND-ed with a constant expression. So back that optimization out and add a test case to make sure it does not get added back in. (check-in: eed754fe93 user: drh tags: trunk)
16:00
Fix the index name for the shadow tables in the spellfix1 extension so that multiple instances of the spellfix1 virtual table can each have their own index. (check-in: 438c348a40 user: drh tags: trunk)
15:33
Correction: The maximum SQLITE_MAX_ATTACHED value to avoid overflowing a signed 8-bit integer is 125, not 127. (check-in: 48e3780295 user: drh tags: trunk)
14:58
Enhance the sqlite_stat1.stat parsing to allow additional text parameters at the end. Unrecognized parameters are silently ignored. (check-in: ca2a5a2c77 user: drh tags: trunk)
14:42
Expire prepared statements after running ANALYZE. (check-in: b083a961f8 user: drh tags: trunk)
12:05
Enhance the comment on whereLoopAddBtree(). No changes to code. (check-in: b22dd165da user: drh tags: trunk)
00:40
For the OR-optimization, avoid generating OP_OpenRead opcodes that reopen exactly the same index. (check-in: b67a6e33f2 user: drh tags: trunk)

10 Years Ago (more context)

2009-07-22
18:24
Modify mksqlite3c.tcl so that it inserts SQLITE_API macros into sqlite3.h. Ticket #3983. (CVS 6924) (check-in: 803ec79f3b user: danielk1977 tags: trunk)
18:07
Simplifications to btree.c in support of coverage testing. (CVS 6923) (check-in: 375fd6f9c5 user: drh tags: trunk)
16:41
Avoid leaving a suspect page in the page-cache if an error occurs during sqlite3PagerAcquire(). (CVS 6922) (check-in: 2594f01c73 user: danielk1977 tags: trunk)
14:08
Fix a double-free that can occur after database corruption is detected. (CVS 6921) (check-in: 5260e8b104 user: danielk1977 tags: trunk)
13:19
Add a NEVER() macro around a pager.c conditional that must always be false in the current implementation. (CVS 6920) (check-in: 1e510d7fc5 user: drh tags: trunk)
07:27
Changes to test code (only) to allow veryquick.test to run with OMIT_UTF16 builsd. Ticket #3985. (CVS 6919) (check-in: 7f3fc7f20f user: danielk1977 tags: trunk)
02:02
Remove an ALWAYS() from a condition that can in fact be false under very obscure circumstances. (CVS 6918) (check-in: 3808322895 user: drh tags: trunk)
00:35
Further simplifications to btree.c, especially the sqlite3BtreeKey() and sqlite3BtreeData() functions. New assert() statements added to verify that these routines are called correctly. (CVS 6917) (check-in: 96cfd07952 user: drh tags: trunk)

15 Years Ago (more context)

2004-07-22
19:06
Home page updates. (CVS 1861) (check-in: 15774aab7d user: drh tags: trunk)
18:54
Version 3.0.3 (CVS 1860) (check-in: 068b15ae2a user: drh tags: trunk)
18:53
Version 2.8.15 (CVS 1859) (check-in: 102ab94167 user: drh tags: version_2)
18:53
Updates to the publish.sh script and the download.html webpage. (CVS 1858) (check-in: 23c2ec4591 user: drh tags: trunk)
18:44
Fixes to the publish.sh file for version 3.0. (CVS 1857) (check-in: cc82288b9f user: drh tags: trunk)
18:08
Fix the publish.sh script so that it builds and packages windows DLLs correctly. (CVS 1856) (check-in: 81aa41e7d4 user: drh tags: version_2)
17:10
Another attempt at fixing the memory allocation problem in sqliteExprListDup(). (CVS 1855) (check-in: 49c2ad8a75 user: drh tags: version_2)
16:32
Bug fix in allocation of expression lists after a malloc() failure. (CVS 1854) (check-in: 09494cab4f user: drh tags: version_2)
16:12
Update changes log for 2.8.15. Add new architecture images. (CVS 1853) (check-in: 8dd9b4de27 user: drh tags: trunk)
16:08
file join4_28.test was initially added on branch version_2. (CVS 1852) (check-in: dc3caba7f0 user: drh tags: trunk)
16:08
Add join tests to the 2.8 branch. (CVS 1850) (check-in: e5546f49c7 user: drh tags: version_2)
16:08
file join3_28.test was initially added on branch version_2. (CVS 1851) (check-in: ee5c2cff81 user: drh tags: trunk)
15:53
Update the version number for release 2.8.15. (CVS 1849) (check-in: 9b3c3ca4af user: drh tags: version_2)
15:47
Update VERSION and changes.html in preparation for the next release. (CVS 1848) (check-in: 428f80239e user: drh tags: trunk)
15:45
Change sqlite* to sqlite3* in the API reference for version 3.0. Ticket #818. (CVS 1847) (check-in: 7c96daddb6 user: drh tags: trunk)
15:02
Fix bugs associated with the codec. (CVS 1846) (check-in: b0a3becd82 user: drh tags: trunk)
02:40
Changes in support of using a codec. (CVS 1845) (check-in: 58505bf9be user: drh tags: trunk)
02:40
Changes in support of using a codec. (CVS 1844) (check-in: b77bec3574 user: drh tags: trunk)
01:19
Initial implementation of variable page sizes and the temp_store pragma. (CVS 1843) (check-in: 4cf6e9db75 user: drh tags: trunk)