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

32669 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
dan
d802904c8a Fix some problems with DROP CONSTRAINT and DROP NOT NULL on generated columns. 
FossilOrigin-Name: 66c47e18e6e1b69df4c2ceb63ff20423bbc1d5819934d77b140cf321fa14eac5
 2025-10-01 17:27:23 +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
dan
c592b7e01d Fix handling of FK constraints that immediately follow named table constraints in DROP CONSTRAINT. 
FossilOrigin-Name: 1c6f09f9f95ba76efa4f11f1c05d405d799b43f3570b23791472c3e165971bbc
 2025-09-30 19:20:53 +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
dan
1f6d80c1e2 Fix some DROP CONSTRAINT and DROP NOT NULL cases involving SQL comments or multiple table constraints without separating commas. 
FossilOrigin-Name: b0b02e58ac60e4371981938c904ccf831b2367e3fd7d22e0ec2b4782e4c6805b
 2025-09-30 17:13:12 +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
drh
974b8d7df0 Fix a problem with the merge at [cb604efdb40da95a]. 
FossilOrigin-Name: ee6102d4fe35b7b914aa2dc7c7dd37460910efedc9b2d192c2fb8cb0e6a1fd4e
 2025-09-29 20:40:50 +00:00
drh
8f6b797a1b Change the name to SQLITE_DBSTATUS_TEMPBUF_SPILL. 
FossilOrigin-Name: 4a60a9c63534f5d2f16af2c3c6581abe7ecf7adfdb39f17e557e73997ae03396
 2025-09-29 19:57:43 +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
c49ff175ef Merge the latest trunk enhancements into the dbstatus-spill branch 
FossilOrigin-Name: cb604efdb40da95a759e2eeb9d73608859a94acde9d9782ca82757d3a1c15303
 2025-09-29 18:48:00 +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
dan
d7330b571d Add further tests for the new ALTER TABLE commands on this branch. 
FossilOrigin-Name: 17a6f4e69e54a5dc233e33501f16f0f69f77fff071142cefc309b5407f57f721
 2025-09-29 16:49:55 +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
stephan
39bffbcd32 Use new c-pp features to simplify generation of the tester1 family of files. 
FossilOrigin-Name: f7cab028c97b2c9ac9b561a4c33475aadd3f71cbd48ec4dd6e09c1bb19ec00cb
 2025-09-28 12:47:09 +00:00
drh
d3cd2a25b4 All legacy tests are passing. Want to add new test cases before merging. 
FossilOrigin-Name: adb80761d2319e16b6db2b5e35fedc239fad0ed5d26d629a5ea659c90881f76a
 2025-09-28 11:01:05 +00:00
drh
9ffb344ed9 The generate_series rewrite is working better now, but is still not 
completely correct.

FossilOrigin-Name: 6c41d14707e6890ca6d0460c72178ccb710d7f41dead76f222f1382c5cbd5a9a
 2025-09-28 10:36:23 +00:00
drh
5b047a8ec6 Refactor the generate_series extension. Compiles but does not yet work. 
FossilOrigin-Name: 25e395a82f14513bf23c1e913fe24be77ad74fec1540f524e709f9cdfeb3dc56
 2025-09-28 09:25:07 +00:00
drh
c2f7be11bb Fix harmless typo in a comment. 
FossilOrigin-Name: 1f6deabfff2fc2fed5fbff48d2637b48245e5a946a442c4bcc9b9ecb7c4848b9
 2025-09-28 08:59:16 +00:00
stephan
1d592e0d62 Internal js/wasm tooling doc updates. 
FossilOrigin-Name: 0d6ed44278a513b062539f32da49fa43952fcdf0bc1bba7b24ef3749bc4525a5
 2025-09-28 02:30:25 +00:00
stephan
0b0c8734f3 Improve #if support in, and add #assert to, c-pp. Rename target=... preprocessor symbols to target:... because changes in the semantics for symbols which have an '=' makes some of those #if blocks mutually exclusive (which we won't want in rare cases involving the bundler-friendly builds). 
FossilOrigin-Name: 54287487793d48f6dde919446ab7476aea0cc0aba3835c80f060a7b84221881a
 2025-09-28 00:53:00 +00:00
dan
fc66c6380f Add test cases for ALTER TABLE and attached databases. 
FossilOrigin-Name: 8f2e066e9a0a34fe7a41b153c0fb54b621128b2195141cc454a44180c969b4a9
 2025-09-27 19:17:08 +00:00
dan
eceff127ea Add OOM injection tests for new commands on this branch. 
FossilOrigin-Name: 34b47c9b1be8a6ead917c6e9a85f8a295b14640cde177d8f1384b15f8bc692bb
 2025-09-27 18:25:27 +00:00
dan
d47220c190 Add tests for ALTER TABLE authorization callbacks and other things. 
FossilOrigin-Name: 55cad8d15040bc01300bfe5efcc7225dd9695c2972c0f9b4bbd311ed57188e1f
 2025-09-27 18:08:19 +00:00
dan
32c49bd6e6 Fix authorization callbacks for the new commands on this branch. 
FossilOrigin-Name: 0165e2afa8b640c9d7a31414f06144e089844dc13691f06f363a50d14fec62bc
 2025-09-27 16:13:56 +00:00
drh
54f296389c Rework the bounds calculations on generate_series() in an attempt to 
avoid signed integer overflow when the bounds are ridiculous values.

FossilOrigin-Name: 3d9148c7d7379a34a0c2a33a1eb2562234868bc0b14c3d16990b33e52fd4ebc5
 2025-09-27 15:03:11 +00:00
