Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
811 check-ins using file ext/misc/zipfile.c version e35e035bc2
|
2021-05-11
| ||
| 11:33 | Merge changes from branch-3.35. Specifically, fixes for a running RBU with a cksumvfs VFS. (Leaf check-in: ca62c36b7f user: dan tags: reuse-schema-3.35) | |
| 11:25 | Fixes for cksmvfs and rbu so that they work together. (Leaf check-in: ce8b589e4c user: dan tags: branch-3.35) | |
|
2021-04-22
| ||
| 17:40 | Add the sqlite3session_object_config() API. Current used to enable/disable collecting data for sqlite3session_changeset_size(). (Closed-Leaf check-in: 4d5fd2151e user: dan tags: session-changeset-size) | |
| 12:38 | In the whereLoopXfer() routine, ensure that the destination is fully initialized even if an OOM error occurs. (check-in: c4258708c0 user: drh tags: trunk) | |
|
2021-04-21
| ||
| 23:13 | The new OP_Null opcode from check-in [8b54102a00852b72] was not coded correctly. This check-in attempts to fix that. (check-in: 02af30aab2 user: drh tags: trunk) | |
| 20:52 | Add the experimental sqlite3session_changeset_size() API. (check-in: b5564a6fd5 user: dan tags: session-changeset-size) | |
| 12:03 | Add recent dbsqlfuzz test cases to test/fuzzdata8.db. (check-in: 6fe50dcc23 user: drh tags: trunk) | |
| 11:58 | Initialize the key registers in the skip-scan optimization to NULL, in case the query is run on a corrupt database that causes the initialization of the key to be bypassed. dbsqlfuzz 62fdf2bece00d24cac8a4edf2cf562e6eeac779d (check-in: 8b54102a00 user: drh tags: trunk) | |
| 11:32 | Fix a problem allowing SQL variables to be used expressions within the second and subsequent ON CONFLICT clauses of an UPSERT within a trigger. (check-in: 2a28910a17 user: dan tags: trunk) | |
|
2021-04-20
| ||
| 22:48 | Remove a testcase() that is no longer relevant due to the previous check-in. (check-in: ca70c8ac72 user: drh tags: trunk) | |
| 20:48 | More aggressive detection of database corruption in the rebuildPage() routine. (check-in: a18c65068b user: drh tags: trunk) | |
| 13:31 | Update an assert() in btree.c that may fail with a corrupt database. (check-in: d74bf88c5a user: dan tags: trunk) | |
| 12:14 | In the sqlite3SelectDup() routine, do not do an incomplete duplication due to OOM. This in turn requires several new NEVER() and ALWAYS() macros for unreachable branches. (check-in: a61c0e6b78 user: drh tags: trunk) | |
| 00:09 | Add two ALWAYS() macros for branches no longer reachable due to the previous check-in. Later: Dbsqlfuzz quickly found ways to make both of these ALWAYS() conditionals false. (Closed-Leaf check-in: 8f339f4300 user: drh tags: mistake) | |
|
2021-04-19
| ||
| 20:36 | Improvement to check-in [d564d8882ef18b55] to detect the OOM fault even if it occurs deep down inside the duplicated expression. (check-in: 3e863cd093 user: drh tags: trunk) | |
| 19:59 | An improvement to check-in [1a341378ab24a509] that omits the new Walker.bWalkWinDefn boolean (which is not always initialized) and uses a special value for xSelectCallback2 instead. (check-in: bef2238de9 user: drh tags: trunk) | |
| 19:07 | Merge in the 3.35.5 patches. (check-in: 35d1c9a5f8 user: drh tags: reuse-schema-3.35) | |
| 18:32 | Version 3.35.5 (check-in: 1b256d97b5 user: drh tags: release, branch-3.35, version-3.35.5) | |
| 18:03 | Ensure that a WITHOUT ROWID table does not have the .iPKey field set, even if an OOM error occurs while parsing a schema in PRAGMA writable_schema=ON mode. Add extra assert() statements to triple-check that this never happens. dbsqlfuzz 803bb1f63d6f3bd6c14db568494d6e96be8f1ec9. (check-in: 41228350a6 user: drh tags: trunk) | |
| 16:45 | Remove fts5 test functions fts5_expr(), fts5_expr_tcl(), fts5_isalnum() and fts5_fold() from release builds. (check-in: c68a6c6c89 user: dan tags: trunk) | |
| 15:05 | In the query flattener, avoid invalidating an expression if an OOM occurs. This prevents problems in higher-level routines that might not check for the OOM after processing a subquery. dbsqlfuzz fb70fa8602421f87673e0670b0712ff2b5240ea0 (check-in: d564d8882e user: drh tags: trunk) | |
| 12:05 | Update the version number to 3.35.5. (check-in: d917b70a35 user: drh tags: branch-3.35) | |
|
2021-04-18
| ||
| 15:45 | Create new branch named "auth-vac" (Leaf check-in: 5a7410acce user: larrybr tags: auth-vac) | |
| 06:03 | Ensure that all records are updated by setting the OPFLAG_SAVEPOSITION flag when updating records as part of ALTER TABLE DROP COLUMN. Fix for [c88f3036a2]. (check-in: 11c368f20a user: dan tags: branch-3.35) | |
| 05:52 | Modify the drop column code to handle WITHOUT ROWID tables for which a single column appears more than once in the primary key. (check-in: cfa8912a94 user: dan tags: branch-3.35) | |
| 05:30 | Ensure that all records are updated by setting the OPFLAG_SAVEPOSITION flag when updating records as part of ALTER TABLE DROP COLUMN. Fix for [c88f3036a2]. (check-in: 354a4db5cb user: dan tags: trunk) | |
|
2021-04-17
| ||
| 20:13 | Remove a couple of NEVER() macros from the code for walking window lists. (check-in: 4ec9ef4bcd user: dan tags: trunk) | |
| 20:13 | Merge trunk bug/test fixes (check-in: 830b0b1c49 user: larrybr tags: compile_options) | |
| 20:04 | Bring in permutations mod. (check-in: 7a1316f32c user: larrybr tags: trunk) | |
| 19:59 | Do not run external_reader.test as part of permutation "journaltest", as it requires wal mode. (check-in: 9f5f16cf09 user: dan tags: trunk) | |
| 18:43 | Allow more time for perf tests when instrumented. Condition another on feature it needs. (check-in: f0dd9cf2d7 user: larrybr tags: trunk) | |
| 18:39 | Add new dbsqlfuzz cases to test/fuzzdata8.db. (check-in: d18793e589 user: drh tags: trunk) | |
| 14:42 | Fix cases where code in expr.c was failing to handle OOM failures that occurred while processing sub-select expressions. (check-in: 62efe2eee3 user: dan tags: trunk) | |
| 13:46 | Ensure that variables are not used in the WINDOW clause of a query inside of a trigger. dbsqlfuzz d9cf66100064952b66951845dfab41de1c124611 (check-in: 1a341378ab user: drh tags: trunk) | |
|
2021-04-16
| ||
| 23:53 | Merge from trunk. (check-in: 43894f0b5b user: larrybr tags: compile_options) | |
| 23:43 | Add geopoly to $::sqlite_options() and use it to pass more tests. (check-in: 23da5016b6 user: larrybr tags: trunk) | |
| 22:53 | Performance optimizations in the code generator, especially in name resolution. (check-in: ab83a99899 user: drh tags: trunk) | |
| 21:29 | Make a test conditioned on feature used. (check-in: 31afda7ac3 user: larrybr tags: trunk) | |
| 19:25 | Add new dbsqlfuzz-generated cases to test/fuzzdata8.db. (check-in: 1ac0a056a0 user: drh tags: trunk) | |
| 17:09 | Fix another undefined behaviour in fts3 that could follow an OOM error. (check-in: fac3ff857c user: dan tags: trunk) | |
| 16:55 | Avoid signed integer overflow when finding snippets in fts3 by using 64-bit integer offsets. (check-in: 4cc09a872f user: dan tags: trunk) | |
| 15:44 | Merge from trunk. (check-in: d762784a46 user: larrybr tags: compile_options) | |
| 12:33 | Remove an ALWAYS() from a branch in sqlite3ExprAddCollateToken() which can be false following an OOM. dbsqlfuzz 9e8516bf1e786c84e520ae43141b75b7399f8618. (check-in: 6af4e6d054 user: drh tags: trunk) | |
| 12:13 | Fix an assert() in whereLoopAddOr() that can be wrong if an OOM occurs in an OR constraint on a virtual table if one of the terms of the OR is an IN operator. dbsqlfuzz 5ee7350b40014f5a878c5d6e76913a2d619f5146 (check-in: 5cb40e53ed user: drh tags: trunk) | |
| 11:25 | Fix an assert() in fts3 that might fail when handing corrupt records. (check-in: d0e2d6742f user: dan tags: trunk) | |
| 11:05 | Fix the comment on the implementation of the pi() SQL function. No changes to code. (check-in: 5620bd466e user: drh tags: trunk) | |
| 10:25 | Dial back assumptions on compile option defaults to reflect actual conditionals. (check-in: cb3127725d user: larrybr tags: compile_options) | |
| 01:03 | Do not invoke sqlite3ExprAffinity() if there is a possibility that the Expr is incomplete due to a prior OOM. dbsqlfuzz b8a824706914488bd236da51118eb9174ceb870f (check-in: e8a1515b44 user: drh tags: trunk) | |
|
2021-04-15
| ||
| 23:43 | Merge from (forked) trunk. Handle compile options that differ from default by being 0. (check-in: 6eb83f83d2 user: larrybr tags: compile_options) | |
| 19:09 | Fix a bad interaction between constant propagation and transitive term handling causing patterns like "WHERE unlikely(t1.x=t1.y) AND t1.y=?" to return non-matching rows. See forum post c38462ab5e. (check-in: 2363a14ca7 user: dan tags: trunk) | |
| 13:26 | Add extra test case for OOM handling in where.c. (check-in: 7163de3dea user: dan tags: trunk) | |
| 12:56 | Make sure the WhereInfo.pExprMods list is properly cleared when existing sqlite3WhereBegin() early due to an OOM fault. dbsqlfuzz 1247a51318047aba42e7f6991dfa62577cb7a151. (check-in: 0e19af72d8 user: drh tags: trunk) | |
| 00:26 | Bring pragma compile_options up to date. And make mkctimec.tcl help do so. (check-in: 63ea3e298c user: larrybr tags: compile_options) | |
|
2021-04-14
| ||
| 15:25 | Prevent an assert() from failing if sqlite3_blob_reopen() is called on a blob-handle that has already hit an SQLITE_CORRUPT error. (check-in: b5dc7aba03 user: dan tags: trunk) | |
| 12:11 | Fix a potential crash when using json_group_array() as a window function. (check-in: 3c266690c7 user: dan tags: trunk) | |
| 11:20 | Fix an assert() in the code generator for expressions so that it is valid even after an OOM. (check-in: 427e83eb58 user: drh tags: trunk) | |
|
2021-04-13
| ||
| 18:39 | Fix a problem with handling expressions like "(col IS NULL AND <expr1>) OR col == NULL" in WHERE clauses. Reported at https://sqlite.org/forum/forumpost/1c4f2fdcc4. (check-in: e8c7bd34d0 user: drh tags: branch-3.35) | |
| 17:45 | Fix an undefined signed integer overflow in fts5. (check-in: e6f0adb00d user: dan tags: trunk) | |
| 13:48 | Do not leave a WITHOUT ROWID table without a primary key index structure due to an OOM error. This prevents downstream troubles in the case of PRAGMA writable_schema=ON. dbsqlfuzz 69fb32cc82d59b4d790881566e3f6c727e616122 (check-in: 608b6644b9 user: drh tags: trunk) | |
| 13:20 | The SQLITE_NoSchemaError flag should not apply to OOM errors while parsing the schema. (check-in: 9cc484ad1a user: drh tags: trunk) | |
| 13:01 | Earlier detection empty_result_callbacks in sqlite3InitCallbac() to avoid problems with corrupt schemas an writable_schema=ON. dbsqlfuzz ca4ca43bdb22eab9859de4979aec615af851e111. (check-in: fb305fe077 user: drh tags: trunk) | |
| 12:28 | In the rtreedepth() function, detect OOM when converting a zeroblob() on input. dbsqlfuzz ed23eda7cc3a8a054f85ea19d55c59ba2ca72744. (check-in: 69f843c8fa user: drh tags: trunk) | |
| 01:12 | Fix an error in the inversion function for json_group_array(). dbsqlfuzz 68a4b0f668b7bc27235e3f1c5cff8a2d94cfa17e. (check-in: e718a62ed1 user: drh tags: trunk) | |
|
2021-04-12
| ||
| 23:18 | Fix a faulty assert() inside sqlite3ExprDup(). (check-in: 59812e7ef7 user: drh tags: trunk) | |
| 22:39 | Fix an assert() in OP_ParseSchema so that it works even after an OOM. (check-in: 79b8835379 user: drh tags: trunk) | |
| 18:32 | Avoid taking the address of a NULL pointer following an OOM in FTS5. Doing so is harmless in actual practice, but it technically UB so we want to avoid it. (check-in: 1cfcd9dceb user: drh tags: trunk) | |
| 17:34 | Add an assert() to show that the SF_Resolved flag does not get set if errors are being suppressed. (check-in: f455c5b0bd user: drh tags: trunk) | |
| 16:59 | Fix a segfault that could occur if the ORDER BY clause of a compound SELECT contains a sub-select that uses one or more window functions. (check-in: 5ba15ebb34 user: dan tags: trunk) | |
| 12:58 | Fix the display of SrcList in the sqlite3TreeView debugging routines. (check-in: 28ecb3810b user: drh tags: trunk) | |
| 12:02 | Avoid an assert() failure when a compound scalar sub-select is, due to a "WHERE (sub-select) AND (... OR ...)" clause, coded twice by the code generator. (check-in: a4e3f13329 user: dan tags: trunk) | |
| 11:51 | Fix harmless comment typo in main.c. (check-in: 785a553e71 user: drh tags: trunk) | |
|
2021-04-11
| ||
| 00:11 | Add NEVER() to a branch that is no longer reachable due to check-in [a1d823f6879ce1ac]. (check-in: 5fda21feda user: drh tags: trunk) | |
|
2021-04-10
| ||
| 20:27 | Avoid an uninitialized-memory valgrind error by tightening up corruption detection in internal routine defragmentPage(). (check-in: 8096f7aee4 user: dan tags: trunk) | |
| 20:21 | Add NEVER() to a branch that became unreachable with check-in [58f36af2271517ab]. (check-in: e07ce46396 user: drh tags: trunk) | |
| 15:34 | Avoid invoking sqlite3Atoi64() will a null pointer following an error from ExpandBlob(). (check-in: 780412f2ca user: drh tags: trunk) | |
| 14:49 | Fix a problem with handling expressions like "(col IS NULL AND <expr1>) OR col == NULL" in WHERE clauses. Reported at https://sqlite.org/forum/forumpost/1c4f2fdcc4. (check-in: 40852ca8e2 user: dan tags: trunk) | |
| 13:37 | Refactor NameContext.nErr into nNcErr to avoid confusion with Parse.nErr. Do not abandon sqlite3ResolveExprList() on nNcErr if nErr is still zero as we might have hit a problem with ORDER BY resolution that should be a suppressed error. dbsqlfuzz 41b9dad40919d3549ca7e52d893da81a6dded4ad (check-in: 7d67497074 user: drh tags: trunk) | |
|
2021-04-09
| ||
| 22:34 | Remove a NEVER() in a corruption detection conditional in defragmentPage(). dbsqlfuzz 9c61c33802600b2b01dfb09b0386ceb4ade02a19 (check-in: c174f5d32b user: drh tags: trunk) | |
| 22:20 | Remove an ALWAYS() that is actually reachable following an OOM on an UPDATE FROM of a virtual table. dbsqlfuzz aa03237ef7c4a028c7cdaf8bbcde2b62e2bcd36e (check-in: 49eac38926 user: drh tags: trunk) | |
| 20:50 | Have the VFS in memdb.c return SQLITE_IOERR_NOMEM instead of SQLITE_NOMEM when an OOM error is encountered. This is required to get the pager module to handle such OOM errors correctly in some cases. (check-in: 09c96b4c02 user: dan tags: trunk) | |
|
2021-04-08
| ||
| 20:29 | Fix a use-after-free error that could occur when processing "SELECT aggregate(DISTINCT <expr>)..." queries. (check-in: 0e4789860b user: dan tags: trunk) | |
| 19:56 | Remove an ALWAYS() that might be false under very unusual circumstances. dbsqlfuzz 300261f469ace7ecc57ed32ea7b0de3ea9d7dbf. Test case in TH3. (check-in: 466f508973 user: drh tags: trunk) | |
| 19:39 | Handle the corruption fixed by the previous commit in a different way so as to also fix dbsqlfuzz crash 753de0a0ac5b25b18f1e4d41e650d3333cdc270c. (check-in: cb27ce2509 user: dan tags: trunk) | |
| 15:19 | Handle a special case of corruption that can present if "PRAGMA writable_schema=1" is set. Fix for dbsqlfuzz test case 6229ad63de49e3ba0630aaf0058868f36008bcca. (check-in: 58f36af227 user: dan tags: trunk) | |
| 14:15 | Harden the filter_over grammar rule against OOM faults. dbsqlfuzz e47c54502a9c36778a5ed553199d5870e2ebd9f2 (check-in: f375f541ef user: drh tags: trunk) | |
| 13:52 | Remove an incorrect assert() from sqlite3EndTable(). dbsqlfuzz 4af45bcda779592449b1985433bca90b0e683b9b. (check-in: 38a1085cbd user: drh tags: trunk) | |
| 13:41 | Fix an obscure memory leak in FTS3. dbsqlfuzz 26a51001beeff35649d2e328b05ec06f93c577a5 (check-in: be7cd9ebb1 user: drh tags: trunk) | |
|
2021-04-07
| ||
| 18:17 | Do not allow the use of rowid for views and subqueries unless compiled with -DSQLITE_ALLOW_ROWID_IN_VIEW. (check-in: a2ddb89b20 user: drh tags: trunk) | |
| 18:08 | Add the SQLITE_ALLOW_ROWID_IN_VIEW option to omitttest.tcl. (Closed-Leaf check-in: 83b8e4c281 user: drh tags: no-rowid-on-view) | |
| 17:46 | Merge latest changes into this branch. (check-in: 655c28412f user: dan tags: begin-concurrent-report) | |
| 17:32 | Merge latest trunk changes into this branch. (check-in: 1f3f7e4bf3 user: dan tags: begin-concurrent-pnu) | |
| 15:45 | Also prohibit the use of rowid from a subquery. Add the SQLITE_ALLOW_ROWID_IN_VIEW compile-time option to restore legacy behavior in case somebody actually needs it. (check-in: 14b1d56ef8 user: drh tags: no-rowid-on-view) | |
| 15:23 | Merge version 3.35.4 with this branch. (check-in: 4b4f87913a user: dan tags: reuse-schema-3.35) | |
| 15:13 | Update a broken assert() on this branch. (check-in: e69f29892e user: dan tags: reuse-schema) | |
| 13:20 | Unnecessary local variable initialization to fix a harmless compiler warning. (check-in: c22e47c77a user: drh tags: trunk) | |
| 12:59 | In FTS3, if the xBegin method fails to start a transaction due to an OOM error, then make sure that the virtual table is left in a consistent state. dbsqlfuzz 85ef48423fda4eef79a551654445d8ef3537a590. (check-in: dd55357833 user: drh tags: trunk) | |
| 12:36 | Fix an assert in the automatic-index constructor that can be false following an OOM error. dbsqlfuzz ee04d66c627ed5b5301e0ce09e24db47e0f1544e. (check-in: cc6463fe6d user: drh tags: trunk) | |
| 12:21 | Earlier detection of page 1 on the freelist (which is impossible) and reporting of that as database corruption. dbsqlfuzz 6fe6c504b320be5e3eed66896cb0db28bfb38a93. (check-in: b1bf0d9875 user: drh tags: trunk) | |
| 12:02 | Fix a possible crash that could occur when executing a drop column operation on a corrupt database schema. (check-in: c337849416 user: dan tags: trunk) | |
| 09:31 | Fix seg-fault upon appendvfs attempt to open non-existent file. (check-in: 04f6439f4d user: larrybr tags: trunk) | |
|
2021-04-06
| ||
| 23:29 | Do not apply the optimization that omits DISTINCT if all result terms are part of a UNIQUE index if the index is also a partial index. Fix for the bug reported by forum post 66954e9ece. (check-in: c2f940b028 user: drh tags: trunk) | |
| 22:56 | Detect OOM earlier in the geopoly extension. dbsqlfuzz 0986e7b020e6137fc6b96331f91d15753d18e42d. (check-in: 7237117595 user: drh tags: trunk) | |
| 21:20 | Modify the drop column code to handle WITHOUT ROWID tables for which a single column appears more than once in the primary key. (check-in: e0d2507021 user: dan tags: trunk) | |
| 19:13 | Raise an error if a query tries to access the "rowid" of a view, as views do not have rowids. (check-in: 7a73c6166b user: drh tags: no-rowid-on-view) | |
| 18:40 | Restructure a loop in window.c to avoid hitting an assert() following an OOM. dbsqlfuzz test case 6ef74a9659de87e9be3d8694ad062c448aa7ef1d. (check-in: 887c19a15b user: dan tags: trunk) | |
| 18:02 | Update an assert statement that could fail when using "PRAGMA writable_schema = 1" to access a database with a corrupt schema. (check-in: 55cad6f628 user: dan tags: trunk) | |
| 17:51 | Fix issue with failing --enable-debug --enable-fts5 build. (check-in: e7491acc0c user: dan tags: trunk) | |
| 16:55 | New test cases added to fuzzdata8.db. (check-in: 039ad662dd user: drh tags: trunk) | |
| 16:42 | Silence an msan warning triggered by a corrupt database by initializing a local variable in sqlite3Insert(). (check-in: f64deecee1 user: dan tags: trunk) | |
| 16:16 | Avoid a use-after-free that may occur when accessing a corrupt database schema with "PRAGMA writable_schema = 1" set. (check-in: a1d823f687 user: dan tags: trunk) | |
| 14:46 | Remove some test routines from release builds of fts5. (check-in: 3088bf15ca user: dan tags: trunk) | |
| 13:57 | Fix incorrect RETURNING test cases in wherelimit.test (check-in: 20d21ff9be user: dan tags: trunk) | |
| 13:56 | Earlier detection of OOM errors during window function processing. dbsqlfuzz b08676f5a0437552c95d2a5d7ef285f8c451ea35. (check-in: 8e04f52e32 user: drh tags: trunk) | |
| 13:53 | Handle "RETURNING rowid" clauses attached to INSERTs on views without causing an assert() to fail. Fixes dbsqlfuzz crash 0081f863d7b2002045ac2361879fc80dfebb98f1. (check-in: 9c5b7386d0 user: dan tags: trunk) | |
| 13:03 | Further improvements (subsequent to [d91450847a3a3a72]) to handling of attempts to delete a journal using the memdb VFS. dbsqlfuzz ac61dab357279a6a531de067f040e9a4828d2df0. (check-in: a083940642 user: drh tags: trunk) | |
| 12:50 | Earlier detection and handling of OOM problems. dbsqlfuzz 39f2963ea5559aa3a16e24e0e3cb42aac85a7371. (check-in: 8d46df7313 user: drh tags: trunk) | |
|
2021-04-05
| ||
| 22:42 | Relax an assertion on the sqlite3WhereEnd() routine after dbsqlfuzz found a counter-example. (check-in: e6b591e765 user: drh tags: trunk) | |
| 22:30 | Add a missing CORRUPT_DB to an assert in the OP_ResultRow opcode. (check-in: 82f92d79e1 user: drh tags: trunk) | |
| 19:23 | Adjust the README.md file so that build instructions work for Fossil version 2.12 and later. Forum post 51f28bb701. (check-in: 51f87adc7f user: drh tags: trunk) | |
| 19:05 | Do not allow floating point rounding errors to cause a window function xInverse() function to be invoked before the corresponding xStep() call. (check-in: 7a19fed4f2 user: dan tags: trunk) | |
| 17:50 | Fix an assert() that can be false when doing an incremental vacuum on a corrupt database file. dbsqlfuzz cced0668cfd4da4eb2382cb9dd26c17c64aaff76. (check-in: 15b801016f user: drh tags: trunk) | |
| 16:20 | Avoid coding unindexed WHERE constraints if an equivalent transitive term has already been coded by an outer loop. (check-in: 644bb77f8b user: dan tags: trunk) | |
| 13:41 | Do not invoke the xDelete method when converting to PRAGMA journal_mode=OFF if the underlying VFS does not support that method. dbsqlfuzz 39d6af88ef5242f866c4f9b21ede330c5c1e36a8. (check-in: d91450847a user: drh tags: trunk) | |
| 11:39 | As a continuation of [1f66a85b7757754f], ensure that an OOM that occurs while checking the validity of the schema is reported out as SQLITE_NOMEM and not as SQLITE_SCHEMA. (check-in: 5045c8a748 user: drh tags: trunk) | |
|
2021-04-04
| ||
| 23:56 | Fix an assert() in sqlite3BtreeLast() that needs an "|| CORRUPT_DB" term. Dbsqlfuzz case b92b72e4de80b5140c30ab71372ca719b8feb618. (check-in: ad718388a1 user: drh tags: trunk) | |
| 14:22 | Avoid compile error when SQLITE_OMIT_VIRTUALTABLE defined. (check-in: 0ee0ef476b user: larrybr tags: trunk) | |
| 12:52 | Make shell .parameter feature type-agnostic. Hush harmless compiler warning. (check-in: 35cf295e02 user: larrybr tags: trunk) | |
|
2021-04-03
| ||
| 23:30 | Improved robustness to OOM conditions in the window function logic. dbsqlfuzz 0c123f7d80b29beaafc8411c12129e46f7ffdac3. (check-in: 35ff7cbf54 user: drh tags: trunk) | |
| 20:35 | Take care not to change an SQLITE_NOMEM error into SQLITE_SCHEMA. (check-in: 1f66a85b77 user: drh tags: trunk) | |
| 19:23 | Fix a crash in handling queries of the form "SELECT aggregate(DISTINCT tbl.col) FROM ... LEFT JOIN tbl ...". Fixes a problem introduced by [ef4ac0ddd297bbd3]. (check-in: 0dcf808ddf user: dan tags: trunk) | |
|
2021-04-02
| ||
| 20:53 | Merge latest trunk changes with this branch. (check-in: a221625933 user: dan tags: begin-concurrent-report) | |
| 20:43 | Correctly capture the error when a RETURNING clause appears on an attempt to UPDATE an eponymous virtual table. dbsqlfuzz 486f791cbe2dc45839310073e71367a1d8ad22dd. (check-in: 778a9a6e6f user: drh tags: trunk) | |
| 20:40 | Merge latest trunk changes into this branch. (check-in: a7e612ee8f user: dan tags: begin-concurrent-pnu) | |
| 20:29 | Merge latest trunk changes into this branch. (check-in: 9842084230 user: dan tags: begin-concurrent) | |
| 19:55 | Add experimental SQLITE_FCNTL_EXTERNAL_READER file control. (check-in: e16da5af82 user: dan tags: trunk) | |
| 18:59 | Fix a problem with the geopoly_bbox() function. (check-in: f3a2eb979f user: drh tags: trunk) | |
| 15:20 | Version 3.35.4 (check-in: 5d4c65779d user: dan tags: release, branch-3.35, version-3.35.4) | |
| 11:59 | Fix incorrect RETURNING test cases in wherelimit.test (check-in: 64b0eb7e11 user: drh tags: branch-3.35) | |
|
2021-04-01
| ||
| 11:30 | When resolving names in the RETURNING clause, do not accept trigger names even within subquires. (check-in: 8541c71b35 user: drh tags: branch-3.35) | |
|
2021-03-31
| ||
| 23:56 | When resolving names in the RETURNING clause, do not accept trigger names even within subquires. See forum post 34c81d83c9177f46 for context. (check-in: fd4ea3f626 user: drh tags: trunk) | |
| 17:49 | When resolving column names in the RETURNING clause, do not ignore an incorrect table name qualifier. Raise an error instead. (check-in: 3b916924ce user: drh tags: branch-3.35) | |
| 17:42 | When resolving column names in the RETURNING clause, do not ignore an incorrect table name qualifier. Raise an error instead. See forum post 85aef8bc01 for context. (check-in: 51d5c50b2f user: drh tags: trunk) | |
| 13:51 | Defer deletion of expressions that are optimized out by the AND optimizer in the sqlite3ExprAnd() routine until the corresponding Parse object is deleted. This avoids a dangling pointer in AggInfo if sqlite3ExprAnd() is invoked by the push-down optimization. The dangling pointer appears to be harmless in release builds, only showing up in debug builds. Problem found by dbsqlfuzz. (check-in: 77a30f3f7a user: drh tags: branch-3.35) | |
| 13:41 | Ensure that negative numbers may not be used in frame offset clauses even if they are initially text value. e.g. (RANGE BETWEEN '-1' PRECEDING ...). (check-in: 2d179f58bf user: drh tags: branch-3.35) | |
| 13:31 | Defer deletion of expressions that are optimized out by the AND optimizer in the sqlite3ExprAnd() routine until the corresponding Parse object is deleted. This avoids a dangling pointer in AggInfo if sqlite3ExprAnd() is invoked by the push-down optimization. The dangling pointer appears to be harmless in release builds, only showing up in debug builds. Problem found by dbsqlfuzz. (check-in: c36b43589a user: drh tags: trunk) | |
| 11:31 | Ensure that negative numbers may not be used in frame offset clauses even if they are initially text value. e.g. (RANGE BETWEEN '-1' PRECEDING ...). (check-in: 8b681b274d user: dan tags: trunk) | |
|
2021-03-30
| ||
| 01:57 | Raise an error if a term of the form "TABLE.*" appears in the RETURNING clause, as SQLite does not (yet) know how to handle that. Ticket [132994c8b1063bfb]. (check-in: 257e16f7b3 user: drh tags: branch-3.35) | |
| 01:52 | Raise an error if a term of the form "TABLE.*" appears in the RETURNING clause, as SQLite does not (yet) know how to handle that. Ticket [132994c8b1063bfb]. (check-in: 3039bcaff9 user: drh tags: trunk) | |
|
2021-03-29
| ||
| 21:59 | Increase the patch number to 3.35.4. (check-in: 4375cec281 user: drh tags: branch-3.35) | |
| 21:16 | Do not do the EXISTS-to-IN transformation if the sub-select has LIMIT clause. Ticket [de7db14784a08053] (check-in: 3bf8a35716 user: dan tags: branch-3.35) | |
| 20:28 | Do not do the EXISTS-to-IN transformation if the sub-select has LIMIT clause. (check-in: d07e246f9b user: dan tags: trunk) | |
| 20:04 | Add "#ifdef SQLITE_DEBUG" blocks around test variables sqlite3_fts5_may_be_corrupt and sqlite3_fts3_may_be_corrupt. (check-in: 004559544e user: dan tags: trunk) | |
| 20:01 | Simplify the comparison opcodes in the bytecode engine, for a performance improvement. (check-in: f2af5868be user: drh tags: trunk) | |
| 19:47 | Fix VDBE coverage macros. (Closed-Leaf check-in: ebe100de55 user: drh tags: compare-opcode-opt) | |
| 18:53 | Omit the SQLITE_STOREP2 and SQLITE_KEEPNULL options from the comparison opcodes, allowing them to run faster. This required refactoring the vector comparison logic, which in turn required changing OP_ElseNotEq into OP_ElseEq. (check-in: 380b46054b user: drh tags: compare-opcode-opt) | |
| 14:40 | Add the OP_ZeroOrNull opcode and use it to compute boolean values for scalar comparisons, rather than the SQLITE_STOREP2 parameter to the comparison opcode. (check-in: 93781b6f10 user: drh tags: compare-opcode-opt) | |
| 13:47 | The comparison opcodes (ex: OP_Eq) now set the iCompare flag so that the result of comparison can be used by subsequent OP_Jump or OP_ElseNotEq opcodes. (check-in: bd00df8f07 user: drh tags: compare-opcode-opt) | |
|
2021-03-28
| ||
| 23:37 | Alternative implementation of the comparison opcode speed-up of check-in [4a8805d9a66dc888] that should pass muster with UBSAN. (check-in: afb18f6454 user: drh tags: trunk) | |
| 20:44 | Document the "%token" directive for Lemon. This directive has been in place for a while, but was previously undocumented. (check-in: 36624d3740 user: drh tags: trunk) | |
|
2021-03-27
| ||
| 20:45 | Performance improvement in the comparison opcodes by rewriting an array lookup using pointer arithmetic. This makes gcc 5.4.0 builds with -Os both faster and smaller. Though I suspect that in newer compilers with better optimizers in will probably make no difference at all in the generated machine code. Later: Even though the new code is perfectly valid, and generates correct machine code that is both smaller and faster, UBSAN complains about it in OSSFuzz. So we will take it out. So here was have an example of OSSFuzz coercing a widely used application to become bigger and slower. (Leaf check-in: 4a8805d9a6 user: drh tags: gcc-opt) | |
| 16:21 | For the sqlite3_bind_text16 TCL binding used for testing, ensure that there are at least 3 terminating zeros, so that there will always be a \u0000 character even if the original byte sequence is an odd number of bytes. (check-in: c23d092f37 user: drh tags: trunk) | |
|
2021-03-26
| ||
| 23:59 | In the sqlite3_bind_text and sqlite3_bind_text16 TCL commands of the test suite, ensure that the string is zero-terminated if the size argument is negative. (check-in: f472fd6443 user: drh tags: trunk) | |
| 14:04 | Merge up all the 3.35.3 changes into the begin-concurrent-pnu-wal2 branch. (check-in: 4d425e641d user: drh tags: begin-concurrent-pnu-wal2) | |
| 13:58 | Merge the 3.35.3 enhancements into the wal2 branch. (check-in: a1b8d9d213 user: drh tags: wal2) | |
| 13:47 | Merge patch 3.35.3 into the begin-concurrent-report branch. (check-in: 4ba9fc34c5 user: drh tags: begin-concurrent-report) | |
| 13:38 | Merge version 3.35.3 changes into the begin-concurrent-pnu branch. (check-in: 7e4c48afcc user: drh tags: begin-concurrent-pnu) | |
| 13:31 | Merge from 3.35.3 into the begin-concurrent branch. (check-in: 988da36c86 user: drh tags: begin-concurrent) | |
| 13:16 | Merge in changes for 3.35.3 (check-in: 76f19f4bcf user: drh tags: reuse-schema) | |
| 12:12 | Version 3.35.3 (check-in: 4c5e6c200a user: drh tags: release, branch-3.35, version-3.35.3) | |
|
2021-03-24
| ||
| 23:30 | Remove old testcases() macros. Also remove surplus end-of-line whitespace. (check-in: 54b41915ed user: drh tags: trunk) | |
| 19:57 | Add a comment to snapshotrevert.c warning of the undefined effects reverting to an old snapshot may have on newer readers. (Leaf check-in: 00af3bd254 user: dan tags: snapshot-revert) | |
| 19:54 | Add experimental extension "snapshotrevert". (check-in: 2d5ee3bad1 user: dan tags: snapshot-revert) | |
| 19:44 | Comment improvements to on the distinct-agg optimization. Show a line in the EQP output when using an ephemeral table to implement DISTINCT on an aggregate. (check-in: 037ca79e60 user: drh tags: trunk) | |
| 17:28 | Improvements to distinct aggregates such that they can sometimes avoid using an ephermeral table to test for duplicates if the column that is distinct is part of an index. (check-in: ef4ac0ddd2 user: drh tags: trunk) | |
| 17:04 | Fix a harmless compiler warning. (check-in: 26b005a95e user: drh tags: trunk) | |
|
2021-03-23
| ||
| 22:15 | Fix a problem with renaming a column when there is a quoted string immediately following the column name somewhere in the schema. (check-in: 4719fae626 user: dan tags: trunk) | |
| 21:02 | Add an ALWAYS() on a branch that is always taken. (check-in: 0646d2260c user: drh tags: trunk) | |
| 19:39 | Test result adjustments in test/misc7.test due to the EQP format change. (check-in: d3ade8c7fe user: drh tags: trunk) | |
| 16:34 | When doing schema updates, try to convert (incorrect) double-quoted strings into (SQL-standard) single-quoted strings. (check-in: 0770470488 user: drh tags: trunk) | |
| 15:39 | Tweaks to test/scanstatus.test to account for the new EQP format. (check-in: 2eb28afd01 user: drh tags: trunk) | |
| 15:07 | Changes to test/analyzeG.test to conform to the new EXPLAIN QUERY PLAN syntax. (check-in: d8afde1bf1 user: drh tags: trunk) | |
| 14:33 | Fix a test case in bigmmap.test so that it works with the new EXPLAIN QUERY PLAN output format. (check-in: 9ac064fe2a user: drh tags: trunk) | |
| 14:27 | Add the ExprList.nAlloc column and use it to make the sqlite3ExprListAppend() routine much faster. (check-in: 1d3c4662c2 user: drh tags: trunk) | |
| 01:06 | Enhance the EXPLAIN QUERY PLAN output to use symbolic names to describe subqueries, where possible, instead of cryptic subquery index numbers. And in other ways, make the EQP output cleaner and easier to read. Little code is changed, but many of the test results had to be tweaked to align with the new output format. (check-in: f8e28308fd user: drh tags: trunk) | |
|
2021-03-22
| ||
| 18:53 | Merge recent fixes from trunk. (Closed-Leaf check-in: 4a343698b4 user: drh tags: eqp-improvements) | |
| 16:50 | Increase the version number to 3.36.0 to begin the next development cycle. (check-in: 5cee689d64 user: drh tags: trunk) | |
| 16:47 | This branch for any further patches on 3.35. We anticipate 3.35.3 in a few days. Hopefully there will never be a need for 3.35.4. (check-in: 8de4cb984a user: drh tags: branch-3.35) | |
|
2021-03-21
| ||
| 18:23 | Fix an assert() that in preupdate-hook logic (not normally built) that can be false when running VACUUM on a corrupt database file under PRAGMA writable_schema=ON. (check-in: 6bb2134027 user: drh tags: trunk, same-as-3.35.3) | |
| 17:52 | Add a better comment and an assert() on the code inside sqlite3CreateIndex() that REPLACE indexes come at the end of the index list. forum post ceb51d83f7 (check-in: 71e4da136b user: drh tags: trunk) | |
|
2021-03-20
| ||
| 23:15 | Fix the "box" output mode in the shell when statement returns zero-column rows (for example from "PRAGMA incremental_vacuum"). (check-in: 34439fe3ae user: drh tags: trunk) | |
| 15:46 | Use the canonical name, not the AS name, when showing the MATERIALIZE or CO-ROUTINE lines for a CTE. (check-in: 1b83e232c4 user: drh tags: eqp-improvements) | |
| 15:11 | Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: 50fbd53260 user: drh tags: eqp-improvements) | |
| 01:00 | Fix a faulty assert() in the OP_SkipScan opcode. dbsqlfuzz a15a9b2ca82e812ad52f62c86cc93dca0dc72f01. Test cases in TH3. (check-in: 1805b9aaf1 user: drh tags: trunk) | |
|
2021-03-19
| ||
| 19:44 | Further simplification of the EQP output. Only show "SUBQUERY n" if the subquery is anonymous. (check-in: 1fadd30525 user: drh tags: eqp-improvements) | |
| 19:09 | Merge enhancements from trunk. (check-in: d192d73775 user: drh tags: eqp-improvements) | |
| 17:54 | In the wholenumber virtual table, increase the cost penalty for running open-loop. This appears to fix the problem reported by forum post b52a020ce4. (check-in: f12b54042e user: drh tags: trunk) | |
| 16:29 | Dbsqlfuzz found a new way to make that branch in codeVectorCompare reachable. (check-in: 959272c275 user: drh tags: trunk) | |
| 15:02 | Fix tokenizer's classification of EBCDIC newline. (check-in: 8680f6a8fb user: larrybr tags: trunk) | |
| 14:51 | Restore the NEVER() that was taken out by [f481636f1a0333c6] because that case is no longer reachable after the previous check-in. (check-in: e3a78b2a23 user: drh tags: trunk) | |
| 14:26 | Fix a crash that could occur when an INSERT has more than one ON CONFLICT clause, at least one of which contains an unresolvable symbol. (check-in: 7420838650 user: dan tags: trunk) | |
| 13:53 | Correlated CTEs should not generate a materialization subroutine. If they need to be materialized, each use case must be materialized separately. dbsqlfuzz 01b8355086998f0a452cb31208e80b9d29ca739a. (check-in: d72d865d3e user: drh tags: trunk) | |
| 13:00 | Improved labeling of EXPLAIN QUERY PLAN output. Many test failures due to the different output format. (check-in: 6f8faec022 user: drh tags: eqp-improvements) | |
|
2021-03-18
| ||
| 20:04 | Add a NEVER() on a branch that was made unreachable by the "circular reference" fix. (check-in: 114d9780ae user: drh tags: trunk) | |
| 18:27 | Disable a test case requiring generate_series when virtual tables are not available. (check-in: ee86e2f4c5 user: drh tags: trunk) | |
| 18:25 | Fix a problem causing spurious "<cte>: circular reference" errors to be reported when there is actually a different error in the SQL statement. (check-in: 9981223618 user: dan tags: trunk) | |
| 16:52 | Increase the patch level to 3.35.3. (check-in: 259b7c3e21 user: drh tags: trunk) | |
| 16:47 | Fix the OP_OpenDup opcode so that it is able to duplicate a cursor that was itself opened by OP_OpenDup. Add additional verification of ephemeral tables. Fix for ticket [bb8a9fd4a9b7fce5]. (check-in: bcbe5308f3 user: drh tags: trunk) | |
| 16:36 | Remove unnecessary code from sqlite3BtreeClose() and add test cases. (Closed-Leaf check-in: edbfdcaefa user: drh tags: opendup-fix) | |
| 15:42 | Further sanity checking of the OpenDup cursors. (check-in: 0ec71cf169 user: drh tags: opendup-fix) | |
| 14:36 | Fix the dbsqlfuzz-derived authorizer in fuzzcheck to avoid creating junk files when running rogue tests. (check-in: eca21a6206 user: drh tags: trunk) | |
| 14:31 | Automatically close ephemeral b-trees when their last cursor is closed. (check-in: 39b5af18c0 user: dan tags: opendup-fix) | |
| 13:55 | Fix a problem with the filename normalizer in unix, discovered by dbsqlfuzz. (check-in: ff1eca7fcd user: drh tags: trunk) | |
| 13:42 | Allow instruction OP_OpenDup to duplicate cursors created by OP_OpenDup, as well as by OP_OpenEphemeral. (check-in: b8de980b2f user: dan tags: opendup-fix) | |
| 13:19 | New assert statements associated with Ephemeral cursors in the bytecode engine. (check-in: a8ce73e257 user: drh tags: trunk) | |
| 12:36 | Change the name of the iDataVersion field of Btree to iBDataVersion to make it distinct from Pager.iDataVersion. (check-in: e4c44c0bca user: drh tags: trunk) | |
|
2021-03-17
| ||
| 19:52 | Update to version 3.35.2 (check-in: 18bec0d263 user: drh tags: reuse-schema) | |
| 19:07 | Version 3.35.2 (check-in: ea80f3002f user: drh tags: trunk, release, version-3.35.2) | |
| 19:05 | Fix a harmless compiler warning in the appendvfs.c extension. (check-in: 0ed7eb9115 user: drh tags: trunk) | |
| 14:29 | If there are already 500 or more simple SELECTs in a query, do not add more by flattening UNION ALL sub-queries into parent join queries. (check-in: 9520bed2bd user: dan tags: trunk) | |
| 11:25 | Fix a problem in sqldiff virtual table hanlding to do with tab and other non-space whitespace characters in the CREATE VIRTUAL TABLE statement. (check-in: 1737e4fdfc user: dan tags: trunk) | |
|
2021-03-16
| ||
| 18:41 | Date/time functions with no arguments (ex: date() or time()) should be non-deterministic. Fix for ticket [2c6c8689fb5f3d2f]. (check-in: 1734c332e7 user: drh tags: trunk) | |
| 18:24 | Add tests for sqlite_rename_quotefix(). Fix a memory leak in the same. (Closed-Leaf check-in: 531550056c user: dan tags: alter-quotefix) | |
| 16:14 | Have ALTER TABLE RENAME COLUMN and DROP COLUMN use sqlite_rename_quotefix() to convert any double-quoted strings in the database schema to their single-quoted equivalents. (check-in: 6446c09610 user: dan tags: alter-quotefix) | |
| 14:43 | Increase the version number to 3.35.2. (check-in: 7a211b3f09 user: drh tags: trunk) | |
| 14:26 | Fix recent breakage of the appendvfs extension. (check-in: 7dbbe5b34e user: drh tags: trunk) | |
| 14:12 | Comment and stylistic changes to the appendvfs.c implementation. (Closed-Leaf check-in: 25c3186aa1 user: drh tags: appendvfs_fix) | |
| 11:21 | Merge trunk changes into this branch. (check-in: f15d51054a user: dan tags: alter-quotefix) | |
| 11:11 | Fix a problem with ALTER TABLE RENAME COLUMN when used on a schema that features generated columns. Fix for [a753a856]. (check-in: 0e255b2687 user: dan tags: trunk) | |
| 07:06 | Fix assert typo. (check-in: 3aedf818c1 user: larrybr tags: appendvfs_fix) | |
| 06:50 | Merge from trunk. (check-in: eae8236f3b user: larrybr tags: appendvfs_fix) | |
| 06:41 | Fix appendvfs bug exposed with bigger files, and add tests for such conditions. (check-in: 19b1f53a1c user: larrybr tags: appendvfs_fix) | |
| 04:03 | Create new branch named "appendvfs_fix" (check-in: 026edd6014 user: larrybr tags: appendvfs_fix) | |
|
2021-03-15
| ||
| 20:22 | Add internal SQL function sqlite_rename_quotefix(). For converting double-quoted strings to their single-quoted counterparts in DDL statements. (check-in: d874b30046 user: dan tags: alter-quotefix) | |
| 19:34 | Merge version 3.35.1 into the reuse-schema branch. (check-in: 0fe60a63ae user: drh tags: reuse-schema) | |
| 16:53 | Version 3.35.1 (check-in: aea12399bf user: drh tags: trunk, release, version-3.35.1) | |
| 15:12 | Improvements to the built-in ".dump" documentation in the CLI. (check-in: 0915f969f4 user: drh tags: trunk) | |
| 15:02 | Bump the version number to 3.35.1. (check-in: 184d5a352f user: drh tags: trunk) | |
| 14:58 | Improved detection of conflicting indexes when doing DROP COLUMN on a column whose name is quoted in the index definition. Fix for ticket [1c24a659e6d7f3a1]. (check-in: c450d0ad6b user: drh tags: trunk) | |
| 12:56 | Make shell's .help output for .dump more accurate as to what can be dumped. (Closed-Leaf check-in: f91d8c09a0 user: larrybr tags: cli-tweaks) | |
| 12:32 | Create new branch named "cli-tweaks" (check-in: 4cf056a571 user: larrybr tags: cli-tweaks) | |
|
2021-03-14
| ||
| 20:17 | An additional test case (Closed-Leaf check-in: 7e2d7ca15a user: drh tags: tkt-1c24a659-b) | |
| 19:55 | An alternative approach for fixing ticket [1c24a659e6d7f3a1]. (check-in: a2adae907a user: drh tags: tkt-1c24a659-b) | |
| 01:40 | Never allow a double-quoted identifier that appears by itself in the argument list of an index to be interpreted as a string literal. Proposed fix for ticket [1c24a659e6d7f3a1]. (Closed-Leaf check-in: 7c8aa38125 user: drh tags: tkt-1c24a659) | |
|
2021-03-13
| ||
| 18:23 | Fix a memory leak in the new code on this branch. (Closed-Leaf check-in: 0817cf2ec0 user: dan tags: distinct-agg-opt) | |
| 17:21 | Fix typos in comments and add test cases. (check-in: 01312a3dbd user: dan tags: distinct-agg-opt) | |
|
2021-03-12
| ||
| 23:15 | Update generated autoconf/Makefile.msc to reflect its source. (check-in: d9f8f488ff user: larrybr tags: trunk) | |
| 21:59 | Add test for autoconf/Makefile.msc current with respect to its generator input. (Leaf check-in: 4dfd871689 user: larrybr tags: derived_tests) | |
| 21:09 | Fix a crash in new code on this branch. (check-in: c05ed2a8a9 user: dan tags: distinct-agg-opt) | |
| 20:29 | Merge v3.35.0 release to this branch. (check-in: 6733ed766e user: larrybr tags: derived_tests) | |
| 20:24 | Create new branch named "derived_tests" (check-in: 8dc765d3ba user: larrybr tags: derived_tests) | |
| 18:33 | Merge latest trunk changes into this branch. (check-in: 198bc510d6 user: dan tags: distinct-agg-opt) | |
| 18:24 | Attempt to use an index for DISTINCT aggregate queries that have GROUP BY clauses. (check-in: 3bca003cd2 user: dan tags: distinct-agg-opt) | |
| 17:26 | Merge the 3.35.0 release into the reuse-schema branch. (check-in: c8237a024d user: drh tags: reuse-schema) | |
| 17:18 | Merge the 3.35.0 release into the begin-concurrent-pnu-wal2 branch. (check-in: 939b9e7530 user: drh tags: begin-concurrent-pnu-wal2) | |
| 17:08 | Merge the 3.35.0 release into the wal2 branch. (check-in: 03142e5f76 user: drh tags: wal2) | |
| 16:50 | Merge the 3.35.0 release into the begin-concurrent-report branch. (check-in: 27f8f56b98 user: drh tags: begin-concurrent-report) | |
| 16:24 | Merge the 3.35.0 release into the begin-concurrent-pnu branch. (check-in: a0a9dd52a7 user: drh tags: begin-concurrent-pnu) | |
| 16:18 | Merge version 3.35.0 changes into the begin-concurrent branch. (check-in: 7e38c889e7 user: drh tags: begin-concurrent) | |
| 15:10 | Version 3.35.0 (check-in: acd63062eb user: drh tags: trunk, release, major-release, version-3.35.0) | |
| 13:49 | Fix broken requirement marks. (check-in: 98d6715284 user: drh tags: trunk) | |
| 01:49 | Fix the ".read" command in the CLI so that SQLITE_OMIT_POPEN disables reading from a pipeline. (check-in: cea34f3cc3 user: drh tags: trunk) | |
| 00:44 | Conform description of sqlite3changeset_op() arguments to implemented behavior, some reformatting. This is a comment-only change; no code is affected. (check-in: 9d6e544c47 user: larrybr tags: trunk) | |
|
2021-03-11
| ||
| 21:00 | Update this branch with latest fixes from trunk. (check-in: 12363f8e17 user: dan tags: reuse-schema) | |
| 20:07 | Merge latest wal2 changes into this branch. (check-in: 88c3c173e0 user: dan tags: begin-concurrent-pnu-wal2) | |
| 19:42 | Merge latest trunk changes into this branch. (check-in: 30f912d0b3 user: dan tags: wal2) | |
| 19:26 | Merge latest changes from begin-concurrent-pnu into this branch. (check-in: 6994a2d8af user: dan tags: begin-concurrent-report) | |
| 19:08 | Merge latest trunk changes with this branch. (check-in: eb3101364f user: dan tags: begin-concurrent-pnu) | |
| 18:52 | Update this branch with latest changes from trunk. (check-in: 79d44ebd53 user: dan tags: begin-concurrent) | |
| 15:57 | Fix a Tcl object leak in test_session.c. (check-in: 07150cf15a user: dan tags: trunk) | |
| 13:43 | Bug fix in appendvfs.c: Adjust the size parameter for SQLITE_FCNTL_SIZE_HINT to account for the prefix. (check-in: 41df3bbefd user: drh tags: trunk) | |
| 10:55 | Merge latest trunk changes into this branch. (check-in: ef8c6e06cb user: dan tags: reuse-schema) | |
| 08:49 | Have the Tcl tests support environment variable SQLITE_TEST_PATTERN_LIST, so that if it is set it is interpreted as a list of patterns that are matched against tests file names. Only test files that match at least one pattern are run. (check-in: b7c92e1d08 user: dan tags: trunk) | |
|
2021-03-10
| ||
| 20:04 | Fix sanitizer complaint in fts3 code. (check-in: 424b39eaeb user: dan tags: trunk) | |
| 19:32 | Fix further sanitizer complaints in the fts5 code. (check-in: 4cb00b9d40 user: dan tags: trunk) | |
| 18:21 | Improved testcase() related the SQLITE_MAX_ATTACHED vs. SQLITE_MAX_DB problem. (check-in: 27d3c00efe user: drh tags: trunk) | |
| 17:52 | Improvement to the ATTACH-abuse authorizer logic in fuzzcheck. (check-in: 88132f698a user: drh tags: trunk) | |
| 17:43 | Do not run avfs.test when testing SQLITE_OMIT_VIRTUALTABLE builds. (check-in: 2ab6957a22 user: dan tags: trunk) | |
| 16:35 | Do not confuse the constant SQLITE_MAX_ATTACHED with the maximum number of schemas. Add the new SQLITE_MAX_DB constant for the maximum number of schemas. Forum post a006d86f72. (check-in: 7b65fb9f7b user: drh tags: trunk) | |
| 15:10 | Fix test file avfs.test so that it works with SQLITE_DEFAULT_AUTOVACUUM builds. Do not run avfs.test under test permutation "journaltest". (check-in: 2c6078ebe7 user: dan tags: trunk) | |
| 14:57 | Fix a few sanitizer complaints in fts5. (check-in: 4fe4fee00e user: dan tags: trunk) | |
| 10:43 | Fix a problem preventing wapptest from setting SQLITE_ENABLE_LOCKING_STYLE for OSX tests. Also modify the "Sanitize" configuration in releasetest_data.tcl to subsume test item 6g. (check-in: f762d7df2a user: dan tags: trunk) | |
| 06:06 | When shell has no .ar, fake its effect w.r.t. page_size and table creation/filling. (check-in: 959f5c65ea user: larrybr tags: trunk) | |
|
2021-03-09
| ||
| 23:38 | Add appendvfs.c to the MSVC makefile. (check-in: a6681fbb2e user: drh tags: trunk) | |
| 21:20 | Update a comment in btree.h. (check-in: 9645fe1a05 user: dan tags: trunk) | |
| 20:58 | Fix a bad comment (copy-paste error) in the byte code engine. No code changes. (check-in: 1c01745734 user: drh tags: trunk) | |
| 19:52 | Improved comments on the NOT NULL strength reduction optimization. (check-in: a85d722939 user: drh tags: trunk) | |
| 19:32 | Extra comments and testcase() macros associated with the new sqlite3ParserAddCleanup() mechanism. No changes to release builds. (check-in: c3c8691121 user: drh tags: trunk) | |
| 17:09 | Add --enable-math to the amalgamation autoconf. On be default. Improved logging of the amalgamation autoconf. (check-in: 85d28b5225 user: drh tags: trunk) | |
| 16:47 | Add missing comment to new routine in select.c. (check-in: ef2f0cf21b user: dan tags: distinct-agg-opt) | |
| 16:35 | Math functions are enabled by default in the main configure script. (check-in: b7456e0715 user: drh tags: trunk) | |
| 16:06 | Experimental optimization for distinct aggregates (e.g. "SELECT count(DISTINCT <expr) FROM ..."). (check-in: eb919611fd user: dan tags: distinct-agg-opt) | |
| 13:53 | Improvements to the configure script. Math functions are enabled by --enable-all. (check-in: c79c6d18de user: drh tags: trunk) | |
| 13:12 | Update the authorizer in fuzzcheck to align with dbsqlfuzz. (check-in: f86d8fae3b user: drh tags: trunk) | |
|
2021-03-08
| ||
| 20:13 | Add tests for too-tiny appended DBs, clarify align macro. (check-in: eb40a8dea6 user: larrybr tags: trunk) | |
| 17:22 | Add test cases for ALTER TABLE. (check-in: 9c9ba36e85 user: dan tags: trunk) | |
| 17:17 | Fix a bad assert in RENAME COLUMN. dbsqlfuzz 3f0a7245b69cd08617d7d7781ebaedb0fe765a93. (check-in: f13e0d12f1 user: drh tags: trunk) | |
| 16:29 | Fix a harmless compiler warning in appendvfs.c (check-in: f538961a80 user: drh tags: trunk) | |
| 16:13 | Enable internal functions for fuzzcheck. (check-in: 79281603b9 user: drh tags: trunk) | |
| 14:32 | Added test/avfs.test (missing from branch merge for some reason.) (check-in: 08fa67053c user: larrybr tags: trunk) | |
| 14:26 | Merge appendvfs updates and testing. (check-in: 63fcf301fe user: larrybr tags: trunk) | |
| 13:45 | Require that the appendvfs suffix mark indicate that the appended database begins at an offset that is a muliple of 512 and that the appended database contains at least 512 bytes. (Leaf check-in: aeb87cc704 user: drh tags: appendvfs_tighten) | |
| 13:30 | Correct the precendence order for rules that determine how a database is opened by appendvfs when a database is appended to another database. (check-in: 92989fc56f user: drh tags: appendvfs_tighten) | |
| 12:59 | Minor comment and formatting changes. (check-in: cf2add064f user: drh tags: appendvfs_tighten) | |
| 01:31 | Add tests for sqlite3 shell with -append flag. (check-in: d179028872 user: larrybr tags: appendvfs_tighten) | |
|
2021-03-07
| ||
| 18:55 | Add grow/shrink tests. Fix truncate bug. Make appendvfs.c easier to inspect. (check-in: c9521fa556 user: larrybr tags: appendvfs_tighten) | |
|
2021-03-06
| ||
| 23:49 | Merge from trunk. (check-in: 729117cdfa user: larrybr tags: appendvfs_tighten) | |
| 23:36 | Create initial tests for appendvfs, and make it available as a statically loaded extension. (check-in: 9f33d45179 user: larrybr tags: appendvfs_tighten) | |
| 15:13 | Limit parenthesis nesting depth in FTS3 expressions to SQLITE_MAX_EXPR_DEPTH. (check-in: 5ddd8032ef user: drh tags: trunk) | |
| 14:46 | Ensure the correct collation sequence is used for comparisons when delimiting a RANGE window. (check-in: 01eae68e85 user: dan tags: trunk) | |
| 13:28 | Fix a crash in fts3 that could occur when running a NEAR query on a corrupt database. (check-in: 609d949963 user: dan tags: trunk) | |
| 13:02 | Fix a possible NULL pointer dereference when applying a DROP COLUMN to a corrupt database schema. dbsqlfuzz 419aa525df93db6e463772c686ac6da27b46da9e (check-in: 349ccf58ae user: drh tags: trunk) | |
|
2021-03-05
| ||
| 20:52 | Merge last day of trunk changes, reverify build. (check-in: 1d67ed1c98 user: larrybr tags: appendvfs_tighten) | |
| 20:46 | Fix appendvfs bug exposed by docsapp build (in docsrc), and tighten/revise published behavior. (check-in: 7f0f2eacdb user: larrybr tags: appendvfs_tighten) | |
| 18:33 | Modify the SQLITE_DBCONFIG_ENABLE_VIEW option so that it always permits TEMP views, just as SQLITE_DBCONFIG_ENABLE_TRIGGER always permits TEMP triggers. (check-in: 83dab8b358 user: drh tags: trunk) | |
| 15:42 | Fix problems with RETURNING clauses attached to UPDATEs on tables with virtual columns. (check-in: 6b41b136fb user: dan tags: trunk) | |
| 15:29 | Fix another problem with RETURNING clauses in UPDATEs against tables with virtual columns. (Closed-Leaf check-in: f0ef5c76ab user: dan tags: returning-fix) | |
| 15:10 | Fix an assert() failure that could be triggered by a correlated sub-query in a RETURNING clause. (check-in: 551260c862 user: dan tags: returning-fix) | |
| 14:08 | Fix the processing of implied LIMIT clauses when flattening a compound query. (check-in: 90c6b9fcb0 user: drh tags: trunk) | |
| 09:42 | Create new branch named "appendvfs_tighten" (check-in: 48c968bf4c user: larrybr tags: appendvfs_tighten) | |
|
2021-03-04
| ||
| 19:44 | Mark the NotUsed parameter to the dropColumnFunc() function as unused, to avoid a harmless compiler warning. (check-in: 2345907109 user: drh tags: trunk) | |
| 18:34 | Put ALWAYS() on a branch that is now always true because of changes in OOM behavior due to check-in [9adf6e2469d18bc3]. (check-in: 8a1bb9c3e9 user: drh tags: trunk) | |
| 18:31 | Update shell.c.in so that SQLITE_SHELL_IS_UTF8 is set to 0 if the -municode option is passed to gcc on windows. (check-in: 99e6a0f020 user: dan tags: trunk) | |
| 16:32 | Remove a branch made unreachable by check-in [e893f88750ea64d4]. (check-in: 20d7dc120d user: drh tags: trunk) | |
| 16:10 | Fix a segfault that could occur following an OOM condition. (check-in: 9adf6e2469 user: dan tags: trunk) | |
| 16:03 | Earlier detection of a misplaced ORDER BY or LIMIT clause in a compound SELECT. This prevents problems in recursive CTEs with multiple recursive terms in which there is an ORDER BY or LIMIT clause on the last non-recursive term. (check-in: e893f88750 user: drh tags: trunk) | |
| 14:18 | Fix a crash that could occur if a sub-select inside an EXISTS expression features an ORDER BY clause containing one or more window functions. (check-in: 9768e7db62 user: dan tags: trunk) | |
|
2021-03-03
| ||
| 19:54 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: 73bf458e1d user: drh tags: reuse-schema) | |
| 19:41 | Merge in recent enhancements. (check-in: b0fc8ca14e user: drh tags: begin-concurrent-pnu-wal2) | |
| 19:36 | Fix a buffer overrun that could occur in fts5 when running a prefix query against a corrupt db. (check-in: 4da40620ac user: dan tags: trunk) | |
| 19:32 | Merge recent trunk enhancements into the wal2 branch. (check-in: 0ae8103908 user: drh tags: wal2) | |
| 19:25 | Merge recent trunk enhancemenets into the begin-concurrent-pnu branch. (check-in: 59d3ec295a user: drh tags: begin-concurrent-pnu) | |
| 19:17 | Merge recent trunk changes into the begin-concurrent branch. (check-in: acdafef836 user: drh tags: begin-concurrent) | |
| 16:46 | Remove the --timeout option from the valgrindfuzz Makefile target. (check-in: 3f520b8bde user: dan tags: trunk) | |
| 16:00 | Fix a case where fts3 was erroneously reporting corruption. (check-in: e6c7683c75 user: dan tags: trunk) | |
| 14:07 | Fix a harmless assertion fault resulting from [6e6b3729e0549de0] that was discovered by dbsqlfuzz. Enhance .selecttrace output to show omitted ORDER BY clauses. New dbsqlfuzz test cases added. (check-in: 27a0388ad6 user: drh tags: trunk) | |
| 11:00 | Fix a problem with using ALTER TABLE commands on database schemas that contain expressions of the form "<expr> NOT NULL" or "<expr> IS NULL" that can be evaluated at prepare time. (check-in: d2630ffafa user: dan tags: trunk) | |
|
2021-03-02
| ||
| 21:07 | Cast a string size variable to 64-bit to avoid any possibility of integer overflow. (check-in: a5940294b2 user: drh tags: trunk) | |
| 16:27 | Limit the size of the exponent input in the second argument to the ieee754() SQL function, to avoid integer overflow. Ticket [22dea1cfdb9151e4]. (check-in: 99aab32da1 user: drh tags: trunk) | |
| 13:50 | Change the timeout for test case "valgrindfuzz" from 600 seconds to 1200. (check-in: 7c6aa6f384 user: dan tags: trunk) | |
| 13:36 | Do not run test file windowpushd.test as part of the "no_optimization" permutation. (check-in: 275a75aa82 user: dan tags: trunk) | |
| 00:42 | Add ALWAYS() to an always-true conditional. (check-in: fa3506db20 user: drh tags: trunk) | |
|
2021-03-01
| ||
| 21:43 | Add #ifndef macros so that the build works again with -DSQLITE_OMIT_AUTHORIZATION and -DSQLITE_OMIT_WINDOWFUNC. (check-in: 9400bdc602 user: drh tags: trunk) | |
| 16:16 | Fix a couple of memory-sanitizer complaints that could be triggered by a corrupt database. (check-in: 39c8686cab user: dan tags: trunk) | |
| 16:15 | Fix another msan complain triggered by a corrupt database. (Closed-Leaf check-in: d235d40628 user: dan tags: msan-fix) | |
|
2021-02-28
| ||
| 08:24 | Initialize extra field in PgHdr1 to fix an msan complaint. (check-in: 4cb2ea5795 user: dan tags: msan-fix) | |
|
2021-02-27
| ||
| 15:32 | Add OOM test case associated with the fix in the previous commit. (check-in: a631c38d22 user: dan tags: trunk) | |
| 15:12 | Remove a NEVER() that might sometimes be tree following an OOM. (check-in: ccb8cf5256 user: drh tags: trunk) | |
|
2021-02-26
| ||
| 21:39 | Fix a segfault that could occur when optimizing a NOT NULL constraint against an IPK column of a sub-query. (check-in: e4d1970ef1 user: dan tags: trunk) | |
| 20:39 | Attempt to optimize "x IS NULL" and "x IS NOT NULL" expressions when x is a column with a NOT NULL constraint. This addresses the performance issue described by forum post a5fc33cf9d8f4ff5. (check-in: de9c86c9e4 user: dan tags: trunk) | |
| 20:14 | Attempt to optimize "x IS NULL" and "x IS NOT NULL" expressions when x is a column with a NOT NULL constraint. (Closed-Leaf check-in: 5ecd842555 user: dan tags: ifnull-opt) | |
| 15:20 | Minor simplification in resolve.c. (check-in: 310dac342e user: dan tags: trunk) | |
|
2021-02-25
| ||
| 18:28 | Fix test case in altercorrupt.test so that it works with SQLITE_ENABLE_OVERSIZE_CELL_CHECK builds. (check-in: 062b338ff2 user: dan tags: trunk) | |
| 18:23 | Fix a problem with UPDATE and DELETE statements that use both INDEXED BY and LIMIT clauses in SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds. (check-in: cc2b4b3866 user: dan tags: trunk) | |
| 16:55 | Fix handling of INSERT on views with implicitly named hidden columns in SQLITE_ENABLE_HIDDEN_COLUMNS builds. (check-in: 15795a96a8 user: dan tags: trunk) | |
| 15:50 | Ensure that tests like "rbu.test" and "notify2.test" that are only run by specific configurations during release testing are run for both release and debug versions of the tests. (check-in: 911df43f98 user: dan tags: trunk) | |
|
2021-02-23
| ||
| 16:40 | When a sub-transaction is released, if no pages required by containing sub-transactions were journaled, truncate the statement journal. This prevents out of control statement journal growth in some cases. See forum thread e78ffd751185a67e for context. (check-in: 23ca23894a user: dan tags: trunk) | |
| 15:53 | Allow WHERE terms to be pushed down into sub-queries that contain window functions, provided that the WHERE term is made up of entirely of constants and copies of expressions found in the PARTITION BY clauses of all window functions in the sub-query. (check-in: 2068946810 user: dan tags: trunk) | |
| 15:36 | Further tests for the push-down optimization with window functions. (Closed-Leaf check-in: 4b089f7011 user: dan tags: window-functions-pushdown) | |
|
2021-02-22
| ||
| 20:56 | Allow WHERE terms to be pushed down into sub-queries that contain window functions, provided that the WHERE term is made up of entirely of constants and copies of expressions found in the PARTITION BY clauses of all window functions in the sub-query. (check-in: dac51f303b user: dan tags: window-functions-pushdown) | |
| 19:57 | Add a few simple test cases for MATERIALIZED and NOT MATERIALIZED. (check-in: 64878124c1 user: drh tags: trunk) | |
| 16:42 | Implement the MATERIALIZED and NOT MATERIALIZED hints on common table expressions. (check-in: b5a0778cc5 user: drh tags: trunk) | |
| 15:44 | When a sub-transaction is released, if no pages required by containing sub-transactions were journaled, truncate the statement journal. This might prevent out-of-control statement journal growth in some cases. (Closed-Leaf check-in: e36327fb22 user: dan tags: stmt-jrnl-truncate) | |
| 14:25 | Add an ALWAYS() on a branch that is now unreachable. (Closed-Leaf check-in: ace54c5bd5 user: drh tags: as-materialize-redux) | |
| 11:07 | Fix inverted logic regarding the materialization hint on the push-down optimization. (check-in: b66a495708 user: drh tags: as-materialize-redux) | |
| 03:04 | Add the AS MATERIALIZED and AS NOT MATERIALIZED syntax that works like it does in PostgreSQL. (check-in: a6bb272ec0 user: drh tags: as-materialize-redux) | |
|
2021-02-21
| ||
| 23:44 | Materialize any CTE that is used more than once. (check-in: ba59159fbe user: drh tags: as-materialize-redux) | |
| 21:04 | Rename the "struct SrcList_item" object to the more succinct "SrcItem". This is a symbolic change only. The logic is unmodified. (check-in: bfd5bf2c73 user: drh tags: trunk) | |
| 01:19 | Simplified resolution of CTE names. Slightly faster and about 100 bytes of code smaller. (check-in: 0d2c992f36 user: drh tags: trunk) | |
|
2021-02-20
| ||
| 21:20 | Performance improvement in resolving the INDEXED BY index name for the common case where there is no INDEXED BY clause. (check-in: 554b286ac2 user: drh tags: trunk) | |
| 19:22 | Fix a case where FTS3/4 could pass a NULL pointer to memcpy() when handling a corrupt db. (check-in: 68bb541a39 user: dan tags: trunk) | |
| 18:02 | Update sqlite3changeset_apply_v2() so that it handles no-op UPDATE changes (UPDATE changes that modify no columns). This fixes a regression introduced by [e4ccfac09b]. Also modify sqlite3rebaser_rebase() so that it does not output changesets containing such UPDATEs. (check-in: 0288a8013e user: dan tags: trunk) | |
| 14:57 | Break out the Cte object from the With object. This will make it simpler to add new kinds of Cte objects (ex: DML statements) and/or MATERIALIZED keywords in the future. It brings trunk into closer alignment with the experimental as-materialize branch. (check-in: f03efe905d user: drh tags: trunk) | |
| 13:36 | Simplification to where.c manually cherrypicked from the as-materialize branch. (check-in: 03805a6117 user: drh tags: trunk) | |
| 12:47 | Merge changes from trunk. (Later:) Abandon this line of development. See the as-materialize-redux branch. (Closed-Leaf check-in: 7a90571e0a user: drh tags: as-materialize) | |
|
2021-02-19
| ||
| 18:39 | Fix another problem handling corrupt database files in the ALTER TABLE DROP COLUMN code. (check-in: 9edf2ddc47 user: dan tags: trunk) | |
| 15:34 | Add tests for ALTER TABLE DROP COLUMN commands. (check-in: 05dbea9b26 user: dan tags: trunk) | |
| 14:32 | Add support for "ALTER TABLE ... DROP COLUMN ..." commands. (check-in: c844a331e7 user: dan tags: trunk) | |
| 14:13 | Fix a crash that could occur in ALTER TABLE DROP COLUMN if the sqlite_schema table was corrupt. (Closed-Leaf check-in: 126ee1ec4f user: dan tags: alter-table-drop-column) | |
| 09:46 | Omit an branch made unreachable by the improved error message from dropping the last column of a table. (check-in: c5719fc5aa user: drh tags: alter-table-drop-column) | |
| 09:36 | The COLUMN keyword in ALTER TABLE DROP COLUMN is optional. (check-in: a22f87fb6c user: drh tags: alter-table-drop-column) | |
| 09:09 | Give a better error message on DROP COLUMN when attempting to drop the last column of a table. (check-in: 5e1f362bc3 user: drh tags: alter-table-drop-column) | |
| 02:30 | Add a NEVER() to an unreachable branch in the DROP COLUMN logic. (check-in: 963f498ae6 user: drh tags: alter-table-drop-column) | |
|
2021-02-18
| ||
| 23:53 | Add missing VdbeCoverage() macros. (check-in: 9bb720e659 user: drh tags: alter-table-drop-column) | |
| 23:03 | Enhance renameParseSql() to better handle OOMs. (check-in: 68bcde7ab5 user: drh tags: alter-table-drop-column) | |
| 22:47 | Merge changes from trunk into the alter-table-drop-column branch. (check-in: 9ea640073f user: drh tags: alter-table-drop-column) | |
| 20:27 | Fix DROP COLUMN so that it works even if the user has registered an authorizer callback. (check-in: e5f144182b user: dan tags: alter-table-drop-column) | |
| 19:25 | Fix a problem with schema error detection when processing ALTER TABLE DROP COLUMN commands. (check-in: 565a6fd0c9 user: dan tags: alter-table-drop-column) | |
| 17:48 | Add test cases for ALTER TABLE DROP COLUMN. (check-in: 204ee5e282 user: dan tags: alter-table-drop-column) | |
| 15:59 | Avoid invoking the update or pre-update hooks during VACUUM operations. (check-in: 3c25cb4ab8 user: dan tags: trunk) | |
| 15:45 | Improvement to the INSERT optimization of check-in [16ac213c57196361] so that it works with SQLITE_ENABLE_HIDDEN_COLUMN but is also easier to maintain and a little faster as well. (check-in: f985a78ecc user: drh tags: trunk) | |
| 14:27 | Disable the optimization of [16ac213c57196361] when the SQLITE_ENABLE_HIDDEN_COLUMN compile-time option is used, as the optimization does not work in that case. (check-in: 5168b06bcf user: drh tags: trunk) | |
| 12:18 | Ensure that the pre-update hook is invoked for INSERT operations on WITHOUT ROWID tables that use the xfer optimization. (check-in: 66bbad239b user: dan tags: trunk) | |
| 01:02 | Add missing VdbeCoverage() macros to some of the new RETURNING code. (check-in: 53a5390909 user: drh tags: trunk) | |
| 00:59 | Performance optimization in the resolver. (check-in: 1aafb94d4e user: drh tags: trunk) | |
| 00:26 | Performance optimization in the code generator for INSERT for the common case where the target table has neither generated nor hidden columns. Also fix a redundant (and thus unreachable) branch in the resolver. (check-in: 16ac213c57 user: drh tags: trunk) | |
|
2021-02-17
| ||
| 21:13 | Use the sqlite3ParserAddCleanup() mechanism to ensure that the AggInfo structure associated with an aggregate query is deallocated, for a performance increase and size reduction. (check-in: 7a1399671f user: drh tags: trunk) | |
| 20:46 | Fix a problem with OOM error handling in the new code on this branch. (check-in: ea999c9db5 user: dan tags: alter-table-drop-column) | |
| 20:19 | Merge trunk changes into this branch. (check-in: 0cd5e2f9ce user: dan tags: alter-table-drop-column) | |
| 20:08 | Fix various issues with the changes on this branch. Add test cases for the same. (check-in: 10538ec6fc user: dan tags: alter-table-drop-column) | |
| 13:19 | Enhance the ".once" and ".output" commands in the CLI so that if the filename argument begins with "|" the name becomes the concatenation of all subsequent arguments. Hence, commands like ".once | open -f" become possible without the need for quotes. (check-in: c46a94a624 user: drh tags: trunk) | |
|
2021-02-16
| ||
| 20:43 | Add experimental implementation of ALTER TABLE DROP COLUMN. Only some cases work so far. (check-in: f0217937d7 user: dan tags: alter-table-drop-column) | |
| 20:32 | Simplification to the resolveAlias() routine. (check-in: 00bead3931 user: drh tags: trunk) | |
| 20:01 | New SELECTTRACE macros more clearly deliniate when the query planner is invoked in the middle of PRAGMA vdbe_addoptrace output. (check-in: 7c03ce49b7 user: drh tags: trunk) | |
| 19:29 | Remove unnecessarily complexity from sqlite3WithReleaseByParse(). Improved TreeView output for the enhanced CTE structures. This code still does not work 100%. I'm saving my place in order to (maybe) come back to it later. (check-in: 30bb18b450 user: drh tags: as-materialize) | |
| 16:32 | Trying to get the new AS MATERIALIZE syntax of CTEs to work. There are still performance and memory management issues. This is a WIP check-in. (check-in: bf0fd9b23a user: drh tags: as-materialize) | |
| 00:48 | Change the syntax from "GENERATED AS" to "AS MATERIALIZED" so as to match the syntax of PostgreSQL 12+. (Closed-Leaf check-in: 78dcddd969 user: drh tags: with-generated-as) | |
|
2021-02-15
| ||
| 17:51 | Merge the LIKE operator fix from trunk. (check-in: 8c8618780a user: drh tags: with-generated-as) | |
| 17:02 | Fix an issue with the LIKE operator when it includes the "ESCAPE '_'" clause. Ticket [c0aeea67d58ae0fd]. (check-in: 27d4117980 user: drh tags: trunk) | |
| 14:55 | Merge minor fixes from trunk. (check-in: d876b287e1 user: drh tags: with-generated-as) | |
| 14:32 | Add tests for sqlite3_column_count(). (check-in: 7cc65ae571 user: dan tags: trunk) | |
| 13:17 | Ensure that the ALTER TABLE statements return 0 for sqlite3_column_count(). (check-in: 29c1932a47 user: drh tags: trunk) | |
| 11:14 | Fix an error in the test case fix in [ecd71203]. (check-in: 5411bfa41e user: dan tags: trunk) | |
|
2021-02-13
| ||
| 23:46 | If the GENERATED keyword occurs before the AS keyword in a common table expression (CTE) definition, then that CTE becomes an "optimization barrier". For now, that means the CTE is always materialized. It also means that query flattener or pushdown optimizations that cross the CTE boundary are omitted. (check-in: 186ec18b24 user: drh tags: with-generated-as) | |
| 21:01 | Add a test-control that allows setting a LIKE pattern for common table expression names such that CTEs with matching names become an optimization barrier - They are not flattened and are implemented by materialization. (Closed-Leaf check-in: 15692ec02b user: drh tags: optbarrier-test-ctrl) | |
| 18:14 | Fix incorrect test name labels in the select1.test script. (check-in: 179c79ea0d user: drh tags: trunk) | |
| 16:39 | Avoid manifesting a CTE (or other view) multiple times when it is possible to reuse the first manifestation. (check-in: 9692f51080 user: drh tags: trunk) | |
| 14:26 | Fix a problem in the unreleased union-all flattening enhancement (check-in: e4f8a79fd8 user: dan tags: trunk) | |
|
2021-02-12
| ||
| 21:22 | Fix a test case to account for the fact that different versions of OpenBSD behave differently when a program tries to read() from a file-descriptor open on a directory. (check-in: ecd712032f user: dan tags: trunk) | |
| 21:07 | Parsing of DML statements in a WITH clause. But at this point, it just generates an error about "not yet supported". (Leaf check-in: 964ff68d8f user: drh tags: dml-in-cte) | |
| 11:37 | Ensure all RBU tests are run as part of release testing. (check-in: a18dc08baf user: dan tags: trunk) | |
|
2021-02-10
| ||
| 20:20 | Merge latest trunk changes into this branch. (check-in: d29c41bd26 user: dan tags: reuse-schema) | |
| 20:00 | Fix a longstanding problem causing an RBU vacuum to omit releasing some locks before finishing. (check-in: 66c07a07b2 user: dan tags: trunk) | |
| 19:49 | Remove an assert() added by the previous commit that is sometimes false. (Closed-Leaf check-in: fb36ac4dc6 user: dan tags: shm-lock-fix) | |
| 19:40 | Fix a longstanding problem causing an RBU vacuum to omit releasing some locks before finishing. (check-in: cb5bdf82fe user: dan tags: shm-lock-fix) | |
| 17:31 | In RBU, avoid passing VFS xShmLock calls through to the underlying VFS in cases where xShmMap calls may not be. This fixes a bad interaction with ZipVFS. (check-in: bd1e9e0a4c user: dan tags: trunk) | |
|
2021-02-08
| ||
| 15:56 | Correctly detect correlated subqueries when resolving names in RETURNING clauses. (check-in: b43cfa0492 user: drh tags: trunk) | |
| 13:41 | Improved name resolution for references to a table begin modified from within a subquery in the RETURNING clause. (check-in: 799d205bfa user: drh tags: trunk) | |
|
2021-02-07
| ||
| 23:28 | Do not allow RETURNING in the DML statements of a trigger. (check-in: 7a8fe6463a user: drh tags: trunk) | |
| 12:59 | Fix harmless compiler warnings. (check-in: 5f8bf99579 user: drh tags: trunk) | |
|
2021-02-06
| ||
| 14:56 | Remove an ALWAYS() and NEVER() in the authorizer that become reachable as of [078dbff04a95a001]. Test case for coverage in TH3. (check-in: b469327e29 user: drh tags: trunk) | |
| 14:37 | Fix the OSSFuzz-discovered shift problem from two days ago. This patch was omitted from [078dbff04a95a001] apparently because I made the edit to "sqlite3.c" rather than "resolve.c" where it belongs. (check-in: 864772ffec user: drh tags: trunk) | |
|
2021-02-05
| ||
| 17:34 | Remove unreachable code. Fix a shift UB problem introduced yesterday and discovered by OSSFuzz. (check-in: 078dbff04a user: drh tags: trunk) | |
|
2021-02-04
| ||
| 23:20 | Change the RETURNING algorithm so that outputs accumulate in an ephemeral table until all modifications have been completed, and only then do results start being returned. This should help prevent problems with interleaved sqlite3_step() calls on two separate DML statements. It also seems to be closer to how PostgreSQL works, which might prevent compatibility problems. (check-in: c4615eb28c user: drh tags: trunk) | |
| 22:59 | Remove dead code. Fix RETURNING for INSERT into a virtual table. (Closed-Leaf check-in: dbfa38699c user: drh tags: returning-manifested) | |
| 21:19 | Initial commit (Leaf check-in: e73dbce8c5 user: shearer tags: selective-debug) | |
| 21:17 | Fix an issue with RETURNING from UPSERT. (check-in: 757b74ba0f user: drh tags: returning-manifested) | |
| 20:52 | Snapshot. New design appears to work on a simple test case. (check-in: 8a65fbeecf user: drh tags: returning-manifested) | |
| 17:29 | Preliminary changes for a new implementation of RETURNING that captures all results in a buffer and plays them all back after the DML statement completes. This avoids problems with interleaved DML statements. This particular check-in is a non-functional work in progress. (check-in: 04b77d6321 user: drh tags: returning-manifested) | |
| 13:52 | Add NEVER() to a branch that check-in [5d54d9fd40638138] apparently made unreachable. (check-in: 5c8e6296aa user: drh tags: trunk) | |
| 13:44 | Performance optimization in sqlite3FinishCoding(). (check-in: 0f34f241d3 user: drh tags: trunk) | |
| 11:14 | Work toward handling interleaved RETURNING statements. Trunk does not handle that case correctly. This branch is a partial implementation of ideas that might, however. (Closed-Leaf check-in: e1eb621319 user: drh tags: interleaved-returning) | |
|
2021-02-03
| ||
| 19:38 | Corrections to the 'filepath_normalize' test suite helper procedure. (check-in: 32f4d04470 user: mistachkin tags: trunk) | |
| 18:32 | Change the name of Vdbe.magic to Vdbe.iVdbeMagic to disambiguate with sqlite3.magic. (check-in: 6b29e549bb user: drh tags: trunk) | |
| 14:20 | Avoid doing any foreign-key constraint related processing for an UPDATE statement that does not modify any columns that are part of FK constraints, even if the table has a self-referencing FK. (check-in: 7f3b036e73 user: dan tags: trunk) | |
| 13:20 | Fix a harmless compiler warning. (check-in: 1eb69c64ed user: drh tags: trunk) | |
| 13:08 | Add support for the RETURNING clause following PostgreSQL syntax. Also change the behavior of SQLITE_DBCONFIG_ENABLE_TRIGGER so that TEMP triggers are always allowed, regardless of the setting. (check-in: 416c898bfb user: drh tags: trunk) | |
| 12:35 | Fix an assert() that might be off-by-one in the case of a prior errors in the parse. (check-in: 06b15b17be user: drh tags: trunk) | |
| 00:55 | Modify the SQLITE_DBCONFIG_ENABLE_TRIGGER setting so that it only disables main-schema triggers and allows TEMP trigger to continue operating. This is safe, since only the application (not an attacker) can add TEMP triggers. It will also all us to disengage SQLITE_DBCONFIG_ENABLE_TRIGGER on Fossil databases since Fossil has no main-schema triggers but does use TEMP triggers. (Closed-Leaf check-in: a10c5a2503 user: drh tags: returning) | |
| 00:05 | Load enhancements from trunk into the returning branch. (check-in: b84c7f60c2 user: drh tags: returning) | |
|
2021-02-02
| ||
| 20:46 | Do not allow aggregates in a RETURNING clause. Fix a memory leak that occurs when window functions are used in a RETURNING clause. (check-in: 2e9bd94b9a user: drh tags: returning) | |
| 20:41 | Modify the sessions extension to use more efficient SQL when applying a changeset or patchset. (check-in: e4ccfac09b user: dan tags: trunk) | |
| 12:01 | Report an error if RETURNING is used for DELETE or UPDATE of a virtual table. (check-in: bd5dee8425 user: drh tags: returning) | |
| 00:16 | Allow the RETURNING trigger to exist for virtual tables. (check-in: 2f244ab4a2 user: drh tags: returning) | |
|
2021-02-01
| ||
| 21:26 | Add a few test cases for RETURNING together with UPDATE/DELETE LIMIT. (check-in: 7611c77d6b user: drh tags: returning) | |
| 12:39 | Improved corrupt database detection in balance_nonroot(). (check-in: 5d54d9fd40 user: drh tags: trunk) | |
| 01:57 | Modify RETURNING so that it does not return changes implemented by cascading foreign keys or by triggers. (check-in: 6e62470a73 user: drh tags: returning) | |
|
2021-01-31
| ||
| 16:45 | Mark an unreachable branch as ALWAYS(). (check-in: cb8b797a64 user: drh tags: returning) | |
| 15:50 | New opcode OP_ChngCntRow used to output the result of PRAGMA change_count. Only this new opcode, and not OP_ResultRow, checks for foreign key errors. Faster performance, and now also works with RETURNING. (check-in: 154fc2b154 user: drh tags: returning) | |
| 12:41 | When setting the number of result columns in a RETURNING trigger, be sure to set that value in the top-level bytecode program, not in the immediate caller of the trigger. (check-in: 1f1ce7ceb9 user: drh tags: returning) | |
|
2021-01-30
| ||
| 21:55 | Improved comments on the new code. (check-in: a38f0c1d7c user: drh tags: returning) | |
| 16:16 | Add an ALWAYS() to an unreachable branch. (check-in: 6bb6de42b6 user: drh tags: returning) | |
| 14:17 | Change the OP_ResultRow opcode so that it does not cancel pending statement transactions. (check-in: fea91e3a51 user: drh tags: returning) | |
| 12:07 | Fix a obsolete assert() in the bytecode engine. Improved OOM detection in sqlite3AddReturning(). (check-in: 138b10d54a user: drh tags: returning) | |
| 03:06 | Fix handling of an OOM condition in sqlite3AddReturning(). (check-in: 52204cd768 user: drh tags: returning) | |
| 02:43 | Fix a memory deallocation problem that comes up when doing a RETURNING query on a corrupt database. I think I fixed this before, but it got unfixed with stale editor content. (check-in: 02b1415efb user: drh tags: returning) | |
| 02:34 | Another attempt to get trigger selection correct for RETURNING triggers. (check-in: 1b8ed52275 user: drh tags: returning) | |
| 02:22 | When running the RETURNING trigger, if it is tagged as a DELETE trigger, do not use it as INSERT or UPDATE. (check-in: 3c7a6e04dd user: drh tags: returning) | |
| 01:30 | Test cases added. RETURNING works with UPSERT as does PG. (check-in: f5698f96e2 user: drh tags: returning) | |
|
2021-01-29
| ||
| 22:33 | Better handling of errors in RETURNING due to corrupt database files. (check-in: 6aa2a058d1 user: drh tags: returning) | |
| 21:31 | RETURNING works even if "PRAGMA count_changes=ON" is set. (check-in: a9122d9757 user: drh tags: returning) | |
| 21:18 | Allow "*" wildcards in the RETURNING clause. (check-in: b0e3ae303d user: drh tags: returning) | |
| 19:32 | Working prototype. (check-in: b7ef4dc21f user: drh tags: returning) | |
| 16:20 | Fix possible division-by-zero in the new log() SQL functions. Problemm discovered by OSSFuzz. (check-in: 1ffd321a33 user: drh tags: trunk) | |
| 14:22 | Incorporate the sqlite3TriggerList() optimization from trunk. And move the pReturning field to the uninitialized area in the Parse object, to save memset() time. (check-in: 29fbaf0e3e user: drh tags: returning) | |
| 13:47 | Performance optimization (and size reduction) in sqlite3TriggerList() for the common case where there are no TEMP triggers. (check-in: 0defaf730b user: drh tags: trunk) | |
|
2021-01-27
| ||
| 20:35 | Merge recent enhancements from trunk. (check-in: 5fbcb208d2 user: drh tags: returning) | |
| 19:15 | Fix an issue with IN operator optimization introduced by check-in [4a43430fd23f8835] and described by ticket [ee51301f316c09e9]. (check-in: 9dc7fc9f04 user: drh tags: trunk) | |
| 17:15 | Ensure a cursor used by the SeekScan operator does not point to a valid row on the first iteration of the loop. Possible fix for [ee51301f316c09e]. (Closed-Leaf check-in: 390cf60a28 user: dan tags: fix-2d6e8400) | |
|
2021-01-25
| ||
| 21:24 | Add an extra log message in the case of an SQLITE_CORRUPT_INDEX error. (check-in: 0571c24177 user: drh tags: trunk) | |
|
2021-01-22
| ||
| 21:23 | Enhance the query planner to enable it to use an index for IS NOT NULL constraints, even if STAT4 is not enabled. (check-in: 7b2a7c7314 user: drh tags: trunk) | |
| 20:28 | Merge fixes from trunk. Omit a conditional in sqlite3IsLikeFunction() that was made unreachable by this enhancement. (Closed-Leaf check-in: 0b42f9eb5d user: drh tags: isnotnull-opt) | |
|
2021-01-21
| ||
| 21:36 | Do not allow VACUUM to resize the page_size to 512 if the reserve_byte value is 31 or greater. forum post e807885dc5. (check-in: d5ea75a09d user: drh tags: trunk) | |
| 20:42 | Performance optimizations in exprAnalyze() (check-in: 6d60cf540b user: drh tags: isnotnull-opt) | |
| 17:54 | Always enable the IS NOT NULL optimization, even if STAT4 is not enabled. (check-in: fc98218cf6 user: drh tags: isnotnull-opt) | |
| 16:02 | Fix a problem caused by using an SQL variable in an OVER clause within a trigger program. Edit: The problem appears to have existed ever since window functions landed on trunk (check-in [17198a1206e2fbc9]) on 2018-06-30, version 3.25.0. (check-in: 02264ab6a0 user: dan tags: trunk) | |
| 15:40 | Fix a problem caused by using an SQL variable in an OVER clause within a trigger program. (Closed-Leaf check-in: 4f676466e6 user: dan tags: fix-over-trigger) | |
|
2021-01-20
| ||
| 23:01 | Improvements to the auxiliary "main.mk" makefile so that it works better with multi-threaded builds. (check-in: d1873054d8 user: drh tags: trunk) | |
| 15:10 | Incorporate the 3.34.1 patches into the reuse-schema branch. (Leaf check-in: cc0e582854 user: drh tags: reuse-schema-3.34) | |
| 14:10 | Version 3.34.1 (Leaf check-in: 10e20c0b43 user: drh tags: release, patch, version-3.34.1, branch-3.34) | |
| 10:59 | Add tests for sqlite3session_memory_used() interface. (check-in: 5596611f96 user: dan tags: trunk) | |
|
2021-01-19
| ||
| 20:38 | Fix an issue with sha3_query() when the first argument contains blank SQL statements. (check-in: a1a7a5f238 user: drh tags: branch-3.34) | |
| 20:17 | Bump the version number to 3.34.1. (check-in: cea7d0f8a3 user: drh tags: branch-3.34) | |
| 20:09 | Fix a problem handling sub-queries with both a correlated WHERE clause and a "HAVING 0" clause where the parent query is itself an aggregate. The problem was apparently introduced by check-in [6e6b3729e0549de0] (check-in: 30a4c32365 user: drh tags: branch-3.34) | |
| 20:04 | Prevent potential segfault in the sqlite-expert idxPopulateStat1 context cleanup code. (check-in: 69e31d52b2 user: drh tags: branch-3.34) | |
|
2021-01-18
| ||
| 19:28 | Fix harmless compiler warnings seen with MSVC. (check-in: dc7938d2d7 user: mistachkin tags: trunk) | |
| 19:27 | Update test helper procedure 'get_pwd' to handle the ComSpec environment variable being absent. (check-in: fe1979552f user: mistachkin tags: trunk) | |
| 12:35 | Enhance the query planner so that it is able to code EXISTS operators in the WHERE clause as if they were IN operators, when appropriate. (check-in: c1862abb44 user: drh tags: trunk) | |
| 00:11 | More comments on the EXISTS-to-IN optimization logic. (Closed-Leaf check-in: 92cc29099f user: drh tags: exists-to-in) | |
|
2021-01-17
| ||
| 00:13 | Minor simplification of the EXISTS-to-IN logic. (check-in: cac90a9f4a user: drh tags: exists-to-in) | |
|
2021-01-16
| ||
| 20:22 | Improved handling of vector equalities in the EXISTS-to-IN translator. (check-in: ef49ee4a37 user: drh tags: exists-to-in) | |
| 18:55 | Give the EXISTS-to-IN optimization the ability to handle some cases that involve vector comparisons, instead of throwing a mysterious error in those cases. (check-in: 87e78a19bb user: drh tags: exists-to-in) | |
| 18:22 | Add debugging output about the EXISTS-to-IN optimization when the ".wheretrace" flag has the 0x20 bit set. (check-in: 0dad5ce34a user: drh tags: exists-to-in) | |
| 12:15 | Fix a hyperlink in the Lemon documentation. (check-in: 2ffb2ffa0e user: drh tags: trunk) | |
|
2021-01-15
| ||
| 17:51 | Add OOM injection tests for new code on this branch. (check-in: 9a181dbaed user: dan tags: exists-to-in) | |
| 16:37 | Update header comments for routines added by this branch. (check-in: 950030d679 user: dan tags: exists-to-in) | |
| 15:32 | Ensure the EXISTS->IN transformation preserves the collation sequence of the comparison operation. (check-in: a373baae12 user: dan tags: exists-to-in) | |
| 15:21 | Fix a potential NULL pointer dereference following OOM. (check-in: 8ce3cb9096 user: drh tags: exists-to-in) | |
| 15:17 | Add a new optimizer disabling bit to close off the exists-to-in optimization, for testing purposes. (check-in: a80c9a076d user: drh tags: exists-to-in) | |
| 14:25 | Small performance improvement in the EXISTS-to-IN translator for the common case where the EXISTS operator is not found in the WHERE clause. (check-in: dcb7772d76 user: drh tags: exists-to-in) | |
| 14:15 | Merge the latest trunk enhancements into the exists-to-in branch. (check-in: 13c4c9088c user: drh tags: exists-to-in) | |
| 11:39 | Add simple tests (and a fix) for the change on this branch. (check-in: 897f3f4026 user: dan tags: exists-to-in) | |
|
2021-01-14
| ||
| 20:57 | Improvements to the min/max optimization. Fix for a performance regression introduced at [b8ba2f17f938c035] reported by forum post 4050026ab8 (check-in: 249a71cc68 user: drh tags: trunk) | |
| 20:50 | Allow the planner to convert an EXISTS(SELECT...) expression in a WHERE clause to the equivalent IN(...) expression in situations where this is possible and advantageous. (check-in: 9f90a88221 user: dan tags: exists-to-in) | |
| 00:53 | The early-out of the inner loop on the min/max optimization was overly aggressive for the cases where there is a join and outer loops contain IN operators. Fix this. Test case in TH3. (Closed-Leaf check-in: ccd3bae14b user: drh tags: minmax-opt-exp) | |
|
2021-01-13
| ||
| 21:05 | Fix a harmless compiler warning. (check-in: 83ec01e38c user: drh tags: minmax-opt-exp) | |
| 19:28 | Expand the number of optimization-disable bits from 16 to 32. Use one of the new bits to disable the min/max optimization, so that we can more easily verify that we get the same answer both with and within that optimization. (check-in: fd0c9a123b user: drh tags: minmax-opt-exp) | |
| 15:23 | Further enhancements to the min/max optimization of check-in b8ba2f17f938c035 to fix the performance regression identified by forum post 4050026ab8. (check-in: 188772a1db user: drh tags: minmax-opt-exp) | |
| 12:59 | cli: Omit surplus whitespace at the end of lines in .explain output. (check-in: 11e4eb0957 user: drh tags: trunk) | |
| 11:44 | In the .selecttrace output, show the ORDER BY clause added by the Min/Max optimization. (check-in: db0ecfe664 user: drh tags: trunk) | |
|
2021-01-12
| ||
| 20:16 | Lexer and grammar rules for a RETURNING clause on DELETE/INSERT/UPDATE. Actually making this work, though, will involve a lot more code which will likely slow down processing for the common case where there is no RETURNING clause. Furthermore, RETURNING seems to be of limited usefulness and it is not standard SQL. So we abandon it here. These experimental changes are parked in a branch as an historical reference. If circumstances changes, we might take up the cause again some day. (check-in: abf8da8156 user: drh tags: returning) | |
| 16:26 | Merge the ParseCleanup enhancement to trunk. (check-in: 35824c1bcb user: drh tags: trunk) | |
| 15:30 | Fix a potential use-after-free following an OOM in sqlite3ParserAddCleanup() and add a mechanism to detect situations where this might occur in the future. (Closed-Leaf check-in: 38ef8ab983 user: drh tags: parse-cleanup) | |
| 14:23 | Rerun autoconf. (check-in: 8f3ab5da4c user: drh tags: trunk) | |
| 14:19 | Fix for the top-level configure script so that it works with tcl 8.7. (check-in: 4810f814ff user: dan tags: trunk) | |
|
2021-01-11
| ||
| 20:37 | Add a linked list of ParseCleanup objects to the end of a Parse object and use that list as a place to put other sub-objects that need to be deallocated. Have a single such list for infrequently used sub-objects is more efficient than doing an a separate check for each kind of sub-object. Edit: Now possible to have use-after-free following an OOM. (check-in: affa2b7b31 user: drh tags: parse-cleanup) | |
|
2021-01-09
| ||
| 19:10 | New CLI command: ".stats vmstep" enables the display of the virtual-machine step count only, after each command. Useful for optimization problems. (check-in: 49dfce469e user: drh tags: trunk) | |
| 18:24 | More detailed compile-time testing before attempting to use atomic load intrinsics. See forum post fc0237a39b30ac0a. (check-in: 5204c2c4a7 user: drh tags: trunk) | |
|
2021-01-08
| ||
| 19:53 | Fix an issue with sha3_query() when the first argument contains blank SQL statements. (check-in: 24baab9a9f user: drh tags: trunk) | |
|
2021-01-07
| ||
| 16:59 | Update cksumvfs to check that the xCurrentTimeGetInt64 method of the underlying VFS is not NULL before invoking it. (check-in: c71f6cadcc user: dan tags: trunk) | |
| 16:29 | Fix problems with some "crashsql" tests. (check-in: 0c8e2ede5c user: dan tags: trunk) | |
| 16:10 | Fix harmless typos in comments per forum post 7849e58dd5 (check-in: d1e22e2f76 user: drh tags: trunk) | |
|
2021-01-04
| ||
| 18:28 | Add extra test for handling of embedded nul characters in the fts4 unicode61 tokenizer. (check-in: c2c2c7e945 user: dan tags: trunk) | |
|
2021-01-02
| ||
| 23:56 | In Lemon, factor the parser stack overflow detection logic out of the yy_reduce() subroutine and into the main parser routine, so that when overflow is detected, it can exit immediately. This saves a single conditional in the main loop of the parser. (check-in: 203c049c66 user: drh tags: trunk) | |
|
2021-01-01
| ||
| 22:06 | Avoid allocating space to hold the prepared statements for CREATE statements when parsing the schema of an existing database, since those prepared statements are never used.. This helps to make startup faster, (check-in: d01e9f2d00 user: drh tags: trunk) | |
| 21:02 | Faster and smaller test to ensure that the sqlite_schema.sql field is always a CREATE statement of some kind. (check-in: 76de2bb04b user: drh tags: trunk) | |
| 20:04 | Change the unions of the Table.addColOffset field from characters to bytes. This makes the query that implements ALTER TABLE ADD COLUMN more complex and slightly slower, but also makes CREATE TABLE statement parsing faster by avoiding a call to sqlite3UtfCharLen(). Since, CREATE TABLE parsing is far more common than ALTER TABLE, this is a net win for performance. (check-in: 6f25f2529f user: drh tags: trunk) | |
| 19:17 | Use the column name hash to improve performance of column name collision detection while parsing CREATE TABLE statements. (check-in: d02820f035 user: drh tags: trunk) | |
| 18:32 | Modify the makefile rule for "startup" so that it always builds with -Os and -DSQLITE_THREADSAFE=0 and no other options, for consistency of performance. (check-in: 5ac939e0ad user: drh tags: trunk) | |
| 18:23 | Size reduction and performance increase in sqlite3Prepare(). (check-in: 41f45c8e89 user: drh tags: trunk) | |
| 17:01 | Small size reduction and performance improvement in sqlite3VdbeMakeReady() by linking the new prepared statement into the prepared statement list sooner rather than later. (check-in: 2996e800a0 user: drh tags: trunk) | |
| 16:43 | Streamline processing of the authenticator callback for the common case when there is no callback. (check-in: d3196685d9 user: drh tags: trunk) | |
| 15:13 | Add the "startup" test program designed to measure startup performance, and in particular schema parsing time. (check-in: 7b3b31efb0 user: drh tags: trunk) | |
| 01:44 | Do not attempt to take a pointer to the ceil() and floor() functions as those routines are intrinsics on some versions of MSVC. (check-in: e5d7209e11 user: drh tags: trunk) | |
|
2020-12-30
| ||
| 13:20 | New test case for the HAVING fix of check-in [f62f983b56623f0e]. (check-in: 45f46317ab user: drh tags: trunk) | |
| 13:10 | New test cases for cursor renumbering in the UNION ALL query flattener. (check-in: 270babf259 user: drh tags: trunk) | |
|
2020-12-29
| ||
| 16:48 | Add an ALWAYS on an always-true conditional in the cursor renumbering logic of the UNION ALL flattener. Edit: turns out this change is incorrect and the conditional is reachable after all. See the nearby trunk check-in for test cases. (Closed-Leaf check-in: 5774318e73 user: drh tags: mistake) | |
| 15:06 | Do not set the P3 parameter on OP_RowCell when copying an index btree, as P3 is not used in that case. (check-in: eef070a4aa user: drh tags: trunk) | |
|
2020-12-28
| ||
| 21:42 | Fix missing comma in ctime.c that would cause the ENABLE_MATH_FUNCTIONS output rw to merge with whatever row followed. Problem reported in forum post aacac97680. (check-in: 328bc4a01d user: drh tags: trunk) | |
|
2020-12-23
| ||
| 16:46 | Add the sqlite3session_memory_used() API to the sessions module. For querying the amount of heap memory currently being used by a session object. (check-in: 823f75c2e4 user: dan tags: trunk) | |
|
2020-12-22
| ||
| 20:35 | Fix SQLITE_OMIT_WINDOWFUNC builds by moving declaration of sqlite3ExpandSubquery out of "ifndef SQLITE_OMIT_WINDOWFUNC" block. (check-in: 9587fa8b29 user: dan tags: trunk) | |
| 19:57 | Fix a couple spelling typos in comments. (check-in: 907ddf8676 user: mistachkin tags: trunk) | |
| 16:23 | Fix a problem handling sub-queries with both a correlated WHERE clause and a "HAVING 0" clause where the parent query is itself an aggregate. The problem was apparently introduced by check-in [6e6b3729e0549de0] (check-in: f62f983b56 user: dan tags: trunk) | |
| 14:54 | Simplification to the aggregate-function analysis error detection logic at the end of sqlite3Select(). (check-in: 82884438e3 user: drh tags: trunk) | |
|
2020-12-21
| ||
| 19:50 | Fix problems with joining UNION ALL sub-queries against other sub-queries that contain LEFT JOIN. (check-in: d554f710a5 user: dan tags: trunk) | |
| 18:39 | Fix a problem when flattening joins between a UNION ALL sub-query and another sub-query that uses more than one window function. (check-in: ef9733fe1c user: dan tags: trunk) | |
| 14:51 | Enhance documentation to show that "ro" is the correct way to say "readonly" in the mode= query parameter. (check-in: 788b96851d user: drh tags: trunk) | |
| 12:14 | Add the --timer option to fuzzcheck. Get the --timeout option working in fuzzcheck when running dbsql tests. (check-in: 3b0c9b41a8 user: drh tags: trunk) | |
|
2020-12-20
| ||
| 14:51 | Always declare the sqlite3WhereTrace variable, even for non-debug builds. (check-in: 88d93ee380 user: drh tags: trunk) | |
|
2020-12-19
| ||
| 15:39 | Fix a broken assert() in fts5 that could be triggered by corrupt database records. (check-in: b79f59f9ad user: dan tags: trunk) | |
| 13:58 | Allow UNION ALL sub-queries to be flattened even if the parent query is a join. (check-in: df1d6482f9 user: drh tags: trunk) | |
|
2020-12-18
| ||
| 18:04 | Fix for the previous fix in the case where a UNION ALL sub-query is joined against some other compound query. (Closed-Leaf check-in: 63c5cfb9ae user: dan tags: union-all-flattener) | |
| 16:13 | When flattening UNION ALL subqueries into a join query, ensure that separate cursor numbers are used for each segment of the newly flattened query. (check-in: c510377b0b user: dan tags: union-all-flattener) | |
|
2020-12-17
| ||
| 17:17 | Fix a part of the header comment for flattenSubquery(). (check-in: dc0937ce9d user: dan tags: union-all-flattener) | |
| 16:48 | Add test cases and minor fixes to this branch. (check-in: 5d6dc29d5f user: dan tags: union-all-flattener) | |
| 15:17 | In the CLI, add the ".filectrl data_version" command. And put the various ".filectrl" subcommands in alphabetical order. (check-in: 3434452148 user: drh tags: trunk) | |
| 11:30 | Merge latest trunk changes into this branch. (check-in: 9f41f60405 user: dan tags: reuse-schema) | |
| 11:24 | Fix a problem with sqlite3_expanded_sql() that could occur with statements that use both numbered (e.g. "?1") and unnumbered (i.e. "?") parameters. (check-in: 2a6cd6833e user: dan tags: trunk) | |
|
2020-12-16
| ||
| 21:09 | Enhance the sqlite3BtreeTransferRow() routine so that it does more careful checks for corrupt database pages. (check-in: 85952e7117 user: drh tags: trunk) | |
| 20:00 | Allow sub-queries that use UNION ALL to be flattened, even if the parent query is a join. Still some problems on this branch. (check-in: 00e4bf74d3 user: dan tags: union-all-flattener) | |
| 14:20 | Remove an unnecessary and incorrect #ifdef. Fix harmless compiler warnings. (check-in: 31cd1bbfa5 user: drh tags: trunk) | |
| 13:20 | Fix a typo in the sqlite3_free_filename() documentation. (check-in: 7316ee19c5 user: drh tags: branch-3.34) | |
| 13:17 | Fix a typo in the sqlite3_free_filename() documentation. (check-in: 48301edc90 user: drh tags: trunk) | |
|
2020-12-15
| ||
| 19:27 | Fix another integer overflow triggered by a corrupt database in recently modified vacuum code. (check-in: 4e2dd2a533 user: dan tags: trunk) | |
| 16:28 | When the -statstep option is passed to the "rbu" executable, print out memory stats right before exiting, as well as every -statstep steps. (check-in: 94f81b5117 user: dan tags: trunk) | |
| 13:55 | Change an fts5 assert() that can be triggered by a corrupt database to an if() condition. (check-in: ea0a7f103a user: dan tags: trunk) | |
|
2020-12-14
| ||
| 16:50 | Merge the latest trunk enhancements into the begin-concurrent-pnu branch. (check-in: daf0465021 user: drh tags: begin-concurrent-pnu) | |
| 16:26 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: a1708e8457 user: drh tags: begin-concurrent) | |
| 15:39 | Enhance UPSERT so that it allows multiple ON CONFLICT clauses and does not require a conflict target for DO UPDATE. (check-in: 6b01a24daa user: drh tags: trunk) | |
| 15:25 | Fix an integer overflow problem in new VACUUM code. (check-in: 59b4367fd8 user: dan tags: trunk) | |
| 13:52 | Minor changes for test coverage. (Closed-Leaf check-in: e5a8fa50f4 user: drh tags: generalized-upsert) | |
|
2020-12-12
| ||
| 00:43 | More test cases. No new problems discovered. (check-in: f34dd67e2d user: drh tags: generalized-upsert) | |
| 00:28 | New test cases with corresponding bug fixes. (check-in: f22c21a94c user: drh tags: generalized-upsert) | |
|
2020-12-11
| ||
| 19:36 | Begin adding test cases. Fix one bug found so far. More are pending. (check-in: aadd67ddf2 user: drh tags: generalized-upsert) | |
| 19:01 | Fix an assert() broken by recent changes to vacuum. (check-in: dd058da85c user: dan tags: trunk) | |
| 17:11 | Small performance tweaks. (check-in: 5321d60c57 user: drh tags: generalized-upsert) | |
| 16:49 | Bug fixes so that legacy tests pass. New tests for new functionality have not yet been added. (check-in: aa76790e58 user: drh tags: generalized-upsert) | |
| 16:03 | Add an "#ifndef SQLITE_AMALGAMATION" block around the typedef for u64 in shathree.c. (check-in: b411f29e1a user: dan tags: trunk) | |
| 14:34 | Fix the configure script on the autoconf distribution so that the --disable-threadsafe option works. See FreeBSD bug 244459. (check-in: e64ff2cce3 user: drh tags: trunk) | |
| 14:22 | Fix the expert extension so that it handles generated columns correctly. (check-in: c2ae7ba6f8 user: dan tags: trunk) | |
| 01:17 | Logic is in place to handle multiple ON CONFLICT clauses, but it does not work. Any use of ON CONFLICT will likely lead to memory faults. This is an incremental check-in to save my place. (check-in: 155142314f user: drh tags: generalized-upsert) | |
|
2020-12-10
| ||
| 20:31 | Use an iterator for the index loop in sqlite3GenerateConstraintChecks(). The idea is that this iterator can be enhanced to traverse the indexes in any order, as required by multi-index UPSERT. (check-in: 64a4a91ecc user: drh tags: generalized-upsert) | |
| 19:54 | Remove a redundant branch added by [56a54258560]. (check-in: b4d6f6d728 user: dan tags: trunk) | |
| 19:51 | Changes to avoid loading large records into memory within VACUUM. (check-in: 56a5425856 user: dan tags: trunk) | |
| 19:20 | Fix minor issues with new code on this branch. (Closed-Leaf check-in: f7fa76d096 user: dan tags: vacuum-lomem) | |
| 18:07 | Merge trunk changes into this branch. (check-in: 7337eed629 user: dan tags: vacuum-lomem) | |
| 18:06 | Better integrate the changes on this branch with OP_Insert and OP_IdxInsert. (check-in: 101cef1491 user: dan tags: vacuum-lomem) | |
| 13:49 | Add an optional function to the chsumvfs extension. When activated by the SQLITE_CKSUMVFS_INIT_FUNCNAME macro, this function will invoke the file-control that sets the number of reserved bytes to 8. This can be used to initialize a cksumvfs database file by programming languages that do not have access to the sqlite3_file_control() interface. (check-in: 01841fb4bf user: drh tags: trunk) | |
| 12:49 | The DO UPDATE code generator searches for the correct ON CONFLICT clause to use. (check-in: a47e35ee2d user: drh tags: generalized-upsert) | |
|
2020-12-09
| ||
| 23:35 | Fix compilation issues with MSVC related to C99. (check-in: c0de6c1fb2 user: mistachkin tags: trunk) | |
| 20:33 | Transfer large index or WITHOUT ROWID records between b-trees when vacuuming without loading them into memory. (check-in: dfd4ca6891 user: dan tags: vacuum-lomem) | |
| 20:30 | For upsert, the constraint check code generator uses a copy of the index list for the target table, which can potentially be reordered. (check-in: 3194c00c2c user: drh tags: generalized-upsert) | |
| 16:49 | Add tests for a 'delete' command on a contentless table where values that weren't actually inserted are NULL. (check-in: 818c647cec user: dan tags: trunk) | |
| 16:32 | Avoid loading large intkey rows when VACUUMing, even if the page-size is changing. (check-in: 0d2c377606 user: dan tags: vacuum-lomem) | |
| 13:11 | Improved comments in sqliteInt.h. No changes to code. (check-in: 8ccb8d1d55 user: drh tags: generalized-upsert) | |
| 01:34 | Initialize all terms in the ON CONFLICT clause stack. (check-in: 5e683fd1cb user: drh tags: generalized-upsert) | |
|
2020-12-08
| ||
| 20:19 | Experimental changes to vacuum to avoid loading large records entirely into memory. Currently only works in limited cases only - for rowid tables when the page-size does not change. (check-in: c90e063ca9 user: dan tags: vacuum-lomem) | |
| 14:29 | Enhance UPSERT parsing to allow multiple ON CONFLICT clauses. Only the very last clause may omit the conflict target, but the conflict target may now be omitted for the DO UPDATE resolution. (check-in: 2ca62f4c71 user: drh tags: generalized-upsert) | |
|
2020-12-07
| ||
| 23:14 | Fix a bad assert() in math1Func(). (check-in: 4b28612913 user: drh tags: trunk) | |
| 21:19 | Fix to the --disable-math option to ./configure. (check-in: 99ff641849 user: drh tags: trunk) | |
| 21:13 | Many more math functions. Semantics follows PG wherever possible. (check-in: 6b93627b5d user: drh tags: trunk) | |
| 17:15 | Begin adding new SQL functions that depend on -lm: ceil(), ceiling(), floor(), ln(), log(), and log10() so far. More to follow. (check-in: 4db5f2f787 user: drh tags: trunk) | |
|
2020-12-04
| ||
| 18:47 | Update this branch with latest trunk changes. (check-in: 846e8444f7 user: dan tags: reuse-schema) | |
| 17:05 | Fix harmless compiler warnings associated with the recent FTS5 enhancements. (check-in: 1db7c75191 user: drh tags: trunk) | |
| 16:58 | Fix a bug in the ".eqp" command of the shell that was introduced by the recent sqlite3SelectTrace/SQLITE_TESTCTRL_TRACEFLAGS changes. (check-in: fd02dffceb user: drh tags: trunk) | |
| 16:49 | Ensure that fts5 function matchinfo() is registered before running tests that use it in fts5corrupt3.test. (check-in: 932e05e093 user: dan tags: trunk) | |
| 16:26 | Fix a test script problem in walvfs.test. (check-in: 4c5076fbe4 user: dan tags: trunk) | |
| 16:25 | Fix an incorrect datatype no the sqlite3WhereTrace variable in test1.c. (check-in: 4e6dab30f6 user: drh tags: trunk) | |
| 16:09 | Eliminate the sqlite3_unsupported_selecttrace global variable by creating a new test-control to control SELECT tracing. Note that SELECT tracing is only available on debug builds. (check-in: fb07c4e3c7 user: drh tags: trunk) | |
| 16:04 | Further changes to the trace variables to try to eliminate (harmless) compiler warnings in all configurations. (Closed-Leaf check-in: 3a4c98b989 user: drh tags: traceflags-test-control) | |
| 01:17 | Alternative implementation of ".selecttrace" and ".wheretrace" that uses a test-control rather than global variables. (check-in: d36d6f2923 user: drh tags: traceflags-test-control) | |
|
2020-12-03
| ||
| 21:22 | When merging prefix lists in fts5, use 16-way merges instead of 2-way merges. This faster. (check-in: 026a93508e user: dan tags: trunk) | |
| 19:25 | Do not simulate OOM faults on the SQLITE_FCNTL_CKPT_START and SQLITE_FCNTL_CKPT_DONE file-controls, as those are write-only and the return value is always ignored. (check-in: 62a2d39483 user: drh tags: trunk) | |
| 14:21 | Enhance the generate_series() table-valued function to support negative step values. (check-in: 9b60fc4870 user: drh tags: trunk) | |
|
2020-12-02
| ||
| 20:07 | Prevent potential segfault in the sqlite-expert idxPopulateStat1 context cleanup code. (check-in: c24f13448b user: mistachkin tags: trunk) | |
| 19:08 | Allow a search for an N character prefix in fts5 to use a prefix index of size N+1, if no prefix index of size N exists. (check-in: 78a7801d8f user: dan tags: trunk) | |
| 18:27 | Fix the ".open" command in the CLI so that it accepts command-line options both before and after the filename. (check-in: d330bf0c02 user: drh tags: trunk) | |
| 16:23 | Improve performance for fts5 column filters that filter for more than one column. e.g. "{col1 col2 col3}:phrase". (check-in: d8de2f236d user: dan tags: trunk) | |
| 02:58 | Parameterize the hash function in mkkeywordhash.c. This was an attempt to find a better hash function, which turned out to not be successful. (check-in: 2195d731f5 user: drh tags: trunk) | |
| 00:22 | Increase the version number to 3.35.0 to begin the next development cycle. (check-in: edbabaa308 user: drh tags: trunk) | |
| 00:20 | Slightly faster tokenization of non-keyword identifiers. (check-in: 55fa22bd40 user: drh tags: trunk) | |
|
2020-12-01
| ||
| 23:18 | Add the --lookaside SIZE COUNT command-line option to the dbfuzz2 testing tool. (check-in: 2466960c0b user: drh tags: trunk) | |
| 16:36 | Merge the 3.34.0 release into the reuse-schema branch. (check-in: 73b5f614cd user: drh tags: reuse-schema) | |
| 16:14 | Version 3.34.0 (check-in: a26b6597e3 user: drh tags: trunk, release, major-release, version-3.34.0) | |
|
2020-11-30
| ||
| 18:52 | Update the tea/win/makefile.vc file that ships as part of the autoconf package to use "sqlite3" instead of "tclsqlite3" for the installed dll filename. (check-in: 23212b1a05 user: dan tags: trunk) | |
| 18:43 | Update the tea/win/makefile.vc file that ships as part of the autoconf package to use "sqlite3" instead of "tclsqlite3" for the installed dll filename. (Closed-Leaf check-in: 93d4d9dc05 user: dan tags: win-tea-fix) | |
| 14:20 | Do not reuse the obsolete SQLITE_TESTCTRL_PRNG_RESET value for SQLITE_TESTCTRL_SEEK_COUNT. Give SEEK_COUNT its own unique value. This avoids incompatibility with legacy test code. (check-in: fdba0b1290 user: drh tags: trunk) | |
|
2020-11-27
| ||
| 20:56 | Improve the speed of the tokenizer by recognizing that tokens starting with letters "_", "Y", or "Z" can never be SQL keywords and must be ordinary identifiers. (Closed-Leaf check-in: 16e281ed62 user: drh tags: faster-tokenizer) | |
| 19:40 | Fix a compiler warning in fts5_aux.c. (check-in: 8edb983bc8 user: dan tags: trunk) | |
| 16:15 | Add missing cast to fts5 bm25() code. (check-in: 6ff9673847 user: dan tags: trunk) | |
| 16:08 | Remove a redundant "if( rc==SQLITE_OK )" from the fts5 bm25() code. (check-in: d85f4f27f5 user: dan tags: trunk) | |
| 16:05 | Move an "if( rc==SQLITE_OK )" to outside a loop body in the fts5 bm25() code. (check-in: 14a4dcf347 user: dan tags: trunk) | |
| 15:28 | Fix a case in the FTS5 integrity check where a corrupt database could cause a buffer overread. (check-in: a32b4f650d user: dan tags: trunk) | |
|
2020-11-26
| ||
| 20:13 | Update mkunicode.tcl to match the change erroneously made to machine generated file fts5_unicode2.c in [b7b7bde9]. (check-in: 326d579d77 user: dan tags: trunk) | |
| 18:41 | Merge latest changes from wal2 branch. (check-in: b451bb724e user: dan tags: begin-concurrent-pnu-wal2) | |
| 18:08 | Merge latest trunk changes into this branch. (check-in: cb1f6f18e7 user: dan tags: wal2) | |
| 17:54 | Merge latest changes from begin-concurrent-pnu into this branch. (check-in: d2de81a24f user: dan tags: begin-concurrent-report) | |
| 17:36 | Merge latest changes from trunk into this branch. (check-in: a42e6f34f5 user: dan tags: begin-concurrent-pnu) | |
| 11:37 | Update this branch with latest changes from trunk. (check-in: ddb97eeef7 user: dan tags: begin-concurrent) | |
|
2020-11-25
| ||
| 20:29 | Merge trunk changes into this branch. (check-in: f4b7c10057 user: dan tags: reuse-schema) | |
| 18:44 | Update a requirement mark in the e_expr.test script. (check-in: bb174a074b user: drh tags: trunk) | |
| 16:28 | Fix harmless compiler warnings about unused function parameters. (check-in: 25d067c270 user: drh tags: trunk) | |
| 15:29 | Fix a potential NULL pointer dereference in the geopoly_overlap() routine of the GeoPoly extension. (check-in: b5665712e6 user: drh tags: trunk) | |
| 14:50 | Fix the shell1.test test script so that it works on windows. (check-in: 9bd15b07e5 user: drh tags: trunk) | |
| 13:59 | Change the -init option to the command-line shell to honor the -bail option. Also change it to report an error if the filename mentioned cannot be opened. (check-in: a29f54bd2c user: drh tags: trunk) | |
|
2020-11-24
| ||
| 23:40 | Fix a typo in the sqlite3_txn_state() documentation. (check-in: 5b4325295b user: drh tags: trunk) | |
| 21:19 | Add the new sqlite3_txn_state() interface to the set of routines accessible by run-time loadables extensions. (check-in: db25f1dc8e user: drh tags: trunk) | |
| 19:55 | Fix a harmless typo in a comment. (check-in: b2a201f1b5 user: drh tags: trunk) | |
| 17:55 | Fix a bug in OOM handling code introduced by [6a28713d]. (check-in: 8a786ce994 user: dan tags: trunk) | |
| 16:44 | Ensure that super-journal and other journal filenames passed by SQLite to an sqlite3_vfs.xOpen() implementation may be safely passed to sqlite3_uri_parameter() and similar functions. (check-in: 6a28713d59 user: dan tags: trunk) | |
| 13:14 | Remove the VERSION_NUMBER macro from configure.ac as it has been unused since 2009 check-in [7f4810747b086498]. See also forum post bb2c634fcd. (check-in: 5466dd55d4 user: drh tags: trunk) | |
|
2020-11-23
| ||
| 21:05 | Syntactic changes to work around a bug in gcov 9.3.0. No changes to the generated code for release builds. (check-in: 4f1573b146 user: drh tags: trunk) | |
| 17:36 | In os_unix.c, put ALWAYS() on unreachable branches associated with pathname normalization. (check-in: b45a08e3c7 user: drh tags: trunk) | |
| 15:30 | Fix a test script problem causing crash8.test to fail when run with leak-sanitizer. (check-in: 2c437f7a2c user: dan tags: trunk) | |
| 14:50 | Allow "substring()" as an alias for "substr()" for compatibility with other SQL engines. (check-in: aa2ee5754c user: drh tags: trunk) | |
|
2020-11-20
| ||
| 14:16 | Add file doc/vdbesort-memory.md, containing notes on the way vdbesort.c uses heap memory. (check-in: 07f53899a9 user: dan tags: trunk) | |
|
2020-11-19
| ||
| 21:12 | The xFullPathname method of the unix VFS now normalizes the filenames by omitting surplus "/", "/./" and "/../" strings. (check-in: c38dec6f52 user: drh tags: trunk) | |
| 21:01 | More test case changes so that shared-cache mode tests all work with normalized database names. (Closed-Leaf check-in: 6f0d5f0949 user: drh tags: stronger-nofollow) | |
| 20:07 | Fix the tkt3793 test case so that work even when filenames are normalized. (check-in: e85d32ac6c user: drh tags: stronger-nofollow) | |
| 19:43 | Use an ephemeral table rather than a RowSet to remember rowids in the two-pass UPDATE algorithm, as this uses much less memory for large UPDATEs. (check-in: 842c432772 user: drh tags: trunk) | |
|
2020-11-18
| ||
| 23:44 | If a read() or pread() indicates that the database file is unreadable due to filesystem damage, then it returns SQLITE_IOERR_CORRUPTFS which is then converted into SQLITE_CORRUPT before being returned to the application. (check-in: 849e4e14fd user: drh tags: trunk) | |
| 21:50 | Improvements to the mechanism that attempts to report SQLITE_CORRUPT if pread() says that the underlying filesystem is corrupt. (Closed-Leaf check-in: b887c7504e user: drh tags: detect-corrupt-fs) | |
| 21:15 | Merge trunk changes into this branch. (check-in: 6004de525d user: dan tags: reuse-schema) | |
| 20:55 | Update cksumvfs.c so that if SQLITE_AMALGAMATION is defined, SQLITE_CKSUMVFS_STATIC is implied. (check-in: 184e9d782d user: dan tags: trunk) | |
| 18:36 | Add test infrastructure for cksumvfs. And update cksumvfs so that it works in concert with version 2 VFSs. No changes to core SQLite. (check-in: 43d4801df5 user: dan tags: trunk) | |
| 14:30 | Fix a problem causing sqlite3_carray_bind() to return an undefined value. (check-in: 083203a549 user: dan tags: trunk) | |
| 14:12 | Update test code to fix a problem with SQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: 29c779a07b user: dan tags: trunk) | |
| 12:48 | On unix, for certain error codes of read()/pread() return SQLITE_IOERR_CORRUPTFS instead of SQLITE_IOERR_READ. And then convert this error into SQLITE_CORRUPT prior to returning back to the application. (check-in: 9538ea8447 user: drh tags: detect-corrupt-fs) | |
|
2020-11-17
| ||
| 21:26 | Claw back most of the performance lost in the previous commit. (Closed-Leaf check-in: df8ce2675b user: drh tags: lowmem-update-exp) | |
| 21:09 | Fix trivial memory leaks in the shell and sqldiff programs. (check-in: 272793e5ed user: dan tags: trunk) | |
| 18:25 | Fix test file busy2.test so that it works with the "inmemory_journal" permutation. (check-in: b192fdddb6 user: dan tags: trunk) | |
| 14:41 | Add a single-argument form to the CARRAY table-valued function, with content bound using the sqlite3_carray_bind() interface that is included with the extension. (check-in: 7b229cb120 user: drh tags: trunk) | |
|
2020-11-16
| ||
| 18:45 | Enhance the unix VFS so that it removes extra "/", "/./" and "/../" from the database filename. (check-in: 7ba89d3e5c user: drh tags: stronger-nofollow) | |
|
2020-11-14
| ||
| 20:03 | Modify UPDATE so that two-pass updates on a rowid table use an ephemeral table to store rowids rather than a RowSet. This uses less memory, though it is slower. (check-in: 4673096dd8 user: drh tags: lowmem-update-exp) | |
|
2020-11-12
| ||
| 18:16 | Improved diagnostics output with ".wheretrace 0x800". No changes to non-debug builds. (check-in: 772ae83c61 user: drh tags: trunk) | |
|
2020-11-11
| ||
| 19:11 | Fix a typo in a comment. No changes to code. (check-in: 572f1ed59d user: drh tags: trunk) | |
|
2020-11-08
| ||
| 20:44 | Use NEVER and ALWAYS macros to confirm that the return value from sqlite3ExprSkipCollateAndLikely() is never NULL in some of its use cases. (check-in: 76d2eb86e1 user: drh tags: trunk) | |
|
2020-11-06
| ||
| 16:48 | Add ALWAYS() to conditionals associated with SHM locking that are always true. (check-in: b599e89076 user: drh tags: trunk) | |
|
2020-11-05
| ||
| 19:13 | Suppress errors associated with TEMP triggers that reference objects in non-TEMP databases. This is a continuation of the fix for ticket #3810 shown in check-in [ba1afc040171810d] from 2009-08-06, based on a bug report in forum post 157dc791df (check-in: 991ca9b26b user: drh tags: trunk) | |
| 14:50 | Remove unused variable from speedtest1.c (check-in: c0a18565e6 user: drh tags: trunk) | |
|
2020-11-03
| ||
| 11:54 | Make platform compilation clearer, including the section that applies to both *ix and Windows Add link to the detailed compilation instructions Add brief Android section, it seems strange to omit it since Android is the majority use case by numbers (Closed-Leaf check-in: 2a71bebfe3 user: shearer tags: docupdate) | |
| 11:27 | Update for new git-style syntax in Fossil (check-in: d46b6778b1 user: shearer tags: docupdate) | |
| 11:20 | Add links, especially for the docsrc repo, which is otherwise hard to find (check-in: e03867e2fb user: shearer tags: docupdate) | |
|
2020-11-02
| ||
| 00:40 | Fix an another OSS-Fuzz discovered assertion fault due to ALTER TABLE and strange triggers. (check-in: 6646d7898c user: drh tags: trunk) | |
|
2020-10-31
| ||
| 18:58 | Add the -tabs command-line option to the CLI. (check-in: 7d01e84dc4 user: drh tags: trunk) | |
| 16:33 | Update the ALTER TABLE command to correctly handle UPDATE ... FROM statements within trigger programs. (check-in: 3e6af89040 user: dan tags: trunk) | |
|
2020-10-27
| ||
| 11:58 | Prettify btree.h headings. Close branch. (Closed-Leaf check-in: ee9689ad2f user: shearer tags: btree-code-documentation) | |
| 11:13 | Typo in btree.h (and unwanted merge; this branch for cherrypicking btree.h only) (check-in: eb6e5fc189 user: shearer tags: btree-code-documentation) | |
| 11:07 | Final commit in btree.h reorg. No more unknowns. (check-in: ea06f1d1f9 user: shearer tags: btree-code-documentation) | |
|
2020-10-26
| ||
| 18:14 | Always create a statement journal when using the OP_ParseSchema opcode, as you never know when it might fail. See the discussion on forum post daa2c728cc. (check-in: aa512f72cf user: drh tags: trunk) | |
| 16:22 | Ensure that the table argument passed to Tcl_GetIndexFromObjStruct() in the sessions module test code is declared "static". (check-in: 80eba105d6 user: dan tags: trunk) | |
| 13:24 | Prevent fts5 tokenizer unicode61 from considering '\0' to be a token characters, even if other characters of class "Cc" are. See forum thread 09609d7e22 for details. (check-in: b7b7bde9b7 user: dan tags: trunk) | |
|
2020-10-22
| ||
| 18:50 | Minor tweaks to query planning weights so that when STAT4 is enabled and functioning, a full table scan is more likely to be selected if that seems like the fastest solution. Only do this when STAT4 info is available because an error has a large potential downside. (check-in: 0e7e113d9f user: drh tags: trunk) | |
| 18:16 | Test case updates. (Closed-Leaf check-in: 27c681c9c6 user: drh tags: avoid-bad-indexes) | |
| 15:47 | Sometimes it makes sense to do a full table scan rather than try to use an index when most of the rows will be selected. This branch is trying to tune the query planner to make that happen more often. (check-in: 0f42099ad6 user: drh tags: avoid-bad-indexes) | |
|
2020-10-20
| ||
| 14:40 | Fix the sqlite3_hard_heap_limit() so that it works with sqlite3_realloc64() in addition to sqlite3_malloc64(). Improvements to OOM processing and debugging aids in the fuzzcheck utility. (check-in: 602d736916 user: drh tags: trunk) | |
| 12:37 | Fix an assert() inside of debug-only code that can fail following an OOM. (check-in: 79da254f41 user: drh tags: trunk) | |
|
2020-10-19
| ||
| 20:49 | Fix an incorrect table ref-count in the new recursive CTE logic that might result in a reference to freed memory following a syntax error. (check-in: 75a0288871 user: drh tags: trunk) | |
| 12:35 | Enhance recursive common table expressions to support two or more recursive terms. (check-in: 77e64647ec user: drh tags: trunk) | |
| 01:44 | New test cases for recursive CTEs with multiple recursive terms. (Leaf check-in: cd5182bd6f user: drh tags: cte-enhancement) | |
| 01:23 | Allow multiple recursive terms in the compound SELECT of a recursive CTE. This facilitates writing a query to find find the connected components of an undirected graph. (check-in: 5481fa8c79 user: drh tags: cte-enhancement) | |
|
2020-10-18
| ||
| 18:35 | Fix harmless compiler warnings. (check-in: 7f8802bb7b user: mistachkin tags: trunk) | |
|
2020-10-17
| ||
| 22:13 | Fix the SQLITE_DESERIALIZE_FREEONCLOSE flag so that it works as it is documented to work. See forum post ba1dff667a (check-in: d6fac8a1d3 user: drh tags: trunk) | |
| 19:09 | Fix an incorrect printf() in debugging logic in where.c. Problem reported by forum post 80a9c47769772207. (check-in: 883da4dadc user: drh tags: trunk) | |
|
2020-10-15
| ||
| 17:59 | Minor fixes to the cksumvfs documentation in the header comment of the source file. Enhance speedtest1.c so that it can more easily do performance comparisons of cksumvfs. (check-in: ed3bb818f5 user: drh tags: trunk) | |
| 14:37 | The windows VFS accepts query parameter "exclusive=true" to cause it to take a mandatory file lock, preventing other applications from even reading the file. See forum thread 11b5560864189b5d. (check-in: 05b573fdb2 user: drh tags: trunk) | |
|
2020-10-14
| ||
| 21:31 | Enhancements to TclKit batch tool for MSVC. (check-in: 2a8a455211 user: mistachkin tags: trunk) | |
| 21:30 | Fix typo in a documentation comment. (check-in: 462adc7d6b user: mistachkin tags: trunk) | |
| 15:46 | Enhanced documentation for sqlite3_vtab_nochange() to make it clear that it is an optimization and that virtual table implementations should be prepared for it to always return false. (check-in: 3e2643619d user: drh tags: trunk) | |
|
2020-10-12
| ||
| 18:09 | Fix some fts5 problems with signed integer overflow causing segfaults in -ftrapv builds. (check-in: 7e17c2f4b7 user: dan tags: trunk) | |
| 17:57 | Improved quoting of the table name argument for the ".import" command of the CLI. See forum post 34591fefbe. (check-in: ce97b56d63 user: drh tags: trunk) | |
| 16:54 | Add options --data-only and --nosys to the ".dump" command in the CLI. (check-in: 57123b14a7 user: drh tags: trunk) | |
| 15:27 | Fix ALTER TABLE so that it can run even if the schema contains unknown collation sequences. (check-in: bc4bb9433f user: dan tags: trunk) | |
| 14:56 | Add the --nosys option to the .schema command in the CLI. (check-in: b72ee69453 user: drh tags: trunk) | |
| 14:29 | Fix UPDATE FROM statements on virtual tables that are declared WITHOUT ROWID. See forum post 0fee7951eb for more information. (check-in: bcb0bc6a7b user: dan tags: trunk) | |
| 13:24 | Fix BEGIN IMMEDIATE and BEGIN EXCLUSIVE so that they work even if one or more of the database files in the connection are read-only. Test cases for this are in TH3. (check-in: 2fa08c3963 user: drh tags: trunk) | |
|
2020-10-07
| ||
| 11:24 | In the CSV extension, use SQLITE_TRANSIENT rather than SQLITE_STATIC on return values that can in fact change. (check-in: 54b54f02c6 user: drh tags: trunk) | |
|
2020-10-06
| ||
| 15:48 | More additions and improvements to btree.h documentation (check-in: a49a7cdec7 user: shearer tags: btree-code-documentation) | |
|
2020-10-05
| ||
| 16:41 | Allow fts5 trigram tables created with detail=column or detail=none to optimize LIKE and GLOB queries. Allow case-insensitive tables to optimize GLOB as well as LIKE. (check-in: 64782463be user: dan tags: trunk) | |
|
2020-10-03
| ||
| 19:16 | Do not apply affinities when creating entries for automatic indexes on views. Fix for [95302bdb]. (check-in: df12f09722 user: dan tags: trunk) | |
| 17:06 | Fix a segfault caused by running "column LIKE NULL" against an fts5 table using the trigram tokenizer. Fix for [e33ee62575fc22]. (check-in: 6e72a08de7 user: dan tags: trunk) | |
| 14:36 | FTS5 does not handle tokens that contain embedded nul characters. Prevent the trigram tokenizer from returning such tokens. Fix for [2ba5930b2]. (check-in: b1d048748c user: dan tags: trunk) | |
|
2020-10-02
| ||
| 15:15 | Fix some test code so that testfixture can build with SQLITE_OMIT_WAL defined. (check-in: dd009cd7ae user: dan tags: trunk) | |
| 13:48 | Additional corner-case fixes for the in-scan-vs-index or OP_SeekScan optimization. (check-in: ad5ab24ebd user: drh tags: trunk) | |
| 12:49 | Remove an incorrect assert() from the OP_SeekScan opcode. (check-in: c0400f8c0b user: drh tags: trunk) | |
| 12:42 | Fix a faulty assert() statement. Add new test cases. (check-in: 80ecdb3da4 user: drh tags: trunk) | |
| 11:55 | For the OP_SeekScan optimization, the OP_IdxGT does not necessarily come right after the OP_SeekGE. So use the P2 operand of OP_SeekScan to point to the first instruction after OP_IdxGT. Problem found by dbsqlfuzz. (check-in: 091d719394 user: drh tags: trunk) | |
| 02:02 | Disable the OP_SeekScan opcode of the in-scan-vs-index optimization when in PRAGMA reverse_unordered_selects mode, as the OP_SeekScan only works with forwards scans. Thanks to OSSFuzz for pointing out the problem to us. (check-in: c75c3a3b75 user: drh tags: trunk) | |
|
2020-10-01
| ||
| 17:24 | Add experimental "trigram" tokenizer to fts5. (check-in: c4e8ec7907 user: dan tags: trunk) | |
| 17:15 | Add the -trigram option to the fts5txt2db.tcl script. (Closed-Leaf check-in: a394dd2602 user: dan tags: fts5-trigram) | |
| 16:10 | Add tests for the trigram tokenizer. Fix minor issues. (check-in: 897ced99b4 user: dan tags: fts5-trigram) | |
| 15:46 | Fix the OP_SeekScan opcode so that its variable names do not cause problems for the test/vdbe-compress.tcl script. (check-in: 7a78274a07 user: drh tags: trunk) | |
| 14:38 | Remove a debugging printf() accidentally left in the previous check-in. (check-in: e9d1efa597 user: drh tags: trunk) | |
| 14:36 | The IN-early-out optimization does not work for virtual tables. Do not try to use it there. Fix for ticket [2d5a3163563d559f]. Test cases in TH3. (check-in: dbec6910d9 user: drh tags: trunk) | |
|
2020-09-30
| ||
| 20:35 | Add experimental unicode-aware trigram tokenizer to fts5. And support for LIKE and GLOB optimizations for fts5 tables that use said tokenizer. (check-in: 0d7810c1ae user: dan tags: fts5-trigram) | |
| 18:06 | Improved query optimization for multi-column indexes where the second or later columns are constrained by an IN operator and the earlier index columns limit the search to a small number of rows. Use the new OP_SeekScan opcode which does scanning of the relevant range of the index but gives up and falls back to doing a seek if the number of rows scanned grows to large, in order to guard against pathological cases where the estimated number of rows to be scanned is far too small. (check-in: 4a43430fd2 user: drh tags: trunk) | |
| 18:03 | For the OP_SeekScan opcode, adjust the number of steps run before giving up based on the estimated number of comparisons needed to perform a seek. (Closed-Leaf check-in: dc4172e6b8 user: drh tags: in-scan-vs-index) | |
| 17:32 | Back out the incorrect optimization of check-in [e51ecadcbdef5ce6] as ticket [5c4e7aa793943803] reports a case where the optimization does not work. (check-in: 7395e96b8c user: drh tags: trunk) | |
| 15:36 | In the query flattener when substituting expression Y in place of expression X, if X is marked has having come from an ON or USING clause of a LEFT JOIN, then be sure that all subexpressions of Y, not just the root node of Y, are similarly marked. Otherwise, if Y is an AND operator, it will be split up during WHERE clause analysis and the subexpressions will not get the special treatment needed by LEFT JOIN ON/USING clauses. Fix for ticket [66e4b0e271c47145]. (check-in: 69f9eb7343 user: drh tags: trunk) | |
| 09:17 | Better understanding of savepoint code (check-in: ce6d8d6215 user: shearer tags: trunk) | |
| 00:48 | Add an sqlite3FaultSim() call to btreeNext() to make it easier to simulate I/O errors in calls to sqlite3BtreeNext(), and in OP_SeekScan. (check-in: 29cca775d3 user: drh tags: in-scan-vs-index) | |
| 00:10 | In the OP_SeekScan opcode, changes to pOp must occur after the call to VdbeBranchTaken() so that the VdbeBranchTaken() attributes the branch to the correct opcode. (check-in: 61fbe7aa7c user: drh tags: in-scan-vs-index) | |
|
2020-09-29
| ||
| 23:52 | The OP_SeekScan opcode is a no-op if the cursor is not pointing to a valid row upon entry. (check-in: 4afc96b5fe user: drh tags: in-scan-vs-index) | |
| 20:22 | Coverage testing of the OP_SeekScan opcode. Fix a problem that comes up when OP_SeekScan reaches the end of the table. (check-in: 9e57e758a6 user: drh tags: in-scan-vs-index) | |
| 17:29 | Improved comments on the new OP_SeekScan opcode. (check-in: 6110fdd5bb user: drh tags: in-scan-vs-index) | |
| 16:05 | Improved performance by manually in-lining the sqlite3VdbeIdxKeyCompare() routine for the OP_IdxGT opcode and its kin. (check-in: 2206a2c848 user: drh tags: in-scan-vs-index) | |
| 15:32 | Typo fix to repair the early-out optimization. Also avoid unnecessary OP_SeekHit opcodes. (check-in: 8fd7d8dfcd user: drh tags: in-scan-vs-index) | |
| 01:48 | The OP_SeekScan opcode works, but using it requires disabling the IN-earlyout optimization because the OP_IfNoHope opcode might move the cursor. (check-in: f3c36b840c user: drh tags: in-scan-vs-index) | |
|
2020-09-28
| ||
| 19:51 | Revisiting the IN-scan optimization to try to fix it for the corner case where the statistics deceive the query planner into using a scan when an indexed lookup would be better. This check-in changes the code generation to do the IN-scan using a new OP_SeekScan opcode. That new opcode is designed to abandon the scan and fall back to a seek if it doesn't find a match quickly enough. For this work-in-progress check-in, OP_SeekScan is still a no-op and OP_SeekGE still ends up doing all the work. (check-in: d720b6981e user: drh tags: in-scan-vs-index) | |
| 15:49 | Small performance improvement and size reduction by reducing the size of the WhereTerm object. (check-in: 43f7ddad80 user: drh tags: trunk) | |
| 13:34 | Avoid the possibility of integer overflow on the --pagecache option to the CLI. See forum post 10a2892377 (check-in: d3d13df31a user: drh tags: trunk) | |
|
2020-09-25
| ||
| 17:17 | Clarify (check-in: 14dba0f3b5 user: shearer tags: btree-code-documentation) | |
| 16:54 | Distinguish between checkpoints (WAL-only, implementation specific) and savepoints (Btree internal implementation of COMMIT/ROLLBACK subtransactions) and SQL SAVEPOINT (identical name for SQL-level subtransactions) (check-in: ae686ab6a8 user: shearer tags: btree-code-documentation) | |
| 14:26 | Reset to trunk's func. Still learning Fossil. (check-in: a4840cf5c6 user: shearer tags: btree-code-documentation) | |
| 13:56 | More classification of functions. Fix incorrect comment that sqlite3BtreeCursorHasHint() is only used within asserts. (check-in: 78d8db7cb7 user: shearer tags: btree-code-documentation) | |
| 09:42 | Merge recent trunk changes into the btree-code-documentation branch (check-in: 3a576608e6 user: shearer tags: btree-code-documentation) | |
| 08:17 | Add reminder comment that, by definition, these functions won't be called from elsewhere in SQLite. Useful to remember for beginners who may suspect unusued code. (check-in: 6f5c1fde24 user: shearer tags: btree-code-documentation) | |
|
2020-09-24
| ||
| 11:41 | Added context to explain that the test coverage is about MC/DC in general, not just an SQLite-specifc test harness. (check-in: 770dbedddc user: shearer tags: btree-code-documentation) | |
| 06:37 | Group metadata definitions together (check-in: 5c306f4251 user: shearer tags: btree-code-documentation) | |
|
2020-09-23
| ||
| 17:31 | Figured out where/how sqlite3BtreeRowCountEst() is called (check-in: a46537153c user: shearer tags: btree-code-documentation) | |
|
2020-09-21
| ||
| 20:18 | Fix harmless compiler warning seen with MSVC. (check-in: 4591ee03d7 user: mistachkin tags: trunk) | |
| 14:53 | In fts5 integrity checks, do not compare the contents of the index against an external content table unless specifically requested. (check-in: 782163693f user: dan tags: trunk) | |
|
2020-09-20
| ||
| 13:33 | Remove a new assert() that the compiler finds is always true at compile-time, to avoid a compiler warning. (check-in: 8bbaee2385 user: drh tags: trunk) | |
| 12:10 | Attempt to silence harmless static analyzer warnings in Lemon and in the Lemon-generated parser. (check-in: de8ce22a46 user: drh tags: trunk) | |
|
2020-09-17
| ||
| 21:11 | Fix a typo in the documentation comment for sqlite3_preupdate_hook(). (check-in: 4542d194e2 user: dan tags: trunk) | |
| 17:01 | Fix a problem in sqlite-expert causing it to ignore equality constraints on the second or subsequent columns of a multi-column PRIMARY KEY. (check-in: c666c85a43 user: dan tags: trunk) | |
| 15:16 | Fix a problem in fts5 causing the in-memory hash table to be flushed more often than necessary. (check-in: 9a55601d07 user: dan tags: trunk) | |
| 15:04 | Order btree.h by logical function, add comments (check-in: ab53b31795 user: shearer tags: btree-code-documentation) | |
| 14:16 | Fix a "jump depends on unitialized value" valgrind/asan error in fts5. (check-in: 66f94d623c user: dan tags: trunk) | |
| 11:56 | Earlier detection of corruption in the rtreecheck() SQL function to prevent a (harmless) read of an uninitialized value. (check-in: e2074b2478 user: drh tags: trunk) | |
| 11:32 | Prevent use-after-free of the u.vtab.idxStr string following an OOM while generating the OP_VFilter opcode. (check-in: 751fe4edb2 user: drh tags: trunk) | |
| 00:46 | DISTINCT may not be ignored inside a UNION ALL common table expression. Fix for ticket [c51489c3b8f919c5] (check-in: 7d2b590d3a user: drh tags: trunk) | |
|
2020-09-16
| ||
| 19:48 | Fix a pair of assert()s in "PRAGMA foreign_key_check" that might have given a false-positive following an OOM. (check-in: 9ea3039b53 user: drh tags: trunk) | |
| 16:55 | Fix harmless compiler warnings in Lemon. (check-in: 6c94ba4b1c user: drh tags: trunk) | |
|
2020-09-15
| ||
| 20:48 | Fix a buffer overread found by OSSFuzz that could occur if a WITHOUT ROWID table with many columns was NATURAL JOINed against itself. (check-in: 3d35fa0be8 user: dan tags: trunk) | |
| 12:29 | Do not invoke usleep() for more than 999999 microseconds. (check-in: 1f5ed852f2 user: drh tags: trunk) | |
|
2020-09-11
| ||
| 15:01 | Catch fts5 index corruption caused by issuing 'delete' commands with incorrect data earlier in some cases. Also fix a couple of test script problems. (check-in: b79f19edfd user: dan tags: trunk) | |
|
2020-09-10
| ||
| 15:09 | Try again to fix the typo in the sqlite3_txn_state() documentation. (check-in: 6d1ab0403c user: drh tags: trunk) | |
| 14:54 | Fix typo in the documentation for the new sqlite3_txn_state() interface. (check-in: 23f7d01758 user: drh tags: trunk) | |
| 12:41 | If an amalgamation is created using SQLITE_ENABLE_UPDATE_DELETE_LIMIT, ensure that it can still be compiled without that option by setting the SQLITE_UDL_CAPABLE_PARSER flag in the preamble. (check-in: 5b905d7d77 user: drh tags: trunk) | |
|
2020-09-07
| ||
| 11:23 | Merge latest trunk changes into this branch. (check-in: ae1a778dbb user: dan tags: reuse-schema) | |
| 11:14 | Fix another (harmless in practice) tsan error in shared-cache mode. (check-in: 5a74fa3f0a user: dan tags: trunk) | |
|
2020-09-06
| ||
| 17:40 | Remove an artifical limitation on the length of columns in the "box" output mode of the command-line shell. (check-in: 783fa887c9 user: drh tags: trunk) | |
|
2020-09-05
| ||
| 06:21 | Fix a bug in Lemon that might cause it to crash if there is a multi-terminal token with a space following the "|" separator. This does not affect SQLite. (check-in: 430c5d1da5 user: drh tags: trunk) | |
|
2020-09-04
| ||
| 19:12 | Merge tsan error fix from trunk into this branch. (check-in: 93cc60b342 user: dan tags: reuse-schema) | |
| 19:10 | Fix a tsan error that could occur when using shared-cache mode. (check-in: de80bc8730 user: dan tags: trunk) | |
| 17:40 | Update this branch with latest changes from trunk. (check-in: ca8deb44c7 user: dan tags: reuse-schema) | |
| 17:30 | Ensure that the busy-handler count is reset at the end of each sqlite3_file_control() and sqlite3_prepare() (and _v2() and _v3()). (check-in: 5dd0594061 user: dan tags: trunk) | |
|
2020-09-02
| ||
| 16:14 | Add tests for virtual table shmlock. (Leaf check-in: 1c6a844273 user: dan tags: shmlock-vtab) | |
| 15:26 | Fix reporting on locks from external processes. Various other fixes. (check-in: 459de23e86 user: dan tags: shmlock-vtab) | |
|
2020-09-01
| ||
| 20:56 | Add file-controls and a vtab frontend for querying the unix VFS for the currently held shm-locks. Still some issues. (check-in: ef10e1b386 user: dan tags: shmlock-vtab) | |
| 19:02 | Fix harmless compiler warning. (check-in: a711e8cd2c user: mistachkin tags: trunk) | |
| 12:26 | In the Lemon output, add a prefix comment that explains that the output file is automatically generated and shows the name of the source file. (check-in: d34caf3bb6 user: drh tags: trunk) | |
| 11:20 | Lemon updates: (1) include the #defines for all tokens in the generated C file, so that the C-file can be stand-alone. (2) If the grammar begins with a %include {...} directive on line one, make that directive the header for the generated C file. (3) Enhance the lemon.html documentation. (check-in: 84d54eb357 user: drh tags: trunk) | |
| 01:52 | Improvements to the IN-early-out optimization so that it works more efficiently when there are two or more indexed IN clauses on a single table. (check-in: 35505c68c1 user: drh tags: trunk) | |
| 00:26 | Fix a harmless compiler warning. (check-in: 3ca0b7d54d user: drh tags: trunk) | |
| 00:09 | Minor changes - fix a compiler warning and add an assert(). (Closed-Leaf check-in: 07222dce10 user: drh tags: in-early-out-fail) | |
|
2020-08-31
| ||
| 19:58 | Merge the SEEK_COUNT instrumentation enhancement from trunk. (check-in: 689ede9564 user: drh tags: in-early-out-fail) | |
| 18:49 | New test-control that returns the number of calls to sqlite3BtreeMovetoUnpacked() on the main database and then resets the counter. This only works for SQLITE_DEBUG builds. (check-in: dca5b91926 user: drh tags: trunk) | |
| 16:31 | An attempt to improve the performance of the IN-early-out optimization (see check-in [09fffbdf9f2f6ce3]) by avoiding unnecessary calls to the b-tree search algorithm in OP_IfNoHope when the index key is at hand and the same answer can be obtained by doing a quick key comparison. Update 2020-08-31: This experiment did not work out. A better approach is now on trunk. (check-in: e9d983c683 user: drh tags: in-early-out-fail) | |
| 12:29 | Fix the documentation for the OP_IdxGT family of opcodes to show that the P5 operand is not used. (check-in: 62f7d2a612 user: drh tags: trunk) | |
|
2020-08-29
| ||
| 19:00 | Fix a sanitizer warning in zipfile.c. (check-in: ded1a75b3c user: dan tags: trunk) | |