This Day In History For 2018-04-17
1 Year Ago (more context)
|
2017-04-17
| ||
| 23:23 | Defer checking for null in the comparison operators, since that is an uncommon case. (check-in: 5684525613 user: drh tags: trunk) | |
| 20:50 | Do not allow a Mem object to be both NULL and some other type at the same time. (check-in: e698db1956 user: drh tags: trunk) | |
| 18:42 | Consolidate two branches of code in the "PRAGMA foreign_key_check" implementation. (check-in: 69f51f838a user: dan tags: trunk) | |
| 18:06 | • Edit [690870bd7b2e607b|690870bd7b]: Edit check-in comment. (artifact: d6d82fccf1 user: dan) | |
| 18:02 | Fix a problem in "PRAGMA foreign_key_check" in handling a WITHOUT ROWID child table with an INTEGER PRIMARY KEY parent key. Also, if an FK violation is detected in a WITHOUT ROWID child table, do not try to read and return the rowid. The second column returned by "PRAGMA foreign_key_check" in this case (WITHOUT ROWID child table) is now always set to NULL. (check-in: 690870bd7b user: dan tags: trunk) | |
| 17:03 | Add support for analyzing trigger programs to the sqlite3_expert code. (check-in: 159e8022a9 user: dan tags: schemalint) | |
| 16:07 | Further improvements to test coverage in fts3. (check-in: 352413eed4 user: dan tags: trunk) | |
| 13:38 | Improve coverage of code in fts3. (check-in: 1a08a836fa user: dan tags: trunk) | |
| 13:18 | Fix the ".column" output mode in the command-line shell so that it correctly counts and formats multi-byte UTF characters. (check-in: f508aff8d1 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2015-04-17
| ||
| 20:51 | Fix a problem affecting some fts3 UPDATE and DELETE statements on order=DESC tables. (check-in: 284c1623f8 user: dan tags: trunk) | |
| 19:41 | In the expression-tree comparison routine, do not compiler Expr.iColumn and Expr.iTable for TK_STRING expressions. (check-in: b67bb16c72 user: drh tags: trunk) | |
| 18:52 | Always resolve symbols in all ORDER BY clauses of a compound-SELECT, even illegal ORDER BY clauses. (check-in: 6c39ef73d5 user: drh tags: trunk) | |
| 18:22 | Remove unnecessary parser error count increments. Let the sqlite3ErrorMsg() take care of doing that. (check-in: 3f3b0f683a user: drh tags: trunk) | |
| 17:00 | Ensure that filenames passed to the VFS xOpen() function are terminated by 2 '\0' bytes. (check-in: 66eff473c3 user: dan tags: ota-update) | |
| 16:29 | Fix a memory leak in sqlite3ota.c that can follow an OOM error. (check-in: c3dc15e717 user: dan tags: ota-update) | |
| 16:12 | Remove an ALWAYS() that turns out to be false when there is a semantic error on a compound SELECT. (check-in: ad67a67c03 user: drh tags: trunk) | |
| 15:58 | Ensure that semantic SQL errors are always reported back up to the syntax parser. Also: Improve the defense against invalid PRAGMA synchronous settings. (check-in: 7aeade9a07 user: drh tags: trunk) | |
| 15:16 | Fix a faulty assert() in sqlite3SelectNew(). (check-in: 620d19c3b4 user: drh tags: trunk) | |
| 14:30 | Add the tool/fuzzershell.c utility program. (check-in: db8d9af4d0 user: drh tags: trunk) | |
| 12:16 | Fix the header comment on the sqldiff utility program. No code changes. (check-in: b355ca3a3f user: drh tags: trunk) | |
| 11:31 | Hold the database mutex for the duration of sqlite3session_diff(). (check-in: 6f33050115 user: dan tags: sessions) | |
| 08:36 | Have OTA always specify SQLITE_CONFIG_URI when opening databases. Fix a test issue causing otacrash.test to fail. (check-in: 0d0e5ec064 user: dan tags: ota-update) | |
4 Years Ago (more context)
|
2014-04-17
| ||
| 23:23 | Performance optimization on byte-swapping in R-Tree. (check-in: 444084fd62 user: drh tags: rtree-enhancements) | |
| 15:34 | More test cases with very long priority queues. (check-in: 71692aa97c user: drh tags: rtree-enhancements) | |
| 14:52 | Test cases and bug fixes for the sqlite3_rtree_query_callback() mechanism. (check-in: 1ccaaed6b5 user: drh tags: rtree-enhancements) | |
| 13:15 | Refactor the constraint checking logic in RTree. The new-style constraint callbacks created by sqlite3_rtree_query_callback() are now hooked up from end to end, though still untested. (check-in: 32a1387017 user: drh tags: rtree-enhancements) | |
| 08:57 | Fix build problems in vdbesort.c. Add further comments and changes to make things easier to understand. (check-in: 12b190db1d user: dan tags: threads) | |
5 Years Ago (more context)
|
2013-04-17
| ||
| 23:38 | • New ticket [f69b96e307] Over-aggressive optimization of ORDER BY using a virtual table with IN operator. (artifact: 2788bf1656 user: drh) | |
| 19:42 | Fix the --match command in mptester so that it checks the entire result, not just a prefix of the result. (check-in: 3e3ecad2b5 user: drh tags: trunk) | |
| 18:56 | In the mptester, add --glob and --notglob and --testcase. Make --exit work on the main thread. Enable the load_extension() SQL function. (check-in: c273c171f5 user: drh tags: trunk) | |
| 17:33 | In the command-line shell, allow a dot-command to occur after a multi-line c-style comment. (check-in: e2c94ab930 user: drh tags: trunk) | |
| 14:04 | Improvements to some of the comments that are used to render documentation concerning loadable extensions. No changes to code. (check-in: 76f4e31245 user: drh tags: trunk) | |
| 12:19 | Update the command-line shell to give an exit code of 0 when the ".quit" command is run from the command-line. (check-in: 467e218120 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2008-04-17
| ||
| 20:59 | Continuing progress on the journal_mode pragma. It still does not work. (CVS 5027) (check-in: 4a72a7bb9c user: drh tags: trunk) | |
| 19:14 | Additional work on ticket #3015. The previous fix (check-in (4919)) did not appear to work in all cases and it disabled indexing in some places where it should not have. New test cases added to help insure that the current fix is better. (CVS 5026) (check-in: 0d2e258e1a user: drh tags: trunk) | |
| 17:03 | Fix a typo in the documentation for sqlite3_bind_text. Ticket #3056. (CVS 5025) (check-in: 79571e2c74 user: drh tags: trunk) | |
| 17:02 | Add the journal_mode pragma. This is currently just syntax - it is not operational. (CVS 5024) (check-in: 8eaa0c7102 user: drh tags: trunk) | |
| 14:16 | In exclusive locking mode, commit by zeroing the first 28 bytes of the journal file, not by truncating the journal. Overwriting is much faster than truncating. (CVS 5023) (check-in: 8efb7f4ffb user: drh tags: trunk) | |
15 Years Ago (more context)
|
2003-04-17
| ||
| 22:57 | Fix triggers to work in an ATTACHed database. Ticket #295. (CVS 915) (check-in: 1e5e00fb73 user: drh tags: trunk) | |
| 12:44 | Make sure the min() and max() optimizations work on empty indexed tables. Ticket #296. (CVS 914) (check-in: 98ef611006 user: drh tags: trunk) | |
| 02:54 | Change the shell to use the sqliteIsNumber() routine for determining if values are numeric. Modified os.c so that it should now work with DJGPP - though I have no way of testing this. (CVS 913) (check-in: 35caefe317 user: drh tags: trunk) | |