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
stephan
3a94a00768 Get wasmfs build working in the new setup. Disable the custom wasm loader because its generated makefile code is currently broken. 
FossilOrigin-Name: 36bc2514f70af5608aa20903d9c38b316603e2f78f2cbf4a20c7c79b60c5b8d5
 2025-09-26 12:49:41 +00:00
drh
8d2f3a1f82 Fix harmless integer overflows caused by over-sized integer constants in 
the "{m,n}" syntax of the regexp extension.

FossilOrigin-Name: 8f17e1d869685b51f3368feed03dc06543ec16bc8fd81b8daad2ac2dbf99c5d6
 2025-09-26 11:53:54 +00:00
stephan
c839ea5d94 Docs and dead code removal in mkwasmbuilds.c. 
FossilOrigin-Name: d022ee167b90a7c32049a93d476e869270018017f60551185024409730d77640
 2025-09-26 11:47:13 +00:00
dan
6553a5d6a6 Fix some integer overflow problems when handling corrupt hexdb dumps in the shell tool. [forum:/forumpost/82b513b116 | Forum post 82b513b116]. 
FossilOrigin-Name: 730323f95d126162fd2867dbee1e1f1fc1d6e05b8a905a6767c4ab1cb43dacff
 2025-09-26 11:45:13 +00:00
drh
c9f1759c94 Add new table-valued functions jsonb_each() and jsonb_tree() that work just 
like json_each() and json_tree() except that the "value" column is JSONB
instead of JSON text when the "type" is 'object' or 'array'.

FossilOrigin-Name: dfc41cb3aad7fedd834baaaba0d8e3aeb55a249af4f0934397652ea9c59dc9fc
 2025-09-26 11:36:10 +00:00
drh
a7a8d7fa87 Fix a harmless compiler warning. 
FossilOrigin-Name: c50a3c45a20e5b9d48e749818bea06dfa99b729535e0617347c6ece1d277a447
 2025-09-26 11:28:01 +00:00
stephan
e040128ecd In c-pp.c, use (void)x instead of an empty if(x){} to flag unused arguments. 
FossilOrigin-Name: df9ab8a35517e3a2baf4b19d07d46ce3f8b48043ccdeadef22bffc12e80461c3
 2025-09-26 11:14:15 +00:00
drh
92f93556e5 On-demand loading of JSON virtual tables. 
FossilOrigin-Name: 118f97ddcd8f888715825a623c02d42b92a82737a316f7bee4cd66f570945346
 2025-09-26 10:29:07 +00:00
stephan
5ace5e0a38 More build docs. Add a speedtest1 64-bit build but it's not hooked up to any test apps yet. Improve invalid-arg detection in c-pp. 
FossilOrigin-Name: 69086be8a155d70d9dd7b655b66809250b24fe6d5bcdc6cb5e0275446a43f51d
 2025-09-26 02:18:28 +00:00
stephan
c1254430d8 Build cleanups and dead code removal. 
FossilOrigin-Name: b516109e5accc885b71900402c800ae855407552648861334c895f0e5dea4ee5
 2025-09-26 01:38:07 +00:00
drh
3574ec40a6 Add JSON table-valued functions jsonb_each() and jsonb_tree(). 
FossilOrigin-Name: 2f8b461c636ce2c0e7970c00d1e6ea62cdef72273150fea6aabe4e9292724977
 2025-09-25 23:32:23 +00:00
dan
51e3a140c9 Include writes to temp files by sort operations in the SQLITE_DBSTATUS_SPILL values. 
FossilOrigin-Name: 4c1118ba40172af61d9304dec7a9c7344566e6a5963a317880ad232bebb40176
 2025-09-25 19:32:29 +00:00
stephan
ae48a2463b wasm dist: add --snapshot flag, add -64 flag to include 64-bit builds, and add module-symbols.html to the dist. 
FossilOrigin-Name: e9a6391b377b6964620285192262a4dc9fe1712799f7aa8a8b37c5f718544ed2
 2025-09-25 18:53:28 +00:00
