This Day In History For 2019-09-28
1 Year Ago (more context)
|
2018-09-28
| ||
| 23:53 | Fix test cases so that they work with ICU. (check-in: d04b2013b5 user: drh tags: trunk) | |
| 21:11 | Merge latest begin-concurrent changes into this branch. (check-in: 6f3dd9809f user: dan tags: begin-concurrent-pnu) | |
| 20:58 | Merge latest trunk into this branch. (check-in: 86750c927c user: dan tags: begin-concurrent) | |
| 20:46 | Have sqlite3changegroup_output_strm() call its output function more regularly. (check-in: 8467c31aa0 user: dan tags: trunk) | |
| 18:51 | Fix a bug in the sqlite_memstat virtual table that was causing it to report the amount of memory used as zero bytes. (check-in: 8a758a8721 user: drh tags: trunk) | |
| 14:01 | Add the geopoly_regular(X,Y,R,N) function to the geopoly extension. (check-in: 4505bbae58 user: drh tags: trunk) | |
| 13:18 | Make most geopoly functions pure. (check-in: 944e167a98 user: drh tags: trunk) | |
| 00:16 | Rig geopoly to use sqlite3AtoF() if it is available, as that routine is much faster than atof(). (check-in: 470c6c07d0 user: drh tags: trunk) | |
2 Years Ago (more context)
|
2017-09-28
| ||
| 20:06 | Do not flatten subqueries that contain an ORDER BY or GROUP BY clause and can be implemented using a co-routine. (check-in: 042d655dd9 user: drh tags: prefer-coroutine-sort-subquery) | |
| 18:32 | • Edit [ff2f5a31a2ac67a2|ff2f5a31a2]: Edit check-in comment. (artifact: 54bd1ea785 user: drh) | |
| 17:29 | Remove the (undocumented) query-planner control that prevents a "SELECT ALL" subquery in FROM clause from being implemented as a co-routine. This control was added by [a29e117d7ec], where it was called a "stop-gap". (check-in: ff2f5a31a2 user: drh tags: trunk) | |
| 16:56 | Fix over-length source code lines in select.c. No logic changes. (check-in: fd3267ef92 user: drh tags: trunk) | |
| 13:47 | Fix an issue introduced by check-in [4cd2a9672c59] (2017-03-03) that could allow a negative value in the 3rd parameter to memmove() when defragmentPage() is called on a btree page with a corrupted freeblock list. The corruption is now detected early and results in an SQLITE_CORRUPT return before the memmove() is reached. (check-in: 5b9ae69312 user: drh tags: trunk) | |
| 01:58 | Add new routines to simplify dealing with collating sequences in expressions: sqlite3ExprNNCollSeq() and sqlite3ExprCollSeqMatch(). (check-in: 490e488ea9 user: drh tags: trunk) | |
| 01:09 | Indexes on expressions with a COLLATE clause are able to satisfy an ORDER BY with the same COLLATE clause. (check-in: 0413001843 user: drh tags: trunk) | |
| 00:01 | In two places, change the magic number -1 to its proper symbol XN_ROWID. (check-in: 80277d2fc9 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2016-09-28
| ||
| 20:42 | Use Knuth multiplicative hashing for the symbol table. (check-in: cc29ddd6be user: drh tags: trunk) | |
| 16:15 | Merge recent enhancements from trunk. (check-in: 0601416347 user: drh tags: apple-osx) | |
| 16:05 | Two more typo fixes in comments. (check-in: 40c0fb0af6 user: drh tags: trunk) | |
| 16:04 | Fix typos in comments. No code changes. (check-in: 5bbd071d57 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2015-09-28
| ||
| 23:45 | Avoid unnecessary cursors and seeking when running a DELETE against a WITHOUT ROWID table. (Leaf check-in: 70ec88b299 user: drh tags: delete-without-rowid-opt) | |
| 20:03 | Also allow UPDATE on virtual tables to use the onepass strategy. (check-in: 1aa27d706d user: dan tags: vtab-onepass) | |
| 17:05 | Extra information provided by .wheretrace on input flags to the query planner and on the result of sqlite3WhereOkOnePass(). (check-in: c5566bb39c user: drh tags: trunk) | |
| 15:23 | Update fts3 to use the onepass strategy for delete operations. (check-in: fffab4f70f user: dan tags: vtab-onepass) | |
| 15:20 | Changes to allow DELETE operations on virtual tables to use the onepass strategy under some circumstances. (check-in: e73f919fae user: dan tags: vtab-onepass) | |
| 15:08 | Add test cases to the ONEPASS optimization corruption problem fixed by the previous check-in. (check-in: 5c14d44705 user: drh tags: trunk) | |
| 14:40 | Fix a database corruption bug caused by the ONEPASS optimization added in check-in [8b93cc5937000535]. Bug detected (prior to release) by sqllogictest. Test cases to follow. (check-in: 9d057f5221 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2009-09-28
| ||
| 18:52 | Ignore foreign key mismatch errors while compiling DROP TABLE commands. (check-in: 5b4d46374a user: dan tags: trunk) | |
| 14:49 | Fix the DROP TABLE command so that it cannot be used to bypass foreign key constraints (if foreign key support is enabled). (check-in: 8353808c9e user: dan tags: trunk) | |
| 11:54 | Fix some foreign key constraint related problems that occur when a row refers to itself. (check-in: 9e503e2d04 user: dan tags: trunk) | |
| 05:32 | • New ticket [7d32c69b50] sqlite3LoadExtension truncates file names. (artifact: 5e9b718726 user: rogerb) | |
| 05:05 | • New ticket [0b803bff85] Return (error code) of xCurrentTime is always ignored. (artifact: c4d1bfb5d6 user: rogerb) | |
| 05:02 | • New ticket [20f9d4fbbf] sqlite3_overload_function ignores errors. (artifact: e201503146 user: rogerb) | |
| 04:58 | • New ticket [62359d6511] xGetLastError should be dumped. (artifact: 148039b239 user: rogerb) | |
| 04:49 | • New ticket [efeeb90f2a] error messages should be per-thread not global. (artifact: 0abb02116e user: rogerb) | |