Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around 5d4535bfb603d7c8.
|
2021-06-10
| ||
| 14:36 | Improved robustness following OOM in the constant propagation optimization. dbsqlfuzz 001a20255c0df7495c21df62a20ea5b51e22c390. (check-in: 8658a64d41 user: drh tags: trunk) | |
|
2021-06-09
| ||
| 14:45 | Set the database connection error code for an oversize argument to sqlite3_bind_blob64() or sqlite3_bind_text64(). Forum post a636276f0d451667 and 33821c8db543c. (check-in: 56ff58c0b8 user: drh tags: trunk) | |
| 13:39 | Add defensive code to better handle corrupt records in fts5. (check-in: a99c29b5ef user: dan tags: trunk) | |
|
2021-06-08
| ||
| 23:46 | Remove two assert()s in FTS5 that checks for database corruption right before actual code does the same check. dbsqlfuzz 9680db8f5338cb9b6060eb3a02d984555d4472e3. (check-in: f3f82967b2 user: drh tags: trunk) | |
| 17:56 | Try to avoid a double-free in the showdb utility program when running pgidx on a corrupt database. See forum post a60ea5a4d4 for context (check-in: e3188a8663 user: drh tags: trunk) | |
| 12:22 | Add an assert() to prevent the value of the SQLITE_VTABRISK macros from being changed in a way that would break logic. (check-in: 33babdb582 user: drh tags: trunk) | |
| 12:15 | Avoid a buffer overread in fts3 that could occur when handling corrupt data structures. (check-in: 45f459d2fa user: dan tags: trunk) | |
|
2021-06-07
| ||
| 17:36 | Fix a buffer overread that could occur in fts5 when handling corrupt records. (check-in: 078962a216 user: dan tags: trunk) | |
| 15:28 | Fix a buffer overrun in fts3 that could occur when handling corrupt records and '^' queries. (check-in: 9d0b6b0f42 user: dan tags: trunk) | |
| 14:21 | Add recent dbsqlfuzz test cases to test/fuzzdata8.db. (check-in: 162022003c user: drh tags: trunk) | |
| 13:50 | Avoid use of uninitialized memory while running defragmentPage() on a corrupt database file. dbsqlfuzz 4c45cecc0b255aaf2ea85453ccd17e814fd0b6b2 (check-in: 35e40d7575 user: drh tags: trunk) | |
| 11:50 | Fix an assert() in the OP_ParseSchema opcode that might fail on a corrupt database file when running with PRAGMA writable_schema=ON. dbsqlfuzz e7d743ca65f2767e415095f0c5a49166a0f55eea. (check-in: 10801f65af user: drh tags: trunk) | |
| 00:54 | Remove unnecessary end-of-line whitespace from the regexp.c extension. (check-in: 17e26a1f5e user: drh tags: trunk) | |
| 00:41 | Omit the unnecessary highlighting of the security implications of SQLTIE_DIRECTONLY in the sqlite3_create_function() documentation. No changes to code. (check-in: 2aa9368b63 user: drh tags: trunk) | |
|
2021-06-04
| ||
| 23:26 | A better fix for the problem addressed by [4eb80b0cc61526c1]. This fix also avoids reading uninitialized variables. (check-in: 1c71de43db user: drh tags: trunk) | |
| 21:46 | Make MSVC build examples work when taken literally, and say when they do. (check-in: b53ca8ed83 user: larrybr tags: trunk) | |
| 17:47 | Improvements to the OP_SeekScan optimization. Added the SQLITE_TESTCTRL_TUNE test-control. (check-in: 9a2ab6092d user: drh tags: trunk) | |
| 16:17 | Add the (missing) dependency of regexp.c to the shell.c rule in the makefiles. This dependency should have been added by [5d4535bfb603d7c8] but was missed. (check-in: c93be7e660 user: drh tags: trunk) | |
| 16:11 | Fix harmless compiler warnings. (check-in: 83aca2d870 user: drh tags: trunk) | |
| 15:56 | Fix more cases in the regexp extension where the 0x00 terminator at the end of the input string is being pattern matched. [forum/forumpost/9104f0d9e7|Forum post 9104f0d9e7]. (check-in: 569e00d4ac user: drh tags: trunk) | |
| 13:40 | Revamp SQLITE_TESTCTRL_TUNE to provide visibility of current turning parameter values. (Closed-Leaf check-in: 677e645e69 user: drh tags: seekscan-improvements) | |
| 13:16 | Add support for SQLITE_TESTCTRL_TUNE and the ".testctrl tune ID VALUE" command in the CLI. (check-in: f1199d58b9 user: drh tags: seekscan-improvements) | |
| 12:29 | Merge recent trunk enchancements into the seekscan-improvements branch. (check-in: d9e85fe80c user: drh tags: seekscan-improvements) | |
|
2021-06-03
| ||
| 18:56 | Fix a case where combining row-value UPDATE FROM syntax with window functions over aggregates can cause an error. dbsqlfuzz ae4516bff08d736f203f09934e2f4d31e0b3e7ce (check-in: 4a587c3492 user: dan tags: trunk) | |
| 18:51 | Fix the truncate optimization so that PRAGMA count_changes and changes() return correct values even for a WITHOUT ROWID table. Forum post 07dedbf9a1. (check-in: 820ae3b117 user: drh tags: trunk) | |
| 13:51 | Add the regexp() and regexpi() extension functions to the CLI. (check-in: 5d4535bfb6 user: drh tags: trunk) | |
| 13:44 | Fix a bug in the regexp extension in which the "." wildcard would match the 0x00 terminator at the end of the comparison string. (check-in: fa23108b29 user: drh tags: trunk) | |
| 12:31 | Fix the case-insensitive version of the regexp() function so that it does not use the prefix optimization incorrectly. Forum post 983b43ef8e. (check-in: 1a8e43cc1b user: drh tags: trunk) | |
|
2021-06-02
| ||
| 19:28 | Add an optimization control bit to disable the OP_SeekScan optimization. (check-in: f674c41e5c user: drh tags: seekscan-improvements) | |
| 18:50 | Fix an ALWAYS which can be false. (check-in: a87f8ecd6d user: drh tags: seekscan-improvements) | |
| 17:32 | Tighten assert() restrictions on the OP_SeekScan opcode. (check-in: dbc33d3ae3 user: drh tags: seekscan-improvements) | |
| 17:14 | Never use WHERE_IN_SEEKSCAN for the 2nd or subsequent IN operator. (check-in: d0b9861908 user: drh tags: seekscan-improvements) | |
| 12:44 | This is an attempt to address the OP_SeekScan performance issue identified by forum post b4fcb8a598. (check-in: d58efb3f21 user: drh tags: seekscan-improvements) | |
|
2021-06-01
| ||
| 21:07 | Fix issue in 'mkopcodeh.tcl' tool that prevented its termination in rare circumstances. (check-in: a8d921136f user: mistachkin tags: trunk) | |
| 15:37 | Fix a problem with running ALTER TABLE against schemas that contain compound SELECT statements with ORDER BY clauses containing one or more references to the second or subsequent component SELECT statements. This fixes the problem reported by forum post 31ceaa8461. (check-in: 587a304446 user: dan tags: trunk) | |
|
2021-05-29
| ||
| 23:07 | Do not confuse the ">" operator with IS NOT NULL when checking to see if a partial index is usable. Forum post d813704d7c. (check-in: 8cc23931d6 user: drh tags: trunk) | |
| 21:50 | Fix a subtle error in an assert(). dbsqlfuzz eefbd0215c0c1b4bcc32b8141b48b35f7b431300 (check-in: a5ec81eb49 user: drh tags: trunk) | |
|
2021-05-28
| ||
| 14:28 | If a subquery is used to drive an index, this change avoids making an extra copy of the result of that subquery. But, such situations are probably sufficiently unusual that the added complexity of this enhancement is not worth the performance gain. So I'm going to park this check-in on a branch. If we later find a use case to justify it, we can merge it to trunk then. This is the "further change" that was promised by the prior check-in comment. (Leaf check-in: 4488cb883e user: drh tags: copy-optimization) | |
| 12:48 | Make a deep copy of the result of a subquery in case the subquery is reused. Fix for the problem reported by forum post 28216b36ac and introduced by check-in [f30fb19ff763a7cb]. Further changes to try to optimize the new OP_Copy opcode back into either OP_SCopy or OP_Move will be attempted separately. A test case will be in TH3. (check-in: c9f0b9cb0a user: drh tags: trunk) | |
| 12:15 | Fix a potential memory leak in json_group_object() following an error. dbsqlfuzz cd32630de3ff039d97089592b63cb3616f8ec9dd (check-in: 21676731ce user: drh tags: trunk) | |
|
2021-05-27
| ||
| 16:31 | Add the merge-test.tcl script to ease verification of LTS branches. (check-in: f958ffbc61 user: drh tags: trunk) | |
| 15:24 | The SQLITE_ENABLE_SHARED_SCHEMA compile-time option is on by default in the configure-generated makefile, permitting a complete test of this branch using "./configure && make test". (check-in: e867d22622 user: drh tags: reuse-schema) | |
| 14:09 | Improved comment on the prpagateConstants() routine. No changes to executable code. (check-in: d61a875df4 user: drh tags: trunk) | |
| 10:23 | Remove a NEVER that is reachable following OOM in writable_schema=ON mode with a corrupt schema. (check-in: 4eb80b0cc6 user: drh tags: trunk) | |
|
2021-05-26
| ||
| 23:10 | Improvements to the constant-propagation optimization in order to better deal with unusual affinities. See forum post 6a06202608 for more detail. (check-in: 9be208a6d7 user: drh tags: trunk) | |
| 19:52 | Minor optimization to opcode comparison logic in the fixes to the constant-propagation optimization on this branch. (Closed-Leaf check-in: f17dec40a0 user: drh tags: constant-propagation-fix) | |
| 19:37 | Add new test file whereM.test. Containing tests for the change on this branch. (check-in: c4c76b824c user: dan tags: constant-propagation-fix) | |
| 18:51 | Avoid assuming that an expression like "x=10" in a WHERE clause implies that CASE(x AS TEXT)=='10'. (check-in: 389ec669f4 user: dan tags: constant-propagation-fix) | |
| 18:46 | Take care that the code is not generated for the same Select object more than once, as transformations that apply during the first pass might cause problems for the second pass. dbsqlfuzz 836b625cd8a41809ef80fc7ebaa6554357bcb463. (check-in: f30fb19ff7 user: drh tags: trunk) | |
| 14:32 | Update an assert() in wherecode.c that might fail following an unrelated SQL error. (check-in: 3e2c36a827 user: dan tags: trunk) | |