database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
32,669 Commits 1,785 Branches 392 Tags
static-sql
Commit Graph

32669 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
dan
f1c37a357e Add new column "cwd" to the jobs table in testrunner.db. For recording the directory in which the test ran or is running. 
FossilOrigin-Name: 334305a469a51ef0d768ba8443d8cab217f45394cc9f720748a489b10703193d
 2025-11-03 15:29:51 +00:00
drh
d95fffc9af Adjust the dbstatus2.test module so that it works on 32-bit builds in 
addition to 64-bit builds.

FossilOrigin-Name: dcaaa71e750d56afde3e905aaf10729ec95e0ede00522e1b12af6b6345e744ac
 2025-11-03 12:36:52 +00:00
drh
4733884eae Update test result output from test/dbstatus2.test module so that it 
reports the actual value of nTmpSpill when that value is out of range.

FossilOrigin-Name: 382c8440d7a16eae49fa1644513ae045bfceb072d9b4005963f57f1a57fe94b2
 2025-11-03 11:35:13 +00:00
drh
0dfa31d279 Fix the test/speedtest.tcl script so that the CC= command-line option works. 
FossilOrigin-Name: 0de0ba878b9ec572d76d47112a0124df9f234fbb7a69c5f5a76ce8c439b11f6f
 2025-11-03 10:40:06 +00:00
drh
15c6d88381 Fix a harmless memory leak in the CLI caused by the --cmd option generating 
an error message.

FossilOrigin-Name: ab916bad188b150321e420ec0009d909c287e3790b5d6ec683e2df9ed457ff15
 2025-11-03 10:14:20 +00:00
drh
eaacb4ac37 Add pedantic OOM detection logic to some disused diagnostic and test code. 
No changes to any deliverables.

FossilOrigin-Name: abb6945fc62a1855786bda1f473edef0e937a791c453387a0859a6ce0451635a
 2025-11-02 22:57:26 +00:00
drh
0c747e1653 Update the test/walthread.test testing script so that it uses a random 
database name.

FossilOrigin-Name: ce25a758d4cea1741cb3db6384720f17faef61b352d494ab410a83a41f1721d3
 2025-11-01 20:14:43 +00:00
stephan
e5c8467a8e Fix ext/wasm/mkdist.sh to use ./version-info instead of ../../version-info (a recent build change made to ensure that builds with a custom sqlite3.c embed that version info). 
FossilOrigin-Name: d25a92d88923f880d6477a99f2a35528faea83e7db245f2b07db80613b4aeb8e
 2025-11-01 14:49:05 +00:00
drh
b2b8ab6bc8 Updates to the compile-for-windows.md document. No changes to code. 
FossilOrigin-Name: 652310a9f0ef2a870b5033029278b1fbef28c2ec15405d1b32bf1d51df28266c
 2025-10-31 17:45:59 +00:00
dan
7f70085071 Detect some cases of ambiguous column references in USING clauses that can come up with nested joins. 
FossilOrigin-Name: 38c993c8b7137d6d5623d387292639634297c17da11befec9029f12a16a472f8
 2025-10-31 16:07:31 +00:00
drh
a183595edd Change the name of a file-scope constant array in carray.c so that it does 
not conflict with other variables names in other files when carray.c is
amalgamated.  This is down to resolve a harmless compiler warning.

FossilOrigin-Name: 5afd815ada94d55c9c56efe339235d23ffbf1fb64511a5e460927a2c8deaaaf0
 2025-10-31 15:18:29 +00:00
drh
63ab7c625c Update the main README.md file to use the robot-safe /rchvdwnld page on the 
server for downloads.

FossilOrigin-Name: c1aa52361b8ede611f64b96f2394174389ce531b1d86b9cfec91d3b03c94f6ea
 2025-10-31 13:44:51 +00:00
drh
1c19c06246 Fix the output of ".dump" in the CLI so that the sqlite_sequence table 
is created using correct syntax.

FossilOrigin-Name: 4b9f2e1d4485ad3baf9285aa09b468469be929b18cb308f19af471d7aac66076
 2025-10-31 11:23:44 +00:00
drh
da17de532f New assert() statements to help out static analyzers. 
FossilOrigin-Name: ba0c4bf072ed721a507855d68bde7f1c388396a19b69814b6e257b934f8b0fd9
 2025-10-30 22:10:41 +00:00
stephan
1ed6441bb1 Add SQLITE_OMIT_WAL checks around some functions to avoid defining unused statics in such builds. Fixes OMIT_WAL builds on msys2 and passes tool/omittest-msvc.tcl. 
FossilOrigin-Name: f9b89535dc279acf617f274b6edbad0610fc8e5c76d402fc8b5b9dc656e95caa
 2025-10-30 21:11:01 +00:00
