b.bum wrote:
do_test format3-11.3 {
execsql {SELECT '123456789012345678901'=='123456789012345678900'}
} {1}
... and the two values are "not equal by inspection". If the test is
expected to pass, why?
The "format3.test" file is used to make sure that the most recent
SQLite library will correctly read and write older databases,
version 2.6.3 and earlier. Version 2.7.0 was published on
2002-August-13. If your databases are newer than that, none
of this applies to you.
In a version 2.6.3 and earlier database, all comparisons between
things that looked like numbers were done numerically - by
converting the numbers into a double and comparing the doubles.
The two numbers in the test above differ in their 20th significant
digit. doubles are only accurate to 17 signficant digits (roughly)
so the two number are indistinguishable.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