stephan
3e7fe489e2 Replace ext/wasm/dist.make with mkdist.sh and get dist working with the new build. Fix the preprocessing flags for tester1-esm.html. 
FossilOrigin-Name: ab6eb4d3b723107da488770b1849b9f1d1c491348f1eaa544e0e07356b8fac7d
 2025-09-25 17:29:12 +00:00
stephan
a4476ea1fa Overhaul the wasm build to (A) support more coexisting variants, e.g. 32/64-bit of both vanilla and esm, and (B) build each variant to its own subdir so that they can build in parallel. It can, with make -j4, now build all new variants in half the time it previously took for just the 32-bit builds. The new build logging output, though unconventional, serves two purposes: (A) improve my build-time situational awareness and (B) it help demystify some of the build steps and output files. 
FossilOrigin-Name: 2f4be98614b49def2c2951887796c736269ef3bb7ba5b045cae5f748ae165a83
 2025-09-25 15:17:58 +00:00
drh
5ad6e7b0e0 Fix the translation of "\v" in JSON5. 
[forum:/forumpost/28e21085f9c6a4e7|Forum post 28e21085f9].

FossilOrigin-Name: 2914e8fc7b10e8b42c9a0fbd0e71f495714cee3cae67b8c238d37b1e7ec22359
 2025-09-25 15:06:57 +00:00
stephan
5dbbbf4923 Remove some superfluous tabs and add the mkwasmbuilds ability to emit just its prologue. 
FossilOrigin-Name: 75079401753778e3bc2f7fa307de9217e8d1ec395079fc1009060f707be32943
 2025-09-25 14:44:03 +00:00
stephan
96d39ce7d2 Minor logging fix for the wasm-opt build step. 
FossilOrigin-Name: 918eca02d162cfa98613f9d8d9b0901f9f94ae1bcb53d811b09baec6c3f06bbe
 2025-09-25 14:39:41 +00:00
stephan
653e32e9a1 Move fiddle.make into the main makefile. Various adjacent cleanups and docs. 
FossilOrigin-Name: fabd6160d0c128592ce512b1160dfa0b89b1fbb03e11cd185c6a4888a85cc7fb
 2025-09-25 14:29:47 +00:00
dan
31efe5a0f2 Avoid an integer overflow in the shell tool when outputing hex dumps of blobs greater than 1GB in size. 
FossilOrigin-Name: 4a1bb874f12adda26e91970b64e700cb904c126412989be4debac9a5647d6f69
 2025-09-25 11:10:55 +00:00
drh
dc868ef879 Convert the ShellText object in the CLI to use sqlite3_malloc64() rather than 
plain malloc().  Avoid unnecessary quoting of table names in .dump output
and similar.  Improved detection of OOM in set_table_name().

FossilOrigin-Name: 6ce4f6dc15a575c318669051fe6590ad114b52ff3f3e260cdf7accccdd922d63
 2025-09-25 10:55:54 +00:00
dan
4d488bd341 Avoid an integer overflow ([forum:/forumpost/b3abe06121 | forum post b3abe06121]) and a compiler warning ([forum:/forumpost/3db6aa9ed6 | forum post 3db6aa9ed6]) in the shell tool code. 
FossilOrigin-Name: 39925489b347ec3126389c6dba1ee719373e50c6cea6944384a212c3a3e163d2
 2025-09-25 10:50:11 +00:00
stephan
3ed76ca35b Minor build cleanups. 
FossilOrigin-Name: 05e7ea021388fcac975779cd2a70e341e25670e70d1d9f372f15b823b2466750
 2025-09-25 02:30:55 +00:00
stephan
99cb0049ee Consolidate the speedtest1 wasm build into the new mkwasmbuilds.c model. Remove the long-unused batch-runner JS tools. 
FossilOrigin-Name: 980c033c05bf37c0e8f5e82486ee99ba1294cc9c9e2087aaf83b64e5d0118b5f
 2025-09-25 02:02:48 +00:00
