Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events for the month beginning 2023-09-01 by user drh
Following month ↑|
2023-09-30
| ||
| 16:50 | Restore the trunk version of sqlite3_user_data(). Fix the xColumn for virtual tables so that the sqlite3_context contains a valid but NULL user data pointer. (check-in: 15ffd932 user: drh tags: jsonb) | |
| 14:34 | Finish adding jsonb_ versions for all JSON routines that return JSON text. (check-in: 6daa7b69 user: drh tags: jsonb) | |
|
2023-09-29
| ||
| 22:37 | Update json_each() and json_tree() so that they work with JSONB inputs. (check-in: bb5e50ff user: drh tags: jsonb) | |
| 19:47 | The u.zJContent field of JsonNode for a string or label should NOT include the quotation mark delimiters. Ever. This is an inefficiency that really ought to be fixed on trunk, but that can wait until this branch lands. (check-in: 96f545f6 user: drh tags: jsonb) | |
| 16:37 | Additional refactoring and cleanup. (check-in: 45dd1760 user: drh tags: jsonb) | |
| 16:21 | • Edit [c794aeb374c9e2cb|c794aeb3]: Move to branch mistake. Mark "Closed". Edit check-in comment. (artifact: f06a0098 user: drh) | |
| 15:53 | Remove an incorrect assert(). (check-in: f090af77 user: drh tags: trunk) | |
| 15:18 | Bad edit (Closed-Leaf check-in: c794aeb3 user: drh tags: mistake) | |
| 12:45 | Improvements to comments and procedure names for clarity in the JSON implementation. (check-in: 9b620d81 user: drh tags: jsonb) | |
| 11:17 | Describe the JSONB encoding in a header comment to the json.c source file. (check-in: 1c0cba34 user: drh tags: jsonb) | |
|
2023-09-28
| ||
| 19:11 | Fix some minor memory issues so that all legacy tests now pass. (check-in: 1744bfc6 user: drh tags: jsonb) | |
| 18:23 | Allow the sqlite3_user_data() function to be invoked with a NULL argument or with an sqlite3_context pointer from a virtual table. It returns NULL in both cases. (check-in: 2f496873 user: drh tags: jsonb) | |
| 17:41 | Merge trunk changes into the jsonb branch for the compiler warning fixes from two days ago. (check-in: cee113cc user: drh tags: jsonb) | |
| 17:27 | The json_extract() function now works on BLOBs without the need to translate into an array of JsonNode objects. This is much faster. (check-in: 5853065b user: drh tags: jsonb) | |
| 17:23 | Extract directly from BLOB is now complete and appears to work. (Closed-Leaf check-in: 3de58ec9 user: drh tags: jsonb-direct-extract) | |
| 17:07 | Miscellaneous bugs fixed. (check-in: 5c0815fa user: drh tags: jsonb-direct-extract) | |
| 15:56 | Improvements to json_extract() to better support JSONB. Still not 100% working. (check-in: 8c825761 user: drh tags: jsonb-direct-extract) | |
| 10:20 | Work toward getting json_extract() to operate directly on the BLOB, omitting the translation into a JsonNode array. (check-in: c1feba70 user: drh tags: jsonb-direct-extract) | |
|
2023-09-27
| ||
| 16:55 | Performance tests for JSONB added. (check-in: 7c1be8e3 user: drh tags: jsonb) | |
|
2023-09-26
| ||
| 21:22 | Fix harmless compiler warnings in the testfixture testing utility. (check-in: 5a39a02d user: drh tags: trunk) | |
| 19:46 | Merge partial-index constant value fixes from trunk into the jsonb branch. (check-in: 700bdbd7 user: drh tags: jsonb) | |
| 19:38 | Fix yet another assert() in the partial-index constant value optimization. (check-in: f459d080 user: drh tags: trunk) | |
| 19:30 | Add in many jsonb_xxxx() interfaces. Still uses the internal JsonNode representation for transformations and search, but it does at least conform to the desired API design. Largely untested. (check-in: e6045b4e user: drh tags: jsonb) | |
| 15:13 | Merge all the latest trunk enhancements into jsonb branch. (check-in: ac242c4d user: drh tags: jsonb) | |
| 14:57 | Remove unreachable code from the partial-index constant value optimization ([8d4160910d651246]). (check-in: 7ad38254 user: drh tags: trunk) | |
|
2023-09-25
| ||
| 17:14 | When parsing JSON text into the BLOB format, only use node type JSONB_TEXTJ for an unquoted object label if the object label contains escape sequences. (check-in: a82ebbac user: drh tags: jsonb) | |
| 14:20 | Enable -Wall for the compiler on --enable-debug builds. (check-in: 63a7b521 user: drh tags: trunk) | |
| 13:26 | • Edit [8ead1b5ed6693c0e|8ead1b5e]: Move to branch expert-enhancement. (artifact: 77269d4a user: drh) | |
| 13:23 | As a temporary measure, try to translate the BLOB JSON format into the legacy node format for processing. (check-in: 14f2e95a user: drh tags: jsonb) | |
|
2023-09-23
| ||
| 18:49 | Fix a harmless compiler warning. (check-in: 7c421025 user: drh tags: partial-index-terms) | |
|
2023-09-22
| ||
| 16:20 | Fix minor parse-to-BLOB bugs. (check-in: 8b53b2e6 user: drh tags: jsonb) | |
| 14:33 | Add the ability to render a binary BLOB back into valid canonical JSON. (check-in: 0b70cb77 user: drh tags: jsonb) | |
| 12:16 | Begin adding code to render binary JSON back into text. Very incomplete. This is an incremental check-in. (check-in: b817dd86 user: drh tags: jsonb) | |
| 11:20 | Improvements to the JSON binary BLOB format design. (check-in: 2c89ae5d user: drh tags: jsonb) | |
|
2023-09-21
| ||
| 18:16 | Reorganize the code to put the new JSONB routines together, for easier editing. (check-in: dc23e783 user: drh tags: jsonb) | |
| 17:51 | Initial development code for an experimental binary BLOB encoding for JSON. (check-in: 8131b3c2 user: drh tags: jsonb) | |
|
2023-09-17
| ||
| 16:36 | Remove a NEVER() in btree.c that could actually be reached, with the approriate database corruption. (check-in: d1fd00e0 user: drh tags: trunk) | |
|
2023-09-16
| ||
| 16:39 | Add a NEVER() to an unreachable branch. (Closed-Leaf check-in: 6b6eb389 user: drh tags: nested-from-rowid-expansion) | |
| 16:23 | Fix minor code indentation inconsistencies. No function changes. (check-in: 05107a0a user: drh tags: nested-from-rowid-expansion) | |
| 16:12 | Fix a harmless compiler warning. (check-in: 9e9ff4ca user: drh tags: nested-from-rowid-expansion) | |
|
2023-09-15
| ||
| 20:28 | Simplifications and performance optimizations for the RTree extension. (check-in: 04a333f5 user: drh tags: trunk) | |
| 20:04 | Drop support for the view-scan optimization as it was causing multiple performance regressions. In its place, reduce the estimated row count for DISTINCT subsqueries by a factor of 8. (check-in: 796a65fa user: drh tags: branch-3.28) | |
| 19:51 | Drop support for the view-scan optimization (check-in [609fbb94b8f01d67]) as it was causing multiple performance regressions. In its place, reduce the estimated row count for DISTINCT subsqueries by a factor of 8. (check-in: f911f1c4 user: drh tags: trunk) | |
| 19:27 | Minor simplification to the DISTINCT output row count change. (Closed-Leaf check-in: 0738386d user: drh tags: rethink-viewscan) | |
| 19:00 | Do not reduce subquery output row count estimates due to DISTINCT until after the decision of whether or not to use an index for ORDER BY has been made. (check-in: 27390051 user: drh tags: rethink-viewscan) | |
| 16:15 | Experimental: Assume that a DISTINCT clause on a subquery reduces the number of rows returned by that subquery by a factor of 8. (check-in: 5a940e47 user: drh tags: rethink-viewscan) | |
| 14:06 | The view-scan optimization was added to enhance the performance of one specific query, but it causes performance regressions on a host of others. Disable it (at least temporarily) in order to try to find an alternative way of fixing the one specific query that it was created to fix - an alternative way that does not cause performance problems for other unrelated queries. (check-in: d9625a9e user: drh tags: rethink-viewscan) | |
| 10:30 | • Edit [ce339046416e9dde|ce339046]: Edit check-in comment. (artifact: 9fd17f80 user: drh) | |
| 10:27 | Do not try to convert a double into an unsigned 64-bit integer, as that does not work on all platforms. A double can only be converted into a signed 64-bit integer. (check-in: 4ce5a03e user: drh tags: branch-3.43) | |
| 10:24 | Do not try to convert a double into an unsigned 64-bit integer, as that does not work on all platforms. A double can only be converted into a signed 64-bit integer. This is a fix for the problem reported in forum post 9f6db917e1c05d40. (check-in: ce339046 user: drh tags: trunk) | |
|
2023-09-14
| ||
| 16:45 | According to forum post 9f6db917e1, older MSVC compilers are unable to convert a double directly into an unsigned long long int, but must first go through a signed long long int. Work around this by restricting the range of doubles that are converted into long long integers so that only the lower 63 bits are used. (Closed-Leaf check-in: 0ab05871 user: drh tags: legacy-msvc-workaround) | |
| 16:02 | Document the use of OPFLAG_ISNOOP as the P2 argument on OP_Delete. No functional code changes. (check-in: d88f41b2 user: drh tags: trunk) | |
| 13:10 | Improve the sqlite3IntFloatCompare() routine so that it is testable. (check-in: bb221381 user: drh tags: trunk) | |
| 10:46 | Do not set the global bUseLongDouble flag based purely on sizeof(long double) being more than 8. That is a necessary but not sufficient condition to use the long double routines. Instead, do a run-time test to verify that long double really does provide extra precision. (check-in: aa999d49 user: drh tags: trunk) | |
| 01:46 | Reduce the number of calls to sqlite3_mprintf() made by RTree. (Closed-Leaf check-in: f158b7d4 user: drh tags: rtree-performance) | |
|
2023-09-13
| ||
| 20:35 | Improved comments on the hasHighPrecisionDouble() routine. No changes to the underlying code. (Closed-Leaf check-in: 810c635c user: drh tags: runtime-longdouble-test) | |
| 20:06 | Determine at start time whether or not the underlying hardware supports high-precision long double computations. (check-in: 9a854b91 user: drh tags: runtime-longdouble-test) | |
| 17:30 | Omit the Reinsert algorithm from RTree. This causes most benchmarks to run faster, at the expense of having a slightly less dense and hence larger index (example: 33 entries/node versus 34 entries/node). (check-in: b3049a1d user: drh tags: rtree-performance) | |
| 14:07 | Performance optimization to cellContains() in RTREE. (check-in: 43cde22b user: drh tags: rtree-performance) | |
| 13:12 | In the ChooseLeaf algorithm of RTREE, do an initial pass through the cells of a node looking for solutions that involve no cell enlargement. Only look for the minimum cell enlargement if the enlargement is non-zero for all cells. This results in a performance improvement by reducing the number of calls to cellUnion(). (check-in: 59f0e239 user: drh tags: rtree-performance) | |
| 13:09 | • Edit [fb2e4a8067edc29b|fb2e4a80]: Move to branch rtree-performance. (artifact: 790a284f user: drh) | |
| 12:06 | Reduce the number of calls to cellArea() in the ChooseLeaf() algorithm of rtree. (check-in: c633fe6b user: drh tags: rtree-performance) | |
| 11:36 | Remove unused variable from the ChooseLeaf algorithm in r-tree. (check-in: fb2e4a80 user: drh tags: rtree-performance) | |
|
2023-09-12
| ||
| 23:11 | Fix a use-after-free error in fts5 that could occur when querying the "rank" column immediately after another connection changes its definition. (check-in: dfc42411 user: drh tags: branch-3.43) | |
| 14:36 | 64-bit builds on Windows default to using UTF-8 output (as if the -utf8 command-line option had been specified.) 32-bit builds continue to use Windows code pages. There is also a new -no-utf8 command-line option to force the use of legacy code pages. (check-in: d8c7560e user: drh tags: trunk) | |
| 14:09 | Show the "(utf8)" tag on the CLI banner in Windows if in UTF8 mode. (Closed-Leaf check-in: 822699a4 user: drh tags: cli-utf8) | |
|
2023-09-11
| ||
| 20:09 | Add the -no-utf8 option to the Windows CLI to cause UTF-8 mode to be omitted. (check-in: 4cb799c6 user: drh tags: cli-utf8) | |
| 20:02 | Make the -utf8 option the default behavior in the CLI on Windows for 64-bit builds. (check-in: 8b3c306d user: drh tags: cli-utf8) | |
| 15:35 | Remove a harmlessly unused variable from FTS5. (check-in: 958d62c7 user: drh tags: branch-3.43) | |
| 15:28 | Refuse to build amalgamation-tarball and snapshot-tarball if the TEA version number disagrees with ./VERSION. (check-in: ad5cc375 user: drh tags: branch-3.43) | |
| 15:27 | Refuse to build amalgamation-tarball and snapshot-tarball if the TEA version number disagrees with ./VERSION. (check-in: 3308fdda user: drh tags: trunk) | |
| 15:04 | Fix the TEA version number to be 3.43.1 (check-in: e00f1fed user: drh tags: branch-3.43) | |
| 14:55 | Add support for the sqlite3_get_clientdata() and sqlite3_set_clientdata() interfaces, to better support JNI. (check-in: 9806c0dd user: drh tags: trunk) | |
| 13:06 | Merge version 3.43.1 into the reuse-schema-3.43 subbranch. (check-in: d96586b5 user: drh tags: reuse-schema-3.43) | |
| 12:01 | Version 3.43.1 (check-in: 2d3a40c0 user: drh tags: release, branch-3.43, version-3.43.1) | |
|
2023-09-09
| ||
| 15:30 | Merge post-3.43.0 wal2 fixes into the bedrock-3.43 branch. (check-in: 48ecf390 user: drh tags: bedrock-3.43) | |
| 15:22 | Merge post-3.43.0 wal2 fixes into the wal2-3.43 sub-branch. (Leaf check-in: f82b1a0b user: drh tags: wal2-3.43) | |
|
2023-09-08
| ||
| 20:24 | Merge candidate patches for version 3.43.1 into the reuse-schema-3.43 branch. (check-in: c94be460 user: drh tags: reuse-schema-3.43) | |
| 20:19 | Merge the latest candidate patches for 3.43.1 into the bedrock-3.43 branch. (check-in: 4cefd16e user: drh tags: bedrock-3.43) | |
| 20:14 | Merge the latest 3.43.1 candidate patches into the wal2-3.43 branch. (check-in: b4491c9f user: drh tags: wal2-3.43) | |
| 20:09 | Merge patches queued for version 3.43.1 into the begin-concurrent-3.43 branch. (check-in: c7867985 user: drh tags: begin-concurrent-3.43) | |
| 19:58 | • Edit [9e927eed2d9e379d|9e927eed]: Edit check-in comment. (artifact: 8e0a8594 user: drh) | |
| 19:35 | Fix a problem with fts5 secure-delete mode causing fts5 to corrupt its records. (check-in: fb24ca17 user: drh tags: branch-3.43) | |
|
2023-09-07
| ||
| 16:53 | Enhance the ./configure script and its associated Makefile.in so that the --with-linenoise=DIR argument cause the linenoise command-line editing library located in directory DIR to be linked with the sqlite3 CLI. (check-in: 6c7822b5 user: drh tags: trunk) | |
| 16:48 | • Edit [9c4e4928b14fcace|9c4e4928]: Move to branch wrong-branch. Mark "Closed". (artifact: 1e4a5255 user: drh) | |
| 16:36 | Enhance the ./configure script and its associated Makefile.in so that the --with-linenoise=DIR argument cause the linenoise command-line editing library located in directory DIR to be linked with the sqlite3 CLI. (Closed-Leaf check-in: 9c4e4928 user: drh tags: wrong-branch) | |
| 14:10 | Fix a bad assert() in FTS3. (check-in: 61d2074c user: drh tags: branch-3.43) | |
| 14:04 | Fix a buffer overread in the sessions extension that could occur when processing a corrupt changeset. (check-in: 6009c871 user: drh tags: branch-3.43) | |
| 13:48 | Fix a harmless compiler warning in the sqldiff.c utility. (check-in: e6390a65 user: drh tags: trunk) | |
| 13:43 | Add the "tool-zip" makefile target with the intention of using it to build the "sqlite-tool-*.zip" deliverables. deliverables. (check-in: 06e4af49 user: drh tags: trunk) | |
| 11:48 | Version number to 3.43.1. (check-in: fdfe4d60 user: drh tags: branch-3.43) | |
| 02:13 | Fix a problem with the new xIntegrity method for virtual tables, and also fix a bad assert() in FTS3 that was found by the new xIntegrity method. (check-in: 52bbf44f user: drh tags: trunk) | |
|
2023-09-06
| ||
| 17:07 | Add documentation to sqlite3_get/set_clientdata() to make it clear that these are security-sensitive interfaces that should not be exposed to potential attackers. (check-in: 2837061d user: drh tags: db-client-data) | |
| 16:51 | Add the xIntegrity method to the sqlite3_module object, thus enabling PRAGMA integrity_check to operate on virtual tables. Make use of this new method in the FTS3/4, FTS5, and RTREE virtual tables. (check-in: 2f08e7d2 user: drh tags: trunk) | |
| 16:22 | Fix unreachable branches. (Closed-Leaf check-in: f00fc163 user: drh tags: vtab-integrity-check) | |
| 14:00 | Change the xIntegrity virtual table method signature so that it returns an integer error code and writes the error message into a parameter. (check-in: f1d4024a user: drh tags: vtab-integrity-check) | |
| 12:52 | Add the xIntegrity method to the sqlite3_module object. Implement this method in RTREE, FTS3/4, and FTS5 so that "PRAGMA integrity_check" also verifies the correctness of shadow tables associated with those virtual tables. (check-in: 17bede8c user: drh tags: vtab-integrity-check) | |
|
2023-09-05
| ||
| 15:03 | Fix a few SQLITE_MISUSE returns so that they call sqlite3MisuseError(). (check-in: 93f74490 user: drh tags: trunk) | |
|
2023-09-04
| ||
| 12:50 | Do not make assumptions about the byteorder of PowerPC processors. (check-in: 4a2498fe user: drh tags: trunk) | |
|
2023-09-02
| ||
| 19:35 | Performance optimization to the OP_MakeRecord opcode. (check-in: 2aef9af3 user: drh tags: trunk) | |