This Day In History For 2019-09-03
1 Year Ago (more context)
|
2018-09-03
| ||
| 20:05 | Improve the error messages emitted by RENAME TABLE. (check-in: 6805b5900d user: dan tags: alter-table-rename-column) | |
| 17:11 | Ensure that FTS5 queries of the form "WHERE rowid BETWEEN ? AND ? AND tbl MATCH ? ORDER BY rank" do rowid filtering before sorting. (check-in: f1138a38bd user: dan tags: trunk) | |
2 Years Ago (more context)
|
2017-09-03
| ||
| 23:27 | • New ticket [b899b6042f] Segfault on correlated subquery on the RHS of an IN operator in the WHERE clause. (artifact: 95580e0c99 user: drh) | |
3 Years Ago (more context)
|
2016-09-03
| ||
| 19:52 | Fix a problem causing the affinity of sub-select row-value elements to be ignored in some contextes. (check-in: 7d9bd22c07 user: dan tags: rowvalue) | |
| 16:24 | Merge the fuzzershell enhancement from trunk. (check-in: ed20604848 user: drh tags: rowvalue) | |
| 16:23 | Build the generate_series(START,END,STEP) table-valued function into fuzzershell, to make it easier to construct compact test cases that contain actual data. (check-in: 672c21bcf0 user: drh tags: trunk) | |
| 15:31 | Consider the affinity of "b" when using an "a IN (SELECT b ...)" expression with an index on "a". Fix for [199df416]. (check-in: f5e4985541 user: dan tags: rowvalue) | |
| 15:24 | • Edit [e72186f2d68d28c2|e72186f2d6]: Edit check-in comment. (artifact: b1cf969569 user: drh) | |
| 15:24 | • Ticket [199df4168c] Different answer with and without index on IN operator with type mismatch status still Open with 6 other changes (artifact: 6a41349726 user: drh) | |
| 14:19 | • New ticket [199df4168c]. (artifact: 21640ea63e user: drh) | |
| 01:46 | Performance optimizations. (check-in: f1d06c49ba user: drh tags: rowvalue) | |
4 Years Ago (more context)
|
2015-09-03
| ||
| 20:52 | Merge performance enhancements from trunk. This branch now runs (slightly) faster than the 3.8.11.1 release, though still slightly slower than trunk. (check-in: c490bfb150 user: drh tags: begin-concurrent) | |
| 20:43 | Change the pcache module to keep track of the total number of references to all pages rather than the number of pages references, for a performance improvement and size reduction. (check-in: f00a9e1e99 user: drh tags: trunk) | |
| 19:48 | Rearrange code in fts5_expr.c so that synonym support does not slow down the common case. (check-in: 801882817f user: dan tags: fts5-incompatible) | |
| 18:57 | Merge enhancements from trunk. (check-in: 4b49fe9969 user: dan tags: fts5-incompatible) | |
| 18:20 | A simple optimization and size reduction in sqlite3PagerAcquire(). (check-in: 618d8dd4ff user: drh tags: trunk) | |
| 18:05 | Add documentation for fts5 synonym support. (check-in: 58aa1f4359 user: dan tags: fts5-incompatible) | |
| 17:54 | Change the Pager.hasBeenUsed flag into Pager.hasHeldSharedLock in order to take it off the critical path in sqlite3PagerAcquire(). (check-in: b79096be7c user: drh tags: trunk) | |
| 15:37 | Add tests to improve coverage of fts5_varint.c. (check-in: 89f24f31a8 user: dan tags: fts5-incompatible) | |
| 15:17 | Changes from ENABLE_CONCURRENT (default off) to OMIT_CONCURRENT (default on). This is not a clear-cut decision and might be changed back. (check-in: f8ae9bfd05 user: drh tags: begin-concurrent) | |
| 14:48 | Merge recent trunk enhancements. (check-in: 6a513c0585 user: drh tags: sessions) | |
| 14:39 | Merge enhancements from trunk. (check-in: 25ee3000e9 user: drh tags: cursor-hints) | |
| 14:31 | Merge enhancements from trunk. (check-in: d01658adf8 user: drh tags: apple-osx) | |
| 14:22 | Remove some more code from fts5_index.c by consolidating similar functions. (check-in: 59ae30b97b user: dan tags: fts5-incompatible) | |
| 14:18 | Merge enhancements from trunk. (check-in: 1ab10cbf27 user: drh tags: index-expr) | |
| 14:04 | Merge trunk optimizations. (check-in: 71e7299e8d user: drh tags: begin-concurrent) | |
| 13:46 | Add the sqlite3VdbeLoadString() and sqlite3VdbeMultiLoad() routines to help with code generation, especially on PRAGMAs. Rename sqlite3VdbeAddGoto() to just sqlite3VdbeGoto(). (check-in: 847387ec8e user: drh tags: trunk) | |
| 11:17 | Remove dead code from fts5_index.c. (check-in: 8a0a9b01e7 user: dan tags: fts5-incompatible) | |
| 11:00 | Fix the fts5 integrity-check so that it works with columnsize=0 tables. (check-in: 11b887b15e user: dan tags: fts5-incompatible) | |
| 10:27 | Fix a memory leak in fts5_expr.c. (check-in: 399932a181 user: dan tags: fts5-incompatible) | |
| 04:28 | Factor out and simplify code in pragma.c for pragmas that return a single row with a single column that is an integer or text value. (check-in: d7f4bdf594 user: drh tags: trunk) | |
| 03:29 | For PRAGMAs, factor out the code that sets the result set column names into a subroutine. (check-in: 0ea6e5c9fc user: drh tags: trunk) | |
5 Years Ago (more context)
|
2014-09-03
| ||
| 19:30 | Split part of "PRAGMA ota_mode" off into "PRAGMA pager_ota_mode". This allows some specialized custom VFS implementations to intercept and implement the expected pager-related effects of this pragma. (check-in: 209f672e58 user: dan tags: ota-update) | |
| 08:25 | Add a command line program that uses the extension. This serves as example code and is also useful for performance testing. (check-in: ffa1524ef2 user: dan tags: ota-update) | |
10 Years Ago (more context)
|
2009-09-03
| ||
| 20:25 | • New ticket [89f7b55854] RFE - Documentation in PDF format?. (artifact: 5e93da252f user: anonymous) | |
| 20:21 | • New ticket [df2c3ad12a] free() on unallocated memory when fts3 match phrase contains terms after "-" modifier. (artifact: 99ab3ad4fc user: anonymous) | |
| 19:43 | Fix a VDBE stack overflow issue with the UPDATE statement. (Leaf check-in: 715cecb8c7 user: drh tags: branch-3.3.6) | |
| 16:23 | Add the "unix-wfl" VFS that does whole-file locking in order to help NFS do better cache coherency. (check-in: 2aeab80e5b user: drh tags: trunk) | |
| 01:26 | • Fixed ticket [2ea2425d34]: Assertion fault: Text encoding mismatch on value comparison plus 3 other changes (artifact: f0bfe8a8a5 user: drh) | |
| 01:18 | Do not reuse function parameters in subsequent expressions since the function call might have triggered a text encoding change. Fix for ticket [2ea2425d34be]. (check-in: f22e388727 user: drh tags: trunk) | |
| 00:53 | • New ticket [2ea2425d34] Assertion fault: Text encoding mismatch on value comparison. (artifact: f4234de905 user: drh) | |
15 Years Ago (more context)
|
2004-09-03
| ||
| 23:32 | Fix a comment. (CVS 1938) (check-in: af44ddeea1 user: drh tags: trunk) | |
| 18:38 | Modify btree.c so that is allocates big data structures using malloc() instead of allocating from the stack. Stack allocations cause problems for embedded systems and pthreads implementations that only allocate a limited amount of stack space. (CVS 1937) (check-in: 4595292f93 user: drh tags: trunk) | |
| 00:27 | More tests of sqlite3_step() and SQLITE_BUSY added. (CVS 1936) (check-in: 9e6645dd78 user: drh tags: trunk) | |