stephan
ef565295f5 Wasm build deps fixes. 
FossilOrigin-Name: fd0c649047f4e444ea682138a3555a973839627150e1124bb9d9ced17880a9e5
 2025-09-25 00:53:30 +00:00
stephan
9daf58ee8d Move the static makefile code from mkwamsbuilds.c into the makefile. Move util.make back into the main makefile. Remove a bunch of dead makefile code and docs. 
FossilOrigin-Name: 18beeb26bfa48f806866e0e330024535adabcf668071abc4b6251eb39de2701d
 2025-09-24 23:07:45 +00:00
stephan
3675a69f1d Cosmetic makefile tweaks. 
FossilOrigin-Name: 4ec7e6800e090f7e17469a77bc37b57d3e1777171a5b354dfc68345416de504f
 2025-09-24 20:53:19 +00:00
drh
9444c29094 Fix the makefile so that "<tt>test/testrunner.tcl release --buildonly</tt>" 
works on mac.  Apparently broken by [b7751d144330593b].

FossilOrigin-Name: 023365228f3264c53263b649365e7c133d8633010baf6e050fdee044a40454dd
 2025-09-24 20:44:33 +00:00
stephan
6d3ae03f1e Get the tester1 worker1/promiser demos building again. Show WASM heap usage in tester1 if. 
FossilOrigin-Name: 6691a84872f823c95b0bdc3db8e12d21c9561aa1e1ce1d787a977f2c5ef8225a
 2025-09-24 20:39:08 +00:00
drh
b8a62d9da7 Add an assert() to fix a harmless compiler warning in the session extension. 
FossilOrigin-Name: d77b8ad96c695594668cd7019c7f607fe5efa5474dde0ece8b621051cf88a0b5
 2025-09-24 20:09:48 +00:00
drh
1ecc36a2b0 Fix a harmless compiler warning in FTS5. 
FossilOrigin-Name: 89f8d02075a7b265b1f0226a0f878903e1dce27ff1ac2e8a2d62d450b9b4ec76
 2025-09-24 19:51:07 +00:00
drh
2c88a2ffb5 Rework the set_table_name() function in the CLI to use modern APIs. 
[forum:/forumpost/2baa4acd64|Forum post 2baa4acd64].

FossilOrigin-Name: 821cc0e421bc14a68ebaee507e38a900e0c84ff6ba7ee95bf796cad387755232
 2025-09-24 19:10:58 +00:00
drh
96bb92e70c Special case the "decimal(-0.0)" output to show exactly 0.0, just as it 
does for positive zero. 
[forum:/forumpost/adc719d88d56ab22|Forum post adc719d88].

FossilOrigin-Name: 9ca4163bd93d78be5e4daf2b5d2b920d54d038c6fa8217dd2add0be0da6cd6b0
 2025-09-24 17:49:09 +00:00
stephan
892109542b Generate 64-bit variants of tester1.js/html. Enhance c-pp to accept multiple input files. 
FossilOrigin-Name: ef6c55e4499957fb46b213540786e5d3928ec096eae1fe759066ed011518e7a2
 2025-09-24 17:46:08 +00:00
drh
68353d0531 Fix a harmless compiler warning in IEEE754. 
FossilOrigin-Name: 7f72308322cd1f238e6c725ec6bff44ed42fb2619f3f52afe38e2faad838a63f
 2025-09-24 17:38:13 +00:00
drh
2abc502ebc Additional short-circuit optimizations for AND/OR operators. Also fix 
bugs in prior implementations (such as [0083d5169a46104a]).

FossilOrigin-Name: 63b686fe4cb1d5d82dd3a399aaafd1dfcbda533ca83b46ed2bc2750baa7f251d
 2025-09-24 17:07:15 +00:00
drh
dc90d7055c Simplification to the AND/OR short-circuit logic. 
FossilOrigin-Name: 7be555a3b8500c43c2f30171af26bcda9bcb68f41992b792228218a56315e7c4
 2025-09-24 16:26:44 +00:00
