database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-08 14:02:16 +03:00
Code Activity
30,066 Commits 1,570 Branches 184 Tags
wasm-column-metadata
Commit Graph

30066 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
3640785453 Add an SQLITE_TESTCTRL_OPTIMIZATION mask that can disable the query planner 
heuristics that are designed to help with star queries.

FossilOrigin-Name: fec4ff185a2f3f1bee8f27432206276636cf27365d2d41cd7282f8c0425f2e96
 2025-01-19 19:14:21 +00:00
stephan
2534bf4011 Initial work towards converting the autoconf bundle to autosetup. Currently non-functional. 
FossilOrigin-Name: d7708372ff2fef4bfa61e56dbfbb363cac7685587a61a151497991d9a08bb07f
 2025-01-19 18:58:09 +00:00
stephan
c6a39debf9 Further refactoring of auto.def to simplify creation of variant builds like the autoconf bundle. 
FossilOrigin-Name: f806c563a29240c709508316846fbe0cb3ed61b68a6c1d9544eb699e30141d8d
 2025-01-19 18:32:45 +00:00
stephan
815709dd00 Minor internal refactoring of auto.def to support the pending autoconf subdir port to autosetup. No functional changes. 
FossilOrigin-Name: 01ff37584708f3f79c62c1b5ed8cceab721cf8348a69a65f0559b1ef8845e85b
 2025-01-19 16:26:25 +00:00
stephan
6cd83aecb9 Move some of the auto.def functions into autosetup/sqlite-config.tcl for re-use in the pending migration of the autoconf bundle to autosetup. This is just reorg, no functional changes. 
FossilOrigin-Name: 2f1e94994f3595baad4045ab05ffee0668059c23ab37a39c25b83c62bfbaea28
 2025-01-19 14:53:45 +00:00
drh
8291cd78f2 Enable automatic query-time indexes for WITHOUT ROWID tables. 
FossilOrigin-Name: 8534af5b94be9f5b1f02453e1c3b6b3f78a698af91595bdbbfdea00676510116
 2025-01-18 23:44:06 +00:00
drh
0f4de9bf9d Add a simple test case (many more are coming soon to TH3). Fix an obsolete 
assert().

FossilOrigin-Name: aa829a131a3431791083cf60d9cf00e7b3c0fafdd39a23e761b629a2287ab875
 2025-01-18 21:19:02 +00:00
drh
50c4420030 Add support for automatic query-time indexes on WITHOUT ROWID tables. 
FossilOrigin-Name: 89c4cbd9529081941d7283a401c4a8d71b241f4577ebf6d3eb2ebe5a1cf92f2e
 2025-01-18 21:00:19 +00:00
stephan
1a1fe1d1da When cross-compiling, change the CFLAGS default to exclude -g, per /chat discussion prompted by [forum:9a67df63eda9925c|forum post 9a67df63eda9925c]. 
FossilOrigin-Name: 4309da2ca5cb99ea81f3034ae3c5809187c0131d21f9f9469ea0d69c941f393e
 2025-01-18 16:05:38 +00:00
stephan
e52cdadea7 When running make install, avoid the -s (strip) flag when cross-compiling, as it only works for the build platform. Reported in [forum:9a67df63eda9925c|forum post 9a67df63eda9925c]. 
FossilOrigin-Name: 230e49c10e3aa6fe9c487a1e026016a8bf97f7e736e7477d5976d987da5e83cf
 2025-01-18 13:51:01 +00:00
drh
e432f2a316 For the purpose of the query planner heuristic added by [38db9b5c83], a query 
should only count as a star query if the fact tables are connected to the
dimension table by an INNER JOIN.  If a LEFT JOIN is used, then the fact
tables are constrained to be in inner loops anyhow and so the heuristic does
not make any sense.  But it does interfere with AUTOMATIC index creation, which
causes the performance regression reported by
[forum:/forumpost/d87570a145599033|forum post d87570a1455].

FossilOrigin-Name: 0852c57ee2768224af79910e6f26e70a4962651dae0f8b45cbfc847e6707d7bb
 2025-01-17 23:49:40 +00:00
drh
f462046cd1 Enhance a comment on a test case to add recent context. 
FossilOrigin-Name: c2647d1bd16fd46dd03953afee6cad44ce14fa2c36713c487b678d63660bc072
 2025-01-17 17:09:42 +00:00
