This Day In History For 2020-09-10
1 Year Ago (more context)
|
2019-09-10
| ||
| 19:46 | • Closed ticket [c4130c33]: DISTINCT malfunctions for VIEW plus 6 other changes (artifact: 419e98d5 user: drh) | |
| 19:07 | • New ticket [c4130c33]. (artifact: 183f1b7c user: mrigger) | |
| 17:51 | Enhance treeview to show SOFT-COLLATE for TK_COLLATE operators that omit the EP_Collate flag. (check-in: a9780462 user: drh tags: trunk) | |
| 15:33 | Ensure the columns of views and sub-queries maintain their implicit collation sequences when the "push-down" optimization is applied. Fix for [18458b1a]. (check-in: 36997c4a user: dan tags: trunk) | |
| 07:50 | • Ticket [18458b1a] COLLATE issue in view status still Open with 7 other changes (artifact: 7a5fee4d user: drh) | |
2 Years Ago (more context)
|
2018-09-10
| ||
| 19:34 | Fix a test script issue in fts3ao.test. (check-in: 74c381b5 user: dan tags: trunk) | |
| 19:27 | Fix a minor problem causing an incorrect cursor-hint to be generated in some cases. (check-in: d879c47d user: dan tags: trunk) | |
| 17:21 | Add the ability for loadable extensions to access the new sqlite3_create_window_function() interface. (check-in: 3def6d8e user: drh tags: trunk) | |
| 16:38 | Fix a broken assert() in fts3.c. (check-in: 564fa751 user: dan tags: trunk) | |
| 14:49 | • Fixed ticket [9936b2fa]: Infinite loop due to the ORDER BY LIMIT optimization plus 3 other changes (artifact: 7fafa41f user: drh) | |
| 14:43 | New testcase() macros on virtual table xBestIndex logic. (check-in: 3bbd9c5f user: drh tags: trunk) | |
| 12:41 | • Fixed ticket [c94369ca]: Wrong answer due to the LIKE optimization plus 3 other changes (artifact: 0606ed8e user: drh) | |
| 12:40 | Fix the LIKE optimization so that it is disabled when the LHS of the expression does not have TEXT affinity and the RHS is the pattern '/%' or the RHS begins with the escape character. Fix for ticket [c94369cae9b561b1f996d0054b]. (check-in: f191431d user: drh tags: trunk) | |
| 12:17 | Fix a problem with processing a "vtab.col IS NULL" expression within the WHERE clause of a query when "vtab" is a virtual table on the rhs of a LEFT JOIN. (check-in: 83da4d41 user: dan tags: trunk) | |
| 10:16 | • Ticket [c94369ca] Wrong answer due to the LIKE optimization status still Open with 6 other changes (artifact: 9aeb839f user: drh) | |
3 Years Ago (more context)
|
2017-09-10
| ||
| 01:06 | Simplifications to the PRAGMA integrity_check code generator. (check-in: 99b9140c user: drh tags: improved-integrity-check) | |
4 Years Ago (more context)
|
2016-09-10
| ||
| 19:51 | Changes to give a warning-free build with SQLITE_OMIT_INCRBLOB and SQLITE_OMIT_SHARED_CACHE. (check-in: 711c5917 user: drh tags: trunk) | |
| 14:43 | Add test code to delete an SQLite database and its auxiliary files. (check-in: 8a9d1281 user: dan tags: trunk) | |
5 Years Ago (more context)
|
2015-09-10
| ||
| 20:40 | Make the sqlite3_value_subtype() and sqlite3_result_subtype() interfaces available to loadable extensions. (check-in: c6fca0be user: drh tags: subtypes) | |
| 20:34 | Experimental implementation of sqlite3_result_subtype() and sqlite3_value_subtype() interfaces. (check-in: 7b5be299 user: drh tags: subtypes) | |
| 19:22 | Fix a potential NULL pointer deref in the testing logic of pcache1. NB: The -DSQLITE_TEST compile-time option is needed to hit the problem. (check-in: f5580f08 user: drh tags: trunk) | |
| 17:23 | Modify the fts5 leaf page format to permit faster seek operations. This is a file-format change. Any existing databases can be upgraded by running the fts5 'rebuild' command. (check-in: 0c0c4ae9 user: dan tags: trunk) | |
| 17:20 | Create separate "path" and "root" columns in the json_each() and json_tree() virtual tables. "Root" is the 2nd parameter and is fixed. "Path" varies as json_tree() walks the hierarchy. (check-in: 127cce3e user: drh tags: trunk) | |
| 16:39 | Increment the fts5 version value to indicate that the on-disk format has changed. (Closed-Leaf check-in: 99de5e36 user: dan tags: fts5-incompatible) | |
| 16:19 | Fix a segfault in fts5 that could occur if the database contents were corrupt. (check-in: 4931e37d user: dan tags: fts5-incompatible) | |
| 15:52 | Merge latest changes from trunk. Including fts5_expr.c fixes. (check-in: 716e7e74 user: dan tags: fts5-incompatible) | |
| 15:49 | Update description of on-disk format in fts5_index.c. (check-in: 85aac7b8 user: dan tags: fts5-incompatible) | |
| 15:24 | Make the sqlite3ext.h header file responsive to -DSQLITE_OMIT_LOAD_EXTENSION. (check-in: 47a46a9f user: drh tags: trunk) | |
| 15:22 | Disable tests for json_each() and json_tree() on builds where virtual tables are not supported (check-in: bb8ee3b1 user: drh tags: trunk) | |
| 15:20 | Fix the --help option on test/releasetest.tcl. Also fix the final error count so that it includes a count of subtest crashes. (check-in: 9ecf684d user: drh tags: trunk) | |
| 10:40 | Revert an accidentally committed makefile change. (check-in: 402704b1 user: dan tags: fts5-incompatible) | |
| 10:01 | Fix an fts5 problem that could occur if a term and the first associated rowid are on different leaf pages. (check-in: ffe2796a user: dan tags: fts5-incompatible) | |
| 05:40 | Change the array of 16-bit offsets at the end of each page to an array of varints. (check-in: fab245be user: dan tags: fts5-incompatible) | |
| 04:17 | Attempt to declare sqlite3MemoryBarrier() correctly for all possible build configurations. (check-in: da8a288f user: drh tags: trunk) | |
| 03:29 | Fix the json_tree() scan for the case when a path is supplied. Add new json1 test cases. (check-in: 6adc7de7 user: drh tags: trunk) | |
| 01:22 | No-op the sqlite3_memory_alarm() interface in a different way, that does not break legacy memory behavior. This is a re-do of check-in [5d3f5df4da9f40d5]. (check-in: 8250e2a4 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2010-09-10
| ||
| 23:16 | fixed memory leak in proxy lock file error handling (check-in: e01c5f3e user: adam tags: apple-osx) | |
| 20:23 | A further correction to the sqlite3_create_function() interface documentation. (check-in: c65583db user: drh tags: trunk) | |
| 20:19 | replaced relative lock proxy paths with absolute (check-in: 782c3351 user: adam tags: apple-osx) | |
| 19:18 | Add tests to e_select.test. (check-in: 3a051a76 user: dan tags: trunk) | |
| 16:38 | Updates to the documentation on the sqlite3_create_function() family of interfaces. (check-in: 9d277e0b user: drh tags: trunk) | |
| 13:23 | Make sure SQLite is running with MEMSTATUS enabled at the beginning of every test script. (check-in: 69995314 user: drh tags: trunk) | |
| 00:59 | replaced relative lock proxy paths with absolute (check-in: 6a88cd46 user: adam tags: apple-osx) | |
| 00:18 | Make sure SQLite is running with MEMSTATUS enabled at the beginning of every test script. (check-in: b6e9a4d8 user: drh tags: apple-osx) | |
15 Years Ago (more context)
|
2005-09-10
| ||
| 22:40 | The shell does not output the sqlite_stat1 table on .dump or .schema. The ANALYZE command now gathers statistics on tables that have only a single index because this sometimes helps when reordering tables in a join. (CVS 2686) (check-in: 26565b89 user: drh tags: trunk) | |
| 16:46 | Add the experimental EXPLAIN QUERY PLAN diagnostic capability. (CVS 2685) (check-in: 986efb7b user: drh tags: trunk) | |
| 15:35 | Avoid a memory leak and/or assertion failure when parsing a table declaration that contains a duplicate column name. Ticket #1418. (CVS 2684) (check-in: f4342774 user: drh tags: trunk) | |
| 15:28 | Use of the CROSS keyword in a join prevents table reordering. Ticket #1414. (CVS 2683) (check-in: 415b8b24 user: drh tags: trunk) | |