Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
223 check-ins going from 96c92aba00c8375b to 26978f34bd03b052
|
2024-05-23
| ||
| 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 | |
| 11:45 | Fix a harmless compiler warning in the ICU extension due to [acddbc489d5231da]. check-in: 3d8750e885 user: drh tags: trunk | |
|
2024-04-07
| ||
| 18:36 | Omit all rowid-in-view restrictions from the fuzzinvariant.c test module as they are no longer necessary, as of the previous check-in. check-in: 6431538f0b user: drh tags: trunk | |
| 18:23 | If SQLITE_ALLOW_ROWID_IN_VIEW is set to 2, then all rowids for views return a value of NULL. check-in: 0a53dde214 user: drh tags: trunk | |
| 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 | |
| 11:13 | Fix pragma6.test so that it works with ENABLE_OVERSIZE_CELL_CHECK builds. check-in: a02551de4c user: dan tags: trunk | |
| 11:08 | Do not run tests for the intck extension in OMIT_VIRTUAL_TABLE or OMIT_PRAGMA builds. check-in: de8130c020 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: 820f106acf 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: 2fbaf2f51d 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: 9347d9b9a6 user: stephan tags: wasm-promiser1-v2 | |
| 17:56 | wasm promiser.v2 is essentially working but the demo code is double-loading the module for as-yet-undetermined reasons. check-in: aa877ce0c3 user: stephan tags: wasm-promiser1-v2 | |
| 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: 0e272123ac user: stephan tags: wasm-promiser1-v2 | |
|
2024-03-06
| ||
| 12:28 | Correction to the previous check-in. check-in: 483fa2969e user: drh tags: trunk | |
| 11:35 | Fix handling of "id=?" corner cases in rtree when the value on the RHS is a real value. Problem reported by [forum:/forumpost/1bb055be17|forum post 1bb055be17]. check-in: 027e5336ac user: dan tags: trunk | |
|
2024-03-05
| ||
| 18:41 | Remove code that added a P4 parameter to the OP_Variable opcode. This is no longer required. check-in: dd5977c9a8 user: dan tags: trunk | |
| 17:33 | Reformulate [34439fe3aeea7cbb] slightly to resolve a false-positive OOM reported in [forum:2eadfe94e3|forum post 2eadfe94e3]. check-in: 8290646792 user: stephan tags: trunk | |
| 16:47 | The value returned by the json_each.json field needs to survive longer than the json_each virtual table itself, in the event that the value is used in an aggregate expression. dbsqlfuzz 5120bd0b3bb0b73eebbcb79ac37c6b0663fccad6 check-in: 952ed71b9b user: drh tags: trunk | |
| 12:48 | /fiddle: reorder/replace example entries to make them more coherent when tried in order and clear the example selection list when the input area is cleared, both based on forum feedback. check-in: b4ce270b3f user: stephan tags: trunk | |
| 08:48 | /fiddle 'Mandlebrot' typo fix reported in the forum. check-in: ceefe6ba38 user: stephan tags: trunk | |
| 07:55 | Update fiddle.make to account for Makefile changes in [178b7d46f9]. check-in: 7a5d810549 user: stephan tags: trunk | |
| 06:31 | /fiddle: before resetting a db, roll back any transactions (resolves problem reported in [forum:0b41a25d65|forum post 0b41a25d65]) and remove an obsolete/broken reference to a long-gone API which could cause initialization to fail prematurely. check-in: ee164ca73c user: stephan tags: trunk | |
|
2024-03-04
| ||
| 18:22 | Fix a compiler warning in date.c. Update makefiles to include all necessary dependencies for building shell.c. check-in: 178b7d46f9 user: drh tags: trunk | |
| 16:44 | Change test results in corruptC.test to account for the added detail in the output of "PRAGMA integrity_check" from [b736519d3d2e93c7]. check-in: 0d19eeaafb user: drh tags: trunk | |
| 16:18 | Fix harmless compiler warnings in the increment integrity_check extension. check-in: 596668e662 user: drh tags: trunk | |
| 13:58 | Adjust date/time functions so that they do a better job of keeping track of whether the current time is UTC or localtime, and no-op the 'utc' and 'localtime' modifiers accordingly. See [forum:/info/e7a939e074|forum post e7a939e074]. Also add the datedebug() function, available only under -DSQLITE_DEBUG, for improved visibility of the DateTime object during debugging and testing. check-in: dc56968374 user: drh tags: trunk | |
| 11:12 | Fix assert() statements in date/time computations: The month and day numbers can be zero if an error has been seen. check-in: fc773f6c76 user: drh tags: trunk | |
| 09:56 | Document why the wasm build does not use Emscripten's -sSTRICT=1 flag and account for a behaviour change in emsdk 3.1.55 regarding the HEAPxyz symbols. check-in: f6e8872033 user: stephan tags: trunk | |
| 09:23 | When warning about multiple invocations of JS's sqlite3ApiBootstrap(), use the warning logger installed by the first invocation, rather than console.warn. check-in: d162af2d99 user: stephan tags: trunk | |
| 06:54 | After wasm bootstrapping has read the optional global-scope config objects, delete those objects because any further changes would not have any useful effect. Expand the docs regarding the sqlite3ApiBootstrap() config object and explain the necessary evil of a separate global-scope object for that configuration. check-in: e6b14f7313 user: stephan tags: trunk | |
|
2024-03-03
| ||
| 20:15 | Back out the previous change. Replace it with new date modifiers "ceiling" and "floor". check-in: f0831cced2 user: drh tags: trunk | |
|
2024-03-02
| ||
| 21:02 | New date/time modifiers "mnth" and "yr" work like "month" and "year" but resolve day-of-month overflow by truncating rather than rolling over into the next month. [forum:/forumpost/232d1abb5d|Forum thread 232d1abb5d] check-in: 5d392c16bb user: drh tags: trunk | |
|
2024-02-29
| ||
| 10:55 | Fix two -Werror=lto-type-mismatch warnings reported in [forum:ef62b57bd5|forum post ef62b57bd5]. check-in: 803481f250 user: stephan tags: trunk | |
|
2024-02-28
| ||
| 15:32 | Add in a VdbeCoverage() macro needed by STAT4 that should have been part of check-in [63ef234e88857a65]. check-in: d51c699ae4 user: drh tags: trunk | |
| 01:12 | Always convert 32-bit integer literals into EP_IntValue notation, even if they contain "_" separators. check-in: 2dfc427f67 user: drh tags: trunk | |
|
2024-02-27
| ||
| 20:19 | Fix an eputf() macro without its argument in the CLI. check-in: c2f5e257d2 user: drh tags: trunk | |
| 19:57 | Add an assert() to help scan-build recognize that a variable is initialized. check-in: 10d26f1ee8 user: drh tags: trunk | |
| 16:36 | Adjust a VdbeCoverage() macro in PRAGMA integrity_check to account for the fact that arguments to the OP_Eq opcode used are never NULL. check-in: 759ccea3f6 user: drh tags: trunk | |
| 15:33 | Remove unreachable branches from the PRAGMA integrity_check enhancement of [b736519d3d2e93c7]. check-in: 6d02fb233f user: drh tags: trunk | |
| 14:31 | Ensure memory cells are properly freed before they are overwritten by OP_IntegrityCk. check-in: e50acaf934 user: dan tags: trunk | |
| 11:03 | Have "PRAGMA quick_check" compare the number of entries in tables and indexes. check-in: b736519d3d user: dan tags: trunk | |
| 11:02 | Extend sqlite3.c makefile rule to support EXTRA_SRC=list-of-c-files to append to the generated sqlite3.c, as discussed in/around [forum:ccda88cf6f1754c5|forum post ccda88cf6f1754c5]. check-in: 61676f1e18 user: stephan tags: trunk | |
| 10:52 | Allow "_" characters to appear between any two digits in an integer, real or hexadecimal SQL literal. check-in: 0e6700f43f user: dan tags: trunk | |
|
2024-02-12
| ||
| 17:01 | Have rtree avoid keeping a blob handle open following an error. check-in: 26978f34bd user: drh tags: branch-3.45 | |
|
2024-02-11
| ||
| 23:25 | Cherrypick multiple fixes for trifling faults from trunk, so that all 834 dbsqlfuzz run clean with ASAN on branch-3.45. dbsqlfuzz. check-in: c080560c2d user: drh tags: branch-3.45 | |
|
2024-02-10
| ||
| 03:12 | Further clarify sqlite3_exec() callback parameter lifetime. check-in: 044ce823a4 user: larrybr tags: branch-3.45 | |
|
2024-02-08
| ||
| 01:23 | Mention limited lifetime of string arrays passed to sqlite3_exec() callback. check-in: d14a9d81a5 user: larrybr tags: branch-3.45 | |
|
2024-02-07
| ||
| 14:16 | Detect and respond to an OOM on the jsonStringTerminate() call of jsonReturnStringAsBlob() routine. check-in: 77431aca6e user: drh tags: branch-3.45 | |
|
2024-02-06
| ||
| 13:36 | Return SQLITE_ABORT if the underlying shadow tables change in the middle of an rtree query in such a way as to invalidate an rtree internal priority queue entry. This replaces the SQLITE_ABORT_ROLLBACK mechanism added in [97cffff331b]. check-in: 061af0d74a user: drh tags: branch-3.45 | |
|
2024-02-03
| ||
| 19:41 | Following a ROLLBACK that reverts changes to an RTREE, any pending queries against that same RTREE abort with code SQLITE_ABORT_ROLLBACK. check-in: 97cffff331 user: drh tags: branch-3.45 | |
|
2024-01-30
| ||
| 16:01 | Version 3.45.1 check-in: e876e51a0e user: drh tags: release, branch-3.45, version-3.45.1 | |
|
2024-01-29
| ||
| 21:29 | Detect malformed nested JSONB earlier and stop rendering to avoid long delays. check-in: ab40e28246 user: drh tags: branch-3.45 | |
| 16:49 | Avoid a potential buffer overread when handling corrupt json blobs. check-in: ac402cc551 user: drh tags: branch-3.45 | |
| 12:58 | When rendering JSONB back into text JSON, report an error if a zero-length integer or floating-point node is encountered. Otherwise, if the node occurs at the very end of the JSONB, the rendering logic might read one byte past the end of the initialized part of the BLOB byte array. OSSFuzz 66284. check-in: 3ab08ac75d user: drh tags: branch-3.45 | |
|
2024-01-28
| ||
| 17:44 | Automatically disable the DISTINCT optimization during query planning if the ORDER BY clause exceeds 63 terms. check-in: 6edbdcc02d user: drh tags: branch-3.45 | |
| 00:35 | Apply the same fix found in [99057383acc8f920] to descending scans. check-in: 593d6a1c2e user: drh tags: branch-3.45 | |
|
2024-01-23
| ||
| 21:10 | Slight adjustment to test results for Windows in mmap1.test due to the previous check-in. check-in: a8043eaed8 user: drh tags: branch-3.45 | |
| 16:17 | In os_unix.c and os_win.c, do not allow xFetch() to return a pointer to a page buffer that is right at the end of the mapped region - if the database is corrupted in a specific way such a page buffer might be overread by several bytes. check-in: d131cab652 user: drh tags: branch-3.45 | |
| 15:04 | Fix harmless "unused parameter" compiler warning in the new fts3IntegrityMethod implementation. check-in: 9d459f6b50 user: drh tags: branch-3.45 | |
| 13:58 | Bump the version number to 3.45.1 check-in: 54d34edb89 user: drh tags: branch-3.45 | |
| 13:53 | When a JSON input is a blob, but it looks like valid JSON when cast to text, then accept it as valid JSON. This replicates a long-standing bug in the behavior of JSON routines, and thus avoids breaking legacy apps. check-in: 4c2c1b97dc user: drh tags: branch-3.45 | |
| 11:20 | Add extra checks for the validity of a numeric literal to sqlite3DequoteNumber(). Closed-Leaf check-in: d57407ef59 user: dan tags: digit-separators | |
| 10:47 | Ensure that the xIntegrity methods of fts3 and fts5 work on read-only databases. check-in: e79b97369f user: dan tags: branch-3.45 | |
|
2024-01-22
| ||
| 19:42 | Fix a problem in the previous commit with hex literals that start with "0X" instead of "0x". check-in: c063c89b11 user: dan tags: digit-separators | |
| 19:38 | Allow underscores to occur in hex literals. check-in: 81a5622946 user: dan tags: digit-separators | |
| 19:00 | Add extra tests for the code on this branch. check-in: b15bbb201a user: dan tags: digit-separators | |
| 17:18 | Do not allow digit separators that are not surrounded on both sides by digits. check-in: 5bbc378a30 user: drh tags: digit-separators | |
| 11:12 | Fix test script literal.test so that it works with SQLITE_OMIT_ALTER_TABLE builds. check-in: b57327be4b user: dan tags: digit-separators | |
|
2024-01-20
| ||
| 18:45 | Merge trunk changes into this branch. check-in: 03ade4a810 user: dan tags: digit-separators | |
| 16:46 | Add test cases for the new code on this branch. check-in: 49f29a7b4f user: dan tags: digit-separators | |
| 16:18 | Allow "_" characters to appear following any digit in an integer or real SQL literal. check-in: 401650aacc user: dan tags: digit-separators | |
| 15:13 | When doing a text-affinity comparison between two values where one or both have both a text and a numeric type, make sure the numeric type does not confuse the answer. This is a deeper fix to the problem observed by [forum:/forumpost/3776b48e71|forum pose 3776b48e71]. The problem bisects to [25f2246be404f38b] on 2014-08-24, prior to version 3.8.7. check-in: 709841f88c user: drh tags: trunk | |
| 13:18 | Ensure that the replace() SQL function always returns a TEXT value even when its first argument is numeric and its second argument is an empty string. Fix for the issue reported by [forum:/forumpost/3776b48e71|forum post 3776b48e71]. check-in: 01868ebcd2 user: drh tags: trunk | |
| 12:19 | When backing out a character in a constructed string in JSON, first make sure the string has not been reset by on OOM. check-in: 950bf9fe78 user: drh tags: branch-3.45 | |
| 12:13 | When backing out a character in a constructed string in JSON, first make sure the string has not been reset by on OOM. dbsqlfuzz 2fffbea91a5376526ea118d4fe4188c8dd35e317. check-in: 666690eb43 user: drh tags: trunk | |
| 12:00 | Fix the version number in the TEA configure script. This should have been changed by [1481baf3d55effcc] three check-ins ago. It is unclear how testing missed this. check-in: eaf2cf73fc user: drh tags: trunk | |
| 00:31 | Implement a new algorithm for computing ISO week values in strftime() based on the idea (from [forum:3681cb1bcd|Nuno Cruces]) of shifting the date being tested to the Thursday of the same week. check-in: b06ab46a9e user: drh tags: trunk | |
|
2024-01-19
| ||
| 16:51 | Allow large hexadecimal literals to be used as DEFAULT values. check-in: 8cccc1f27d user: dan tags: trunk | |
|
2024-01-18
| ||
| 16:52 | Increase the version number to 3.46.0 to begin the next development cycle. check-in: 1481baf3d5 user: drh tags: trunk | |
| 16:50 | Add support in the strftime() SQL function for conversion letters %G, %g, %U, and %V. check-in: e1155d6aa4 user: drh tags: trunk | |
|
2024-01-16
| ||
| 16:14 | Fix harmless "unused parameter" compiler warning in the new fts3IntegrityMethod implementation. check-in: bb1fe53a97 user: drh tags: trunk | |
| 16:05 | Ensure that the xIntegrity methods of fts3 and fts5 work on read-only databases. check-in: b855886c4c user: dan tags: trunk | |
| 15:04 | Clutter the code with "fall-through" comments in order to suppress nuisance compiler warnings. No logic changes. check-in: 05d2cf5e90 user: drh tags: trunk | |
| 14:54 | Remove the LLONG_MAX preprocessor macro from the series.c extension as it is apparently only C99 and later. [forum:/forumpost/4af649419b|Forum post 4af649419b]. check-in: f106bc0d21 user: drh tags: trunk | |
| 14:28 | wasm build: reformulate an awk invocation to account for awks which do not support the -e flag. Problem reported on the forum via a docker-hosted build. check-in: 90dd51153f user: stephan tags: branch-3.45 | |
| 14:24 | Various build- and code-reorg cleanups for ext/wasm. No functional changes. check-in: 835bd4a11e user: stephan tags: trunk | |
|
2024-01-15
| ||
| 17:01 | Version 3.45.0 check-in: 1066602b2b user: drh tags: trunk, release, version-3.45.0 | |