Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-03-09 Thread Pavel Volkov 

FreeBSD 9.1-RELEASE #0 r243826: Tue Dec  4 06:55:39 UTC 2012
r...@obrian.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386

%sqlite3 :memory:
SQLite version 3.7.15.1 2012-12-19 20:39:10
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE TABLE t (a text, b real, c int);
sqlite> select 4.40035364203128e+118;
4.40035364203128e+118
sqlite> select 4.400353642031278e+118;
4.40035364203128e+118
sqlite> select 4.400353642031274e+118;
4.40035364203127e+118
sqlite> select 4.400353642031275e+118;
4.40035364203127e+118  <--- should by
4.40035364203128e+118
sqlite> select 4.400353642031276e+118;
4.40035364203128e+118
sqlite> select 4.40035364203127786031058909193863e+118;
4.40035364203128e+118
sqlite> insert into t
values(4.40035364203127786031058909193863e+118,4.40035364203127786031058909193863e+118,1);
sqlite> select * from t;
4.40035364203128e+118|4.40035364203128e+118|1
sqlite>


FreeBSD 9.1-RELEASE #0 r243825: Tue Dec  4 09:23:10 UTC 2012
r...@farrell.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  amd64

%sqlite3 :memory:
SQLite version 3.7.14.1 2012-10-04 19:37:12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select 4.400353642031275e+118;
4.40035364203128e+118  <--- is the correct result
sqlite>


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-03-08 Thread Pavel Volkov 
And if set tcl_precision ...



#!/usr/local/bin/tclsh8.6

# do_test atof1-1.$i.1

package require platform
puts "\nplatform: [platform::generic]"

set tcl_precision 15

puts "sqlite version: [package require sqlite3]"
sqlite db :memory:

set xf [format %.32e 4.40035364203127786031058909193863e+118]
set x  [expr {1*$xf}]

puts [format "\nxf = %.32e\nx  = %.15e"   $xf $x]
puts [format "\nxf = %.60e\nx  = %.60e\n" $xf $x]

puts [format "db eval \"SELECT \$xf=\\\$x\" : %s" [db eval "SELECT $xf=\$x"]]
puts [format "expr { \$xf == \$x }   : %s\n"  [expr { $xf == $x }]]

puts [format "db eval \"SELECT \$xf\"  = %s" [db eval "SELECT $xf"]]
puts [format "db eval \"SELECT \\\$xf\" = %s" [db eval "SELECT \$xf"]]
puts [format "db eval \"SELECT \\\$x\"  = %s" [db eval "SELECT \$x"]]

db eval "CREATE TABLE t (a text, b real, c int)"
db eval "INSERT INTO t VALUES($xf,\$xf,1)"
db eval "INSERT INTO t VALUES(\$xf,$xf,2)"
db eval "INSERT INTO t VALUES($xf,$xf,3)"
db eval "INSERT INTO t VALUES(\$xf,\$xf,4)"

puts "\ndb eval \"CREATE TABLE t (a text, b real, c int)\"\n"
db eval {SELECT * FROM t} values {
parray values
puts ""
}

db close


FreeBSD 9.1-RELEASE #0 r243826: Tue Dec  4 06:55:39 UTC 2012
r...@obrian.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386
tcl-8.6.0

set tcl_precision 15

platform: freebsd-ix86
sqlite version: 3.7.15.1

xf = 4.40035364203127786031058909193863e+118
x  = 4.400353642031278e+118

xf = 4.400353642031277860310589091938627241607447857305708019118800e+118
x  = 4.400353642031277860310589091938627241607447857305708019118800e+118

db eval "SELECT $xf=\$x" : 0
expr { $xf == $x }   : 1

db eval "SELECT $xf"  = 4.40035364203128e+118
db eval "SELECT \$xf" = 4.40035364203128e+118
db eval "SELECT \$x"  = 4.40035364203128e+118

db eval "CREATE TABLE t (a text, b real, c int)"

