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,519 Commits 1,600 Branches 184 Tags
alter-table-constraints
Commit Graph

30519 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
064a1aa308 Fix harmless compiler warnings. 
FossilOrigin-Name: 963a4c406799fc5352157552bdbbc6a0cc7edf68040e893e9d736ab7224d5a4b
 2025-10-02 16:14:25 +00:00
drh
9abd7edaa7 Merge recent trunk fixes and enhancements into the alter-table-constraints branch. 
FossilOrigin-Name: 26f8a700785edf64e2540b37c748e9f201870865ba70374f8681cdfdd048e68f
 2025-10-02 15:30:26 +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
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
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
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