stephan
0887b70286 Typo fix in speedtest.md. 
FossilOrigin-Name: 36027cf340fe2e351c63129d069f9bced090c4a028ffd78d5b8c0f418ad9f230
 2025-01-17 15:56:16 +00:00
drh
ada3470075 Improvements to the speedtest.tcl script. Add documentation on how to use the 
script.

FossilOrigin-Name: eb3853d08141bf941193e8ecaf991191bb7fb46287818708a84018520eb1835e
 2025-01-17 15:39:48 +00:00
drh
e024421624 Add the test/speedtest.tcl script to simplify performance and size testing. 
FossilOrigin-Name: ad7b38672656d0336a73bb789ec83f6939fbdae81e21be68e0313006826dc294
 2025-01-17 12:32:01 +00:00
drh
d0c6c6586e Fix a potential one-byte buffer overrun when reading from the Windows 
console in the CLI. [forum:/forumpost/95e17b8f5c|Forum post 95e17b8f5c].

FossilOrigin-Name: 4d96759694c91301410f53a3f737a049c33e8b259b0954ff659714aff8b21ae8
 2025-01-17 10:39:04 +00:00
drh
1425bae1ab speedtest1: further improvements to the "json" testset. 
FossilOrigin-Name: c4750f7cf7e2188623de8b12e01acf3e3d7dc7b5ea87ac449571eb36f97d842a
 2025-01-16 20:46:08 +00:00
drh
7edb0c3920 speedtest1: Improvements to the "json" testset. Better balance in "mix1". 
FossilOrigin-Name: 2cc73c5e08f1a16fe8accf0af6af061e42d27635883d09234516fd470e99bc0a
 2025-01-16 20:08:59 +00:00
drh
c957673bf7 Revamp the "json" testset in speedtest1. 
FossilOrigin-Name: d33508836bc88314a205bfa9d80f3ebe695163cf0c46d500ad674535975408fb
 2025-01-16 17:19:06 +00:00
drh
bfa7218982 Add the "json" test case to speedtest1 and include it in "mix1". 
FossilOrigin-Name: 2db3a3ee37a9d2fe9b94d16d35c24846c37abe73b89cde4dd763e01a2bfaa8b7
 2025-01-16 14:37:48 +00:00
drh
4a25b740f2 Speedtest1 enhancements: (1) Add the ability to scale performance of 
tests sets using "/NNN" after the testset name, even for testsets in a
comma-separated list.  (2) Add the "mix1" macro testset.

FossilOrigin-Name: 85667b3a572bc9afd8c862a0b2c5f47f76ca80d6e61302ca7d7c1b326d3dd578
 2025-01-16 14:06:29 +00:00
stephan
ec50c5a2a4 wasm: after generating the .js/.mjs file, strip out all of the generated pieces which create Emscripten call() bindings for the sqlite3 APIs, as we don't use those binding, so both the setup time and the memory they use installing WASM proxy bindings is wasted. This eliminates some 200 superfluous/unused bindings from the init process. 
FossilOrigin-Name: 020d2c7528be6f11a5b2b849d7b2f04e47abe2b0842520ff60eb7defb3768e1c
 2025-01-16 13:10:06 +00:00
stephan
b6953280e7 When generating the autoconf snapshot, replaces the Libs.private line from sqlite3.pc.in with one compatible with the legacy build, as reported in [forum:e40b9b424a|forum post e40b9b424a]. 
FossilOrigin-Name: fe47154799bfefb12eb1209d9ada64ecac38bee1b7c3558d175215a2beba991d
 2025-01-16 12:15:51 +00:00
stephan
3202b11f66 Replace use of Emscripten's Module.postRun() with a custom callback so that we get consistent library init timing with both Emscripten 3.1.x and 4.0.x. Details and discussion are in [https://github.com/emscripten-core/emscripten/issues/23420|Emscripten ticket #23420]. 
FossilOrigin-Name: 4863a70ac61ff6f868429f16f0141484ea98f973fde1a9aff879252d0f1dbb6b
 2025-01-16 09:27:40 +00:00
drh
c5dd908c89 When two indexes have the same cost, use the narrower one (the one with the 
smaller average on-disk row width).

FossilOrigin-Name: 398559678f2b9a65b245ed73b4d512c4fccc69d42b5a6a1c1b7755a80b69d073
 2025-01-16 01:47:03 +00:00
