hctree

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

133 check-ins going from 8a6196ab29052071 to 688c6279ef1d4ff8

2024-03-19
13:31
When compiled with SQLITE_ALLOW_ROWID_IN_VIEW, rowid-in-view is on by default but can now be turned off using SQLITE_TESTCTRL_ROWID_IN_VIEW. Without the compile-time option, rowid-in-view is always off. check-in: 8a6196ab29 user: drh tags: rowid-in-view
02:30
First steps toward getting -DSQLITE_ALLOW_ROWID_IN_VIEW to work again. That compile-time option is untested, undocumented, and unsupported. But it was mentioned in the release notes for version 3.36.0, so I think that means we need to support it forever. check-in: 7c46ff6402 user: drh tags: rowid-in-view
2024-03-18
21:08
Fix asan problems in sqlite3rbu.c. Enable RBU for sanitizer release tests. check-in: ad2ae7717e user: dan tags: trunk
20:52
Avoid spurious SQLITE_IOERR_DATA errors when reading partial pages from a cksumvfs database using a SQLITE_DIRECT_OVERFLOW_READ build. check-in: 0f485dbece user: dan tags: trunk
18:03
Remove unnecessary blank lines from build commands in the default Makefile.in. check-in: 76fb3a908f user: drh tags: trunk
18:00
Add the "VALUES-as-coroutine" optimization. Large VALUES clauses on an INSERT, for example, prepare and run in about half the time and with half the memory. This check-in also includes enhancements to the internal sqlite3ExprIsConstant() routine to recognize pure SQL functions as constant if they have constant arguments. check-in: a120c9235f user: drh tags: trunk
2024-03-15
17:57
New options for testrunner.tcl: --stop-on-error and --stop-on-coredump. check-in: 82035b9cfd user: drh tags: trunk
17:04
Fix (totally harmless) memory leaks in Lemon to avoid warnings during ASAN builds. check-in: ce009205a8 user: drh tags: trunk
13:16
Tweaks to the func4.test test module (which tests the rarely used totype.c extension) so that it works on i586 compiled using gcc-13 with -O0. Details at [forum:/forumpost/0a7553b0f734c033|forum post 0a7553b0f734c033]. check-in: d0fbe779bc user: drh tags: trunk
2024-03-14
13:18
JS: remove an unused function argument and some debug-related comments. No functional changes. check-in: f15709430d user: stephan tags: trunk
2024-03-13
16:32
Minor change to the "mdevtest" and "sdevtest" in testrunner.tcl, to make it easier to add configurations in branches. check-in: 9349d94e05 user: drh tags: trunk
13:43
If the NJOB environment variable is a positive integer, it causes testrunner.tcl to run that many jobs. check-in: 924281b94d user: drh tags: trunk
13:27
Document the testrunner.tcl --explain option in doc/testrunner.md. check-in: 5a7b5fc99a user: drh tags: trunk
13:09
Add the --explain option to testrunner.tcl. check-in: f0c9eb0326 user: drh tags: trunk
11:46
Improve one of the error messages from testrunner.tcl. check-in: 233155c174 user: drh tags: trunk
11:29
Minor tweaks to the testrunner documentation. check-in: 3128b98d26 user: drh tags: trunk
10:55
Improvements to the "help" message generated by testrunner.tcl. Add the special "list" permutation that does nothing but list all allowed values for the PERMUTATION argument to testrunner.tcl. check-in: 1f5bfc6a90 user: drh tags: trunk
10:54
Add pointer to documentation to testrunner.tcl help message. check-in: eff855102f user: dan tags: trunk
10:47
Have testrunner.tcl set SQLITE_TMPDIR on windows as well. check-in: 64f4dad1f9 user: dan tags: trunk
00:37
On testrunner.tcl: (1) Add the "help" command. (2) Add the "script" command to the help message. (3) Improve the error message generated by "script" when an incorrect CONFIG option is provided. check-in: 1b7f0be440 user: drh tags: trunk
2024-03-12
18:33
Have testrunner.tcl have each test store its temp files in its working directory. To avoid unlikely, but possible, collisions. check-in: 18842d0d72 user: dan tags: trunk
2024-03-11
20:34
Fix another testrunner.tcl problem on windows. check-in: 7805844bc4 user: dan tags: trunk
19:43
Fix a missing brace problem in testrunner.tcl introduced by the previous commit. check-in: 1f5e334d98 user: dan tags: trunk
19:33
Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it. check-in: 6eae4547d4 user: dan tags: trunk
18:21
Run shell*.test modules with "make mdevtest". check-in: 76c4710618 user: drh tags: trunk
11:24
Fix the ".import" command in the CLI so that it works correctly with tables that contain computed columns. [forum:/forumpost/ca014d7358|forum post ca014d7358]. check-in: 95a9c88b25 user: drh tags: trunk
09:39
Add more docs for the OPFS delete-before-open feature. check-in: cb8d9c269c user: stephan tags: trunk
09:34
Add delete-before-open=1 URI flag to the 'opfs' VFS to tell it to xDelete the db file before opening it, primarily to enable users to work around a corrupt db without having to reach into OPFS-specific APIs to remove the db file. check-in: e87cf0d770 user: stephan tags: trunk
2024-03-09
18:41
Fix the .expert command in the shell so that it does not leak memory if not followed by SQL and so that it works with reverse_unordered_selects. check-in: 7ead022eda user: drh tags: trunk
13:31
Fuzzcheck is run automatically by testrunner.tcl, so there is no need to include fuzzcheck as a separate dependency for the releasetest target in the MSVC makefile. check-in: 76629b2bff user: drh tags: trunk
2024-03-08
21:37
The NOT NULL strength reduction optimization from [de9c86c9e4cdb34f] should be applied to the WHERE clause only. Otherwise, the operand of the IS NULL or IS NOT NULL operator might be a reference to a bare column of an aggregate table, and we can't tell if it is NULL or not based only on its NOT NULL attribute. [forum:/forumpost/440f2a2f17|Forum post 440f2a2f17]. check-in: 51704feae2 user: drh tags: trunk
19:03
One of the assert()s added by the previous check-in was not quite correct. This commit fixes it. check-in: d401358329 user: drh tags: trunk
15:39
Add new assert() statements, which if they had existed three years ago, would have detected the code generator problem fixed by the previous check-in. check-in: 166d1e5d26 user: drh tags: trunk
14:01
Silently ignore redundant ON CONFLICT clauses in an UPSERT. Only the first ON CONFLICT for each index is active. Do not issue an error, since that might break legacy queries. But ignore the redundant ON CONFLICT clauses to prevent problems such as described in [forum:/forumpost/919c6579c8|forum post 919c6579c8]. check-in: d0ea6b6ba6 user: drh tags: trunk
13:49
Omit some extra tests for the intck extension in OMIT_VIRTUAL_TABLE or OMIT_PRAGMA builds. check-in: 29d9eb7d55 user: dan tags: trunk
11:13
Fix pragma6.test so that it works with ENABLE_OVERSIZE_CELL_CHECK builds. check-in: a02551de4c user: dan tags: trunk
11:08
Do not run tests for the intck extension in OMIT_VIRTUAL_TABLE or OMIT_PRAGMA builds. check-in: de8130c020 user: dan tags: trunk
03:24
Must use sqlite3IntFloatCompare() for accurate comparisons between very large integer and floating point values in RTREE. Otherwise the comparison does not work on all platforms. Further fix to [027e5336acc26f57]. check-in: 820f106acf user: drh tags: trunk
2024-03-07
19:29
Introducing JS worker1 promiser v2, which initializes via Promise (instead of a callback function) and can be loaded as an ESM module. check-in: 2fbaf2f51d user: stephan tags: trunk
18:53
Resolve duplicate loading of promiser v2 demo code (a side effect of having done precisely what it was told to do). Consolidate demo-worker1-promiser(-esm).html/(m)js variants into central copies processed with c-pp. Closed-Leaf check-in: 9347d9b9a6 user: stephan tags: wasm-promiser1-v2
17:56
wasm promiser.v2 is essentially working but the demo code is double-loading the module for as-yet-undetermined reasons. check-in: aa877ce0c3 user: stephan tags: wasm-promiser1-v2
16:04
Initial work at getting sqlite3Worker1Promiser.v2() to return a Promise instead of using an onready() callback, and also creating an ESM build for promiser1 per user request. It seems to work but requires more testing. check-in: 0e272123ac user: stephan tags: wasm-promiser1-v2
2024-03-06
12:28
Correction to the previous check-in. check-in: 483fa2969e user: drh tags: trunk
11:35
Fix handling of "id=?" corner cases in rtree when the value on the RHS is a real value. Problem reported by [forum:/forumpost/1bb055be17|forum post 1bb055be17]. check-in: 027e5336ac user: dan tags: trunk
2024-03-05
18:41
Remove code that added a P4 parameter to the OP_Variable opcode. This is no longer required. check-in: dd5977c9a8 user: dan tags: trunk
17:33
Reformulate [34439fe3aeea7cbb] slightly to resolve a false-positive OOM reported in [forum:2eadfe94e3|forum post 2eadfe94e3]. check-in: 8290646792 user: stephan tags: trunk
16:47
The value returned by the json_each.json field needs to survive longer than the json_each virtual table itself, in the event that the value is used in an aggregate expression. dbsqlfuzz 5120bd0b3bb0b73eebbcb79ac37c6b0663fccad6 check-in: 952ed71b9b user: drh tags: trunk
12:48
/fiddle: reorder/replace example entries to make them more coherent when tried in order and clear the example selection list when the input area is cleared, both based on forum feedback. check-in: b4ce270b3f user: stephan tags: trunk
08:48
/fiddle 'Mandlebrot' typo fix reported in the forum. check-in: ceefe6ba38 user: stephan tags: trunk
07:55
Update fiddle.make to account for Makefile changes in [178b7d46f9]. check-in: 7a5d810549 user: stephan tags: trunk
06:31
/fiddle: before resetting a db, roll back any transactions (resolves problem reported in [forum:0b41a25d65|forum post 0b41a25d65]) and remove an obsolete/broken reference to a long-gone API which could cause initialization to fail prematurely. check-in: ee164ca73c user: stephan tags: trunk
2024-03-04
18:22
Fix a compiler warning in date.c. Update makefiles to include all necessary dependencies for building shell.c. check-in: 178b7d46f9 user: drh tags: trunk
16:44
Change test results in corruptC.test to account for the added detail in the output of "PRAGMA integrity_check" from [b736519d3d2e93c7]. check-in: 0d19eeaafb user: drh tags: trunk
16:18
Fix harmless compiler warnings in the increment integrity_check extension. check-in: 596668e662 user: drh tags: trunk
13:58
Adjust date/time functions so that they do a better job of keeping track of whether the current time is UTC or localtime, and no-op the 'utc' and 'localtime' modifiers accordingly. See [forum:/info/e7a939e074|forum post e7a939e074]. Also add the datedebug() function, available only under -DSQLITE_DEBUG, for improved visibility of the DateTime object during debugging and testing. check-in: dc56968374 user: drh tags: trunk
11:12
Fix assert() statements in date/time computations: The month and day numbers can be zero if an error has been seen. check-in: fc773f6c76 user: drh tags: trunk
09:56
Document why the wasm build does not use Emscripten's -sSTRICT=1 flag and account for a behaviour change in emsdk 3.1.55 regarding the HEAPxyz symbols. check-in: f6e8872033 user: stephan tags: trunk
09:23
When warning about multiple invocations of JS's sqlite3ApiBootstrap(), use the warning logger installed by the first invocation, rather than console.warn. check-in: d162af2d99 user: stephan tags: trunk
06:54
After wasm bootstrapping has read the optional global-scope config objects, delete those objects because any further changes would not have any useful effect. Expand the docs regarding the sqlite3ApiBootstrap() config object and explain the necessary evil of a separate global-scope object for that configuration. check-in: e6b14f7313 user: stephan tags: trunk
2024-03-03
20:15
Back out the previous change. Replace it with new date modifiers "ceiling" and "floor". check-in: f0831cced2 user: drh tags: trunk
2024-03-02
21:02
New date/time modifiers "mnth" and "yr" work like "month" and "year" but resolve day-of-month overflow by truncating rather than rolling over into the next month. [forum:/forumpost/232d1abb5d|Forum thread 232d1abb5d] check-in: 5d392c16bb user: drh tags: trunk
2024-02-29
10:55
Fix two -Werror=lto-type-mismatch warnings reported in [forum:ef62b57bd5|forum post ef62b57bd5]. check-in: 803481f250 user: stephan tags: trunk
2024-02-28
15:32
Add in a VdbeCoverage() macro needed by STAT4 that should have been part of check-in [63ef234e88857a65]. check-in: d51c699ae4 user: drh tags: trunk
01:12
Always convert 32-bit integer literals into EP_IntValue notation, even if they contain "_" separators. check-in: 2dfc427f67 user: drh tags: trunk
2024-02-27
20:19
Fix an eputf() macro without its argument in the CLI. check-in: c2f5e257d2 user: drh tags: trunk
19:57
Add an assert() to help scan-build recognize that a variable is initialized. check-in: 10d26f1ee8 user: drh tags: trunk
16:36
Adjust a VdbeCoverage() macro in PRAGMA integrity_check to account for the fact that arguments to the OP_Eq opcode used are never NULL. check-in: 759ccea3f6 user: drh tags: trunk
15:33
Remove unreachable branches from the PRAGMA integrity_check enhancement of [b736519d3d2e93c7]. check-in: 6d02fb233f user: drh tags: trunk
14:31
Ensure memory cells are properly freed before they are overwritten by OP_IntegrityCk. check-in: e50acaf934 user: dan tags: trunk
11:03
Have "PRAGMA quick_check" compare the number of entries in tables and indexes. check-in: b736519d3d user: dan tags: trunk
11:02
Extend sqlite3.c makefile rule to support EXTRA_SRC=list-of-c-files to append to the generated sqlite3.c, as discussed in/around [forum:ccda88cf6f1754c5|forum post ccda88cf6f1754c5]. check-in: 61676f1e18 user: stephan tags: trunk
00:58
Bring the extra-src branch up to date with the trunk. Closed-Leaf check-in: 12ff5c5c41 user: stephan tags: extra-src
2023-10-24
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 [forum:/forumpost/63735293ec|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 [forum:/forumpost/63735293ec|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-09-25
00:39
Cause sqlite3_exper_new() to replicate UDFs and custom collations early enough to appear in virtual column expressions during schema copy. [forum:/forumpost/e030aa4b3a|forum post e030aa4b3a] check-in: 8fc2c45558 user: larrybr tags: expert-enhancement
2023-09-24
22:51
Make expert changes acceptable to C89. check-in: a4f03c22ec user: larrybr tags: expert-enhancement
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:00
Give expert ability to deal with custom collations. check-in: ac1dc1b6de user: larrybr tags: expert-udfs
2023-09-22
14:20
Give expert ability to deal with UDFs. check-in: 3406b05b4f user: larrybr tags: expert-udfs
2023-09-15
20:28
Simplifications and performance optimizations for the RTree extension. check-in: 04a333f5fa user: drh tags: trunk
2023-09-14
01:46
Reduce the number of calls to sqlite3_mprintf() made by RTree. Closed-Leaf check-in: f158b7d491 user: drh tags: rtree-performance
2023-09-13
17:30
Omit the Reinsert algorithm from RTree. This causes most benchmarks to run faster, at the expense of having a slightly less dense and hence larger index (example: 33 entries/node versus 34 entries/node). check-in: b3049a1d3d user: drh tags: rtree-performance
14:07
Performance optimization to cellContains() in RTREE. check-in: 43cde22bf3 user: drh tags: rtree-performance
13:12
In the ChooseLeaf algorithm of RTREE, do an initial pass through the cells of a node looking for solutions that involve no cell enlargement. Only look for the minimum cell enlargement if the enlargement is non-zero for all cells. This results in a performance improvement by reducing the number of calls to cellUnion(). check-in: 59f0e239d1 user: drh tags: rtree-performance
12:06
Reduce the number of calls to cellArea() in the ChooseLeaf() algorithm of rtree. check-in: c633fe6be0 user: drh tags: rtree-performance
11:36
Remove unused variable from the ChooseLeaf algorithm in r-tree. check-in: fb2e4a8067 user: drh tags: rtree-performance
11:24
Replace an if() condition in fts5 that is always true with an assert(). check-in: 2170312c8d user: dan tags: trunk
2023-09-12
23:21
CLI .import to accept EOF in lieu of record terminator on last field of CSV (with multiple field records), per RFC 4180. [forum:5b21c25bdfa|forum post 5b21c25bdfa] check-in: 6f7842f577 user: larrybr tags: trunk
18:36
Fix a use-after-free error in fts5 that could occur when querying the "rank" column immediately after another connection changes its definition. [forum:a2dd636330|forum post a2dd636330]. check-in: cb54c2da52 user: dan tags: trunk
17:49
Clarify some metrics output in Tester1.java. check-in: 4ae7199a82 user: stephan tags: trunk
17:06
Re-add the fts5 decls to sqlite3-jni.h, removed in a rebuild without fts5 enabled. Need a better solution for this problem. check-in: 6f269790a0 user: stephan tags: trunk
17:03
Rename JNI sqlite3_errmsg() to sqlite3_errmsg16() for overall constency with the text()/text16() family of functions. check-in: c4a8d8a571 user: stephan tags: trunk
16:33
JNI readme fix. check-in: 7dde000efc user: stephan tags: trunk
14:36
64-bit builds on Windows default to using UTF-8 output (as if the -utf8 command-line option had been specified.) 32-bit builds continue to use Windows code pages. There is also a new -no-utf8 command-line option to force the use of legacy code pages. check-in: d8c7560e88 user: drh tags: trunk
2023-09-11
15:27
Refuse to build amalgamation-tarball and snapshot-tarball if the TEA version number disagrees with ./VERSION. check-in: 3308fdda4b user: drh tags: trunk
15:20
Merge in JNI's significant divergence since it adopted sqlite3_client_data(). check-in: e8e07dbbea user: stephan tags: trunk
14:55
Add support for the sqlite3_get_clientdata() and sqlite3_set_clientdata() interfaces, to better support JNI. check-in: 9806c0dd28 user: drh tags: trunk
2023-09-09
17:53
Remove out-of-date comment regarding use of Parse.pConstExpr. check-in: 71548f72ad user: dan tags: trunk
2023-09-08
19:18
Add extra tests for [4b60a1c3]. check-in: 6357491bd1 user: dan tags: trunk
18:34
Fix a problem with fts5 secure-delete mode causing fts5 to corrupt its records. check-in: 4b60a1c358 user: dan tags: trunk
2023-09-07
17:54
Add -DSQLITE_OMIT_LOOKASIDE=1 to the "Sanitize" configuration in testrunner_data.tcl. check-in: a917ebf17b user: dan tags: trunk
16:53
Enhance the ./configure script and its associated Makefile.in so that the --with-linenoise=DIR argument cause the linenoise command-line editing library located in directory DIR to be linked with the sqlite3 CLI. check-in: 6c7822b554 user: drh tags: trunk
13:53
Fix a buffer overread in the sessions extension that could occur when processing a corrupt changeset. check-in: 0e4e7a05c4 user: dan tags: trunk
13:48
Fix a harmless compiler warning in the sqldiff.c utility. check-in: e6390a6567 user: drh tags: trunk
13:43
Add the "tool-zip" makefile target with the intention of using it to build the "sqlite-tool-*.zip" deliverables. deliverables. check-in: 06e4af492d user: drh tags: trunk
02:13
Fix a problem with the new xIntegrity method for virtual tables, and also fix a bad assert() in FTS3 that was found by the new xIntegrity method. check-in: 52bbf44f2d user: drh tags: trunk
2023-09-06
16:51
Add the xIntegrity method to the sqlite3_module object, thus enabling PRAGMA integrity_check to operate on virtual tables. Make use of this new method in the FTS3/4, FTS5, and RTREE virtual tables. check-in: 2f08e7d233 user: drh tags: trunk
2023-09-05
15:03
Fix a few SQLITE_MISUSE returns so that they call sqlite3MisuseError(). check-in: 93f74490fa user: drh tags: trunk
2023-09-04
16:48
Add tests for, and source code comments to, fts5. No changes to code. check-in: b12afff4ef user: dan tags: trunk
12:50
Do not make assumptions about the byteorder of PowerPC processors. check-in: 4a2498fed4 user: drh tags: trunk
2023-09-03
15:01
In mksqlite3c.tcl, pass EXTRA_SRC files through verbatim instead of applying the post-processing needed for sqlite's own source files. check-in: 44f3d7d054 user: stephan tags: extra-src
2023-09-02
21:55
Also add support for EXTRA_SRC in the Makefile for MSVC. check-in: bfc18ef432 user: mistachkin tags: extra-src
19:35
Performance optimization to the OP_MakeRecord opcode. check-in: 2aef9af3dd user: drh tags: trunk
05:37
Add EXTRA_SRC build var. If set, it is treated like a list of files, each of which gets appended verbatim to sqlite3.c. The intent is to enable easily extending the amalgamation. Requested in/around [forum:3fcc655f0ac0efe8|forum post 3fcc655f0ac0efe8]. check-in: 934b843398 user: stephan tags: extra-src
2023-09-01
11:10
Second half of [1c532e80]. check-in: 8ca1d815a5 user: stephan tags: trunk