dan
ba1ee803ee Add experimental implementations of ALTER TABLE commands to add and drop CHECK and NOT NULL constraints. 
FossilOrigin-Name: d939b25d76fe70a3255cfe38097d4489323028cd05e5512a98dce06b48eee445
 2025-09-27 14:59:21 +00:00
stephan
41549103ac ext/wasm/c-pp.c: add #savepoint support. Consolidate how the diverse sqlite3_stmt handles are managed. 
FossilOrigin-Name: b44650f907e9cb4ec908bb7525488e309946fac9d84cdac4cdde730527a440a9
 2025-09-27 13:34:02 +00:00
drh
c090488133 Use sqlite3_malloc64() and sqlite3_realloc64() everywhere in the CLI. 
FossilOrigin-Name: b05c47009120840f74955114082f3a9c1206a81bd935a503fc359b5bde61c996
 2025-09-27 13:00:37 +00:00
drh
943324c80d Fix a bug in the ".dbtotxt" command of the CLI that causes a NULL pointer 
dereference if run on an in-memory database.

FossilOrigin-Name: 865352499223c3bdc5cb01a2f984d6e3fe74a028ab6a0cf2d92fec49383633f6
 2025-09-27 12:35:25 +00:00
drh
18af487597 Avoid integer overflow in memory allocation for the 
".import --csv" command in the CLI.

FossilOrigin-Name: a8093d45e0f59fd55ea4cba515e9e2eb3683bb0a4f4c062747cfb4074ae3db73
 2025-09-27 12:29:28 +00:00
drh
15e4074084 Additional cleanup and refinement of the regexp.c extension. 
FossilOrigin-Name: 2b34b750b5528b6dda195bc1a3895dc3fe46e70cbf992a78111316e2726c1ade
 2025-09-27 11:54:49 +00:00
stephan
4ac2118c5d Teach c-pp how to replace configure-script-like @tokens@, giving us a much simpler way to get the proper WASM file name injected into each JS build. 
FossilOrigin-Name: ffd5c8eaa89250a043b573c3eb66693dfec087a5b5eef184ae6d7bfbcf61235a
 2025-09-27 11:38:35 +00:00
stephan
4bdfae9d40 Remove and edit some comments. 
FossilOrigin-Name: 1fa7e32d264f8329a8c9b0b5b469f1fc7ccadee86696d65e05df7fa3868af158
 2025-09-27 00:07:25 +00:00
stephan
5d0d30ae2d Add wasm.ptr to the module-symbols.html output. 
FossilOrigin-Name: dced5a7c434b83553ede533f71e3133450795c12fc67acd1a55fdedfa8fed76c
 2025-09-27 00:05:13 +00:00
stephan
836e895f9e Latest upstream c-pp.c for the ability to process multiple inputs and outputs in a single invocation. 
FossilOrigin-Name: c7633373046ceb94f293b8fbd4f436a1eb281c2744d97334c6e7e3a803d8eac2
 2025-09-27 00:04:28 +00:00
stephan
879066a0a2 Delay replacing the wasm file name strings until they're needed. Add target b-all to run all known wasm builds. 
FossilOrigin-Name: a4edaecc9b0b649df53a99e05d9abfbc5bdb40d45c7c6940a50b24fa30dca158
 2025-09-26 19:41:07 +00:00
stephan
e309de27f9 Consolidate some duplicate code in mkwasmbuilds.c. 
FossilOrigin-Name: 1078aa4f1e5685d45e31eea622865ddd077f367f1cec90fc267e8ba50cbe2ee9
 2025-09-26 19:30:34 +00:00
stephan
a34f87d25a Clean up how the speedtest1 64-bit test/demo files are generated. Make log output very slightly less verbose. 
FossilOrigin-Name: 64715e92708e4f8c5b82c1f4ed71b75f418bf741f7f05516eab309582fbfad2b
 2025-09-26 19:19:35 +00:00
stephan
42f9273da2 Get 64-bit builds of speedtest1.wasm running in order to better compare 32-/64-bit performance (spoiler alert: the latter is consistently roughly 10% slower). Add WASM heap usage info to speedtest1. 
FossilOrigin-Name: 70b944cc0189309c2265b184381f2f050bced7b83f204d57b912def6e203982a
 2025-09-26 18:29:00 +00:00
stephan
96c753ec56 Reinstate the Module.instantiateWasm() override and simplify how the wasm filename gets injected into the JS files. 
FossilOrigin-Name: e878ffd2eaa87e2978c44fcd03a1eb6114a9ae31e31101898d682f43cf81000f
 2025-09-26 17:11:39 +00:00
drh
b62c26d999 Limit the complexity of a REGEXP pattern using SQLITE_LIMIT_LIKE_PATTERN_LENGTH 
FossilOrigin-Name: 869c968569b09d05a5b7d587d8fddb3b4611daf7467dc157701e5dc6c9608606
 2025-09-26 15:38:52 +00:00
drh
80d74f0934 In the regexp extension, limit the maximum value of integers in the 
"{p,q}" syntax, as performance of the NFA used to do pattern matching
is linear in the maximum such integer.  The limit is SQLITE_MAX_REGEXP_REPEAT
which defaults to 999.  This helps to prevent DoS attacks in systems that
make use of the regexp extension.

FossilOrigin-Name: 911c745f88c0ee8569e67bbcbbab034264f8c981b505aadac3ce7289486a1a68
 2025-09-26 13:14:20 +00:00