bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
31,413 Commits 1,672 Branches 385 Tags
opfs-wl
Commit Graph

19872 Commits

Author SHA1 Message Date
drh
18f99f43bc Convert many sqlite3_realloc() calls to sqlite3_realloc64(). 
FossilOrigin-Name: 88dce64242552e7443d9fb496f6f3ad71dc5b4a882ce21b7ef1d5ea4e26f1e61
 2026-03-02 17:11:44 +00:00
drh
72afb50a6d Fix TEMP INSTEAD OF triggers so that they work on TEMP views. 
[forum:/forumpost/2026-02-28T23:33:04z|Forum post 2026-02-28T23:33:04z].

FossilOrigin-Name: 0596bd508f0bc548158858a1dc113af2235d02632ce8c41cd27d1029e1a7e48d
 2026-03-02 15:34:16 +00:00
drh
7fa89ea907 Change some sqlite3_realloc() calls into sqlite3_realloc64(). 
FossilOrigin-Name: a391f5646926787fd9a004225ea406b61d20f282c852c0282fd26cada644b601
 2026-03-02 15:06:59 +00:00
drh
83de60bd7b Simplified rounding logic in sqlite3Fp10Convert2(). 
FossilOrigin-Name: 8ac63ebc5c04ba555bbf0d878a70e25deba5fcc75ff44c464600b92c27e5dcb0
 2026-03-01 20:22:08 +00:00
drh
a000db9754 Code changes in sqlite3Fp10Convert2() for easier maintenance. Does not 
affect the generated machine code.

FossilOrigin-Name: 21c8fc7100e23b632b77934cbbafb98dfd3e6e73bab702446ef6345b378c9d36
 2026-02-28 20:22:10 +00:00
drh
7ac310d0c6 Improvements to power-of-ten computations used for text ↔ binary64 
conversions.

FossilOrigin-Name: 0780bce854b962fb2d4a1a19c55c9b5790a9669f26e1ff8b5f1f1733cfc647e0
 2026-02-27 22:59:46 +00:00
drh
afaf7ea2e4 Minor simplification to the text→binary64 conversion algorithm. 
FossilOrigin-Name: 6632d51f1673e9a6b6e26baebc7aaa1ae27024ad5db1baff6ee5fcf865099f43
 2026-02-27 20:37:03 +00:00
stephan
f707e2ec5d Two code comment typo fixes reported in the forum. No code changes. 
FossilOrigin-Name: 3fbd28fabc5509a0bf2026cb60891d6d3efe251910baa3a3934225d0a7187bfa
 2026-02-27 18:32:12 +00:00
drh
c67a538168 Add an assert() to sqlite3RegisterLikeFunctions() to hopefully prevent 
future false-positive bug reports coming out of CodeQL.

FossilOrigin-Name: 7c5f4dcd748baa60097bbf68d7aca99cc959bb1f7da92bd9ad86a4425a37d391
 2026-02-27 11:36:43 +00:00
drh
5dfccfb0bb Fix typos in the SQLITE_PREPARE_FROM_DDL documentation. 
FossilOrigin-Name: 9174e7dacf867c1f80e73ccf5e0ee7b9e84fbe9f2e53559d06b72206b1cde3c6
 2026-02-26 16:19:21 +00:00
drh
5a6eef2fb2 Improvements to the SQLITE_PREPARE_FROM_DDL documentation. 
FossilOrigin-Name: c3288f16848866a2c846221c33631785f7b39938078bb95c61895f789395aa1d
 2026-02-26 13:35:38 +00:00
drh
8bc78bebfb Fix an inconsequential typo in the output of the datedebug() SQL function. 
FossilOrigin-Name: 3a92a53d8cf77822c22618dbf35851a20d27c4a659d23db2d24e7ccb3f61c7fc
 2026-02-26 12:17:19 +00:00
dan
a86c6017e7 Fix a problem where the wrong collation could be used as part of a row-value comparison between columns with different collation sequences. [forum:/forumpost/6ceca07fc3 | Forum post 6ceca07fc3]. 
FossilOrigin-Name: 212c68249cc0e8904fc36d8e90646d04604f2b3b9d4c32eaeac7d920fa0fba99
 2026-02-26 11:03:22 +00:00
