database/sqlite
database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-05-01 08:24:53 +03:00
Code
29,842 Commits 1,540 Branches 176 Tags
Commit Graph

29842 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
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
drh
ece1729958 Fix a memory error in test logic introduced by [8704034254938662]. 
FossilOrigin-Name: 8a56e98d257e280d308b9fdc26e17e202f00a70fb9a780e30924e87a189fc7f4
 2025-01-07 15:39:57 +00:00
drh
4a83311370 Typo in the previous check-in. 
FossilOrigin-Name: 5872d7a0a7d4959562e1218bbba1115df8b292d980234273d0d38749edf19822
 2025-01-07 15:00:00 +00:00
drh
311990d74e Enhancements to the Tcl SQLite extension testing procedures so that they 
install a full-featured SQLite and so that Tcl is build statically so that
there is no need to worry with LD_LIBRARY_PATH.

FossilOrigin-Name: c8972e652ebe62a8583904b5bc1d96b2d598222c037a714c8ff114ca84b52c7a
 2025-01-07 14:55:49 +00:00
drh
4717d573e4 Make the TCL extension aware of the booleanString type within TCL. 
FossilOrigin-Name: 14b38ae6ab86a314a63ca9513850b43fcc670864f94d03a2706eff469980da88
 2025-01-07 12:14:32 +00:00
drh
e53393250a Fix a typo in the previous check-in. 
FossilOrigin-Name: 7d41885e85b0e2ef28bac34d663af07c35b21ee3e8b14481d2371f623bce681d
 2025-01-07 11:54:43 +00:00
drh
4a6896379f Minor fixes to tclsqlite.c to promote portability. 
FossilOrigin-Name: dd934f032fa6fc790a951006512e3ed76a5f2930858932918eafdbe3ceec4620
 2025-01-07 00:17:54 +00:00
drh
fbbe262820 Enhance the makefile to make it easier to build from a read-only source tree. 
FossilOrigin-Name: f99a70eca2fd8a54be3a6629dabd62efc623488706eed5e5a1bd0be577ac1acb
 2025-01-06 23:33:45 +00:00
drh
885f546f97 Fix a problem with tool/mksqlite3h.tcl that prevents it from running out of 
a read-only check-out.

FossilOrigin-Name: cb54f0063edd284996b225183b8e35d71ffcd3c0fb4f56a0e316181f1a186d46
 2025-01-06 21:36:16 +00:00
drh
a5dbae3781 Fix a minor problem with the sqlite3_get_table_printf() test interface. 
No core changes.

FossilOrigin-Name: a0df29c7a3eb4f558aba00598d827643830591def3101a4d5464543527b8d13c
 2025-01-06 18:32:53 +00:00
dan
cee8b04d33 Add test case for using both SQLITE_CHANGESETAPPLY_IGNORENOOP and SQLITE_CHANGESETAPPLY_FKNOACTION. 
FossilOrigin-Name: b1cc53fa3fb2ac3abeadd3282d8751f4d533315754159f16ca7f7f300ccdd8c8
 2025-01-06 17:01:35 +00:00
drh
f19d7b4de1 Further refactoring of the TCL extension test procedure document, for 
improved clarity and usability.

FossilOrigin-Name: bcdaef434142973a0805117495e561b2dcd1ec1465cacc9b944a3707291afc0d
 2025-01-05 19:58:30 +00:00
drh
15e388d910 Refactor the TCL extension test procedure to deal with TCL8.6 and TCL9.0 
separately, to simplify the procedures and reduce cognative stress on the
tester.

FossilOrigin-Name: 5281536327d244ba9507548f7ed607e86e59b98a003e63f6da767471411c8ffc
 2025-01-05 17:16:33 +00:00
drh
85900c04b0 Fix typo in the tcl-extension-testing.md document. 
FossilOrigin-Name: 28150c615cb601dfc9e4f660627228d6a8a715d64c65f7bc77931c9daf8a0dd7
 2025-01-05 11:40:15 +00:00
drh
8b53358f8f Improvements to TCL extension test procedure description. Improvements to 
the tclextension-list and tclextension-verify makefile targets to suppress
unnecessary output.

FossilOrigin-Name: 3e92fea09af13259d61afd2953fe5f3fc16e3cedfef09e350903aa5299b8e469
 2025-01-05 11:19:32 +00:00
drh
1e03bd8a89 Improvements to testing and validation of the SQLite TCL extension. 
FossilOrigin-Name: 9d7597cad4a167aef7688e85513d8695e8d919e41f5cd44909aefee5ddf13345
 2025-01-04 20:50:21 +00:00
drh
1c1b3a0f2d Show the values of $(JIM_TCLSH) and $(VISUALSTUDIOVERSION) in the 
output of "nmake tcl-env".

FossilOrigin-Name: 4270abc071ced9e7ec1fed3c387262cc1912e321e37e45e547a1088dbb022702
 2025-01-04 20:13:54 +00:00
drh
1388a71690 Allow the 2nd argument to ".param set" to use previously bound parameters, 
as suggested by [forum:/forumpost/823e1bd746|forum post 823e1bd746].

FossilOrigin-Name: 13a35ad792dc0afe1f7b60230aef392ae01e702972b963d732e332f21848f38b
 2025-01-04 19:50:44 +00:00
dan
7a3d03b1fd Fix a problem in the sessions extension allowing changesets containing foreign key violations to be committed under some circumstances. 
FossilOrigin-Name: e09a0c022903d88d5d6de34b2527565ef60c6bb049f2fb42f037e1520abf0f93
 2025-01-04 16:30:05 +00:00
drh
4bf468e69d Add the document describing test procedures for the TCL extension build 
process.  Update the Windows makefile so that it builds the TCL extensions
successfully with a default installation of Tcl8.6.

FossilOrigin-Name: 3263db9249444203b7a9a9f2b0be309c74944315dde7ed192366b709fff93f1b
 2025-01-04 15:52:40 +00:00
drh
8272128211 Adjust the Windows Makefile.msc so that it can build the tclextension with 
Tcl8.6 successfully.  Updates to the tcl-extension test procedure document.

FossilOrigin-Name: 0c2cdc632f26d6acac2d508def4ecfcc97462ebcddc20c84f8847e02e42b3a1d
 2025-01-04 15:51:30 +00:00
drh
8f1bdc0f73 Add new tcl-extension-testing.md document. The Windows side is not yet 
working.

FossilOrigin-Name: 9dc805df1b1c26196ca53baa6b1b8c2f7e59e0150d02ead53228c77a63ad40f4
 2025-01-04 14:10:45 +00:00
drh
ded37f337b Add comment to the columnIsGoodIndexCandidate() routine to record the results 
of a failed experiment.  No changes to code.

FossilOrigin-Name: 9ee57a30a49d9813bf2669a5d8346f7e018e3fbf1792739951311a8d3a249d45
 2025-01-03 11:51:50 +00:00
dan
8d6e3f513c Avoid using Int32x32To64() with a 64-bit argument in fileio.c - this level of micro-optimization is not really necessary there. 
FossilOrigin-Name: 1291b013a8c93e7001fe25783bc98d12f5f7c341d1f728e6852632e18a38af58
 2025-01-03 11:22:01 +00:00
drh
04364cb3cc Improve the treeview output for CteUse objects. 
FossilOrigin-Name: 2b16d6947ca4a102ddab4d5ba3e340a75e1e5c28e45e874ee5ff52f9b5fb964f
 2025-01-02 21:23:25 +00:00