Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around d8cd6d49b46a3.
|
2024-03-18
| ||
| 10:54 | Fix a problem caused by a non-aggregate function with an OVER clause in a multi-row VALUES clause. (check-in: 10ee6fcb user: dan tags: exp-values-clause2) | |
|
2024-03-17
| ||
| 16:01 | Omit the "noop(X)" test SQL function. Accomplish the same thing using the idiom: "coalesce(X,random())". (check-in: 0eb2fbb8 user: drh tags: exp-values-clause2) | |
| 00:13 | Add an ALWAYS on an unreachable branch. (check-in: 0dce6211 user: drh tags: exp-values-clause2) | |
|
2024-03-16
| ||
| 21:12 | Recognize when an SQL function is constant and can occur inside an optimized VALUES clause. (check-in: c0e5ceb8 user: drh tags: exp-values-clause2) | |
| 21:04 | Fix a assert() that is incorrect, though harmless. (Closed-Leaf check-in: 9ba3cff9 user: drh tags: enhanced-expr-is-const) | |
| 20:15 | Further expand the scope of usage for the enhacement to expr-is-constant. (check-in: d7eadcf7 user: drh tags: enhanced-expr-is-const) | |
| 19:48 | Assert that the eCode is always non-zero upon entry into exprNodeIsConstant(). (check-in: f71b28f6 user: drh tags: enhanced-expr-is-const) | |
| 19:36 | Activate the enhanced constant-expression for the [constant propagation optimization](/info/f4229707ac08d66c). (check-in: 92afea38 user: drh tags: enhanced-expr-is-const) | |
| 17:04 | Extend the scope expr-is-constant for function to cover the IN-to-EQ optimization. (check-in: dae66924 user: drh tags: enhanced-expr-is-const) | |
| 14:27 | Fix exprNodeIsConstantFunction() so that it returns WRC_Continue, not WRC_Abort, if the function really is constant. (check-in: d85dd4de user: dan tags: enhanced-expr-is-const) | |
| 13:18 | Enhance the sqlite3ExprIsConstant() function so that it recognizes constant functions. So far the enhancement only applies to the multi-row VALUES clause, but it could possibly be applied in many other places. (check-in: c9e0488c user: drh tags: enhanced-expr-is-const) | |
|
2024-03-15
| ||
| 17:57 | New options for testrunner.tcl: --stop-on-error and --stop-on-coredump. (check-in: 82035b9c user: drh tags: trunk) | |
| 17:04 | Fix (totally harmless) memory leaks in Lemon to avoid warnings during ASAN builds. (check-in: ce009205 user: drh tags: trunk) | |
| 13:16 | Tweaks to the func4.test test module (which tests the rarely used totype.c extension) so that it works on i586 compiled using gcc-13 with -O0. Details at forum post 0a7553b0f734c033. (check-in: d0fbe779 user: drh tags: trunk) | |
| 12:59 | Attempt to use the Dekker high-precision floating point algorithm in the ext/misc/totype.c extension. This check-in should have been derived from trunk, not the exp-values-clause2 branch. But that's ok, because both trunk and the branch are the same in all aspects that relate to this check-in and this check-in is just parking the proposed enhancement for future consideration - it is not a serious proposal at this point. (Leaf check-in: dd41db3b user: drh tags: totype-dekker) | |
|
2024-03-14
| ||
| 20:39 | Fix testcase to account for new behaviors with this branch. (check-in: 823e5793 user: drh tags: exp-values-clause2) | |
| 19:31 | Fix a problem with ALTER TABLE and correlated multi-row VALUES clauses. (check-in: d543c829 user: dan tags: exp-values-clause2) | |
| 19:01 | Fix a problem handling "INSERT INTO ... SELECT ... UNION VALUES(...), (...)" and similar statements. (check-in: e8a2a819 user: dan tags: exp-values-clause2) | |
| 17:04 | Avoid some OP_SCopy instructions in "INSERT INTO .. VALUES" statements that insert more than one row in cases where the VALUES clause contains a value for all columns of the table. (check-in: 988f0ea7 user: dan tags: exp-values-clause2) | |
| 13:18 | JS: remove an unused function argument and some debug-related comments. No functional changes. (check-in: f1570943 user: stephan tags: trunk) | |
| 11:45 | Add further tests for VALUES clauses in various contexts. (check-in: 973d197d user: dan tags: exp-values-clause2) | |
|
2024-03-13
| ||
| 20:04 | Change the way parse.y handles multi-row VALUES clauses to save a few cycles. (check-in: 88d5bc91 user: dan tags: exp-values-clause2) | |
| 18:41 | Remove unreachable code from this branch. (check-in: 657c7b4f user: dan tags: exp-values-clause2) | |
| 18:00 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 5c8e80f4 user: drh tags: bedrock) | |
| 17:55 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 2b12da72 user: drh tags: wal2) | |
| 17:51 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 238fa84a user: drh tags: begin-concurrent) | |
| 17:33 | Fix some OOM handling problems on this branch. (check-in: 2085c7f1 user: dan tags: exp-values-clause2) | |
| 16:49 | Do not automatically activate SQLITE_ENABLE_SHARED_SCHEMA in the Makefile. Instead, enhance the mdevtest and sdevtest targets of testrunner.tcl to set that option sometimes and sometimes not. (check-in: 693b8f93 user: drh tags: reuse-schema) | |
| 16:35 | Merge the testrunner.tcl enhancement from trunk. (check-in: da471515 user: drh tags: reuse-schema) | |
| 16:32 | Minor change to the "mdevtest" and "sdevtest" in testrunner.tcl, to make it easier to add configurations in branches. (check-in: 9349d94e user: drh tags: trunk) | |
| 15:59 | Merge the latest trunk enhancements into the reuse-schema branch. Fix the reuse-schema build of the CLI so that it works again. (check-in: 70ef3784 user: drh tags: reuse-schema) | |
| 15:47 | Merge trunk into this branch. (check-in: 38635651 user: dan tags: exp-values-clause2) | |
| 15:44 | Ensure that if a multi-row VALUES cannot be coded while being parsed, the SF_MultiValue flag is correctly set. (check-in: 94791824 user: dan tags: exp-values-clause2) | |
| 15:34 | Avoid creating a co-routine incrementally for a VALUES clause that has affinities other than NONE. (check-in: 4229b12b user: dan tags: exp-values-clause2) | |
| 13:43 | If the NJOB environment variable is a positive integer, it causes testrunner.tcl to run that many jobs. (check-in: 924281b9 user: drh tags: trunk) | |
| 13:27 | Document the testrunner.tcl --explain option in doc/testrunner.md. (check-in: 5a7b5fc9 user: drh tags: trunk) | |
| 13:09 | Add the --explain option to testrunner.tcl. (check-in: f0c9eb03 user: drh tags: trunk) | |
| 11:46 | Improve one of the error messages from testrunner.tcl. (check-in: 233155c1 user: drh tags: trunk) | |
| 11:29 | Minor tweaks to the testrunner documentation. (check-in: 3128b98d user: drh tags: trunk) | |
| 10:55 | Improvements to the "help" message generated by testrunner.tcl. Add the special "list" permutation that does nothing but list all allowed values for the PERMUTATION argument to testrunner.tcl. (check-in: 1f5bfc6a user: drh tags: trunk) | |
| 10:54 | Add pointer to documentation to testrunner.tcl help message. (check-in: eff85510 user: dan tags: trunk) | |
| 10:47 | Have testrunner.tcl set SQLITE_TMPDIR on windows as well. (check-in: 64f4dad1 user: dan tags: trunk) | |
| 00:37 | On testrunner.tcl: (1) Add the "help" command. (2) Add the "script" command to the help message. (3) Improve the error message generated by "script" when an incorrect CONFIG option is provided. (check-in: 1b7f0be4 user: drh tags: trunk) | |
|
2024-03-12
| ||
| 20:10 | Correctly initialize the SrcItem.iCursor field to -1 when creating a co-routine from a multi-values VALUES clause. (check-in: c32953ff user: dan tags: exp-values-clause2) | |
| 18:33 | Have testrunner.tcl have each test store its temp files in its working directory. To avoid unlikely, but possible, collisions. (check-in: 18842d0d user: dan tags: trunk) | |
| 18:04 | Have testrunner.tcl have each test store its temp files in its working directory. To avoid unlikely, but possible, collisions. (Closed-Leaf check-in: 775a10d1 user: dan tags: testrunner-tmpdir-fix) | |
| 12:12 | Merge all version-3.45.2 patches into the reuse-schema-3.45 subbranch. (check-in: 20d9618d user: drh tags: reuse-schema-3.45) | |
| 12:00 | Merge all 3.45.2 pages into the bedrock-3.45 subbranch. (check-in: 33b9cf7c user: drh tags: bedrock-3.45) | |
| 11:55 | Merge all 3.45.2 patches into the wal2-3.45 subbranch. (check-in: 64d740c5 user: drh tags: wal2-3.45) | |
| 11:51 | Merge all version 3.45.2 patches into the begin-concurrent-3.45 subbranch. (check-in: f0723258 user: drh tags: begin-concurrent-3.45) | |
| 11:06 | Version 3.45.2 (check-in: d8cd6d49 user: drh tags: release, branch-3.45, version-3.45.2) | |
| 10:47 | First attempt at version 3.45.2, but failed to set the version number correctly in the source tree. (Closed-Leaf check-in: 78bed2b0 user: drh tags: mistake) | |
|
2024-03-11
| ||
| 23:28 | Merge the latest branch-3.45 patches into the reuse-schema-3.45 subbranch. (check-in: e22e0e1e user: drh tags: reuse-schema-3.45) | |
| 23:26 | Merge the latest branch-3.45 changes into the bedrock-3.45 subbranch. (check-in: 516b7e13 user: drh tags: bedrock-3.45) | |
| 23:23 | Merge the branch-3.45 patches into the wal2 branch. (check-in: f8cee91f user: drh tags: wal2-3.45) | |
| 23:18 | Merge the latest branch-3.45 changes into the begin-concurrent branch. (check-in: 98ea2ca2 user: drh tags: begin-concurrent-3.45) | |
| 20:34 | Fix another testrunner.tcl problem on windows. (check-in: 7805844b user: dan tags: trunk) | |
| 19:43 | Fix a missing brace problem in testrunner.tcl introduced by the previous commit. (check-in: 1f5e334d user: dan tags: trunk) | |
| 19:33 | Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it. (check-in: 6eae4547 user: dan tags: trunk) | |
| 18:21 | Run shell*.test modules with "make mdevtest". (check-in: 76c47106 user: drh tags: trunk) | |
| 17:27 | Attempt to reduce the memory used by VALUES clauses in as many statements as possible, not just INSERT. This branch still has problems. (check-in: 17d1f7cf user: dan tags: exp-values-clause2) | |
| 11:26 | Fix the ".import" command in the CLI so that it works correctly with tables that contain computed columns. (check-in: b26f2444 user: drh tags: branch-3.45) | |
| 11:24 | Fix the ".import" command in the CLI so that it works correctly with tables that contain computed columns. forum post ca014d7358. (check-in: 95a9c88b user: drh tags: trunk) | |
| 09:39 | Add more docs for the OPFS delete-before-open feature. (check-in: cb8d9c26 user: stephan tags: trunk) | |
| 09:34 | Add delete-before-open=1 URI flag to the 'opfs' VFS to tell it to xDelete the db file before opening it, primarily to enable users to work around a corrupt db without having to reach into OPFS-specific APIs to remove the db file. (check-in: e87cf0d7 user: stephan tags: trunk) | |
| 09:32 | Add delete-before-open=1 URI flag to the 'opfs' VFS to tell it to xDelete the db file before opening it, primarily to enable users to work around a corrupt db without having to reach into OPFS-specific APIs to remove the db file. (Closed-Leaf check-in: e83f9788 user: stephan tags: opfs-delete-before-open) | |
|
2024-03-09
| ||
| 18:41 | Fix the .expert command in the shell so that it does not leak memory if not followed by SQL and so that it works with reverse_unordered_selects. (check-in: 7ead022e user: drh tags: trunk) | |
| 13:31 | Fuzzcheck is run automatically by testrunner.tcl, so there is no need to include fuzzcheck as a separate dependency for the releasetest target in the MSVC makefile. (check-in: 76629b2b user: drh tags: trunk) | |
| 13:17 | Reenable the use of SQLITE_OMIT_VIRTUALTABLE by fixing a misplaced #endif caused by the merge at [c080560c2d0d753c]. (check-in: 71120ea8 user: drh tags: branch-3.45) | |
| 13:10 | Fix the rtreeJ.test module to align it with [cd017c28d516399e]. (check-in: 111b3d82 user: drh tags: branch-3.45) | |
| 12:30 | Handle an OOM case in fts5 code to query tokendata=1 tables. (check-in: ebf59fa3 user: drh tags: branch-3.45) | |
| 00:38 | The NOT NULL strength reduction optimization should be applied to the WHERE clause only. (check-in: be266c71 user: drh tags: branch-3.45) | |
|
2024-03-08
| ||
| 21:37 | The NOT NULL strength reduction optimization from [de9c86c9e4cdb34f] should be applied to the WHERE clause only. Otherwise, the operand of the IS NULL or IS NOT NULL operator might be a reference to a bare column of an aggregate table, and we can't tell if it is NULL or not based only on its NOT NULL attribute. Forum post 440f2a2f17. (check-in: 51704fea user: drh tags: trunk) | |
| 19:03 | One of the assert()s added by the previous check-in was not quite correct. This commit fixes it. (check-in: d4013583 user: drh tags: trunk) | |
| 15:39 | Add new assert() statements, which if they had existed three years ago, would have detected the code generator problem fixed by the previous check-in. (check-in: 166d1e5d user: drh tags: trunk) | |
| 14:16 | Silently ignore redundant ON CONFLICT clauses in an UPSERT. (check-in: e546d8c6 user: drh tags: branch-3.44) | |
| 14:11 | Silently ignore redundant ON CONFLICT clauses in an UPSERT. (check-in: 46245855 user: drh tags: branch-3.45) | |
| 14:01 | Silently ignore redundant ON CONFLICT clauses in an UPSERT. Only the first ON CONFLICT for each index is active. Do not issue an error, since that might break legacy queries. But ignore the redundant ON CONFLICT clauses to prevent problems such as described in forum post 919c6579c8. (check-in: d0ea6b6b user: drh tags: trunk) | |
| 13:49 | Omit some extra tests for the intck extension in OMIT_VIRTUAL_TABLE or OMIT_PRAGMA builds. (check-in: 29d9eb7d user: dan tags: trunk) | |
| 11:13 | Fix pragma6.test so that it works with ENABLE_OVERSIZE_CELL_CHECK builds. (check-in: a02551de user: dan tags: trunk) | |
| 11:08 | Do not run tests for the intck extension in OMIT_VIRTUAL_TABLE or OMIT_PRAGMA builds. (check-in: de8130c0 user: dan tags: trunk) | |
| 03:24 | Must use sqlite3IntFloatCompare() for accurate comparisons between very large integer and floating point values in RTREE. Otherwise the comparison does not work on all platforms. Further fix to [027e5336acc26f57]. (check-in: 820f106a user: drh tags: trunk) | |
|
2024-03-07
| ||
| 19:29 | Introducing JS worker1 promiser v2, which initializes via Promise (instead of a callback function) and can be loaded as an ESM module. (check-in: 2fbaf2f5 user: stephan tags: trunk) | |
| 18:53 | Resolve duplicate loading of promiser v2 demo code (a side effect of having done precisely what it was told to do). Consolidate demo-worker1-promiser(-esm).html/(m)js variants into central copies processed with c-pp. (Closed-Leaf check-in: 9347d9b9 user: stephan tags: wasm-promiser1-v2) | |
| 18:47 | Improved error handling. (Leaf check-in: cf2d1ad0 user: drh tags: exp-values-clause) | |
| 17:56 | wasm promiser.v2 is essentially working but the demo code is double-loading the module for as-yet-undetermined reasons. (check-in: aa877ce0 user: stephan tags: wasm-promiser1-v2) | |
| 17:11 | Simplify the parser changes on this branch. (check-in: 89a6c7b5 user: dan tags: exp-values-clause) | |
| 16:25 | Merge all the latest trunk enhancements into the exp-values-clause branch. (check-in: c4923f26 user: drh tags: exp-values-clause) | |
| 16:04 | Initial work at getting sqlite3Worker1Promiser.v2() to return a Promise instead of using an onready() callback, and also creating an ESM build for promiser1 per user request. It seems to work but requires more testing. (check-in: 0e272123 user: stephan tags: wasm-promiser1-v2) | |
| 15:58 | Fix harmless compiler warnings in test code for the intck extension. (check-in: 7fbdc1a8 user: drh tags: trunk) | |
| 15:44 | Add further tests for the code on this branch. (check-in: 5d8065e8 user: dan tags: exp-values-clause) | |
| 12:34 | Do not allow the query planner to be tricked into thinking that an index on a constant expression might be useful for something. Problem reported on forum post ecdfc02339. This is a follow-up to the fixes at [44200596aa943963] and [2d2b91cc0f6fed8c]. (check-in: 720ce06d user: drh tags: trunk) | |
|
2024-03-06
| ||
| 21:53 | Fix a memory leak in new memdb1.test test cases that were added by [e638d5e408ea2e18]. No changes to SQLite itself. (check-in: f0a49dc8 user: drh tags: branch-3.45) | |
| 21:22 | Fix harmless compiler warning seen with MSVC. (check-in: 5aa809bc user: mistachkin tags: branch-3.45) | |
| 21:08 | Fix harmless compiler warnings seen with MSVC. (check-in: c0f61524 user: mistachkin tags: branch-3.45) | |
| 21:06 | Fix a minor test file locking issue on Windows. (check-in: a4475280 user: mistachkin tags: branch-3.45) | |
| 21:00 | Work around obscure floating point issue seen with older versions of MSVC. (check-in: 6055715f user: mistachkin tags: branch-3.45) | |
| 20:59 | Fix two -Werror=lto-type-mismatch warnings reported in forum post ef62b57bd5. (check-in: d4e423f3 user: mistachkin tags: branch-3.45) | |
| 20:58 | The quote() SQL function should convert +Inf into 9.0e+999 and -Inf into -9.0e+999. See forum post 6675b25108. (check-in: 07a9ef88 user: mistachkin tags: branch-3.45) | |
| 20:58 | Make sure key comprisons are done correctly if the index key contains NaN values that have not been shifted into NULLs. That can only happen due to database corruption, but we need to deal with it nevertheless. (check-in: 7ed922d9 user: mistachkin tags: branch-3.45) | |