drh
1a152ea92a The GCC bug is fixed in GCC-15. 
FossilOrigin-Name: 21f9abe6c9d1e2ce99ed75c2984103dcd2356b5d53bca3f3732176bb856bf3f7
 2026-02-25 21:19:20 +00:00
drh
f45c695471 Reinstant the work-around for [https://gcc.gnu.org/bugzilla/show_bug.cgi?id=96270|GCC compiler bug 96270] 
which is apparently still an issue as of gcc 13.3.0 with -m32 on Mint Linux.
The test case in the bug report is fixed, but the vdbeMemRenderNum() routine
in SQLite still shows the problem.

FossilOrigin-Name: 7fae321095ebec775de1b39b974fb1f295d5efbd5723e9cb29a981c97a4262c8
 2026-02-25 12:44:19 +00:00
drh
46bf39e396 Use a 64-bit hash for the testing option SQLITE_CHECK_PAGES to maintain 
page alignment.

FossilOrigin-Name: 75a35cd8f97f8a6cd2311c829685bd3b1cfb394de15174aef347f15cfb1913a1
 2026-02-25 01:04:22 +00:00
drh
9d65290207 Rename SQLITE_ENABLE_MULTITHREADED_CHECKS to SQLITE_THREAD_MISUSE_WARNINGS. 
Run test cases with that option. Also add the
SQLITE_THREAD_MISUSE_ABORT option.

FossilOrigin-Name: be8c8b9cb7b618a1571a988bc1cfdc15d99a8bf144d699385c0076e940b9f7f5
 2026-02-24 19:37:16 +00:00
drh
da67225f04 Fix an assert() that is incorrect when the SQLITE_DBCONFIG_FP_DIGITS setting 
is on a non-default value.

FossilOrigin-Name: 3ca1ed81c4fa41f5f9fdbebf0929dd8421a4e29f95764fe1027d4d8706a41480
 2026-02-23 19:51:54 +00:00
drh
ffd9892a02 Change the SQLAR archive extraction algorithm in the CLI so that it 
uses the newly enhanced realpath() SQL function to guard against
attacks that use symlinks to try to write files outside of the
destination directory.
[forum:/forumpost/641b09daa17d9086|Forum post 641b09daa17d9086].

FossilOrigin-Name: 7cced53e8c508fbf1816162c5358c77a712f76a38fd18f07171efc3c028a3c57
 2026-02-23 12:19:05 +00:00
drh
9dac613f04 When doing an SQLAR archive extraction in the CLI, postpone creating symlinks until after 
all files and directories have been created.  This prevents a hostile archive from
creating a symlink through which it can subsequently write content outside of the target
directory.  [forum:forumpost/9e176adfef91c207|Forum post 9e176adfef91c207].

FossilOrigin-Name: 9719034d4d3becda127dc294f7f58ded9c982509c690dd55b56310912957eb51
 2026-02-23 01:34:14 +00:00
drh
60f132bf12 Fix typos and include wording in the documentation for 
SQLITE_DBCONFIG_FP_DIGITS.

FossilOrigin-Name: c30cee1224904eb2092daa0ad9494aec7c7a8c6c1661f5b91b62c3ef0c5ea95b
 2026-02-21 21:19:41 +00:00
drh
8642ca2025 New sqlite3_db_config(SQLITE_DBCONFIG_FP_DIGITS) that let's the application 
specify the number of significant digits that double→text conversions
will attempt to preserve.

FossilOrigin-Name: 3f16985dcc47a366b54164c5024f920a79dddd76faeac5e36b4770732ed72c0a
 2026-02-21 19:26:58 +00:00
drh
7aba858597 Remove an unreachable branch. 
FossilOrigin-Name: 93f90eacc0c5b2ae0042ec525359298883f8473e24967208feef4029d9fa2d08
 2026-02-21 13:40:07 +00:00
drh
4428aa842c Increase the precision of double → text conversions that happen in 
sqlite3_column_text(), or sqlite3_value_text(), or in the CAST() operator,
or similar, so that round-tripping the value back to double results in
exactly the same value.

FossilOrigin-Name: ef0049e3ade304f64e1ab97e52e1e21379e4db461f3fa80dac8e544fb90d622f
 2026-02-21 10:57:02 +00:00
drh
24ef9fbb19 Further simplification, performance gain, and size reduction in 
sqlite3FpDecode().

FossilOrigin-Name: 5954f22ceb6b43ed160ec085cd86b66299d8aab3e349a41941a4f1c2eade7457
 2026-02-21 00:56:11 +00:00
drh
aec283385e Small performance increase and size reduction in sqlite3FpDecode() by using 
local variables instead of structure elements.

FossilOrigin-Name: b4c378bba582205aa676e45b21ffa17ad6199e2a017ec73cf41a0243f693b589
 2026-02-21 00:20:29 +00:00
drh
ac5ee556eb Inconsequential changes to floating-point conversion, amounting to mere 
code cleanup to aid comprehension.

FossilOrigin-Name: 6d9c29123b6b143b0f7c8f5d018f170c72edfc5b1a4d67edd45e5552def2af6c
 2026-02-20 20:43:25 +00:00
drh
20c65785cd Improved rounding of floating-point conversions in some corner cases. 
FossilOrigin-Name: 436dccd42650a6ab0a74459ae42fdb3e36d853f934324acc2bc961f87c001852
 2026-02-20 12:27:52 +00:00
drh
e8750019c2 In the CLI, the ".quit" command in a --cmd argument causes an immediate 
exit.  [forum:/forumpost/f057122b68|Forum post f057122b68].

FossilOrigin-Name: 4731cc8856aa4dcfad5db501648bfd0afef43d8c5f339e7b11a1e3ee64348b87
 2026-02-19 17:20:40 +00:00
drh
cac09127e1 Improvements to rounding behavior in the new floating-point conversion logic. 
FossilOrigin-Name: e540f6c370675ae043af8cdbb80f7eb17c08e50f7634e0b78f0b1dccf7bd4b18
 2026-02-19 12:59:42 +00:00
drh
37ee141d25 Restore the CLI function dtostr() back to its original purpose of converting 
floating point values to decimal using the host computer's C-library.

FossilOrigin-Name: f3cc05ba7fa9cb77573de5cd28ab90f10844567692ed57a706c5dc35b1348009
 2026-02-17 20:28:25 +00:00
drh
31d4e56b29 Fix a harmless compiler warning from MSVC. 
FossilOrigin-Name: 12f3a6d0aaff8818c427d79e2b9394328625b3a60ccaa7b628d064084c65cfaf
 2026-02-17 12:23:12 +00:00
drh
530f536ce7 New assert()s for the return value from sqlite3SchemaToIndex(). 
FossilOrigin-Name: 2610105a439e25c050b2deb32953861187c81b1d97407f41dc188e6627e0ac4d
 2026-02-17 11:28:48 +00:00
drh
eb8c4c5742 Further simplifications, performance improvements, and size reductions 
to the numeric to text conversion logic.

FossilOrigin-Name: dd5af703e1082951a4295a3453611db12b23cfbcfee4258ec3985abe96ab54ba
 2026-02-17 01:04:23 +00:00
drh
0b5e944480 Faster conversion of integers to text, by converting two digits at a time. 
FossilOrigin-Name: 90300e02f0de45b57d53976cae72928b3e56532d90b8b8cdc988e14762777930
 2026-02-17 00:37:12 +00:00
drh
63338e3ba8 Simplifications to sqlite3AtoF(), resulting in slightly faster performance 
and slightly smaller size.

FossilOrigin-Name: 6b9ab641763bc1620a01beec71589506b3b0827bff1c6cd98a5d17c6070050b3
 2026-02-16 23:52:51 +00:00
drh
5c977eaa0a Refactor the sqlite3AtoF() routine so that it requires a zero-terminated 
UTF-8 input.  When the need arises to convert UTF16 or non-terminated
strings, wrapper functions are used.  Together, this makes the code slightly
smaller and faster.

FossilOrigin-Name: 67c7c72e9bdf04c920d77006538a202c923fa74b47c81dc3014c2929dac7277d
 2026-02-16 16:56:59 +00:00
dan
1105c33900 Fix another case where SQLite might fail to identify an ON clause on a RIGHT or FULL join that refers to FROM-clause elements to its right. 
FossilOrigin-Name: e956b36063e77b5ad0d8b8afb5dc942665f570d762929ff277e320c06ded8ce6
 2026-02-16 16:56:25 +00:00
dan
7b93f1a387 Fix a problem with identifying ON clauses attached to RIGHT or FULL JOINs (which is an error) if the join appeared in a flattened sub-query. 
FossilOrigin-Name: cf2dc6dfad275dad8fef763a57baaaf6301b0d3bf1916be90f22200cbe0115d0
 2026-02-16 11:59:14 +00:00
drh
c47bc0ffca Performance improvement in floating-point conversions. 
FossilOrigin-Name: b5ebbd004183f81902fa79a143222204b33dbe1cacb918194556b8dac67bd567
 2026-02-16 11:14:59 +00:00
drh
adbb756155 Avoid the big power-of-ten lookup table. 
FossilOrigin-Name: 245ac7d9ec61e14fcef13a731e290fc5e8979efef6f4345f875eab9b882b0713
 2026-02-15 18:41:29 +00:00
drh
658908a32f Fix to [9d3a12d3926d55ef] to force the static const string literal to 
have two-byte alignment.  Necessary to get that patch to work in Mac-ARM.

FossilOrigin-Name: a80c847169f307a4d2e524b6732ea557bf7f312f1a319d6c6c2e81adb0907596
 2026-02-14 22:04:53 +00:00
drh
b3b2695d4b Add the "LLU" suffix to 64-bit integer constants, for portability to older 
compilers.

FossilOrigin-Name: 4bf08110662c4b8db9ee90ce34271890a62a469166ea292f7f782b84236531d4
 2026-02-14 21:47:08 +00:00
drh
775e4b7073 Fix to the generic version of the 128-bit multiple subroutine. 
FossilOrigin-Name: 9c3d09ee75beb26447161c0bf5ea252520a6ec051774f1a4e9f18204281d504f
 2026-02-14 21:31:31 +00:00
drh
4bee65dcb9 Another minor performance refinement. 
FossilOrigin-Name: 9d3a12d3926d55efffdc84bff342bd1dbccd08426104aeb2d339b064bf6f02f4
 2026-02-14 20:48:58 +00:00
drh
4d0611c1eb Minor corrections. 
FossilOrigin-Name: 93fdee20021b8cc2a113ea042fedbccd8b53b6aceeeb34c0810e6d3a5f106f07
 2026-02-14 19:42:55 +00:00
drh
10fb1e3077 Improved comment. No code changes. 
FossilOrigin-Name: c5a4da1bf7af8f8ec4b3273f88b09c01ce90986c8a5ce3d03319bd094706c411
 2026-02-14 19:36:41 +00:00
drh
db84cdb747 Use a precomputed table of 696 powers of 10 to improve the performance 
of floating-point to decimal and decimal to floating-point conversions.

FossilOrigin-Name: 64d9b7becf2da8927024adda278e837a46837e46af3cff51bd54a183d1716750
 2026-02-14 17:58:46 +00:00
drh
990d861038 Add new assert() statements to demonstrate that the complaint given in 
[forum:/forumpost/56ad8b632c|forum post 56ad8b632c] is not a real bug.

FossilOrigin-Name: d62999907d5f5987fe0030e1a4a7144c898e55595ac116eec966741a5099322b
 2026-02-13 16:02:27 +00:00
drh
23e57bc7cd Use only a single bit, rather than a whole byte, to store infrequently 
accessed boolean values in the Parse object.

FossilOrigin-Name: e1bcd7e1cf6d6b1add49deac65e1b64bcae52fbbad094e561846bb92959db76a
 2026-02-13 12:20:57 +00:00