values(*) = a b c
values(a) = 4.40035364203128e+118
values(b) = 4.40035364203128e+118
values(c) = 1

values(*) = a b c
values(a) = 4.40035364203128e+118
values(b) = 4.40035364203128e+118
values(c) = 2

values(*) = a b c
values(a) = 4.40035364203128e+118
values(b) = 4.40035364203128e+118
values(c) = 3

values(*) = a b c
values(a) = 4.40035364203128e+118
values(b) = 4.40035364203128e+118
values(c) = 4


FreeBSD 9.1-RELEASE #0 r243826: Tue Dec  4 06:55:39 UTC 2012
r...@obrian.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386
tcl-8.6.0

set tcl_precision 14

platform: freebsd-ix86
sqlite version: 3.7.15.1

xf = 4.40035364203127786031058909193863e+118
x  = 4.400353642031278e+118

xf = 4.400353642031277860310589091938627241607447857305708019118800e+118
x  = 4.400353642031277860310589091938627241607447857305708019118800e+118

db eval "SELECT $xf=\$x" : 0
expr { $xf == $x }   : 1

db eval "SELECT $xf"  = 4.4003536420313e+118
db eval "SELECT \$xf" = 4.4003536420313e+118
db eval "SELECT \$x"  = 4.4003536420313e+118

db eval "CREATE TABLE t (a text, b real, c int)"

values(*) = a b c
values(a) = 4.40035364203128e+118
values(b) = 4.4003536420313e+118
values(c) = 1

values(*) = a b c
values(a) = 4.40035364203128e+118
values(b) = 4.4003536420313e+118
values(c) = 2

values(*) = a b c
values(a) = 4.40035364203128e+118
values(b) = 4.4003536420313e+118
values(c) = 3

values(*) = a b c
values(a) = 4.40035364203128e+118
values(b) = 4.4003536420313e+118
values(c) = 4



On Fri, Mar 8, 2013 at 3:24 PM, Pavel Volkov  wrote:
> Excuse me, the test (test/atof1.test) of sqlite3 distribution, of
> course. It is guilty?
> Or tcl real to text conversation? Why only on the platform x32.
> Thanks.
>
> On Fri, Mar 8, 2013 at 3:10 PM, Richard Hipp  wrote:
>> On Fri, Mar 8, 2013 at 6:00 AM, Pavel Volkov  wrote:
>>
>>> And more tests. Perhaps one of the problems in converting real -> text?
>>>
>>
>> Binary to decimal conversion is *the* problem.  TCL uses an infinite
>> precision integer math library to do exact binary to decimal conversion.
>> SQLite does not have access to such a library and so exact integer to
>> decimal conversion is beyond its reach.
>>
>> I repeat:  SQLite stores and retrieves IEEE floating point values with
>> perfect accuracy.  But it only does binary to decimal conversion of IEEE
>> floating point numbers with 14 or 15 digits of accuracy.  If you need more
>> accuracy than this, use SQLite only for storage and use a different library
>> for your binary to decimal conversion.
>>
>>
>>
>> --
>> D. Richard Hipp
>> d...@sqlite.org
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-03-08 Thread Pavel Volkov 
Excuse me, the test (test/atof1.test) of sqlite3 distribution, of
course. It is guilty?
Or tcl real to text conversation? Why only on the platform x32.
Thanks.

On Fri, Mar 8, 2013 at 3:10 PM, Richard Hipp  wrote:
> On Fri, Mar 8, 2013 at 6:00 AM, Pavel Volkov  wrote:
>
>> And more tests. Perhaps one of the problems in converting real -> text?
>>
>
> Binary to decimal conversion is *the* problem.  TCL uses an infinite
> precision integer math library to do exact binary to decimal conversion.
> SQLite does not have access to such a library and so exact integer to
> decimal conversion is beyond its reach.
>
> I repeat:  SQLite stores and retrieves IEEE floating point values with
> perfect accuracy.  But it only does binary to decimal conversion of IEEE
> floating point numbers with 14 or 15 digits of accuracy.  If you need more
> accuracy than this, use SQLite only for storage and use a different library
> for your binary to decimal conversion.
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-03-08 Thread Pavel Volkov 
Hello again.
This problem was initially detected in the test "test/atof1.test",
only on x32 platform. On x64 it work correct.

