bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Commit Graph

  • fb839cf1a1 Merge the sort-and-merge optimization bug fix from trunk. drh 2026-03-04 13:15:58 +00:00
  • 0f7f9ab007 Remove dead (commented-out) code that came to my attention because it ws nearby the fix of the previous check-in. drh 2026-03-04 13:08:14 +00:00
  • 76e562e222 Fix a code-generator bug introduced by the UNION/INTERSECT/EXISTS optimization of check-in [132ba781b031972c] and reported in [forum:/forumpost/2026-03-04T05:06:26Z|forum post 2026-03-04T05:06:26Z]. drh 2026-03-04 13:02:08 +00:00
  • 96daad10fa Consolidate much of the OPFS utility code into a new file for use by two of the OPFS VFSes. stephan 2026-03-04 11:37:39 +00:00
  • 92b9d4f870 Merge latest trunk changes into this branch. dan 2026-03-04 11:08:10 +00:00
  • 6d6bf30735 A potential fix for the probable breakage of bundler-friendly builds in the previous check-in. Pending review from someone who uses those tools. stephan 2026-03-04 00:48:03 +00:00
  • 9ac95d9ce1 opfs-wl is now loading and registering but it's still untested. stephan 2026-03-04 00:37:55 +00:00
  • a2d3a54f80 An initial attempt to plugging opfs-wl into the build but its initial handshake with the async half collides with the opfs VFS's handshake, causing bootstrapping to fail miserably. We'll need to either devise a handshake which can differentiate between the two instances or we'll need to preprocess sqlite3-opfs-async-proxy into two copies. Move the (now) three copies of some common code shared by the opfs pieces into a preprocessor #include. stephan 2026-03-03 23:43:40 +00:00
  • 5281d98a2a Merge the latest trunk enhancements into the begin-concurrent branch. drh 2026-03-03 23:01:51 +00:00
  • 0b7b802d83 Add a missing reset of the lock handshake SharedArrayBuffer slot. stephan 2026-03-03 21:46:44 +00:00
  • e2309eebd7 Implementations of WebLock-based opfs::xLock() and xUnlock(). Still completely untested and not yet integrated into the build. stephan 2026-03-03 21:07:46 +00:00
  • 72a14a575e Avoid an obscure race condition between a checkpointer and a writer wrapping around to the start of the wal file. dan 2026-03-03 19:43:19 +00:00
  • d016fad5a8 Merge trunk into the opfs-wl branch. stephan 2026-03-03 18:34:59 +00:00
  • 8ba2a38363 Do not run test script walrestart.test with the "memsubsys1" permutation. wal-restart-fix dan 2026-03-03 18:34:38 +00:00
  • bb80d688ac Minor tweaks to the previous, for testability. drh 2026-03-03 18:21:22 +00:00
  • fe57e14b49 Avoid an obscure race condition between a checkpointer and a writer wrapping around to the start of the wal file. dan 2026-03-03 17:34:01 +00:00
  • 0ba562936d Improvements to the SQLITE_FCNTL_IS_UNLINKED mechanism so that it works for SHM files. wal-unlink-detection drh 2026-03-03 16:01:26 +00:00
  • d3811ff1de Check the WAL and SHM files at the start of each write transaction or checkpoint and fail with SQLITE_READONLY if they have become unlinked. drh 2026-03-03 14:26:54 +00:00
  • 5c4692b6a9 Add JS tests for sqlite3_bind_zeroblob(). wasm-zeroblob stephan 2026-03-03 14:13:34 +00:00
  • a2fef84b19 Expose sqlite3_bind_zeroblob() to JS/WASM, per request in [forum:e7acf225f9|forum post e7acf225f9]. This is currently missing tests and is not planned for merge until the 3.53 dev cycle starts. stephan 2026-03-03 01:48:18 +00:00
  • 18f99f43bc Convert many sqlite3_realloc() calls to sqlite3_realloc64(). drh 2026-03-02 17:11:44 +00:00
  • f6c8adf3a2 Omit explain_i calls from TCL test scripts. drh 2026-03-02 16:40:16 +00:00
  • 72afb50a6d Fix TEMP INSTEAD OF triggers so that they work on TEMP views. [forum:/forumpost/2026-02-28T23:33:04z|Forum post 2026-02-28T23:33:04z]. drh 2026-03-02 15:34:16 +00:00
  • 7fa89ea907 Change some sqlite3_realloc() calls into sqlite3_realloc64(). realloc64 drh 2026-03-02 15:06:59 +00:00
  • c1454ee833 Remove the experimental and incomplete ext/repair extension, to prevent AIs from scanning the (incomplete) code and reporting bugs against it. drh 2026-03-02 13:44:04 +00:00
  • ea6b2a87d1 Disable test shell1-5.0 as it is causing a use of initialized deep inside of TCL. drh 2026-03-02 13:43:08 +00:00
  • f270460366 Use only 64-bit memory allocation in FTS5. Fix for UAF reported by Zijie Zhao. drh 2026-03-02 11:41:48 +00:00
  • 33478099c9 Fix a possible 9-byte buffer overread in the zipfile extension hit when processing a corrupt zip file. Forum post [forum:/forumpost/721a05d2c5 | 721a05d2c5]. dan 2026-03-02 11:22:28 +00:00
  • 93ad2e083e The intck01.sql test should only be run if virtual tables work. drh 2026-03-02 00:06:02 +00:00
  • ffaf9110f6 More floating point conversion test cases. drh 2026-03-01 23:23:52 +00:00
  • 7e4e866baf New floating-point test case. drh 2026-03-01 23:01:17 +00:00
  • e293b2d835 Fix an OOB read in the incremental integrity-check extension. drh 2026-03-01 22:36:02 +00:00
  • 83de60bd7b Simplified rounding logic in sqlite3Fp10Convert2(). drh 2026-03-01 20:22:08 +00:00
  • a000db9754 Code changes in sqlite3Fp10Convert2() for easier maintenance. Does not affect the generated machine code. drh 2026-02-28 20:22:10 +00:00
  • 7ac310d0c6 Improvements to power-of-ten computations used for text ↔ binary64 conversions. drh 2026-02-27 22:59:46 +00:00
  • afaf7ea2e4 Minor simplification to the text→binary64 conversion algorithm. drh 2026-02-27 20:37:03 +00:00
  • f707e2ec5d Two code comment typo fixes reported in the forum. No code changes. stephan 2026-02-27 18:32:12 +00:00
  • 7d9fbe6476 Fix an off-by-one error in the indentation of multi-line outputs in QRF_STYLE_Line mode. drh 2026-02-27 13:25:42 +00:00
  • c67a538168 Add an assert() to sqlite3RegisterLikeFunctions() to hopefully prevent future false-positive bug reports coming out of CodeQL. drh 2026-02-27 11:36:43 +00:00
  • 57d7a20ce7 Another nano-optimization in kvvfs v2. stephan 2026-02-27 06:33:28 +00:00
  • d22d0edc48 JS: slight performance improvements in KVVfsStorage. stephan 2026-02-27 03:21:47 +00:00
  • 8c6bf948b7 An initial copy/paste stub for experimenting with using WebLocks for a new copy of the OPFS vfs. This is not yet functional, or even loading, but needs stashing to avoid potential loss. stephan 2026-02-27 03:11:40 +00:00
  • 5dfccfb0bb Fix typos in the SQLITE_PREPARE_FROM_DDL documentation. drh 2026-02-26 16:19:21 +00:00
  • 5a6eef2fb2 Improvements to the SQLITE_PREPARE_FROM_DDL documentation. drh 2026-02-26 13:35:38 +00:00
  • 8bc78bebfb Fix an inconsequential typo in the output of the datedebug() SQL function. drh 2026-02-26 12:17:19 +00:00
  • a86c6017e7 Fix a problem where the wrong collation could be used as part of a row-value comparison between columns with different collation sequences. [forum:/forumpost/6ceca07fc3 | Forum post 6ceca07fc3]. dan 2026-02-26 11:03:22 +00:00
  • 1a152ea92a The GCC bug is fixed in GCC-15. drh 2026-02-25 21:19:20 +00:00
  • f45c695471 Reinstant the work-around for [https://gcc.gnu.org/bugzilla/show_bug.cgi?id=96270|GCC compiler bug 96270] which is apparently still an issue as of gcc 13.3.0 with -m32 on Mint Linux. The test case in the bug report is fixed, but the vdbeMemRenderNum() routine in SQLite still shows the problem. drh 2026-02-25 12:44:19 +00:00
  • 46bf39e396 Use a 64-bit hash for the testing option SQLITE_CHECK_PAGES to maintain page alignment. drh 2026-02-25 01:04:22 +00:00
  • b1a73ba34d Adjust the changes to shell8.test from [5da9bf09cc00faf9] so that they work with older versions of TCL. drh 2026-02-24 19:50:27 +00:00
  • 9d65290207 Rename SQLITE_ENABLE_MULTITHREADED_CHECKS to SQLITE_THREAD_MISUSE_WARNINGS. Run test cases with that option. Also add the SQLITE_THREAD_MISUSE_ABORT option. drh 2026-02-24 19:37:16 +00:00
  • da67225f04 Fix an assert() that is incorrect when the SQLITE_DBCONFIG_FP_DIGITS setting is on a non-default value. drh 2026-02-23 19:51:54 +00:00
  • d2e27e5d54 Add test cases for the symlink defenses of the previous check-in. drh 2026-02-23 13:29:29 +00:00
  • ffd9892a02 Change the SQLAR archive extraction algorithm in the CLI so that it uses the newly enhanced realpath() SQL function to guard against attacks that use symlinks to try to write files outside of the destination directory. [forum:/forumpost/641b09daa17d9086|Forum post 641b09daa17d9086]. drh 2026-02-23 12:19:05 +00:00
  • 9235f9b049 Enhance the realpath() SQL function in the fileio.c extension so that it works ever for pathnames that do not exist. drh 2026-02-23 11:44:30 +00:00
  • 7ef794170f Add further tests for the BEGIN CONCURRENT extension on this branch. bedrock-lcd-ex dan 2026-02-23 11:42:16 +00:00
  • 9dac613f04 When doing an SQLAR archive extraction in the CLI, postpone creating symlinks until after all files and directories have been created. This prevents a hostile archive from creating a symlink through which it can subsequently write content outside of the target directory. [forum:forumpost/9e176adfef91c207|Forum post 9e176adfef91c207]. drh 2026-02-23 01:34:14 +00:00
  • 95fe5b9c38 Improved implementation of realpath() in the fileio.c extension that does not require the last element of the path to actually exist. drh 2026-02-23 00:57:00 +00:00
  • 9bc017423c Add the realpath() SQL function to the fileio.c extension. And clean up the UTF8 handling on the Windows side of that extension while we are at it. drh 2026-02-22 20:44:52 +00:00
  • 60f132bf12 Fix typos and include wording in the documentation for SQLITE_DBCONFIG_FP_DIGITS. drh 2026-02-21 21:19:41 +00:00
  • f8681fb638 Fix a harmless warning in the decimal extension. drh 2026-02-21 20:20:06 +00:00
  • 283f33233b Improved rounding of double→text conversions for rounding digits of 17. Add the new sqlite3_db_config(), SQLITE_DBCONFIG_FP_DIGITS, to specify the number of significant digits to preserve on conversions. drh 2026-02-21 20:03:47 +00:00
  • 8642ca2025 New sqlite3_db_config(SQLITE_DBCONFIG_FP_DIGITS) that let's the application specify the number of significant digits that double→text conversions will attempt to preserve. fp-performance-v2 drh 2026-02-21 19:26:58 +00:00
  • 699959ff25 New test cases for floating-point conversions. drh 2026-02-21 13:57:40 +00:00
  • 7aba858597 Remove an unreachable branch. drh 2026-02-21 13:40:07 +00:00
  • 4428aa842c Increase the precision of double → text conversions that happen in sqlite3_column_text(), or sqlite3_value_text(), or in the CAST() operator, or similar, so that round-tripping the value back to double results in exactly the same value. drh 2026-02-21 10:57:02 +00:00
  • 24ef9fbb19 Further simplification, performance gain, and size reduction in sqlite3FpDecode(). drh 2026-02-21 00:56:11 +00:00
  • aec283385e Small performance increase and size reduction in sqlite3FpDecode() by using local variables instead of structure elements. drh 2026-02-21 00:20:29 +00:00
  • ac5ee556eb Inconsequential changes to floating-point conversion, amounting to mere code cleanup to aid comprehension. drh 2026-02-20 20:43:25 +00:00
  • ea504caad1 Fix OMIT_CONCURRENT builds on this branch. dan 2026-02-20 18:27:02 +00:00
  • eb27374ff1 Further tests for the new code in btree.c on this branch. dan 2026-02-20 16:58:45 +00:00
  • 62546d4b1f In the decimal extension, an optional second argument to the decimal() and decimal_exp() functions rounds the value to the number of significant digits specified by that argument. drh 2026-02-20 16:21:58 +00:00
  • 9e395efec6 Fix a cse in the fiddle.debug build where it could not overwrite its read-only/generated index.html. stephan 2026-02-20 14:22:09 +00:00
  • d447df4205 Add new functions ieee754_to_int() and ieee754_from_int() to the ieee754 extension. No changes to the core SQLite. drh 2026-02-20 14:20:33 +00:00
  • 20c65785cd Improved rounding of floating-point conversions in some corner cases. drh 2026-02-20 12:27:52 +00:00
  • 46c7cccde8 Improve handling of logical conflict detection for exact lookups on indexes. dan 2026-02-20 11:45:30 +00:00
  • f47ec658ff Fix problems with logical conflict detection and zeroblob(). dan 2026-02-19 18:48:40 +00:00
  • 918a7c61d9 Add tests and fixes for the new code on this branch. Add the sqlite_concurrent eponymous virtual table to begin_concurrent_lcd.md. dan 2026-02-19 17:48:41 +00:00
  • e8750019c2 In the CLI, the ".quit" command in a --cmd argument causes an immediate exit. [forum:/forumpost/f057122b68|Forum post f057122b68]. drh 2026-02-19 17:20:40 +00:00
  • cac09127e1 Improvements to rounding behavior in the new floating-point conversion logic. drh 2026-02-19 12:59:42 +00:00
  • 2b732359bf Add doc/begin_concurrent_lcd.md to document the change on this branch. dan 2026-02-19 11:41:40 +00:00
  • 22e3847f04 Ensure incremental blob reads and writes are handled correctly by this branch. dan 2026-02-18 18:12:36 +00:00
  • 2c33626cd1 Fix problem with retrying UPDATEs on WITHOUT ROWID tables. dan 2026-02-18 17:19:52 +00:00
  • ce92c81231 Merge latest changes from branch "bedrock". dan 2026-02-18 14:14:56 +00:00
  • a9540e9880 Add SQLITE_CONFIG_SHAREDLOG_MAXSIZE, for configuring the maximum size of a single BEGIN CONCURRENT shared-log in bytes. Or for disabling it entirely by setting max-size to 0. dan 2026-02-18 14:10:20 +00:00
  • e62fd42bba Merge latest changes from wal2 into this branch. dan 2026-02-18 13:57:52 +00:00
  • 37ee141d25 Restore the CLI function dtostr() back to its original purpose of converting floating point values to decimal using the host computer's C-library. drh 2026-02-17 20:28:25 +00:00
  • c4edb9f95c Add test cases and fixes for the change on this branch. dan 2026-02-17 19:45:34 +00:00
  • f69b39aac2 Rename bcrecord.c to btrecord.c. dan 2026-02-17 17:40:46 +00:00
  • 780913a0b1 When a logical commit fails, issue an informative message to sqlite3_log(). dan 2026-02-17 17:05:52 +00:00
  • 445cd7c7b9 Merge the latest trunk enhancements into the reuse-schema branch. drh 2026-02-17 16:33:41 +00:00
  • e8c2de0e0f Merge the latest trunk enhancements into the wal2 branch. drh 2026-02-17 16:18:59 +00:00
  • 9331d99ca6 Merge the latest trunk enhancements into the begin-concurrent branch. drh 2026-02-17 16:16:27 +00:00
  • aa3c87b4c6 Tests and fixes for recording the reads made by BEGIN CONCURRENT transactions. dan 2026-02-17 15:40:57 +00:00
  • 7549e784a8 Minor fixes to tmstmpvfs.c. drh 2026-02-17 14:28:18 +00:00
  • 8c3e8dce41 Increase the number of floating-point precision test cases by 9x, and increase the require precision to 16 digits. drh 2026-02-17 14:02:27 +00:00
  • 31d4e56b29 Fix a harmless compiler warning from MSVC. drh 2026-02-17 12:23:12 +00:00
  • 530f536ce7 New assert()s for the return value from sqlite3SchemaToIndex(). drh 2026-02-17 11:28:48 +00:00
  • eb8c4c5742 Further simplifications, performance improvements, and size reductions to the numeric to text conversion logic. drh 2026-02-17 01:04:23 +00:00
  • 0b5e944480 Faster conversion of integers to text, by converting two digits at a time. numeric-conversion drh 2026-02-17 00:37:12 +00:00