This Day In History For 2021-02-01
1 Year Ago (more context)
|
2020-02-01
| ||
| 21:03 | On an INSERT or UPDATE, perform affinity conversions on new data prior to running CHECK constraints. Ticket [86ba67afafded936]. (check-in: 1d4f86201d user: drh tags: trunk) | |
| 17:38 | Fix the comment display for the OP_Function opcode. And at the same time, improve the comment generating logic to make use of the newer sqlite3_str_appendf() interface. (check-in: 4248980a35 user: drh tags: trunk) | |
| 14:30 | • New ticket [86ba67afaf] Incorrect affinity for CHECK constraints. (artifact: 605ae30539 user: drh) | |
| 14:29 | Fix a problem in sqlite3CodecQueryParameters() that was introduced by the query parameter encoding changes for the 3.31.1 release. (check-in: 1240ee4f6f user: drh tags: apple-osx) | |
| 14:20 | Merge the sqlite3CodecQueryParameters() fix into trunk. (check-in: a812f53369 user: drh tags: trunk) | |
| 13:30 | Fix a problem in sqlite3CodecQueryParameters() that was introduced by the query parameter encoding changes for the 3.31.1 release. (check-in: cc65ca5412 user: drh tags: branch-3.31) | |
| 00:08 | Merge version 3.31.1 (check-in: d250d085fa user: numist tags: apple-osx) | |
2 Years Ago (more context)
|
2019-02-01
| ||
| 21:08 | Slight adjustment to the printf formatter large memory allocation detector so that it does not overestimate the amount of space needed for oversize %d conversions. (check-in: 1aee70d6de user: drh tags: trunk) | |
| 20:29 | Prevent the printf formatter from doing large memory allocations - larger than either the size of the static buffer for interfaces like sqlite3_snprintf(), or larger than SQLITE_LIMIT_LENGTH for interfaces that are associated with a database connection. This helps to prevent DOS attacks on products that let hostile sources inject arbitrary SQL. It also helps fuzzers run faster and more effectively. (check-in: 179e5d4605 user: drh tags: trunk) | |
| 18:46 | Performance improvement in the parsing of options to %-formats in the printf implementation. (check-in: 40d8f8ae87 user: drh tags: trunk) | |
| 15:06 | Ensure that the Walker.pParse structure is initialized when walking the source tree to gather the WINDOW clauses on a query with window functions. (check-in: 4ca9d5d53d user: drh tags: trunk) | |
| 14:54 | New test cases added to test/fuzzdata8.db. (check-in: e5924939c9 user: drh tags: trunk) | |
| 14:50 | Improve the strict enforcement of cell sizes in balancing from check-in [12713f320b2c1def] so that it also works with table-btrees in addition to index-btrees. (check-in: ef27e7a087 user: drh tags: trunk) | |
| 14:40 | Fix an assert() in fts5 that could fail if the database is corrupt. (check-in: 55f06aa3f8 user: dan tags: trunk) | |
| 13:34 | Fix another corrupt-database-handling problem in fts5. (check-in: 9876ae1b80 user: dan tags: trunk) | |
3 Years Ago (more context)
|
2018-02-01
| ||
| 20:42 | Add a few more zipfile tests. No changes to code. (check-in: 3f62154587 user: dan tags: trunk) | |
| 19:41 | • Edit [48f1c556994d7f8f|48f1c55699]: Edit check-in comment. (artifact: 15cbb3aaa2 user: dan) | |
| 19:41 | Fix a problem triggered when a zipfile virtual table is created and written to within the same transaction. And add other zipfile tests. (check-in: 48f1c55699 user: dan tags: trunk) | |
| 16:17 | • Fixed ticket [343634942d]: Index on expression goes corrupt from valid SQL plus 6 other changes (artifact: fb5194040a user: drh) | |
| 15:57 | New assert() statements to help ensure that no other errors similar to [343634942dd54ab57b7] ever appear in the code. (check-in: 5a70af1e9c user: drh tags: trunk) | |
| 15:19 | Fix a memory leak that could follow an IO error in the zipfile extension. And add other tests. (check-in: e6bb750697 user: dan tags: trunk) | |
| 01:13 | When an index is based on a text representation of a numeric column in the original table, make sure the indexed value uses the canonical text representation of the numeric value in the table. Proposed fix for ticket [343634942dd54ab57b70]. (check-in: 88e2ce9167 user: drh tags: trunk) | |
| 00:08 | • New ticket [343634942d] Index on expression goes corrupt from valid SQL. (artifact: bc6f47b386 user: drh) | |
4 Years Ago (more context)
|
2017-02-01
| ||
| 23:06 | Fix harmless compiler warnings seen with MSVC. (check-in: 0c66cf0f0a user: mistachkin tags: trunk) | |
| 23:03 | Backout the change in [02f6293f27] as it causes MSVC to complain. (check-in: aaae74d06f user: mistachkin tags: trunk) | |
| 22:59 | Fix C99-style variable declaration issue seen with older versions of MSVC. (check-in: 54d285464a user: mistachkin tags: trunk) | |
| 22:43 | Fix harmless compiler warnings seen with MSVC. (Closed-Leaf check-in: 997f765bc6 user: mistachkin tags: msvcWarn) | |
| 22:32 | Add an option to the MSVC makefile to enable treating warnings as errors. (check-in: 6a378c29b4 user: mistachkin tags: trunk) | |
| 17:08 | Unwind the RTREE dimension loop inside of rtreeCallbackConstraint(). (check-in: 4854ea9c18 user: drh tags: trunk) | |
| 16:41 | Completely unroll the dimension loop inside of cellArea() in RTREE. (check-in: 3c4c0126c2 user: drh tags: trunk) | |
| 15:49 | Precompute the nDim2 value in the Rtree object and use that to make loops over coordinates faster. (check-in: f1f3c8cc73 user: drh tags: trunk) | |
| 15:24 | Use compiler intrinsic functions (when available) for byteswapping in RTREE. (check-in: 82fcd54a59 user: drh tags: trunk) | |
| 15:19 | Fix the build by making the OPFLAG_ISNOOP macro available unconditionally. (check-in: 510933cb24 user: drh tags: trunk) | |
| 14:19 | Update the documentation comment in sqlite.h.in for sqlite3_preupdate_hook(). (check-in: 7f8570208c user: dan tags: trunk) | |
| 14:10 | Changes so that the pre-update hook and the sessions module work with WITHOUT ROWID tables. (check-in: 964bdc27f8 user: dan tags: trunk) | |
| 02:25 | More RTREE performance optimizations related to decoding values. (check-in: c5395e7496 user: drh tags: trunk) | |
| 01:34 | Improved comments on the statGet() implementation in ANALYZE. No changes to code. (check-in: 9663eea2a1 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2016-02-01
| ||
| 21:48 | Change the OP_SetCookie instruction to write the literal P3 value, not the value in register P3. (check-in: 6d7d4703eb user: drh tags: trunk) | |
| 20:12 | Improve performance of fts5 queries. (check-in: 2334e88244 user: dan tags: trunk) | |
| 17:20 | Number VDBE opcodes starting with 0 instead of 1, as this obviates the lower-bound test on "switch(opcode){...}", making the code smaller and faster. (check-in: 4c9222f75b user: drh tags: trunk) | |
| 16:36 | Update walcrash.test to ensure that, during a particular test, enough data is written to cause SQLite to sync the wal file 14 times. (check-in: 5d7c092869 user: dan tags: trunk) | |
| 13:58 | Fix a problem causing the OR/covering-index optimization to be disabled if compile time parameter SQLITE_MAX_ATTACHED were set to greater than 30. (check-in: a17712bf8d user: dan tags: trunk) | |
| 13:21 | Minor simplification to the OP_AutoCommit opcode. Fix some code comments related to transaction control. (check-in: a9b6a0672f user: drh tags: trunk) | |
| 00:21 | Fix an assert() that might fail on a corrupt database. (check-in: 22eaced727 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2011-02-01
| ||
| 18:59 | Remove extra instances of the text "checked out." from sqlite.h.in. Also add new file fts3_aux.c to mksqlite3c.tcl. (check-in: 9897da22c5 user: dan tags: fts4aux) | |
| 18:00 | Fix a problem causing builds with SQLITE_OMIT_WAL defined to fail. (check-in: b9b48dd8dd user: dan tags: fts4aux) | |
| 17:55 | Fix a case in fts4 where a corrupt %_stat table could lead to a crash. (check-in: 4ade96ce97 user: dan tags: fts4aux) | |
| 16:34 | Add virtual table module "fts4aux", used to inspect the full-text index of an fts4 table directly. Also add the "compress" and "uncompress" fts4 options. (check-in: b010ddcc52 user: dan tags: fts4aux) | |
| 00:05 | • Edit [ed759d5a9edb3bba|ed759d5a9e]: Add tag "version-3.7.5". (artifact: eb49600a1b user: drh) | |
| 00:05 | • Edit [ed759d5a9edb3bba|ed759d5a9e]: Change background color to "#d0c0ff". Edit check-in comment. Timestamp 2011-02-01 00:04:29. Add tag "release". (artifact: 5d54d4b2c0 user: drh) | |
| 00:04 | Version 3.7.5 (check-in: ed759d5a9e user: drh tags: trunk, release, version-3.7.5) | |
15 Years Ago (more context)
|
2006-02-01
| ||
| 14:39 | Typecast to silence (incorrect) compiler warning. (CVS 3054) (check-in: 3a04fc45cc user: drh tags: trunk) | |
| 13:50 | Always register BINARY collating sequences for UTF-16BE and UTF-16LE both. Formerly we were only registering the native byte order by default. Ticket #1654. Note: There may still be problems with collating sequence synthesis. (CVS 3053) (check-in: 3861377bd9 user: drh tags: trunk) | |
| 02:45 | In joins of the form: "A, B left C" make sure that the reordering optimization does not put table A after table C. Ticket #1652. (CVS 3052) (check-in: 248b9be93d user: drh tags: trunk) | |
| 01:55 | Added support for the -enable-thread-override-lock option on the configure script. (CVS 3051) (check-in: 82f558bd11 user: drh tags: trunk) | |