On Fri, Mar 8, 2013 at 2:54 PM, Richard Hipp  wrote:
> On Fri, Mar 8, 2013 at 5:34 AM, Pavel Volkov  wrote:
>
>> Hello. This is new test that illustrates the problem:
>>
>
> SQLite only claims to convert floating binary to decimal and back again
> with an accuracy of 14 significant digits.  Going much beyond that requires
> the use of infinite precision integer math, which we have chosen to omit
> from the SQLite library at this time.
>
> SQLite will store and retrieve floating point values with perfect
> accuracy.  Applications that need more than 14 significant digits of
> accuracy in binary to decimal conversion can still use SQLite for storage.
> But binary to decimal conversion should be done using another library.
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-03-08 Thread Richard Hipp 
On Fri, Mar 8, 2013 at 6:00 AM, Pavel Volkov  wrote:

> And more tests. Perhaps one of the problems in converting real -> text?
>

Binary to decimal conversion is *the* problem.  TCL uses an infinite
precision integer math library to do exact binary to decimal conversion.
SQLite does not have access to such a library and so exact integer to
decimal conversion is beyond its reach.

I repeat:  SQLite stores and retrieves IEEE floating point values with
perfect accuracy.  But it only does binary to decimal conversion of IEEE
floating point numbers with 14 or 15 digits of accuracy.  If you need more
accuracy than this, use SQLite only for storage and use a different library
for your binary to decimal conversion.



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-03-08 Thread Pavel Volkov 
And more tests. Perhaps one of the problems in converting real -> text?



#!/usr/local/bin/tclsh8.6

# do_test atof1-1.$i.1

package require platform
puts "\nplatform: [platform::generic]"
puts "sqlite version: [package require sqlite3]"
sqlite db :memory:

set xf [format %.32e 4.40035364203127786031058909193863e+118]
set x  [expr {1*$xf}]

puts [format "\nxf = %.32e\nx  = %.15e"   $xf $x]
puts [format "\nxf = %.60e\nx  = %.60e\n" $xf $x]

puts [format "db eval \"SELECT \$xf=\\\$x\" : %s" [db eval "SELECT $xf=\$x"]]
puts [format "expr { \$xf == \$x }   : %s\n"  [expr { $xf == $x }]]

puts [format "db eval \"SELECT \$xf\"  = %.32e" [db eval "SELECT $xf"]]
puts [format "db eval \"SELECT \\\$xf\" = %.32e" [db eval "SELECT \$xf"]]
puts [format "db eval \"SELECT \\\$x\"  = %.32e" [db eval "SELECT \$x"]]

db eval "CREATE TABLE t (a text, b real, c int)"
db eval "INSERT INTO t VALUES($xf,\$xf,1)"
db eval "INSERT INTO t VALUES(\$xf,$xf,2)"
db eval "INSERT INTO t VALUES($xf,$xf,3)"
db eval "INSERT INTO t VALUES(\$xf,\$xf,4)"

puts "\ndb eval \"CREATE TABLE t (a text, b real, c int)\"\n"
db eval {SELECT * FROM t} values {
parray values
puts ""
}

db close


FreeBSD 9.1-RELEASE #0 r243826: Tue Dec  4 06:55:39 UTC 2012
r...@obrian.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386
tcl-8.6.0

platform: freebsd-ix86
sqlite version: 3.7.15.1

xf = 4.40035364203127786031058909193863e+118
x  = 4.400353642031278e+118

xf = 4.400353642031277860310589091938627241607447857305708019118800e+118
x  = 4.400353642031277860310589091938627241607447857305708019118800e+118

