database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-10-21 11:13:54 +03:00
Code Activity
30,539 Commits 1,600 Branches 184 Tags
ext-to-core
Commit Graph

30539 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
8f2f5e4963 Add the SQLITE_ prefix to the type constants used by sqlite3_carray_bind(). 
FossilOrigin-Name: e11e9913e56d42d2baa07f1b549f212b873fe7343a06825682d843471c4a3640
 2025-10-08 18:51:15 +00:00
stephan
0df9db4921 Make use of the new SQLITE_ENABLE_PERCENTILE in the wasm build. 
FossilOrigin-Name: 937c084c2d9b20fde2d54e48257cb7018bd8c36d6f00ed6f1659b5ecc2f48ed4
 2025-10-08 18:17:19 +00:00
drh
01f5e6e757 Add ENABLE compile-time options to enable carray() and median(). Hence 
there is no new code and no increase in library size without the ENABLE
macros.

FossilOrigin-Name: 7dec290b413ca1bc67694743d8b771e1634fd85251f1a23d60aaf36c63f0f366
 2025-10-08 18:11:37 +00:00
drh
ba5cce9f08 This is how the percentile() family of functions might be integrated into 
the amalgamation, should we elect to do such a thing.

FossilOrigin-Name: c2cfc9c92e35105e26a4c0887b0401ace15a874fd18046135de4b375ba968795
 2025-10-08 16:29:14 +00:00
drh
cdaff852bf Were we to choose to integrate the carray() table-valued function into the 
amalgamation, that integration might look something like this.

FossilOrigin-Name: 2b43d5d7dcc5aee14a050c824a5e09b6a38a9c78ddcc25a994eba5d4c5ad9ba2
 2025-10-08 15:32:55 +00:00
drh
e15ef5b756 Fix harmless integer overflow in the CLI when arguments to --lookaside are 
ridiculously large.

FossilOrigin-Name: 8bf337e6e609dd38de6002f2d3d3ebf52dd0462ed98a50e4b002a7c6860d30c5
 2025-10-08 12:37:01 +00:00
dan
d3973778a1 Fix an uninitialized variable problem in test1.c. 
FossilOrigin-Name: 059203f658273712597d45d9b4a9cf1aea20368fe51224b38e28797b045fb6b8
 2025-10-08 11:00:04 +00:00
drh
55085a2cc2 The ".dbtotxt" command in the CLI should not fail if the database is 
uninitialized.  It should instead be a no-op.

FossilOrigin-Name: 2818ef64d9233095b065101392768071fbd95729cde060b954f48ea821fc549a
 2025-10-08 09:52:52 +00:00
stephan
b8d2ca1513 Function name doc typo fixes for sqlite3_source_id() (sic.). 
FossilOrigin-Name: 03c3f12853163ce542239a98bdf8e830db2fc7ccf1edb2f9c783fcfdca858879
 2025-10-08 02:05:15 +00:00
dan
6147a0f6a1 Add test cases for the carray module. 
FossilOrigin-Name: dcfc0164a95eddb5e924c606850fe2015e8f2f516d36b380cbb79d6bdfe034fc
 2025-10-07 21:02:37 +00:00
drh
308831d1c7 Improve the invariant checker module so that so that it added "+" before 
"column ISNULL" in queries where the base query contains a GROUP BY, to
prevent the ISNULL term from being pushed down into the subquery, since
that can cause ambiguities if column is UNIQUE.

FossilOrigin-Name: b4ff920fbeef9a8590219596d73c09976da3da53c08a685be56f6b2cd2cdc70c
 2025-10-07 18:06:05 +00:00
dan
9b6bc61dbd Fix some integer overflow warnings in the base64 and base85 extensions. 
FossilOrigin-Name: 06b4bd2aba22c57f5a5fed606c3bee225dee6fdc13bb16cc58194040ef0d7d85
 2025-10-07 15:14:03 +00:00
