This Day In History For 2019-09-26
1 Year Ago (more context)
|
2018-09-26
| ||
| 18:02 | Further improvements to the ".help" command in the CLI. (check-in: edc3d18ecb user: drh tags: trunk) | |
| 16:53 | Begin revamping the ".help" command in the command-line shell so that it can accept an argument and will do a search for commands that match that argument. (check-in: 209afb8d06 user: drh tags: trunk) | |
| 16:05 | Tweak spellfix.c so that if SQLITE_SPELLFIX_5BYTE_MAPPINGS is defined at compile time the Transliteration structure has space for 5 byte (instead of 4 byte) mappings. (check-in: cbaf5b6c1b user: dan tags: trunk) | |
| 03:43 | Fix typos in the header comment for the sha1 and sha3 hash extensions in the ext/misc folder. (check-in: 4ed9d83a0b user: drh tags: trunk) | |
3 Years Ago (more context)
|
2016-09-26
| ||
| 14:39 | When flattening a query of the form "SELECT * FROM (SELECT * FROM tbl WHERE x=?) WHERE y=?", ensure that the final WHERE clause is "x=? AND y=?" instead of "y=? AND x=?". Although it is still not guaranteed, this makes the order in which WHERE clause terms are processed comport more closely to users expectations. (check-in: cf7f9e6d5a user: dan tags: trunk) | |
| 12:38 | Inline the relevent parts of sqlite3ExprAlloc() into spanExpr(), for a performance improvement. (check-in: fe89225eab user: drh tags: trunk) | |
4 Years Ago (more context)
|
2015-09-26
| ||
| 17:44 | Enable adding JSON1 by appending the json1.c source file to the amalgamation and compiling with -DSQLITE_ENABLE_JSON1 (check-in: 33404b2029 user: drh tags: trunk) | |
| 11:15 | Fix a memory leak that can occur following a syntax error in CREATE VIEW. (check-in: f4704035a6 user: drh tags: trunk) | |
| 03:31 | Fix the title of the documentation on sqlite3_value_subtype(). This is a comment change only. (check-in: b790235424 user: drh tags: trunk) | |
| 03:23 | Expand the header comment to clarify the purpose for the sqlite3MemoryBarrier() function. (check-in: b89495ae09 user: drh tags: trunk) | |
| 01:28 | Remove an assert in the windows worker-thread logic that can fail in a race condition. (check-in: d7bfb96092 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2014-09-26
| ||
| 18:30 | Add an assert() to verify the last-row-id for the database just prior to calling a SQL function. (check-in: d026f0c944 user: mistachkin tags: trunk) | |
| 10:52 | Fix a problem with concatenating patchsets containing DELETE and INSERT operations on the same row. (check-in: 4d8537eafb user: dan tags: sessions) | |
| 02:41 | Fix the "PRAGMA integrity_check" command so that it avoids formatting error message context messages until it actually needs to generate an error message. This avoids much formatting, and hence greatly improves the performance of "PRAGMA integrity_check" in the common case when there are no errors. It also makes the code a little smaller. (check-in: 8391351583 user: drh tags: trunk) | |
| 01:10 | If an SQL function makes a recursive call to do an INSERT into the same database, make sure that the last_insert_rowid() for that INSERT is recorded. (check-in: e93aecc090 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2009-09-26
| ||
| 17:51 | When ALTER TABLE RENAME TO is used to change the name of a table that is the parent table of a foreign key constraint, modify that foreign key constraint to use the new table name. (check-in: b4a10c39e7 user: dan tags: trunk) | |
| 15:14 | • Closed ticket [58a75d62e0]: encoding failure plus 3 other changes (artifact: 683a429351 user: drh) | |
| 14:40 | • Added wiki page "Bug Reports" (artifact: 8646127e8b user: drh) | |
| 14:20 | • Closed ticket [cff1a52937]: sqlite3_get_table() returns wrong result when using where clause plus 3 other changes (artifact: 0d93ca4736 user: drh) | |
| 13:57 | • Closed ticket [d77ffcd7a5]: Memory leak on failing INSERT statements on tables with UNIQUE INDEX plus 2 other changes (artifact: 10890730d0 user: drh) | |
| 12:06 | • Ticket [d77ffcd7a5]: 3 changes (artifact: 9677292406 user: anonymous) | |
| 12:05 | • Ticket [d77ffcd7a5]: 1 change (artifact: b2bffcc242 user: anonymous) | |
| 10:28 | • New ticket [cff1a52937] sqlite3_get_table() returns wrong result when using where clause. (artifact: 504f4a7388 user: anonymous) | |
| 10:16 | • Ticket [d77ffcd7a5] Memory leak on failing INSERT statements on tables with UNIQUE INDEX status still Open with 1 other change (artifact: d8074b889f user: anonymous) | |
| 09:31 | • Ticket [d77ffcd7a5]: 1 change (artifact: 1c0ad2ba4a user: anonymous) | |
| 03:42 | • Ticket [d77ffcd7a5]: 4 changes (artifact: 36a52f7b79 user: drh) | |
| 01:15 | • Ticket [d77ffcd7a5]: 3 changes (artifact: 71206fb79a user: drh) | |