Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
182 events for the month beginning 2023-12-01
Following month ↑|
2023-12-31
| ||
| 20:04 | Better comments. Slight tuning of parameters. (check-in: 1cc32ecc user: drh tags: enhanced-stat1) | |
| 12:38 | Ensure that all elements of aiRowLogEst[] have been initialized even if the stat entry is truncated. (check-in: c216921b user: drh tags: enhanced-stat1) | |
| 04:01 | Use SQLITE_ENABLE_STAT4 in both the WASM and JNI builds. (check-in: 99d11e6d user: stephan tags: trunk) | |
|
2023-12-30
| ||
| 22:00 | In sqlite_stat1, revert the number of rows to the average, not adjusted for the maximum. Instead add "uneven=NNN" where NNN is a multiplier to apply to the average to get the maximum. "uneven" is only reported if NNN is 10 or more. Also add the "slow" argument is the maximum number of rows reported by a full equality match is so large that a table scan seems likely to be faster. (check-in: 41773fa7 user: drh tags: enhanced-stat1) | |
| 15:07 | Omit the "noquery" argument in sqlite_stat1. Instead, add the "uneven" argument for indexes that have an uneven distribution of values. Modify the query planner to avoid doing equality look-ups on uneven indexes. (check-in: 0ec4b880 user: drh tags: enhanced-stat1) | |
|
2023-12-29
| ||
| 21:07 | Revise the "noquery" decision algorithm again. The index now must select more than 150 rows on average, and the number of rows select must be enough that it seems faster to do a full scan of the associated table. (check-in: f516ef80 user: drh tags: enhanced-stat1) | |
| 20:31 | Fix an issue in the "noquery" decision in the previous check-in. Also add comments explaining the algorithm. (check-in: 6aaa65ad user: drh tags: enhanced-stat1) | |
| 20:08 | Add the "noquery" argument as an option for the stat column of sqlite_stat1. If set, then the index will not be used to optimize a query. Enhance ANALYZE to set that argument on very low selectivity indexes. (check-in: e514d3fa user: drh tags: enhanced-stat1) | |
| 19:03 | Attempt to improve the ANALYZE command so that it does a better job of detecting lopsided indexes and makes appropriate changes to the sqlite_stat1 table. (check-in: 4b70b946 user: drh tags: enhanced-stat1) | |
| 04:29 | Minor doc touchup in the JS bits. (check-in: 8d2120c3 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: 630604a4 user: drh tags: trunk) | |
| 20:54 | Update fts5origintext4.test to work with SQLITE_DIRECT_OVERFLOW_READ. (check-in: 15ed002a user: dan tags: trunk) | |
| 19:18 | Performance improvement by unwinding a loop in jsonAppendString(). (check-in: 190ab3c0 user: drh tags: trunk) | |
| 16:25 | Fix harmless compiler warnings in FTS5. (check-in: 3cd5ef44 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: 056de8d5 user: drh tags: trunk) | |
| 14:07 | Merge the latest trunk changes into the reuse-schema branch. (check-in: 3d1b0403 user: drh tags: reuse-schema) | |
| 14:01 | Merge the latest trunk changes into the bedrock branch. (check-in: 5a17b972 user: drh tags: bedrock) | |
| 13:44 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 1f592dd3 user: drh tags: wal2) | |
| 13:40 | Merge recent trunk enhancements into the begin-concurrrent branch. (check-in: b3a2adfd user: drh tags: begin-concurrent) | |
|
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: 026618b9 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: 1a8a9b1c user: dan tags: trunk) | |
| 13:20 | Improved handling of malformed unicode within JSON strings. (check-in: e252bdf5 user: drh tags: trunk) | |
|
2023-12-24
| ||
| 12:02 | Remove an ALWAYS() added in [c50e6c2ace49d092] because it is sometimes false. dbsqlfuzz c393a4f783d42efd9552772110aff7e5d937f15e. (check-in: b9daf37e user: drh tags: trunk) | |
| 11:43 | Fix harmless compiler warnings associated with [5db30bcc338aac1c] (check-in: e55d1c23 user: drh tags: trunk) | |
| 11:31 | Avoid signed integer overflow during integrity_check of FTS5. (check-in: 5937df3b user: drh tags: trunk) | |
|
2023-12-23
| ||
| 19:05 | • Edit [72fcc12cda910a0e|72fcc12c]: Edit check-in comment. (artifact: 0a634a53 user: drh) | |
| 19:03 | Improvements to the query planner to address the inefficiency described by forum post 2568d1f6e6. (check-in: 72fcc12c 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: 5db30bcc user: drh tags: trunk) | |
|
2023-12-22
| ||
| 21:22 | Change parameters on a debugging function to include "const". (check-in: 94c3e111 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: 89563311 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: 7374c234 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: 0f22d809 user: stephan tags: trunk) | |
| 14:47 | Fix a usan complaint about signed integer overflow. (check-in: e65907e0 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: da5f34fd user: drh tags: trunk) | |
|
2023-12-21
| ||
| 18:08 | Add internal core-developer-only documentation of the JSONB format. (check-in: 4d304788 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: 029a05cd user: dan tags: trunk) | |
| 11:34 | Avoid harmless integer overflow in pager status statistics gathering. Response to forum post 7f4cdf23f9. (check-in: 206d8c65 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: 215fabda user: drh tags: trunk) | |
| 15:51 | Remove redundant conditional from sqlite3ExprCanBeNull(). (check-in: 257f96a2 user: drh tags: trunk) | |
| 15:10 | On second thought, we don't really need sqlite_dbdata accessible to the CLI. (check-in: 36fe6a61 user: drh tags: trunk) | |
| 15:06 | Fix harmless compiler warning in the randomjson.c extension. (check-in: debe7060 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: 0c8d88e4 user: drh tags: trunk) | |
| 14:53 | Add ALWAYS() and NEVER() on branches made unreachable by recent changes. (check-in: c50e6c2a 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: 34ae36a4 user: drh tags: trunk) | |
| 13:00 | Test case for the previous check-in. (check-in: df5a07e1 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: 8f770d14 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: d2e6117e user: drh tags: trunk) | |
| 12:23 | Always make the sqlite_dbdata virtual table available in the CLI. (check-in: e5fd3b32 user: drh tags: trunk) | |
| 11:57 | Extra ALWAYS() macros to verify state in the sqlite3ExprCanBeNull() routine. (check-in: be19b84c user: drh tags: trunk) | |
| 00:07 | Remove a stray comment in the JSON code. (check-in: 6618bdf0 user: drh tags: trunk) | |
|
2023-12-18
| ||
| 19:18 | New JSON invariant test cases. (check-in: a6a1367b user: drh tags: trunk) | |
| 18:50 | Add NEVER() to an unfalsifiable branch. (check-in: 9a0c67db user: drh tags: trunk) | |
| 18:31 | Fix JSON to JSONB translation so that it deals correctly with Infinity and NaN. (check-in: 178cb84f 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: 4b458166 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: f1c04060 user: drh tags: trunk) | |
| 14:16 | Ensure that all object labels for individual objects generated by randomjson.c are unique. (check-in: 29c46aca user: drh tags: trunk) | |
| 13:51 | Bug fix in the randomjson.c extension. (check-in: 1f3a33df user: drh tags: trunk) | |
| 12:18 | Enhancements to ext/misc/randomjson.c. (check-in: a4e6d1f8 user: drh tags: trunk) | |
|
2023-12-17
| ||
| 20:41 | Enhancements to the "randomjson.c" extension. Automatically load that extension into fuzzcheck. (check-in: 70620405 user: drh tags: trunk) | |
|
2023-12-16
| ||
| 15:48 | Enable SQLITE_STRICT_SUBTYPE for default builds of the shell, fuzzcheck, and testfixture. (check-in: 5a0c517e user: drh tags: trunk) | |
| 10:50 | New test case based on Chromium bug report 1511689. (check-in: 2c7ef4b4 user: drh tags: trunk) | |
|
2023-12-15
| ||
| 21:39 | Fix a spurious "misuse of aggregate function" error that could occur when an aggregate function was used within the FROM clause of a sub-select of the select that owns the aggregate. (check-in: 122cd0ba user: drh tags: branch-3.43) | |
| 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: da442578 user: drh tags: trunk) | |
| 19:26 | Avoid expiring prepared statements in the middle of an integrity-check. (check-in: 88beb484 user: dan tags: trunk) | |
| 16:28 | Add mention of --buildonly and --dryrun to the testrunner.tcl usage screen. (check-in: 23b92d91 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: b995aae5 user: drh tags: trunk) | |
| 15:17 | Do not run test script fts5origintest4.test with either "memsubsys1" or "mmap" permutations. (check-in: 05a63d96 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: 6b4e1344 user: dan tags: trunk) | |
| 13:38 | Correct --enable-sab flag in ext/wasm/GNUmakefile to fix a silent alhttpd args-parsing error. (check-in: 7b9b757d 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: 99021135 user: stephan tags: trunk) | |
| 16:34 | Add assert()s to FTS5 to fix static analyzer warnings. (check-in: 27d4a89a user: drh tags: trunk) | |
| 15:38 | Fix harmless compiler warnings in JSON and FTS5. (check-in: 90135efc 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: 0fbf4b8a 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: d302a389 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: 3536f403 user: drh tags: agg-orderby-subtype) | |
|
2023-12-13
| ||
| 20:37 | In CLI, fix .read inability to open 2GB+ files on WIN32. (check-in: 56c80a62 user: larrybr tags: trunk) | |
| 16:50 | Avoid invoking sqlite3ExprColUsage() on an unresolve column reference. (check-in: 6e0e2ee7 user: drh tags: branch-3.44) | |
| 16:45 | Avoid invoking sqlite3ExprColUsage() on an unresolve column reference. dbsqlfuzz fc34aa62df4de103705d11b807074687ffafbda5. (check-in: ac9314c0 user: drh tags: trunk) | |
| 15:27 | Bug fix in the JSONB validator. dbsqlfuzz ac6fa521a08609a642198e7decf64180e750b3c4 (check-in: 3e940a6a user: drh tags: trunk) | |
| 14:31 | Improvements to UTF8 handling, and especially the handling of invalid UTF8, in the JSON routines. (check-in: 1b229c11 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: 4d5353ca 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: 3874e5a3 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: 194276e1 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: 840efb33 user: drh tags: trunk) | |
| 17:13 | Add NEVER to two unreachable branches in JSON. (Closed-Leaf check-in: c96ebb08 user: drh tags: jsonb-valid) | |
| 14:33 | Improvements to JSONB validation - catch more cases where the input does not conform to spec. (check-in: be1864ea user: drh tags: jsonb-valid) | |
| 02:31 | Validity checking of text nodes in JSONB. (check-in: fa516068 user: drh tags: jsonb-valid) | |
|
2023-12-11
| ||
| 21:00 | The json_error_position() function now reports an approximate byte offset to the problem in a JSONB if there is a problem. (check-in: 80d5d94d user: drh tags: jsonb-valid) | |
| 20:44 | json_error_position() now uses jsonValidityCheck() to find the approximate position of an error in a JSONB blob. (check-in: c3d60cf7 user: drh tags: jsonb-valid) | |
| 20:19 | json_valid(*,8) allows minus-signs on hexadecimal literals. (check-in: c0d7f452 user: drh tags: jsonb-valid) | |
| 19:21 | Activate JSON_SELFCHECK within fuzzcheck. (check-in: 4d14e733 user: drh tags: jsonb-valid) | |
| 19:00 | Rename the new test-control to SQLITE_TESTCTRL_JSON_SELFCHECK. Make it so that the current value of the setting can be interrogated. (check-in: 7aff1d9a user: drh tags: jsonb-valid) | |
| 17:03 | Add SQLITE_TESTCTRL_VALIDATE_JSONB, which if enabled under SQLITE_DEBUG causes cross-checking of generate JSONB. (check-in: b410a4db user: drh tags: jsonb-valid) | |
| 14:01 | Work toward enhanced functionality for json_valid() with deep checking of the JSONB (second argument has bit 0x08). (check-in: c370d573 user: drh tags: jsonb-valid) | |
| 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: 67da596d 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: fa102036 user: drh tags: trunk) | |
|
2023-12-08
| ||
| 16:56 | Fix a harmless UBSAN warning. (check-in: 1503cba6 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: d2f2174c user: drh tags: trunk) | |
| 12:58 | Fix a harmless compiler warning about "confusing indentation". (check-in: 34f9e9a8 user: drh tags: trunk) | |
| 12:04 | Avoid dropping an error code in new fts5 tokendata=1 code. (check-in: a66596e3 user: dan tags: trunk) | |
|
2023-12-07
| ||
| 21:09 | Ensure an fts5vocab table never uses a special tokendata=1 merge cursor. (check-in: 1e26510e 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: 386ba9e2 user: dan tags: trunk) | |
| 19:08 | Fix a null-pointer dereference in fts5 tokendata=1 code. (check-in: d69fa8f0 user: dan tags: trunk) | |
| 18:41 | Fix a problem with handling OOM and other errors in fts5 when querying tokendata=1 tables. (check-in: bc911ab5 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: d8c6b246 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: 858b76a0 user: drh tags: trunk) | |
| 13:14 | Add ALWAYS() on branches added in [ec0ae4030968c782] that are always true. (check-in: 451cef86 user: drh tags: trunk) | |
| 12:55 | Improved detection of corrupt JSONB in the jsonReturnFromBlob() function. (check-in: b014736c user: drh tags: trunk) | |
|
2023-12-06
| ||
| 22:22 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 5c36819c user: drh tags: reuse-schema) | |
| 21:18 | Merge the latest trunk changes into the bedrock branch. (check-in: c2e53000 user: drh tags: bedrock) | |
| 21:11 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 457724e7 user: drh tags: wal2) | |
| 21:05 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: b1c58f48 user: drh tags: begin-concurrent) | |
| 18:34 | Fix compiler warning about shadowed variable in fts5_index.c. (check-in: ee70e4c1 user: dan tags: trunk) | |
| 18:25 | Work around LLVM's newfound hatred of function pointer casts. Forum post 1a7d257346636292. (check-in: ec0ae403 user: drh tags: trunk) | |
| 18:10 | Update documentation comments in fts5.h. (check-in: 38c50e22 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: bda2e30c user: drh tags: trunk) | |
| 17:39 | Correctly handle 8-byte sizes in the JSONB format. Forum post 283daf08e91183fc. (check-in: 73d390f3 user: drh tags: trunk) | |
| 16:57 | Fix the routine that determines the json_tree.path value for the first row so that it correctly takes into account escape sequences in the path argument. (Closed-Leaf check-in: b9243ee8 user: drh tags: json-label-compare) | |
| 16:27 | In CLI, move -interactive flag handling back to arg-loop pass 2. (check-in: 63cb05a8 user: larrybr tags: trunk) | |
| 15:50 | Test cases for object label matching with escape sequences. (check-in: c6f2aa38 user: drh tags: json-label-compare) | |
| 15:35 | The rule for the RHS of the ->> and -> operators when the RHS does not begin with $ is that it must be (1) all digits, or (2) all alphanumerics, or (3) contained within [..] or else it will become a quoted label. (check-in: 0e059a54 user: drh tags: json-label-compare) | |
| 14:50 | Increased rigor in comparisons between object labels in JSON. (check-in: 2bc86d14 user: drh tags: json-label-compare) | |
| 14:36 | Add the tokendata=1 option and related APIs to fts5. (check-in: a76a636b user: dan tags: trunk) | |
| 14:30 | Merge trunk changes into this branch. (Closed-Leaf check-in: 8f46eace user: dan tags: fts5-token-data) | |
| 12:30 | README.md typo fix reported in the forum and update all links from http: to https:. (check-in: 5c48acdb user: stephan tags: trunk) | |
|
2023-12-05
| ||
| 19:45 | Rework the JSON functions so that they use the JSONB format internally. The original JsonNode parse tree design is removed. All JSON functions that accept text JSON also accept JSONB. New functions generate JSONB. (check-in: 7f0c79b9 user: drh tags: trunk) | |
| 19:24 | Use extra assert() statement to silence harmless static analyzer warnings. (Closed-Leaf check-in: 174c2b2e user: drh tags: jsonb) | |
| 18:36 | Further tests for the new code on this branch. (check-in: 59d008b6 user: dan tags: fts5-token-data) | |
| 18:28 | Miscellaneous comment cleanup and typo fixes. (check-in: 59446dc0 user: drh tags: jsonb) | |
| 12:52 | Use strspn() to accelerate whitespace bypass in the JSON parser. (check-in: 843197df user: drh tags: jsonb) | |
| 12:22 | Small performance gain by unwinding the string literal delimiter search loop in the JSON parser by one more level. (check-in: 4c587fea user: drh tags: jsonb) | |
| 12:20 | Clean up the JSONB performance test script. (check-in: 90530107 user: drh tags: jsonb) | |
| 01:44 | Use an assert() to fix a harmless static analyzer warning. (check-in: a249ca65 user: drh tags: jsonb) | |
| 00:17 | Fix OOM and corrupt JSONB handling in json_patch(). (check-in: 1910feb0 user: drh tags: jsonb) | |
|
2023-12-04
| ||
| 23:12 | Rename the internal routine jsonMergePatchBlob() to just jsonMergePatch(). (check-in: ebf667b6 user: drh tags: jsonb) | |
| 19:48 | Add further tests for xInstToken(). (check-in: 8582707f user: dan tags: fts5-token-data) | |
| 19:32 | Fixes to error handling in json_array_length(). (check-in: aa85df2d user: drh tags: jsonb) | |
| 19:14 | Do not make the input JSONB editable in json_remove() if there are no PATH argument. (check-in: 66594544 user: drh tags: jsonb) | |
| 18:53 | Fix errors in rendering JSON5 escape sequences embedded in JSONB. (check-in: f1a51ae3 user: drh tags: jsonb) | |
| 18:45 | Fixes for xInstToken() with tokendata=0 tables. And with prefix queries. (check-in: 78fbb715 user: dan tags: fts5-token-data) | |
| 17:58 | Fix memory leak in new code on this branch. (check-in: ebc160b9 user: dan tags: fts5-token-data) | |
| 17:45 | Fix a problem with the xInstCount() API and "ORDER BY rank" queries. (check-in: 317a5056 user: dan tags: fts5-token-data) | |
| 17:40 | Continuing simplifications and code cleanup. (check-in: ddf92b50 user: drh tags: jsonb) | |
| 17:05 | Fix bug in xInstToken() causing the wrong token to be returned. (check-in: da78d07e user: dan tags: fts5-token-data) | |
| 16:01 | Remove reachable ALWAYS and NEVER macros. (check-in: f601de3e user: drh tags: jsonb) | |
| 15:22 | Two new NEVER macros. (check-in: 52632c92 user: drh tags: jsonb) | |
| 15:08 | Add tests for using tokendata=1 and contentless_delete=1 together. (check-in: a2506b8c user: dan tags: fts5-token-data) | |
| 13:12 | Repair issues and inefficiencies found during testing. (check-in: ae973cb1 user: drh tags: jsonb) | |
| 01:14 | Better pre-scan size estimations for objects in the JSON parser resulting in fewer reallocations and memmove operations. (check-in: 526b27f9 user: drh tags: jsonb) | |
| 00:31 | Back off on the use of strlen() for situations where sqlite3_value_bytes() will work as well, for performance. (check-in: 79fb54fb user: drh tags: jsonb) | |
|
2023-12-03
| ||
| 23:38 | Remove dead code. Improved reporting of errors in JSON inputs. (check-in: 2eaa738e user: drh tags: jsonb) | |
| 23:30 | Avoid problems when the path argument to json_tree() contains embedded U+0000 characters. (check-in: 9f055091 user: drh tags: jsonb) | |
| 20:11 | Ensure that OOM conditions in the generation of the "bad JSON path" error message result in an SQLITE_NOMEM error. (check-in: aa0e02b5 user: drh tags: jsonb) | |
| 19:59 | Enable incorrect JSONB to be rendered into text without hitting an assertion for a bad whitespace escape in a string. (check-in: 4d6a9a21 user: drh tags: jsonb) | |
| 19:32 | Partial hand-merge of shell.c.in (not buildable) (Leaf check-in: 62e90c9b user: larrybr tags: cli_extension_wip) | |
| 11:54 | Do not let bad hexadecimal digits in malformed JSONB cause an assertion fault. (check-in: 8dec1ba1 user: drh tags: jsonb) | |
| 00:51 | Minor code changes for consistency and to simplify testing. (check-in: df272bd8 user: drh tags: jsonb) | |
|
2023-12-02
| ||
| 21:39 | Implement strict JSONB checking in the json_valid() function. (check-in: 0f26d388 user: drh tags: jsonb) | |
| 20:37 | Fix harmless compiler warnings reported by MSVC. (check-in: 419652c0 user: drh tags: jsonb) | |
| 20:35 | Fix various compiler warnings and other problems with the new code on this branch. (check-in: 3a623cfa user: dan tags: fts5-token-data) | |
| 20:25 | Code and comment cleanup. Everything should work the same. (check-in: c640754d user: drh tags: jsonb) | |
| 18:17 | Fix harmless compiler warnings. Refactor some identifier names for clearer presentation. (check-in: 7e394150 user: drh tags: jsonb) | |
| 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: e0175d07 user: dan tags: fts5-token-data) | |
| 18:04 | Take extra care to ensure that JSONB values that are in cache are actually owned by the JSON subsystem, and that ownership of such values is not handed back to the bytecode engine. (check-in: 13045340 user: drh tags: jsonb) | |
| 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: 7bda09ab user: dan tags: fts5-token-data) | |
| 16:11 | Protect a memcpy() against OOM conditions. (check-in: 26144d1c user: drh tags: jsonb) | |
| 15:59 | Do not allow a JsonParse object to be considered "editable" after an OOM. (check-in: c6bacf57 user: drh tags: jsonb) | |
| 15:06 | Fix potential unsigned integer underflow in jsonAppendString(). (check-in: d2fba2cb user: drh tags: jsonb) | |
| 14:55 | Minor fix to the header comment on jsonXlateTextToBlob(). (check-in: c3677ba4 user: drh tags: jsonb) | |
| 14:16 | Performance optimization in jsonAppendString(). (check-in: fdf00e96 user: drh tags: jsonb) | |
| 13:36 | Simplification and optimization of the JSON parser. (check-in: f5ec9485 user: drh tags: jsonb) | |
| 12:23 | Remove a NEVER that can be true if a virtual table column is declared to have a DEFAULT. See forum post 3d4de8917627d058. (check-in: 8abc2cca user: drh tags: trunk) | |
| 01:38 | Unroll a loop in the parser for a performance increase. (check-in: a6dc29e4 user: drh tags: jsonb) | |
| 01:06 | Fix harmless compiler warnings and enhance performance the parser. (check-in: 285633da user: drh tags: jsonb) | |
|
2023-12-01
| ||
| 22:01 | Performance optimization in the JSON parser. (check-in: 68d191f4 user: drh tags: jsonb) | |
| 20:37 | Remove old code for tokendata=1 queries. (check-in: b0a489e8 user: dan tags: fts5-token-data) | |
| 20:10 | Merge latest trunk with this branch. (check-in: 82589674 user: dan tags: fts5-token-data) | |
| 20:09 | Different approach to querying a tokendata=1 table. Saves cpu and memory. (check-in: c523f408 user: dan tags: fts5-token-data) | |
| 18:49 | JSON cache is now more effective. (check-in: 443a3f3a user: drh tags: jsonb) | |
| 18:46 | Fix up the JSON cache to work better. (Closed-Leaf check-in: 1fdbc395 user: drh tags: jsonb-cache) | |
| 13:28 | Cache is working better, but does not preserve the hasJson5 flag. (check-in: a12add7a user: drh tags: jsonb-cache) | |
| 12:57 | First attempt to get the JSON text-to-binary cache working. All test cases pass, but the cache seems not to help much. (check-in: 25ed295f user: drh tags: jsonb) | |