This Day In History For 2018-04-18
1 Year Ago (more context)
|
2017-04-18
| ||
| 20:10 | Have sqlite3_expert_analyze() populate the sqlite_stat1 table before running queries through the planner for the second time. (check-in: a157fcfde5 user: dan tags: schemalint) | |
| 13:50 | Use sqlite3_table_column_metadata() instead of a SELECT statement to check for the existence of a %_stat table in fts3. This leads to smaller and easier to test code. (check-in: dc2a48020a user: dan tags: trunk) | |
| 11:20 | Improved optimizations of views as the right operand of a LEFT JOIN. (check-in: 41c27bc0ff user: drh tags: trunk) | |
| 09:04 | Fix sqlite3_expert handling of triggers on views. (check-in: ff4976da66 user: dan tags: schemalint) | |
| 05:49 | Refactor the fts3ColumnMethod() function so that all branches can be covered. (check-in: e47fdb493b user: dan tags: trunk) | |
2 Years Ago (more context)
|
2016-04-18
| ||
| 21:00 | Another fix to rbu vacuum for a zipvfs case. (check-in: 29407d70e4 user: dan tags: rbu-vacuum) | |
| 18:40 | • Edit [92dc59fd5ad66f64|92dc59fd5a]: Add tag "release". (artifact: c00916fd05 user: drh) | |
| 18:40 | • Edit [92dc59fd5ad66f64|92dc59fd5a]: Change background color to "#d0c0ff". Edit check-in comment. Add tag "version-3.12.2". (artifact: f9f3851625 user: drh) | |
| 18:18 | Fix some zipvfs related problems in RBU vacuum. (check-in: d76f4aaa4c user: dan tags: rbu-vacuum) | |
| 17:30 | Version 3.12.2 (Leaf check-in: 92dc59fd5a user: drh tags: release, branch-3.12.0, version-3.12.2) | |
| 16:18 | Correctly interpret negative "PRAGMA cache_size" values when determining the cache-size used for sorting large amounts of data (i.e. the functionality in vdbesort.c). (check-in: 39dd67afa5 user: drh tags: branch-3.12.0) | |
| 16:12 | Fix a problem in the code generator for joins on virtual tables where the outer loop of the join uses the IN operator. (check-in: a2cf496896 user: drh tags: branch-3.12.0) | |
| 16:06 | Fix the sqlite3BtreeDelete() routine so that it preserves the correct key even when the row being deleted is not on a leaf page. Fix for ticket [a306e56ff68b8fa56] (check-in: 368e86c760 user: drh tags: branch-3.12.0) | |
| 15:59 | Increase the version number to 3.12.2. (check-in: 9c37e9ce07 user: drh tags: branch-3.12.0) | |
| 15:58 | • Fixed ticket [7d7525cb01]: Compatibility break on INTEGER PRIMARY KEY columns. plus 5 other changes (artifact: 7d322fddac user: drh) | |
| 15:54 | Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (check-in: ab9d279f40 user: drh tags: branch-3.12.0) | |
| 15:53 | • Edit [abf9d602eefd9de6|abf9d602ee]: Move to branch mistake. Add propagating "hidden". Mark "Closed". Edit check-in comment. (artifact: 5846442177 user: drh) | |
| 15:51 | Faulty check-in. Extraneous edits that were not logically part of the check-in. (Closed-Leaf check-in: abf9d602ee user: drh tags: mistake) | |
| 15:46 | Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (check-in: eba27d4d17 user: drh tags: trunk) | |
| 15:24 | • New ticket [7d7525cb01] Compatibility break on INTEGER PRIMARY KEY columns.. (artifact: b61cd89a7b user: drh) | |
| 13:36 | Merge recent trunk changes. (check-in: d9768de502 user: drh tags: tempfiles-25) | |
| 13:30 | sqlite3PCachePerecentDirty() should return 0 if the pcache is empty. (check-in: 85f3d80eb7 user: drh tags: tempfiles-25) | |
| 13:09 | The last parameter to pread64() and pwrite64() should be off64_t, not off_t. (check-in: 3a7d72986f user: drh tags: trunk) | |
| 09:17 | Add the -vacuum switch to the "rbu" demonstration program. (check-in: 9a0078a538 user: dan tags: rbu-vacuum) | |
3 Years Ago (more context)
|
2015-04-18
| ||
| 19:20 | The sqlite3_trace() callback does not try to expand parameters in statements that have no parameter. (check-in: 917e3c3629 user: drh tags: trunk) | |
| 17:43 | Fix an incorrect assert() statement in the CREATE INDEX code generator. (check-in: 2eed41fda0 user: drh tags: trunk) | |
| 16:25 | Ensure that if a "ROLLBACK TO" statement is used to rollback (but not close) theoutermost transaction, the xRollbackTo() method of any virtual tables involved in the transaction is invoked. (check-in: e98d481d84 user: dan tags: trunk) | |
| 04:45 | Disregard leading zeros when converting strings to 32-bit integers. (check-in: 691cc201e1 user: drh tags: trunk) | |
| 00:22 | Fix an incorrect assert() in the sqlite3_trace() logic. (check-in: eabde33997 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2014-04-18
| ||
| 22:20 | Clean up the proper-subset cost adjustment logic to make it more compact and easier to read and so that full branch test coverage is more easily obtained. (check-in: 9a5d38c79d user: drh tags: trunk) | |
| 13:57 | Add to speedtest1.c the --threads option for setting the SQLITE_CONFIG_WORKER_THREADS configuration. (check-in: 5fce40c44a user: drh tags: threads) | |
| 13:40 | Fix harmless compiler warnings. (check-in: f8f72ecb90 user: drh tags: threads) | |
| 12:38 | Merge recent trunk changes into the threads branch. (check-in: 8729aa3e3e user: drh tags: threads) | |
| 01:37 | Further improvements to the RTREE_DECODE_COORD() method, to take advantage of known processor byte orders when available. This makes the code 3% faster, according to valgrind. Also add test cases to make sure the on-disk representation is correct. (check-in: 6f3e94f4b1 user: drh tags: rtree-enhancements) | |
| 01:14 | Merge the latest changes from sessions. (check-in: d9eef5b03c user: drh tags: rtree-enhancements) | |
| 01:10 | Merge recent trunk changes into sessions. (check-in: 95e77efe07 user: drh tags: sessions) | |
| 00:49 | Add the SQLITE_RUNTIME_BYTEORDER compile-time option to force SQLite to check the processor byte-order at run-time. Add additional compile-time byte order checks for ARM, PPC, and SPARC. (check-in: 2c5363873a user: drh tags: trunk) | |
| 00:08 | Preliminary changes to support building VSIX packages for Windows Phone 8.1. (check-in: a1b2f28ba8 user: mistachkin tags: vsixWinPhone81) | |
| 00:06 | Add the SQLITE_TESTCTRL_BYTEORDER test control to interrogate SQLite's notion of the processor byte order and whether the byte order is known at compile-time or determined at run-time. (check-in: 9c6961967a user: drh tags: trunk) | |
5 Years Ago (more context)
|
2013-04-18
| ||
| 22:56 | Experiments in making loadable extensions easier to program. The shared library filename tries various operating-system specific extensions if the bare library name does not work. And the entry point is derived from the filename is the legacy entry point name "sqlite3_extension_init" is not found. (check-in: 6cfa1d73d7 user: drh tags: loadext) | |
| 20:33 | Fix an incorrect comment (a copy/paste error) in the mptester. No code changes. (check-in: e94783f36a user: drh tags: trunk) | |
| 15:11 | Add the --breakpoint and --show-sql-errors commands to mptester. (check-in: d0898fd76a user: drh tags: trunk) | |
| 03:10 | Fix a compiler warning in sqlite3_compileoption_used(). (check-in: e9f9d84b22 user: drh tags: trunk) | |
| 02:55 | • Fixed ticket [f69b96e307]: Over-aggressive optimization of ORDER BY using a virtual table with IN operator plus 5 other changes (artifact: d6b7fea672 user: drh) | |
| 02:55 | Do not suppress the ORDER BY clause on a virtual table query if an IN constraint is used. Fix for ticket [f69b96e3076e]. Testing done on TH3 using cov1/where37.test. (check-in: 61b2a7be3b user: drh tags: trunk) | |
10 Years Ago (more context)
|
2008-04-18
| ||
| 11:31 | Remove unused code from OP_IdxLt and OP_IdxGE. (CVS 5030) (check-in: df02175ec0 user: danielk1977 tags: trunk) | |
| 10:25 | Combine cases 3 and 4 in where.c, since case 4 is now a special case of case 3. (CVS 5029) (check-in: 9a97681924 user: danielk1977 tags: trunk) | |
| 09:01 | Allow OP_MoveGt and similar to use an array of registers instead of a serialized record. Modify one type of index range scan to use this. (CVS 5028) (check-in: c448f15aa5 user: danielk1977 tags: trunk) | |
15 Years Ago (more context)
|
2003-04-18
| ||
| 22:52 | fix a memory leak in btree_rb.c. (CVS 918) (check-in: 1e3d0d0947 user: drh tags: trunk) | |
| 17:45 | Fix for ticket #297 - bug in sqliteSortCompare(). (CVS 917) (check-in: 4ded1965eb user: drh tags: trunk) | |
| 02:31 | The VACUUM command is now functioning (again). Need to do more testing. (CVS 916) (check-in: 6e948d9aae user: drh tags: trunk) | |