dan
7aa5271c72 Fix a minor problem with building sqlite3.c without manifest.tags. 
FossilOrigin-Name: 140f0f9fd389c99dc6ba1fdca7658c43d8dc3f3c128484fbafa7d67c33fe1001
 2025-10-06 20:11:18 +00:00
dan
9804ed7021 Avoid attempting to delete a file that is still open in sessionnoop2.test. 
FossilOrigin-Name: 56f6d6c538fd4e0da8a7c4e4c4d1bd0b8cd83ffd126ae24daaf30fdf808e1a78
 2025-10-06 17:52:52 +00:00
dan
75ef68e385 Avoid using randomblob() in walckptnoop.test, as it produces different results for different test permutations. 
FossilOrigin-Name: 94ceb0f0cfef1da89ea2a7420f508024897d9b7c19ef9be9af88d3e6f48c297c
 2025-10-06 17:20:26 +00:00
drh
35299c9076 Change the testrunner.tcl option from "--case" (singular) to "--cases". 
Allow the argument to be a glob pattern, to pick up multiple cases.

FossilOrigin-Name: e205f87f5cf97b82781af690da1a3fbf3dc75f590783074e5a72c1d7e3bebbad
 2025-10-06 16:57:49 +00:00
drh
87f53152ed Fix typo in the previous check-in that prevented the script from running. 
FossilOrigin-Name: 797664700701effefbf4d87a791febae3bb68544bac23470351a11bcb3a87651
 2025-10-06 16:56:12 +00:00
stephan
6f7c977ed9 Add info from the SQLITE_SCM_... macros to tool/version-info.c's --json output, prompted by [forum:0c513ae3fca7d55c|forum post 0c513ae3fc]. 
FossilOrigin-Name: 951882aa4e1684b7b0f7e10590de81eae1ddb8c5ac21588e3f9b9cd4cb9f0f51
 2025-10-06 16:54:45 +00:00
drh
ad7118fa68 Update testrunner.tcl so that the new option is --cases rather than singular 
--case, and so that it is a glob pattern.

FossilOrigin-Name: 9488b4f00c9278de8c03f4a3cbd4f54e48e71c1eff45de4454f8bd49c080a930
 2025-10-06 16:50:37 +00:00
drh
0ab87fc9a7 Fix typo in the "testprefix" for walckptnoop.test 
FossilOrigin-Name: ff205f29934417e8150b5243245fb70389717b219e35bd8d60791a8485b69b33
 2025-10-06 16:23:31 +00:00
drh
0611aeeed4 New testrunner.tcl option "--case DISPLAYLNAME" only runs the single case 
(and its build dependencies) that exactly matches DISPLAYNAME.

FossilOrigin-Name: 8ea2e097b731514c284f255f12b08e15f63c7f49641a698e61ee7e47cc9d3c45
 2025-10-06 15:53:52 +00:00
drh
566348f68b Fix testrunner.tcl so that --help output goes to stdout, not stderr. 
FossilOrigin-Name: 441a759c225d4e710a693339402624e7ba52852c08aa64439ed4568c193ad529
 2025-10-06 14:30:22 +00:00
drh
d357d9d1cd Fix a subtle problem with short-circuit evaluation introduced by 
[cea8bf79e18d55a8] and detected by the dbsqlfuzz fuzzer.  Test cases
in TH3.

FossilOrigin-Name: d71cd722c478288601c70df8cec8c242cc623d2147b30f4f68dad57c75b3ee4a
 2025-10-06 11:50:35 +00:00
drh
833fb1ef59 Another small performance increase in the text format by using strchr() to 
search for '%'.

FossilOrigin-Name: 59ad89ba07dd7b127f03f62a647f7328f08dbc0aa1b88b2b4529eb5b4c677775
 2025-10-05 22:41:32 +00:00
stephan
34775b696b Fix a syntax error in the tcl script part of [199b6567bb41cd]. 
FossilOrigin-Name: a7ed85f27066b74263dbd3dfcefe5d378e524cc56cd3abac4032bc23f83b5d21
 2025-10-05 19:56:57 +00:00