db eval "SELECT $xf=\$x" : 0
expr { $xf == $x }   : 1

db eval "SELECT $xf"  = 4.40035364203127696441269222081694e+118
db eval "SELECT \$xf" = 4.40035364203127786031058909193863e+118
db eval "SELECT \$x"  = 4.40035364203127786031058909193863e+118

db eval "CREATE TABLE t (a text, b real, c int)"

values(*) = a b c
values(a) = 4.40035364203128e+118
values(b) = 4.400353642031278e+118
values(c) = 1

values(*) = a b c
values(a) = 4.40035364203128e+118
values(b) = 4.400353642031277e+118
values(c) = 2

values(*) = a b c
values(a) = 4.40035364203128e+118
values(b) = 4.400353642031277e+118
values(c) = 3

values(*) = a b c
values(a) = 4.40035364203128e+118
values(b) = 4.400353642031278e+118
values(c) = 4


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-03-08 Thread Richard Hipp 
On Fri, Mar 8, 2013 at 5:34 AM, Pavel Volkov  wrote:

> Hello. This is new test that illustrates the problem:
>

SQLite only claims to convert floating binary to decimal and back again
with an accuracy of 14 significant digits.  Going much beyond that requires
the use of infinite precision integer math, which we have chosen to omit
from the SQLite library at this time.

SQLite will store and retrieve floating point values with perfect
accuracy.  Applications that need more than 14 significant digits of
accuracy in binary to decimal conversion can still use SQLite for storage.
But binary to decimal conversion should be done using another library.


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-03-08 Thread Pavel Volkov 
Hello. This is new test that illustrates the problem:



#!/usr/local/bin/tclsh8.5

package require platform
puts "\nplatform: [platform::generic]"
puts "sqlite version: [package require sqlite3]"
sqlite db test.db

set xf [format %.32e 4.40035364203127786031058909193863e+118]
set x  [expr {1*$xf}]

puts [format "\nxf = %.32e\nx  = %.15e"   $xf $x]
puts [format "\nxf = %.60e\nx  = %.60e\n" $xf $x]

puts [format "db eval \"SELECT \$xf=\\\$x\" : %s" [db eval "SELECT $xf=\$x"]]
puts [format "expr { \$xf == \$x }   : %s\n"  [expr { $xf == $x }]]

db close
file delete test.db


FreeBSD 9.1-RELEASE #0 r243825: Tue Dec  4 09:23:10 UTC 2012
r...@farrell.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  amd64
tcl-8.5.13

platform: freebsd-amd64
sqlite version: 3.7.15.1

xf = 4.40035364203127786031058909193863e+118
x  = 4.400353642031278e+118

xf = 4.400353642031277860310589091938627241607447857305708019118800e+118
x  = 4.400353642031277860310589091938627241607447857305708019118800e+118

db eval "SELECT $xf=\$x" : 1
expr { $xf == $x }   : 1


FreeBSD 9.1-RELEASE #0 r243825: Tue Dec  4 09:23:10 UTC 2012
r...@farrell.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  amd64
tcl-8.5.13

platform: freebsd-amd64
sqlite version: 3.7.14.1

xf = 4.40035364203127786031058909193863e+118
x  = 4.400353642031278e+118

xf = 4.400353642031277860310589091938627241607447857305708019118800e+118
x  = 4.400353642031277860310589091938627241607447857305708019118800e+118

db eval "SELECT $xf=\$x" : 1
expr { $xf == $x }   : 1


FreeBSD 9.1-RELEASE #0 r243826: Tue Dec  4 06:55:39 UTC 2012
r...@obrian.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386
tcl-8.5.13

platform: freebsd-ix86
sqlite version: 3.7.15.1

xf = 4.40035364203127786031058909193863e+118
x  = 4.400353642031278e+118

xf = 4.400353642031277860310589091938627241607447857305708019118800e+118
x  = 4.400353642031277860310589091938627241607447857305708019118800e+118

