bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
31,340 Commits 1,672 Branches 385 Tags
fp-performance-v2
Commit Graph

31340 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
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
699959ff25 New test cases for floating-point conversions. 
FossilOrigin-Name: 3033fe97b14ba0531278d4aa444bc5340e044b87a72b3a4341032ddee442000f
 2026-02-21 13:57:40 +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
62546d4b1f In the decimal extension, an optional second argument to the 
decimal() and decimal_exp() functions rounds the value to the
number of significant digits specified by that argument.

FossilOrigin-Name: cb24edf1afc3f9083a4963c5fe232933eccc7c0cb8872aa5fcd336d226b885ef
 2026-02-20 16:21:58 +00:00
stephan
9e395efec6 Fix a cse in the fiddle.debug build where it could not overwrite its read-only/generated index.html. 
FossilOrigin-Name: 7adb2c0f438a97d377760436b1ac81fffab36e541a2b5ee733bfc7108e0180e5
 2026-02-20 14:22:09 +00:00
drh
d447df4205 Add new functions ieee754_to_int() and ieee754_from_int() to the 
ieee754 extension.  No changes to the core SQLite.

FossilOrigin-Name: 8660d3e94cbe892693554df282bce0fa8c7aedbc5e020cab647cbbff3d7e55b7
 2026-02-20 14:20:33 +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
7549e784a8 Minor fixes to tmstmpvfs.c. 
FossilOrigin-Name: 091bd90ed5a6a326fd532e93bd17903e052476da14dc6aee2599a9acf75a3276
 2026-02-17 14:28:18 +00:00
drh
8c3e8dce41 Increase the number of floating-point precision test cases by 9x, and 
increase the require precision to 16 digits.

FossilOrigin-Name: 62c2cf74db5e47f975d1f47818f82f060ddecad4b68c4d4dbc6190cc9a8fc397
 2026-02-17 14:02:27 +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
6315919ba8 Fix a bad assert() in the previous check-in. 
FossilOrigin-Name: a4540582b5b704af13b570b3dc609dbacada719302372a038cf74eee3688d5e7
 2026-02-16 17:22:17 +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
drh
7d49eb1dff Add a "const" to avoid a harmless false-positive compiler warning. 
FossilOrigin-Name: d44af6cc093ab6b5a196249a84681148bbae3f624abf4bc8cc42c88f3f7320b2
 2026-02-13 11:40:28 +00:00
drh
df59c5da78 Respect "const" strings in the sqlite3ShadowTableName() function. 
Patch moved to trunk, where it was intended.

FossilOrigin-Name: 51b5afdfac401cbf74af6383d4559439cb6defe2ce23ebcf7ed9a5b526a07b51
 2026-02-12 18:15:26 +00:00
drh
643fb6cf4b Minor performance enhancement to floating-point rendering. 
FossilOrigin-Name: 38d8c0d8a0b0e9990ba7bdcce979f2824ffee22a083cb788a75917628b1eb559
 2026-02-11 19:42:46 +00:00
drh
c652e34317 Correction to date/time computations associated with the timestamp-vfs. 
FossilOrigin-Name: b67889e4f17c3280f839ee7045256cc47d6ce3ed60d880925e3d30f9ebbcf3ff
 2026-02-10 19:33:11 +00:00
drh
c94f97fac7 Minor tweaks to the star-query optimization in the query planner. 
FossilOrigin-Name: 5021e114b251467fee6a39749c88ec581ee1f7d50093b02a44dc300db0c0a1c5
 2026-02-10 18:28:41 +00:00
drh
1f9ae1f780 Immediately reset all pending prepared statements on any call to 
sqlite3_set_authorizer(), even if the authorizer is being disabled.

FossilOrigin-Name: 5c0468acd1a12f7fd01b9974250fb42c5811939dc2319729a1ef93c073dc0071
 2026-02-09 19:58:04 +00:00
dan
612bee531f Do not allow table-function argument expressions on the RHS of an OUTER join to refer to FROM clause elements to their right. 
FossilOrigin-Name: 021e48e28931afd781e76db6293e60fd2ffb8377cb1051e8b802f2743a10fa5d
 2026-02-09 14:45:17 +00:00
stephan
de702aebb9 Fix a method name typo in test-only code which could hide the triggering error condition. 
FossilOrigin-Name: b2c1a4184c3de5a26524906ba04ce6c9c80b27f8d89c40fde7bbc8f5a9f99e34
 2026-02-08 12:13:19 +00:00
stephan
e45418c5f5 JS doc touchups. 
FossilOrigin-Name: dcd22fd6d135892852358c8cfb5049dce4a1410dbc0f28cafc8b340f69350165
 2026-02-08 05:08:30 +00:00
drh
a0857f321c Improved output from calls to sqlite3ShowSrcList() made from a symbolic debugger. 
FossilOrigin-Name: 241d23f8d36a0d4d0bcf058c5c1ff6144cfe7dd33460e8d94de5f0daf56aaf50
 2026-02-07 13:41:05 +00:00
drh
450a90097f Do a better job of not generating unnecessary Bloom filters associated 
with IN operators.

FossilOrigin-Name: 3861df5c127f82becea80c48c547de8ed0d01eebcf6a6a9d7f234dde31f50394
 2026-02-05 21:14:34 +00:00
drh
e58c1a987c Fix harmless compiler warning when the CLI is compiled with 
SQLITE_OMIT_PROGRESS_CALLBACK.

FossilOrigin-Name: d6150c813ce43e15285a07d24135b10a7c254b3c175dee4f61c3b6a6ce91c29f
 2026-02-05 13:03:04 +00:00
drh
d0c4a5853b Display scanstatus results in neat columns. 
FossilOrigin-Name: c476d956d0bd3065cf894de6f9d393b999ff7d2268a35f01a6d88804789ab58f
 2026-02-04 20:51:27 +00:00
drh
b55d6f3754 Improved output for ".scanstatus est" in the CLI. 
FossilOrigin-Name: e6902937ecdbeb449986469859b46631272fb0a9e7e1c31adea14cff072b6d67
 2026-02-04 18:10:49 +00:00