drh
d310393158 Performance optimization in text formatter by using a hash table to look up 
the operator character that follows %-subsitutions.

FossilOrigin-Name: 199b6567bb41cd41977e28b3e06e8c26c3300b3873f226a4699ec251a7bf8883
 2025-10-05 19:30:05 +00:00
drh
275d08ad62 Minor clarifications to the JSONB format documentation. 
FossilOrigin-Name: 0fc708b41fe99b315b32e4a6ac8d48d8250195f7de1ab1d9f6eaf50290781286
 2025-10-03 18:17:13 +00:00
drh
1d574d3d71 Remove the memvfs.c extension, to prevent it from being misused. 
See [forum:/forumpost/91811439aa|forum post 91811439aa] for the complaint
that prompted me to take down this demonstration code.  I have other things
to do rather than argue about posts such as the foregoing, so it is easier
to just take the code down.  If you need this code, you can downloading older
check-ins.  The beauty of DAG-based version control systems like Fossil
(and Git) is that nothing is ever lost; it is just stops appearing on
trunk.

FossilOrigin-Name: eb79110dcac80dde3bcca0929d67a8f8f6d2eea5695184b2b7c6788283f06902
 2025-10-02 22:48:08 +00:00
drh
e2ebc364cd Fix typo in the previous check-in. Remove surplus end-of-line whitespace 
from the ext/misc/fossildelta.c extension.

FossilOrigin-Name: cc87551805dc1fcb05598339e526b304401b64a4eaaa2148a9d837b1423484ce
 2025-10-02 19:35:58 +00:00
drh
0d9ec8b2ee Harden the debugging vtab "delta_parse()" which is part of the 
ext/misc/fossildelta.c extension against malicious inputs.
[forum:/forumpost/be139437c3|forum post be139437c3].

FossilOrigin-Name: 4be6deee646f2c0f591ba81f902182ca9302050a7fb2729c7f64981307058b8b
 2025-10-02 19:19:40 +00:00
drh
4defad2f29 In the ".open" command of the CLI if using the --new option with a URI 
filename, then decode the URI to extract the actual filename prior to
trying to delete that file.

FossilOrigin-Name: 14ee3c1f03de274e5fa1efb471816a0001762623614253c24d58f41ea6af0628
 2025-10-02 18:31:19 +00:00
dan
7d973ac52f Fix -DSQLITE_OS_OTHER=0 builds. 
FossilOrigin-Name: 2971d7470110fcd43bdc8ad5d09d1f2f63f5a3bccda41810948a683e310ad908
 2025-10-02 14:48:27 +00:00
drh
b9c23fa541 Correction to [ae303dab2f534e2c] to use the right loop over the solver. 
FossilOrigin-Name: 22b2700ac20bb8e5883d484bfd0aee7a0fbc99b92696d8ca850cd129e2ccbb43
 2025-10-02 11:28:27 +00:00
dan
cbc3cd47f0 Fix a buffer overrun in the zipfile extension that could occur while processing zip archives with extremely long file-names and comment fields. 
FossilOrigin-Name: c284fda848038a61972fd1df5796f608a24ead109170aafe562a5d5787c46488
 2025-10-02 11:16:22 +00:00
drh
fa563eff1d Add the --ifexists option to the CLI and to the ".open" command of the CLI. 
Also the undocumented and unsupported --exclusive option on the same.

FossilOrigin-Name: 9a1947814d235d270dec265bb85db37e75cc077289e444d3d00f8345016c683e
 2025-10-01 20:41:02 +00:00
drh
65ee59bb26 Prevent embedded 0x00 characters in the output strings from confusing 
the completion extension and causing it to read past the end of an array.
[forum:/forumpost/88a08b3201|Forum post 88a08b3201].

FossilOrigin-Name: 26f6d41f9d3ab656129af333d54a8645c6890314919bcae90351ba0c2240ceef
 2025-10-01 19:01:19 +00:00
