Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
153 check-ins going from 29d9eb7d55755604 to 7a65ac42c2723b78
|
2024-08-06
| ||
| 22:54 | Improved robustness of parsing of tokenize= arguments in FTS5. check-in: 7a65ac42c2 user: drh tags: branch-3.46 | |
|
2024-07-15
| ||
| 10:13 | Slight doc touchup for [af41a1e6fc8b36e9bf65]/[c7519d98ff09e] based on feedback. No code changes. check-in: a61997c315 user: stephan tags: branch-3.46 | |
|
2024-07-12
| ||
| 13:51 | Work around a difficult-to-trigger Atomics API message-passing quirk in the OPFS VFS which appears in rare instances in some browsers when running high I/O loads. This resolves [https://github.com/sqlite/sqlite-wasm/issues/12 | issue #12 of the npm distribution]. check-in: c7519d98ff user: stephan tags: branch-3.46 | |
|
2024-06-17
| ||
| 13:06 | Improve the JS-exception-to-C-result-code conversion to account for the case of a file disappearing while the OPFS VFS is waiting to acquire a lock on it. check-in: d34e788044 user: stephan tags: branch-3.46 | |
|
2024-06-12
| ||
| 21:08 | Fix a potential db corruption case triggered by the OPFS VFS's xCheckReservedLock() implementation. check-in: a7cd07d96e user: stephan tags: branch-3.46 | |
|
2024-06-09
| ||
| 17:58 | Disable the omit-noop-join optimization when there are 64 or more terms in the ORDER BY clause. check-in: a7fe90c158 user: drh tags: branch-3.46 | |
|
2024-06-05
| ||
| 16:50 | Fix an fts5 problem with secure-delete mode causing integrity-check to erroneously report a corrupt index. check-in: 0a7fa0a434 user: drh tags: branch-3.46 | |
|
2024-05-27
| ||
| 11:38 | Fix a possible buffer overwrite in the ".import" command. check-in: 55eee9f920 user: drh tags: branch-3.46 | |
|
2024-05-25
| ||
| 23:17 | Ensure that sqlite3ViewGetColumnNames() returns non-zero on any error. check-in: 01ead0a2d9 user: drh tags: branch-3.46 | |
|
2024-05-23
| ||
| 23:34 | Increase the version number to 3.46.1 check-in: 170e3a91d5 user: drh tags: branch-3.46 | |
| 23:30 | Fix the window-function group_concat() so that it returns an empty string if it has one or more empty string inputs. check-in: 7fe11274fc user: drh tags: branch-3.46 | |
| 13:25 | Version 3.46.0 check-in: 96c92aba00 user: drh tags: trunk, release, major-release, version-3.46.0 | |
|
2024-05-21
| ||
| 17:37 | Ensure an sqlite_dbdata cursor is properly reset before being used again, even if it has already encountered database corruption. check-in: 3210e1ca4d user: dan tags: trunk | |
| 14:54 | Do not attempt to run mmapcorrupt.test with builds that do not support mmap(). check-in: 54a49f1847 user: dan tags: trunk | |
| 13:34 | Fix harmless compiler warnings. check-in: aab59f9f7c user: drh tags: trunk | |
| 11:11 | Fix the -> and ->> operators so that when the RHS is a string that looks like a number, it is still treated as a string, because that is what PG does. [forum:/forumpost/9e52cdfe15c3926e|Forum post 9e52cdfe15c3926e]. check-in: de8182cf17 user: drh tags: trunk | |
|
2024-05-20
| ||
| 19:59 | Omit a capi3 test from 2007 that depends upon undefined behavior (UAF). check-in: a60a0b7513 user: drh tags: trunk | |
| 19:51 | Do not run the tests in recovercorrupt4.test with the inmemory_journal permutation. check-in: c13205d66b user: dan tags: trunk | |
| 17:52 | Improvements to the documentation of sqlite3_vtab_distinct(). Do not allow sqlite3_vtab_distinct() to return 2 or 3 if the rowid column of the virtual table is used, as doing so might lead to an incorrect answer. check-in: 08058d66d1 user: drh tags: trunk | |
|
2024-05-18
| ||
| 15:21 | JS error message and doc typos reported in the forum. No code changes. check-in: 1a073f9acf user: stephan tags: trunk | |
|
2024-05-17
| ||
| 22:51 | Improvements to a VDBE comment. No changes to anything that affects queries. check-in: c2188da860 user: drh tags: trunk | |
|
2024-05-16
| ||
| 16:22 | Add extra tests for the error messages generated by sqlite3_declare_vtab() when passed something other than a well-formed CREATE TABLE statement. check-in: 5fa0c2a026 user: dan tags: trunk | |
| 15:57 | The sqlite3_declare_vtab() interface should return SQLITE_ERROR, not SQLITE_MISUSE when a nonsense SQL input is provided, for legacy compatibility. [forum:/forumpost/4b875d7b2a|Forum post 4b875d7b2a]. check-in: 1ec2961a03 user: drh tags: trunk | |
| 00:20 | Fix a case where an error in the ORDER BY clause of an aggregate function that is part of a trigger body might cause an assert() to fail in an ALTER TABLE command. dbsqlfuzz 899d9255555a07f1fe11a0bb51a2fe197b3150cd check-in: 953271f29e user: drh tags: trunk | |
|
2024-05-15
| ||
| 15:06 | If there is no data available for a field in a corrupted record, but the type is available, have the recovery extension substitute 0, 0.0, '' or X'' instead of a NULL value. check-in: 8eb326c249 user: dan tags: trunk | |
|
2024-05-11
| ||
| 16:44 | Add tests to bestindexC.test. No changes to code. check-in: 58d938c0e0 user: dan tags: trunk | |
|
2024-05-10
| ||
| 18:24 | Fix aggregate function processing to correctly deal with OOMs inside of sqlite3ParserAddCleanup(). (dbsqlfuzz b2d11ca70e55ee8bde48ae0b53fa3e9355812f95). Also add improved testing support by causing sqlite3FaultSim(300) to simulate an OOM inside of sqlite3ParserAddCleanup() and by adding improved fault-sim support to the CLI. check-in: c6fd70b3c2 user: drh tags: trunk | |
| 09:26 | Squelch two OMIT-flag-related warnings reported in [forum:388243d9882067a9|forum post 388243d9882067a9]. No functional changes. check-in: 1d6716054d user: stephan tags: trunk | |
|
2024-05-09
| ||
| 18:39 | Add a maintenance-reminder comment explaining [dc58ed65492857]. check-in: 857f5d7fad user: stephan tags: trunk | |
| 18:00 | Reformulate a for-in loop to a for loop in wasm.xWrap() to work around downstream frameworks modifying the JS Array prototype, as reported in [forum:b549992634b55104|forum post b549992634b55104]. check-in: dc58ed6549 user: stephan tags: trunk | |
|
2024-05-08
| ||
| 17:57 | Rename a shadowed local var, as reported in [forum:2ba65af3148585cf|forum post 2ba65af31]. No functional changes. check-in: d030c87c4d user: stephan tags: trunk | |
| 11:51 | Fix a hyperlink typo in session documentation. check-in: 42d67c6fed user: drh tags: trunk | |
|
2024-05-07
| ||
| 19:45 | Fix bug in test script sessionconflict.test. check-in: e29decb8b1 user: dan tags: trunk | |
| 17:58 | Ensure successive scans of pragma virtual tables return consistent rowids. check-in: 6838bf3ac1 user: dan tags: trunk | |
| 13:20 | Fix a compilation error in test/lemon-test01.y, reported in [forum:f0ad095705|forum post f0ad095705]. check-in: 576b68c8b5 user: stephan tags: trunk | |
|
2024-05-06
| ||
| 20:21 | When extracting links from sqlar archives, clobber any existing file or link, and do not call utimes() to set the timestamp - it looks through the link and operates on the target. check-in: 2bf8c3f99a user: dan tags: trunk | |
| 20:18 | Omit redundant unary + operators from the AST. check-in: f81cc149e5 user: drh tags: trunk | |
| 19:04 | Avoid unnecessary recursion in sqlite3ExprDeleteNN(). This complicates the code, but it is needed to prevent nuisance "stack overflow" reports from OSSFuzz while it is running the latest ASAN. check-in: 70abc144ca user: drh tags: trunk | |
| 17:55 | Add new sessions API sqlite3changegroup_add_change(). check-in: 5eaab43ce4 user: dan tags: trunk | |
| 11:27 | Fix problem in sqlar_uncompress() when being used to extract symbolic links. check-in: 4d90c3f179 user: dan tags: trunk | |
|
2024-05-05
| ||
| 10:00 | Add comment to the test/lemon-test01.y file indicating that it does not work and is for historical reference only. check-in: 9bdf73a8d4 user: drh tags: trunk | |
|
2024-05-04
| ||
| 16:50 | Add test cases to test/in7.test. No code changes. check-in: 8c3086f9fe user: dan tags: trunk | |
| 15:10 | Assume that an SQL function is able to return a subtype if any of its arguments are SQL functions that are able to return subtypes. This closes a corner-case hole in the patch at [ba789a7804ab96d8]. check-in: b36d499e4c user: drh tags: trunk | |
|
2024-05-02
| ||
| 19:22 | Fix a problem with queries that use "IN(...) ORDER BY ... NULLS LAST" or similar introduced by [d7648e21605a0b38]. check-in: 26b2d9390f user: dan tags: trunk | |
| 18:16 | Avoid an assert failure accessible only when internal testing features are enabled. dbsqlfuzz crash-66abacda6bca6bd531e25595e8c8068e2c710326.txt. check-in: fbc446daac user: dan tags: trunk | |
| 17:46 | Fix a case where the recovery extension might write uninitialized data to the recovered database. check-in: 8519b4d039 user: dan tags: trunk | |
| 14:48 | Avoid an OP_Next in cases where an IN(...) query against a UNIQUE index may return at most 1 row. check-in: d7648e2160 user: dan tags: trunk | |
|
2024-05-01
| ||
| 19:48 | Avoid an OP_Next in cases where an IN(...) query against a UNIQUE index may return at most 1 row. Closed-Leaf check-in: 560f64157d user: dan tags: unique-in-opt | |
|
2024-04-30
| ||
| 19:34 | Avoid 32-bit overflow when calculating ncycle for ".scanstats vm". check-in: 2858efa06d user: dan tags: trunk | |
|
2024-04-26
| ||
| 19:10 | Fix issues in [/info/1e227ad9f413227f|LIMIT/OFFSET support for virtual tables]. The first problem was reported by [forum:/forumpost/c243b8f856|forum post c243b8f856]. That report prompted an enhancement to the generate_series() (also included in this merge) which in turn identified other similar issues. check-in: 5f6c079d84 user: drh tags: trunk | |
| 18:42 | Internal JS doc touchups. No functional changes. check-in: 626b997b4e user: stephan tags: trunk | |
| 18:24 | Additional internal docs in the wasm utilities. check-in: 5a2245a9eb user: stephan tags: trunk | |
| 11:32 | Fix the TreeView display of a LIMIT clause on a compound query. Debugging code only - not part of production builds. check-in: 38f1e5ce4e user: drh tags: trunk | |
|
2024-04-25
| ||
| 23:26 | Improvement to the way that affinity is determined for columns of a compound subquery. The affinity is the affinity of the left-most arm of the compound subquery that has an affinity other than NONE, adjusted to accommodate the data types coming out of the other arms. check-in: e6df846f36 user: drh tags: trunk | |
| 06:52 | wasm: add a makefile comment about the static sqlite3.h/c version info injected into the JS files possibly differing from the runtime-emited version info when a user provides their own sqlite3.c. check-in: d99a01a0f6 user: stephan tags: trunk | |
|
2024-04-24
| ||
| 16:36 | If a RETURNING clause contains a subquery that references the table that is being updated in the statement that includes the RETURNING clause, then mark the subquery as correlated so that it is recomputed for each result and not just computed once and reused. See [forum:/forumpost/2c83569ce8945d39|forum post 2c83569ce8945d39]. check-in: 9ea6bcc8fd user: drh tags: trunk | |
| 14:18 | Fix a case where a corrupt stat4 record could go unrecognized due to integer overflow. check-in: 240a4a48b2 user: dan tags: trunk | |
| 11:51 | Add comments linking the assert() added in [cef4d9e3ba586735] to the places where the precondition that the assert() tests are actually required. check-in: 6f0e7e1952 user: drh tags: trunk | |
| 11:40 | Avoid slowdown when exprNodeIsConstant() is called on deeply nested SQL functions. check-in: 1c0b034545 user: dan tags: trunk | |
| 11:21 | Ensure that temporary SrcItem objects created by trigger processing have either SrcItem.zName or SrcItem.pSelect defined. Every SrcItem should have one or the other. check-in: cef4d9e3ba user: drh tags: trunk | |
| 06:43 | Remove an undocumented feature from the JS Worker1.open API because it relies on broken behavior which has no VFS-agnostic workaround. check-in: 3a640038c7 user: stephan tags: trunk | |
|
2024-04-23
| ||
| 12:02 | Fix a problem with vector IN operators used with an index where the affinities and collations for the various vector terms are different. check-in: 86e8c782e7 user: drh tags: trunk | |
| 11:56 | Fix an uninitialized variable problem in the new code on this branch. Closed-Leaf check-in: 85625b3871 user: dan tags: vector-in-fix | |
|
2024-04-20
| ||
| 19:19 | Slight performance improvement for the new code on this branch. check-in: 500c67f134 user: dan tags: vector-in-fix | |
| 15:14 | Fix a problem where an expression like (a, b) IN (SELECT ...) might not use an index on (a, b) if the affinities and collation sequences of "a" and "b" are not identical. check-in: 4d870fd8b5 user: dan tags: vector-in-fix | |
|
2024-04-18
| ||
| 16:11 | Correct handling of OUTER JOIN when on or the other operand is a subquery implemented using the VALUES-as-coroutine optimization. dbsqlfuzz bde3bf80aedf25afa56e2997a0545a314765d3f8. check-in: 8c0f69e0e4 user: drh tags: trunk | |
|
2024-04-15
| ||
| 20:43 | The first assert() added in [0ebc65481f4a3e79] is not necessarily true in a corrupt database file. So add a term to make it true. check-in: 6b21cccdee user: drh tags: trunk | |
|
2024-04-12
| ||
| 18:46 | If a build fails in testrunner.tcl, do not attempt to run the jobs that depend on that build. Instead, report those jobs as having been skipped. check-in: b40580be71 user: drh tags: trunk | |
| 15:02 | Fixes and new tests logic to ensure that the btree overflow page cache is only used when it is consistent. This resolves the malfunction observed in [forum:/forumpost/284955a3cd454a15|forum post 284955a3cd454a15]. check-in: 5dede50d9e user: drh tags: trunk | |
|
2024-04-11
| ||
| 19:08 | Fix handling of the SQLITE_OMIT_WAL check in one place. Resolves [forum:87cc13302de160eb|forum post 87cc13302de160eb]. check-in: 5dae6e6df4 user: stephan tags: trunk | |
|
2024-04-09
| ||
| 19:23 | Fix a "shift exponent is too large" usan error that could occur in the fts3 snippet() function when a query phrase contains more than 64 tokens. check-in: 6d2c7ac4ec user: dan tags: trunk | |
| 15:09 | Avoid some performance problems in the recover extension when recovering strategically corrupted databases. check-in: e66a834bba user: dan tags: trunk | |
| 13:57 | The read-only CHECK-constraint optimization of [34ddf02d3d21151b] inhibits the xfer optimization for tables with CHECK constraints. However, the xfer optimization is required for correct operation of VACUUM INTO on tables that contain generated columns. Fix this by ignoring CHECK constraints when qualifying the xfer optimization while running VACUUM. Problem reported by [forum:/forumpost/3ec177d68fe7fa2c|forum post 3ec177d68fe7fa2c]. check-in: a6e26e7788 user: drh tags: trunk | |
|
2024-04-08
| ||
| 17:55 | Update tests in returning1.test to account for [c7896e88]. check-in: c02956cd5c user: dan tags: trunk | |
| 11:50 | Enhance the WHERE-clause push-down optimization so that it is able to push down WHERE clause terms that contain uncorrelated subqueries. check-in: 69ec714b2d user: drh tags: trunk | |
| 06:37 | Enhancements to the fuzzer invariant checker to turn optimizations on and off. Closed-Leaf check-in: 6759448137 user: drh tags: pushdown-subquery | |
|
2024-04-07
| ||
| 18:55 | Merge trunk testing enhancements into the pushdown-subquery branch. check-in: 287ff24b26 user: drh tags: pushdown-subquery | |
| 10:30 | Merge trunk enhancements into the pushdown-subquery branch. check-in: 27865e316f user: drh tags: pushdown-subquery | |
| 10:27 | Add comments to note the name abiguity between the MySQL push-down optimization and the WHERE-clause push-down optimization. check-in: 3d5fb1ec7a user: drh tags: trunk | |
|
2024-04-06
| ||
| 17:37 | Improvements to the accurancy of the fuzzinvariants.c testing module when SQLITE_ALLOW_ROWID_IN_VIEW is defined and the test query involves rowids. check-in: c6e873d4db user: drh tags: trunk | |
|
2024-04-05
| ||
| 13:56 | Check-in [a9657c87c53c1922] is wrong: the IndexedExpr.bMaybeNullRow flag is required for virtual columns if they are part of an outer join. Add a test case (derived from dbsqlfuzz b9e65e2f110df998f1306571fae7af6c01e4d92b) to prove it. check-in: 4484ec6d26 user: drh tags: trunk | |
| 11:23 | When compiling with SQLITE_ALLOW_ROWID_IN_VIEW, if the RETURNING clause of an UPDATE of a view specifies a rowid, then return NULL for the value of that rowid. dbsqlfuzz 7863696e9e5ec10b29bcf5ab2681cd6c82a78a4a. check-in: c7896e8885 user: drh tags: trunk | |
|
2024-04-04
| ||
| 22:53 | Optimize sqlite3.oo1.DB.exec() for the rowMode='object' case to avoid converting the object property keys (column names) from native code to JS for each row. This speeds up large data sets considerably and addresses the report in [forum:3632183d2470617d|forum post 3632183d2470617d]. check-in: 8b41ef8690 user: stephan tags: trunk | |
| 14:26 | Add the "interstage-heuristic" that attempts to avoid wildly inefficient queries that use table scans instead of index lookups because the output row estimates are inaccurate. check-in: 7bf49e2c54 user: drh tags: trunk | |
|
2024-04-02
| ||
| 14:12 | Fix typos in comments. Provided ".wheretrace" debugging output for the interstage heuristic module. Do omit automatic index loops in the interstage heuristic. Closed-Leaf check-in: 186dcae19e user: drh tags: interstage-heuristic | |
| 11:44 | Add a heuristic in between the two solver() passes of the query planner that tries to prevent a very slow query plan in cases where the output row count estimate is imprecise. check-in: 8018417b01 user: drh tags: interstage-heuristic | |
|
2024-04-01
| ||
| 15:38 | Improved comments in the query planner logic that computes the cost for a particular step in a query plan. No code changes. check-in: 0b2ac2cdc7 user: drh tags: trunk | |
|
2024-03-30
| ||
| 14:11 | Make explicit that sqlite3_keyword_name()'s index is 0-based, per forum request. Doc changes only. check-in: 090943dc31 user: stephan tags: trunk | |
|
2024-03-28
| ||
| 10:58 | Document that the order of an update hook call is unspecied vis-a-vis the final result of the operation which triggers that hook. Doc changes only. check-in: 3d4b1f0791 user: stephan tags: trunk | |
|
2024-03-27
| ||
| 20:34 | Update comments in fts5.h. check-in: 862945d5c4 user: dan tags: trunk | |
|
2024-03-26
| ||
| 18:07 | Add extra tests to vtabL.test. check-in: fe209099f5 user: dan tags: trunk | |
| 11:14 | Avoid expanding integer values in columns with real affinity to the full 8-byte representation when editing records as part of a DROP COLUMN command. check-in: a49296de00 user: dan tags: trunk | |
|
2024-03-25
| ||
| 20:35 | The RAISE() operator is not a constant expression and cannot participate in the VALUE-as-coroutine optimization. dbsqlfuzz 74cf7c9904360322a6c917e4934b127543d1cd51 check-in: 6a06dc7384 user: drh tags: trunk | |
| 20:00 | Add further tests for sqlite3_declare_vtab(). check-in: f3c4433f6b user: dan tags: trunk | |
| 19:31 | Simplifications to the sqlite3_declare_vtab() implementation. Changes some conditionals into assert() statements, for coverage. check-in: ff7b898a6f user: drh tags: trunk | |
| 18:30 | Fix a theoretical OOB memory access in sqlite3_stmt_scanstatus_v2(). check-in: 87be958074 user: dan tags: trunk | |
| 18:24 | Revert the previous change. Instead, do a pre-check of the CREATE TABLE statement that is the second argument to sqlite3_declare_vtab() and if the first two keywords are not "CREATE" and "TABLE", then raise an SQLITE_MISUSE error. check-in: 6a2ff83512 user: drh tags: trunk | |
| 17:43 | Remove an ALWAYS() from a condition that can be true. check-in: 715fcf033a user: drh tags: trunk | |
| 14:44 | Fix an inaccuracy in automatic indexes that was exposed by the fix at [80c4223098c1827f]. check-in: fdc9406f1c user: drh tags: trunk | |
| 13:18 | Fix the pragma4.test script so that it works with SQLITE_OMIT_VIRTUALTABLE. check-in: f8fe6fb69c user: drh tags: trunk | |
| 12:28 | Fix recent test case changes so that they also work on Windows. check-in: 38578b5af2 user: drh tags: trunk | |
| 11:34 | Use the SQLITE_CONSTRAINT return value from xBestIndex to prohibit bad query plans in the pragma virtual table. check-in: b1259d4448 user: drh tags: trunk | |
| 10:55 | Improvements to the vtablog.c extension: Eliminate memory leaks. More diagnostic output for xBestIndex. check-in: 92e9a71bc4 user: drh tags: trunk | |
| 10:28 | Flag sqlite3_trace() and sqlite3_profile() as deprecated so that the doc generator for funclist.html sees them as such, and add 'Deprecated' to their page's title for consistency with other deprecated APIs. Comment changes only. Addresses [forum:0901025836|forum post 0901025836]. check-in: 87c54f93f5 user: stephan tags: trunk | |
| 00:38 | Improvements to the vtablog.c extension, for better logging of virtual table interactions. check-in: e253bb36a5 user: drh tags: trunk | |
|
2024-03-24
| ||
| 21:10 | Fix the xBestIndex method of the pragma virtual table so that it correctly gives a higher cost to plans where the schema hidden parameter is unconstrained. Fix for the problem reported by [forum:/forumpost/85b6a8b6705fb77a|forum post 85b6a8b6705fb77a]. check-in: bc516ff520 user: drh tags: trunk | |
| 20:26 | Improved "wheretrace" debugging output for calls to xBestIndex. No changes to release code. check-in: 33966bb06c user: drh tags: trunk | |
| 16:33 | Do not automatically assume that ROWID is NOT NULL when compiled with SQLITE_ALLOW_ROWID_IN_VIEW. dbsqlfuzz 31b38eeb63a4e1562de665078f52b7b47a7543cf check-in: 80c4223098 user: drh tags: trunk | |
|
2024-03-23
| ||
| 15:17 | Fix an adverse interaction between CREATE TABLE AS and the new [/info/a120c9235f125e05|VALUES-as-coroutine] optimization. dbsqlfuzz c2c5e7e08b7e489d270a26d895077a03f678c33b check-in: 84b6fdea0b user: drh tags: trunk | |
|
2024-03-22
| ||
| 10:32 | Fix incorrect boundary assert()s on the new OP_IfSizeBetween opcode. check-in: 8eda4797c5 user: drh tags: trunk | |
|
2024-03-21
| ||
| 22:18 | Test case for the assert() problem fixed by [9ba3cff9d48fe8fc]. check-in: 865f0de7a1 user: drh tags: trunk | |
| 15:52 | Add comments (only, no code) to the JS sqlite3_config() bindings reminding us why SQLITE_CONFIG_ROWID_IN_VIEW is specifically not included. JNI does not need this treatment because it explicitly supports only a very small subset of config options. check-in: 4fea396221 user: stephan tags: trunk | |
| 11:46 | Enhancements to testrunner.tcl: (1) Add the "--config CONFIGS" option, to that only configuration named on the comma-separated list CONFIGS are run. (2) Add the "--omit CONFIGS" to omit configuration on the CONFIGS list (3) Add the Android configuration to "release" check-in: 4ccb372967 user: drh tags: trunk | |
| 11:37 | Have os_unix.c reuse cached file-descriptors in the case when a read-write fd is requested on a read-only file and a read-only fd returned. check-in: a678e85402 user: dan tags: trunk | |
| 10:35 | Fix all test cases so that they work with SQLITE_ALLOW_ROWID_IN_VIEW. check-in: 66c69e2f20 user: drh tags: trunk | |
|
2024-03-20
| ||
| 16:56 | Change EXPLAIN QUERY PLAN output to say "USE TEMP B-TREE FOR LAST TERM OF ORDER BY", or "LAST N TERMS OF ORDER BY", instead of "RIGHT PART OF ORDER BY". check-in: 7e13a2c758 user: dan tags: trunk | |
| 10:45 | Fix the SQLITE_ALLOW_ROWID_IN_VIEW bug-compatibility option so that it works again. Add the SQLITE_CONFIG_ROWID_IN_VIEW sqlite3_config() value to optionally disable the bug-compatibility mode at start-time. Enable testing of SQLITE_ALLOW_ROWID_IN_VIEW. check-in: b6802565df user: drh tags: trunk | |
|
2024-03-19
| ||
| 19:42 | Make sure the new u1.nRow value is copied when making a copy of a SrcItem object. This fixes a problem in [ac6f095e13e43d66] from yesterady. check-in: 262f8f9d80 user: drh tags: trunk | |
| 10:41 | Adjustments to the test cases for the previous check-in to make them cross-platform Linux/Mac/Windows. Test changes only. No change to core code. check-in: 0dddadbd5b user: drh tags: trunk | |
| 10:16 | Fix another problem from [c63e26e705f5e967] involving infinities and the Kahan-Babushka-Neumaier summation algorithm. Problem reported by [forum:/forumpost/23b8688ef4|forum post 23b8688ef4]. check-in: 45d272ef38 user: drh tags: trunk | |
|
2024-03-18
| ||
| 21:08 | Fix asan problems in sqlite3rbu.c. Enable RBU for sanitizer release tests. check-in: ad2ae7717e user: dan tags: trunk | |
| 20:52 | Avoid spurious SQLITE_IOERR_DATA errors when reading partial pages from a cksumvfs database using a SQLITE_DIRECT_OVERFLOW_READ build. check-in: 0f485dbece user: dan tags: trunk | |
| 18:03 | Remove unnecessary blank lines from build commands in the default Makefile.in. check-in: 76fb3a908f user: drh tags: trunk | |
| 18:00 | Add the "VALUES-as-coroutine" optimization. Large VALUES clauses on an INSERT, for example, prepare and run in about half the time and with half the memory. This check-in also includes enhancements to the internal sqlite3ExprIsConstant() routine to recognize pure SQL functions as constant if they have constant arguments. check-in: a120c9235f user: drh tags: trunk | |
|
2024-03-15
| ||
| 17:57 | New options for testrunner.tcl: --stop-on-error and --stop-on-coredump. check-in: 82035b9cfd user: drh tags: trunk | |
| 17:04 | Fix (totally harmless) memory leaks in Lemon to avoid warnings during ASAN builds. check-in: ce009205a8 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:/forumpost/0a7553b0f734c033|forum post 0a7553b0f734c033]. check-in: d0fbe779bc user: drh tags: trunk | |
|
2024-03-14
| ||
| 13:18 | JS: remove an unused function argument and some debug-related comments. No functional changes. check-in: f15709430d user: stephan tags: trunk | |
|
2024-03-13
| ||
| 16:32 | Minor change to the "mdevtest" and "sdevtest" in testrunner.tcl, to make it easier to add configurations in branches. check-in: 9349d94e05 user: drh tags: trunk | |
| 13:43 | If the NJOB environment variable is a positive integer, it causes testrunner.tcl to run that many jobs. check-in: 924281b94d user: drh tags: trunk | |
| 13:27 | Document the testrunner.tcl --explain option in doc/testrunner.md. check-in: 5a7b5fc99a user: drh tags: trunk | |
| 13:09 | Add the --explain option to testrunner.tcl. check-in: f0c9eb0326 user: drh tags: trunk | |
| 11:46 | Improve one of the error messages from testrunner.tcl. check-in: 233155c174 user: drh tags: trunk | |
| 11:29 | Minor tweaks to the testrunner documentation. check-in: 3128b98d26 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: 1f5bfc6a90 user: drh tags: trunk | |
| 10:54 | Add pointer to documentation to testrunner.tcl help message. check-in: eff855102f user: dan tags: trunk | |
| 10:47 | Have testrunner.tcl set SQLITE_TMPDIR on windows as well. check-in: 64f4dad1f9 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: 1b7f0be440 user: drh tags: trunk | |
|
2024-03-12
| ||
| 18:33 | Have testrunner.tcl have each test store its temp files in its working directory. To avoid unlikely, but possible, collisions. check-in: 18842d0d72 user: dan tags: trunk | |
|
2024-03-11
| ||
| 20:34 | Fix another testrunner.tcl problem on windows. check-in: 7805844bc4 user: dan tags: trunk | |
| 19:43 | Fix a missing brace problem in testrunner.tcl introduced by the previous commit. check-in: 1f5e334d98 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: 6eae4547d4 user: dan tags: trunk | |
| 18:21 | Run shell*.test modules with "make mdevtest". check-in: 76c4710618 user: drh tags: trunk | |
| 11:24 | Fix the ".import" command in the CLI so that it works correctly with tables that contain computed columns. [forum:/forumpost/ca014d7358|forum post ca014d7358]. check-in: 95a9c88b25 user: drh tags: trunk | |
| 09:39 | Add more docs for the OPFS delete-before-open feature. check-in: cb8d9c269c 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: e87cf0d770 user: stephan tags: trunk | |
|
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: 7ead022eda 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: 76629b2bff user: drh tags: trunk | |
|
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:/forumpost/440f2a2f17|Forum post 440f2a2f17]. check-in: 51704feae2 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: d401358329 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: 166d1e5d26 user: drh tags: trunk | |
| 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:/forumpost/919c6579c8|forum post 919c6579c8]. check-in: d0ea6b6ba6 user: drh tags: trunk | |
| 13:49 | Omit some extra tests for the intck extension in OMIT_VIRTUAL_TABLE or OMIT_PRAGMA builds. check-in: 29d9eb7d55 user: dan tags: trunk | |