database/sqlite
database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-05-11 13:01:33 +03:00
Code
29,842 Commits 1,544 Branches 177 Tags
Commit Graph

14 Commits

Author SHA1 Message Date
drh
1a4b2117f1 On x64 hardware, round-trip uint64_t→double→uint64_t conversions 
fail for values greater than UINT64_MAX-2047.  This caused the SQLite
text-to-float converter routine to give incorrect results for values
between '1.8446744073709550592eNNN' and '1.8446744073709551609eNNN' for any
exponent NNN.  This problem was introduced by check-in [761d8fd18b0ee868]
and first appeared in version 3.47.0 and was reported by
[forum:/forumpost/569a7209179a7f5e|forum post 569a7209179a7f5e].  Fixed
by this check-in.

FossilOrigin-Name: 81342fa6dd03fffbe7d4d699ff049dcef4d30344578bb6f91cb58a4e5a4f6036
 2024-12-07 14:48:55 +00:00
drh
e8b2c92240 Remove all code that makes use of the C-language "long double" datatype. 
FossilOrigin-Name: f622b52024c8bec1d241b1dc480fbbd839fc1af50b6220f012812503de2c656e
 2024-10-01 20:29:43 +00:00
drh
aa4356da68 Enhance sqlite3AtoF() so that it honors the USELONGDOUBLE test-control. 
Enable the test/atof1.test module on non-intel platforms.

FossilOrigin-Name: b7850fd480535980d66f107c2746e7f7fc0a5379ec8244d84f7785533c83f276
 2023-07-03 18:18:35 +00:00
drh
37b188fbca Fix one constant in the normalization logic. Improved error output 
from atof1.test.

FossilOrigin-Name: d3c48807100a358a70fdd799c8935eba1b765ace2e1ddea4475fd673006cb6da
 2023-07-03 10:00:38 +00:00
drh
c8885d42fe Replace the dodgy error estimating logic in the previous check-in with 
full-up Dekker double-double multiplication, and this idea works much better.
There are still a few inaccuracies, but it is much closer.

FossilOrigin-Name: 4fa6938dac2d3d813a37664053db31451a2a065f78dd212488f5f7f8d583ddc5
 2023-07-03 09:07:23 +00:00
drh
7931f0a3d8 Only run atof1.test on x86_64 machines. 
FossilOrigin-Name: 4173819cd285a1c133645eda27b9f6dc5a2247eaa0c834bdc60058ef3109b102
 2022-03-10 11:48:16 +00:00
drh
359941bd33 Apple the same fix for ticket [9eda2697f5cc1aba] to text-to-integer 
conversions that was done for floating point conversions by
check-in [1c76f1d8ec0937a2].

FossilOrigin-Name: aafb7a21041090e529491b0ce30c3902420be0551b1b2c55840a5fbb9105fb7d
 2020-08-27 16:28:30 +00:00
drh
87969b2a11 When doing a test-to-double conversion on a BLOB with an odd number of bytes 
and assuming a UTF16 encoding, ignore the last byte.
Ticket [9eda2697f5cc1aba].

FossilOrigin-Name: 1c76f1d8ec0937a2d2e4ce75f98494c953e9621db31945d7e44f45d90d1c3892
 2020-01-08 12:17:46 +00:00
drh
2ab410aa1e A different approach to handling integer/float comparisons. This seems to 
work better on systems where "long double" and "double" are the same type,
but still needs refinement and testing.

FossilOrigin-Name: a3f7614b2095fbc1eca54801b2da88f85f294ec5
 2015-11-06 14:59:07 +00:00
drh
dbb3c98ad1 Do not try to run the atof1.test test script on ARM hardware which lacks 
the "long double" type.

FossilOrigin-Name: fafca560f28f526abdf1474c33af94665a65aaf0
 2013-11-26 16:20:28 +00:00
drh
c722a2c2e4 Disable the atof1.test module when compiling on MSVC. 
FossilOrigin-Name: 0f706acfc7181f2714a06b2c232677ebeede3a44
 2012-06-21 15:02:26 +00:00
drh
4ef9413028 Round-trip conversions of real->text->real are now lossless on x64 with GCC. 
Untested on other platforms so far.  Still a corner-case problem with round().

FossilOrigin-Name: fd7bd4a59361be41b10522abc212cf56fb5e35b4
 2012-06-19 03:35:05 +00:00
drh
72b3fbc7b5 Improved accuracy on text-to-real and real-to-text conversions. Most 
conversions now round-trip correctly.  Still need to fix some corner
cases.

FossilOrigin-Name: 8ecffca900cd6a8922001fd458a266ce8c83fb66
 2012-06-19 03:11:25 +00:00
drh
89f15088f0 Improved rounding accuracy on test-to-float conversions. 
FossilOrigin-Name: 699b792c6a0e989994549959b11ec1bfad8bbd92
 2012-06-19 00:45:16 +00:00