Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 most recent check-ins using file ext/rtree/rtree9.test version c646f12c8c
|
2024-09-18
| ||
| 18:04 | Improvements to the scope of valueFromFunction(). (Leaf check-in: b021399a6e user: drh tags: branch-3.28) | |
|
2024-06-07
| ||
| 00:20 | Allow the query planner access to the argument of LIMIT even if that argument is a bound parameter. (check-in: 148d505ca0 user: drh tags: branch-3.28) | |
|
2024-06-06
| ||
| 16:06 | Better optimize queries that use parameters in the LIMIT clause. (Closed-Leaf check-in: b44f267671 user: drh tags: branch-3.28-var-in-limit) | |
|
2024-04-02
| ||
| 18:48 | Fix typos in comments. Provided ".wheretrace" debugging output for the interstage heuristic module. Do omit automatic index loops in the interstage heuristic. (check-in: 357d9513d2 user: drh tags: branch-3.28) | |
| 18:31 | Fix table-valued functions so that they will work as the right table in a LEFT JOIN. Ticket [2ae0c599b735d59e] (check-in: 1f97086d62 user: drh tags: branch-3.28) | |
| 11:54 | Add a heuristic in between the two solver() passes of the query planner that tries to prevent a very slow query plan in cases where the output row count estimate is imprecise. (check-in: 74b247d958 user: drh tags: branch-3.28) | |
|
2023-11-29
| ||
| 16:26 | Fix a duplicate assert() caused by the second cherrypick in the previous check-in. (check-in: f10d4fc4a8 user: drh tags: branch-3.28) | |
| 16:07 | Remove Window objects from the corresponding Select.pWin list when they are deleted, as they are, for example, when the ORDER BY clause is optimized out. (check-in: f9c6e6a710 user: drh tags: branch-3.28) | |
|
2023-10-19
| ||
| 21:05 | Ensure that when an ephemeral cursor is reopened with a second invocation of to OP_OpenEphemeral, the sequence counter is reset and the cache marked as stale. Fix for [9cdc5c46]. (check-in: d4bfa8d21a user: drh tags: branch-3.28) | |
|
2023-09-15
| ||
| 20:04 | Drop support for the view-scan optimization as it was causing multiple performance regressions. In its place, reduce the estimated row count for DISTINCT subsqueries by a factor of 8. (check-in: 796a65fa61 user: drh tags: branch-3.28) | |
|
2023-02-26
| ||
| 11:52 | In the omit-unused-subquery-columns optimization, be sure to remove the EP_Skip and EP_Unlikely flags from the result set expressions that get nulled-out. dbsqlfuzz bf1d3ed6e0e0dd8766027797d43db40c776d2b15. Also fix an incorrect ".selecttrace" code block. (check-in: 83a7f13edb user: drh tags: branch-3.28) | |
|
2023-02-16
| ||
| 21:01 | Fix an #ifdef that uses a different macro name from the main branch. (check-in: ad6ac5d3e8 user: drh tags: branch-3.28) | |
| 19:04 | Back-port omit-unused-subquery-column enhancements into the 3.28 branch. (check-in: 57a4e91f43 user: drh tags: branch-3.28) | |
| 14:29 | Do not compute result columns of subqueries that are never used. Make those columns NULL instead. This optimization potentially resolves the enhancement request described by [ticket baa5bb76c35a124c]. (check-in: 0163b697dd user: drh tags: branch-3.28) | |
| 01:29 | Do not compute unused result columns of subqueries. This optimization will potentially resolve the performance optimization request of [ticket baa5bb76c35a124c]. (Closed-Leaf check-in: 0c21b6a5f8 user: drh tags: branch-3.26) | |
| 01:21 | Update test cases so that they work with TCL 8.7 and later. (check-in: e9b762de0e user: drh tags: branch-3.26) | |
|
2023-02-15
| ||
| 13:00 | Update the configure script so that it contains the correct version number. (check-in: a7cbf30808 user: drh tags: branch-3.26) | |
|
2022-10-24
| ||
| 13:50 | Improve the ability of the query planner to recognize covering indexes even on tables with more than 63 columns and where the index is over columns beyond the 63rd column. (check-in: 3d1992de47 user: drh tags: branch-3.28) | |
|
2022-10-19
| ||
| 11:22 | If a query uses an index where one or more of the columns of the index is an expression and if the corresponding expression is used elsewhere in the query, then strive to read the value of the expression out of the index, rather than recomputing it. This is the "Indexed Expression Optimizations". (check-in: 3da1032878 user: drh tags: branch-3.28) | |
|
2022-09-01
| ||
| 10:41 | In the query planner, add a heuristic that will reduce the cost of a full table scan for a materialized view or subquery if the full scan is the outer-most loop. This is shown to speed up some queries. (check-in: e3754cc188 user: drh tags: branch-3.28) | |
|
2022-08-10
| ||
| 17:03 | Merge the branch-3.28a fixes into branch-3.28. (check-in: ba6bf33147 user: drh tags: branch-3.28) | |
|
2022-08-09
| ||
| 20:22 | Fix a rounding error caused by scalar->logarithm->scalar conversion when using stat4 data to estimate some range scans. (check-in: 68d86f2b20 user: drh tags: branch-3.28) | |
|
2021-11-06
| ||
| 11:58 | Add the rbu_exclusive_checkpoint query parameter to RBU. (Leaf check-in: c15806a45a user: drh tags: reuse-schema-3.36) | |
|
2021-10-26
| ||
| 10:16 | Fix an RBU problem with restarting an update after the *-oal file is already larger than 4GiB. (check-in: 0e79584a2b user: drh tags: reuse-schema-3.36) | |
| 10:02 | Fix an RBU problem with restarting an update after the *-oal file is already larger than 4GiB. (Leaf check-in: e466260313 user: drh tags: branch-3.36) | |
|
2021-10-21
| ||
| 20:08 | Enable FTS5 for fuzzcheck. (check-in: 559ba38b8a user: drh tags: trunk) | |
| 19:48 | Fix the previous check-in so that it works with virtual tables that add new shadow tables the first time they are referenced. (check-in: f73b499e53 user: drh tags: trunk) | |
| 17:01 | Fix the new "table_list" pragma so that it shows the correct number of columns for views and virtual tables even when the object has not been previously used. (check-in: fb0ed8c55f user: drh tags: trunk) | |
| 14:37 | Merge all recent trunk changes into the begin-concurrent-report branch. (check-in: 0770f320b9 user: drh tags: begin-concurrent-report) | |
| 14:27 | Merge trunk enhancements into begin-concurrent-pnu branch. (check-in: 4d972744c3 user: drh tags: begin-concurrent-pnu) | |
| 14:24 | Merge trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: 1958e6faca user: drh tags: begin-concurrent-pnu-wal2) | |
| 14:13 | Merge recent trunk enhancements into begin-concurrent branch. (check-in: ae4eed0b7e user: drh tags: begin-concurrent) | |
| 14:10 | Merge recent trunk enhancements into the reuse-schema branch (check-in: cd15fc3c08 user: drh tags: reuse-schema) | |
| 14:01 | Merge recent trunk enhancements into the wal2 branch. (check-in: 7e2bc836f6 user: drh tags: wal2) | |
|
2021-10-20
| ||
| 20:22 | Fix an incorrect JSON assert() that was added 5 days ago by check-in [7b8ea2298927fd34]. (check-in: e162da3ab4 user: drh tags: trunk) | |
| 18:17 | Fix the finish_test proc in tester.tcl so that it works for Windows test builds. Fix for problem introduced yesterday by check-in [3658417bf300e004]. (check-in: f52b84e69e user: drh tags: trunk) | |
| 17:58 | Enabled the testcase() macros under SQLITE_DEBUG. (check-in: 0ae8dd132d user: drh tags: trunk) | |
| 13:48 | Fix a problem with the CARRAY extension when the SQLITE_TRANSIENT destructor is used for non-text arrays. Forum thread 48e525b266. (check-in: cac910c15f user: drh tags: trunk) | |
| 12:52 | Ensure that valid bytecode is generated for RETURNING clauses even if the schema is corrupt and PRAGMA writable_schema is set so that the schema parse returns no errors. dbsqlfuzz cb21825bdcd6fdb4b686ce4f6e2f45e781d2f220 (check-in: 699117156e user: drh tags: trunk) | |
| 11:40 | Fix a case in the fts3 offsets() function where a corrupt database record could lead to dereferencing an uninitialized pointer. (check-in: 7b7d31a615 user: dan tags: trunk) | |
|
2021-10-19
| ||
| 19:26 | Merge multi-module test logic improvements from trunk. (check-in: e00a44ac10 user: drh tags: autovacuum-pages-callback) | |
| 18:59 | Improved cleanup in finish_test so that specifying multiple test modules on the "./testfixture" command-line is more likely to work. (check-in: 3658417bf3 user: drh tags: trunk) | |
| 18:53 | Fix permutations.test so that it can be called with a test file pattern that uses square brackets. (check-in: 55b6241871 user: dan tags: trunk) | |
| 18:40 | Update test scripts to unregister the test devsim VFS after it is used. (check-in: bb0e18ae4a user: dan tags: trunk) | |
| 18:00 | Merge trunk enhancements into the autovacuum-pages-callback branch. (check-in: c26c9e5040 user: drh tags: autovacuum-pages-callback) | |
|
2021-10-17
| ||
| 10:31 | Remove an incorrect assert() added 4 days ago by check-in [9e2f06b84f994277]. Replace it with a testcase() macro. (check-in: 03dff7196b user: drh tags: trunk) | |
|
2021-10-16
| ||
| 19:50 | Fix a harmless scan-build warning in FTS5. (check-in: 0bf42bb561 user: drh tags: trunk) | |
| 18:53 | Add NEVER() macros on branches that become unreachable due to the previous check-in. (check-in: 5fa272cc03 user: drh tags: trunk) | |
| 17:09 | Have the btree layer detect when a "DELETE FROM tbl" statement is clearing a database page that is still in use (due to database corruption) and report SQLITE_CORRUPT. (check-in: a6fda39e81 user: dan tags: trunk) | |
| 13:59 | Fix an assert() in fts5 that could fail with a corrupt database. (check-in: e99979855d user: dan tags: trunk) | |
|
2021-10-15
| ||
| 23:02 | Demostrate a prototype sqlite3_autovacuum_pages() interface. (check-in: bb6f2b8b48 user: drh tags: autovacuum-pages-callback) | |
| 17:06 | Protect the WhereTerm.u union using nearby assert()s and/or branches. (check-in: 8a56de5b9c user: drh tags: trunk) | |
| 16:15 | Protect the JsonNode.u union using nearby assert()s and branches. (check-in: 7b8ea22989 user: drh tags: trunk) | |
|
2021-10-14
| ||
| 21:13 | Fix a signed integer overflow in fts5 leading to a segfault that could occur when processing corrupt records. (check-in: 69a3ff0cc1 user: dan tags: trunk) | |
| 19:28 | Protect access to the WhereLoop.u union using nearby assert()s and branches. (check-in: bdd840216c user: drh tags: trunk) | |
| 17:30 | Update requirement marks. No changes to code. (check-in: 3a6887a543 user: drh tags: trunk) | |
|
2021-10-13
| ||
| 20:29 | New tests added to test/fuzzdata8.db. (check-in: e944d71760 user: drh tags: trunk) | |
| 20:11 | Convert an assert() into a corruption detection branch in sqlite3BtreePayload(). dbsqlfuzz 848171b5d58f6e4a62257466e0e7de16696d4f02. (check-in: f038d7f90e user: drh tags: trunk) | |
| 15:09 | Attempt to clarify the sqlite3_open_v2() documentation so that people do not come away with the idea that SQLITE_OPEN_EXCLUSIVE is an allowed bit value for the 3rd argument bitmask. (check-in: 1310a126de user: drh tags: trunk) | |
| 14:45 | Back out the SQLITE_OPEN_EXCLUSIVE changes because it does not work on Windows and it does not work always on unix. (check-in: d008ad793d user: drh tags: trunk) | |
| 14:01 | Remove a NEVER() macro in ALTER TABLE due to an obscure case of a nested CTE inside an UPDATE within a trigger. dbsqlfuzz e89174cbfad2d904f06b5e24df0a22510b6a1c1e (check-in: 9e2f06b84f user: drh tags: trunk) | |
| 13:00 | The sqlite3_result_text() routine (and similar) should record OOM errors in addition to SQLITE_TOOBIG errors. dbsqlfuzz (check-in: eca4343626 user: drh tags: trunk) | |
|
2021-10-12
| ||
| 22:55 | Fix the group_concat() inverse function implementation so that it correctly handles BLOB inputs when database text encoding is UTF16. (check-in: 38a1326b4b user: drh tags: trunk) | |
| 18:05 | Fix an incorrect assert() in SQLITE_ENABLE_SORTER_REFERENCES logic - a new assert() introduced 5 days ago by [87e2f5eb436fc448]. (check-in: 7cfc839e5f user: drh tags: trunk) | |
| 11:30 | Fix a use-after-free in fts3 that could follow an optimize() in the middle of a SELECT statement when the hash table is non-empty. (check-in: 8124b2ceb7 user: dan tags: trunk) | |
| 02:26 | Fix another harmless compiler warning for MSVC. (check-in: b54c0db0fd user: mistachkin tags: trunk) | |
| 02:17 | Fix harmless compiler warnings in the debug build for MSVC. (check-in: 1ceb73f316 user: mistachkin tags: trunk) | |
|
2021-10-11
| ||
| 15:54 | Fail a schema parse if a virtual table or view has a positive integer rootpage. (check-in: 0265676040 user: drh tags: trunk) | |
| 15:21 | Use the IsOrdinaryTable() macro, not a test of tnum, to distinguish tables from views and virtual tables. (check-in: 6189b7809d user: drh tags: trunk) | |
| 09:48 | New test cases added to test/fuzzdata8.db (check-in: 2e475fecad user: drh tags: trunk) | |
| 09:39 | Fix an over-zealous assert(). (check-in: e2bb82a409 user: drh tags: trunk) | |
|
2021-10-09
| ||
| 16:00 | Detect any attempt to use an INDEXED BY clause on a CTE and report an error. (check-in: 35a9de2c97 user: drh tags: trunk) | |
|
2021-10-08
| ||
| 18:15 | Further to the previous check-in, remove the "harmless()" macro definition as it is no longer used. (check-in: b8c9a54664 user: drh tags: trunk) | |
| 18:12 | Remove a "harmless()" macro that is no longer relevant. (check-in: 87c357c601 user: drh tags: trunk) | |
| 16:39 | Add support for "PRAGMA writable_schema=RESET". (check-in: a51b305bd0 user: drh tags: trunk) | |
| 16:15 | Improved detection of database corruption. (check-in: c7fae46c8a user: drh tags: trunk) | |
| 10:25 | Minor improvements to comments in the data structure definitions. No changes to code. (check-in: e77ac4050c user: drh tags: trunk) | |
|
2021-10-07
| ||
| 23:04 | New assert() statements to protect the u1 and u2 unions of SrcList. (check-in: 9b91fbcfcc user: drh tags: trunk) | |
| 20:46 | Protect access to the Expr.y union using nearby assert()s and branches. (check-in: 87e2f5eb43 user: drh tags: trunk) | |
| 19:27 | Break the tcl release tests into smaller units to better take advantage of multi-processor systems. (check-in: 03cef1c30d user: dan tags: trunk) | |
| 17:43 | Protect all accesses to the Expr.x union using nearby assert()s and branches. (check-in: 8eaa1d4a98 user: drh tags: trunk) | |
| 14:19 | Fix an incorrect assert() on PRAGMA table_xinfo added by the previous check-in. (check-in: f85cb287c5 user: drh tags: trunk) | |
| 13:40 | Protect all accesses to the FuncDef.u and Expr.u unions using nearby assert()s or branches. (check-in: 9af863f065 user: drh tags: trunk) | |
| 12:11 | Protect every access to the Table.u union using a nearby assert() or branch. (check-in: 50e08338ae user: drh tags: trunk) | |
|
2021-10-06
| ||
| 10:36 | Fix a macro typo introduced by [5da112c02f9e8d0b] that prevented coverage tests from working. (check-in: 566e697489 user: drh tags: trunk) | |
| 10:04 | One corner case for the fix at [8b24c177061c3836] was not quite right. Caught overnight by both OSSFuzz and dbsqlfuzz and repaired here. (check-in: 79e90a8225 user: drh tags: trunk) | |
|
2021-10-05
| ||
| 22:51 | Fix a harmless typo in a comment. forum post 218c116fdf. (check-in: 8ca0c7d826 user: drh tags: trunk) | |
| 18:59 | Fix harmless compiler warnings, mostly caused by prior efforts to get static analyzers to run without warnings. (check-in: cddd3b382a user: drh tags: trunk) | |
| 18:33 | Fix more harmless static-analyzer warnings. As of this check-in, no warnings are generated by scan-build for clang-6 or clang-10. (check-in: a7835bead8 user: drh tags: trunk) | |
| 17:41 | Fixes for harmless static-analyzer warnings. This also makes the code easier for humans to understand. (check-in: 36177a62fe user: drh tags: trunk) | |
| 15:30 | Fix separate compilation of json1.c, which was apparently broken by check-in [32f33f356931242b]. (check-in: 0c7ece6792 user: drh tags: trunk) | |
| 13:00 | Small change to FTS5 to help static analyzers understand that it is not dereferencing a NULL pointer. (check-in: 0d853df1b1 user: drh tags: trunk) | |
| 12:34 | Ensure that geopoly does not invoke sqlite3_result_error_nomem() with a NULL pointer. (check-in: 2483310d15 user: drh tags: trunk) | |
| 11:11 | Simplifications to the preupdate_hook logic to make it easier to reason about, and reduce static analyzer warnings. (check-in: 91e3b98e06 user: drh tags: trunk) | |
|
2021-10-04
| ||
| 22:34 | Fix harmless static-analyzer warnings. (check-in: 32f33f3569 user: drh tags: trunk) | |
| 18:59 | Merge static-analyzer warning fixes and the new SQLITE_OMIT_AUXILIARY_SAFETY_CHECKS macro. (check-in: 5da112c02f user: drh tags: trunk) | |
| 18:57 | Some #defines somehow failed to get set correctly in the previous check-in. Fixed here. (Closed-Leaf check-in: 15bbdf9ac8 user: drh tags: fix-warnings) | |
| 18:21 | Fix harmless static analyzer warnings in sessions, rtree, fts3 and fts5. Add the -DSQLITE_OMIT_AUXILIARY_SAFETY_CHECKS compile-time option to cause ALWAYS() and NEVER() macros to be omitted from the build. (check-in: 1c67f957fc user: drh tags: fix-warnings) | |
| 16:14 | Fix harmless static analyzer warnings in auxiliary build tools, mkkeywordhash.c and lemon.c. No changes to the SQLite core. (check-in: f2f279b2cc user: drh tags: trunk) | |
| 15:08 | Fix harmless static analyzer warnings. (check-in: 1ebcde72e2 user: drh tags: trunk) | |
| 13:30 | The pragma_table_list virtual table should have only one "schema" column. (check-in: 886feffaad user: drh tags: trunk) | |
| 13:18 | Fix harmless static analyzer warnings. (check-in: 6604a08596 user: drh tags: trunk) | |
| 12:16 | Merge recent trunk changes into the begin-concurrent-report branch. (check-in: 71b102942c user: drh tags: begin-concurrent-report) | |
| 12:09 | Merge recent trunk enhancements into begin-concurrent-pnu branch. (check-in: 35ad7bc6e0 user: drh tags: begin-concurrent-pnu) | |
| 12:02 | Merge recent trunk changes into the begin-concurrent-pnu-wal2 branch. (check-in: bce02eaa0c user: drh tags: begin-concurrent-pnu-wal2) | |
| 11:54 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: 4f5ef7aa4c user: drh tags: begin-concurrent) | |
| 11:49 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: 64234c5c9a user: drh tags: reuse-schema) | |
| 11:44 | Merge recent trunk enhancements into the wal2 branch. (check-in: 127173e0ba user: drh tags: wal2) | |
| 11:10 | Fix query plans created by whereShortCut() so that they always check transitive constraints that drive an index. The is analogous to the [f1f9b5de3c59489b] check-in, just for whereShortCut() rather than the full query planner. Fix for the issue described by forum post a65cacbf5e1c41ba. (check-in: 8b24c17706 user: drh tags: trunk) | |
|
2021-10-03
| ||
| 22:03 | In CLI, ensure correct line-accumulation state whenever line(s) are dumped or processed. And test this. (check-in: be211a9c59 user: larrybr tags: trunk) | |
| 00:12 | Add the sqlite3ResultStrAccum() internal interface to simplify the the implementation of functions that return strings. (check-in: e548e9299d user: drh tags: trunk) | |
|
2021-10-02
| ||
| 18:22 | Try to fix a harmless static-analyzer warning in sqlite3BtreeTransferRow(). (check-in: 5906a0152d user: drh tags: trunk) | |
| 17:46 | Fix a harmless static-analyzer warning in sqlite3ExprCode(). (check-in: 918c22e82a user: drh tags: trunk) | |
| 17:34 | Remove an unnecessary static buffer from sqlite3VdbeExpandSql(). (check-in: 953a33b7f7 user: drh tags: trunk) | |
| 17:12 | Make the sqlite3_filename_xxxx() interfaces robust against NULL pointer arguments, even though the documentation says the behavior is undefined in that case. (check-in: dd64c60bab user: drh tags: trunk) | |
| 16:39 | Fix harmless compiler warnings (check-in: bdb9dc8a02 user: drh tags: trunk) | |
| 15:34 | Fix CLI line processing. (back to start state after meta-command executes) (check-in: 928c2a3498 user: larrybr tags: trunk) | |
|
2021-10-01
| ||
| 22:48 | Fix a problem with group_concat() when it is used as a window function with a sliding window, as described by forum thread ccf3b5673ba852cf. (check-in: f47f7f7822 user: drh tags: trunk) | |
| 21:01 | Fix harmless compiler warnings. (check-in: 94b59691ee user: drh tags: trunk) | |
| 20:39 | Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE. (check-in: 2f7c946c5f user: dan tags: trunk) | |
| 17:06 | Fix a potential write outside of array bounds in the --hexdb decoder of the CLI when given corrupt input. (check-in: c7fdd775bb user: drh tags: trunk) | |
| 15:05 | Fix a buffer overread in fts5 that could occur when processing an "ORDER BY rowid DESC" query against corrupt database records. (check-in: fe098a9334 user: dan tags: trunk) | |
| 02:45 | Remove unreachable branches in the fixed group_concat() code. (Closed-Leaf check-in: 8bd721c29e user: drh tags: group_concat-fix-legacy) | |
| 02:16 | Merge updates from trunk (check-in: 35351371c5 user: drh tags: group_concat-fix-legacy) | |
| 00:25 | Fixes to the version of "varsep" group_concat so that (1) it builds under separate compilation and (2) omits tabs in source code and (3) runs faster than trunk. This variant of the group_concat_varsep branch might be preferred over the tip because it preserves (undocumented) legacy behavior about the position of separators relative to terms. (check-in: 04399cf964 user: drh tags: group_concat-fix-legacy) | |
|
2021-09-30
| ||
| 21:42 | Adjust 3 query result expectations to reflect changed group_concat() behavior with varying separator. (Closed-Leaf check-in: 86f9c07a4f user: larrybr tags: group_concat_varsep) | |
| 18:42 | Fix a problem with view handling in SQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: 6e791a24ce user: dan tags: trunk) | |
| 17:39 | Fix rtreedoc.test so that it works with SQLITE_DEFAULT_AUTOVACUUM=1 builds. (check-in: a300adc211 user: dan tags: trunk) | |
| 17:20 | Simplify windowed group_concat() by allowing a change in undocumented behavior (fails some new tests) (check-in: 9d8e616738 user: larrybr tags: group_concat_varsep) | |
| 10:47 | Update a test case in rtreedoc.test to account for the fact that release builds generate fewer VM instructions than debug builds. (check-in: 7d16b30282 user: dan tags: trunk) | |
|
2021-09-29
| ||
| 20:17 | Add NEVER() macros on branches that are not reachable since [a0df216f7c3f8963]. (check-in: 5d771f3554 user: drh tags: trunk) | |
| 19:18 | Fix a typo in altertab3.test. (check-in: 18d38b1310 user: dan tags: trunk) | |
| 19:15 | Have the dbstat module arrange things internally so that there are 256 addressable bytes following each page buffer. This way, small buffer overreads caused by corrupt database pages do not lead to undefined behaviour. (check-in: c4c705abc6 user: dan tags: trunk) | |
| 18:33 | Fix another problem with ALTER TABLE and vector UPDATE statements within triggers. (check-in: a0df216f7c user: dan tags: trunk) | |
| 16:38 | Add new test file rtreedoc3.test. (check-in: 5460486986 user: dan tags: trunk) | |
| 16:35 | Sync w/trunk (check-in: a4c18b2f0c user: larrybr tags: group_concat_varsep) | |
| 14:14 | Add extra tests for the group_concat() fix on this branch. (check-in: 3d148615f9 user: dan tags: group_concat_varsep) | |
| 14:01 | Improved testability of changes from check-in [255b0eeed113d83b]. (check-in: bbfd083c26 user: drh tags: trunk) | |
| 13:36 | Fix an out-of-bounds read in fts5 that could occur when processing corrupt records. (check-in: 9bbc01fb23 user: dan tags: trunk) | |
| 00:32 | Get group_concat() to handle varying separator lengths when windowing (check-in: 98e0f2bf67 user: larrybr tags: group_concat_varsep) | |
|
2021-09-28
| ||
| 10:44 | Fix a potential ALTER TABLE problem with expressions like ( (<sub-select>) IN () ). (check-in: df0d7e36db user: dan tags: trunk) | |
|
2021-09-27
| ||
| 17:11 | Have the dbstat virtual table take a copy of each page buffer that it traverses instead of just a reference to the page-cache object. This avoids problems if an error causes transaction rollback while a dbstat cursor is open. dbsqlfuzz crash-417224040fee04f0f0e62b70265c518893b08769. (check-in: 6ab25f8bd5 user: dan tags: trunk) | |
| 15:44 | Fix a problem in ALTER TABLE causing table or column references in sub-selects ton the RHS of a vector SET clause in an UPDATE within a trigger (i.e. "SET (a,b) = ( (SELECT...), <expr> )"). (check-in: 255b0eeed1 user: dan tags: trunk) | |
|
2021-09-25
| ||
| 20:28 | Load recent dbsqlfuzz cases into test/fuzzdata8.db. (check-in: 7a8fcf6d2c user: drh tags: trunk) | |
| 20:19 | Fix a memory leak in rtree triggered by corrupt database records. dbsqlfuzz 397ad036a9013d7318da30ef84947d2baaaa6d6c. (check-in: 706322c2b5 user: dan tags: trunk) | |
| 18:21 | Fix a bad interaction between the pager cache and the dbstat module that could lead to a malfunction following an OOM. dbsqlfuzz 9ed3e4e3816219d3509d711636c38542bf3f40b1. (check-in: e03554a6a8 user: dan tags: trunk) | |
| 17:07 | Add const to parameters on various internal interfaces. (check-in: 70c221c5cf user: drh tags: trunk) | |
|
2021-09-24
| ||
| 19:57 | Dbsqlfuzz (a097eaad43c3c845b236126df92fb49b25449b0c) found a way to reach the assert() that was added to sqlite3_declare_vtab() by [eb94f4a8174436b1]. This check-in fixes the problem. (check-in: 857d26a68c user: drh tags: trunk) | |
| 16:14 | Add lots of new "const" on internal function parameters. There is opportunity for many more - this is a work in progress. (check-in: a3c71a673d user: drh tags: trunk) | |
| 12:59 | Ensure that sqlite_stat1 and sqlite_stat4 are ordinary tables (not views or virtual tables) before trying to load them (dbsqlfuzz bc02a0cde82dee801a8d6f653d2831680f87dca1). This prevents sqlite3_declare_vtab() from running with db->init.busy turned on. Even so, enhance sqlite3_declare_vtab() to be able to deal with db->init.busy being on, in case there are undiscovered paths to that state. Each of these two changes are independently sufficient to prevent the problem fixed by the previous check-in [c7560c1329965ab5] but there is no harm in keeping that third layer of protection in place. (check-in: eb94f4a817 user: drh tags: trunk) | |
| 02:14 | Ensure that the db->init.azInit array is initialized at all times. dbsqlfuzz 0ad6d441f9bf3dfc32626a9900bc1700495b16f9 (check-in: c7560c1329 user: drh tags: trunk) | |
|
2021-09-23
| ||
| 17:27 | Commencing dynamic extensibility transition. (a WIP, may not build) (check-in: 5ea71afe96 user: larrybr tags: cli_extension) | |
|
2021-09-22
| ||
| 14:43 | Fix harmless compiler warnings. (check-in: d678ecca02 user: drh tags: trunk) | |
| 14:26 | For shell.c.in, define CHAR_BITS to 8 on platforms that do not have that value set by default. This fixes the build on older machines. (check-in: 96610cc825 user: drh tags: trunk) | |
| 13:43 | Fix harmless compiler warnings in shell.c.in, and a compiler warning in sqlite3expert.c which is a real error, though also harmless. (check-in: 56da0e9c03 user: drh tags: trunk) | |
| 13:07 | Fix an incorrect assert() in rtree that was added recently by [f7ad73c49507c943]. Change it to testcase(). (check-in: 3aa0bf3a09 user: drh tags: trunk) | |
| 10:57 | Enhance the TCL-based test harness so that it is possible to list multiple test modules on the "testfixture" command-line and have them all run. For example: "./testfixture test/shell*.test" (check-in: 45caf9b85f user: drh tags: trunk) | |
| 10:28 | Use sqlite3_snprintf() for the ".changes" output formatting in the shell because it now uses %lld, and some older C compilers do not understand that construct. (check-in: 53dadf8067 user: drh tags: trunk) | |
|
2021-09-21
| ||
| 20:03 | Fix .expert name collision bug reported at https://sqlite.org/forum/forumpost/05e6f32984561f57?t=h (check-in: 4a3f98ad0d user: larrybr tags: trunk) | |
| 19:19 | Speed and (slightly) simplify shell's input line early processing. (check-in: a1c7f7f8e1 user: larrybr tags: trunk) | |
| 17:26 | Add the "PRAGMA table_list" command with its corresponding eponymous table-valued function: "pragma_table_list". (check-in: 2c0e7ae541 user: drh tags: trunk) | |
|
2021-09-20
| ||
| 21:42 | Accomplish fileio standalone for Win32 with less intervention. (check-in: af5dcc9c2a user: larrybr tags: trunk) | |
| 20:15 | Allow fileio extension to be a stand-alone DLL for Win32 (check-in: d1cc3105b2 user: larrybr tags: trunk) | |
|
2021-09-19
| ||
| 18:31 | Adjust shell tests for *Nix and Windows test platform anomaly (Leaf check-in: 577544c5a2 user: larrybr tags: speedy_cli) | |
|
2021-09-18
| ||
| 21:35 | Sync w/trunk, further streamline shell's resumable prescan. (check-in: 9e00f9f7c0 user: larrybr tags: speedy_cli) | |
| 16:15 | Further tests for legacy rtree geom callbacks. (check-in: 99d6bb22e8 user: dan tags: trunk) | |
|
2021-09-17
| ||
| 21:12 | Shell's .read pipe now works for Windows too. (check-in: 929bcc4098 user: larrybr tags: trunk) | |
| 20:43 | Add tests for legacy geometry callbacks to rtreedoc2.test. (check-in: 6ad00e52ed user: dan tags: trunk) | |
| 13:07 | Make the affinity() function available even if compiled without SQLITE_DEBUG. Surround the implementation of all test-only SQL functions with #ifndef SQLITE_UNTESTABLE. (check-in: b7e00ef805 user: drh tags: trunk) | |
|
2021-09-16
| ||
| 22:23 | The dbsqlfuzz fuzzer found a refutation for a recent ALWAYS() macro. (check-in: ebfc18aaa6 user: drh tags: trunk) | |
| 20:16 | Minor changes to rtree.c so that we can get full branch coverage even when it is compiled without geopoly. (check-in: f05ae9b586 user: drh tags: trunk) | |
| 19:50 | Add tests to rtreedoc.test. (check-in: b18c6ec460 user: dan tags: trunk) | |
| 17:02 | Add a single new ALWAYS() to rtree.c, with justification. (check-in: 778e4499cd user: drh tags: trunk) | |
| 16:41 | Add a tag comment in rtree.c. No changes to code. (check-in: 213410fa9c user: drh tags: trunk) | |
| 14:17 | Add a reference counter to a structure used internally by the Tcl interface so that it does not segfault if the database connection is closed from any of the various callback scripts that may be invoked. (check-in: e54a33ce56 user: dan tags: trunk) | |
| 14:07 | Mark an unreachable branch in rtree. (check-in: e6c4afd5b3 user: drh tags: trunk) | |
| 13:52 | Back out a couple of ALWAYS() macros from [4fab9089868bbb05]. Test case added to TH3. (check-in: d26963a530 user: drh tags: trunk) | |
| 13:20 | For ALTER TABLE RENAME COLUMN, do not try to filter virtual tables out of calls to sqlite_rename_column(). Let the function filter them itself. The WHERE clause can mistakenly let virtual tables through if the sqlite_schema table is corrupt. The sqlite_rename_column() function must deal with them. We might as well let it deal with them always. (check-in: 7c82b43b7c user: drh tags: trunk) | |
| 12:33 | Under SQLITE_DEBUG with PRAGMA vdbe_trace=ON, show an output line if the VDBE aborts for any reason. (check-in: 7e3d681003 user: drh tags: trunk) | |
| 07:32 | Simplify the routine that attempts to estimate the size of an rtree index by looking at the sqlite_stat1 entry for the %_rowid table. (check-in: 06c329c17c user: drh tags: trunk) | |
| 05:39 | Mark various unreachable branches in rtree.c with ALWAYS() or NEVER(). (check-in: 4fab908986 user: drh tags: trunk) | |
| 05:24 | New ALWAYS() and assert() to mark unreachable branches in rtree.c. (Closed-Leaf check-in: f7ad73c495 user: drh tags: tree-testing) | |
|
2021-09-15
| ||
| 19:53 | In rtree.c, remove an incorrect ALWAYS(). Add other ALWAYS() and NEVER(). (check-in: cbaac8878a user: drh tags: tree-testing) | |
| 19:13 | Add more ALWAYS() macros on unreachable branches in rtree.c (check-in: fbba89dac9 user: drh tags: tree-testing) | |
| 16:20 | Fix the xBestIndex method on rtree so that it correctly recognizes that rowid=? works the same as id=?. (check-in: c74c07cc86 user: drh tags: trunk) | |
| 15:56 | Add ALWAYS() macros on some unreachable branches in rtree. (check-in: 9123f680ae user: drh tags: trunk) | |
| 15:53 | Further updates to rtreedoc.test. (check-in: e66727837d user: dan tags: trunk) | |
| 14:48 | Fix non-build for a test configuration (check-in: c9a4ab0590 user: larrybr tags: trunk) | |
| 13:09 | Simplify some of the corrupt shadow-table detection logic in rtree. (check-in: 0c4f37aa47 user: drh tags: trunk) | |
| 11:15 | Squelch needless narrowing warning. (check-in: 5540e6abc1 user: larrybr tags: trunk) | |
| 10:49 | Ensure rtreedoc.test is not run for builds without the rtree extension. (check-in: 42dff22347 user: dan tags: trunk) | |
|
2021-09-14
| ||
| 20:07 | Add test cases to rtreedoc.test. (check-in: afe0ec4d58 user: dan tags: trunk) | |
| 18:57 | Update requirements marks to reflect recent documentation changes. (check-in: 08cab8921e user: drh tags: trunk) | |
| 14:16 | Add test cases to rtreedoc.test. (check-in: b62de1269f user: dan tags: trunk) | |
| 11:27 | Minor updates to rtreedoc.test. (check-in: b22c75e41d user: dan tags: trunk) | |
|
2021-09-13
| ||
| 23:11 | Shell to .read any named character source file/device (again.) (check-in: c6fe4f8d63 user: larrybr tags: trunk) | |
| 18:32 | Add test cases to rtreedoc.test. (check-in: 4ee99d3154 user: dan tags: trunk) | |
| 18:16 | Add assert() statements to refute forum post 9f4e7f58fbb66ddd. (check-in: 83a83475c5 user: drh tags: trunk) | |
| 16:36 | Add new test file rtreedoc.test. (check-in: 8c4b1482ee user: dan tags: trunk) | |
| 13:53 | Fix an incorrect comment and possible integer overflow in pager resulting from check-in [23ca23894af352ea]. Problem reported by forum post e2ea1a3f61. Also change the datatype of Pager.pageSize to i64 even though page size never exceeds 65536, in order to help prevent future problems of this kind. (check-in: f4a552ed9f user: drh tags: trunk) | |