db eval "SELECT $xf=\$x" : 0 <--- this is wrong
expr { $xf == $x }   : 1


FreeBSD 9.1-RELEASE #0 r243826: Tue Dec  4 06:55:39 UTC 2012
r...@obrian.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386
tcl-8.5.13

platform: freebsd-ix86
sqlite version: 3.7.14.1

xf = 4.40035364203127786031058909193863e+118
x  = 4.400353642031278e+118

xf = 4.400353642031277860310589091938627241607447857305708019118800e+118
x  = 4.400353642031277860310589091938627241607447857305708019118800e+118

db eval "SELECT $xf=\$x" : 0 <--- this is wrong
expr { $xf == $x }   : 1


FreeBSD 9.1-RELEASE #0 r243826: Tue Dec  4 06:55:39 UTC 2012
r...@obrian.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386
tcl-8.6.0

platform: freebsd-ix86
sqlite version: 3.7.15.1

xf = 4.40035364203127786031058909193863e+118
x  = 4.400353642031278e+118

xf = 4.400353642031277860310589091938627241607447857305708019118800e+118
x  = 4.400353642031277860310589091938627241607447857305708019118800e+118

db eval "SELECT $xf=\$x" : 0 <--- this is wrong
expr { $xf == $x }   : 1



On Sat, Jan 12, 2013 at 9:07 AM, Pavel Volkov  wrote:
> Hello.
>
> On a 64 bit system, all the tests running are successful.
>
> log compilation
> https://docs.google.com/file/d/0Bz0ZXsXvwY_gc09EeWk1VEktRVk/edit
>
> log testing
> https://docs.google.com/file/d/0Bz0ZXsXvwY_geDlIRWlUSTZTMFE/edit
>
> My operating system:
> FreeBSD fb2.localhost 9.1-PRERELEASE FreeBSD 9.1-PRERELEASE #1
> r244644: Tue Dec 25 10:11:44 MSK 2012
> root@fb2.localhost:/usr/obj/usr/src/sys/ext  amd64
>
> and compiler:
> gcc (GCC) 4.2.1 20070831 patched [FreeBSD]
>
> and "cpp -dM" output:
>
> #define _LONGLONG 1
> #define _LP64 1
> #define __CHAR_BIT__ 8
> #define __DBL_DENORM_MIN__ 4.9406564584124654e-324
> #define __DBL_DIG__ 15
> #define __DBL_EPSILON__ 2.2204460492503131e-16
> #define __DBL_HAS_DENORM__ 1
> #define __DBL_HAS_INFINITY__ 1
> #define __DBL_HAS_QUIET_NAN__ 1
> #define __DBL_MANT_DIG__ 53
> #define __DBL_MAX_10_EXP__ 308
> #define __DBL_MAX_EXP__ 1024
> #define __DBL_MAX__ 1.7976931348623157e+308
> #define __DBL_MIN_10_EXP__ (-307)
> #define __DBL_MIN_EXP__ (-1021)
> #define __DBL_MIN__ 2.2250738585072014e-308
> #define __DEC128_DEN__ 0.1E-6143DL
> #define __DEC128_EPSILON__ 1E-33DL
> #define __DEC128_MANT_DIG__ 34
> #define __DEC128_MAX_EXP__ 6144
> #define __DEC128_MAX__ 9.9E6144DL
> #define __DEC128_MIN_EXP__ (-6143)
> #define __DEC128_MIN__ 1E-6143DL
> #define __DEC32_DEN__ 0.01E-95DF
> #define __DEC32_EPSILON__ 1E-6DF
> #define

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-01-11 Thread Pavel Volkov 
Hello.

On a 64 bit system, all the tests running are successful.

log compilation
https://docs.google.com/file/d/0Bz0ZXsXvwY_gc09EeWk1VEktRVk/edit

log testing
https://docs.google.com/file/d/0Bz0ZXsXvwY_geDlIRWlUSTZTMFE/edit

