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

Commit Graph

  • bc5e0be7f8 A experiment addressing the embedded-NUL behavior of sqlite3_colum/value_text() in the JS bindings, as discussed in [forum:d77281aec2df9ada|forum post d77281aec2]. This is an experiment only. It works, in that existing tests do not see the difference, but it has implicications which require careful consideration before deploying. stephan 2025-10-30 02:21:38 +00:00
  • 7c86a0321e Remove an OMIT_WAL from the wasm build because it breaks with the current amalgamation (and isn't strictly needed here anyway). stephan 2025-10-30 01:43:30 +00:00
  • 11b6fc93f6 Experimental change to allow triggers in the temp schema to use fully qualified table names in INSERT/UPDATE/DELETE statements. dan 2025-10-29 20:57:44 +00:00
  • d443f0a95f Fix a logic error introduced by [cea8bf79e18d55a8] which caused "0 OR 2" to be evaluated as "2" instead of as "1". Problem reported at [forum:/forumpost/d5f32040c5d50d2d|forum post d5f32040c]. drh 2025-10-29 20:47:01 +00:00
  • 0fe7b968dd Send an sqlite3_log() message if the unix backend takes a short read. log-short-read drh 2025-10-29 13:59:25 +00:00
  • 03e6242802 Striving for better names for fields in the spec structure. drh 2025-10-29 13:03:35 +00:00
  • 630b111cd3 Documentation tweaks. Change the name of the eQuote setting to eText for consistency. drh 2025-10-29 11:19:04 +00:00
  • a73fb2b233 Add support for the bTxtJsonb flag in sqlite3_qrf_spec, which if true causes JSONB blobs to be displayed as JSON text. drh 2025-10-28 22:25:24 +00:00
  • 34b1bf16ec Tiny cosmetic tweak to configure script output. No functional changes. stephan 2025-10-28 22:09:43 +00:00
  • 74cd3c53f9 Typo fixes in LICENSE.md from BrickViking. stephan 2025-10-28 19:57:15 +00:00
  • ccae8e0c47 Fix a harmless compiler warning. drh 2025-10-28 19:37:18 +00:00
  • 74e5918178 Merge the latest trunk enhancements into the qrf branch. drh 2025-10-28 19:35:26 +00:00
  • 7c9ae4e5c8 Merge the latest trunk enhancements into the reuse-schema branch drh 2025-10-28 15:33:46 +00:00
  • 69982ae430 Merge the latest trunk enhancements into the bedrock branch. drh 2025-10-28 15:03:38 +00:00
  • bc410e8769 Merge the latest trunk enhancements into the wal2 branch. drh 2025-10-28 14:58:14 +00:00
  • 9d0754ea35 Merge all the latest trunk enhancements into the begin-concurrent branch. drh 2025-10-28 14:52:34 +00:00
  • ffbfc27fab Fix an signed integer overflow problem that can occur when using an oversize value for the SQLITE_MAX_LENGTH compile-time option together with multi-gigabyte operands to the OP_Concat operator. drh 2025-10-28 13:24:50 +00:00
  • 5a9ada593f Add enhanced resistance to corruption after posix advisory locks on the database file been unintentionally broken on unix by running close(open(DBFILE)) from a separate thread. drh 2025-10-28 10:50:55 +00:00
  • 9c0770537f Enhance the CLI so that it can handle inputs larger than 2 billion lines. drh 2025-10-28 10:44:26 +00:00
  • 6cc222c3be Additional comments explaining what unixIsSharingShmNode() does. No changes to code. broken-lock-defense-1 drh 2025-10-28 01:28:20 +00:00
  • db0d47b749 Omit unnecessary branches from the unixIsSharingShmNode() implementation. drh 2025-10-27 23:57:57 +00:00
  • e34f35c833 The unixIsSharingShmNode() function should always return false for the unix-excl VFS. drh 2025-10-27 15:44:16 +00:00
  • 626351d444 Implement an experimental defensive measure to try to prevent the -wal and -shm files of an active WAL-mode database connection from being deleted out from under the database connection in the case where the database SHARED lock has been released by an accidental call to close() in a different thread, or similar. drh 2025-10-27 14:24:02 +00:00
  • 4db3453794 Merge the latest trunk enhancements into the reuse-schema branch. drh 2025-10-27 12:20:22 +00:00
  • a4124d4256 Merge the latest trunk enhancements up into the bedrock branch drh 2025-10-27 12:01:56 +00:00
  • 3c0047482d Merge all the latest trunk enhancements into the wal2 branch. drh 2025-10-27 11:49:07 +00:00
  • 6e27846323 Fix a minor over-allocation of heap memory in wal.c. dan 2025-10-27 11:39:07 +00:00
  • 41446046ab Merge all the latest trunk enhancements into the begin-concurrent branch. drh 2025-10-27 11:31:39 +00:00
  • 8ce786f173 Fix sanitizer complaints in the regexp extension. dan 2025-10-27 11:20:47 +00:00
  • 6b9230d2a1 Merge the OPFS/SEE tests into trunk (where they should have been committed). stephan 2025-10-26 21:58:41 +00:00
  • 241004f8fc Demonstrate the opfs-sahpool VFS with SEE. stephan 2025-10-26 21:45:02 +00:00
  • 89a9efe840 Add a test which uses SEE via the "opfs" VFS. "opfs-sahpool" is pending. stephan 2025-10-26 21:30:29 +00:00
  • 4f177f1d3e Merge trunk into the wasm-post-3.51 branch. stephan 2025-10-26 18:43:04 +00:00
  • d4ead9b9e4 A better/cleaner fix for [1c80ff88c0ce]. stephan 2025-10-26 18:36:57 +00:00
  • f57d368078 c-pp-lite: Fix another newline-related off-by-one which could cause newlines to get lost in @token@ filtering. Problem found in out-of-tree testing. stephan 2025-10-26 17:59:30 +00:00
  • 3fceae3b95 Doc typo fix reported in the forum. No code changes. stephan 2025-10-26 12:34:13 +00:00
  • 38113d392d Add the SQLITE_FCNTL_FILESTAT file control and the sqlite_filestat() SQL function. drh 2025-10-25 22:22:58 +00:00
  • a105989856 Rename the file control to SQLITE_FCNTL_FILESTAT. Rename the SQL function to sqlite_filestat(). Rename the enable macro to SQLITE_ENABLE_FILESTAT. file-info drh 2025-10-25 20:46:09 +00:00
  • ecbeefecd0 Fix a bug in sqlite_file_info() output: It was showing the "pal" for the main file descriptor when traversing other unused file descriptors for the same inode. drh 2025-10-25 19:51:16 +00:00
  • 2b24d8957e New --normal option for the ".open" command in the CLI. Also, when opening the database for deduceDatabaseType(), use the same open-flags that will be used subsequently for the official open, to avoid creating unusable file descriptors that need to be held until all database instances close. drh 2025-10-25 19:36:12 +00:00
  • 726e836108 Add additional information about unix file descriptors to the same database file in the sqlite_file_info() output. drh 2025-10-25 19:26:16 +00:00
  • 7be565f0cc Adjust unixPosixAdvisorLocks() to use redirectable system calls so that it can be tested. drh 2025-10-25 18:40:18 +00:00
  • c053b57716 Merge the CLI deduceDatabaseType fix from trunk. drh 2025-10-25 18:36:14 +00:00
  • 0d859b4828 Fix the CLI so that it does not try to open what might be an SQLite database using open() in the deduceDatabaseType() routine, as this can lead to broken posix advisory locks. drh 2025-10-25 18:35:29 +00:00
  • ab29c24dc3 Additional information about the unixShm shown. drh 2025-10-25 14:06:36 +00:00
  • dcc07d3ca6 Do not attempt to show posix-advisory-locking status on journal files. drh 2025-10-25 13:55:49 +00:00
  • 234c6c4bf0 The sqlite_file_info() function should always return JSON, unless there is an OOM. drh 2025-10-25 13:16:41 +00:00
  • 86319b841a New symbolic representation of posix advisory locking information drh 2025-10-25 12:53:03 +00:00
  • f4e66056ac Merge trunk enhancements into the file-info branch. drh 2025-10-25 11:47:04 +00:00
  • 76db3a6e66 Stricter assert() statements on unixShmSystemLock(). drh 2025-10-25 11:37:54 +00:00
  • 003737d1dc Improvements to the design of the /proc lock analysis. drh 2025-10-24 23:12:33 +00:00
  • 02c5f3976f Random tiny tweaks in internal JS and flesh out the tester1 test selection list to include both 32-/64-bit entries for all tester1XYZ.html combinations. For after the 3.51 release. stephan 2025-10-24 21:01:23 +00:00
  • be4d0c2e2f Make it particularly clear in the wasm build output that unsupported builds are exactly that. Cosmetic tweak only, no functional changes. stephan 2025-10-24 20:29:12 +00:00
  • aeb886bc53 Easier to read /proc lock interpretation. drh 2025-10-24 20:26:13 +00:00
  • 2f9311c5cb Flesh out the sqlite_file_info() function further, and in particular show locks based in /proc/PID/fdinfo/FD, when that information is available. drh 2025-10-24 20:04:16 +00:00
  • 093b26e8e0 New diagnostic SQL function "sqlite_file_info()" and its associated file-control SQLITE_FCNTL_GET_INFO. drh 2025-10-24 17:42:03 +00:00
  • 63ee854264 Fix a duplicate SQLITE_API on sqlite3_carray_bind(), as reported in [forum:7499e8a19edc8908|forum post 7499e8a19e]. stephan 2025-10-24 17:16:00 +00:00
  • 3ba506d9cc ext/wasm: dependencies fix for parallel builds attempted immediately after a distclean. Add version-info to the distclean rules. stephan 2025-10-24 16:39:58 +00:00
  • 67fa337744 ext/wasm/GNUmakefile: (A) When using a custom sqlite3.c, use sqlite3.h from the same directory instead of the top of this tree. (B) Re-add preprocessor flags for SEE which were misplaced during recent build refactoring. stephan 2025-10-24 16:25:23 +00:00
  • 033dbac510 Fix [4e713558f6c6ea3d] so that it supports separate builds of rtree. drh 2025-10-24 16:01:55 +00:00
  • 9af334f54a Document minor discrepancies in how sqlite3_bind_pointer() and sqlite3_carray_bind() react to the SQLITE_TRANSIENT and SQLITE_STATIC finalizers. stephan 2025-10-24 15:18:13 +00:00
  • 4bb53ab2e4 Make explicit that sqlite3_bind_pointer() and sqlite3_carray_bind() call the provided destructor even if those routines fail, per [forum:6d81b10952|forum feedback]. stephan 2025-10-24 14:30:42 +00:00
  • 7adc9a5978 Update the MSVC makefile for the amalgamation distribution. drh 2025-10-24 13:23:43 +00:00
  • acdda1075d Enhance the tokenizer so that it is able to deal with individual tokens larger than 2GiB. drh 2025-10-24 13:18:31 +00:00
  • bc2691d5c1 In the CLI, improved error messages on input errors. Limit the size of a single SQL statement to a little more than 2GB. drh 2025-10-24 12:32:32 +00:00
  • 95c188d557 Limit the size of --hexdb files in the CLI to 2 billion lines, to avoid overflowing the line number counter. drh 2025-10-24 09:24:56 +00:00
  • c64739e017 Change the documentation name to README.md so that it displays automatically when browsing the source directory. drh 2025-10-23 23:07:02 +00:00
  • a75737f931 Bring the documentation into sync with the current implementation. drh 2025-10-23 23:03:14 +00:00
  • c873460fd1 Add support for QUOTE and EXPLAIN modes. drh 2025-10-23 20:13:57 +00:00
  • 52d1e3aef3 Add support for EQP mode. drh 2025-10-23 18:57:15 +00:00
  • cc1a3d3d85 Add CSV mode. drh 2025-10-23 17:09:03 +00:00
  • 09efb92900 Implement LINE mode. drh 2025-10-23 16:57:57 +00:00
  • b3a3a4c006 Add HTML and INSERT modes. drh 2025-10-23 16:40:29 +00:00
  • fa56585242 Implement JSON mode. drh 2025-10-23 16:22:01 +00:00
  • 4043096408 Additional defenses against over-sized inputs in the (unused) amatch.c demonstration code. drh 2025-10-23 14:05:58 +00:00
  • d06a0be514 Fix a faulty error message in the ext/misc/fileio.c extension. drh 2025-10-23 13:10:34 +00:00
  • a678784c4c Assigned widths and alignments on columns. drh 2025-10-22 21:24:17 +00:00
  • e40b5d9867 Column modes are now working. drh 2025-10-22 21:00:52 +00:00
  • f32be465e8 Code in place to do column formats. Compiles, but does not work. This is an incremental check-in. drh 2025-10-22 18:09:54 +00:00
  • 3c11df7e92 Merge va_list misuse fix. drh 2025-10-22 12:59:34 +00:00
  • 21769e1d85 Fix a va_list misuse. resfmt stephan 2025-10-22 12:38:39 +00:00
  • 41b5ded8d0 Refactor: Name change to "query result formatter" or "QRF". Simplify names. put all the code into its own subdirectory of ext/ drh 2025-10-22 12:33:59 +00:00
  • 22f8a84fda Simplify the interface to use just a single API. drh 2025-10-22 12:09:50 +00:00
  • 984e446891 Adjust some of the markdown in the LICENSE.md file so that it will hopefully work better on GitHub. drh 2025-10-22 00:38:28 +00:00
  • ce3d809d62 Simplify the set of formatting choices. drh 2025-10-21 20:10:44 +00:00
  • dcd722d204 Add TCL and JSON output formatting. Add the ability to test the xRender. drh 2025-10-21 19:56:13 +00:00
  • 15a064807f Text quoting formats CSV and HTML. drh 2025-10-21 19:03:27 +00:00
  • 774ce0ba43 Back out [b144f875d6bddce6] and remove the former check for strchrnul() from the configure script. stephan 2025-10-21 16:15:53 +00:00
  • f4720e195e Back out [b144f875d6bddce6] and remove strchrnul() from printf.c because it's not as portable as we'd hoped. mistake stephan 2025-10-21 16:10:09 +00:00
  • 8e544ca512 Add separate quoting style for BLOB values. drh 2025-10-21 15:30:38 +00:00
  • 8c8bd1969c Control-character escaping drh 2025-10-21 13:07:51 +00:00
  • 861cb4c0b4 Recognize the various quoting styles and escape modes in the resfmt-test program. drh 2025-10-21 11:00:04 +00:00
  • 6e334ef616 More capabilities being added. Incremental check-in. drh 2025-10-20 19:55:26 +00:00
  • a1f32824e2 Add test program for resfmt.c. Now compiles and runs. drh 2025-10-20 17:19:30 +00:00
  • 5b5b35f6d6 Notes on the result-formatter utility. None of the code works. These are just ideas I have jotted down as I try to figure out how to do this. drh 2025-10-20 14:28:57 +00:00
  • a0b13abd34 Merge recent trunk enhancements into the resfmt branch. drh 2025-10-20 10:55:01 +00:00
  • d41f5ef7e6 Reduce the maximum size of LIKE and GLOB patterns in the ossfuzz.c test module to avoid false-positive infinite loop reports from OSS-Fuzz based on long and complex fuzzer-generated LIKE/GLOB patterns that are not actually infinite loops, but which do take a long time to resolve. drh 2025-10-19 17:30:07 +00:00
  • efe8ae567c Use 64-bit memory allocations everywhere in the expert extension. drh 2025-10-18 11:19:02 +00:00
  • 21c57abc53 Increase the range of integer indexes in the the merge() family of SQL functions. drh 2025-10-18 11:04:03 +00:00
  • 31c86ca0a8 Fix a minor memory leak in the CLI that can occur following an error in the ".output" dot-command. drh 2025-10-17 10:06:44 +00:00