Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
182 check-ins going from 8a6196ab29052071 to 184a0cd2e855c517
|
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-11-20
| ||
| 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-13
| ||
| 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-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: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 | |
|
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 [forum:/forumpost/fa0e00d36db5fe0a|noted in a forum post]. check-in: a4c7954b93 user: larrybr tags: trunk | |
| 23:04 | Remedy CLI non-UTF8 handling detection flaw [forum:/forumpost/fa0e00d36db5fe0a|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:75524f7342c1ba45|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:/forumpost/ffcbf789b5386573|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:/forumpost/965c0d02ea|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:/forumpost/c11523ca2df50293|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 [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-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-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: 2837061d66 user: drh tags: db-client-data | |
|
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 | |
| 08:04 | Optimize sqlite3_get/set_clientdata() for the presumably common case of a static string pointer. check-in: 84e38341ae user: stephan tags: db-client-data | |
| 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 | |
| 11:05 | In the OPFS VFS' importDb() methods, overwrite the header bytes 18 and 19 with 1 instead of 0. Both seem to work, but 1 is correct. check-in: 1c532e807b user: stephan tags: trunk | |
|
2023-08-31
| ||
| 18:00 | Do not disable unused columns in a UNION ALL sub-query if any component of the sub-query is DISTINCT. Problem introduced by [7c2d3406000dc8ac] and reported by [forum:/forumpost/aeae62275ebbf584|forum post aeae62275ebbf584]. check-in: c84d5602ac user: dan tags: trunk | |
|
2023-08-30
| ||
| 18:51 | Use mutexes to make sqlite3_set_clientdata() and sqlite3_get_clientdata() threadsafe. check-in: 443ea20ddb user: drh tags: db-client-data | |
| 18:45 | Replace JNI's per-db-instance state tracking with the new sqlite3_set/get_clientdata(). check-in: e7c11d34ee user: stephan tags: db-client-data | |
| 18:19 | Fix a bug in json_array_length() introduced in version 3.43.0 by check-in [df099ad713011b67]. If the JSON input comes from json_remove(), the removed array entries are still counted as part of the array length. Bug report in [forum:/forumpost/0560d5e482|forum post 0560d5e482]. check-in: 69a635958a user: drh tags: trunk | |
| 17:41 | Remove another unreachable branch in the sqlite3_set_clientdata() logic. check-in: 57e31e6b10 user: drh tags: db-client-data | |
| 17:14 | Remove an unreachable branch, and improve documentation of sqlite3_set_clientdata(). check-in: 565c68adee user: drh tags: db-client-data | |
| 16:03 | Fix the AVG() and TOTAL() functions (after the SUM() fix of [77d3dcd283595c52]) so that they work with infinitites. Fixes a bug introduced by check-in. [c63e26e705f5e967]. Bug reported by [forum:/forumpost/8960fb40cc|forum post 8960fb40cc]. check-in: 6df6f17ccb user: drh tags: trunk | |
| 15:51 | Further tweaking in both SQLTesters. check-in: 46b0eb98e7 user: stephan tags: trunk | |
| 15:42 | Fix to the sqlite3_get_clientdata() interface. check-in: 937cd1762b user: drh tags: db-client-data | |
| 15:20 | New experimental API for attaching client data to a database connection. check-in: d542837fdb user: drh tags: db-client-data | |
| 14:20 | When a JS SQLTester script throws, report the exception details back to the UI regardless of whether it's fatal. check-in: 273d3b05f6 user: stephan tags: trunk | |