Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
393 check-ins going from 633dca907488b721 to e52c87420b072fa6
2024-03-20
| ||
16:29 | Fix test cases for rtree and fts5. No changes to code. (check-in: 633dca9074 user: drh tags: branch-3.44) | |
16:04 | Have rtree avoid keeping a blob handle open following an error. (check-in: 1303716a11 user: drh tags: branch-3.44) | |
15:26 | Following a ROLLBACK that reverts changes to an RTREE, any pending queries against that same RTREE abort with code SQLITE_ABORT_ROLLBACK. dbsqlfuzz de7d17b72d0e842352c998dd86a47b7d0f707be9. (check-in: b26e5a500e user: drh tags: branch-3.44) | |
12:19 | Back port various minor patches (check-in: a1a5c427c2 user: drh tags: branch-3.44) | |
11:36 | Automatically disable the DISTINCT optimization during query planning if the ORDER BY clause exceeds 63 terms. dbsqlfuzz afd1d61fc27d14938a0d78a50970fa1e9fbfee58. (check-in: e8d5caef26 user: drh tags: branch-3.44) | |
11:30 | Ignore COLLATE operators when determining whether the result of a subexpression should be shallow-copied or deep-copied. (check-in: dd58d1178f user: drh tags: branch-3.44) | |
11:25 | Fix a harmless compiler warning in the randomjson.c extension. (check-in: a4c9351234 user: drh tags: branch-3.44) | |
11:24 | If a term of an ORDER BY or GROUP BY contains an aggregate function or column, then it is not an alias that needs to be resolved, so don't try to. This fixes a harmless assertion found by dbsqlfuzz. (check-in: e7ba2af5a1 user: drh tags: branch-3.44) | |
11:04 | 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: acc08353e2 user: drh tags: branch-3.44) | |
2024-03-19
| ||
10:46 | Fix a problem involving infinities int the Kahan-Babushka-Neumaier summation algorithm. (check-in: 0984e5cd25 user: drh tags: branch-3.44) | |
2024-03-08
| ||
14:16 | Silently ignore redundant ON CONFLICT clauses in an UPSERT. (check-in: e546d8c685 user: drh tags: branch-3.44) | |
2024-02-04
| ||
04:01 | Fix harmless compiler warnings seen with MSVC. (check-in: e52c87420b user: mistachkin tags: trunk) | |
2024-02-03
| ||
19:19 | Following a ROLLBACK that reverts changes to an RTREE, any pending queries against that same RTREE abort with code SQLITE_ABORT_ROLLBACK. dbsqlfuzz de7d17b72d0e842352c998dd86a47b7d0f707be9. (check-in: af5c425114 user: drh tags: trunk) | |
2024-02-02
| ||
18:42 | More extensive use of SQLITE_CORRUPT_PGNO. (check-in: 3838332cff user: drh tags: trunk) | |
11:37 | Fix typo in vdbe.c comment. No changes to code. (check-in: 62010ba488 user: dan tags: trunk) | |
2024-02-01
| ||
15:42 | Ensure the fts5 xIntegrity method correctly returns error codes unrelated to corruption or missing SQL elements. (check-in: d18d9a05c2 user: dan tags: trunk) | |
15:21 | Ensure the fts3 xIntegrity method correctly returns error codes unrelated to corruption or missing SQL elements. (check-in: 1bdb8cbaf7 user: dan tags: trunk) | |
14:57 | In PRAGMA integrity_check, defer running xIntegrity on virtual tables until after all ordinary tables have been checked. (check-in: 8f4b1ceafe user: drh tags: trunk) | |
14:17 | Add tracing logic to the shared-cache locks in btree.c. The tracing is off by default. Enable by changing a single "#if 0" into "#if 1" and recompiling. Debugging code only - no changes to release builds. (check-in: f2b943f97a user: drh tags: trunk) | |
11:38 | Add the test_oom_breakpoint() routine on debug builds, to serve as a convenient breakpoint to intercept OOM conditions. (check-in: e45df7dcd6 user: drh tags: trunk) | |
2024-01-31
| ||
20:11 | Replace an conditional assignment that was made obsolete by [d4c193f0b49f4950] with an assert(). The conditional was added by [d6fd512f50513ab7] as a fix for tickets [c36cdb4afd504dc1], [4051a7f931d9ba24], and [d6fd512f50513ab7] which means now [d4c193f0b49f4950] is the correct fix for those tickets. that check-in (check-in: 44b5524d52 user: drh tags: trunk) | |
15:29 | Allow control characters in JSON5 string literals. Forum thread 05182119f69c3a92. (check-in: 380f09c194 user: drh tags: trunk) | |
12:15 | Fix a memory allocation bug in the (debug-use-only) json_parse() SQL function. (check-in: 32ce7dacf5 user: drh tags: trunk) | |
2024-01-29
| ||
21:09 | Detect malformed nested JSONB earlier and stop rendering to avoid long delays. (check-in: 72f3e1d0ec user: drh tags: trunk) | |
20:36 | When generated text JSON from JSONB, do not continue descending into nested structures after an error is seen. This avoids long loops and wait times. (check-in: 97666ec052 user: drh tags: trunk) | |
19:30 | Consider an index for queries like "SELECT count(DISTINCT col) FROM ...", even if the index records are not smaller than the table records. (check-in: ad06868807 user: dan tags: trunk) | |
15:30 | Avoid a potential buffer overread when handling corrupt json blobs. (check-in: 738473dc0a user: dan tags: trunk) | |
12:50 | 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: b0eb279ea8 user: drh tags: trunk) | |
2024-01-28
| ||
20:42 | Use __ppc__ instead of __POWERPC__ to identify 32-bit PowerPC processors. Forum post 34794846ce. (check-in: c974d9313b user: drh tags: trunk) | |
17:39 | Automatically disable the DISTINCT optimization during query planning if the ORDER BY clause exceeds 63 terms. dbsqlfuzz afd1d61fc27d14938a0d78a50970fa1e9fbfee58. (check-in: d4c193f0b4 user: drh tags: trunk) | |
00:31 | Apply the same fix found in [99057383acc8f920] to descending scans. dbsqlfuzz afd1d61fc27d14938a0d78a50970fa1e9fbfee5. (check-in: e1d463c2d6 user: drh tags: trunk) | |
2024-01-27
| ||
20:17 | Improvements to parser stack overflow testing. Forum post 99e181b5bf. (check-in: 556c43a937 user: drh tags: trunk) | |
12:47 | Performance enhancements to the parser template. (check-in: 2db8b30acd user: drh tags: trunk) | |
12:25 | Use an alternative memory allocator for parser stack space that includes a call to sqlite3FaultSim() to facilitate testing. (check-in: 7c36d560ff user: drh tags: trunk) | |
11:35 | Allocate new parser stack space from the heap if needed, eliminating the possibility of a "parser stack overflow" error as long as heap memory is available. (check-in: d87a205477 user: drh tags: trunk) | |
2024-01-24
| ||
21:08 | Add NEVER() to a branch that is no longer reachable. (check-in: 9411337a7b user: drh tags: trunk) | |
19:54 | Update ext/wasm/SQLTester for recent internal-API reorgs. (check-in: 996cfdf9b5 user: stephan tags: trunk) | |
2024-01-23
| ||
21:10 | Slight adjustment to test results for Windows in mmap1.test due to the previous check-in. (check-in: 5cf9ea9b1f user: drh tags: trunk) | |
16:21 | 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: 198a1daae0 user: drh tags: branch-3.44) | |
16:09 | 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: 2684feac3b user: dan tags: trunk) | |
14:45 | Improved error message when a double-quoted identifier name cannot be resolved - ask the user if they intended to use a string literal. (check-in: efc5c3c5e6 user: drh tags: trunk) | |
13:51 | 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. Forum thread 012136abd5292b8d. (check-in: e5dc81d5c7 user: drh tags: trunk) | |
12:51 | Change the shell's --help flag to exit with code 0 instead of 1, per /forum and /chat discussions. (check-in: df563a1857 user: stephan tags: trunk) | |
2024-01-22
| ||
14:01 | Fix test script literal.test so that it works with SQLITE_OMIT_ALTER_TABLE builds. (check-in: 4dc00f5776 user: dan tags: trunk) | |
12:56 | Fix userauth so that it works together with SQLITE_OMIT_SHARED_CACHE. (Forum post 0bfc5888a384d430). However, also change to code to issue a deprecation warning whenever SQLITE_USER_AUTHENTICATION is used. (check-in: 249048b0cb user: drh tags: trunk) | |
12:30 | Add a notice to the user-authentication documentation to say that the extension is deprecated and may disappear in the future. (check-in: fe6fc7b91a user: drh tags: trunk) | |
01:11 | Make CLI .dump immune to pragma reverse_unordered_selects, as reported in Forum thread c42be01880e961eb. (check-in: 488caed244 user: larrybr tags: trunk) | |
2024-01-21
| ||
21:20 | Fix a harmless typo in a comment. (check-in: 382a8f94bf user: drh tags: trunk) | |
2024-01-20
| ||
18:41 | Ensure that values generated by DEFAULT clauses that specify real numbers that can be expressed as 64-bit integers (e.g. -1234.0) are not silently converted to integers. (check-in: 298d697728 user: dan tags: trunk) | |
18:26 | Simplifications to the strftime() logic. (check-in: aaa5a044d8 user: drh tags: trunk) | |
18:21 | Fix a memory leak in new memdb1.test test cases that were added by [e638d5e408ea2e18]. No changes to SQLite itself. (check-in: bb2b7a658e user: drh tags: trunk) | |
16:38 | Make sure that %V and %G are testing for every since day in between 1970-01-01 and 2023-01-19. (check-in: 39c475f5fb user: drh tags: trunk) | |
16:29 | Rig sqlite3_serialize() so that it will initialize a previously uninitialized database prior to serializing it, so that it does not have a zero-byte size and does not return NULL (except for OOM). Forum thread 498777780e16880a. (check-in: e638d5e408 user: drh tags: trunk) | |
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 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 post 3776b48e71. (check-in: 01868ebcd2 user: drh tags: trunk) | |
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 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 post 4af649419b. (check-in: f106bc0d21 user: drh tags: trunk) | |
14:24 | Various build- and code-reorg cleanups for ext/wasm. No functional changes. (check-in: 835bd4a11e user: stephan tags: trunk) | |
2024-01-11
| ||
16:10 | 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. (Closed-Leaf check-in: 5836657929 user: stephan tags: wasm-post-3.45) | |
14:21 | Internal JS doc cleanups. (check-in: c8284170f6 user: stephan tags: wasm-post-3.45) | |
12:56 | Remove some dead JS code. Minor doc cleanups. (check-in: bf23cf2049 user: stephan tags: wasm-post-3.45) | |
12:31 | Split the JS vfs/vtab helper code into discreet units as a step towards a build which optionally elides those pieces. This is an internal restructuring change and does not affect the API. (check-in: ede945fd23 user: stephan tags: wasm-post-3.45) | |
2024-01-08
| ||
07:52 | Make explicit which JS APIs are for internal use only by moving the JS-bound internal-use-only functions out of client-visible reach and renaming the WASM-exported ones from sqlite3_wasm... to sqlite3__wasm... (with two underscores). These have always been documented as internal-use-only, so this is not a breaking change except for clients which have ignored the docs. (check-in: 0eddc20f37 user: stephan tags: wasm-post-3.45) | |
2024-01-07
| ||
20:27 | Remove an ALWAYS() from RTREE. Dbsqlfuzz found a way to make it false. (check-in: 40f0a29e6d user: drh tags: trunk) | |
00:45 | Updates to RTREE to facility testing. (check-in: 7a5b42ff74 user: drh tags: trunk) | |
2024-01-06
| ||
15:22 | Update JSON performance testing procedures for clarity and to describe how to do performance testing of JSONB. (check-in: b115b4f75b user: drh tags: trunk) | |
13:58 | Update extension ext/misc/totext.c to avoid both ubsan warnings and dubious real->integer conversions. (check-in: 541436004d user: dan tags: trunk) | |
2024-01-04
| ||
17:13 | Avoid errors with SQLITE_OMIT_VIRTUALTABLE builds in json106.test and unionall.test. (check-in: 8940e2a105 user: drh tags: trunk) | |
13:01 | Restructure some code to fix what appears to be a false-positive UBSAN warning. (check-in: fe952c1290 user: drh tags: trunk) | |
2024-01-03
| ||
20:40 | Fix a #ifdef in sqlite3_test_control() that was preventing builds with SQLITE_OMIT_WSD. (check-in: d546a9c94c user: drh tags: trunk) | |
16:41 | Convert the JSON functions to use lookaside memory allocation whenever feasible, to avoid hitting the global memory allocator mutex. (check-in: a79a244954 user: drh tags: trunk) | |
15:49 | Change a constant from decimal to hex to avoid a compiler warning on Mac. (check-in: e3acb8a43a user: drh tags: trunk) | |
14:13 | Enhance sqlite3_analyzer.exe so that it uses the ext/consio extension. (check-in: 769de0b98e user: drh tags: trunk) | |
12:26 | Update the sqldiff.exe utility program so that it uses the sqlite3_str string interface, and so that it does console output using the ext/consio extension. (check-in: 4443b7e592 user: drh tags: trunk) | |
2024-01-02
| ||
22:49 | Back out [b517a52fa36df0a0] which is no longer reachable due to early error detection enhancements in [166e82dd20efbfd3]. (check-in: 704943e96f user: drh tags: trunk) | |
21:37 | Adjust the sqlite3PagerDirectReadOk() routine (part of the SQLITE_DIRECT_OVERFLOW_READ optimization) to use less code and to be more easily testable. (check-in: eed670ea2a user: drh tags: trunk) | |
21:08 | Fix a problem in fts5 caused by a COMMIT involving fts5 data that immediately follows a ROLLBACK TO that does not. (check-in: 55c61f6a8d user: dan tags: trunk) | |
20:34 | Increase the default "max_page_count" to its theoretical maximum of 4294967294. (check-in: ffb35f1784 user: drh tags: trunk) | |
09:20 | Elaborate on the various build flavors used by ext/wasm/. Doc changes only. (check-in: d489232aa4 user: stephan tags: trunk) | |
09:03 | Update and clean up the in-makefile docs for ext/wasm. (check-in: 7a7b295e6d user: stephan tags: trunk) | |
2024-01-01
| ||
23:28 | Back out [99d11e6d0ae6] (enabling of STAT4 in WASM/JNI), per /chat discussion. (check-in: cd7929ee2e user: stephan tags: trunk) | |
19:20 | New logic to avoid using indexes that ANALYZE has identified as of little practical use. Also a performance optimization in ANALYZE. (check-in: bcac937526 user: drh tags: trunk) | |
06:58 | JNI: move the ByteBuffer-using APIs from public to package visibility for the time being because they have UB-inducing possibilities which need to be worked out. Update test code to account for a change in custom FTS5 columntext() impls. (check-in: dc501275fc user: stephan tags: trunk) | |
05:58 | WASM: various build cleanups and add initial infrastructure for a build which elides the oo1 API and its dependents (worker1 and promiser). Sidebar: an attempt was made to move generation of the build rules to an external script, but the mixed-mode make/script was even less legible than the $(eval) indirection going on in the makefile. (check-in: 563d313163 user: stephan tags: trunk) | |
2023-12-31
| ||
04:01 | Use SQLITE_ENABLE_STAT4 in both the WASM and JNI builds. (check-in: 99d11e6d0a user: stephan tags: trunk) | |
2023-12-29
| ||
04:29 | Minor doc touchup in the JS bits. (check-in: 8d2120c354 user: stephan tags: trunk) | |
2023-12-28
| ||
21:02 | Enable SQLITE_DIRECT_OVERFLOW_READ unless it is specifically disabled using the -DSQLITE_DIRECT_OVERFLOW_READ=0 compile-time option. (check-in: 630604a4e6 user: drh tags: trunk) | |
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 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:42 | Update #ifdef checks in pager.c and util.c to account for [0462a2612d1fc1d0] to resolve the build problem reported in forum post 9819032aac. (check-in: 7374c2342e user: stephan tags: branch-3.44) | |
15:41 | Update #ifdef checks in pager.c and util.c to account for [0462a2612d1fc1d0] to resolve the build problem reported in 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 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 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) | |
13:00 | 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. (check-in: 8f770d14d3 user: drh tags: branch-3.44) | |
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 post 87347ad2fb5a8f76. (check-in: d302a38946 user: drh tags: trunk) | |
13:58 | Pass subtype information through the aggregate ORDER BY sorter for aggregate functions that use subtype information. (Closed-Leaf check-in: 3536f4030e user: drh tags: agg-orderby-subtype) | |
2023-12-13
| ||
16:50 | Avoid invoking sqlite3ExprColUsage() on an unresolve column reference. (check-in: 6e0e2ee7c7 user: drh tags: branch-3.44) | |
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:55 | 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 post 894c330e7f23b177. (check-in: 3874e5a328 user: stephan tags: branch-3.44) | |
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 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
| ||
13:48 | 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: 67da596d82 user: dan tags: branch-3.44) | |
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 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 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) | |
02:53 | Increase the patch level to 3.44.3. (check-in: bb4d35e262 user: drh tags: branch-3.44) | |
02:50 | Reference count the Table passed into the OP_VCheck opcode. (check-in: 79e6496bb1 user: drh tags: branch-3.44) | |
2023-11-28
| ||
19:43 | Merge latest trunk updates into this branch. (check-in: 554fc13f2c user: dan tags: fts5-token-data) | |
2023-11-24
| ||
11:41 | Version 3.44.2 (check-in: ebead0e723 user: drh tags: release, branch-3.44, version-3.44.2) | |
2023-11-23
| ||
12:12 | Another assertion fault fix, similar to [a9443dbfbe25e588]. (check-in: f796da626b user: drh tags: branch-3.44) | |
11:45 | Fix harmless compiler warnings in debugging code. (check-in: db40272c36 user: drh tags: branch-3.44) | |
11:29 | Fix an fts5 problem that could occur when mixing regular and secure delete operations on a single table. (check-in: 25fb5a540b user: drh tags: branch-3.44) | |
11:21 | Increase the version number to 3.44.2. (check-in: 73d3cb7909 user: drh tags: branch-3.44) | |
07:06 | Fix output redirect bug reported in the forum. (check-in: 2ab256bc0b user: larrybr tags: branch-3.44) | |
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) | |
17:13 | Correct the URL for loading sqlite3-worker1-bundler-friendly.mjs from sqlite3-worker1-promiser-bundler-friendly.js, so that the promiser can be used in bundler-using environments. Problem reported via email. (check-in: b1128838f9 user: stephan tags: branch-3.44) | |
14:18 | Version 3.44.1 (check-in: d295f48e8f user: drh tags: release, branch-3.44, version-3.44.1) | |
2023-11-21
| ||
18:46 | Pickup minor stylistic changes related to console I/O and, for Windows builds, get fact of UTF-16 translation into the sign-on banner. (a straight cherry-pick) (check-in: d7a59e7946 user: larrybr tags: branch-3.44) | |
2023-11-20
| ||
15:58 | Back out an incorrect change to the sqlite3ExprCompareSkip() function from long ago. (check-in: 89658abbcd user: drh tags: branch-3.44) | |
13:59 | Arrange to not compile unused console I/O function. (check-in: 184a0cd2e8 user: larrybr tags: branch-3.44) | |
13:12 | Convert an assert in OP_VCheck into a branch that aborts the opcode, as this can happen on some very obscure conditions, as discovered by dbsqlfuzz. (check-in: 0d5f68717c user: drh tags: branch-3.44) | |
12:00 | Cherry pick additional assert() fixes from trunk into the branch-3.44 branch. (check-in: 6d8a8b7002 user: drh tags: branch-3.44) | |
11:50 | Fix an assert() in fts5 that could be true following an OOM or IO error in contentless-delete mode. (check-in: 80a0bd7a69 user: drh tags: branch-3.44) | |
2023-11-19
| ||
17:33 | Fix test 5.0 in shell1.test for Windows. (A double-quote wrapped single-quote needs no further treatment to be recognized as a single single-quote.) (check-in: aaa73400c4 user: larrybr tags: branch-3.44) | |
2023-11-18
| ||
22:10 | Merge changes to do Windows console I/O with UTF-16. (check-in: f782054e7c user: larrybr tags: branch-3.44) | |
20:24 | Correct conditional compilation issue seen with MSVC in the Win32 mutex subsystem. (check-in: 6c069c5d66 user: drh tags: branch-3.44) | |
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) | |
12:05 | Remove an incorrect ALWAYS() and NEVER(). (check-in: 94f6209386 user: drh tags: branch-3.44) | |
2023-11-10
| ||
21:03 | Fix another problem with mixed join types and the RIGHT JOIN strength-reduction optimization. (check-in: 8f01f8b260 user: drh tags: branch-3.44) | |
15:20 | Fix an obscure problem with the join-strength-reduction optimization that could occur when mixing LEFT and RIGHT joins in the same query. (check-in: dcf1c13781 user: drh tags: branch-3.44) | |
15:01 | Expose the missing SQLITE_SUBTYPE to wasm. (check-in: 7bebfe20e7 user: stephan tags: branch-3.44) | |
2023-11-09
| ||
18:41 | Ensure 8-byte alignment of data structues in sqlite3_database_file_object(). (check-in: 3cfcaafaff user: drh tags: branch-3.44) | |
17:55 | Expose SQLITE_RESULT_SUBTYPE to wasm. (check-in: fc03988650 user: stephan tags: branch-3.44) | |
17:42 | Add the SQLITE_RESULT_SUBTYPE flag for application-defined functions. Add the -DSQLITE_STRICT_SUBTYPE=1 compile-time option that raises an error if any function invokes sqlite3_result_subtype() without the SQLITE_RESULT_SUBTYPE flag. SQLITE_RESULT_SUBTYPE prevents an indexed value of that function from being used to replace an equivalent expression, since the indexed expression does not carry the subtype. (check-in: 65a9cfc466 user: drh tags: branch-3.44) | |
01:56 | JSON5 bug fix: Escape double-quotes that occur inside of single-quoted strings. (check-in: 6cc57bb2ce user: drh tags: branch-3.44) | |
2023-11-08
| ||
14:55 | Add declarations for new fts5 API functions. (check-in: b8a48cc18c user: dan tags: fts5-token-data) | |
2023-11-07
| ||
19:15 | Update the documentation to the sqlite3_set_auxdata() and sqlite3_get_auxdata() routines to make it clear that they do not work as one might expect when they are called during query planning, instead of during query execution. The JSON routines misuse those interfaces, so add a special flag to JSON routines that prevents them from being invoked during query planning. (check-in: 36259009c5 user: drh tags: branch-3.44) | |
2023-11-06
| ||
19:16 | Merge latest trunk into this branch. (check-in: 3a869cf1f8 user: dan tags: fts5-token-data) | |
19:08 | Update the srctree-check.tcl script and child script so that they can be run on a read-only source tree and so that if any inconsistencies are found, the script returns a non-zero exit code and thus halts the build. (check-in: a0cc7e8117 user: drh tags: branch-3.44) | |
19:01 | Fix an fts5 problem where a transaction consisting of (a) a DELETE on rowid X, (b) a prefix query, and (c) an INSERT on rowid X, could corrupt the index. (check-in: 34af510a56 user: drh tags: branch-3.44) | |
16:32 | Merge trunk changes into this branch. (check-in: ac5570614e user: dan tags: fts5-token-data) | |
2023-11-02
| ||
11:14 | Update the version number to 3.44.1 (check-in: 34f23c3d0d user: drh tags: branch-3.44) | |
11:08 | CLI to compile with older MSVC compiler. (check-in: c8bf4f7a6a user: drh tags: branch-3.44) | |
2023-11-01
| ||
11:23 | Version 3.44.0 (check-in: 17129ba1ff user: drh tags: trunk, release, major-release, version-3.44.0) | |
2023-10-31
| ||
17:40 | Fix harmless compiler warnings in test code. (check-in: d1895dd8f5 user: drh tags: trunk) | |
17:39 | Fix a problem with SQLITE_ENABLE_FTS5 builds of the non-amalgamation testfixture.exe in Makefile.msc. (check-in: 544091cc0f user: dan tags: trunk) | |
2023-10-30
| ||
23:20 | Remedy CLI non-UTF8 handling detection flaw noted in a forum post. (check-in: a4c7954b93 user: larrybr tags: trunk) | |
23:04 | Remedy CLI non-UTF8 handling detection flaw noted in a forum post. (Leaf check-in: 2666b80d2c user: larrybr tags: win-utf8-io-split) | |
13:56 | Predicate Windows CLI UTF-8 console I/O on a runtime capability check rather than an OS version check. (check-in: f89d062f88 user: larrybr tags: win-utf8-io-split) | |
2023-10-29
| ||
19:55 | Simplify code slightly. Improve comments on added code and its use. (check-in: 046c842966 user: larrybr tags: win-utf8-io-split) | |
16:26 | Properly close a handle. Use a putatively effective runtime test for UTF-8 console I/O capability. (This makes the version test useful mainly for avoiding a warning that UTF-8 console I/O could not be setup.) (check-in: dc91eb9172 user: larrybr tags: win-utf8-io-split) | |
00:24 | Condition default UTF-8 console I/O for Windows builds on OS version 10 or more. This is to accomodate an IsValidCodePage() API which may happily report CP_UTF8 as a valid code page when the stock console cannot, in fact, do UTF-8 I/O. (check-in: 6b9b2a886f user: larrybr tags: win-utf8-io-split) | |
2023-10-28
| ||
16:19 | Limit the range of integer unix timestamps in date4.test, since some systems (RaspberryPI) cannot deal with timestamp values that exceed pow(2,31). (check-in: 765290663b user: drh tags: trunk) | |
11:53 | Update documentation for sqlite3_errmsg() to try to make it clear that if the schema of a database contains table names or similar with invalid UTF, then the error message generated by SQLite might also contain invalid UTF. No changes to code. (check-in: 33ba13c7c4 user: drh tags: trunk) | |
11:40 | Since SQLite considers NaN to be like NULL and NULL sorts before any integer, make sure the sqlite3IntFloatCompare() routine reports that the integer argument is larger if the floating-point argument is NaN. (check-in: de1cf31a34 user: drh tags: trunk) | |
03:54 | Remove the SQLITE_MAX_ALLOCATION_SIZE flag (set to 536mb) from the WASM build because it can unduly limit db exports via sqlite3_serialize(), as reported in forum post 75524f7342c1ba45. It now defaults to whatever sqlite3.c uses, which is currently just shy of 2gb. (check-in: f6e1137919 user: stephan tags: trunk) | |
2023-10-27
| ||
21:44 | Fix cosmetic flaw in SQLITE_TXN_* doc. (no code change) (check-in: 72d7c18f80 user: larrybr tags: trunk) | |
18:16 | Disable two rtree test cases for Linux-i686. We do not have that platform available for testing. The test cases work on all other 64-bit and 32-bit platforms that we have at hand. So there is no way for us to debug this problem. Better to disable the test. forum post ffcbf789b5386573. (check-in: fed4d6e90b user: drh tags: trunk) | |
17:40 | Add makefile targets for fuzzcheck-asan and fuzzcheck-ubsan. (check-in: 27fc14303a user: drh tags: trunk) | |
15:31 | Fix to Makefile.in so that the "tool-zip" target can be run from outside the source tree. (check-in: cd118da9db user: dan tags: trunk) | |
13:59 | Cleanup shell.c comments. Hide -utf8 option, as it is undocumented and accepted only for backward compatibility. No functional changes except for -help content. (check-in: 3a87995560 user: larrybr tags: trunk) | |
10:49 | Back out [2904fcbeebba9189], mostly. The page bitmap is needed even for a partial integrity_check in order to avoid an infinite loops while walking the database. (check-in: dd6e03b373 user: drh tags: trunk) | |
2023-10-26
| ||
18:41 | In CLI for Windows builds, do MBCS/UTF-8 translation independently for input and output. (And cure an MSVC warning.) (check-in: 80f0b6f9c7 user: larrybr tags: trunk) | |
17:30 | Enhance the "tool-zip" makefile target on Windows so that it uses more universally available commands to build the ZIP archive. Fix other minor issues with that makefile target at the same time. (check-in: d2f2f91265 user: drh tags: trunk) | |
2023-10-25
| ||
20:08 | Updates to the mktoolzip.tcl to work on win32. (Closed-Leaf check-in: 166b775bb5 user: dan tags: win32-mktoolzip) | |
15:30 | Add an ALWAYS on branch that was made always-true by the DISTINCT ORDER BY fix. (check-in: c29ebcb0be user: drh tags: trunk) | |
14:54 | When doing a DISTINCT aggregate that contains an ORDER BY, only the arguments to the aggregate need to be distinct, not the ORDER BY terms. (check-in: d2dbbdf719 user: drh tags: trunk) | |
12:58 | Fix the amalgamation generator so that when it is reporting the Fossil version number in the header comment of the amalgamation, it does not elide the first hex digit of the version hash. (check-in: cc66f526bd user: drh tags: trunk) | |
10:37 | Enhance the new xIntegrity method of the sqlite3_module object with new parameters that provide the name of the table being checked and a flag to indicate a "quick_check". Based on feedback in forum post 965c0d02ea. (check-in: bc8afa3f15 user: drh tags: trunk) | |
2023-10-24
| ||
19:56 | Implement check-in [477577120b897bf1] differently, so as not to disrupt non-standard build configuration. See forum post c11523ca2df50293. (check-in: 50448fe4fd user: drh tags: trunk) | |
17:45 | Test cases for COLLATE and NULLS FIRST/LAST in the ORDER BY for an aggregate function. (check-in: 641f928feb user: drh tags: trunk) | |
16:16 | New #ifdefs to fix certain compile-time options. (check-in: 688c6279ef user: drh tags: trunk) | |
16:06 | Fix a problem with the fts5 highlight() and snippet() functions when used with tokenizers like "trigram" that output overlapping tokens. Forum post 63735293ec. (check-in: e952db86fa user: dan tags: trunk) | |
15:53 | Fix a problem with the fts5 highlight() and snippet() functions when used with tokenizers like "trigram" that output overlapping tokens. Forum post 63735293ec. (Closed-Leaf check-in: d570aa02f7 user: dan tags: fts5-trigram-snippet-fix) | |
09:57 | Fix a harmless compiler warning in the expert extension. (check-in: 0c4907ddf9 user: drh tags: trunk) | |
2023-10-23
| ||
23:34 | Fix a minor typo in the previous. (check-in: 9d388267e4 user: drh tags: trunk) | |
23:34 | Add notes on how to build a statically linked version of sqlite3_analyzer.exe. (check-in: 99ce9939c8 user: drh tags: trunk) | |
19:51 | Add the sqlite3res file to the Windows build of sqldiff.exe so that the resulting binary shows the SQLite icon. (check-in: c696a4963b user: drh tags: trunk) | |
15:30 | Avoid attempting to delete a file while it is open in test script sessionalter.test. (check-in: f20b4a96f7 user: dan tags: trunk) | |
15:24 | Revert an earlier change that considered passing a NULL callback to sqlite3_preupdate_hook() to be a misuse. This is required to clear the preupdate hook altogether. (check-in: 1bf6f0f3bb user: dan tags: trunk) | |
15:23 | New test cases for PRAGMA integrity_check against FTS4 and FTS5 tables. (check-in: 3950d20c3a user: drh tags: trunk) | |
14:24 | Fix mutex1.test to take into account that the prng mutex is not (as of [c84e4483cb4]) taken when writing a header to an in-memory journal. (check-in: c9e37417fc user: dan tags: trunk) | |
13:46 | Improved error messages for the xIntegrity method in FTS3/4 and FTS5. (check-in: df69abc082 user: drh tags: trunk) | |
12:16 | Fix sqlite3ExprDup() alignment assertions so that they work on 32-bit platforms. (check-in: 143f95efc7 user: drh tags: trunk) | |
11:41 | Temporarily disable the ext/expert/expert1-6.0 test, which does not work on my configurations. (check-in: a41b903d0f user: drh tags: trunk) | |
11:34 | Add an SQLITE_OMIT_VIRTUALTABLE block around the new vtab code in "PRAGMA integrity_check". (check-in: ab99eb2b6c user: dan tags: trunk) | |
11:18 | Add missing test file fts3fault3.test. Should have been part of [7f41d700]. (check-in: 92e64ab63a user: dan tags: trunk) | |
02:08 | Merge fixes for expert handling of UDFs and other UD-whatevers. (check-in: b5d7d07df5 user: larrybr tags: trunk) | |
01:55 | Clear some picky warnings, sync w/trunk. (Closed-Leaf check-in: ee58425904 user: larrybr tags: expert-enhancement) | |
2023-10-22
| ||
23:44 | Fix [f5c01676fd281e93] so that it always preserves 8-byte alignment for Expr objects. Add new assert() statement to verify this. (check-in: 678a9728dc user: drh tags: trunk) | |
17:27 | Do not do backslash escape processing on any unquoted strings in dot-commands in the CLI - on Windows or on posix-like systems either one. This brings the processing into alignment with the documentation, allows backslash-delimited filenames on Windows (as long as they are unquoted), and causes the CLI to work the same with regard to backslash escapes on both Windows and posix. (check-in: bce807cd48 user: drh tags: trunk) | |
12:33 | JNI: improve UB protections in sqlite3_bind_blob/text/text16(). (check-in: 5c8383210a user: stephan tags: trunk) | |
11:11 | Add missing ScalarFunction.java to JNI build. (check-in: b8258103fb user: stephan tags: trunk) | |
2023-10-21
| ||
22:31 | In the CLI, do not translate unquoted backslash escapes on dot-commands as that can damage filename arguments. (check-in: 4a0e2c6e17 user: drh tags: trunk) | |
20:34 | Remove a branch that cannot affect the outcome from FkNoAction processing in fkey.c. Replace it with an assert(). (check-in: 023a9dbe83 user: drh tags: trunk) | |
20:03 | Replace the patch at [5cb61c6788d7c017] with a better way to avoid failing PRAGMA integrity_check if a module implementation is not loaded, as the use of suppressErr can lead to problems. (check-in: be5737ee4f user: drh tags: trunk) | |
18:12 | Fix a problem allowing a COMMIT following an OOM to cause fts3/4 corruption. (check-in: 7f41d7006d user: dan tags: trunk) | |
16:33 | Add the SQLITE_TESTCTRL_FK_NO_ACTION test control. Make it available in the CLI. Fix a minor problems with SQLITE_CHANGESETAPPLY_FKNOACTION in sessions. (check-in: 91b64c6a70 user: drh tags: trunk) | |
11:43 | Adjust an EXPLAIN QUERY PLAN output in scanstatus2.test to account for a different loop order taken due to the removal of the view-scan optimization. (check-in: 9deb8b6915 user: drh tags: trunk) | |
11:34 | Compress the content of the status line in testrunning.tcl so that all the same status information appears but with less punctuation and with "zero" values omitted, so that the status line will fit comfortably on an 80-column terminal window. (check-in: 9663513116 user: drh tags: trunk) | |
11:13 | Create the new string_agg(X,Y) aggregate function which is an alias for the two-argument group_concat(X,Y) function, for compatibility with SQL-Server and PostgreSQL. (check-in: a3b3df8a9e user: drh tags: trunk) | |
11:06 | Avoid an unnecessary malloc() for the page usage bitmap when running a partial integrity_check. (check-in: 2904fcbeeb user: drh tags: trunk) | |
2023-10-20
| ||
19:59 | Fix a problem allowing a COMMIT following an OOM to cause fts5 corruption. (check-in: fba3129d13 user: dan tags: trunk) | |
19:06 | Fix PRAGMA integrity_check so that it does not raise an error if the schema contains a CREATE VIRTUAL TABLE that does not have its module loaded. (check-in: 5cb61c6788 user: drh tags: trunk) | |
18:09 | Omit some redundant calls to strlen() used to find the size of Expr.u.zToken in sqliteExprDup(). This inefficiency was seen while working on the previous check-in, and I thought it best to fix it while it was fresh in mind. (check-in: b7a84eff5d user: drh tags: trunk) | |
17:15 | Improvements to the sqlite3ExprDup() logic for faster performance and better run-time error detection. This check-in fixes the 5x oversize memory allocation bug from [f371e4c0f8ea73ae] as well as all other known issues that result from handing the ORDER BY clause of an aggregate function off of the pLeft pointer of the Expr object. (check-in: f5c01676fd user: drh tags: trunk) | |
17:06 | Add the SQLITE_CHANGESETAPPLY_FKNOACTION flag to sqlite3session.h, for passing to sqlite3changeset_apply_v2() to cause all foreign key constraints to behave as if they were declared NO ACTION. (check-in: fc9f82ea08 user: dan tags: trunk) | |
15:47 | Simplifications and optimizations to the Expr object duplication logic. The 5x multiplier crutch from [f371e4c0f8ea73ae] is still present. More fixes are still needed. (check-in: 56142a7816 user: drh tags: trunk) | |
14:05 | Omit an unused constant from sessionfuzz.c to prevent a compiler warning. (check-in: a0cf7e24f9 user: drh tags: trunk) | |
12:23 | Correct the opfs-sahpool VFS's xGetLastError() method to return the previous error code, not 0, on success. (check-in: 95a1dde631 user: stephan tags: trunk) | |
10:18 | Use sqlite3ParserAddCleanup() instead of calling sqlite3ExprListDelete() directly when disposing of an unused ORDER BY in an aggregate function, to avoid disrupting ALTER TABLE data structures. (check-in: d083e42086 user: drh tags: trunk) | |
2023-10-19
| ||
20:06 | Remove a faulty assert() that was added just a few check-ins ago by [8b6fffb552c30f9c]. (check-in: 18e7c826f0 user: drh tags: trunk) | |
19:57 | For TK_ORDER expression nodes to always be full-size. (check-in: a5c73b46f4 user: drh tags: trunk) | |
19:19 | Fix an adverse interaction between the new aggregate ORDER BY logic and the expression compressor. Update 2023-10-20: Memory allocations were multiplied by a factor of 5 on line 1575 of expr.c. This was a debugging change that I neglected to remove prior to checking it. That change masks deeper problems that will be solved in later check-ins. (check-in: f371e4c0f8 user: drh tags: trunk) | |
19:08 | In the TreeView logic (used for debugging only) do not show unnecessary fields of the Window object when a function has a FILTER. (check-in: d2c6b82c34 user: drh tags: trunk) | |
18:23 | Fix an fts3 problem caused by reducing the page size using the undocumented "nodesize" option, then running an incremental-merge. (check-in: 2875dcb1ac user: dan tags: trunk) | |
18:07 | Simplify the Expr compression logic slightly by adding the new EP_FullSize property to expressions that are exceptions to the rule and should not be compressed. (check-in: d5ae82ec52 user: drh tags: trunk) | |
13:35 | Simplification to sqlite3GetVarint32() to avoid confusing gcov. (check-in: 89862c51ad user: drh tags: trunk) | |
13:00 | Fix an error in a debugging routine used inside of testcase(). Does not appear in production. Problem discovered by scan-build. (check-in: c6c9d7ed6d user: drh tags: trunk) | |
12:36 | New assert() statements to help verify correctness of the ORDER BY aggregate code. (check-in: 8b6fffb552 user: drh tags: trunk) | |
12:12 | Fix the sqlite3ReferencesSrcList() routine so that it recognizes columns in the ORDER BY clause of an aggregate. Fixes a problem with [634286828dad873d] discoverd by dbsqlfuzz. (check-in: 3d26f1aaa4 user: drh tags: trunk) | |
01:26 | Add support for ORDER BY on the argument list of aggregate functions. (check-in: 634286828d user: drh tags: trunk) | |
00:25 | Fix a false-positive in run-time error checking. (check-in: cd63eec075 user: drh tags: trunk) | |
2023-10-17
| ||
23:35 | JS: replace one errant reference to 'self' with 'globalThis' and remove a separate dead-code 'self' reference. (check-in: da1a47932e user: stephan tags: trunk) | |
19:33 | Fix a harmless compiler warning about variant types for a pointer function. (check-in: 37ff0d8e7f user: drh tags: trunk) | |
18:59 | Make a new branch in the SqlExec opcode reachable by tests. (check-in: 023ad470b6 user: drh tags: trunk) | |
18:28 | Omit an unreachable branch when SQLITE_ENABLE_API_ARMOR is not defined. (check-in: 5f8b807b56 user: drh tags: trunk) | |
17:53 | Changes to sqlite3IntFloatCompare() in an attempt to better measure branch coverage in the face of aggressive compiler optimization. (check-in: 5781d043ff user: drh tags: trunk) | |
13:41 | Fix a JSON bug introduced by the optimization of [df099ad713011b67] and first appearing in 3.43.0. The problem occurs when doing a JSON_EXTRACT() on an array element that was added by JSON_SET() without first reparsing. Reported by forum post fc0e3f1e2a. (check-in: e5099c549a user: drh tags: trunk) | |
11:57 | Enhance the documentation of sqlite3_deserialize() to make it clear that the input database may not be in WAL mode. Forum post a7e272cee9ac469f (check-in: e754789971 user: drh tags: trunk) | |
10:47 | When an I/O or similar error occurs during a transaction with journal_mode=MEMORY, attempt to rollback before closing the journal, as all rollback information is forgotten when a memory rollback journal is closed. (check-in: 1d67f75de2 user: drh tags: trunk) | |
02:15 | Harden API_ARMOR checks for sqlite3_stmt_scanstatus_v2(). (check-in: d3f38e813b user: stephan tags: trunk) | |
2023-10-16
| ||
16:04 | JNI: add aggregate function support to the wrapper1 API. (check-in: 15b28b340a user: stephan tags: trunk) | |
14:31 | JNI: add scalar UDF support to the wrapper1 API. (check-in: a850535766 user: stephan tags: trunk) | |
13:04 | JNI: initial draft (untested - requires more infrastructure first) of a UDF argument/result-handling interface which completely hides the C-style API from the client. (check-in: 43b10a5cf9 user: stephan tags: trunk) | |
10:38 | JNI: cleanups in Tester2 and update the jar makefile target to account for [9fcdf96adca2]. (check-in: abc82bf4b8 user: stephan tags: trunk) | |
10:27 | JNI: move the C-style API parts into the capi subpackage and the higher-level wrapper into (tentatively) wrapper1, so that CApi.java can support multiple independent higher-level wrappers without name collisions, and CApi can be made public but have the option to be elided from wrapper-level javadocs for wrappers which do not wish to expose it. (check-in: 9fcdf96adc user: stephan tags: trunk) | |
08:10 | JNI: after calling a Java-side UDF, zero-out the pointer of the Java-side sqlite3_context and sqlite3_value array entries to avoid misbehavior if a client makes the mistake of holding a reference to one of those objects. (check-in: 9fc3104f76 user: stephan tags: trunk) | |
08:05 | JNI: do not expose SQLITE_OPEN_... flags which are specific to VFSes. (check-in: 2b4e53d8be user: stephan tags: trunk) | |
2023-10-15
| ||
13:36 | Change 3 instance of #if SQLITE_ENABLE_API_ARMOR to #ifdef for consistency with how it is normally used. (check-in: dd766eeb59 user: stephan tags: trunk) | |
13:32 | JNI: enable all optional components in the default build and fix a test broken by an option toggle. (check-in: 5586a9df58 user: stephan tags: trunk) | |
13:25 | Correct non-void return from sqlite3_preupdate_hook() when API_ARMOR is enabled. Broken by [6cb77503484e]. (check-in: 40f5906f48 user: stephan tags: trunk) | |
12:11 | Add coverage of more functions to SQLITE_ENABLE_API_ARMOR builds. (check-in: 6cb7750348 user: stephan tags: trunk) | |
2023-10-14
| ||
20:24 | Do not allow an ALTER TABLE ADD COLUMN on a STRICT table if the added column contains a DEFAULT clause that would violate the type of the added column. (check-in: 75b075863e user: drh tags: trunk) | |
17:14 | The rtreecheck() SQL function should not invoke BEGIN or COMMIT as this causes issues for statement transactions. (check-in: b7b2e30b57 user: drh tags: trunk) | |
10:54 | Bug fix in sqlite3_analyzer: for databases larger than 1GiB, take into account the lock-byte page when calculating the number of freelist pages. (check-in: 26a909cdd3 user: drh tags: trunk) | |
2023-10-13
| ||
22:19 | Earlier detection of a host of errors in CREATE TABLE, such the CREATE TABLE statement itself fails, rather than generating an error on the first attempted use of the created table. (check-in: 348fa7aaf7 user: drh tags: trunk) | |
19:41 | Apply the correct affinity to DEFAULT values that are TRUE or FALSE. (check-in: 4958db70c8 user: drh tags: trunk) | |
18:29 | Do not allow triggers on shadow tables under defensive mode. (check-in: 44b932ff16 user: drh tags: trunk) | |
15:59 | Fix an fts5 problem caused by a 'rebuild' followed by a DELETE in secure-delete mode. (check-in: 18be505c62 user: dan tags: trunk) | |
13:49 | Immediately fail a CREATE TABLE statement that attempts to create a table that has a generated column loop. Legacy allows the table to be created but the table would not be usable for anything. (check-in: 3237bf9641 user: drh tags: trunk) | |
12:57 | Actually prevent PRAGMA writable_schema=ON from being set in defensive mode, rather than just preventing it from functioning. (check-in: 2b574d9e7e user: drh tags: trunk) | |
01:39 | Avoid potential overflow in hex(). See forum post 7ac0c9c5ea. (check-in: 2e968114fd user: larrybr tags: trunk) | |
2023-10-12
| ||
20:51 | Make sure virtual tables have been connected before trying to invoke the xIntegrity method during PRAGMA integrity_check. (check-in: 4a4eccb681 user: drh tags: trunk) | |
19:46 | Fix a problem with an fts5 secure-delete on a rowid/term pair that follows a legacy delete of the same pair. (check-in: 579aea0c28 user: dan tags: trunk) | |
18:46 | Enable SQLITE_VTAB_INNOCUOUS for FTS3, FTS5, and RTREE. (check-in: f34c533b6c user: drh tags: trunk) | |
18:09 | Add test case for [29937081]. (check-in: d3b983edf7 user: dan tags: trunk) | |
17:41 | Make sure the journal file is closed when transitioning into MEMORY journal mode, to avoid an assertion fault in the new sqlite3_randomness() avoidance code added by [c84e4483cb44f827]. (check-in: 29937081a9 user: drh tags: trunk) | |
15:12 | CLI to check for rare prepare failures. See forum post 5be6395182. (check-in: 286d1e8012 user: larrybr tags: trunk) | |
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) | |
20:37 | Unconditionally force use of SQLITE_ENABLE_API_ARMOR in the WASM and JNI builds. Their corresponding test suites still work. (check-in: c11394b50d user: stephan tags: trunk) | |
17:24 | Fix the use of an uninitialized value that occurs when doing a json_insert() of a string value that contains embedded U+0000 characters. (check-in: d3c0cbb909 user: drh tags: trunk) | |
13:52 | Add (prepare, step, reset, finalize) parts of the JNI level-2 stmt wrapper and associated tests. (check-in: a7082f186f user: stephan tags: trunk) | |
13:34 | Simplification to sqlite3ApiExit(). Generates identical machine code, but easier for humans to read. (check-in: 793bbfa5af user: drh tags: trunk) | |
2023-10-10
| ||
15:33 | Fix a bug in the mkautoconfamal.sh script, introduced by check-in [3308fdda4b81c110] so that the "snapshot-tarball" and "amalgamation-tarball" makefile targets work again when run from outside of the source tree. (check-in: 65ccf5fef8 user: drh tags: trunk) | |
12:16 | Start adding tests for the second JNI layer. (check-in: 0177f4dfe8 user: stephan tags: trunk) | |
2023-10-09
| ||
22:45 | Use snprintf() in place of sprintf() in a debugging function in the CLI. (check-in: 5e5e4d2b49 user: drh tags: trunk) | |
17:54 | Avoid calling sqlite3_randomness and taking the PRNG mutex when writing a journal header in "journal_mode=memory" mode. (check-in: c84e4483cb user: dan tags: trunk) | |
14:56 | Add a TCL script that does various verification checks on the source tree to make sure that generated code has been updated correctly. (check-in: 1f1a358af7 user: drh tags: trunk) | |
14:47 | Fix a compiler warning caused by the previous check-in. (check-in: 7e8768bf8b user: drh tags: trunk) | |
14:05 | Turn on SEH by default when building using MSVC. (check-in: f57e8275cf user: drh tags: trunk) | |
12:46 | Fix a potential UAF caused by JSON parser cache spill. Forum post b25edc1d46. (check-in: a163fecca9 user: drh tags: trunk) | |
12:45 | Flesh out the error state captured by SqliteException.java. Doc additions. (check-in: 5c5397ff15 user: stephan tags: trunk) | |
12:39 | Fix harmless compiler warning in the test module for sessions. (check-in: 3d5ec99397 user: drh tags: trunk) | |
11:46 | Add JNI Sqlite and SqliteException classes. Add Tester2.java as the main test app for the high-level API. (check-in: 6acf52be7a user: stephan tags: trunk) | |
10:44 | Minor JNI doc and public/private cleanups. (check-in: c49d36ece2 user: stephan tags: trunk) | |
10:30 | Rename SQLite3Jni to CApi to (A) reduce name prefix collisions with incoming classes and (B) align with its counterpart in the JS build. Remove the Canonical annotation because (A) the new code separation will inherently make that distinction and (B) the line between truly canonical and semi-canonical (e.g. differing in signature overloads) is blurry enough that consistent use of that annocation is becoming an unnecessary burden. (check-in: ca216b4486 user: stephan tags: trunk) | |
2023-10-07
| ||
17:29 | Fix a problem with sqlite3changegroup_schema() and patchsets. (check-in: c4ab4200dc user: dan tags: trunk) | |
16:32 | Add the sqlite3changegroup_schema() API. To allow changegroup objects to upgrade the schema of a changeset/patchset under some circumstances. (check-in: 03f9e50b15 user: dan tags: trunk) | |
16:07 | Fix a problem with the changes on this branch and tables that use an implicit primary key. (Closed-Leaf check-in: 1f9d10235f user: dan tags: session-alter) | |
2023-10-06
| ||
20:39 | Add missing source code comments and fix other issues with the new code on this branch. (check-in: df39fbe9ab user: dan tags: session-alter) | |
19:46 | Update this branch with latest changes from the trunk. (check-in: 897e926a5e user: dan tags: session-alter) | |
19:01 | Add tests for the sqlite3changegroup_schema() API. (check-in: 5dab481c10 user: dan tags: session-alter) | |
2023-10-05
| ||
19:09 | Add the sqlite3changegroup_schema() API. To allow changegroups to handle differences in schema created by ALTER TABLE ADD COLUMN. (check-in: 309deee2dd user: dan tags: session-alter) | |
2023-10-04
| ||
21:15 | Allow a session object to generate a changeset, even if columns were added to one of the tables using ALTER TABLE ADD COLUMN while the changeset was being collected. (check-in: a3f435eccf user: dan tags: session-alter) | |
12:49 | The Makefile distinguishes between tcl8.4 and tcl8.5. Some makefile targets require tcl8.5, but others (ex: "sqlite3.c", "shell.c", and "sqlite3") require only tcl8.4. (check-in: 770308db97 user: drh tags: trunk) | |
11:52 | Modify the main makefile so that it fails with an error if the tclsh found by ./configure is not tclsh 8.5 or later. Forum post 4380363682708ece. (check-in: 1765f3b5a0 user: drh tags: trunk) | |
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-10-02
| ||
17:12 | JNI: when fetching text-or-blob/length pairs, fetch the text-or-blob first, then the length, as the API docs suggest. (check-in: e4f9d3946f user: stephan tags: trunk) | |
17:06 | Fix the length of the string in the new concat() and concat_ws() functions. (check-in: 3252432265 user: drh tags: trunk) | |
15:56 | Remove an ALWAYS() from a branch that can in fact be false following an OOM fault. (check-in: 3a1feb1c46 user: drh tags: trunk) | |
14:44 | Pointer-casting-related fixes for JNI on 32-bit ARM (pi4 armv7l). (check-in: 54441039ae user: stephan tags: trunk) | |
2023-10-01
| ||
12:15 | Add JNI binding for sqlite3_normalized_sql(). (check-in: 2532e5662a user: stephan tags: trunk) | |
11:53 | Make JNI binding of sqlite3_value_frombind() return boolean instead of int and add tests for it. (check-in: 906e2ed3e9 user: stephan tags: trunk) | |
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) | |