Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
503 check-ins using file src/util.c version 3ff7bc2b48
|
2023-04-25
| ||
| 15:12 | If an ON clause to the left of a RIGHT JOIN is false, that does not imply that the query returns no rows. (Leaf check-in: 4011b9d340 user: drh tags: branch-3.41) | |
| 11:52 | Fixes to SQL extension functions base64() and base85(). (check-in: ab3331f41e user: drh tags: branch-3.41) | |
|
2023-04-24
| ||
| 19:14 | Mistake → branched off of the wrong branch. (Closed-Leaf check-in: 491bd51da5 user: drh tags: mistake) | |
|
2023-04-22
| ||
| 23:43 | Import fixes from trunk into the branch-3.41. (check-in: 58a1d94c59 user: drh tags: branch-3.41) | |
|
2023-04-19
| ||
| 17:13 | Fix a segfault that could occur if a non-empty in-memory database was the destination of a backup operation from a database with a smaller page size. (check-in: d37241585c user: drh tags: branch-3.41) | |
| 15:39 | Do not remove pages from the cache of an in-memory database due to a failure to acquire the page due to it being larger than the maximum page size. (check-in: 551b9dacd0 user: drh tags: branch-3.41) | |
|
2023-04-18
| ||
| 16:44 | Ensure that the VACUUM command is not confused by alternative encodings when it is the first command run on new database connection. (check-in: 441f4e4a42 user: drh tags: branch-3.41) | |
| 14:17 | Another fix to the indexed expressions in aggregate queries with GROUP BY enhancement of ticket 99378177930f87bd and implemented by check-in b9190d3da70c4171 to address a problem described by forum post f34e32d120. (check-in: c37e76104b user: drh tags: branch-3.41) | |
|
2023-04-15
| ||
| 16:12 | For CLI -utf8, set output codepage too. Adjust PP vars so that the code can be entirely omitted for targets pretending to be "WIN32" but not quite doing so. (check-in: 543594a727 user: larrybr tags: cli-utf8) | |
|
2023-04-14
| ||
| 21:34 | Fix stray edits in comments in last check-in. (check-in: fa3ce7f013 user: larrybr tags: cli-utf8) | |
| 21:23 | Set CLI -utf8 option and build with line-editing package to be mutually exclusive. Integration of console-invasive UTF-8 handling with line-editing takeover of console may come later. (check-in: 047344a915 user: larrybr tags: cli-utf8) | |
| 19:56 | Cure CLI double-prompting (by ditching gcc fgetws()), general cleanup. Work remaining is to avoid effect of -utf8 when a line editor is linked/used as part of CLI. (check-in: 73a5f54231 user: larrybr tags: cli-utf8) | |
| 18:00 | Further tests for fts5 secure-delete mode. (Closed-Leaf check-in: c5a47063b7 user: dan tags: fts5-secure-delete) | |
| 17:00 | Add extra OOM test for the new code on this branch. (check-in: 846ae7e099 user: dan tags: fts5-secure-delete) | |
| 16:11 | Add tests for the new feature on this branch. (check-in: 0268d1a593 user: dan tags: fts5-secure-delete) | |
| 15:42 | Fix a typo in the aggfault.test test script. (check-in: e915bff7ad user: drh tags: branch-3.41) | |
| 10:46 | When setting the column types on a subquery, ensure that the COLFLAG_HASCOLL flag is cleared from column names from when the collating sequence name has been removed. (check-in: de61bdc9b9 user: drh tags: branch-3.41) | |
| 00:23 | Avoid double de-quoting of table names when processing RESTRICT actions in foreign key constraints. (check-in: 5af7abffe7 user: drh tags: branch-3.41) | |
|
2023-04-13
| ||
| 18:49 | Fix an obscure issue with ALTER TABLE RENAME that comes up with triggers that have UPDATE statements that contain errors. (check-in: cf651dee12 user: drh tags: branch-3.41) | |
| 15:11 | Remove an ALWAYS() that can sometimes be false. And fix a code-generator issue associated with very unusual use of window functions. (check-in: fc12743763 user: drh tags: branch-3.41) | |
| 14:14 | Get CLI utf8_fgets() to not consume more input than it returns. Get console setup restoration to happen for all non-crash exits. (check-in: b4fa233d3d user: larrybr tags: cli-utf8) | |
|
2023-04-12
| ||
| 18:18 | Avoid leaking a database handle in test script rbuexlock.test. (check-in: 2edf98d128 user: dan tags: trunk) | |
| 18:06 | Remove temporary debugging code accidentally left on this branch. (check-in: 0a0f64870f user: dan tags: fts5-secure-delete) | |
| 17:54 | WIP: CLI option to take control of console on Windows and make it support UTF-8 input pasting (or typing). Needs work to become robust per "ToDo:". (check-in: 824382393d user: larrybr tags: cli-utf8) | |
| 17:40 | Add the 'secure-delete' option to fts5. Used to configure fts5 to aggressively remove old full-text-index entries belonging to deleted or updated rows. (check-in: 4240fd09b7 user: dan tags: fts5-secure-delete) | |
|
2023-04-11
| ||
| 19:38 | New #ifdef to enable building with -DSQLITE_OMIT_WINDOWFUNC. (check-in: e1ff83fa25 user: drh tags: trunk) | |
| 15:06 | Remove an ALWAYS() that can sometimes be false. Add a test case that makes the test false. Forum post 6c5678e3da. (check-in: c8fb143d64 user: drh tags: trunk) | |
| 02:10 | Better handling of OOM errors in the cursor-hint logic. dbsqlfuzz 60cd5fff91974af91c2c3692beb4a2d7fdafef46 (check-in: 68fcfb58df user: drh tags: trunk) | |
|
2023-04-10
| ||
| 23:21 | For sha3 extension, mention NIST standard implemented. (check-in: 529ab138a4 user: larrybr tags: trunk) | |
| 18:44 | New assert() statements to validate the parameters to sqlite3BtreeCursorHint(). Fix a problem with the construction of those parameters discovered by forum post 0b53708c95. (check-in: 4c5a3c5fb3 user: drh tags: trunk) | |
| 13:20 | Sync the vt02.c test virtual table with TH3, in order to pull in the fix for long delays when there are huge OFFSET values. (check-in: 49ba030080 user: drh tags: trunk) | |
|
2023-04-09
| ||
| 20:48 | Fix an assertion fault that can occur when compiling with both SQLITE_ENABLE_UNKNOWN_SQL_FUNCTIONS and SQLITE_ENABLE_STAT4. (check-in: 2b02862de6 user: drh tags: branch-3.41) | |
| 20:44 | Fix an assertion fault that can occur when compiling with both SQLITE_ENABLE_UNKNOWN_SQL_FUNCTIONS and SQLITE_ENABLE_STAT4. (check-in: 9ff69e5998 user: drh tags: trunk) | |
| 10:23 | Fix a faulty assert() in whereRangeScanEst() that should only apply if there are not prior errors. (check-in: 450d8ad85c user: drh tags: branch-3.41) | |
| 10:09 | Fix a faulty assert() in whereRangeScanEst() that should only apply if there are not prior errors. dbsqlfuzz 567ad91132879cbab8172b38c6a68ad40fa8d650. (check-in: 8ba9b08bd9 user: drh tags: trunk) | |
|
2023-04-08
| ||
| 19:27 | Fix a couple harmless compiler warnings seen with MSVC. (check-in: 1b864a370f user: mistachkin tags: trunk) | |
| 19:23 | Fix a typo in [83e84531b46814ae] that changed the value of SQLITE_DBCONFIG_STMT_SCANSTATUS. (check-in: b717765391 user: drh tags: trunk) | |
| 16:51 | Faster implementation of keywordCode() - the routine that determines if an identifier is really a keyword and if so, which keyword. (check-in: 0ff3d3d537 user: drh tags: trunk) | |
| 13:31 | Fix a harmless compiler warning. (check-in: c9559ba621 user: drh tags: trunk) | |
| 13:01 | Optimizations to btree.c save about 4.5 million CPU cycles: (1) Clone insertCell() into a separate insertCellFast() routine for use by sqlite3BtreeInsert(). (2) Mark allocateSpace() as always-inline. (3) Improved coalesence of adjacent free blocks in pageFreeArray(). (check-in: 5c12c400fe user: drh tags: trunk) | |
|
2023-04-07
| ||
| 18:27 | Guard against oversized cells in the newly enhanced pageFreeArray(). (Closed-Leaf check-in: 2dcdbb5035 user: drh tags: btree-freespace-opt) | |
| 16:30 | Add NEVER on an unreachable branch. (check-in: 9b3febbd98 user: drh tags: btree-freespace-opt) | |
| 15:49 | Fix an assert(). (check-in: 7eff46ba97 user: drh tags: btree-freespace-opt) | |
| 15:07 | Tweaks to the new insertCellFast(). (check-in: 203a581a91 user: drh tags: btree-freespace-opt) | |
| 14:33 | Clone insertCell() into insertCellFast() for use by sqlite3BtreeInsert() for a substantial performance increase. (check-in: f225afd90c user: drh tags: btree-freespace-opt) | |
| 14:03 | Fix a problem causing the rbu_exclusive_checkpoint=1 to be ignored with zipvfs databases. (check-in: d8f50b31e8 user: dan tags: trunk) | |
| 13:21 | Small performance improvement in freeSpace(). (check-in: 8dc5292ee5 user: drh tags: btree-freespace-opt) | |
| 11:55 | Try to use a heap to make coalescence of adjacent free slots faster when freeing space on a btree page. Turns out that the overhead of managing the heap overwhelms any performance gain and the result is slower. (Closed-Leaf check-in: 5d7e833f25 user: drh tags: deadend) | |
| 11:18 | Add further tests for the rbu_exclusive_lock=1 URI option. (check-in: c07b62bef9 user: dan tags: trunk) | |
|
2023-04-06
| ||
| 20:14 | Increase the size of the cache of free blocks inside of pageFreeArray() to reduce the number of calls to freeSpace(). (check-in: 27c59f1ea7 user: drh tags: btree-freespace-opt) | |
| 17:41 | Work around a harmless assertion fault associated with sqlite3VdbeMemAboutToChange() such that the detection of stale values in registers is preserved in debugging builds, but we avoid a false-positive assertion fault in cases involving a virtual table with a LIMIT clause in an IN-operator loop. (check-in: 9511d17e2a user: drh tags: branch-3.41) | |
| 17:29 | Work around a harmless assertion fault associated with sqlite3VdbeMemAboutToChange() such that the detection of stale values in registers is preserved in debugging builds, but we avoid a false-positive assertion fault in cases involving a virtual table with a LIMIT clause in an IN-operator loop. dbsqlfuzz 3fd70d4ab4950acf1deb8f610a7a7c67cd38713b (check-in: 56ea2c2fe6 user: drh tags: trunk) | |
| 15:32 | A prepared statement that aborts due to SQLITE_SCHEMA should not invalidate cursors in other prepared statements that are already running. (check-in: 4eee8401c9 user: drh tags: branch-3.41) | |
| 13:35 | A prepared statement that aborts due to SQLITE_SCHEMA should not invalidate cursors in other prepared statements that are already running. See forum post cae4367d9b for the original trouble report. (check-in: 857d0f5e16 user: drh tags: trunk) | |
| 02:26 | In the CLI, during error processing while looking for a word boundary, avoid being deceived by malformed input that has a very long sequence of 0x80 characters. Also fix a problem in the zipfile extension for when a corrupt zipfile has a zero-length filename. (check-in: 5323ee77d7 user: drh tags: branch-3.41) | |
| 01:05 | In the CLI, during error processing while looking for a word boundary, avoid being deceived by malformed input that has a very long sequence of 0x80 characters. forum post ab93a23ba1. (check-in: 82609d5a2d user: drh tags: trunk) | |
| 00:59 | In the zipfile extension, defend against corrupt ZIP files that contain a zero-length filename. Forum post b15f5e3ad8. (check-in: 46db2e42a5 user: drh tags: trunk) | |
| 00:18 | In the new .scanstatus command in the CLI, make sure the database is opened before invoking sqlite3_db_config(). Forum post 6e26dcf544. (check-in: 1cd993c45c user: drh tags: trunk) | |
|
2023-04-05
| ||
| 03:00 | Remove an ALWAYS() that can now be false due to the prior check-in. (check-in: 3bfdb4103d user: drh tags: branch-3.41) | |
| 02:55 | Add a test case for the ALWAYS() macro removed by the previous check-in. (check-in: 68a1a83749 user: drh tags: trunk) | |
| 02:50 | Remove an ALWAYS() that might now be false due to the prior check-in. (check-in: fc68993501 user: drh tags: trunk) | |
| 02:25 | Fix the function that determines the collating function for an expression tree to handle new cases that arise as a result of the recently added ability to use indexed expressions in aggregate queries. (check-in: b29dea0dae user: drh tags: branch-3.41) | |
| 02:21 | Fix the function that determines the collating function for an expression tree to handle new cases that arise as a result of the recently added ability to use indexed expressions in aggregate queries. [forum/forumpost/0713a16a44|Forum post 0713a16a44]. (check-in: cc5041f3f0 user: drh tags: trunk) | |
|
2023-04-04
| ||
| 19:56 | Shell to use SQLITE_SHELL_HAVE_RECOVER consistently (correcting check-in 0421cc03e0efa8f1) (check-in: 5b980d72a0 user: larrybr tags: trunk) | |
| 18:59 | Fix an incorrect entry in the array that maps sqlite3_value values into actual datatype numbers. (check-in: 80d518fb82 user: drh tags: branch-3.41) | |
| 18:55 | Fix an incorrect entry in the array that maps sqlite3_value values into actual datatype numbers. dbsqlfuzz f660c659bcec48577a43d3bab37f46baaa22f59e (check-in: fa8537dc90 user: drh tags: trunk) | |
| 18:48 | Remove an assert() statement that is no longer valid due to enhancements to query planner for improved use of indexes. (check-in: 93fb8c66c5 user: drh tags: branch-3.41) | |
| 18:10 | Remove an assert() statement that is no longer valid due to enhancements to query planner for improved use of indexes. Forum post dc16ec63d3. (check-in: 2b23dd249d user: drh tags: trunk) | |
| 17:35 | Expose the new SQLITE_VTAB_USES_ALL_SCHEMAS to JS. (check-in: b7ef09be66 user: stephan tags: trunk) | |
| 08:49 | Omit shell call to sqlite3_dbdata_init() when it is omitted. (check-in: 0421cc03e0 user: larrybr tags: trunk) | |
|
2023-04-03
| ||
| 23:55 | When translating arguments of aggregate functions into references to expression indexes, make sure to only translate them for the current aggregate when there are nested aggregates. (check-in: 7ea98aba78 user: drh tags: branch-3.41) | |
| 23:49 | When translating arguments of aggregate functions into references to expression indexes, make sure to only translate them for the current aggregate when there are nested aggregates. Forum post 409ebc7368. (check-in: 898bfa1afd user: drh tags: trunk) | |
| 20:11 | Improved diagnostic output from PRAGMA vdbe_addoptrace. (check-in: 050958c182 user: drh tags: trunk) | |
| 18:00 | When changing a COLLATE expression node into TK_AGG_COLUMN because the nodes value is contained in an indexed expression, be sure to clear the EP_Collate property from the expression node. (check-in: af0f55cfcb user: drh tags: branch-3.41) | |
| 17:46 | When changing a COLLATE expression node into TK_AGG_COLUMN because the nodes value is contained in an indexed expression, be sure to clear the EP_Collate property from the expression node. Fix for the assertion faults reported by forum post e45108732c and forum post 44270909bb. (check-in: cf6454ce26 user: drh tags: trunk) | |
| 15:01 | Add the SQLITE_VTAB_USES_ALL_SCHEMAS option to sqlite3_vtab_config(). Update the sqlite_dbpage, sqlite_dbdata, and sqlite_dbptr virtual tables to make use of that interface. This was formerly handled by the internal sqlite3VtabUsesAllSchemas() routine that was called directly from sqlite_dbpage. But since sqlite_dbdata and sqlite_dbptr are an extension, an external interface to that functionality had to be provided. dbsqlfuzz 1a29c245175a63393b6a78c5b8cab5199939d6a8 (check-in: bcd51abee0 user: drh tags: trunk) | |
| 12:48 | Make the sqlite_dbdata and sqlite3_dbptr virtual tables accessible to the CLI. (check-in: c0eff02854 user: drh tags: trunk) | |
| 12:45 | Stronger constraint checking in allocateSpace(). (check-in: 0f9e65b6c1 user: drh tags: branch-3.41) | |
| 12:33 | Stronger constraint checking in allocateSpace(). dbsqlfuzz 93d4c9ff5ef7cd29f16e767af1ee71c29ec5a4c0 (check-in: 9e968f4fbc user: drh tags: trunk) | |
|
2023-04-02
| ||
| 20:56 | With the -DSQLITE_ENABLE_JSON_NAN_INF compile-time option, non-standard JSON numeric values "Inf", "Infinity", "-Inf", "-Infinity", "NaN", "QNaN", and "SNaN" are all accepted. SQLite should never generate these values, but it will accept that with the appropriate compile-time option. (check-in: 0a050e9013 user: drh tags: trunk) | |
| 20:46 | More off-by-one errors in the new JSON parsing. (Closed-Leaf check-in: dbc9966208 user: drh tags: json-nan-inf) | |
| 20:27 | Fix an off-by-one error in the recognition of -Infinity. (check-in: f7ebf3e628 user: drh tags: json-nan-inf) | |
| 18:49 | Earlier detection of corruption in sqlite3BtreeDelete(). dbsqlfuzz a4c48c291d6e40157a1b749a05eaa7c7faf5a625. (check-in: 728633c0bd user: drh tags: branch-3.41) | |
| 16:43 | Earlier detection of corruption in sqlite3BtreeDelete(). dbsqlfuzz a4c48c291d6e40157a1b749a05eaa7c7faf5a625. (check-in: 978dc71c38 user: drh tags: trunk) | |
| 14:53 | Clear executable bit on base64.c (check-in: ec1ddbce7d user: larrybr tags: trunk) | |
|
2023-04-01
| ||
| 23:29 | Allow special floating-point value names in JSON: "inf", "-inf", "infinity", "-infinity", "nan", "qnan", and "snan". All are converted into valid JSON values: 9e999, -9e999, or null. Requires the SQLITE_ENABLE_JSON_NAN_INF compile-time option to operate. (check-in: fc8793e5ac user: drh tags: json-nan-inf) | |
| 16:14 | Swat grammar nit on README.md (check-in: 715c00e58b user: larrybr tags: trunk) | |
| 15:51 | Fix harmless compiler warnings. (check-in: a4fb2864fe user: drh tags: trunk) | |
| 13:14 | Improved error messages from PRAGMA integrity_check. Identify the root of the tree when a problem is found in a b-tree, making it easier to track the problem to a specific table or index. (check-in: a1cb152e69 user: drh tags: trunk) | |
| 12:22 | In the b-tree module use %u instead of %d to print unsigned quantities such as page numbers and offsets. (check-in: 33ac62d8ee user: drh tags: trunk) | |
|
2023-03-31
| ||
| 23:59 | Omit the the count-of-view optimization if there is a HAVING clause. (check-in: a8faea2842 user: drh tags: branch-3.41) | |
| 23:48 | Omit the the count-of-view optimization if there is a HAVING clause. This fixes a problem that originated with check-in [9322a7c21f1c22ba]. dbsqlfuzz 6a107e3055bd22afab31cfddabc2d9d54fcbaf69 (check-in: babe2b5e59 user: drh tags: trunk) | |
|
2023-03-30
| ||
| 19:14 | Earlier error detection for index expression usage by aggregate functions. dbsqlfuzz 29214ace4e25c98d2ddff8fbcf97afdda23f28b9 (check-in: cf8dd8cd08 user: drh tags: branch-3.41) | |
| 19:05 | Earlier error detection for index expression usage by aggregate functions. dbsqlfuzz 29214ace4e25c98d2ddff8fbcf97afdda23f28b9 (check-in: 8e841e7f02 user: drh tags: trunk) | |
| 16:08 | Omit a branch that is no longer needed following [c9c4f287652933eb]. (check-in: 960a488a2d user: drh tags: trunk) | |
| 12:19 | Fix an error in new test script test/aggfault.test. (check-in: 8724fe7426 user: dan tags: trunk) | |
| 11:28 | Cherrypick three fixes from trunk. (check-in: 5583ea82c6 user: drh tags: branch-3.41) | |
| 11:05 | Fix a crash that could follow an OOM error while processing aggregate functions. (check-in: 804435a273 user: dan tags: trunk) | |
|
2023-03-29
| ||
| 21:58 | Avoid having OP_SeekScan jump over an OP_IdxGT or OP_IdxGE that follows the OP_SeekGE opcode. Fix for [b50528af4468237c]. (check-in: c9c4f28765 user: dan tags: trunk) | |
| 18:54 | Fix a problem with sqlite3_stmt_scanstatus() calls made from within an SQLITE_TRACE_STMT callback made from within a trigger. (check-in: 1fa78fafa1 user: dan tags: trunk) | |
| 15:16 | Another #ifdef to omit code that is only used by STAT4. (check-in: 445c75567d user: drh tags: trunk) | |
| 14:42 | New #ifdefs to omit code that is unused except under STAT4. (check-in: 09a9b30ba7 user: drh tags: trunk) | |
| 11:40 | Enhance PRAGMA integrity_check so that it can detect that a NOT NULL column contains a NaN value and report that as an error. (check-in: fbc27e18aa user: drh tags: branch-3.41) | |
| 11:36 | Enhance PRAGMA integrity_check so that it can detect that a NOT NULL column contains a NaN value and report that as an error. dbsqlfuzz f144b642fe6f1a1c196f258ac6e60118a0cb59b2. (check-in: 7638d9755d user: drh tags: trunk) | |
| 00:05 | Modify the OP_IsType opcode so that it does not need to distinguish between NaN and other floating point values. Later: This branch causes an unnecessary slowdown of PRAGMA integrity_check. Check-in [7638d9755dc90fd3] does a better job of detecting when a NaN value occurs in a NOT NULL column. (Closed-Leaf check-in: 242cb36c3b user: drh tags: istype-opcode-refactor) | |
|
2023-03-28
| ||
| 16:13 | Fix a weird corner case in aggregate function processing that results from the recent addition of support for index expressions on aggregate queries. (check-in: 36fd948e34 user: drh tags: branch-3.41) | |
| 16:02 | Fix a weird corner case in aggregate function processing that results from the recent addition of support for index expressions on aggregate queries. Forum post bad532820c. (check-in: c34fd9fe1b user: drh tags: trunk) | |
| 11:21 | Fix multiple problems with RETURNING on a DML statement against a view. (1) Do not allow a RETURNING clause to trick the code generator into thinking that the view being updated has an INSTEAD OF trigger. (2) Generate all result columns for a view in a DML statement. (3) The automatic covering index for a view should cover all result columns of the view. (check-in: b49816fcce user: drh tags: branch-3.41) | |
| 11:18 | Fix multiple problems with RETURNING on a DML statement against a view, all inspired by forum post dc3b92cfa0. (1) Do not allow a RETURNING clause to trick the code generator into thinking that the view being updated has an INSTEAD OF trigger. (2) Generate all result columns for a view in a DML statement. (3) The automatic covering index for a view should cover all result columns of the view. (check-in: c8bedef0d6 user: drh tags: trunk) | |
|
2023-03-27
| ||
| 13:57 | Remove a meaningless JS test. Add a timer to the OPFS async-side worker loader in an attempt to catch a browser-specific quirk in which the worker loading silently fails, per discussion in/around [forum post a708c98dcb3ef|forum:a708c98dcb3ef]. (check-in: 4fc1904b8e user: stephan tags: trunk) | |
| 13:27 | Do not allow constant factoring during PRAGMA integrity_check, since the constants might be stored in registers that are later reused for other purposes. (check-in: a4b5f499d9 user: drh tags: branch-3.41) | |
| 13:24 | Do not allow constant factoring during PRAGMA integrity_check, since the constants might be stored in registers that are later reused for other purposes. dbsqlfuzz dc9ab26037cf5ef797d28cd1ae0855ade584216d. Problem discovered by a new assert() statement added in [6f8b97f31a4c8552]. (check-in: 0bba27b781 user: drh tags: trunk) | |
| 13:10 | Improvements to register allocation, especially in the ANALYZE command. New assert() statements added to help verify that memory allocation is correct, and to help fuzzer find lingering errors. (check-in: 636f6fad8d user: drh tags: branch-3.41) | |
|
2023-03-26
| ||
| 16:36 | Improvements to register allocation, especially in the ANALYZE command. New assert() statements added to help verify that memory allocation is correct, and to help fuzzer find lingering errors. (check-in: 6f8b97f31a user: drh tags: trunk) | |
| 11:54 | Disable factoring of constant values during ANALYZE. This is a temporary fix for forum post 07de5f6216. The register allocation logic in ANALYZE needs to be completely refactored, but that will take longer. This check-in will serve to resolve the issue until a better fix can be devised. (check-in: c3967d1259 user: drh tags: trunk) | |
|
2023-03-25
| ||
| 23:56 | When the left table of a RIGHT JOIN is used inside an aggregate function and the left table employs an index on expressions, then make sure the expressions evaluate to NULL for the cases where the left table should be NULL. (check-in: c51df77ebe user: drh tags: branch-3.41) | |
| 23:52 | When the left table of a RIGHT JOIN is used inside an aggregate function and the left table employs an index on expressions, then make sure the expressions evaluate to NULL for the cases where the left table should be NULL. Fix for forum post 9b491e1deb. (check-in: ffe23af73f user: drh tags: trunk) | |
| 23:40 | Add usage detection to the NULL value generator for the left table of a RIGHT JOIN inside of an aggregate. (Closed-Leaf check-in: 4d05a009df user: drh tags: rightjoin-agg-idxexpr) | |
| 22:42 | When reading sqlite_stat4 data during query planning, be sure to expand zeroblobs prior to running comparisons. (check-in: 60f4d19d91 user: drh tags: branch-3.41) | |
| 22:37 | When reading sqlite_stat4 data during query planning, be sure to expand zeroblobs prior to running comparisons. Fix for the issue identified by forum post 5275207102. (check-in: 5c8dd8dfca user: drh tags: trunk) | |
| 21:01 | When the left table of a RIGHT JOIN is used inside an aggregate function and the left table employs an index on expressions, then make sure the expressions evaluate to NULL for the cases where the left table should be NULL. Proposed fix for forum post 9b491e1deb. More testing an analysis needed - there is a FIXME in this check-in. (check-in: 3572b40a7d user: drh tags: rightjoin-agg-idxexpr) | |
| 19:46 | In the byte-code generator, when the result of an expression needs to be in a particular register, always use the sqlite3ExprCode() routine because it has the smarts to know whether to use OP_Copy or OP_SCopy. Do not try to OP_SCopy inline because an OP_Copy might be required. (check-in: 2d439ccca4 user: drh tags: branch-3.41) | |
| 19:44 | In the byte-code generator, when the result of an expression needs to be in a particular register, always use the sqlite3ExprCode() routine because it has the smarts to know whether to use OP_Copy or OP_SCopy. Do not try to OP_SCopy inline because an OP_Copy might be required. Fix for the problem identified by forum post 5522082cfc. (check-in: c104e5c6ee user: drh tags: trunk) | |
| 18:41 | Add the tag-20230325-1 comment that was omitted from the prior check-in. (check-in: a13c01d076 user: drh tags: trunk) | |
| 18:33 | The fix at [13c8c60bb6b4447b] was incomplete in that it failed to clear the reusable register cache that might contain registers in the STAT4 buffer region. This additional change corrects the problem. (check-in: 671bf6f532 user: drh tags: branch-3.41) | |
| 18:31 | The fix at [2bf5413dc2c19d5f] was incomplete in that it failed to clear the reusable register cache that might contain registers in the STAT4 buffer region. This additional change corrects the problem. Forum post 83cb4a95a0. Test case in TH3. (check-in: 5d554e4d0f user: drh tags: trunk) | |
| 12:27 | Even tighter bounds on the maximum length of the filename for sqlite3_load_extension(). (check-in: 787291414d user: drh tags: trunk) | |
| 03:17 | Tighter constraints on the maximum length of the filename handed over to sqlite3_load_extension(), due to forum post a43074729e. This is a follow-on to [01f3877c7172d522] and forum post 08a0d6d9bf. (check-in: 9f351bdee2 user: drh tags: trunk) | |
| 02:07 | New test case to further validate the fix at [221fdcec964f8317]. Forum post d34ad68c36. (check-in: a6e218a6e1 user: drh tags: trunk) | |
| 02:02 | Fix a problem in cursor-hints for WITHOUT ROWID tables. (check-in: fc8ec188d9 user: drh tags: branch-3.41) | |
| 01:50 | Fix CLI non-handling of OOM. (check-in: 44c76f001a user: drh tags: branch-3.41) | |
| 01:29 | Fix CLI non-handling of OOM reported at Forum post 6872514e04. (check-in: 6f6a0fd63b user: larrybr tags: trunk) | |
|
2023-03-24
| ||
| 22:24 | Remove undocumented, vestigial SQL functions in the CLI that were once used for the ".recover" command but are now no longer needed. This is a fix for the problem described by forum post be9c294ee0. (check-in: 74d14900af user: drh tags: branch-3.41) | |
| 22:17 | Remove undocumented, vestigial SQL functions in the CLI that were once used for the ".recover" command but are now no longer needed. (check-in: 1ef461aa4e user: drh tags: trunk) | |
| 21:35 | Fix possible integer overflow in bounds checking for the debugging function "shell_int32()" found in the CLI. This change does not affect the core SQLite. Forum post be9c294ee0. (check-in: 6211471138 user: drh tags: trunk) | |
| 21:27 | Fix an error in the OP_SeekScan opcode. (check-in: b95e69330e user: drh tags: branch-3.41) | |
| 21:24 | Fix an error in the OP_SeekScan opcode added by check-in [4a43430fd23f8835]. Problem reported by forum post 8cc1dc0fe9. (check-in: 651a13fcd1 user: drh tags: trunk) | |
| 20:41 | Increase the version number to 3.41.3. (check-in: 9a19c6ce80 user: drh tags: branch-3.41) | |
| 20:39 | Fix the handling of indexed expressions in an outer query that appear as corelated values inside an aggregate function within a subquery. (check-in: 76b90f267c user: drh tags: branch-3.41) | |
| 20:35 | Fix the handling of indexed expressions in an outer query that appear as corelated values inside an aggregate function within a subquery. Forum post 79cf371080. (check-in: d8259877ea user: drh tags: trunk) | |
| 19:17 | Fix a problem in cursor-hints for WITHOUT ROWID tables used in a RIGHT JOIN. Forum post 591006b1cc. (check-in: 221fdcec96 user: drh tags: trunk) | |
| 17:15 | Add a JS test which checks for the issue described in forum post 895425b49a. (check-in: 98d30400e4 user: stephan tags: trunk) | |
| 17:01 | Fix byte-code register allocation in ANALYZE for STAT4 when there multiple indexes with differing numbers of columns. (check-in: 13c8c60bb6 user: drh tags: branch-3.41) | |
| 16:57 | Fix byte-code register allocation in ANALYZE for STAT4 when there multiple indexes with differing numbers of columns. forum post bc39e531e5. This problem arose when expression indexes were added by check-in [2131a5ca53f0e9b0]. (check-in: 2bf5413dc2 user: drh tags: trunk) | |
|
2023-03-23
| ||
| 10:58 | The attempt to bring STAT4 up to 100% MC/DC at [55a26c67ed4a3a93] and at [168fa2fb22b8c1ad] are incorrect. Back them out and replace them with a simple NEVER() macro. Error reported by forum post dc4854437b. (check-in: 76e683c5f2 user: drh tags: branch-3.41) | |
| 10:54 | The attempt to bring STAT4 up to 100% MC/DC at [55a26c67ed4a3a93] and at [168fa2fb22b8c1ad] are incorrect. Back them out and replace them with a simple NEVER() macro. Error reported by forum post dc4854437b. (check-in: 5992370a89 user: drh tags: trunk) | |
|
2023-03-22
| ||
| 19:57 | Internal cleanups in JS code. No functional changes. (check-in: 8fbdf7d104 user: stephan tags: trunk) | |
| 16:55 | The floating-point-to-text conversion with the zero-padding option now renders NaN as "null". (check-in: ad59fa1766 user: drh tags: trunk) | |
| 16:37 | For consistency, the ".mode json" output from the CLI now renders infinity in the same format as the JSON functions. (check-in: abee339d5e user: drh tags: trunk) | |
| 16:24 | The double-to-text conversion renders infinity as 9e999, so that JSON output is compliant and so that values can be round-tripped. (check-in: b52081d0ac user: drh tags: trunk) | |
| 16:01 | In the CLI, the magic parameter :inf and :nan bind floating point values Infinity and NaN, respectively, as an aid to testing SQLite's handling of those quantities. (check-in: c70a61d8fb user: drh tags: trunk) | |
| 14:51 | Update the version number for the TEA tarball to 3.42.0, to match the core. (check-in: 03e6918e7f user: drh tags: trunk) | |
| 13:47 | Merge the 3.41.2 patch into the reuse-schema-3.41 subbranch of reuse-schema (Leaf check-in: 995fa4d09d user: drh tags: reuse-schema-3.41) | |
| 13:35 | Merge the 3.41.2 patches into the bedrock-3.41 subbranch of bedrock. (Leaf check-in: b7a144c499 user: drh tags: bedrock-3.41) | |
| 13:25 | Merge the 3.41.2 patch into the wal2-3.41 subbranch of wal2. (Leaf check-in: db44f17a84 user: drh tags: wal2-3.41) | |
| 11:56 | Version 3.41.2 (check-in: 0d1fc92f94 user: drh tags: release, branch-3.41, version-3.41.2) | |
| 11:12 | Increment the version number in the TEA configure script to 3.41.2. (check-in: 2bb74aa501 user: drh tags: branch-3.41) | |
|
2023-03-21
| ||
| 14:20 | Add ALWAYS() on a branch this is always true now due to [84417bbd144b2197]. (check-in: badf7d0e3c user: drh tags: trunk) | |
| 12:29 | Add the fuzzcheck-asan.exe target to the MSVC makefile. (check-in: 0901bc0278 user: drh tags: trunk) | |
| 11:56 | Add the fuzzcheck-asan target to the main posix makefile. (check-in: 55e94adddb user: drh tags: trunk) | |
| 11:27 | Fix a valgrind error and potential buffer overread when handling a corrupt database. (check-in: cb8b34fa1a user: drh tags: branch-3.41) | |
| 11:13 | Fix a valgrind error and potential buffer overread when handling a corrupt database. (check-in: b1e0cd6444 user: dan tags: trunk) | |
|
2023-03-20
| ||
| 20:22 | Reinsert two NEVER() macros for b-tree branches that were previously needed for [b6a82f3c3b9d89fd] but which are now obsolete due to [73f0036f045bf371]. Later: dbsqlfuzz quickly found new cases for which those two branches are needed. The new test cases have been added to TH3. (Closed-Leaf check-in: 3065dadb3e user: drh tags: backout) | |
| 18:35 | Minor change to btreeNext() to facilitate coverage testing. (check-in: 20b3ef04d8 user: drh tags: trunk) | |
| 15:50 | Fix a problem causing a cursor to retain an out-of-date cell-info cache when processing a DISTINCT query on values that are identical according to their collation sequence, but different on disk. (check-in: b02811847c user: drh tags: branch-3.41) | |
| 14:59 | Fix a problem causing a cursor to retain an out-of-date cell-info cache when processing a DISTINCT query on values that are identical according to their collation sequence, but different on disk. Forum post e123e6cde4. (check-in: 1b3abc1dae user: dan tags: trunk) | |
| 10:43 | Back out the extra margin added to the input buffer of the CLI, as it is not needed. (check-in: ac8d1e5de5 user: drh tags: trunk) | |
| 01:59 | Fix problems with the sqlite3_error_offset() function and its use in the CLI. (check-in: d5cd6c885b user: drh tags: branch-3.41) | |
| 01:55 | A better fix for the sqlite3_error_offset() problem on generated columns. (check-in: 770b3e67c8 user: drh tags: trunk) | |
| 00:53 | Expression errors in generated columns should not generate non-negative sqlite3_error_offset() returns. Second of two defenses against [33aa4c0de8a62e33]. (check-in: 2adb4e0dda user: drh tags: trunk) | |
| 00:48 | When reporting errors in the CLI, ignore the output of sqlite3_error_offset() if the value returned is clearly out-of-range. One of two lines of defense against [33aa4c0de8a62e33]. (check-in: 26adbb80f5 user: drh tags: trunk) | |
|
2023-03-19
| ||
| 21:53 | Increase the size of ref-count values in the pager layer to 64-bits, to avoid any reasonable possiblity of overflowing the counters. (check-in: 824611ad33 user: drh tags: branch-3.41) | |
| 21:48 | Increase the size of ref-count values in the pager layer to 64-bits, to avoid any reasonable possiblity of overflowing the counters. There is a performance and memory penality for this. Forum post b741f15a35. (check-in: 6c5d99a813 user: drh tags: trunk) | |
| 10:30 | Avoid a buffer overread in fts3 that could occur when processing a corrupt record. (check-in: 1f91fe4bfc user: drh tags: branch-3.41) | |
|
2023-03-18
| ||
| 16:12 | Avoid a buffer overread in fts3 that could occur when processing a corrupt record. (check-in: 02ac2297ab user: dan tags: trunk) | |
|
2023-03-17
| ||
| 20:31 | Fix json rendering so that it shows positive and negative infinity as 9.0e+999 and -9.0e+999 respectively. (Closed-Leaf check-in: efce4690a5 user: drh tags: numeric-only-json) | |
| 19:18 | Add the ability to name functions using one of the join keywords like CROSS FULL INNER LEFT NATURAL OUTER RIGHT. (check-in: 0910b1925e user: drh tags: trunk) | |
| 19:07 | Add test cases for functions named the same as join keywords. (Closed-Leaf check-in: 94944b239c user: drh tags: functions-named-left) | |
| 14:22 | Fix a potential buffer overread in the recovery extension. (check-in: 78836713c9 user: dan tags: branch-3.41) | |
| 14:18 | Fix a potential buffer overread in the recovery extension. (check-in: 0b3b5bf959 user: dan tags: trunk) | |
| 12:25 | Ensure that an error does not delete the Table object out from under the xConstruct method of a virtual table. dbsqlfuzz 7cc8804a1c6d4e3d554d79096e6ea75a7c1c7d2d (check-in: c5bd0ea3b5 user: drh tags: branch-3.41) | |
| 10:43 | Ensure that an error does not delete the Table object out from under the xConstruct method of a virtual table. dbsqlfuzz 7cc8804a1c6d4e3d554d79096e6ea75a7c1c7d2d (check-in: df4928c92b user: drh tags: trunk) | |
| 10:30 | Increase the version number to 3.41.2 (check-in: 122f12f536 user: drh tags: branch-3.41) | |
| 00:42 | Add safety margin on the CLI input buffer for tickets [33aa4c0de8a62e33], [b97e6c5e6a91d97f], [2971fbe3f993e95a], and [2971fbe3f993e95a]. (check-in: 741af08af1 user: drh tags: trunk) | |
| 00:10 | Fix assert() statements that would (incorrectly) fire if an IF NOT EXISTS trigger that already exists contained two or more RETURNING clauses. (check-in: 9b43b34d81 user: drh tags: branch-3.41) | |
| 00:01 | Fix assert() statements that would (incorrectly) fire if an IF NOT EXISTS trigger that already exists contained two or more RETURNING clauses. Tickets [89d259d45b855a0d] and [d15b3a4ea901ef0d]. (check-in: 648899e4de user: drh tags: trunk) | |
|
2023-03-16
| ||
| 21:05 | Correctly handle SELECT DISTINCT ... ORDER BY when all of the result set terms are constant and there are more result set terms than ORDER BY terms. (check-in: 097512b604 user: drh tags: branch-3.41) | |
| 20:54 | Correctly handle SELECT DISTINCT ... ORDER BY when all of the result set terms are constant and there are more result set terms than ORDER BY terms. Fix for these tickets: [c36cdb4afd504dc1], [4051a7f931d9ba24], [d6fd512f50513ab7]. (check-in: 12ad822d9b user: drh tags: trunk) | |
| 12:28 | Additional debug/test output from the query invariant checker showing the row-number that is being checked. (check-in: e4b6eb58e6 user: drh tags: trunk) | |
| 11:50 | Update the tracing output for the query-invariant checker such that it shows the SQL that is run to verify that a found query-invariant discrepency is valid. Changes to testing logic only. (check-in: 8f45ad2740 user: drh tags: trunk) | |
| 10:21 | Do not use the one-pass optimization on an UPDATE if there is a subquery in the WHERE clause, since if the subquery is hidden behind a short-circuit operator, the subquery might not be evaluated until after one or more rows have been updated. (check-in: b5d8a9a6a5 user: drh tags: branch-3.41) | |
| 10:17 | Do not use the one-pass optimization on an UPDATE if there is a subquery in the WHERE clause, since if the subquery is hidden behind a short-circuit operator, the subquery might not be evaluated until after one or more rows have been updated. Fix for the problem reported by forum post 0007d1fdb1. This is the same problem that was fixed by [73f0036f045bf371] only for UPDATE instead of DELETE. (check-in: 2c56b984a0 user: drh tags: trunk) | |
| 09:16 | Remove a NEVER() from btreeNext(). (check-in: 40623f5ab0 user: drh tags: branch-3.41) | |
| 09:12 | Fix a broken assert() in the recovery extension. (check-in: 048711e490 user: drh tags: branch-3.41) | |
| 09:07 | Remove a NEVER() from btreeNext() that dbsqlfuzz 460aa158f9a2c41145831cc924296cde1f312b3f found could sometimes be reached. I will find a way to test that branch later. (check-in: 1dffeffe15 user: drh tags: trunk) | |
| 02:30 | Another approach at attempting to contain the damage caused by corruption that leaves MemPage.isInit clear. Works better than the previous but is still not perfect. (Closed-Leaf check-in: ba964eb0f3 user: drh tags: corruption-in-btree-init) | |
| 01:20 | When the btreeInitPage() routine detects database corruption, it should continue to the end and set MemPage.isInit before it returns SQLITE_CORRUPT, because if it leaves MemPage.isInit unset, then can cause difficulty later. dbsqlfuzz 460aa158f9a2c41145831cc924296cde1f312b3f (check-in: 44e83f8b8f user: drh tags: corruption-in-btree-init) | |
|
2023-03-15
| ||
| 18:05 | Disallow the one-pass optimization for DELETE if the WHERE clause contains a subquery. (check-in: 25e1831885 user: drh tags: branch-3.41) | |
| 17:58 | Disallow the one-pass optimization for DELETE if the WHERE clause contains a subquery. Fix for the problem reported by forum post e61252062c9d286d. This fix is more restrictive than necessary. It could be relaxed if the subquery does not involve the table that is the subject of the DELETE. (check-in: 73f0036f04 user: drh tags: trunk) | |
| 13:53 | Fix a broken assert() in the recovery extension. (check-in: 4c4e66f293 user: dan tags: trunk) | |
|
2023-03-14
| ||
| 20:16 | Fix Bloom filters on an expression index. (check-in: 11e0256b8c user: drh tags: branch-3.41) | |
| 20:08 | Fix Bloom filters on an expression index. forum post 2e427099d5 and forum post d47a0e8e3a. This problem goes back to the original introduction of Bloom filters (check-in [633bfeeea2bccdd4]) for SQLite version 3.38.0. (check-in: c028fb669a user: drh tags: trunk) | |
|
2023-03-13
| ||
| 16:08 | Include CLI's tip for -- in all builds. Better show optionality of its non-option arguments. (check-in: 9e2c771daa user: larrybr tags: trunk) | |
|
2023-03-11
| ||
| 23:29 | The cherry-pick merge at [371838562a675c1b] caused a performance regression for some queries, which is here fixed. (check-in: 6d6d95fced user: drh tags: branch-3.41) | |
| 23:21 | The check-in at [198b3e33dcfd74c7] caused a performance regression for some queries, which is here fixed. Problem reported by forum post b405033490fa56d9. (check-in: dc9f025dc4 user: drh tags: trunk) | |
| 12:27 | Allow functions named using keywords "CROSS", "FULL", "INNER", "LEFT", "NATURAL", "OUTER", and "RIGHT". (check-in: eeac3d5ec9 user: drh tags: functions-named-left) | |
| 00:15 | CLI help to reflect no-more-options option (check-in: 30d95a12eb user: larrybr tags: trunk) | |
|
2023-03-10
| ||
| 21:27 | Fix a typo in a comment. No code changes. (check-in: 76acc07540 user: drh tags: trunk) | |
| 20:54 | Give CLI a no-more-options option. (--) (check-in: 0822788752 user: larrybr tags: trunk) | |
| 13:36 | Fix a problem with the fts5 snippet() function that shows up when snippets just 1 token in length are requested. (check-in: 96d5116d17 user: dan tags: trunk) | |
| 12:47 | Merge the 3.41.1 patches into the bedrock branch. (check-in: 2780cc9f8b user: drh tags: bedrock-3.41) | |
| 12:13 | Version 3.41.1 (check-in: 20399f3eda user: drh tags: release, branch-3.41, version-3.41.1) | |
| 11:57 | Export SQLITE_FCNTL_RESET_CACHE to JS. (check-in: 6195cfc86b user: stephan tags: trunk) | |
| 00:59 | Merge the branch-3.41 patches into the reuse-schema branch. (check-in: af08bd3e6e user: drh tags: reuse-schema-3.41) | |
| 00:21 | Merge the latest 3.41 patches into a new branch called wal2-3.41. (check-in: e67bfc76fa user: drh tags: wal2-3.41) | |
|
2023-03-09
| ||
| 22:09 | Replace a lingering use of 'self' with 'globalThis' in JS code, for node compatibility. (check-in: 7e3782b5aa user: stephan tags: trunk) | |
| 16:11 | Reinstate some test cases accidentally removed by [cb023fe28560ce0f]. (check-in: 870de61f8e user: dan tags: trunk) | |
| 16:04 | In the Bloom filter optimization, hash all strings and blobs into the same value, because we do not know if two different strings might compare equal even if they have different byte sequences, due to collating functions. Formerly, the hash of a string or blob was just its length. This could all be improved. (check-in: cc8a0ee40c user: drh tags: branch-3.41) | |
| 15:08 | Fix countofview.test so that it works with SQLITE_OMIT_PROGRESS_CALLBACK builds. (check-in: d55a7742c9 user: dan tags: branch-3.41) | |
| 15:08 | Fix countofview.test so that it works with SQLITE_OMIT_PROGRESS_CALLBACK builds. (check-in: 2fc7c3fcee user: dan tags: trunk) | |
| 14:14 | Update the version number to 3.41.1 (check-in: e4e2e64725 user: drh tags: branch-3.41) | |
| 13:58 | Merge count-of-view optimization fixes from trunk. But count-of-view is still off by default for this branch. (check-in: cbbe8986ea user: drh tags: branch-3.41) | |
| 08:51 | Experimental addition of sqlite3-node.mjs, for node.js, based on feedback from forum post ac7a94d4f77db235 and related off-list discussions. Build changes only - no code changes. (check-in: a5db97fa17 user: stephan tags: trunk) | |
| 01:35 | Fix a possible NULL pointer dereference due to the sqlite3_interrupt() enhancement in the 3.41.0 release. (check-in: 66d24a220e user: drh tags: branch-3.41) | |
|
2023-03-08
| ||
| 23:05 | Fix a possible NULL pointer dereference due to the sqlite3_interrupt() enhancement at [bd8fa10e59f58886]. Reported by forum post f5a2b1db87. (check-in: 84417bbd14 user: drh tags: trunk) | |
| 22:48 | Backout the OP_MakeRecord optimization as it does not work. (check-in: 25017312d0 user: drh tags: trunk) | |
| 18:05 | Export the new SQLITE_CHANGESETAPPLY_IGNORENOOP flag to JS. (check-in: ac7359b263 user: stephan tags: trunk) | |
| 18:03 | Add the SQLITE_CHANGESETAPPLY_IGNORENOOP flag, which may be passed to sqlite3changeset_apply_v2() to have it ignore changes that would be no-ops if applied to the database (e.g. deleting a row that has already been deleted), instead of considering them conflicts. (check-in: cb023fe285 user: dan tags: trunk) | |
| 17:09 | Small performance improvement in the OP_MakeRecord opcode. (check-in: ca89daef0f user: drh tags: trunk) | |
| 14:37 | Keep the historical datatype ("INT", not "NUM") for a table created as follows: "CREATE TABLE t1 AS SELECT CAST(123 AS INT) AS value;". The use of FLEXNUM only occurs on compound queries. (check-in: dc1033af4b user: drh tags: branch-3.41) | |
| 14:28 | Change to [44135d6ea84f7ba6] that retains the historical datatype ("INT", not "NUM") for a table created as follows: "CREATE TABLE t1 AS SELECT CAST(123 AS INT) AS value;". The use of FLEXNUM only occurs on compound queries. (check-in: 6d5b589626 user: drh tags: trunk) | |
| 10:05 | Extend wasm build to support a custom sqlite3.c to support building against sqlite3-see.c. The JS code now binds the SEE-specific functions if it detects an SEE build. (check-in: dd8612c8ad user: stephan tags: trunk) | |
| 00:47 | Fix a problem in the count-of-view optimization that can lead to incorrect bytecode. dbsqlfuzz 23d782160b71c3f8f535ccb2da313dfc8eb8c631. (check-in: f45009533a user: drh tags: trunk) | |
| 00:04 | Fix an assertion fault added by [65ffee234787213c]. (check-in: d00e68baf7 user: drh tags: branch-3.41) | |
|
2023-03-07
| ||
| 23:47 | Fix a bug introduced 4 days ago by [e95439119ac200cb]: do not set the Expr.affExpr field of a generated column expression if the expression is a RAISE() function, as affExpr has a different meaning for RAISE. Forum post b312e075b5. (check-in: 1096b5a7cc user: drh tags: trunk) | |
| 19:39 | A proposed change to [44135d6ea84f7ba6] that retains the historical datatype ("INT", not "NUM") for a table created as follows: "CREATE TABLE t1 AS SELECT CAST(123 AS INT) AS value;". (Closed-Leaf check-in: a0e54fe205 user: drh tags: flexnum-proposed-fix) | |
| 19:23 | Improve how sqlite3.initWorker1API() determines whether it's running in a Worker thread. Based on feedback in forum post ac7a94d4f77db235. (check-in: 2f712b836a user: stephan tags: trunk) | |
| 19:12 | Replace use of 'self' in JS code with 'globalThis', as that works in browsers and node environments. Avoid using globalThis.location if it's not set (e.g. in node). Based on feedback in forum post ac7a94d4f77db235. Minor JS build tweaks. (check-in: dbbe8f25e5 user: stephan tags: trunk) | |
| 12:59 | In the JS sqlite3.vfs/vtab utility APIs, use a local reference to StructBinder instead of sqlite3.StructBinder, as that object is removed from the sqlite3 namespace during the final steps of API initialization. Based on feedback from forum post d19d96183badca70. (check-in: 0d89885d28 user: stephan tags: trunk) | |
| 02:24 | Fix a couple minor spacing issues in the MSVC makefile. (check-in: 46b3ac6d1f user: mistachkin tags: trunk) | |
|
2023-03-06
| ||
| 23:39 | Repair an unintential fork. (check-in: 8b524c849f user: drh tags: trunk) | |
| 23:38 | Improvements to query invariant testing such that it uses the new SQLITE_DBCONFIG_REVERSE_SCANORDER opcode to sqlite3_db_config() to make more accurate judgements about when a query is ambiguous, and hence when query invariant testing is approprate. (check-in: be9ab292cd user: drh tags: trunk) | |
| 21:38 | Cause CLI to fail noisily when deserialize option used for non-seekable "file". (check-in: 24bd7e8247 user: larrybr tags: trunk) | |
| 19:04 | Add SQLITE_DBCONFIG_REVERSE_SCANORDER for direct C-language access to the "PRAGMA reverse_unordered_selects" setting. (check-in: 83e84531b4 user: drh tags: trunk) | |
|
2023-03-05
| ||
| 07:44 | Rename sqlite3-worker1-bundler-friendly.js to sqlite3-worker1-bundler-friendly.mjs and refactor it to work as an ES6 module, based on feedback in forum post a255f89c2eadf4c4. (check-in: af312b1314 user: stephan tags: trunk) | |
| 07:33 | Correct rendering of error messages in demo-worker1.js. Remove some stray EOL whitespace. (check-in: 1d5d515ad9 user: stephan tags: trunk) | |
|
2023-03-04
| ||
| 15:49 | Cherry-pick the agg-with-indexed-expr optimization fix from trunk. (check-in: b2ad89d3f0 user: drh tags: branch-3.41) | |
| 15:36 | Fix to check-in [b9190d3da70c4171] - the agg-with-indexed-expr optimization requested by ticket [99378177930f87bd] - that can cause an incorrect answer if an aggregate subquery has a GROUP BY clause, and that GROUP BY contains a term that is not in the result set, and the outer query makes use of expression indexes. Problem reported by forum post a68313d054. (check-in: e069738769 user: drh tags: trunk) | |
| 12:57 | Show the output value from OP_AggFinal when doing byte-code tracing. (check-in: 35f10a06ba user: drh tags: trunk) | |
|
2023-03-03
| ||
| 21:17 | Make the SQLITE_DBCONFIG_STMT_SCANSTATUS option on by default in the CLI. (check-in: 5a09191186 user: dan tags: trunk) | |
| 19:56 | Fix a vdbe-coverage macro added by [f418bdd627e84e7d]. (check-in: 77f559d264 user: drh tags: trunk) | |
| 19:47 | Do not use an expression index on a generated column if generated column has the wrong affinity. (check-in: 65ffee2347 user: drh tags: branch-3.41) | |
| 19:43 | Follow-up to [e95439119ac200cb] to fix a case where a pointer is NULL due to OOM. (check-in: 2535bc8c25 user: drh tags: trunk) | |
| 18:47 | Enhance PRAGMA integrity_check so that it can detect when there are extra bytes at the end of an index record, which might cause OP_IdxRowid to malfunction. (check-in: c143f08713 user: drh tags: branch-3.41) | |
| 18:35 | Enhance PRAGMA integrity_check so that it can detect when there are extra bytes at the end of an index record, which might cause OP_IdxRowid to malfunction. dbsqlfuzz c1aa3986534d5feab8d21f28b3c1712df2ef358ba. Test case in TH3. (check-in: f418bdd627 user: drh tags: trunk) | |
| 17:11 | Cherrypick the "(X IS [NOT] NULL)" fix from trunk onto branch-3.41. (check-in: 0fc7f7c2a9 user: drh tags: branch-3.41) | |
| 16:25 | When it is known when preparing a statement that X cannot be NULL or is always NULL, transform the expression (X IS NULL) to integer value 1 or 0 instead of 'true' or 'false'. This is because under some circumstances, "Y IS TRUE" or "Y IS FALSE" may not be equivalent to "Y IS 1" of "Y IS 0". This problem was introduced by [de9c86c9e4cdb34f] and was reported by forum post 2cd11c2d37. (check-in: cc4bb05b36 user: dan tags: trunk) | |
| 15:12 | Do not use an expression index on a generated column if generated column has the wrong affinity. dbsqlfuzz 65f5eb57f8859344d5f1f33e08c77ee12960ed83 (check-in: e95439119a user: drh tags: trunk) | |
| 10:42 | Remove unnecessary call to sqlite3_dbdata_init() from shell.c.in. (check-in: c4d083a3ae user: dan tags: trunk) | |
|
2023-03-02
| ||
| 14:09 | When flattening the right operand of a LEFT JOIN, ensure that the OP_IfNullRow opcode does not NULL-out a subquery result that was computed within OP_Once. (check-in: c80b262c9d user: drh tags: branch-3.41) | |
| 13:49 | When flattening the right operand of a LEFT JOIN (check-in [41c27bc0ff1d3135]), ensure that the OP_IfNullRow opcode does not NULL-out a subquery result that was computed within OP_Once. This fixes the problem problem reported by forum post 402f05296d. (check-in: 8fe13f7a5e user: drh tags: trunk) | |
| 06:58 | Resolve a parallel build timing issue when building sqlite3.c/h from ext/wasm. For the time being, do not add sqlite3_wasm_extra_init.c to fiddle.wasm because it can cause duplicate definitions of extensions which are already built into the shell (a better resolution for this conflict is pending). No longer add sqlite3_wasm_extra_init.c to speedtest1.wasm because it's useless there. (check-in: 75fdd5b83b user: stephan tags: trunk) | |
| 05:51 | Rename some vars in the ext/wasm makefiles for consistency's sake. (check-in: c23589d92c user: stephan tags: trunk) | |
|
2023-03-01
| ||
| 20:44 | When flattening a view that is the right operand of a LEFT JOIN always insert the TK_IF_NULL_ROW expression nodes, even for TK_COLUMN expressions, as the TK_COLUMN might be a column from an outer query and hence still need to be NULLed out. (check-in: 371838562a user: drh tags: branch-3.41) | |
| 20:23 | When flattening a view that is the right operand of a LEFT JOIN, using the optimization of check-in [41c27bc0ff1d3135], always insert the TK_IF_NULL_ROW expression nodes, even for TK_COLUMN expressions, as the TK_COLUMN might be a column from an outer query and hence still need to be NULLed out. This fixes the problem described by forum post 26387ea7ef. (check-in: 198b3e33dc user: drh tags: trunk) | |
| 15:28 | Make sure subtypes do not cross a subquery boundary even if the function that returned the value with a subtype is buried down inside a larger expression. (check-in: 9dc460318d user: drh tags: branch-3.41) | |
| 15:21 | Follow-up to [bbaf1f2eb1e1637b]: Make sure subtypes do not cross a subquery boundary even if the function that returned the value with a subtype is buried down inside a larger expression. This fixes a problem identified by forum post 37dd14a538. (check-in: e72661eb68 user: drh tags: trunk) | |
| 13:54 | Do not attempt to apply the count-of-view optimization to a CTE. dbsqlfuzz ef8623915d843b150c159166ee4548c78cc6895a (check-in: abc3a38363 user: drh tags: trunk) | |
|
2023-02-28
| ||
| 21:23 | Activate SQLITE_DBCONFIG_STMT_SCANSTATUS in fuzzcheck. (check-in: 4fe1419ac3 user: drh tags: trunk) | |
| 20:06 | Updates to speedtest1.c and the speed-check.sh test script so that they work with the new SQLITE_DBCONFIG_STMT_SCANSTATUS control. (check-in: bd02df052e user: drh tags: trunk) | |
| 20:04 | Change the name of SQLITE_DBCONFIG_STMT_SCANSTATS to SQLITE_DBCONFIG_STMT_SCANSTATUS. (check-in: a63e4a150b user: dan tags: trunk) | |
| 19:39 | Add an sqlite3_db_config() option - SQLITE_DBCONFIG_STMT_SCANSTATS - for enabling and disabling the collection of sqlite3_stmt_scanstats() statistics in SQLITE_ENABLE_STMT_SCANSTATUS builds. Collection of statistics is disabled by default. (check-in: 0f5579bef2 user: dan tags: trunk) | |
| 18:06 | Only use a Bloom filter on an automatic index if one or more of the key columns in the index can take on non-TEXT values. (check-in: 5916705c73 user: drh tags: trunk) | |
| 14:28 | In the Bloom filter optimization, hash all strings and blobs into the same value, because we do not know if two different strings might compare equal even if they have different byte sequences, due to collating functions. Formerly, the hash of a string or blob was just its length. This could all be improved. Fix for the issue reported by forum post 0846211821. (check-in: 090304b870 user: drh tags: trunk) | |
| 13:46 | When an automatic index creates a Bloom filter, show that in the EXPLAIN QUERY PLAN output. (check-in: d7b2ac1c1a user: drh tags: trunk) | |
| 12:31 | Performance optimization in the varint decoder for the cell parser. (check-in: b2b91c7cb4 user: drh tags: trunk) | |
| 11:02 | Improve the error message generated by the recovery extension if it is used with a non-SQLITE_ENABLE_DBPAGE_VTAB build. (check-in: c1f2a1d55c user: dan tags: trunk) | |
|
2023-02-27
| ||
| 21:53 | Make the "unref" operation on database pages a method which is part of the PgHdr object. This is a potential performance optimization. (Leaf check-in: 37c5c8aa0e user: drh tags: unref-opt) | |
| 18:55 | Minor performance optimization in the computation of an affinity string for an index. (check-in: 07334aa17b user: drh tags: trunk) | |
| 14:48 | Further to [46639f682975dac6], the parameters of a table valued function that is on the left side of a RIGHT JOIN do not need to be in the ON clause. Add new test cases and tags to associated test cases with the code. (check-in: 18ee689de3 user: drh tags: trunk) | |
| 07:23 | Minor doc tweak for the previous commit. (check-in: a8832164d3 user: stephan tags: trunk) | |
| 07:12 | Extend wasm build to enable inclusion of client-custom C code, initialized via the SQLITE_EXTRA_INIT mechanism, per discussion in forum post 1e1c04f3ed1bc96b. (check-in: 68a52cafff user: stephan tags: trunk) | |
|
2023-02-26
| ||
| 21:09 | When a table-valued function appears as the right table of a RIGHT JOIN, the argument constraints on the table-valued function should be considered part of the ON clause of the RIGHT JOIN. (check-in: d225d077c4 user: drh tags: branch-3.41) | |
| 20:57 | When a table-valued function appears as the right table of a RIGHT JOIN, the argument constraints on the table-valued function should be considered part of the ON clause of the RIGHT JOIN. Fix for the problem reported by forum post 422e635f3beafbf6. Test cases in TH3. Possibly related to the enhancement at [501609eddf2a46d5]. (check-in: 46639f6829 user: drh tags: trunk) | |
| 19:36 | Correct substantive error (DML and DQL versus DML) of last check-in. (Leaf check-in: 703fa854f7 user: larrybr tags: db_config_ops_rewrite) | |
| 19:10 | Revise doc for SQLITE_DBCONFIG_* options, for clarification and coverage of all vararg parameters. Also, a grammo nit swat. (check-in: aa25596b1e user: larrybr tags: db_config_ops_rewrite) | |
| 11:36 | In the omit-unused-subquery-columns optimization, be sure to remove the EP_Skip and EP_Unlikely flags from the result set expressions that get nulled-out. dbsqlfuzz bf1d3ed6e0e0dd8766027797d43db40c776d2b15. (check-in: 21aec65e5e user: drh tags: trunk) | |
|
2023-02-25
| ||
| 16:03 | Split out a new variant of cellSizePtr() that applies only to leaf pages, for a small performance increase. (check-in: 22d32eef87 user: drh tags: trunk) | |
| 15:34 | Remove an unnecessary and redundant corruption checks in defragmentPage(). (check-in: 2dc7342e12 user: drh tags: trunk) | |
| 15:15 | Revert (mostly) to earlier CLI response to -echo and SQL at the command line. (check-in: 1c6cfcf6ed user: larrybr tags: trunk) | |
| 12:50 | Performance optimization on sqlite3_vsnprintf(). (check-in: 4430e6e96d user: drh tags: trunk) | |
|
2023-02-24
| ||
| 21:23 | Add the "on" option to the ".log" command in the CLI. Allow ".log on" and ".log off" even in --safe mode. Enable the .log command for fiddle builds. (check-in: 6bba9100ae user: drh tags: trunk) | |
| 21:05 | In the CLI, do not emit warnings about the incorrect usage of sqlite3_config() in Fiddle. (check-in: 847021b402 user: drh tags: trunk) | |
| 19:58 | Fix a problem with the sqlite3sessions_fullchangeset() and sqlite3changebatch_add() APIs on this branch. (check-in: a95a4bce88 user: dan tags: bedrock) | |
| 16:04 | Modify the sqlite3_config() interface so that the SQLITE_CONFIG_LOG and SQLITE_CONFIG_PCACHE_HDRSZ opcodes can be called after sqlite3_initialize(). Enhancement request [0b75886e6d48f7c2]. (check-in: 7902fb806b user: drh tags: trunk) | |
| 15:59 | Back out the SQLITE_CONFIG_URI option from anytime-config. (Closed-Leaf check-in: 0de98b8e21 user: drh tags: anytime-config) | |
| 13:45 | Adjust testrunner.tcl to make use of the new number_of_cores TCL command available in testfixture, and to use no more than half the available cores. (check-in: e0122d3863 user: drh tags: trunk) | |
| 13:25 | Add the "number_of_cores" TCL command to the testfixture. (check-in: 16ee5a7b5d user: drh tags: trunk) | |
| 12:55 | Merge enhancements from trunk into the anytime-config branch. (check-in: 04b2fdf3bc user: drh tags: anytime-config) | |
| 11:54 | Slightly faster and more precise floating-point to decimal conversion. See forum thread d1387c3979c7f557 for discussion. (check-in: 6dea6f4738 user: drh tags: trunk) | |
| 01:37 | A simpler fix to the problem described by forum thread d1387c3979c7f557. See specifically post 2d2ddc5b70c31de5. This approach is simpler, but it also runs a little slower. (Closed-Leaf check-in: 334d22bc70 user: drh tags: fp-conversion-simpler) | |
| 01:08 | Fix an incorrect optimization that was attempted as part of check-in [18de3a8e6b431a07]. (Closed-Leaf check-in: f32055e811 user: drh tags: fp-conversion) | |
|
2023-02-23
| ||
| 22:08 | Omit unnecessary branches from the enhanced floating-point conversion logic. (check-in: 32b0ba0d27 user: drh tags: fp-conversion) | |
| 21:18 | Increased precision of floating-point to decimal conversions when the floating point value has no fractional part. Forum post d1387c3979c7f557 (check-in: 18de3a8e6b user: drh tags: fp-conversion) | |
| 17:12 | Provide -DHAVE_LOG2=0 and -DHAVE_LOG10=0 compile-time options for use on systems that lack the log2() and log10() standard math library routines, to cause SQLite to substitute its own alternatives. (check-in: ff3362ab53 user: drh tags: branch-3.41) | |
| 14:43 | Fix harmless compiler warnings and a code indentation error. (check-in: de6c5c6bb4 user: drh tags: trunk) | |
| 14:22 | Allow the sqlite3_config() interface to be invoked at any time for a few choosen options: SQLITE_CONFIG_LOG, SQLITE_CONFIG_URI, and SQLITE_CONFIG_PCACHE_HDRSZ. This list will likely change before release. (check-in: e1702eb48d user: drh tags: anytime-config) | |
| 01:52 | Provide -DHAVE_LOG2=0 and -DHAVE_LOG10=0 compile-time options for use on systems that lack the log2() and log10() standard math library routines, to cause SQLite to substitute its own alternatives. (check-in: 7ee22f95e7 user: drh tags: trunk) | |
|
2023-02-22
| ||
| 21:47 | Enable the count-of-view optimization by default. Enhancement request [eaed8e36ce888f1e]. (check-in: a4aacdd323 user: drh tags: trunk) | |
| 21:11 | Avoid computing the values for unused result-set columns in subqueries. Performance optimization request [baa5bb76c35a124c]. (check-in: 7c2d340600 user: drh tags: trunk) | |
| 20:50 | Update the version number to 3.42.0 to begin the next development cycle. (check-in: 6591021639 user: drh tags: trunk) | |
| 20:42 | Remove the push-down optimization restriction that was added by check-in [1ad41840c5e0fa70] because it is no longer needed after the enhancements to compound query processing in check-in [27655c9353620aa5] This resolves the performance regression reported by forum post bcc4375032. (check-in: aa6bd6dff7 user: drh tags: trunk) | |
|
2023-02-21
| ||
| 21:26 | Update the reuse-schema branch to version 3.41.0. (check-in: bbd35706b7 user: drh tags: reuse-schema) | |
| 21:22 | Update the bedrock branch to version 3.41.0 (check-in: dc1d85707b user: drh tags: bedrock) | |
| 21:19 | Update the wal2 branch to version 3.41.0. (check-in: 7bb1f6dca2 user: drh tags: wal2) | |
| 21:19 | Update the begin-concurrent branch to version 3.41.0 (check-in: 918aea50ed user: drh tags: begin-concurrent) | |
| 20:08 | Remove some unnecessary bind() calls in JS code. (check-in: 71215599cd user: stephan tags: trunk) | |
| 18:47 | Unconditionally disable -sSTRICT_JS flag in wasm build because it no longer works with emsdk 3.1.31+. (check-in: b5e0b69649 user: stephan tags: trunk) | |
| 18:09 | Version 3.41.0 (check-in: 05941c2a04 user: drh tags: trunk, release, version-3.41.0) | |
| 13:28 | Disable DQS by default in the MSVC makefile for the amalgamation tarball. (check-in: 409a19145e user: drh tags: trunk) | |
| 12:42 | Yet another comment typo fix. No changes to working code. (check-in: cdbdc8013f user: drh tags: trunk) | |
| 12:34 | Fix a minor typo in a comment. No changes to working code. (check-in: 7981671d14 user: drh tags: trunk) | |
| 12:30 | Fix formatting and improved documentation on the various sqlite3_file_control() opcodes. Other minor documentation changes. No changes to working code. (check-in: 13280f720a user: drh tags: trunk) | |
|
2023-02-20
| ||
| 19:43 | Update the TEA version number to 3.41.0 (check-in: b450a920c0 user: drh tags: trunk) | |
| 16:55 | Fix an incorrect #ifdef in the CLI. (check-in: 3c4d29cf22 user: drh tags: trunk) | |
|
2023-02-19
| ||
| 19:16 | Fix a harmless compiler warning. (check-in: b2534d8de5 user: drh tags: trunk) | |
|
2023-02-18
| ||
| 21:59 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 38fc1d3dfc user: drh tags: reuse-schema) | |
| 21:52 | Merge the lastest trunk code into the bedrock branch. (check-in: 73e9f8d0bf user: drh tags: bedrock) | |
| 21:42 | Merge the latest trunk enhancements into the wal2 branch. (check-in: a36de0c803 user: drh tags: wal2) | |
| 21:35 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 6fb8bb2e8f user: drh tags: begin-concurrent) | |
| 20:31 | Fix stale requirement marks and fix a typo in the documentation for sqlite3_preupdate_hook(). (check-in: 655991f5d9 user: drh tags: trunk) | |
| 15:50 | Fix a harmless UBSAN warning in debugging code of the new unhex() function. (check-in: 315574d5cb user: drh tags: trunk) | |
|
2023-02-17
| ||
| 22:48 | Fix a harmless typo in the test case added by [29fc06465efb948f]. (check-in: e0a0bf56f1 user: drh tags: trunk) | |
| 18:27 | Do not allow the COUNTOFVIEW optimization to run if the count() contains a FILTER clause. dbsqlfuzz 4f8e0de6e272bbbb3e1b41cb5aea31e0b47297e3 (check-in: 29fc06465e user: drh tags: trunk) | |
|
2023-02-16
| ||
| 19:41 | A few simple test cases for the omit-unused-subquery-column optimization. (Closed-Leaf check-in: cf8f57c534 user: drh tags: omit-unused-subquery-columns) | |
| 18:04 | Provide an optimization-disable mask for this optimization. Do not do the optimization if the subquery is an aggregate or is distinct, but allow it to be an ephemeral subquery. Do not omit columns that are used in the ORDER BY of the subquery. (check-in: 6b1a1f374d user: drh tags: omit-unused-subquery-columns) | |
| 15:54 | Do not perform the omit-unused-subquery-columns optimizations on a subquery that is DISTINCT, as that can lead to incorrect results. (check-in: cc148503db user: drh tags: omit-unused-subquery-columns) | |
|
2023-02-15
| ||
| 19:53 | Fix the subquery result column NULL-ifier so that it correctly handles subquery columns past the 63rd column. (check-in: 77b220a724 user: drh tags: omit-unused-subquery-columns) | |
| 17:53 | Do not compute result columns of subqueries that are never used. Make those columns NULL instead. This optimization potentially resolves the enhancement request described by [ticket baa5bb76c35a124c]. (check-in: 5dec3cc022 user: drh tags: omit-unused-subquery-columns) | |
|
2023-02-14
| ||
| 18:09 | Update testrunner.tcl to run zipvfs test scripts on unix. (check-in: e6c8e19ab0 user: dan tags: trunk) | |
|
2023-02-13
| ||
| 19:32 | Ignore extra parentheses around a subquery on the RHS of an IN operator, because that is what PostgreSQL does. (check-in: ecdeef43b2 user: drh tags: trunk) | |
| 18:42 | Do not allow WHERE clause terms to match constant string index terms, which can happen if DQS_DDL is enabled. Follow-up to [44200596aa943963]. dbsqlfuzz 54c9db85ed4af7055f5fd0d50877875c82b11d46. (check-in: 2d2b91cc0f user: drh tags: trunk) | |
| 18:37 | Allow vector-IN expressions like "(a, b) IN ( (?,?), (?,?) )" to use an index. (check-in: 18a99d9cfb user: dan tags: trunk) | |
| 18:26 | Fix compile time option SQLITE_DEFAULT_SYNCHRONOUS so that it works consistently. (check-in: bf6f1ee77c user: dan tags: trunk) | |
| 16:10 | Allow vector-IN expressions like "(a, b) IN ( (?,?), (?,?) )" to use an index. (Closed-Leaf check-in: 1815b15ddb user: dan tags: vector-in-fix) | |
| 12:46 | In the LIKE optimization, do not analyze the new virtual WHERE clause terms until both have been added, since they are expected to be consecutive and the analysis might add complementary terms. This fixes a problem caused by [44200596aa943963] and discovered by dbsqlfuzz and recorded as case 7e3b5983727d843b910b2d9ab556e4afcd777cfb. (check-in: d35de3ad3f user: drh tags: trunk) | |
|
2023-02-11
| ||
| 21:11 | Change a variable from 32 to 64-bits to avoid a harmless compiler warning in Xcode. Forum post 402d733c22. (check-in: 0216ce23cf user: drh tags: trunk) | |
|
2023-02-10
| ||
| 21:53 | Do a better job of detecting when a WHERE clause term might be useful to an expression index. Fix for performance regression reported by forum thread e65800d8cb. (check-in: 44200596aa user: drh tags: trunk) | |
| 17:17 | Fix a problem with the fts5 trigram tokenizer and LIKE or GLOB patterns for which contain runs of 2 or fewer non-wildcard characters that are 3 or more bytes when encoded as utf-8. (check-in: 00714b39b3 user: dan tags: trunk) | |
| 14:20 | Ensure that the valueFromFunction() routine does not clear a prior parser error. dbsqlfuzz 6fa816f20cf5b62260d635d110b88f38e29d8fe1. (check-in: 7347664511 user: drh tags: trunk) | |
| 11:05 | Minor text-only updates to wasm demo/test HTML and license header. (check-in: f28e2a8613 user: stephan tags: trunk) | |
| 11:04 | Fix ext/wasm/fiddle build, which was silently broken by recent build refactoring. (check-in: dcf5329311 user: stephan tags: trunk) | |
|
2023-02-09
| ||
| 15:32 | Disable the double-quoted string misfeature by default in CLI builds. DQS can be reenabled at run-time using the ".dbconfig dqs_dml" and ".dbconfig dqs_ddl" dot-commands. (check-in: c995932c3f user: drh tags: trunk) | |
| 12:59 | Squelch two harmless signedness comparison warnings in shell.c.in. (check-in: bdd3edec13 user: stephan tags: trunk) | |
| 12:47 | New test cases added to fuzzdata8.db. (check-in: be67bafccd user: drh tags: trunk) | |
| 11:51 | The "flexnum" affinity that was added by [44135d6ea84f7ba6] needs to also be added to the output of the affinity() built-in function. dbsqlfuzz d309eaa5fe492c9606a8be876c2bc7dedb29d3d8 (check-in: f4ec68ceef user: drh tags: trunk) | |
|
2023-02-08
| ||
| 20:29 | Back out the 'txn' enhancement to date/time functions. The duration of a "transaction" is confused and needs to be straightened out prior to moving forward with this change. (check-in: 4a145f0732 user: drh tags: trunk) | |
| 19:45 | Be careful to maintain the value of 'txn' as long as there are active statements. Withdrawn See the attached Wiki page. (Closed-Leaf check-in: 98d10cb52a user: drh tags: does-not-work) | |
| 17:28 | Always use 64-bit integers for stats associated with STAT1 and STAT4. (check-in: 6647d1cb8b user: drh tags: trunk) | |
| 17:28 | Better fix the problem where optimizing an fts5 table too often causes it to become unreadable (first attempt was [35bed981]). (check-in: 459d986d38 user: dan tags: trunk) | |
| 14:49 | Cause gcc warning suppression in shell.c to be nice in other project(s). (check-in: 6b41ba2e99 user: larrybr tags: trunk) | |
| 14:25 | Update an assert() in the stat4 code that is only true for a well-formed database. (check-in: 04439f3b23 user: dan tags: trunk) | |
| 14:17 | Fix an incorrect assert() in STAT4 logic added just a few days ago on 2023-02-01. (check-in: 168fa2fb22 user: drh tags: trunk) | |
| 12:47 | Add the 'txn' date/time format. Change CURRENT_TIMESTAMP and similar to use 'tnx'-style semantics instead of 'now'-style. (check-in: 61cc8ed8d3 user: drh tags: trunk) | |
| 12:31 | Test cases to show that CURRENT_TIMESTAMP and similar hold the same value across a transaction. (Closed-Leaf check-in: 7b2fa20e31 user: drh tags: txn-date) | |
| 12:01 | Revert the behavior of date/time functions with no arguments so that they once again work like 'now', even while CURRENT_TIMESTAMP and similar work like 'txn'. (check-in: 06180caff0 user: drh tags: txn-date) | |
| 11:34 | Change the behavior of date-time functions without any arguments (and thus the CURRENT_TIME, CURRENT_DATE, and CURRENT_TIMESTAMP variables) so that they work like 'txn' instead of like 'now'. This is an incompatibility with legacy, but brings SQLite into conformance with all other SQL systems. (check-in: 1ac78be545 user: drh tags: txn-date) | |
| 08:49 | Merge wasi-patches branch into trunk. (check-in: 9902e66a37 user: stephan tags: trunk) | |
|
2023-02-07
| ||
| 23:55 | Simplify the code and add test cases. (check-in: d3bed4caff user: drh tags: txn-date) | |
| 21:55 | Add support for the 'txn' argument to date/time functions that works like 'now' but keeps the same time for the entire transaction. (check-in: 5e4f45af96 user: drh tags: txn-date) | |
| 21:03 | Update an if(...) expression in sqlite3InitCallback() to match the same expression on trunk. (check-in: c73babca38 user: dan tags: reuse-schema) | |
| 18:41 | Fix a test script problem causing "make test" to fail for non-RBU builds. (check-in: 2abc3f9de0 user: dan tags: trunk) | |
| 16:58 | Fix a typo in example documentation code for sqlite3_vtab_in_next(). (check-in: a95dbfae61 user: drh tags: trunk) | |
| 16:23 | Fix an pcache memory leak that might occur due to the munmap() enhancement of [754f331614f6f6e6] if "PRAGMA shrink_memory" is used. (check-in: f8c1f9c44b user: drh tags: bedrock) | |
| 15:57 | Avoid loading (and then discarding) schemas for all attached databases within an ATTACH command. This is inefficient for connections using shared-schema. (check-in: 50174e82ea user: dan tags: reuse-schema) | |
| 15:29 | Merge latest trunk changes into this branch. (check-in: 4d21640c58 user: dan tags: reuse-schema) | |
| 11:39 | Merge the latest trunk enhancements into the bedrock branch. (check-in: b7d9f14d78 user: drh tags: bedrock) | |
| 11:19 | Fix a dropped error code in wal.c. (check-in: 2537db6f6b user: dan tags: wal2) | |
| 10:58 | Fix an assert() in sqlite3WalFindFrame() so that it matches the equivalent assert() on trunk. (check-in: f5bf91d9bf user: dan tags: wal2) | |
|
2023-02-06
| ||
| 22:25 | Merge trunk into wasi-patches branch. (Closed-Leaf check-in: 656d36f50f user: stephan tags: wasi-patches) | |
| 21:20 | Roll back part of [c54f29d8] which attempted to use symbols which that worker does not have access to. (check-in: 90b1221137 user: stephan tags: trunk) | |
| 19:00 | Fix RBU test scripts to avoid attempting to copy or delete a locked file. (check-in: f25eb898fc user: dan tags: trunk) | |
| 19:00 | Disable an invalid assert(). Add the "WAL2" compile-time property so that test scripts can more easily determine that they are dealing with a WAL2-capable build. (check-in: e93113259e user: drh tags: wal2) | |
| 17:48 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 44f8f33d4a user: drh tags: wal2) | |
| 17:35 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 46e79167b9 user: drh tags: begin-concurrent) | |
| 16:23 | Omit the obsolete client/server test cases. (check-in: 5dde07a91d user: drh tags: trunk) | |
| 15:49 | Fix the build after the previous change (Closed-Leaf check-in: aea3b6f651 user: drh tags: test-cleanup) | |
| 15:46 | Remove the long obsolete "client/server" mode tests. (check-in: 08e3114cae user: drh tags: test-cleanup) | |
| 15:46 | Update test scripts speed1.test and speed1p.test so they may be run by testrunner.tcl. (check-in: e761d4b9c8 user: dan tags: trunk) | |
| 14:48 | Shorten the status line for testrunner.tcl so that it fits on an 80-character terminal. (check-in: b760a7307c user: drh tags: trunk) | |
| 14:16 | Fix error in the releasetest makefile target from the previous check-in. (check-in: e7fe287d79 user: drh tags: trunk) | |
| 14:11 | Update "releasetest" makefile targets to use testrunner.tcl. (check-in: 1b95676b05 user: drh tags: trunk) | |
| 14:01 | Add capability to override the JS API's internal use of console.log/debug/warn/error() with client-provided versions via the bootstrap-time config object. (check-in: c54f29d8e5 user: stephan tags: trunk) | |
| 13:36 | Fix a formatting problem in scanstatus2.test introduced by [81c118d9]. (check-in: 928ab40edb user: dan tags: trunk) | |
| 11:43 | Add the --fuzztest option to testrunner.tcl. Also, have it print whitespace over the top of the old report line before writing the new. (check-in: d83ce01fe1 user: dan tags: trunk) | |
| 11:02 | Fix problems with test scripts preventing them from running with SQLITE_DEFAULT_MEMSTATUS=0 builds. Or builds without SQLITE_ENABLE_STAT4. (check-in: c0fbc89ed2 user: dan tags: trunk) | |
| 10:47 | Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: 81c118d90b user: dan tags: trunk) | |
|
2023-02-05
| ||
| 20:29 | Do not use a Bloom filter if any outer loop lacks STAT1 data, since without STAT1 data, the query planner cannot make an accurate determination of whether or not a Bloom filter will be useful. This fixes the problem reported by forum post 56de336385. (check-in: e6ab96bd0b user: drh tags: trunk) | |
| 17:40 | Add the "devtest" makefile target that runs both fuzztest and testrunner. (check-in: c81398c621 user: drh tags: trunk) | |
| 17:09 | In fuzzcheck, only show the description of each database if the -v option is specified. (check-in: 6a58179aaf user: drh tags: trunk) | |
| 00:47 | Restore a test for pBt NULL that was removed by [12a14711afa6cddb] but turned out to be necessary, as dbsqlfuzz quickly showed us. Test case added to TH3. (check-in: 647c89dd2f user: drh tags: trunk) | |
| 00:32 | Modify the status line output from testrunner so that each line overwrites the previous rather than scrolling. (check-in: ad4d28cd68 user: drh tags: trunk) | |
| 00:24 | Changes to the sqlite_dbpage virtual table to tag or remove unreachable branches. (check-in: 12a14711af user: drh tags: trunk) | |
|
2023-02-04
| ||
| 21:25 | Avoid running rbu tests under permutation "journaltest", which does not support wal. Fix some other test script problems. (check-in: 92f018698a user: dan tags: trunk) | |
| 20:53 | Add ALWAYS() and NEVER() macros to unreachable branchs in sqlite_dbpage. (check-in: db875cd6be user: drh tags: trunk) | |
| 20:07 | Remove an ALWAYS() that can be false in some very rare cases. dbsqlfuzz 2274a23c85a93b870f7eb12fe686073da01abc33 (check-in: a4eb0b0d83 user: drh tags: trunk) | |
| 19:01 | Updates to the testrunner.tcl script so that uses a separate sub-process for each test. And so that it runs the release test procedure currently handled by wapptest.tcl. (check-in: 4c3c587500 user: dan tags: trunk) | |
| 18:58 | Changes so that wapptest.tcl still works. (Closed-Leaf check-in: 7624de3a93 user: dan tags: testrunner) | |
| 18:50 | Update testrunner.tcl usage message. (check-in: b7c246bc3f user: dan tags: testrunner) | |
| 18:47 | Add testrunner.tcl "njob" and "status" commands. (check-in: 3869cd3d30 user: dan tags: testrunner) | |
| 14:23 | Better error message when trying to do an INSERT on an sqlite_dbpage virtual table. (check-in: a98e4908da user: drh tags: trunk) | |
|
2023-02-03
| ||
| 21:18 | Fixes for testrunner.tcl on windows. (check-in: b98e19fc41 user: dan tags: testrunner) | |
| 19:28 | Fix a problem where optimizing an fts5 table too often might cause it to become unreadable. (check-in: 35bed98141 user: dan tags: trunk) | |
| 18:47 | Have testrunner.tcl run various builds as part of the 'release' command. (check-in: ba2fae30a8 user: dan tags: testrunner) | |
| 14:57 | Attempt to fix harmless compiler warnings that reportedly appear in clang 15. (check-in: c045d76b90 user: drh tags: trunk) | |
| 12:03 | Improved detection of invalid command-line arguments to the showdb and showwal debugging utility programs. (check-in: 75cdaafc77 user: drh tags: trunk) | |
| 11:32 | Avoid using Tcl command [clock] in testrunner.tcl. (check-in: b2faf9289f user: dan tags: testrunner) | |
|
2023-02-02
| ||
| 20:27 | Instead of free()ing them, retain allocated page buffers on an internal per-connection reuse-list when a page-cache is reset. (check-in: 754f331614 user: dan tags: bedrock) | |
| 20:15 | Do not run test script pendingrace.test as part of the inmemory_journal permutation. (check-in: 69d934a1bf user: dan tags: testrunner) | |
| 19:41 | Add configuration data for osx and windows to testrunner_data.tcl (check-in: e45d34656a user: dan tags: testrunner) | |
| 16:30 | Improved and simplified logic for resolving the various aliases of the schema table. (check-in: 5c19491c36 user: drh tags: trunk) | |
| 15:28 | Resolve all possible aliases and variations of the schema table names. (check-in: e7a0112b23 user: drh tags: trunk) | |
| 14:27 | Merge latest enhancments into this branch from branch wal2. (Leaf check-in: 5a22010c35 user: dan tags: begin-concurrent-pnu-wal2) | |
| 14:21 | Merge trunk enhancements into this branch. (check-in: c9b0180203 user: dan tags: wal2) | |
| 06:17 | Remove automatic installation of JS-global S object for the sake of client libraries which embed this library, per request in the forum. (check-in: 9504f68af8 user: stephan tags: trunk) | |
|
2023-02-01
| ||
| 23:24 | Adjustments of assert() statement in STAT4 in order to give 100% MC/DC. (check-in: 55a26c67ed user: drh tags: trunk) | |
| 20:45 | New assert() statements to verify that sqlite3DeleteIndexSamples() is always called with non-NULL parameters. (check-in: 92c71fdd71 user: drh tags: trunk) | |
| 20:14 | Update testrunner.tcl to use a separate process for each test script. And to run some extra tests too. (check-in: d090948a69 user: dan tags: testrunner) | |
| 15:41 | Just because a CTE is used more than once, does not mean it should be tagged with M10d_Yes and thereby prohibited from participating in the query flattening optimization. See forum thread 1d571c02963. (check-in: 66f29c403d user: drh tags: trunk) | |
| 14:17 | Fix a comment related to PENDING locks in os_unix.c. No code changes. (check-in: 6b3546c871 user: dan tags: trunk) | |
|
2023-01-31
| ||
| 20:43 | Fix a race condition during hot-journal rollback on unix that could theoretically cause spurious corruption errors. (check-in: e365dca4e5 user: dan tags: trunk) | |
| 20:21 | Fix a race condition during hot-journal rollback that could theoretically cause spurious corruption errors. (Closed-Leaf check-in: 20ea53ddf5 user: dan tags: pending-lock-race) | |
|
2023-01-30
| ||
| 20:44 | Additional tweaks to the enhancement at [609fbb94b8f01d67] to further reduce the cost estimate for constructing an automatic index on an ephemeral table, in order to resolve the performance problem described by forum post 1d571c0296. (check-in: bf1aae7a8c user: drh tags: trunk) | |
|
2023-01-29
| ||
| 06:01 | Two JS file renames which got inadvertently undone while setting up [9062b31174618c0e]. Cosmetic cleanups in ext/wasm/dist.make. (check-in: 0c2fde767f user: stephan tags: trunk) | |
| 05:09 | Correct the handling of the worker1 and promiser JS files in the face of the bundler-friendly changes. Those files require separate, bundler-friendly copies. (check-in: 9062b31174 user: stephan tags: trunk) | |
|
2023-01-28
| ||
| 21:06 | Do not assume that sub-queries that contain window functions are uncorrelated. (check-in: f27804484d user: dan tags: trunk) | |
| 21:01 | Show more details about the SrcItem.fg field in tree-trace output. (check-in: 3d05dddd0b user: drh tags: trunk) | |
| 17:37 | Fix a problem causing "PRAGMA quick_check" to return spurious corruption errors for a WITHOUT ROWID for which all columns are either virtual or part of the primary key, and for which the order of the columns in the primary key definition is different from the order in the table. (check-in: a7530f8971 user: dan tags: trunk) | |
| 16:37 | Update sqllimits1.test to account for the fact that if an odd value is specified as the length in bytes of a utf-16 string, it is truncated to the largest smaller even number. (check-in: 74508470c4 user: dan tags: trunk) | |
| 09:51 | Makefile doc touchups - no code/build changes. (check-in: 3458a481b9 user: stephan tags: trunk) | |
| 09:11 | Overhaul ext/wasm/GNUmakefile to consolidate what amounts to much copy/paste/slightly-edit duplication into a single function, called once per distinctive build mode (vanilla, ESM, bundler-friendly). (check-in: 168e5a9301 user: stephan tags: trunk) | |
| 05:09 | Enhance oo1.DB.exec() to simplify returning whole result sets. (check-in: 7b168ee2af user: stephan tags: trunk) | |
| 04:20 | Add JS bundler-friendly JS build. Minor test code cleanups. (check-in: 24d3a53dea user: stephan tags: trunk) | |
|
2023-01-27
| ||
| 23:10 | Fix compiler warning in base85.c. (check-in: bd9613fd63 user: drh tags: trunk) | |
| 20:25 | Update ext/wasm/README-dist.txt for the bundler-friendly build. (Closed-Leaf check-in: 6a5c4f6b19 user: stephan tags: js-bundler-friendly) | |
| 20:15 | Add an assert() to help static analyzers. (check-in: e446c8b4aa user: drh tags: trunk) | |
| 19:59 | Do not try to run rbu tests with builds that do not support rbu. (check-in: c74ad902e3 user: dan tags: trunk) | |
| 19:56 | Add a feature idea note to DB.exec(), derived from a forum discussion. (check-in: 792f43209c user: stephan tags: js-bundler-friendly) | |
| 17:19 | Cherrypick [3773934e91c20ca243] into trunk. (check-in: 50cf4300a6 user: stephan tags: trunk) | |
| 17:14 | Extract emcc version in JS build and use it to conditionally set build flags. Initially a workaround for Emscripten ticket #18610 but may have other uses. (check-in: 3773934e91 user: stephan tags: js-bundler-friendly) | |
| 07:53 | Work around a JS null pointer deref which could be triggered from the dev console, but not (it seems) from client-side code. (check-in: eabb551b8b user: stephan tags: trunk) | |
| 05:37 | Merge trunk into wasi-patches branch. (check-in: 2ce89f5efc user: stephan tags: wasi-patches) | |
| 05:17 | Cherrypick [fa784101775b7|emscripten ticket #18609 workaround] into trunk. (check-in: 9a26fae545 user: stephan tags: trunk) | |
| 05:14 | Work around upstream emscripten 3.1.31 ticket #18609. (check-in: fa78410177 user: stephan tags: js-bundler-friendly) | |
| 03:18 | More work on creating a separate sqlite3.js build which is hopefully friendly to JS bundlers. (check-in: b7b896fb44 user: stephan tags: js-bundler-friendly) | |
| 02:21 | Resolve a nested if-block bug in ext/wasm/c-pp.c which caused output after a nested block to be unduly elided. Remove a kludge, added in the previous check-in, which worked around that bug. (check-in: 7a026a4b24 user: stephan tags: js-bundler-friendly) | |
| 01:33 | Beginnings of a bundler-friendly build of sqlite3.mjs. Not yet ready for downstream testing. (check-in: 4271bf5f41 user: stephan tags: js-bundler-friendly) | |
|
2023-01-26
| ||
| 20:08 | End-of-line whitespace cleanups and doc typo fixes. No code changes. (check-in: bdfd72a083 user: stephan tags: trunk) | |
| 18:16 | Have some RBU tests run as part of veryquick.test/testrunner.tcl. (check-in: f51406e3bf user: dan tags: trunk) | |
| 02:18 | Improved fix to allow sqlite3_vtab_in_first() to reliably return SQLITE_ERROR. (check-in: b25eec1c13 user: drh tags: trunk) | |
|
2023-01-25
| ||
| 21:28 | Fix a harmless compiler warning in FTS3. (check-in: 68d02d3c2a user: drh tags: trunk) | |
| 19:05 | Defer calling the destructor for the user data on a module until after the module has disconnected. Forum post b68391eb71fdff73. (check-in: 1ab122289f user: drh tags: trunk) | |
| 16:56 | Enhance the sqlite3_vtab_in_first() and sqlite3_vtab_in_next() interfaces so that they reliably return SQLITE_ERROR (and not SQLITE_MISUSE) if they are invoked on a parameter that did not have multi-value IN processing enabled via a prior call to sqlite3_vtab_in(). See forum thread a823d4a3d5f73def. (check-in: 144326dc17 user: drh tags: trunk) | |
| 15:45 | Fix a problem with fts3 auxiliary functions and one or more NEAR expressions ORed together. (check-in: de4690a10a user: dan tags: trunk) | |
| 13:42 | Fix another problem with fts3/4 auxiliary functions and NEAR expressions that consist entirely of deferred tokens. (check-in: a8c91c132f user: dan tags: trunk) | |
|
2023-01-24
| ||
| 20:17 | Add scalar SQL function unhex(). (check-in: 890e9629a7 user: dan tags: trunk) | |
| 17:19 | Update unhex() to allow a second argument, specifying a set of characters that are permitted to appear between pairs of hexadecimal digits. (Closed-Leaf check-in: 66c8562690 user: dan tags: unhex-function) | |
| 11:24 | Fix a problem with using fts3 auxiliary functions with expressions like "E AND ...", where E is a NEAR expression that consists entirely of deferred tokens. (check-in: 39bfae4c46 user: dan tags: trunk) | |
|
2023-01-23
| ||
| 21:41 | Suppress a harmless compiler warning. Forum post e3f72e9291189925. The code was legal and correct. The revised code is actually less clear in its intent. But at least now there will (hopefully) be no warning. (check-in: 48bb7c8878 user: drh tags: trunk) | |
| 20:45 | Due to a coding error, check-in [8efd61e8518594e3] did not actually use just read transactions if the operation is read-only and the SQLITE_MAX_ATTACHED macro is set to 31 or more. This was due to a misuse of the writeMask field of Parse, pointed out by forum post aa173c18d5. (check-in: 8760566893 user: drh tags: trunk) | |
| 16:16 | Add the missing CARRAY_BLOB macro to the carray.h extension header. (check-in: 10bf639cd1 user: drh tags: trunk) | |
| 14:11 | Add experimental user function unhex(). (check-in: dbe424b5db user: dan tags: unhex-function) | |
|
2023-01-22
| ||
| 21:54 | Give CLI .version a place in .help output. (check-in: 5f2dfdcc34 user: larrybr tags: trunk) | |
|
2023-01-21
| ||
| 16:53 | Minor API doc cleanups and JS code simplification. (check-in: f608a3a456 user: stephan tags: trunk) | |
| 12:18 | Merge trunk into wasi-patches branch. (check-in: 6fc20d75d4 user: stephan tags: wasi-patches) | |
| 00:59 | Fix a memory leak in the TCL test harness associated with carray. (check-in: 5a316f9fd9 user: drh tags: trunk) | |
| 00:19 | Fix harmless compiler warnings. (check-in: ded60f5b34 user: drh tags: trunk) | |
|
2023-01-20
| ||
| 21:00 | Extend the carray extension to allow the use of BLOB values to be bound as an array of "struct iovec" objects. (check-in: e117a03ca6 user: drh tags: trunk) | |
| 19:19 | Two branches associated with memdb are now always taken (I believe). Tag them with ALWAYS() to verify this. (check-in: 20b9b5aa4f user: drh tags: trunk) | |
| 17:50 | Ensure that the database encoding cannot be changed while there are statements running. And that the connection is left in a valid state after an obscure OOM within sqlite3_deserialize(). (check-in: a02da71f3a user: dan tags: trunk) | |
| 15:13 | Add tests for changing the database encoding via RESET_DATABASE/VACUUM. And test that it is not possible to trick another connection with this. (check-in: b869054acb user: dan tags: trunk) | |
| 13:34 | The json_group_array(), json_group_object(), and fts5_source_id() functions should all be deterministic and innocuous. (check-in: edcb83fa0d user: drh tags: trunk) | |
|
2023-01-19
| ||
| 18:16 | Fix numbering issue in and remove duplicate test from windowB.test. (check-in: fa10e561f5 user: dan tags: trunk) | |
|
2023-01-18
| ||
| 17:39 | Emit sqlite3-api.(m)js during the JS build process, which are the JS APIs without the Emscripten/wasm-loading parts. They are hypothetically useful for arbitrary build environments/toolchains but have notable caveats related to the wasm imports, as elaborated on in the makefile. (check-in: 966b55c513 user: stephan tags: trunk) | |
|
2023-01-17
| ||
| 19:34 | Fix another issue with very large compressed LSM databases. (check-in: d71154265a user: dan tags: trunk) | |
| 19:00 | Change an now unreachable testcase() into an assert(). (check-in: 517b2c4c4e user: drh tags: trunk) | |
| 18:40 | Fix harmless compiler warnings in the CLI. (check-in: 7cf282d307 user: drh tags: trunk) | |
| 15:46 | Update virtual tables json_each and json_tree so that adding "ORDER BY rowid" to a query does not require an external sort. (check-in: ce18f0ed68 user: dan tags: trunk) | |
| 13:33 | Add test cases to confirm that the schema parsing quirk in which an ON CONFLICT clause is accepted and ignored on table CHECK constraints but raises an error on column CHECK constraints. We want to continue supporting this harmless quirk to avoid breaking legacy applications and databases that accidentally use it. (check-in: 92b6a9cd0f user: drh tags: trunk) | |
|
2023-01-16
| ||
| 21:49 | Cause .clone to not trip over sequence table as reported at forum post 71ff9e6c4c. (check-in: b44d04f7b0 user: larrybr tags: trunk) | |
| 18:13 | In the CLI, create our own private version of strncpy() to work around false-positive compiler warnings from Alpine Linux. (check-in: 83f21285fe user: drh tags: trunk) | |
|
2023-01-14
| ||
| 19:53 | Omit the long-disused FTS1 and FTS2 implements from the active source tree. The code will persist forever in the source repository, but there is no point in carrying it around in the latest tarballs where it is never used. (check-in: 2bb50d5aed user: drh tags: trunk) | |
| 19:27 | Add OOM check, per tip at forum post 933479b2d5 (check-in: eda84dcffe user: larrybr tags: trunk) | |
| 19:09 | Doc-only fix, per forum post 0cfaf6876b (check-in: eac135fd6a user: larrybr tags: trunk) | |
|
2023-01-13
| ||
| 20:49 | Fix another lsm compression-mode bug. (check-in: f9fafc9413 user: dan tags: trunk) | |
| 19:29 | In expression nodes of type REGISTER with sub-type COLUMN, ensure that the iColumn field is set correctly, as otherwise the "IS NULL" operator might be incorrectly optimized. Fix for the problem described by forum post d010a26798915b53. (check-in: 0819a1869a user: drh tags: trunk) | |
| 19:00 | Fix an error in debugging output discovered while working on the problem with RETURNING reported by forum post d010a26798. (Leaf check-in: 3ae9127f15 user: drh tags: returning-is-null-fix) | |
| 18:20 | Add missing "const" on variables in recent RBU fixes. (check-in: 9b8dcd7905 user: drh tags: trunk) | |
| 15:54 | Enhance query planning so that it check for sqlite3_interrupt() calls and periodically invokes the progress handler callback (if any) during long query analyses. (check-in: bd8fa10e59 user: drh tags: trunk) | |
| 15:31 | Update documentation for sqlite3_progress_handler(). (Closed-Leaf check-in: 41b4c407b7 user: drh tags: progress-during-prepare) | |
| 11:31 | Remove an incorrect legacy assert(). (check-in: 3006b3b32f user: drh tags: progress-during-prepare) | |
|
2023-01-12
| ||
| 20:36 | Reduce the frequency of calls to sqlite3ProgressCheck(). (check-in: 795aca4a26 user: drh tags: progress-during-prepare) | |
| 19:51 | Fix sqlite3_prepare() so that it only invokes the progress handler on every N-th call to sqlite3ProgressCheck(), where N is the progress handler step count. Also fix faulty asserts exposed by the ability to interrupt in the middle of sqlite3_prepare(). (check-in: 0546165159 user: drh tags: progress-during-prepare) | |