This Day In History For 2020-06-10
1 Year Ago (more context)
|
2019-06-10
| ||
| 23:45 | • Fixed ticket [412bba9b22]: CAST('.' AS NUMERIC) computes 0.0 rather than 0 plus 6 other changes (artifact: f3f09094f7 user: drh) | |
| 23:45 | A string consisting of a single '.' is not a floating point literal with extra text at the end. Fix for ticket [412bba9b22c677da] (check-in: 5705016229 user: drh tags: trunk) | |
| 21:58 | • Open ticket [533010b8ca]: Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" plus 3 other changes (artifact: f065e4ab82 user: mrigger) | |
| 20:46 | • New ticket [d60b3cd7cb] COLLATE expression has an affinity. (artifact: 17666839a7 user: mrigger) | |
| 19:53 | • New ticket [412bba9b22] CAST('.' AS NUMERIC) computes 0.0 rather than 0. (artifact: 27de823723 user: mrigger) | |
| 19:18 | • Closed ticket [533010b8ca]: Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" plus 6 other changes (artifact: 8f1e45446f user: dan) | |
| 19:17 | Have ALTER TABLE commands ignore the lhs of "expr IN ()" and "expr NOT IN ()" expressions, just as other queries do. Fix for [533010b8ca]. (check-in: 71643deb6b user: dan tags: trunk) | |
| 19:07 | • Fixed ticket [5e0423b058]: xAccess behaviour is not documented, changed in Windows 3.7.0 plus 3 other changes (artifact: c703cfe188 user: drh) | |
| 19:07 | Improvements to the documentation for the xAccess method of the VFS. Ticket [5e0423b058fa5adf] (check-in: 7078d77eff user: drh tags: trunk) | |
| 18:51 | • Closed ticket [31c6e64ff9]: ALTER TABLE fails if a trigger references a non-existant table. plus 6 other changes (artifact: d4a0d54d81 user: drh) | |
| 18:33 | • Fixed ticket [dd6bffbfb6]: CAST to NUMERIC no longer converts to INTEGER plus 3 other changes (artifact: b853530b61 user: drh) | |
| 18:33 | Make sure a CAST to "NUMERIC" results in an integer if the value can be losslessly expressed as an integer, as the documentation requires. Ticket [dd6bffbfb6e61db9]. (check-in: c0c90961b4 user: drh tags: trunk) | |
| 18:27 | • Ticket [dd6bffbfb6] CAST to NUMERIC no longer converts to INTEGER status still Open with 7 other changes (artifact: 7bfbf7b8b3 user: drh) | |
| 18:15 | • New ticket [533010b8ca] Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()". (artifact: 0aff6c3fc3 user: mrigger) | |
| 15:35 | • Closed ticket [fd76310a5e]: TEXT value interpreted as column name in an index with empty list in an IN expression plus 5 other changes (artifact: f453906cff user: dan) | |
| 15:35 | • Edit [567b13093956185b|567b130939]: Edit check-in comment. (artifact: fed869acf2 user: dan) | |
| 15:34 | Handle renaming a column or table when the schema contains a (meaningless) index on the constant expression ('text' IN ()) or ('text' NOT IN()). Fix for [fd76310a]. (check-in: 567b130939 user: dan tags: trunk) | |
| 13:52 | • Fixed ticket [b1d8c79314]: LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column plus 6 other changes (artifact: 974e3f5cec user: dan) | |
| 13:46 | Do not attempt the LIKE optimization on a column with numeric affinity if the rhs of the operator begins with whitespace. Fix for ticket [fd76310a5e]. (check-in: 94b58ab059 user: dan tags: trunk) | |
| 11:28 | • New ticket [b1d8c79314] LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column. (artifact: 899d46d175 user: mrigger) | |
| 00:14 | • New ticket [fd76310a5e] TEXT value interpreted as column name in an index with empty list in an IN expression. (artifact: 683171cbee user: mrigger) | |
2 Years Ago (more context)
|
2018-06-10
| ||
| 07:42 | Update Makefile.msc to include window.c in the build. (check-in: 16db73842a user: dan tags: exp-window-functions) | |
3 Years Ago (more context)
|
2017-06-10
| ||
| 17:23 | Remove sqlite3_log() and abort() calls added to this branch to debug the pointer-map problem ([fda22108]). (check-in: 79544fc285 user: dan tags: begin-concurrent) | |
4 Years Ago (more context)
|
2016-06-10
| ||
| 22:49 | Enhance "PRAGMA table_info" to that it provides information about eponymous virtual tables. (check-in: 53a1e5d513 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2015-06-10
| ||
| 23:02 | More test output refinements. (Closed-Leaf check-in: e64a568179 user: mistachkin tags: testerOutput) | |
| 22:51 | Remove possibly stray output from various tests. (check-in: f38e0be56f user: mistachkin tags: testerOutput) | |
| 22:03 | Fix minor typo in the quicktest MSVC makefile target. (check-in: 75b65f9d49 user: mistachkin tags: trunk) | |
| 20:00 | Merge enhancements from trunk. (check-in: 0e23a079bd user: drh tags: view-optimization) | |
| 18:53 | "test" targets on all makefiles use --verbose=file --output=test-out.txt. Add the new "quicktest" target to all makefiles - designed to run in under three minutes. The --quick option on releasetest.tcl now uses quicktest. (check-in: 6ddef2ad35 user: drh tags: trunk) | |
| 17:20 | Resolve FROM-clause subqueries after query planning instead of before. Greatly reduce the estimated cost of automatic indexes for VIEWs and ephemeral tables since performance problems there cannot be mitigated via a CREATE INDEX. (check-in: a1eaf1718e user: drh tags: view-optimization) | |
| 14:27 | Avoid passing constraints that are unusable due to LEFT or CROSS joins to virtual table xBestIndex() methods. (check-in: 7b446771ca user: dan tags: trunk) | |
| 10:45 | Fix the fts5 xRename() method. (check-in: 0f7fd51325 user: dan tags: fts5) | |
10 Years Ago (more context)
|
2010-06-10
| ||
| 16:25 | Adding original art for the new SQLite logo. (check-in: af353bd89e user: drh tags: trunk) | |
| 14:07 | Add the SQLITE_TESTCTRL_PGHDRSZ verb for sqlite3_test_control() used to get the size of pcache headers for testing purposes. (check-in: 5d694f04fe user: drh tags: trunk) | |
| 10:51 | Update the test VFS in test_journal.c so that it implements the xCurrentTimeInt64 method. (check-in: ec3b4a7e5d user: drh tags: trunk) | |
| 06:53 | Store the MemPage structure in memory following, instead of preceding, the page data for cached pages. This reduces the likelihood of a corrupt database page image causing SQLite to read past the end of a buffer. (check-in: 0ce42e7665 user: dan tags: trunk) | |
| 01:07 | Remove a condition that must always be true. Replace it with an assert(). (check-in: 7abcd54ec0 user: drh tags: trunk) | |