SQLite

Today In History
Login

This Day In History For 2020-05-08

1 Year Ago (more context)

2019-05-08
23:56 Edit [ebe4845cd0ffb96b|ebe4845cd0]: Edit check-in comment. (artifact: 0cd4ae8dea user: drh)
23:55
Ensure that the sqlite3BtreeLast() interface initializes the *pRes return to zero if the cursor is already sitting on the last entry of the table. Manuel Rigger found the obscure test case for which this makes a difference. (check-in: ebe4845cd0 user: drh tags: trunk)
23:53
This is part of the previous check-in that didn't get committed for some reason - probably because I failed to press the "Save" button on the text editor. (check-in: 51d32173ff user: drh tags: trunk)
21:14
Add another test case to cover a previously uncovered branch in the RBU module. (check-in: 3039298561 user: dan tags: trunk)
19:55
Fix another pattern for which the LIKE optimization does not work for a non-TEXT affinity. Case found by Manuel Rigger. (check-in: 740201107a user: drh tags: trunk)
19:32
Simplification to the logic underlying PRAGMA case_sensitive_like. (check-in: ef0015fde4 user: drh tags: trunk)
19:06
Avoid an excess register allocation in UPDATE, when possible. This improves speed (slightly) and reduces the code footprint. (check-in: 8658574e3f user: drh tags: trunk)
18:49
Add tests to improve code coverage of the RBU module. (check-in: ecb56b75a0 user: dan tags: trunk)
17:29 Closed ticket [a340eef47b]: PRAGMA case_sensitive_like can corrupt some databases. plus 2 other changes (artifact: c318aa8541 user: drh)
17:28 Deferred ticket [a340eef47b]. (artifact: 09375ae500 user: drh)
17:27
Provide the SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA compile-time option to omit the case_sensitive_like pragma. This change, in combination with documentation changes, is the current solution to ticket [a340eef47b0cad5]. (check-in: eabe7f2d4f user: drh tags: trunk)
14:03 Ticket [9cf6c9bb51] "<" or "<=" comparison of rowid and non-numeric text value sometimes gets the wrong answer. status still Closed with 4 other changes (artifact: bbfde8a2e2 user: drh)
11:54 Ticket [9cf6c9bb51]: 3 changes (artifact: 8cbc48333c user: dan)
11:53 Closed ticket [9cf6c9bb51]. (artifact: 4ec82a65a6 user: dan)
11:52 Edit [658b84d7f4a08865|658b84d7f4]: Edit check-in comment. (artifact: 11cb7afc1b user: dan)
11:52
Fix VDBE opcodes OP_SeekLT and OP_SeekLE so that they work on intkey tables with non-numeric text values. Fix for [9cf6c9bb]. (check-in: 658b84d7f4 user: dan tags: trunk)
11:42
Fix VDBE opcodes OP_SeekLT and OP_SeekLE so that they work on intkey tables with non-numeric text values. (Closed-Leaf check-in: a870c196d7 user: dan tags: tkt-9cf6c9bb)
11:40 Ticket [9cf6c9bb51] "<" or "<=" comparison of rowid and non-numeric text value sometimes gets the wrong answer. status still Open with 6 other changes (artifact: 4622d12dc3 user: dan)
11:37 New ticket [9cf6c9bb51]. (artifact: c18df1c460 user: dan)
04:34 Edit [74eba2558a81f9e7|74eba2558a]: Edit check-in comment. (artifact: bc11414dcc user: drh)
04:33
Remove an ALWAYS() that was previously added by check-in [a0819086] but which turns out can sometimes be false. (check-in: ad8fc5d8b4 user: drh tags: trunk)
03:34
Remove a NEVER() that was added in the previous check-in [a0819086a521f] because it is in fact reachable. (check-in: 74eba2558a user: drh tags: trunk)
00:17
Earlier detections of errors in the byte-offset-to-cell-content integer at offset 5 in the header of a btree page. (check-in: a0819086a5 user: drh tags: trunk)

2 Years Ago (more context)

2018-05-08
23:20 Fixed ticket [e63a34a004]: Incorrectly formatted output for the ".fullschema" command in the CLI plus 5 other changes (artifact: cbaa390e8e user: drh)
23:17
Correctly format the STAT1 and STAT4 content in the output from the ".fullschema" command in the CLI. Fix for ticket [e63a34a0045832dc850367552]. (check-in: 0c3f128fd7 user: drh tags: trunk)
23:15 New ticket [e63a34a004] Incorrectly formatted output for the ".fullschema" command in the CLI. (artifact: b316ee8ea2 user: drh)
22:47
Experiments with routines for processing GeoJSON. (check-in: d22fbff2a3 user: drh tags: geojson)
13:32
Merge changes from trunk, especially the activation of the cell-overwrite optimization for indexes and WITHOUT ROWID tables. (check-in: a016144b0e user: drh tags: apple-osx)
13:03
Fix a harmless compiler warning in fuzzcheck. Add new OSSFuzz test cases to the test case library. (check-in: d2619746cb user: drh tags: trunk)
12:49
Fuzz test cases for UPSERT. (check-in: fd11fbd218 user: drh tags: trunk)

3 Years Ago (more context)

2017-05-08
20:15
Add some support for wal mode to the hack on this branch. (check-in: b733afc1d0 user: dan tags: server-edition)
18:29
Do not invoke codec macros when reading or writing an in-memory sub-journal. (check-in: 2c145ee6c9 user: dan tags: codecless-inmemory-subjournal)

5 Years Ago (more context)

2015-05-08
20:21
Add the fts5vocab module, for direct access to the fts5 index. (check-in: 6bf93e3b56 user: dan tags: fts5)
09:21
Improve the error message returned by FTS5 if it encounters an unknown file format. (check-in: f369caec14 user: dan tags: fts5)
01:04
Fix harmless compiler warning with MSVC. (check-in: 902d0cb8e3 user: mistachkin tags: trunk)
00:58
Remove a couple stray test breakpoint calls. (check-in: 2860cebeea user: mistachkin tags: trunk)