stephan
c129de05bb Simplify the EXPORTED_FUNCTIONS lists to use the preprocessor instead of per-list shell commands. (Unrelated) Remove part of the post-compilation JS filtering which breaks with emsdk 4.0.16+, which means the .js files are about 57kb bigger than they really ought to be. 
FossilOrigin-Name: 936990cf067a5ebb34f7f662fc2d23d468c50f179afafe47fe0d2ed775f5ef74
 2025-10-30 20:18:20 +00:00
stephan
6acd8d28fd Merge trunk into the wasm-post-3.51 branch. 
FossilOrigin-Name: dda1735716cf1006b2a5d1d8eb29df3039047be38dcc04249c4ce50c77084fac
 2025-10-30 19:32:46 +00:00
drh
139ec38ac8 Further improvements the ".dump" command to handle corner cases. 
FossilOrigin-Name: cd0c77934ff32050380c2143bba7d4e6c07d5f08187cb5d5e8e7602854d1cda8
 2025-10-30 18:52:48 +00:00
stephan
41fda52f3c Another (void), as per [dd6edfc09434]. 
FossilOrigin-Name: 7a822cfd388d7ac5765cffd5bd3d6e5b31abc6a360f9d5e27c0223f83a84237e
 2025-10-30 18:48:19 +00:00
stephan
7fb2545905 Add (void) to two places for the sake of SQLITE_OMIT_WAL builds. Why these do not complain on tests in this tree, but do on a downstream tree (same machine, same compiler), is a mystery. 
FossilOrigin-Name: dd6edfc09434b0d170d5ab462053497043016a4ec6b91a46db565ccf646aee20
 2025-10-30 18:46:03 +00:00
stephan
3a61466a2f wasm: re-add SQLITE_OMIT_WAL to the c-pp-lite build flags. 
FossilOrigin-Name: 617f8ac40e073c3fdc1144639b78617ad61113f4e873fc20c99399d2b60e1ceb
 2025-10-30 18:39:28 +00:00
stephan
916fc1129c Macro tweaks to get SQLITE_OMIT_WAL building. Remove some nearby stray EOL whitespace. 
FossilOrigin-Name: c31a944680f18a799c763238dbb0561f8b039905ce442533258905219b33b743
 2025-10-30 18:38:14 +00:00
drh
a8a99becb5 Fix a typo and improve wording in README.md 
FossilOrigin-Name: 34a662ce24930a5e1a142f0b3ce427c4b1b61a306537820dc5e72996f8080d86
 2025-10-30 18:33:58 +00:00
drh
f3b396494f Updates to the tool/warnings.sh script for better compiler warnings. 
FossilOrigin-Name: c9c64892c76cb9f2efb58428b349d43b075e7595b6a391d4818a7e9fb68b85fd
 2025-10-30 18:32:32 +00:00
drh
4ebf49168a Fix a harmless compiler warning associated with flexarrays. 
FossilOrigin-Name: f02cdf1d3ea8da8a09d115721845afeff5d6169dd7532ab486d3ed6db69cde2d
 2025-10-30 17:23:17 +00:00
drh
c6b86ba2ab Updates to the main README.md file. 
FossilOrigin-Name: ab10c4cd9f9314bc62aa310ee796f63c82710c35659debe347e8ebcbf34d9e86
 2025-10-30 15:43:57 +00:00
drh
c5ff2aa7cf Fix the CLI ".dump" command so that it does not make duplicate 
sqlite_sequence table entries as described in
[forum:/forumpost/b1674b56ad|forum thread b1674b56ad].

FossilOrigin-Name: c833f26a6780f919551e50c67d308e96293cec8481899354411d805617481f24
 2025-10-30 11:39:49 +00:00
drh
cb36dc3f3e Prevent a harmless signed integer overflow in the CLI if the argument 
to the --skip option of the ".inport" command is -9223372036854775808.

FossilOrigin-Name: 247277d9373cb2614a1bc4c1e08b904315e5e8c0c2a7fbe9c2ac651481601642
 2025-10-30 10:36:10 +00:00
stephan
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. 
FossilOrigin-Name: d0e803b90344ee972e4b3fb30b77e283599dc4d5c6a3335ce9fea653a1b3f6f0
 2025-10-30 02:21:38 +00:00
stephan
7c86a0321e Remove an OMIT_WAL from the wasm build because it breaks with the current amalgamation (and isn't strictly needed here anyway). 
FossilOrigin-Name: a7be7d155aa6f02075f939ab6d26cfdfe2d0832b59da39c8bf4a74fc4845bd05
 2025-10-30 01:43:30 +00:00
dan
11b6fc93f6 Experimental change to allow triggers in the temp schema to use fully qualified table names in INSERT/UPDATE/DELETE statements. 
FossilOrigin-Name: 48e168007ceb1bdc54cf21a8e959a8e0f9ccdc478827db7a7a0518fc7a226401
 2025-10-29 20:57:44 +00:00
drh
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].