dan
a9af4102f1 Fix a buffer overread in demo code in ext/misc/memvfs.c. 
FossilOrigin-Name: 90f7318308ca8372cbd9f183d88ff6cb884446f6df0695294c9a9955c5109f72
 2025-10-01 14:28:48 +00:00
drh
4af7048aeb Enable the CLI to be compiled with SQLITE_OMIT_AUTHORIZATION. 
FossilOrigin-Name: afb2feb38043fef3c286030f9d1238c132f338e54233f2e4655323b388455c72
 2025-09-30 19:11:00 +00:00
drh
0f76b0a4d6 Fix various compiler warnings. 
FossilOrigin-Name: 24ee6c25b4745c8fd671d845b48b9ab98a787ccb348d560ad70f19d035e7990e
 2025-09-30 17:37:18 +00:00
drh
c8e6f627b8 Fix the new generate_series() to correctly deal with an explicit 0 as the step. 
FossilOrigin-Name: b059413c440d1b831c9a462f7165a350001ba7a8cc77ca2a0a8f2bb73c830aba
 2025-09-30 17:12:39 +00:00
dan
d05bf5aedf Fix another potential buffer overread in the zipfile extension. 
FossilOrigin-Name: 0819fe670f9ceec79f84eb09c234dc29f6581332f86a53d6a0547697404efff1
 2025-09-30 11:17:40 +00:00
drh
5b15123fba Strengthen the fts5_locale() function against integer overflow attacks, 
even when SQLite is compiled with oversize values for
SQLITE_MAX_LENGTH.

FossilOrigin-Name: f0dbd9d22f558dd002e2132381de3c82d55a670399b3e527b5962b025141676a
 2025-09-30 10:11:44 +00:00
dan
3eccaa7915 Fix a buffer overread in the zipfile extension code. 
FossilOrigin-Name: 70c2c99b6f12a3467c23b44adcaf2d7d780ba8317b72de2f6730b1d892cf0c85
 2025-09-29 18:55:05 +00:00
drh
e6197c0d1d Improve whereSolver() so that it always finds a unique solution. 
FossilOrigin-Name: ae303dab2f534e2c5132112b61fa5a097e7010fd8b652badee669fbe9df5cf53
 2025-09-29 18:17:19 +00:00
drh
7e38287da4 Fix JSONB logic so that it correctly interprets large JSON5 hexadecimal 
integer literals as positive numbers.

FossilOrigin-Name: 0ad5d77fc0a9d205cc061ee4923d885f6f28f77c1efef3cc10297036ce164e6d
 2025-09-29 14:09:43 +00:00
drh
381df874f0 Large JSON5 hexadecimal integer literals are positive unless preceded by 
a negative sign.

FossilOrigin-Name: 5a93d9dce2d134ca450955bb272baba43dfc76beb540b643bf4bd31f7eb9e0b9
 2025-09-29 13:43:10 +00:00
drh
b7f5885b3e Back out check-in [9abaa0ac2b304934] as the code removed there is necessary 
after all.

FossilOrigin-Name: 27ae98629406bbaee2857f75c069b2ccd4757b247f0742e51b9e619e96b6dc45
 2025-09-28 23:10:54 +00:00
drh
36ba76010c Revamp the implementation of generate_series to simplify and improve 
long-term maintainability.

FossilOrigin-Name: 9041ca8543ff3d2a617ce4df696aa53269a7803716caaf55a8e61e59ee667040
 2025-09-28 18:25:59 +00:00
stephan
436c8e5026 Remove the long-defunct wasmfs build of speedtest1 from index.html and re-enable the wasmfs scratchpad app (which still works). Fix the CFLAGS for the wasmfs build and the path to the wasm file for one of the JS. 
FossilOrigin-Name: acaaf8cce9e780bf937436b4c987ed284aa0bba6f5ca9508d9dbad598af2991d
 2025-09-28 18:03:29 +00:00
drh
1bf80f2dce Minor bug fixes. Many new test cases. 
FossilOrigin-Name: 86dcc68d1816d970d8d5fb158696c3fe6c5ddcac2c255823110d656372503885
 2025-09-28 17:24:42 +00:00