Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around aa999d490b743f45.
|
2023-09-24
| ||
| 19:49 | • Edit [0f6bbb79cbb52f5d|0f6bbb79cb]: Mark "Closed". (artifact: ad17485c43 user: larrybr) | |
| 19:47 | Merge expert changes to accept UDFs and custom collations. (check-in: 8ead1b5ed6 user: larrybr tags: expert-enhancement) | |
| 19:38 | Add minimal exercise of expert acceptance of UDFs and custom collations. (Closed-Leaf check-in: 0f6bbb79cb user: larrybr tags: expert-udfs) | |
| 19:28 | Sync w/trunk prior to merge back. (check-in: 2d290854cd user: larrybr tags: expert-udfs) | |
| 19:13 | Resolve the JNI FTS5 test5() failure and remove some nearby dead code. (check-in: 5655c51f10 user: stephan tags: trunk) | |
| 19:00 | Give expert ability to deal with custom collations. (check-in: ac1dc1b6de user: larrybr tags: expert-udfs) | |
|
2023-09-23
| ||
| 21:31 | Add extra tests for changes on this branch. (check-in: cb45f5b070 user: dan tags: partial-index-terms) | |
| 19:25 | Avoid an error when parsing a schema that contains indexes with WHERE clauses containing unknown collation sequences. (check-in: d5dd39e37a user: dan tags: partial-index-terms) | |
| 18:52 | Fix a failing assert() caused by changes on this branch. (check-in: d0e21f20bd user: dan tags: partial-index-terms) | |
| 18:49 | Fix a harmless compiler warning. (check-in: 7c4210253b user: drh tags: partial-index-terms) | |
| 15:34 | Add extra tests for the fts5 xPhraseQuery API. (check-in: b5edea1631 user: dan tags: trunk) | |
| 06:50 | Resolve the JNI FTS5 test5() crash, caused by two unrelated typos in JNI callback signature strings. That test now fails with an expected-vs-got mismatch but no longer dies in the native code. (check-in: 0233f310bf user: stephan tags: trunk) | |
| 06:37 | Remove an invalid optimization from JNI code and add a missing check check for Java-side exception. (check-in: b8151f8797 user: stephan tags: trunk) | |
|
2023-09-22
| ||
| 20:21 | In partial index scans, if the WHERE clause implies a constant value for a table column, replace occurences of that table column with the constant. This increases the likelihood of the partial index being a covering index. (check-in: 66ed7abdfa user: dan tags: partial-index-terms) | |
| 16:20 | Fix minor parse-to-BLOB bugs. (check-in: 8b53b2e660 user: drh tags: jsonb) | |
| 14:33 | Add the ability to render a binary BLOB back into valid canonical JSON. (check-in: 0b70cb77a4 user: drh tags: jsonb) | |
| 14:20 | Give expert ability to deal with UDFs. (check-in: 3406b05b4f user: larrybr tags: expert-udfs) | |
| 12:16 | Begin adding code to render binary JSON back into text. Very incomplete. This is an incremental check-in. (check-in: b817dd865e user: drh tags: jsonb) | |
| 11:20 | Improvements to the JSON binary BLOB format design. (check-in: 2c89ae5d02 user: drh tags: jsonb) | |
|
2023-09-21
| ||
| 18:16 | Reorganize the code to put the new JSONB routines together, for easier editing. (check-in: dc23e783d4 user: drh tags: jsonb) | |
| 17:51 | Initial development code for an experimental binary BLOB encoding for JSON. (check-in: 8131b3c272 user: drh tags: jsonb) | |
|
2023-09-18
| ||
| 20:42 | Add extra tests for java Fts5ExtensionApi API. (check-in: f9d62b853c user: dan tags: trunk) | |
| 18:12 | Extra tests for java Fts5ExtensionApi interface. (check-in: c923893f36 user: dan tags: trunk) | |
|
2023-09-17
| ||
| 16:36 | Remove a NEVER() in btree.c that could actually be reached, with the approriate database corruption. (check-in: d1fd00e087 user: drh tags: trunk) | |
|
2023-09-16
| ||
| 18:18 | Fix resolution of "rowid" and similar identifiers in queries that use nested joins. (check-in: 37ec43d92b user: dan tags: trunk) | |
| 17:11 | Enable "OR IGNORE" support via SQLITE_VTAB_CONSTRAINT_SUPPORT for internal-content (not contentless or external-content) fts5 tables. (check-in: c362bde4f4 user: dan tags: trunk) | |
| 16:39 | Add a NEVER() to an unreachable branch. (Closed-Leaf check-in: 6b6eb38979 user: drh tags: nested-from-rowid-expansion) | |
| 16:23 | Fix minor code indentation inconsistencies. No function changes. (check-in: 05107a0ae1 user: drh tags: nested-from-rowid-expansion) | |
| 16:12 | Fix a harmless compiler warning. (check-in: 9e9ff4ca3a user: drh tags: nested-from-rowid-expansion) | |
| 14:42 | Further tests and assert() statements for the change on this branch. (check-in: 1c202d540a user: dan tags: nested-from-rowid-expansion) | |
|
2023-09-15
| ||
| 20:57 | Fix resolution of unqualified "rowid" identifiers in queries with nested joins. (check-in: bbcbd3d537 user: dan tags: nested-from-rowid-expansion) | |
| 20:28 | Simplifications and performance optimizations for the RTree extension. (check-in: 04a333f5fa 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: 796a65fa61 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: f911f1c497 user: drh tags: trunk) | |
| 19:27 | Minor simplification to the DISTINCT output row count change. (Closed-Leaf check-in: 0738386d7c 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: 27390051e8 user: drh tags: rethink-viewscan) | |
| 18:36 | Allow expressions like "<tbl>.rowid" to refer to implicit rowid columns of tables in nested FROM clauses. (check-in: 59a1bbc69f user: dan tags: nested-from-rowid-expansion) | |
| 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: 5a940e47d5 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: d9625a9eaf user: drh tags: rethink-viewscan) | |
| 10:30 | • Edit [ce339046416e9dde|ce33904641]: Edit check-in comment. (artifact: 9fd17f809c 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: 4ce5a03e74 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: ce33904641 user: drh tags: trunk) | |
|
2023-09-14
| ||
| 20:56 | Tests for java versions of Fts5ExtensionApi.xSetAuxdata() and xGetAuxdata(). (check-in: 858fa236f8 user: dan tags: trunk) | |
| 20:02 | JNI: move XTokenizeCallback interface out of the Fts5 object - that level of indirection is a holdover from when those classes were in the core package. (check-in: 385ec08570 user: stephan tags: trunk) | |
| 20:01 | Add a few more tests for Fts5ExtensionApi methods. (check-in: 4ce2a7e8ed user: dan tags: trunk) | |
| 17:42 | Add a test for the java version of Fts5ExtensionApi.xRowid(). (check-in: 227facf879 user: dan tags: trunk) | |
| 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: 0ab05871ba 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: d88f41b2cf user: drh tags: trunk) | |
| 14:05 | Avoid a segfault in test program showdb.c that could occur when analyzing a corrupt db. (check-in: 6bf3e90687 user: dan tags: trunk) | |
| 13:10 | Improve the sqlite3IntFloatCompare() routine so that it is testable. (check-in: bb221381fa 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: aa999d490b user: drh tags: trunk) | |
| 01:46 | Reduce the number of calls to sqlite3_mprintf() made by RTree. (Closed-Leaf check-in: f158b7d491 user: drh tags: rtree-performance) | |
|
2023-09-13
| ||
| 21:32 | JNI: enable the fts5-customization bits by default but elide them from the docs until it's clearer where they're headed. Unrelated minor doc tweaks. (check-in: 21adb1aef2 user: stephan tags: trunk) | |
| 20:35 | Improved comments on the hasHighPrecisionDouble() routine. No changes to the underlying code. (Closed-Leaf check-in: 810c635ce0 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: 9a854b9196 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: b3049a1d3d user: drh tags: rtree-performance) | |
| 17:16 | Doc corrections for the previous checkin. (check-in: 9ea0a9f39d user: stephan tags: trunk) | |
| 17:11 | Add JNI sqlite3_prepare_multi(), based on feedback. (check-in: fa1c153472 user: stephan tags: trunk) | |
| 14:07 | Performance optimization to cellContains() in RTREE. (check-in: 43cde22bf3 user: drh tags: rtree-performance) | |
| 13:12 | In the ChooseLeaf algorithm of RTREE, do an initial pass through the cells of a node looking for solutions that involve no cell enlargement. Only look for the minimum cell enlargement if the enlargement is non-zero for all cells. This results in a performance improvement by reducing the number of calls to cellUnion(). (check-in: 59f0e239d1 user: drh tags: rtree-performance) | |
| 13:09 | • Edit [fb2e4a8067edc29b|fb2e4a8067]: Move to branch rtree-performance. (artifact: 790a284f35 user: drh) | |
| 12:06 | Reduce the number of calls to cellArea() in the ChooseLeaf() algorithm of rtree. (check-in: c633fe6be0 user: drh tags: rtree-performance) | |
| 11:36 | Remove unused variable from the ChooseLeaf algorithm in r-tree. (check-in: fb2e4a8067 user: drh tags: rtree-performance) | |
| 11:24 | Replace an if() condition in fts5 that is always true with an assert(). (check-in: 2170312c8d user: dan tags: trunk) | |
|
2023-09-12
| ||
| 23:21 | CLI .import to accept EOF in lieu of record terminator on last field of CSV (with multiple field records), per RFC 4180. forum post 5b21c25bdfa (check-in: 6f7842f577 user: larrybr tags: trunk) | |
| 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: dfc42411e6 user: drh tags: branch-3.43) | |
| 18:36 | Fix a use-after-free error in fts5 that could occur when querying the "rank" column immediately after another connection changes its definition. forum post a2dd636330. (check-in: cb54c2da52 user: dan tags: trunk) | |
| 17:49 | Clarify some metrics output in Tester1.java. (check-in: 4ae7199a82 user: stephan tags: trunk) | |
| 17:06 | Re-add the fts5 decls to sqlite3-jni.h, removed in a rebuild without fts5 enabled. Need a better solution for this problem. (check-in: 6f269790a0 user: stephan tags: trunk) | |
| 17:03 | Rename JNI sqlite3_errmsg() to sqlite3_errmsg16() for overall constency with the text()/text16() family of functions. (check-in: c4a8d8a571 user: stephan tags: trunk) | |
| 16:33 | JNI readme fix. (check-in: 7dde000efc user: stephan tags: trunk) | |
| 14:36 | 64-bit builds on Windows default to using UTF-8 output (as if the -utf8 command-line option had been specified.) 32-bit builds continue to use Windows code pages. There is also a new -no-utf8 command-line option to force the use of legacy code pages. (check-in: d8c7560e88 user: drh tags: trunk) | |
| 14:09 | Show the "(utf8)" tag on the CLI banner in Windows if in UTF8 mode. (Closed-Leaf check-in: 822699a4d9 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: 4cb799c690 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: 8b3c306def user: drh tags: cli-utf8) | |
| 15:35 | Remove a harmlessly unused variable from FTS5. (check-in: 958d62c777 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: ad5cc3758b 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: 3308fdda4b user: drh tags: trunk) | |
| 15:20 | Merge in JNI's significant divergence since it adopted sqlite3_client_data(). (check-in: e8e07dbbea user: stephan tags: trunk) | |
| 15:04 | Fix the TEA version number to be 3.43.1 (check-in: e00f1fedc9 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: 9806c0dd28 user: drh tags: trunk) | |
| 13:06 | Merge version 3.43.1 into the reuse-schema-3.43 subbranch. (check-in: d96586b51b user: drh tags: reuse-schema-3.43) | |
| 12:01 | Version 3.43.1 (check-in: 2d3a40c05c user: drh tags: release, branch-3.43, version-3.43.1) | |
|
2023-09-10
| ||
| 10:56 | Roll back [84e38341aeab] because a direct pointer comparison is ill-advised when the client-data string is dynamically allocated. (Closed-Leaf check-in: 7b884832b7 user: stephan tags: db-client-data) | |
|
2023-09-09
| ||
| 17:53 | Remove out-of-date comment regarding use of Parse.pConstExpr. (check-in: 71548f72ad user: dan tags: trunk) | |
| 15:30 | Merge post-3.43.0 wal2 fixes into the bedrock-3.43 branch. (check-in: 48ecf390da 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: f82b1a0bde user: drh tags: wal2-3.43) | |
| 11:20 | In the JNI build, emit a reminder to not check in the javac-generated sqlite3-jni.h when FTS5 is disabled because changes in that feature flag result in unnecessary and large diffs in checked-in generated code. (Closed-Leaf check-in: caceb52fb5 user: stephan tags: jni-client-data) | |
| 07:52 | Disable FTS5 in the JNI build by default until it can be thoroughly tested. This is mainly so that the public-facing javadoc does not include it. (check-in: 6f25f02b70 user: stephan tags: jni-client-data) | |
|
2023-09-08
| ||
| 20:24 | Merge candidate patches for version 3.43.1 into the reuse-schema-3.43 branch. (check-in: c94be4600d 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: 4cefd16e6d user: drh tags: bedrock-3.43) | |
| 20:14 | Merge the latest 3.43.1 candidate patches into the wal2-3.43 branch. (check-in: b4491c9fbb 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: c786798506 user: drh tags: begin-concurrent-3.43) | |
| 19:58 | • Edit [9e927eed2d9e379d|9e927eed2d]: Edit check-in comment. (artifact: 8e0a859477 user: drh) | |
| 19:35 | Fix a problem with fts5 secure-delete mode causing fts5 to corrupt its records. (check-in: fb24ca17fa user: drh tags: branch-3.43) | |
| 19:32 | Fix a problem with fts5 secure-delete mode causing fts5 to corrupt its records. (check-in: cc0f82a480 user: dan tags: branch-3.42) | |
| 19:18 | Add extra tests for [4b60a1c3]. (check-in: 6357491bd1 user: dan tags: trunk) | |
| 18:34 | Fix a problem with fts5 secure-delete mode causing fts5 to corrupt its records. (check-in: 4b60a1c358 user: dan tags: trunk) | |
| 16:49 | Fix a sanitizer runtime error in wal2 code (that (1 << 31) cannot be represented as an int). (check-in: 79a920c036 user: dan tags: wal2) | |
| 16:07 | Fix an apparently harmless buffer-overrun that could occur on this branch when committing multi-file transactions in wal2 mode. (check-in: ffe043ba06 user: dan tags: bedrock) | |