FossilOrigin-Name: 095cc4f22e63c98cbb2acabdbcaf02e59e67ec6d3cc219b5f42a714e3d53a264
 2025-10-29 20:47:01 +00:00
drh
03e6242802 Striving for better names for fields in the spec structure. 
FossilOrigin-Name: 9644e2a8db4d97a85aa7660a1536894ab971abca52fb32f946c01de30eb40de3
 2025-10-29 13:03:35 +00:00
drh
630b111cd3 Documentation tweaks. Change the name of the eQuote setting to eText for 
consistency.

FossilOrigin-Name: 612326750155ff15c9a73fde938aa035490cdd95b364452c1e6b19b521508dfe
 2025-10-29 11:19:04 +00:00
drh
a73fb2b233 Add support for the bTxtJsonb flag in sqlite3_qrf_spec, which if true causes 
JSONB blobs to be displayed as JSON text.

FossilOrigin-Name: 3fcf9ecb039a903cefcf4eeaf43974de0cbd48d899dc189b8f70c3745addc11a
 2025-10-28 22:25:24 +00:00
stephan
34b1bf16ec Tiny cosmetic tweak to configure script output. No functional changes. 
FossilOrigin-Name: e2c20aa5929e5b79aabca8a51fb3e32e0533526d64d7576d3caf1c847fff58b4
 2025-10-28 22:09:43 +00:00
stephan
74cd3c53f9 Typo fixes in LICENSE.md from BrickViking. 
FossilOrigin-Name: 26ddec291696dd99c7f84a21b2dd272ce9bf32598ca38413ac89432d45527f8d
 2025-10-28 19:57:15 +00:00
drh
ccae8e0c47 Fix a harmless compiler warning. 
FossilOrigin-Name: d00c549126ca96b061e537dfabb93b02824e3a9b8fa0c9135a96cf060262206e
 2025-10-28 19:37:18 +00:00
drh
74e5918178 Merge the latest trunk enhancements into the qrf branch. 
FossilOrigin-Name: fa5661ea8b6b5ca368d719477bd82a954d2f979f4ab85fff2720cf7bb7cc427d
 2025-10-28 19:35:26 +00:00
drh
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.

FossilOrigin-Name: 724f2299f206cc9e7f830f984c50a8fc4ac1c17210d71d9affe657b45252b060
 2025-10-28 13:24:50 +00:00
drh
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.

FossilOrigin-Name: 6385a1962c69c69ca4775888f034a4eb892aa013689c000f3de6422da7c3c695
 2025-10-28 10:50:55 +00:00
drh
9c0770537f Enhance the CLI so that it can handle inputs larger than 2 billion lines. 
FossilOrigin-Name: 5daebf2d6013e73d89c9feb796e15b67c39577e5a9e9c86fa260995f4118f04b
 2025-10-28 10:44:26 +00:00
drh
6cc222c3be Additional comments explaining what unixIsSharingShmNode() does. No 
changes to code.

FossilOrigin-Name: 819fc87385fd5be8a847492478f4c4f247f64edf7c7161b641bfbac6b658bec5
 2025-10-28 01:28:20 +00:00
drh
db0d47b749 Omit unnecessary branches from the unixIsSharingShmNode() implementation. 
FossilOrigin-Name: 2d5623bc27073c407ec63e401f095d12f0025dd276a0bdc26d8b94b1f13c9a36
 2025-10-27 23:57:57 +00:00
drh
e34f35c833 The unixIsSharingShmNode() function should always return false for the 
unix-excl VFS.

FossilOrigin-Name: 770f35dae47a98554b18f8a7aa9f6b6e39ae2b3aa8dce8d75b5bed0c6f0f9c21
 2025-10-27 15:44:16 +00:00
drh
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.

FossilOrigin-Name: ed1b9206640f66cb8abff444809ccab8a4a5157b5c90e9aacddc422210e63423
 2025-10-27 14:24:02 +00:00
dan
6e27846323 Fix a minor over-allocation of heap memory in wal.c. 
FossilOrigin-Name: 1803cb9bb6a13fb66956f729066b6eae64c3a1c0715102fb1a9994e395c12ba9
 2025-10-27 11:39:07 +00:00
dan
8ce786f173 Fix sanitizer complaints in the regexp extension. 
FossilOrigin-Name: 6ff9ecb89d769bc2a27f8a57130f28ec7478979d3e35ba765c16017b5bdf775d
 2025-10-27 11:20:47 +00:00
stephan
6b9230d2a1 Merge the OPFS/SEE tests into trunk (where they should have been committed). 
FossilOrigin-Name: f8a4d7abf0d1c9c92fa102165d08aed76fd766d49615e3d347b5547580355574
 2025-10-26 21:58:41 +00:00
stephan
241004f8fc Demonstrate the opfs-sahpool VFS with SEE. 
FossilOrigin-Name: b4cffc00f3a18906867e8f070fbc49293ac5c038bad58e96ea74948591f31013
 2025-10-26 21:45:02 +00:00