My operating system:
FreeBSD fb2.localhost 9.1-PRERELEASE FreeBSD 9.1-PRERELEASE #1
r244644: Tue Dec 25 10:11:44 MSK 2012
root@fb2.localhost:/usr/obj/usr/src/sys/ext  amd64

and compiler:
gcc (GCC) 4.2.1 20070831 patched [FreeBSD]

and "cpp -dM" output:

#define _LONGLONG 1
#define _LP64 1
#define __CHAR_BIT__ 8
#define __DBL_DENORM_MIN__ 4.9406564584124654e-324
#define __DBL_DIG__ 15
#define __DBL_EPSILON__ 2.2204460492503131e-16
#define __DBL_HAS_DENORM__ 1
#define __DBL_HAS_INFINITY__ 1
#define __DBL_HAS_QUIET_NAN__ 1
#define __DBL_MANT_DIG__ 53
#define __DBL_MAX_10_EXP__ 308
#define __DBL_MAX_EXP__ 1024
#define __DBL_MAX__ 1.7976931348623157e+308
#define __DBL_MIN_10_EXP__ (-307)
#define __DBL_MIN_EXP__ (-1021)
#define __DBL_MIN__ 2.2250738585072014e-308
#define __DEC128_DEN__ 0.1E-6143DL
#define __DEC128_EPSILON__ 1E-33DL
#define __DEC128_MANT_DIG__ 34
#define __DEC128_MAX_EXP__ 6144
#define __DEC128_MAX__ 9.9E6144DL
#define __DEC128_MIN_EXP__ (-6143)
#define __DEC128_MIN__ 1E-6143DL
#define __DEC32_DEN__ 0.01E-95DF
#define __DEC32_EPSILON__ 1E-6DF
#define __DEC32_MANT_DIG__ 7
#define __DEC32_MAX_EXP__ 96
#define __DEC32_MAX__ 9.99E96DF
#define __DEC32_MIN_EXP__ (-95)
#define __DEC32_MIN__ 1E-95DF
#define __DEC64_DEN__ 0.001E-383DD
#define __DEC64_EPSILON__ 1E-15DD
#define __DEC64_MANT_DIG__ 16
#define __DEC64_MAX_EXP__ 384
#define __DEC64_MAX__ 9.999E384DD
#define __DEC64_MIN_EXP__ (-383)
#define __DEC64_MIN__ 1E-383DD
#define __DECIMAL_DIG__ 21
#define __DEC_EVAL_METHOD__ 2
#define __ELF__ 1
#define __FINITE_MATH_ONLY__ 0
#define __FLT_DENORM_MIN__ 1.40129846e-45F
#define __FLT_DIG__ 6
#define __FLT_EPSILON__ 1.19209290e-7F
#define __FLT_EVAL_METHOD__ 0
#define __FLT_HAS_DENORM__ 1
#define __FLT_HAS_INFINITY__ 1
#define __FLT_HAS_QUIET_NAN__ 1
#define __FLT_MANT_DIG__ 24
#define __FLT_MAX_10_EXP__ 38
#define __FLT_MAX_EXP__ 128
#define __FLT_MAX__ 3.40282347e+38F
#define __FLT_MIN_10_EXP__ (-37)
#define __FLT_MIN_EXP__ (-125)
#define __FLT_MIN__ 1.17549435e-38F
#define __FLT_RADIX__ 2
#define __FreeBSD__ 9
#define __FreeBSD_cc_version 91
#define __GNUC_GNU_INLINE__ 1
#define __GNUC_MINOR__ 2
#define __GNUC_PATCHLEVEL__ 1
#define __GNUC__ 4
#define __GXX_ABI_VERSION 1002
#define __INTMAX_MAX__ 9223372036854775807L
#define __INTMAX_TYPE__ long int
#define __INT_MAX__ 2147483647
#define __KPRINTF_ATTRIBUTE__ 1
#define __LDBL_DENORM_MIN__ 3.64519953188247460253e-4951L
#define __LDBL_DIG__ 18
#define __LDBL_EPSILON__ 1.08420217248550443401e-19L
#define __LDBL_HAS_DENORM__ 1
#define __LDBL_HAS_INFINITY__ 1
#define __LDBL_HAS_QUIET_NAN__ 1
#define __LDBL_MANT_DIG__ 64
#define __LDBL_MAX_10_EXP__ 4932
#define __LDBL_MAX_EXP__ 16384
#define __LDBL_MAX__ 1.18973149535723176502e+4932L
#define __LDBL_MIN_10_EXP__ (-4931)
#define __LDBL_MIN_EXP__ (-16381)
#define __LDBL_MIN__ 3.36210314311209350626e-4932L
#define __LONG_LONG_MAX__ 9223372036854775807LL
#define __LONG_MAX__ 9223372036854775807L
#define __LP64__ 1
#define __MMX__ 1
#define __NO_INLINE__ 1
#define __PTRDIFF_TYPE__ long int
#define __REGISTER_PREFIX__
#define __SCHAR_MAX__ 127
#define __SHRT_MAX__ 32767
#define __SIZE_TYPE__ long unsigned int
#define __SSE2_MATH__ 1
#define __SSE2__ 1
#define __SSE_MATH__ 1
#define __SSE__ 1
#define __STDC_HOSTED__ 1
#define __STDC__ 1
#define __UINTMAX_TYPE__ long unsigned int
#define __USER_LABEL_PREFIX__
#define __VERSION__ "4.2.1 20070831 patched [FreeBSD]"
#define __WCHAR_MAX__ 2147483647
#define __WCHAR_TYPE__ int
#define __WINT_TYPE__ int
#define __amd64 1
#define __amd64__ 1
#define __k8 1
#define __k8__ 1
#define __unix 1
#define __unix__ 1
#define __x86_64 1
#define __x86_64__ 1
#define unix 1
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-01-06 Thread Pavel Volkov 
Hello. This is the output of:

