Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
355 check-ins going from 7fe11274fc05a377 to 15ed002aed12556a
|
2024-05-23
| ||
| 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 | |
| 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 | |
| 00:58 | Bring the extra-src branch up to date with the trunk. Closed-Leaf check-in: 12ff5c5c41 user: stephan tags: extra-src | |
|
2023-12-28
| ||
| 20:54 | Update fts5origintext4.test to work with SQLITE_DIRECT_OVERFLOW_READ. check-in: 15ed002aed user: dan tags: trunk | |
| 19:18 | Performance improvement by unwinding a loop in jsonAppendString(). check-in: 190ab3c084 user: drh tags: trunk | |
| 16:25 | Fix harmless compiler warnings in FTS5. check-in: 3cd5ef44e4 user: drh tags: trunk | |
| 16:21 | Enhance the (undocumented, debug-only) json_parse() SQL function so that it returns the text rendering of the JSONB parse of the input, rather than printing the rendering on stdout. check-in: 056de8d551 user: drh tags: trunk | |
|
2023-12-27
| ||
| 16:24 | Fix a problem in the shell tool (not library) causing an out-of-bounds write if an ".open" command failed, then the user pressed ctrl-c to interrupt a query running on the substitute in-memory database. check-in: 026618b9e3 user: dan tags: trunk | |
|
2023-12-26
| ||
| 15:52 | Ensure that the xColumnText(), xQueryPhrase() and xPhraseFirstColumn() APIs all return SQLITE_RANGE if they are passed a bad column or phrase number. check-in: 1a8a9b1c89 user: dan tags: trunk | |
| 13:20 | Improved handling of malformed unicode within JSON strings. check-in: e252bdf5f5 user: drh tags: trunk | |
|
2023-12-24
| ||
| 12:02 | Remove an ALWAYS() added in [c50e6c2ace49d092] because it is sometimes false. dbsqlfuzz c393a4f783d42efd9552772110aff7e5d937f15e. check-in: b9daf37e57 user: drh tags: trunk | |
| 11:43 | Fix harmless compiler warnings associated with [5db30bcc338aac1c] check-in: e55d1c2333 user: drh tags: trunk | |
| 11:31 | Avoid signed integer overflow during integrity_check of FTS5. check-in: 5937df3b25 user: drh tags: trunk | |
|
2023-12-23
| ||
| 19:03 | Improvements to the query planner to address the inefficiency described by [forum:/forumpost/2568d1f6e6|forum post 2568d1f6e6]. check-in: 72fcc12cda user: drh tags: trunk | |
| 11:31 | Add debugging output routines sqlite3ShowWhereLoop(X) and sqlite3ShowWhereLoopList(X) that can be invoked from a debugger to show a summary of the content of a single WhereLoop object or a list of WhereLoop objects. No change in release builds. check-in: 5db30bcc33 user: drh tags: trunk | |
|
2023-12-22
| ||
| 21:22 | Change parameters on a debugging function to include "const". check-in: 94c3e1110c user: drh tags: trunk | |
| 16:03 | Add the -fno-sanitize-recover=undefined to the sanitizer builds used for sdevtest and release testing. To ensure that any test that provokes undefined behaviour fails. check-in: 89563311ad user: dan tags: trunk | |
| 15:41 | Update #ifdef checks in pager.c and util.c to account for [0462a2612d1fc1d0] to resolve the build problem reported in [forum:9819032aac|forum post 9819032aac]. check-in: 0f22d809a1 user: stephan tags: trunk | |
| 14:47 | Fix a usan complaint about signed integer overflow. check-in: e65907e027 user: dan tags: trunk | |
| 12:57 | Add a new comment to debugging output routine sqlite3WhereLoopPrint() to remind us of what the various fields of the debug output mean. No changes to code. check-in: da5f34fd40 user: drh tags: trunk | |
|
2023-12-21
| ||
| 18:08 | Add internal core-developer-only documentation of the JSONB format. check-in: 4d30478863 user: drh tags: trunk | |
|
2023-12-20
| ||
| 19:33 | Fix SQLITE_ENABLE_SETLK_TIMEOUT assert() statements in os_unix.c to avoid reading past the end of the unixShmNode.aMutex[] array. check-in: 029a05cd29 user: dan tags: trunk | |
| 11:34 | Avoid harmless integer overflow in pager status statistics gathering. Response to [forum:/forumpost/7f4cdf23f9|forum post 7f4cdf23f9]. check-in: 206d8c650d user: drh tags: trunk | |
|
2023-12-19
| ||
| 21:39 | In JSON - minor code cleanup and refactoring with a small size reduction and performance increase. check-in: 215fabda38 user: drh tags: trunk | |
| 15:51 | Remove redundant conditional from sqlite3ExprCanBeNull(). check-in: 257f96a2d2 user: drh tags: trunk | |
| 15:10 | On second thought, we don't really need sqlite_dbdata accessible to the CLI. check-in: 36fe6a61ef user: drh tags: trunk | |
| 15:06 | Fix harmless compiler warning in the randomjson.c extension. check-in: debe7060b1 user: drh tags: trunk | |
| 14:54 | More precise computation of the size of data structures in the query planner. Response to [forum:/forumpost/7d8685d49d|Forum post 7d8685d49d]. check-in: 0c8d88e411 user: drh tags: trunk | |
| 14:53 | Add ALWAYS() and NEVER() on branches made unreachable by recent changes. check-in: c50e6c2ace user: drh tags: trunk | |
| 13:45 | Ignore COLLATE operators when determining whether the result of a subexpression should be shallow-copied or deep-copied. check-in: 34ae36a45e user: drh tags: trunk | |
| 13:00 | Test case for the previous check-in. check-in: df5a07e1a5 user: drh tags: trunk | |
| 12:49 | When unable to resolve an identifier, change the Expr node into TK_NULL rather than TK_COLUMN, to prevent any downstream misuse of the non-existent column. dbsqlfuzz 71869261db80a95e4733afa10ff5724bf3c78592. check-in: d2e6117e4f user: drh tags: trunk | |
| 12:23 | Always make the sqlite_dbdata virtual table available in the CLI. check-in: e5fd3b32ad user: drh tags: trunk | |
| 11:57 | Extra ALWAYS() macros to verify state in the sqlite3ExprCanBeNull() routine. check-in: be19b84c9f user: drh tags: trunk | |
| 00:07 | Remove a stray comment in the JSON code. check-in: 6618bdf067 user: drh tags: trunk | |
|
2023-12-18
| ||
| 19:18 | New JSON invariant test cases. check-in: a6a1367b0b user: drh tags: trunk | |
| 18:50 | Add NEVER() to an unfalsifiable branch. check-in: 9a0c67db36 user: drh tags: trunk | |
| 18:31 | Fix JSON to JSONB translation so that it deals correctly with Infinity and NaN. check-in: 178cb84f36 user: drh tags: trunk | |
| 15:53 | Ensure that the insert/delete size delta on JSONB objects in the JSON cache are always set to zero. check-in: 4b4581668a user: drh tags: trunk | |
| 14:24 | Add randomjson.c to testfixture. Use it for a new set of invariant tests against JSON functions. check-in: f1c040606b user: drh tags: trunk | |
| 14:16 | Ensure that all object labels for individual objects generated by randomjson.c are unique. check-in: 29c46aca23 user: drh tags: trunk | |
| 13:51 | Bug fix in the randomjson.c extension. check-in: 1f3a33df53 user: drh tags: trunk | |
| 12:18 | Enhancements to ext/misc/randomjson.c. check-in: a4e6d1f86f user: drh tags: trunk | |
|
2023-12-17
| ||
| 20:41 | Enhancements to the "randomjson.c" extension. Automatically load that extension into fuzzcheck. check-in: 70620405ab user: drh tags: trunk | |
|
2023-12-16
| ||
| 15:48 | Enable SQLITE_STRICT_SUBTYPE for default builds of the shell, fuzzcheck, and testfixture. check-in: 5a0c517ed7 user: drh tags: trunk | |
| 10:50 | New test case based on Chromium bug report 1511689. check-in: 2c7ef4b4d2 user: drh tags: trunk | |
|
2023-12-15
| ||
| 20:13 | In the count-of-view optimization, deferring freeing obsolete parts of the parse tree, on the off-chance that some other part of the code might be holding a pointer to those parts. check-in: da44257885 user: drh tags: trunk | |
| 19:26 | Avoid expiring prepared statements in the middle of an integrity-check. check-in: 88beb48472 user: dan tags: trunk | |
| 16:28 | Add mention of --buildonly and --dryrun to the testrunner.tcl usage screen. check-in: 23b92d915c user: drh tags: trunk | |
| 15:22 | Fix a new JSON test case so that it works even if SQLITE_OMIT_VIRTUALTABLE is defined. check-in: b995aae510 user: drh tags: trunk | |
| 15:17 | Do not run test script fts5origintest4.test with either "memsubsys1" or "mmap" permutations. check-in: 05a63d9603 user: dan tags: trunk | |
| 14:33 | Avoid running the "no_mutex_try" tests with SQLITE_ENABLE_SETLK_TIMEOUT builds as part of the release test. check-in: 6b4e1344a2 user: dan tags: trunk | |
| 13:38 | Correct --enable-sab flag in ext/wasm/GNUmakefile to fix a silent alhttpd args-parsing error. check-in: 7b9b757d87 user: stephan tags: trunk | |
|
2023-12-14
| ||
| 22:01 | Use SQLITE_STRICT_SUBTYPE=1 by default for the JNI and WASM builds unless they're explicitly built with SQLITE_STRICT_SUBTYPE=0. check-in: 990211357b user: stephan tags: trunk | |
| 16:34 | Add assert()s to FTS5 to fix static analyzer warnings. check-in: 27d4a89a5f user: drh tags: trunk | |
| 15:38 | Fix harmless compiler warnings in JSON and FTS5. check-in: 90135efccf user: drh tags: trunk | |
| 15:31 | Improve the error message returned by an fts5 'rebuild' command on an external content table if there is a problem with the content table or view. check-in: 0fbf4b8a58 user: dan tags: trunk | |
| 15:11 | Enhance aggregate order-by so that it transmits subtype information through the sorter. Fix for the deficiency reported by [forum:/forumpost/87347ad2fb5a8f76|forum post 87347ad2fb5a8f76]. check-in: d302a38946 user: drh tags: trunk | |
|
2023-12-13
| ||
| 20:37 | In CLI, fix .read inability to open 2GB+ files on WIN32. check-in: 56c80a62d2 user: larrybr tags: trunk | |
| 16:45 | Avoid invoking sqlite3ExprColUsage() on an unresolve column reference. dbsqlfuzz fc34aa62df4de103705d11b807074687ffafbda5. check-in: ac9314c0e3 user: drh tags: trunk | |
| 15:27 | Bug fix in the JSONB validator. dbsqlfuzz ac6fa521a08609a642198e7decf64180e750b3c4 check-in: 3e940a6a08 user: drh tags: trunk | |
| 14:31 | Improvements to UTF8 handling, and especially the handling of invalid UTF8, in the JSON routines. check-in: 1b229c1101 user: drh tags: trunk | |
|
2023-12-12
| ||
| 18:38 | Fix the JSON object label comparison object so that it works correctly even if the label ends with escaped whitespace. check-in: 4d5353cadd user: drh tags: trunk | |
| 17:52 | Worker1 Promiser API: when multiple db connections are active then use the requested connection instead of always the first-opened connection. Bug reported in [forum:894c330e7f23b177|forum post 894c330e7f23b177]. check-in: 194276e18e user: stephan tags: trunk | |
| 17:31 | The json_valid(*,8) function does a much better check of the validity of the JSONB input. The json_error_position() function returns an approximate byte offset to the point of the first detected error in the JSONB. check-in: 840efb33a3 user: drh tags: trunk | |
|
2023-12-11
| ||
| 02:39 | Fix a potential use of uninitialized value in json_valid() with 2nd argument of 8. check-in: fa102036fe user: drh tags: trunk | |
|
2023-12-08
| ||
| 16:56 | Fix a harmless UBSAN warning. check-in: 1503cba6d1 user: drh tags: trunk | |
| 14:54 | Fix a potential problem RCStr access on a JsonString object that is not really and RCStr. Fuzzer/UBSAN find. check-in: d2f2174ce2 user: drh tags: trunk | |
| 12:58 | Fix a harmless compiler warning about "confusing indentation". check-in: 34f9e9a8c4 user: drh tags: trunk | |
| 12:04 | Avoid dropping an error code in new fts5 tokendata=1 code. check-in: a66596e33d user: dan tags: trunk | |
|
2023-12-07
| ||
| 21:09 | Ensure an fts5vocab table never uses a special tokendata=1 merge cursor. check-in: 1e26510e83 user: dan tags: trunk | |
| 20:46 | Avoid an assert() failure when querying an fts5vocab table that accesses a tokendata=1 fts5 table with corrupt %_data records. check-in: 386ba9e204 user: dan tags: trunk | |
| 19:08 | Fix a null-pointer dereference in fts5 tokendata=1 code. check-in: d69fa8f050 user: dan tags: trunk | |
| 18:41 | Fix a problem with handling OOM and other errors in fts5 when querying tokendata=1 tables. check-in: bc911ab595 user: dan tags: trunk | |
| 14:41 | Different fix for the fts5 COMMIT-following-OOM problem first fixed by [fba3129d]. This one does not cause problems if an fts5 table is renamed and then dropped within the same transaction. check-in: d8c6b24694 user: dan tags: trunk | |
| 14:09 | Rework the jsonEachPathLength() routine in json_tree() so that it is less susceptible to problems due to goofy object labels. check-in: 858b76a00e user: drh tags: trunk | |
| 13:14 | Add ALWAYS() on branches added in [ec0ae4030968c782] that are always true. check-in: 451cef8609 user: drh tags: trunk | |
| 12:55 | Improved detection of corrupt JSONB in the jsonReturnFromBlob() function. check-in: b014736c1f user: drh tags: trunk | |
|
2023-12-06
| ||
| 18:34 | Fix compiler warning about shadowed variable in fts5_index.c. check-in: ee70e4c1c9 user: dan tags: trunk | |
| 18:25 | Work around LLVM's newfound hatred of function pointer casts. [forum:/forumpost/1a7d257346636292|Forum post 1a7d257346636292]. check-in: ec0ae40309 user: drh tags: trunk | |
| 18:10 | Update documentation comments in fts5.h. check-in: 38c50e22c9 user: dan tags: trunk | |
| 17:50 | Do correct comparisons between object labels in JSON even when the two labels contain different JSON escapes. check-in: bda2e30cc2 user: drh tags: trunk | |
| 17:39 | Correctly handle 8-byte sizes in the JSONB format. [forum:/forumpost/283daf08e91183fc|Forum post 283daf08e91183fc]. check-in: 73d390f39c user: drh tags: trunk | |
| 16:27 | In CLI, move -interactive flag handling back to arg-loop pass 2. check-in: 63cb05a862 user: larrybr tags: trunk | |
| 14:36 | Add the tokendata=1 option and related APIs to fts5. check-in: a76a636b23 user: dan tags: trunk | |
| 14:30 | Merge trunk changes into this branch. Closed-Leaf check-in: 8f46eace86 user: dan tags: fts5-token-data | |
|
2023-12-05
| ||
| 18:36 | Further tests for the new code on this branch. check-in: 59d008b6c2 user: dan tags: fts5-token-data | |
|
2023-12-04
| ||
| 19:48 | Add further tests for xInstToken(). check-in: 8582707f16 user: dan tags: fts5-token-data | |
| 18:45 | Fixes for xInstToken() with tokendata=0 tables. And with prefix queries. check-in: 78fbb71598 user: dan tags: fts5-token-data | |
| 17:58 | Fix memory leak in new code on this branch. check-in: ebc160b9a0 user: dan tags: fts5-token-data | |
| 17:45 | Fix a problem with the xInstCount() API and "ORDER BY rank" queries. check-in: 317a50563d user: dan tags: fts5-token-data | |
| 17:05 | Fix bug in xInstToken() causing the wrong token to be returned. check-in: da78d07e77 user: dan tags: fts5-token-data | |
| 15:08 | Add tests for using tokendata=1 and contentless_delete=1 together. check-in: a2506b8c97 user: dan tags: fts5-token-data | |
|
2023-12-02
| ||
| 20:35 | Fix various compiler warnings and other problems with the new code on this branch. check-in: 3a623cfa17 user: dan tags: fts5-token-data | |
| 18:14 | When tokendata=1 queries require multiple segment-cursors, allow those cursors to share a single array of in-memory tombstone pages. check-in: e0175d07e4 user: dan tags: fts5-token-data | |
| 17:32 | Ensure that tokendata=1 queries avoid loading large doclists for queries like "common AND uncommon", just as tokendata=0 queries do. check-in: 7bda09ab40 user: dan tags: fts5-token-data | |
|
2023-12-01
| ||
| 20:37 | Remove old code for tokendata=1 queries. check-in: b0a489e8e1 user: dan tags: fts5-token-data | |
| 20:10 | Merge latest trunk with this branch. check-in: 8258967411 user: dan tags: fts5-token-data | |
| 20:09 | Different approach to querying a tokendata=1 table. Saves cpu and memory. check-in: c523f40895 user: dan tags: fts5-token-data | |
|
2023-11-29
| ||
| 16:22 | Fix signed integer overflow in fts5. check-in: 60e46c7ec6 user: dan tags: fts5-token-data | |
|
2023-11-28
| ||
| 19:43 | Merge latest trunk updates into this branch. check-in: 554fc13f2c user: dan tags: fts5-token-data | |
|
2023-11-22
| ||
| 21:15 | Add documentation for new fts5 auxiliary function APIs. check-in: 9be8969edd user: dan tags: fts5-token-data | |
| 20:02 | Defer building xInstToken() hash-table until it is to be used. check-in: 9b005085ff user: dan tags: fts5-token-data | |
| 19:02 | Fix tokendata=1 and xInstToken() APIs for detail=none and detail=column tables. check-in: 37b271c19d user: dan tags: fts5-token-data | |
|
2023-11-16
| ||
| 21:11 | When querying a tokendata=1 fts5 table, do not use a prefix cursor for the case where the term has only one variant. check-in: d711c96ba8 user: dan tags: fts5-token-data | |
|
2023-11-15
| ||
| 11:45 | Add implementation of xInstToken() API. check-in: a34b26fe7f user: dan tags: fts5-token-data | |
|
2023-11-13
| ||
| 14:29 | Add new fts5 API xQueryToken(). check-in: 828566392b user: dan tags: fts5-token-data | |
|
2023-11-08
| ||
| 14:55 | Add declarations for new fts5 API functions. check-in: b8a48cc18c user: dan tags: fts5-token-data | |
|
2023-11-06
| ||
| 19:16 | Merge latest trunk into this branch. check-in: 3a869cf1f8 user: dan tags: fts5-token-data | |
| 16:32 | Merge trunk changes into this branch. check-in: ac5570614e user: dan tags: fts5-token-data | |
|
2023-10-11
| ||
| 21:08 | Add the tokendata=1 option to ignore trailing token-data when querying an fts5 table. check-in: 122935182a user: dan tags: fts5-token-data | |
|
2023-10-03
| ||
| 19:06 | Fixes for fts5 expression parser module to allow embedded 0x00 bytes in tokens. check-in: 342c8d0783 user: dan tags: fts5-token-data | |
| 17:07 | Update fts5_decode() to allow for embedded 0x00 bytes in tokens. check-in: e051120067 user: dan tags: fts5-token-data | |
|
2023-09-30
| ||
| 18:13 | Changes so that fts5 can handle tokens with embedded '\0' bytes. check-in: c027c092c4 user: dan tags: fts5-token-data | |
| 17:08 | Fix JNI binding to compile without SQLITE_ENABLE_PREUPDATE_HOOK. Add build option to disable all optional ENABLE flags. check-in: c04022b740 user: stephan tags: trunk | |
| 16:19 | Make all SQLite3Jni methods which take a void-pointer-as-long-int argument explicitly package-private, as they're always for internal use only even if SQLite3Jni is eventually made public. check-in: 5e387275f6 user: stephan tags: trunk | |
| 14:48 | JNI: rename sqlite3_errmsg16() to sqlite3_errmsg(), as the 16 suffix is superfluous there. check-in: df25b21689 user: stephan tags: trunk | |
| 14:34 | Expose sqlite3_stmt_busy() to JNI. check-in: 5733aa5fe3 user: stephan tags: trunk | |
| 13:13 | Correct an undefined-value deref in the JS bindings, triggered by passing invalid args and then tripping over an undefined value while trying to report that. Reported in [forum:dd42df144651d779|forum post dd42df144651d779]. check-in: fd46325407 user: stephan tags: trunk | |
| 10:59 | Make (almost) all SQLite3Jni.sqlite3_... members public but make the SQLite3Jni class package-private, which has the same foot-protection effect but makes it much simpler to patch SQLite3Jni to publicize the interface later. Remove some of the extraneous foot-shooting protection from indidivual functions, in lieu moving it to the still-pending higher-level interfaces. check-in: 082b86683e user: stephan tags: trunk | |
| 10:37 | Merge in and close jni-ptr-passing branch. The remaining pointer-passing adaptation can be done incrementally without affecting the interface. check-in: 7927c42410 user: stephan tags: trunk | |
|
2023-09-29
| ||
| 15:56 | Add test case to ensure the assert() removed by [f090af77] no longer fails. check-in: 615ab71761 user: dan tags: trunk | |
| 15:53 | Remove an incorrect assert(). check-in: f090af775f user: drh tags: trunk | |
|
2023-09-28
| ||
| 15:00 | Clarify serialization API doc w.r.t. buffer validity and usage, instigated by [forum:/forumpost/8922e2ad2ad41205|forum post 8922e2ad2ad41205]. No code changes. check-in: b488b9fb71 user: larrybr tags: trunk | |
|
2023-09-26
| ||
| 21:22 | Fix harmless compiler warnings in the testfixture testing utility. check-in: 5a39a02d2d user: drh tags: trunk | |
| 19:49 | JNI: implement AutoCloseable for the sqlite3 and sqlite3_stmt classes, and adjust a few tests to use it. Override Object.finalize() for sqlite3 class but not sqlite3_stmt (where it triggers a JVM crash for as-yet-unknown reasons). check-in: b633d8bbdb user: stephan tags: trunk | |
| 19:38 | Fix yet another assert() in the partial-index constant value optimization. check-in: f459d0806c user: drh tags: trunk | |
| 19:26 | Remove a NEVER() from a condition in the partial-index constant value optimization that can sometimes be true. check-in: 63aea8c3e0 user: dan tags: trunk | |
| 14:57 | Remove unreachable code from the partial-index constant value optimization ([8d4160910d651246]). check-in: 7ad38254c3 user: drh tags: trunk | |
| 09:46 | Remove some outdated JNI docs. check-in: 2ca5cbbb2a user: stephan tags: trunk | |
| 07:43 | Minor JNI doc updates. No code changes. check-in: 63687cc659 user: stephan tags: trunk | |
|
2023-09-25
| ||
| 17:46 | In partial index scans, if the WHERE clause implies a constant value for a table column, replace occurences of that table column with the constant. This increases the likelihood of the partial index being a covering index. check-in: 8d4160910d user: dan tags: trunk | |
| 14:20 | Enable -Wall for the compiler on --enable-debug builds. check-in: 63a7b52139 user: drh tags: trunk | |
|
2023-09-24
| ||
| 19:13 | Resolve the JNI FTS5 test5() failure and remove some nearby dead code. check-in: 5655c51f10 user: stephan tags: trunk | |
|
2023-09-23
| ||
| 15:34 | Add extra tests for the fts5 xPhraseQuery API. check-in: b5edea1631 user: dan tags: trunk | |
| 06:50 | Resolve the JNI FTS5 test5() crash, caused by two unrelated typos in JNI callback signature strings. That test now fails with an expected-vs-got mismatch but no longer dies in the native code. check-in: 0233f310bf user: stephan tags: trunk | |
| 06:37 | Remove an invalid optimization from JNI code and add a missing check check for Java-side exception. check-in: b8151f8797 user: stephan tags: trunk | |
|
2023-09-18
| ||
| 20:42 | Add extra tests for java Fts5ExtensionApi API. check-in: f9d62b853c user: dan tags: trunk | |
| 18:12 | Extra tests for java Fts5ExtensionApi interface. check-in: c923893f36 user: dan tags: trunk | |
|
2023-09-17
| ||
| 16:36 | Remove a NEVER() in btree.c that could actually be reached, with the approriate database corruption. check-in: d1fd00e087 user: drh tags: trunk | |
|
2023-09-16
| ||
| 18:18 | Fix resolution of "rowid" and similar identifiers in queries that use nested joins. check-in: 37ec43d92b user: dan tags: trunk | |
| 17:11 | Enable "OR IGNORE" support via SQLITE_VTAB_CONSTRAINT_SUPPORT for internal-content (not contentless or external-content) fts5 tables. check-in: c362bde4f4 user: dan tags: trunk | |
|
2023-09-15
| ||
| 20:28 | Simplifications and performance optimizations for the RTree extension. check-in: 04a333f5fa user: drh tags: trunk | |
|
2023-09-14
| ||
| 01:46 | Reduce the number of calls to sqlite3_mprintf() made by RTree. Closed-Leaf check-in: f158b7d491 user: drh tags: rtree-performance | |
|
2023-09-13
| ||
| 17:30 | Omit the Reinsert algorithm from RTree. This causes most benchmarks to run faster, at the expense of having a slightly less dense and hence larger index (example: 33 entries/node versus 34 entries/node). check-in: b3049a1d3d user: drh tags: rtree-performance | |
| 14:07 | Performance optimization to cellContains() in RTREE. check-in: 43cde22bf3 user: drh tags: rtree-performance | |
| 13:12 | In the ChooseLeaf algorithm of RTREE, do an initial pass through the cells of a node looking for solutions that involve no cell enlargement. Only look for the minimum cell enlargement if the enlargement is non-zero for all cells. This results in a performance improvement by reducing the number of calls to cellUnion(). check-in: 59f0e239d1 user: drh tags: rtree-performance | |
| 12:06 | Reduce the number of calls to cellArea() in the ChooseLeaf() algorithm of rtree. check-in: c633fe6be0 user: drh tags: rtree-performance | |
| 11:36 | Remove unused variable from the ChooseLeaf algorithm in r-tree. check-in: fb2e4a8067 user: drh tags: rtree-performance | |
| 11:24 | Replace an if() condition in fts5 that is always true with an assert(). check-in: 2170312c8d user: dan tags: trunk | |
|
2023-09-12
| ||
| 23:21 | CLI .import to accept EOF in lieu of record terminator on last field of CSV (with multiple field records), per RFC 4180. [forum:5b21c25bdfa|forum post 5b21c25bdfa] check-in: 6f7842f577 user: larrybr tags: trunk | |
| 18:36 | Fix a use-after-free error in fts5 that could occur when querying the "rank" column immediately after another connection changes its definition. [forum:a2dd636330|forum post a2dd636330]. check-in: cb54c2da52 user: dan tags: trunk | |
| 17:49 | Clarify some metrics output in Tester1.java. check-in: 4ae7199a82 user: stephan tags: trunk | |
| 17:06 | Re-add the fts5 decls to sqlite3-jni.h, removed in a rebuild without fts5 enabled. Need a better solution for this problem. check-in: 6f269790a0 user: stephan tags: trunk | |
| 17:03 | Rename JNI sqlite3_errmsg() to sqlite3_errmsg16() for overall constency with the text()/text16() family of functions. check-in: c4a8d8a571 user: stephan tags: trunk | |
| 16:33 | JNI readme fix. check-in: 7dde000efc user: stephan tags: trunk | |
| 14:36 | 64-bit builds on Windows default to using UTF-8 output (as if the -utf8 command-line option had been specified.) 32-bit builds continue to use Windows code pages. There is also a new -no-utf8 command-line option to force the use of legacy code pages. check-in: d8c7560e88 user: drh tags: trunk | |
|
2023-09-11
| ||
| 15:27 | Refuse to build amalgamation-tarball and snapshot-tarball if the TEA version number disagrees with ./VERSION. check-in: 3308fdda4b user: drh tags: trunk | |
| 15:20 | Merge in JNI's significant divergence since it adopted sqlite3_client_data(). check-in: e8e07dbbea user: stephan tags: trunk | |
| 14:55 | Add support for the sqlite3_get_clientdata() and sqlite3_set_clientdata() interfaces, to better support JNI. check-in: 9806c0dd28 user: drh tags: trunk | |
|
2023-09-09
| ||
| 17:53 | Remove out-of-date comment regarding use of Parse.pConstExpr. check-in: 71548f72ad user: dan tags: trunk | |
|
2023-09-08
| ||
| 19:18 | Add extra tests for [4b60a1c3]. check-in: 6357491bd1 user: dan tags: trunk | |
| 18:34 | Fix a problem with fts5 secure-delete mode causing fts5 to corrupt its records. check-in: 4b60a1c358 user: dan tags: trunk | |
|
2023-09-07
| ||
| 17:54 | Add -DSQLITE_OMIT_LOOKASIDE=1 to the "Sanitize" configuration in testrunner_data.tcl. check-in: a917ebf17b user: dan tags: trunk | |
| 16:53 | Enhance the ./configure script and its associated Makefile.in so that the --with-linenoise=DIR argument cause the linenoise command-line editing library located in directory DIR to be linked with the sqlite3 CLI. check-in: 6c7822b554 user: drh tags: trunk | |
| 13:53 | Fix a buffer overread in the sessions extension that could occur when processing a corrupt changeset. check-in: 0e4e7a05c4 user: dan tags: trunk | |
| 13:48 | Fix a harmless compiler warning in the sqldiff.c utility. check-in: e6390a6567 user: drh tags: trunk | |
| 13:43 | Add the "tool-zip" makefile target with the intention of using it to build the "sqlite-tool-*.zip" deliverables. deliverables. check-in: 06e4af492d user: drh tags: trunk | |
| 02:13 | Fix a problem with the new xIntegrity method for virtual tables, and also fix a bad assert() in FTS3 that was found by the new xIntegrity method. check-in: 52bbf44f2d user: drh tags: trunk | |
|
2023-09-06
| ||
| 16:51 | Add the xIntegrity method to the sqlite3_module object, thus enabling PRAGMA integrity_check to operate on virtual tables. Make use of this new method in the FTS3/4, FTS5, and RTREE virtual tables. check-in: 2f08e7d233 user: drh tags: trunk | |
|
2023-09-05
| ||
| 15:03 | Fix a few SQLITE_MISUSE returns so that they call sqlite3MisuseError(). check-in: 93f74490fa user: drh tags: trunk | |
|
2023-09-04
| ||
| 16:48 | Add tests for, and source code comments to, fts5. No changes to code. check-in: b12afff4ef user: dan tags: trunk | |
| 12:50 | Do not make assumptions about the byteorder of PowerPC processors. check-in: 4a2498fed4 user: drh tags: trunk | |
|
2023-09-03
| ||
| 15:01 | In mksqlite3c.tcl, pass EXTRA_SRC files through verbatim instead of applying the post-processing needed for sqlite's own source files. check-in: 44f3d7d054 user: stephan tags: extra-src | |
|
2023-09-02
| ||
| 21:55 | Also add support for EXTRA_SRC in the Makefile for MSVC. check-in: bfc18ef432 user: mistachkin tags: extra-src | |
| 19:35 | Performance optimization to the OP_MakeRecord opcode. check-in: 2aef9af3dd user: drh tags: trunk | |
| 05:37 | Add EXTRA_SRC build var. If set, it is treated like a list of files, each of which gets appended verbatim to sqlite3.c. The intent is to enable easily extending the amalgamation. Requested in/around [forum:3fcc655f0ac0efe8|forum post 3fcc655f0ac0efe8]. check-in: 934b843398 user: stephan tags: extra-src | |
|
2023-09-01
| ||
| 11:10 | Second half of [1c532e80]. check-in: 8ca1d815a5 user: stephan tags: trunk | |