dan
2364fe3b38 Improve performance of window function queries that use "BETWEEN :x FOLLOWING AND :y FOLLOWING" where :y is a very large number. 
FossilOrigin-Name: 1f0b7143575634929c0f77bafa888f0be2dd83f0c6c3deadd8299ac4ab8a8c01
 2025-09-24 16:10:46 +00:00
drh
1f030eac9f Fixes to short-circuit AND/OR evaluation. 
FossilOrigin-Name: bc4cadbd60b97d000d2e8be843acab9d82ddf10a8125fd9cc0ae101bb9850091
 2025-09-24 14:43:42 +00:00
stephan
36baed3e2e Add docs to mkwasmbuilds.c explaining the purpose of each of the builds. Remove some inadvertent copy/paste hard tabs in some C-side makefile code. 
FossilOrigin-Name: a2bd965e103026ff5c722357ed9e3432172bbc19d267e718ebd4a876eca41742
 2025-09-24 13:59:53 +00:00
drh
ca574fa1d5 Factor out the code that handles AND and OR short-circuiting into a 
separate subroutine, for performance and legibility.

FossilOrigin-Name: cab84a65c3825c59f3a7a750f4983563ce7ad007125cbcf35c187326289fea89
 2025-09-24 13:10:55 +00:00
drh
feeacfb897 Fix incorrect buffer size computation for the base64() extension function. 
[forum:/forumpost/b1993c858f|Forum post b1993c858f].

FossilOrigin-Name: 603efcd404f0013559ca5bd936fc39481a3aa33a10340bac27b751b6b286d0b7
 2025-09-24 12:01:50 +00:00
drh
b927708437 Restrict the size of the LIMIT on a generate_series() query to avoid 
an integer overflow when computing the final output value.
[forum:/forumpost/479bfb0d3b|Forum post 479bfb0d3b].

FossilOrigin-Name: 266aacb4759945f7cf7a258014620f21225261246edc08e6e71ff5292baf22f3
 2025-09-24 11:12:26 +00:00
stephan
8d93e83461 Cosmetic build tweaks. 
FossilOrigin-Name: 431725330d6c63575dbf3404664a7af33d4d87c569560e99c18de93eb4d73935
 2025-09-24 07:31:19 +00:00
stephan
205257791c Fix the positioning of the wasm-bare-bones flag init. 
FossilOrigin-Name: f5167fb3615efc180e69333f99d82d6afc1d190e7f37b6a701895de00502d8c8
 2025-09-24 07:00:37 +00:00
stephan
4500a87c95 In speedtest1, always use fatal_error() to exit fatally, instead of an fprintf/exit() pair, so that stdout/stderr get flushed consistently (which is significant for the WASM build). 
FossilOrigin-Name: 1bd15cb343f6ce57f108291a8ed0f3ee2046932591d44edec133fe3ea43a2ef0
 2025-09-24 06:59:47 +00:00
stephan
5c01f3fb83 Further wasm build refactoring. Get speedtest1 building again. 
FossilOrigin-Name: 5434307dcd927686ce827da22de55020c4b431f888ac81ae3634d458ad0b563d
 2025-09-24 06:43:24 +00:00
stephan
e779baa099 Move some of the generated wasm makefile utility code out of C and into util.make. 
FossilOrigin-Name: a2935758f534b51cac3d2e5ece74b369c806e3a994781744708e1590b9c32542
 2025-09-24 04:58:14 +00:00
stephan
3b56f296e9 Generic build simplifications. 
FossilOrigin-Name: 61648610c3e454fce77b78e6f6be1b71e27bb9587af03ae5c0e083eac7158a64
 2025-09-24 03:05:31 +00:00
stephan
0dee14a559 Get fiddle building properly again and fiddle/fiddle.debug building in parallel. 
FossilOrigin-Name: 85fe9c6155f72583cea46d38bf5e040623d71fb5317ff9373421dbfdb179b2b0
 2025-09-24 01:50:08 +00:00