#define _LONGLONG 1
#define __CHAR_BIT__ 8
#define __DBL_DENORM_MIN__ 4.9406564584124654e-324
#define __DBL_DIG__ 15
#define __DBL_EPSILON__ 2.2204460492503131e-16
#define __DBL_HAS_DENORM__ 1
#define __DBL_HAS_INFINITY__ 1
#define __DBL_HAS_QUIET_NAN__ 1
#define __DBL_MANT_DIG__ 53
#define __DBL_MAX_10_EXP__ 308
#define __DBL_MAX_EXP__ 1024
#define __DBL_MAX__ 1.7976931348623157e+308
#define __DBL_MIN_10_EXP__ (-307)
#define __DBL_MIN_EXP__ (-1021)
#define __DBL_MIN__ 2.2250738585072014e-308
#define __DEC128_DEN__ 0.1E-6143DL
#define __DEC128_EPSILON__ 1E-33DL
#define __DEC128_MANT_DIG__ 34
#define __DEC128_MAX_EXP__ 6144
#define __DEC128_MAX__ 9.9E6144DL
#define __DEC128_MIN_EXP__ (-6143)
#define __DEC128_MIN__ 1E-6143DL
#define __DEC32_DEN__ 0.01E-95DF
#define __DEC32_EPSILON__ 1E-6DF
#define __DEC32_MANT_DIG__ 7
#define __DEC32_MAX_EXP__ 96
#define __DEC32_MAX__ 9.99E96DF
#define __DEC32_MIN_EXP__ (-95)
#define __DEC32_MIN__ 1E-95DF
#define __DEC64_DEN__ 0.001E-383DD
#define __DEC64_EPSILON__ 1E-15DD
#define __DEC64_MANT_DIG__ 16
#define __DEC64_MAX_EXP__ 384
#define __DEC64_MAX__ 9.999E384DD
#define __DEC64_MIN_EXP__ (-383)
#define __DEC64_MIN__ 1E-383DD
#define __DECIMAL_DIG__ 17
#define __DEC_EVAL_METHOD__ 2
#define __ELF__ 1
#define __FINITE_MATH_ONLY__ 0
#define __FLT_DENORM_MIN__ 1.40129846e-45F
#define __FLT_DIG__ 6
#define __FLT_EPSILON__ 1.19209290e-7F
#define __FLT_EVAL_METHOD__ 2
#define __FLT_HAS_DENORM__ 1
#define __FLT_HAS_INFINITY__ 1
#define __FLT_HAS_QUIET_NAN__ 1
#define __FLT_MANT_DIG__ 24
#define __FLT_MAX_10_EXP__ 38
#define __FLT_MAX_EXP__ 128
#define __FLT_MAX__ 3.40282347e+38F
#define __FLT_MIN_10_EXP__ (-37)
#define __FLT_MIN_EXP__ (-125)
#define __FLT_MIN__ 1.17549435e-38F
#define __FLT_RADIX__ 2
#define __FreeBSD__ 9
#define __FreeBSD_cc_version 91
#define __GNUC_GNU_INLINE__ 1
#define __GNUC_MINOR__ 2
#define __GNUC_PATCHLEVEL__ 1
#define __GNUC__ 4
#define __GXX_ABI_VERSION 1002
#define __INTMAX_MAX__ 9223372036854775807LL
#define __INTMAX_TYPE__ long long int
#define __INT_MAX__ 2147483647
#define __KPRINTF_ATTRIBUTE__ 1
#define __LDBL_DENORM_MIN__ 7.4653686412953080e-4948L
#define __LDBL_DIG__ 15
#define __LDBL_EPSILON__ 2.2204460492503131e-16L
#define __LDBL_HAS_DENORM__ 1
#define __LDBL_HAS_INFINITY__ 1
#define __LDBL_HAS_QUIET_NAN__ 1
#define __LDBL_MANT_DIG__ 53
#define __LDBL_MAX_10_EXP__ 4932
#define __LDBL_MAX_EXP__ 16384
#define __LDBL_MAX__ 1.1897314953572316e+4932L
#define __LDBL_MIN_10_EXP__ (-4931)
#define __LDBL_MIN_EXP__ (-16381)
#define __LDBL_MIN__ 3.3621031431120935e-4932L
#define __LONG_LONG_MAX__ 9223372036854775807LL
#define __LONG_MAX__ 2147483647L
#define __NO_INLINE__ 1
#define __PTRDIFF_TYPE__ int
#define __REGISTER_PREFIX__
#define __SCHAR_MAX__ 127
#define __SHRT_MAX__ 32767
#define __SIZE_TYPE__ unsigned int
#define __STDC_HOSTED__ 1
#define __STDC__ 1
#define __UINTMAX_TYPE__ long long unsigned int
#define __USER_LABEL_PREFIX__
#define __VERSION__ "4.2.1 20070831 patched [FreeBSD]"
#define __WCHAR_MAX__ 2147483647
#define __WCHAR_TYPE__ int
#define __WINT_TYPE__ int
#define __i386 1
#define __i386__ 1
#define __i486 1
#define __i486__ 1
#define __unix 1
#define __unix__ 1
#define i386 1
#define unix 1


On Sat, Jan 5, 2013 at 4:55 PM, Richard Hipp  wrote:
> On Sat, Jan 5, 2013 at 1:40 AM, Pavel Volkov  wrote:
>
>> Hello. Excuse me.
>> I found the following errors when running tests in the operating
>> system FreeBSD x32: (this is an example)
>>
>
>
> Please send the output of the following command:
>
> cpp -dM /dev/null | sort
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-01-05 Thread Richard Hipp 
On Sat, Jan 5, 2013 at 1:40 AM, Pavel Volkov  wrote:

> Hello. Excuse me.
> I found the following errors when running tests in the operating
> system FreeBSD x32: (this is an example)
>


Please send the output of the following command:

cpp -dM /dev/null | sort

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users