drh
65d0312c96 Check-in [da9124fee28c155c] broken the new SQLITE_IOCAP_SUBPAGE_READ mechanism 
for inhibiting direct-overflow-read.  This check-in fixes the problem.

FossilOrigin-Name: 113078d555eaf740666680562ebbb04f7d823b72e8b2d553627e54ab3d7bf653
 2025-01-15 21:13:38 +00:00
stephan
3ba9adc5c1 Teach tool/stripccomments.c that a backslash immediately preceeding a forward slash means that that forward slash cannot be the start of a comment. This is intended to allow JavaScript regular expressions containing \/* (like [https://github.com/emscripten-core/emscripten/issues/23412|the one introduced in emsdk 4.0.0]) to pass through properly. Re-enable comment-stripping in the JS dist builds. 
FossilOrigin-Name: db21d6cc9d1c425deffc0e4e92173caf586e6ac66110c71a4930b21e3e7f84b9
 2025-01-15 21:09:19 +00:00
stephan
c738052394 Work around [https://github.com/emscripten-core/emscripten/issues/23420|a behavior change in emsdk 4.0.0] which breaks the load/init timing of the wasm module. 
FossilOrigin-Name: 00a750184bcf1a94bf4e7f1d5029a42671e87e2997ae97be07bd900d3702883d
 2025-01-15 20:53:14 +00:00
drh
d1047faad6 When choosing between two indexes with the same cost, pick the one with the 
smaller predicted number of bytes per row.

FossilOrigin-Name: d4bd0d4214551f88f248698fefc821575b722ce5c194d0b3796f572e4704f641
 2025-01-15 20:23:22 +00:00
drh
874b5e9fbb Variable names and conditional logic simplified in where.c. These 
changes are cosmetic only and do not affect the resuling machine code.

FossilOrigin-Name: dbc2d6a244fdafd208239894dbdd8f139db6ca20dd8f1ed00d87028e0cb60570
 2025-01-15 19:30:10 +00:00
stephan
73d9eb1bb3 Fix a typo in a wasm makefile var name, noting that this doesn't actually fix anything because the var in question is not used when building 'clean' or 'distclean'. 
FossilOrigin-Name: 7cfc75a625095e41c3e952d4a209fdbb344df0d3dd9b0103e9e6a986dfe53c89
 2025-01-15 15:27:02 +00:00
stephan
4ea86ac0e3 Disable the C-style comment stripper in the JS dist build, as explained in [forum:529c20d344|forum post 529c20d344]. 
FossilOrigin-Name: a9475e7614f8e44252abf273d0e0522c247df12624e40108ce98ad4aaf320f2d
 2025-01-15 14:28:56 +00:00
dan
ff6bff4059 Have windows SQLITE_ENABLE_SETLK_TIMEOUT builds block indefinitely if the busy-timeout is set to 0x7FFFFFFF. 
FossilOrigin-Name: daefcafe799ad7613cbdff1fb1e9d40659892906875b28fbc112abd7679e48ea
 2025-01-15 12:45:38 +00:00
drh
0609cf85fd Change the version number to 3.49.0 to begin the next development 
cycle.  Any patches to 3.48.0 will go on a branch.

FossilOrigin-Name: 8165a3d3a40c5b43275fb4b1cdf57c44a57cd56c514bd2a550deac26a14795eb
 2025-01-14 20:47:23 +00:00
drh
290caec8e3 Trying to remove a warning from some compiler that I do not have access to. 
FossilOrigin-Name: bc6de90c7049dd429a82d32b186a838f4a21aa7b8a83418eaf0416d19771b41e
 2025-01-14 16:10:13 +00:00
drh
942c958769 Version 3.48.0 
FossilOrigin-Name: d2fe6b05f38d9d7cd78c5d252e99ac59f1aea071d669830c1ffe4e8966e84010
version-3.48.0 major-relase relase 		2025-01-14 11:05:00 +00:00
drh
f1747f93e0 Remove a stray tab character from a comment. 
FossilOrigin-Name: 315079b150b47e013e2cde4985bc39d24e0f6f6c6e60f9383fb8ea4ea897c67a
 2025-01-13 13:32:56 +00:00
drh
43afab28a0 GCC 13 has become more quite pedantic about the signature of functions matching the 
type of pointers through which the functions are called.  Make adjustments to
extension functions and test procedures to work around this.  No changes to the
core.

FossilOrigin-Name: ed83b79100b4345235aec990303c4526874f0c2f8701160c4639a80633ebaf70
 2025-01-13 11:28:34 +00:00
drh
14bc98d8e2 Fix harmless "implicit fall through" warnings that suddenly appeared when 
I upgraded to gcc-13.

FossilOrigin-Name: 3e2875dac27de1525d9c78f38ac5f1fc12fec7e1b43dbdf47798b128fae49084
 2025-01-11 16:28:41 +00:00
drh
4b5e8c926a Better job at suppressing harmless scan-build warnings. This time testing 
and working.

FossilOrigin-Name: c847973947de67579fab78a65ecfc90bf59fd5db0b7fa7a9c1abb1fc92213d01
 2025-01-11 14:43:47 +00:00
drh
27661f24cd Fix harmless scan-build warnings. 
FossilOrigin-Name: b93af6feb7c0c3af30a47810a7c0e77ce41c386fac164c64bb5871a6c153db7e
 2025-01-11 13:59:42 +00:00
stephan
c1f914dbc9 Fix an age-old bug in the lower-level wasm/js helper bits which was (A) caused removal of customized WASM func/argument conversion to siltently fail and (B) triggered a warning in the closure toolchain. Reported in [jaccwabyt ticket c5c296e85a7c01360820|https://fossil.wanderinghorse.net/r/jaccwabyt/info/c5c296e85a7c01360820]. 
FossilOrigin-Name: 99917a5bb04b5ad6ace95baf86d91e6ce098f9d3001de1a29d3d0b0b817acdce
 2025-01-11 09:02:55 +00:00
drh
35ac4c8685 Update the makefile so that it puts the amalgamation files in a subdirectory 
in the amalgamation-zip.
[forum:/forumpost/b8dd1941e1|Forum post b8dd1941e1].

FossilOrigin-Name: cef8e88bedf01dc47012ef1cb878b22117c9966e615edf5a69704486f9cfa56c
 2025-01-09 19:57:44 +00:00
dan
b1cbae8bd6 When removing an fts5 in secure-delete mode, defer setting the table version to SECUREDELETE until flushing data to disk. This prevents problems that can occur if there is a rollback or statement rollback operation. 
FossilOrigin-Name: c359e555ceafcaab2ae38074bc4f57cccdc5bc6080d17f82290c09b9e5dd80c2
 2025-01-09 14:10:25 +00:00
dan
c1242d60d9 Fix another assert() failure in fts5. 
FossilOrigin-Name: 6da37893f5b5729ea5fd632e8d98789e867488a67501d4a4dad92f8e7cb6bda0
 2025-01-08 20:43:03 +00:00
dan
ad460db7eb Fix a crash in fts5 that could occur if shadow tables are modified or removed. 
FossilOrigin-Name: c0b691095ae72fc07530777ef6d23688fb4196ce2e0feff14fc3c597c572252d
 2025-01-08 15:54:44 +00:00
drh
af8af121ab Cross-link and otherwise improve the various how-to-compile documents. 
No code changes.

FossilOrigin-Name: 5e6ede92afae77ce6023f3b294dc565651631c7976d898d800988f1b3ff2e83f
 2025-01-08 12:51:28 +00:00
drh
45d19952c3 In the doc/tcl-extension-testing.md document, provide enhanced explanation for 
why the tcl library needs to be copied into the install directory.

FossilOrigin-Name: cff70c859fff37f886fd622b7335a73836ff8cf15e6cb7aabcff449a7e427fa8
 2025-01-08 12:25:33 +00:00
drh
6962f3d814 Further refinement to the Tcl extension testing procedure. 
FossilOrigin-Name: 32b8b078d16b8931afa56e587cf840412c65b68da0bc6fd6280ac773295116cf
 2025-01-07 18:50:19 +00:00
drh
fd11e5c082 Improvements to [14b38ae6ab86a314] so that the Tcl interface is better able 
to work with boolean values in both Tcl86 and Tcl90.

FossilOrigin-Name: 4e85343d6107a46682b549667410c296d7f4d17e3ac04ded7357afcbbfbe3e6d
 2025-01-07 16:36:47 +00:00