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

Commit Graph

  • 96be4a368b The sqlite3_error_schema() interface now works for errors discovered during OP_Transaction. drh 2025-08-04 13:55:58 +00:00
  • 8725bf916d Fix harmless compiler warnings arising from [1cccea0508f5c8b8]. drh 2025-08-04 11:50:41 +00:00
  • fe263ce3a6 Prototype of the sqlite3_error_schema() interface. Non-functional. drh 2025-08-04 11:40:31 +00:00
  • 1f4c281b0b Minor doc typo fix in sqliteLimit.h. stephan 2025-08-04 11:20:31 +00:00
  • 1cf61ce636 Add a note to sqlite3_deserialize() that a schema name of NULL implies the main db, a former shortcoming pointed out in [forum:0543d8aa8e|forum post 0543d8aa8e]. stephan 2025-08-03 08:56:16 +00:00
  • cd552cf99f Tag a condition in os_unix.c as unreachable. drh 2025-08-02 17:37:59 +00:00
  • 8c30f16a2e Fiddle: move the About button into the main toolbar. Extend the About text with some info which only shows up (or is only hidden) when terminal mode is available. stephan 2025-08-02 15:04:50 +00:00
  • f681a9a7d8 Fiddle: make the toolbar visible in terminal mode and hide non-terminal-mode options when in terminal mode. Move the terminal/split-view toggle button into the toolbar. Improve the view-switching handling. stephan 2025-08-02 14:50:01 +00:00
  • 380ef6006b Fiddle: move the About button into the header bar and get it working together with the optional jquery.terminal console mode. stephan 2025-08-02 13:21:07 +00:00
  • a0e569d5ba Fiddle: add an about/info/help view and a button to toggle it. Change the color schema to a more conventional black/white. Force imported databases out of WAL mode, which doesn't work in fiddle. stephan 2025-08-02 12:06:37 +00:00
  • 7516e513b4 Fix the same potential integer overflow problem that was just fixed in the 3.32 branch, but in the 3.39 branch this time. Also increase the patch level here in the 3.39 branch. branch-3.39 drh 2025-08-01 13:22:00 +00:00
  • 24664c3785 Fix the same potential integer overflow problem of [5508b56fd24016c1] in a different and much simpler way. No error is raised but memory errors are avoided. branch-3.32 drh 2025-08-01 13:01:33 +00:00
  • 8b1157d9b5 Increase the patch level to 4. drh 2025-08-01 11:25:39 +00:00
  • 3ecedf6a0a Cast a string size variable to 64-bit to avoid any possibility of integer overflow. drh 2025-08-01 10:58:37 +00:00
  • b0cc58b981 Version 3.50.4 for the reuse-schema-3.50 branch. reuse-schema-3.50 drh 2025-08-01 09:47:33 +00:00
  • 46c7568db5 Ensure that stack space allocated for a flexible array has the correct alignment. Fix to [d4307a0d43f42e96] to for some compilers (DeveloperStudio) and platforms (Sparc). drh 2025-07-31 12:25:23 +00:00
  • 210b182b79 Generic JS doc touchups. No functional changes. stephan 2025-07-31 09:54:09 +00:00
  • 1e687a4187 On MacOS, when increasing the size of files on FAT filesystems from 0 to 1 byte in order to preserve their inode numbers, be sure to fsync() the file. drh 2025-07-31 09:45:20 +00:00
  • 67695a30ea Minor doc and consistency improvements to [cf7163f82ca380958]. stephan 2025-07-31 07:44:18 +00:00
  • 3e616d3445 Back out [e283d817e3a9] because further testing has proven it unnecessary. solaris-alignment stephan 2025-07-30 21:39:27 +00:00
  • d38777134b Move the flexarray union members from [527bbc1676a85a9] to the end of their respective objects. stephan 2025-07-30 21:34:47 +00:00
  • df23b518da Apply alignment-related patches suggested in [forum:41cd226375cd49c6 | forum post 41cd226375]. stephan 2025-07-30 19:48:12 +00:00
  • 8ed5e7365e Version 3.50.4 version-3.50.4 drh 2025-07-30 19:33:53 +00:00
  • 7957c70947 Default pointer size for the __SUNPRO_C compiler is 4 bytes. drh 2025-07-30 18:23:33 +00:00
  • b79848edd4 JS: ensure that sqlite3WorkerPromiser.v2.defaultConfig initially refers to sqlite3WorkerPromiser.defaultConfig. This fixes a longstanding oversight rather than a known in-the-wild problem. stephan 2025-07-30 16:17:14 +00:00
  • 1560d52f82 Adjust the previous check-in to replace the db's WASM address with yet another random number, and increase the range of random numbers, reducing the chance of cross-worker db ID collision to 1 in many billions. stephan 2025-07-30 15:02:32 +00:00
  • f402509b62 JS: add a random element when assigning db IDs to Worker1 db instances. This addresses [https://github.com/sqlite/sqlite-wasm/issues/113 | the npm project's ticket #113], which demonstrates that two independent workers can end up generating non-globally-unique IDs. That's not a bug, per se, but it makes the IDs useless for client-side mapping of db connection IDs to client-side state, so we add some randomness to them. stephan 2025-07-30 14:50:44 +00:00
  • bac6793a8a Enhance the printf formatter for %#f such that the minus sign is omitted if the '+' is missing and all digits shown in the rendering are zero. Thus, for example, '%#.2f' renders -0.004 as "0.00" instead of "-0.00". drh 2025-07-30 13:37:49 +00:00
  • 7423ecb0a9 Fix SQLITE_OMIT_WAL builds on windows. dan 2025-07-29 11:04:32 +00:00
  • 7bcb650f57 Add new extended error codes to SQLITE_ERROR and SQLITE_IOERR, for use by extensions. drh 2025-07-26 12:51:18 +00:00
  • e9689e7dae Do not use any index field with a collating sequence of DATACOPY to speed a look-up. Use such fields only for covering queries. *This is an experimental branch*. branch-3.28-datacopy drh 2025-07-25 21:45:58 +00:00
  • 9c620c0e4e Add the datacopy extension, used for testing only. branch-3.28 drh 2025-07-25 20:37:56 +00:00
  • e0837d59da Version 3.44.5 version-3.44.5 drh 2025-07-24 14:26:41 +00:00
  • 78145e10d9 Increase the version number to 3.44.5 drh 2025-07-23 23:22:38 +00:00
  • 710858bca3 Raise an error right away if the number of aggregate terms in a query exceeds the maximum number of columns. drh 2025-07-23 23:12:53 +00:00
  • 6d7be8293e Do not apply the [/info/e33da6d5dc964db8|EXISTS-to-JOIN optimization] if the subquery contains a LIMIT clause. [forum:/forumpost/2025-07-23T10:59:14z|forum post 2025-07-23T10:59:14z]. drh 2025-07-23 12:48:16 +00:00
  • cac93a5be0 Add a call to Tcl_Init() in tclsqlite3's setup. This activates many of the otherwise-missing Tcl standard commands and is believed to be benign on systems where those cannot be loaded, but whether it truly is requires some experimentation on affected systems. stephan 2025-07-22 20:17:06 +00:00
  • d972a08755 Fix a potentially uninitialized field in the WhereLoop object that is used as part of the skip-ahead-distinct optimization. drh 2025-07-22 16:02:52 +00:00
  • 5a6f651397 Fix a potentially uninitialized field in the WhereLoop object that is used as part of the skip-ahead-distinct optimization. This fixes various [forum:/timeline?ymd=20250722&u=yxchen&vfx|recent forum reports from yxchen]. drh 2025-07-22 15:51:41 +00:00
  • d649d7b90c Apply [ebb346c5aa]'s change to sqlite3.1, as reported in [forum:bf92f78344 | forum post bf92f78344]. stephan 2025-07-21 18:00:44 +00:00
  • 095d399e7c Ensure that certain local files are not inadvertently carried over into the snapshot tarball and causing confusing build results. stephan 2025-07-20 18:29:35 +00:00
  • fdd37e9637 Teach autoconf/tea/configure to be able to run from the canonical source tree so that a snapshot build or appropriate symlinks are not necessary in order to test the extension. stephan 2025-07-20 18:05:45 +00:00
  • 2445ee0e37 Factor out the unusual encoding-change case from vdbeCompareMemString() for a performance improvement in the common case, and a small size reduction. drh 2025-07-19 20:10:07 +00:00
  • ea8f9708c5 Small performance optimization in sqlite3VdbeRecordUnpack(). drh 2025-07-19 19:54:44 +00:00
  • bcd14a0a3e Split the (internal) sqlite3VdbeCheckFk() routine into two variants, sqlite3VdbeCheckFkImmediate() and sqlite3VdbeCheckFkDeferred(), which run faster than the combined general-purpose variant. drh 2025-07-19 18:46:03 +00:00
  • c585e03a4b Use fewer CPU cycles to commit a read transaction. drh 2025-07-19 18:17:06 +00:00
  • 1f436ad563 Add SQLITE_SELFORDER1 to JS's sqlite3.capi namespace. It's only useful when built with an sqlite3.c which itself was created with -DSQLITE_ENABLE_ORDERED_SET_AGGREGATES, which the canonical build does not do but custom builds may. stephan 2025-07-18 22:18:41 +00:00
  • daa4cdf84a Fix a minor comment inaccuracy. drh 2025-07-18 19:17:32 +00:00
  • bae748a76e Increase the precision of the "real time" output from the ".timer" command in the CLI from milliseconds to microseconds. drh 2025-07-18 17:40:34 +00:00
  • b3718ccd92 Ensure that the accumulator for an aggregate always gets initialized, even when the aggregate is on the right side of a LEFT JOIN and never gets evaluated. Also increment the version number. drh 2025-07-18 12:22:41 +00:00
  • 74cc109780 Ensure that the accumulator for an aggregate always gets initialized, even when the aggregate is on the right side of a LEFT JOIN and never gets evaluated. This fixes a problem introduced by [663f5dd32d9db832] and found by dbsqlfuzz. Test cases in TH3. drh 2025-07-18 12:10:15 +00:00
  • 01a2953350 Pedantic internal build doc fix. stephan 2025-07-17 19:18:01 +00:00
  • 4402f35000 Merge the latest trunk enhancments into the reuse-schema branch. drh 2025-07-17 15:38:46 +00:00
  • b46738f169 Merge all of the trunk enchancements into the bedrock branch. drh 2025-07-17 15:31:16 +00:00
  • 825751eb69 Merge the latest trunk enhancements into the wal2 branch. drh 2025-07-17 15:24:19 +00:00
  • 90ca27d507 Merge the latest trunk enhancements into the begin-concurrent branch. drh 2025-07-17 15:18:14 +00:00
  • 5b0592a36f Merge the 3.50.3 changes into the reuse-schema-3.50 branch drh 2025-07-17 14:02:44 +00:00
  • a4643b451a Version 3.50.3 version-3.50.3 drh 2025-07-17 13:25:10 +00:00
  • cf05295a85 Diverse wasm build cleanups. stephan 2025-07-16 20:50:40 +00:00
  • 5b4bbf6dbb Code style conformance tweaks and remove a ref to a now-dead makefile var. wasm-build-parallel stephan 2025-07-16 18:51:07 +00:00
  • 91db1c413b Fix vtabH.test so that it works on windows even if there are files that begin with "$" in the root directory. dan 2025-07-16 17:24:31 +00:00
  • ea17024eed Build .wasm/.js files into a build-mode-specific subdir, the goal being to be able to build them in parallel. This works, but (A) adds a bit of build ugliness and (B) is not actually parallelizing, so needs a closer look after a break. stephan 2025-07-16 17:00:38 +00:00
  • 10687e283a Remove some stray makefile debug output. stephan 2025-07-16 16:56:33 +00:00
  • 074b1aa42d In the wasm makefiles, replace X:=Y with X=Y because := has different semantics depending on the make impl and its use is arguably a bad muscle-memory habit worth breaking. These makefiles are very specifically for GNU make, but long-term it would be nice to eliminate that requirement. stephan 2025-07-16 14:51:23 +00:00
  • 522ce56734 wasm: remove some extraneous levels of makefile var and fix the (unsupported) wasmfs speedtest1 build to account for var renaming which happened long before this. stephan 2025-07-16 13:22:38 +00:00
  • 68b74e2c42 Remove an unnecessary step from the wasm builds and account for a recent Emscripten-internal code-generation change which caused a post-build cleanup step to not actually clean up (harmless, but adds about 26k of useless stuff to the resulting JS). stephan 2025-07-16 11:56:16 +00:00
  • e5a7b815af Further internal wasm build cleanups. No functional changes. stephan 2025-07-16 11:09:18 +00:00
  • f98148be9c Internal refactoring of the WASM build makefile rule generator, working towards parallelizing the various build modes (which is not currently possible because most modes share the same sqlite3.wasm output file name). stephan 2025-07-16 10:34:14 +00:00
  • 27e13f4f3a Teach the sqlite3 CLI shell to look in XDG_STATE_HOME for the CLI history file before falling back to its historical location in the user's home directory. stephan 2025-07-16 09:27:55 +00:00
  • 3a97a1ba8c Squelch a legitimate but harmless 'discards const' warning. shell-xdg-vars stephan 2025-07-16 09:20:02 +00:00
  • 81e9bbf8da Avoid evaluating special vtab operators (e.g. MATCH) that are part of ON clauses attached to left joins from being evaluated too early. Fix for [forum:/forumpost/428ef7c468 | forum post 428ef7c468]. dan 2025-07-15 19:00:01 +00:00
  • 7d20c2e8a3 Add test case to between.test. vtab-leftjoin-fix dan 2025-07-15 18:51:46 +00:00
  • f121227f87 Have SQLite request a plan with no setup-cost from xBestIndex if the plan in question may only be used as the outermost loop of the query. vtab-setup-cost dan 2025-07-15 17:03:51 +00:00
  • 75b03b9c11 Optimize allocation of large tombstone arrays in fts5. drh 2025-07-15 14:21:08 +00:00
  • 192d0ff8cc Optimize allocation of large tombstone arrays in fts5. dan 2025-07-15 14:06:15 +00:00
  • 812c015515 Fix the date in bestindexE.test. dan 2025-07-15 11:27:16 +00:00
  • 44db9fcb1e Add comments to sqlite.h.in describing the change on this branch. dan 2025-07-14 18:59:45 +00:00
  • 97e6368abc Add the snapshot-zip makefile targets for both Windows and Posix. drh 2025-07-14 18:27:32 +00:00
  • d74e285046 Merge latest trunk changes into this branch. dan 2025-07-14 18:03:23 +00:00
  • 1c11aa3da2 Enhance the "mktoolzip.tcl" script (used by the "tool-zip" makefile target) so that it uses "fossil test-filezip" to build the ZIP archive if available, and so that it also generates windows-dll-*.zip on Windows platforms. drh 2025-07-14 16:05:59 +00:00
  • bf5f1f5172 In rtree.c, ensure that the pReadAux statement is reset whenever the bAuxValid flag is cleared. Fix for [forum:/forumpost/3e45ed31d8 | forum post 3e45ed31d8]. dan 2025-07-14 15:40:25 +00:00
  • 194f0bada7 In rtree.c, ensure that the pReadAux statement is reset whenever the bAuxValid flag is cleared. Possible fix for [forum:/forumpost/3e45ed31d8 | forum post 3e45ed31d8]. rtree-aux-column-fix dan 2025-07-14 15:34:11 +00:00
  • 08f8111bd8 Add new sessions function sqlite3changeset_apply_v3() and its streaming equivalent. This allows changesets to be filtered on a per-change basis, not just per-table. dan 2025-07-14 14:51:43 +00:00
  • f8addcf937 Fix harmless compiler warnings in builds that use SQLITE_OMIT_DATETIME_FUNCS. drh 2025-07-14 09:41:59 +00:00
  • bcfe38b96a Avoid evaluating special vtab operators (e.g. MATCH) that are part of ON clauses attached to left joins from being evaluated too early. Possible fix for [forum:/forumpost/428ef7c468 | forum post 428ef7c468]. dan 2025-07-12 18:14:41 +00:00
  • 80a19cab88 Experimental change to allow virtual table xBestIndex() methods to specify an initial setup cost for a plan. dan 2025-07-12 16:35:54 +00:00
  • 1b8f6558f8 wasm: introduce the sqlite3.oo1.DB.wrapHandle() and Stmt.wrapHandle() APIs, which enable clients to wrap (sqlite3*) resp. (sqlite3_stmt*) pointers in their oo1 API counterparts, optionally with or without taking over ownership of the pointer. stephan 2025-07-11 19:52:36 +00:00
  • 1f68085849 Clearer docs for the unowned db/stmt handle mechanism. oo1-unowned-handles stephan 2025-07-11 19:44:42 +00:00
  • c493e4516a Correct a one-too-many-exclamation-points bug which caused the opposite of intended semantics in oo1.Stmt.pointer ownership. stephan 2025-07-11 19:34:30 +00:00
  • 69b5674b40 Additional header comment documentation in the ext/misc/vtablog.c test extension. drh 2025-07-11 17:02:11 +00:00
  • 868f32abbd Merge trunk into column-text-blob-v2 branch. column-text-blob-v2 stephan 2025-07-11 14:18:19 +00:00
  • 08103b6aa8 Add column/value_text/blob_v2() to the sqlite3_api object. stephan 2025-07-11 12:56:59 +00:00
  • 0eca9db776 speedtest1: in WASM builds, disable the "app" test set by default because that one set is triggering file-not-found errors for the db file for reasons not yet understood. stephan 2025-07-11 11:06:25 +00:00
  • c066f2af9c Do not export the numerous Emscripten HEAPxy symbols and remove the last remaining JS code which references them. They have long-since been replaced by internal equivalents and a specific feature check on one of them (which is also no longer needed) is triggering an exception from Emscripten. More details are in [https://github.com/emscripten-core/emscripten/issues/24656 | Emscripten ticket #24656], noting that this is not an Emscripten bug but an Emscripten behavior change brought it to light. stephan 2025-07-11 10:27:06 +00:00
  • 625d0b70fe Improve the accuracy of the ETC on both devtest and releasetest. drh 2025-07-10 20:45:00 +00:00
  • 45bff0ea64 Add the estkey column to the jobs table of testrunner.db. The plan is to use this to collect measurements that will help generate improved ETAs for a test run. drh 2025-07-10 17:19:08 +00:00
  • 07b483c48e Minor internal doc correction in vdbeInt.h. stephan 2025-07-10 09:27:57 +00:00
  • 6fd9469a32 Minor JS doc tweaks. stephan 2025-07-10 09:25:57 +00:00
  • 33c2e37f98 Fix the empty-table optimization on INTERSECT so that it does not try to use an uninitialized register for LIMIT processing. drh 2025-07-09 20:11:49 +00:00
  • 2ba5a93e8f wasm: DB.wrapHandle() no longer accepts a DB object as its first argument, as there's no apparent use case for proxying one DB object with another. Doc improvements for the new code. stephan 2025-07-09 13:43:53 +00:00