[sqlite] [patch] for test/backup2.test

2017-07-06 Thread Pavel Volkov 
Hello.
Please, make test 'test/backup2.test' more compatible with FreeBSD.
This is patch for it:

--- test/backup2.test.orig  2017-07-07 04:59:34 UTC
+++ test/backup2.test
@@ -143,7 +143,7 @@ do_test backup2-9 {
 #
 if {$tcl_platform(platform)=="windows"} {
   set msg {cannot open source database: unable to open database file}
-} elseif {$tcl_platform(os)=="OpenBSD"} {
+} elseif {$tcl_platform(os)=="OpenBSD"||$tcl_platform(os)=="FreeBSD"} {
   set msg {restore failed: file is encrypted or is not a database}
 } else {
   set msg {cannot open source database: disk I/O error}

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

Re: [sqlite] Incompatibility into configure.ac

2017-04-04 Thread Pavel Volkov 
Hello.
bash it's Bourne again shell. Not Bourne shell. Bash is more then POSIX
shell.
And you forgot the FreeBSD in your listing. As example. It does not use
bash at all.
Thank you.

On Apr 4, 2017 4:34 PM, "Gary R. Schmidt" <grschm...@acm.org> wrote:

> On 04/04/2017 23:20, Richard Hipp wrote:
>
>> On 4/4/17, Pavel Volkov <pavelivol...@googlemail.com> wrote:
>>
>>> The "+ =" operator works as you would expect in bash only.
>>> And it causes an error in the Bourne shell, for example.
>>>
>>
>> You have piqued my curiosity.  Who is still using Bourne shell instead
>> of the Bourne-again shell (bash)?  Bash has been with us now for like
>> three decades, right?
>>
>> Anyone who is supporting Solaris/AIX/HP-UX or older systems.
>
> Is SQLite going the way of "Sure it's portable, it works on Fedora Core
> *and* Ubuntu"???
>
> Cheers,
> GaryB-)
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Incompatibility into configure.ac

2017-04-04 Thread Pavel Volkov 
Hello.
Please, replace the "+ =" operators in the configure.ac file with a
more compatible way of combining strings.
The "+ =" operator works as you would expect in bash only.
And it causes an error in the Bourne shell, for example.
Please, see this patch:

--- configure.ac.orig   2017-04-03 12:16:00 UTC
+++ configure.ac
@@ -596,7 +596,7 @@ AC_ARG_ENABLE(memsys5,
   [enable_memsys5=yes],[enable_memsys5=no])
 AC_MSG_CHECKING([whether to support MEMSYS5])
 if test "${enable_memsys5}" = "yes"; then
-  OPT_FEATURE_FLAGS+=" -DSQLITE_ENABLE_MEMSYS5"
+  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_MEMSYS5"
   AC_MSG_RESULT([yes])
 else
   AC_MSG_RESULT([no])
@@ -606,7 +606,7 @@ AC_ARG_ENABLE(memsys3,
   [enable_memsys3=yes],[enable_memsys3=no])
 AC_MSG_CHECKING([whether to support MEMSYS3])
 if test "${enable_memsys3}" = "yes" -a "${enable_memsys5}" = "no"; then
-  OPT_FEATURE_FLAGS+=" -DSQLITE_ENABLE_MEMSYS3"
+  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_MEMSYS3"
   AC_MSG_RESULT([yes])
 else
   AC_MSG_RESULT([no])
@@ -618,20 +618,20 @@ AC_ARG_ENABLE(fts3, AC_HELP_STRING([--en
   [Enable the FTS3 extension]),
   [enable_fts3=yes],[enable_fts3=no])
 if test "${enable_fts3}" = "yes" ; then
-  OPT_FEATURE_FLAGS+=" -DSQLITE_ENABLE_FTS3"
+  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_FTS3"
 fi
 AC_ARG_ENABLE(fts4, AC_HELP_STRING([--enable-fts4],
   [Enable the FTS4 extension]),
   [enable_fts4=yes],[enable_fts4=no])
 if test "${enable_fts4}" = "yes" ; then
-  OPT_FEATURE_FLAGS+=" -DSQLITE_ENABLE_FTS4"
+  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_FTS4"
   AC_SEARCH_LIBS([log],[m])
 fi
 AC_ARG_ENABLE(fts5, AC_HELP_STRING([--enable-fts5],
   [Enable the FTS5 extension]),
   [enable_fts5=yes],[enable_fts5=no])
 if test "${enable_fts5}" = "yes" ; then
-  OPT_FEATURE_FLAGS+=" -DSQLITE_ENABLE_FTS5"
+  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_FTS5"
   AC_SEARCH_LIBS([log],[m])
 fi

@@ -641,7 +641,7 @@ AC_ARG_ENABLE(json1, AC_HELP_STRING([--e
   [Enable the JSON1 extension]),
   [enable_json1=yes],[enable_json1=no])
 if test "${enable_json1}" = "yes" ; then
-  OPT_FEATURE_FLAGS+=" -DSQLITE_ENABLE_JSON1"
+  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_JSON1"
 fi

 #
@@ -650,7 +650,7 @@ AC_ARG_ENABLE(rtree, AC_HELP_STRING([--e
   [Enable the RTREE extension]),
   [enable_rtree=yes],[enable_rtree=no])
 if test "${enable_rtree}" = "yes" ; then
-  OPT_FEATURE_FLAGS+=" -DSQLITE_ENABLE_RTREE"
+  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_RTREE"
 fi

 #
@@ -659,8 +659,8 @@ AC_ARG_ENABLE(session, AC_HELP_STRING([-
   [Enable the SESSION extension]),
   [enable_session=yes],[enable_session=no])
 if test "${enable_session}" = "yes" ; then
-  OPT_FEATURE_FLAGS+=" -DSQLITE_ENABLE_SESSION"
-  OPT_FEATURE_FLAGS+=" -DSQLITE_ENABLE_PREUPDATE_HOOK"
+  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_SESSION"
+  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_PREUPDATE_HOOK"
 fi

 #

Thanks.
With regards, Pavel.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] freebsd 11 SQLite build: readline/readline.h file not found

2016-10-18 Thread Pavel Volkov 
Hello.
Readline now don't part of FreeBSD. You should add flag -I
/usr/local/include into your compilation process. See flags in the port
database/sqlite3.
PS I'm sorry. I am in vacation now.

On Oct 16, 2016 2:46 AM, "jungle Boogie"  wrote:

> Hi All,
>
> I just re-installed freebsd 11 on a machine of mine and as usual, I
> build sqlite from source. However, I see this:
> sqlite3/src/shell.c:66:11: fatal error: 'readline/readline.h' file not
> found
>
> I'm quite sure I didn't have problems on the 10.x branch with sqlite,
> so I don't know if things in 11.0 were re-arranged.
>
> Readline.h is found here:
> # find / -name readline.h
> /usr/local/include/editline/readline.h
> /usr/local/include/readline/readline.h
> /usr/local/include/guile/2.0/readline.h
> /usr/include/edit/readline/readline.h
>
> The header in shell.c was added 16+ years ago, so this doesn't seem to
> be a new change in sqlite3:
> https://www.sqlite.org/src/info/97a0fb780ea1992c
>
>
> Thanks,
> Sean
>
> --
> ---
> inum: 883510009027723
> sip: jungleboo...@sip2sip.info
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] You may add sha256 checksum for files in the download page?

2016-04-03 Thread Pavel Volkov 
Hello.
I ask for easy check checksum. Not because of the hacking.
Thank you.

On 3 April 2016 at 18:19, Luuk  wrote:
>
>
> On 02-04-16 19:13, Simon Slavin wrote:
>>
>> On 2 Apr 2016, at 11:35am, Pavel Volkov  wrote:
>>
>>> You may add sha256 checksum for files in the download page?
>>
>> SHA1 is so easy to crack now it might make sense to replace the SHA1
>> checksums with SHA256.  Does anyone have a good reason why SHA1 is still
>> needed ?
>>
>>
>
> I do not think the SHA1 codes are there to 'crack' something...
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] You may add sha256 checksum for files in the download page?

2016-04-02 Thread Pavel Volkov 
Hello developers.
You may add sha256 checksum for files in the download page?
(https://en.wikipedia.org/wiki/SHA-2).
sha256 used as default algorithm in the FreeBSD ports tree.
It is would be convenient. Please.
__
With regards, Pavel.

[sqlite] amalgamation sqlite3.c:142353: warning: assignment from incompatible pointer type

2014-01-04 Thread Pavel Volkov 
Hello.
During compilation, the warning occurs

sqlite3.c: In function 'deserializeGeometry':
sqlite3.c:142353: warning: assignment from incompatible pointer type

for the sources of http://www.sqlite.org/2013/sqlite-autoconf-3080200.tar.gz
with -DSQLITE_RTREE_INT_ONLY=1

and really

 142314 /*
 142315 ** This function is called to configure the RtreeConstraint
object passed
 142316 ** as the second argument for a MATCH constraint. The value
passed as the
 142317 ** first argument to this function is the right-hand operand
to the MATCH
 142318 ** operator.
 142319 */
 142320 static int deserializeGeometry(sqlite3_value *pValue,
RtreeConstraint *pCons){
 142321   RtreeMatchArg *p;
 142322   sqlite3_rtree_geometry *pGeom;
 142323   int nBlob;
 142324
 142325   /* Check that value is actually a blob. */
 142326   if( sqlite3_value_type(pValue)!=SQLITE_BLOB ) return SQLITE_ERROR;
 142327
 142328   /* Check that the blob is roughly the right size. */
 142329   nBlob = sqlite3_value_bytes(pValue);
 142330   if( nBlob<(int)sizeof(RtreeMatchArg)
 142331|| ((nBlob-sizeof(RtreeMatchArg))%sizeof(RtreeDValue))!=0
 142332   ){
 142333 return SQLITE_ERROR;
 142334   }
 142335
 142336   pGeom = (sqlite3_rtree_geometry *)sqlite3_malloc(
 142337   sizeof(sqlite3_rtree_geometry) + nBlob
 142338   );
 142339   if( !pGeom ) return SQLITE_NOMEM;
 142340   memset(pGeom, 0, sizeof(sqlite3_rtree_geometry));
 142341   p = (RtreeMatchArg *)[1];
 142342
 142343   memcpy(p, sqlite3_value_blob(pValue), nBlob);
 142344   if( p->magic!=RTREE_GEOMETRY_MAGIC
 142345|| nBlob!=(int)(sizeof(RtreeMatchArg) +
(p->nParam-1)*sizeof(RtreeDValue))
 142346   ){
 142347 sqlite3_free(pGeom);
 142348 return SQLITE_ERROR;
 142349   }
 142350
 142351   pGeom->pContext = p->pContext;
 142352   pGeom->nParam = p->nParam;
 142353   pGeom->aParam = p->aParam;
 |   |
 |   this is "double" or
"sqlite3_int64" depending on the SQLITE_RTREE_INT_ONLY
 |
 this is always "double"

 142354
 142355   pCons->xGeom = p->xGeom;
 142356   pCons->pGeom = pGeom;
 142357   return SQLITE_OK;
 142358 }
 142359

   7347
   7348 /*
   7349 ** A pointer to a structure of the following type is passed as the first
   7350 ** argument to callbacks registered using rtree_geometry_callback().
   7351 */
   7352 struct sqlite3_rtree_geometry {
   7353   void *pContext; /* Copy of pContext passed
to s_r_g_c() */
   7354   int nParam; /* Size of array aParam[] */
   7355   double *aParam; /* Parameters passed to SQL
geom function */
  |
  maybe this field structure must be of type "RtreeDValue"?

   7356   void *pUser;/* Callback implementation
user data */
   7357   void (*xDelUser)(void *);   /* Called by SQLite to clean
up pUser */
   7358 };
   7359

Thank.
___
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-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 <pavelivol...@gmail.com> 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 <d...@sqlite.org> wrote:
>> On Fri, Mar 8, 2013 at 6:00 AM, Pavel Volkov <pavelivol...@gmail.com> 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

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 <d...@sqlite.org> wrote:
> On Fri, Mar 8, 2013 at 6:00 AM, Pavel Volkov <pavelivol...@gmail.com> 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 <d...@sqlite.org> wrote:
> On Fri, Mar 8, 2013 at 5:34 AM, Pavel Volkov <pavelivol...@gmail.com> 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 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 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 <pavelivol...@gmail.com> 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

[sqlite] memsubsys1-8.4...Assertion failed: (EIGHT_BYTE_ALIGNMENT(p)) with --enable-debug

2013-01-11 Thread Pavel Volkov 
Hello.
I'm found next error in tests

memsubsys1-8.3... Ok
memsubsys1-8.4...Assertion failed: (EIGHT_BYTE_ALIGNMENT(p)), function
sqlite3Malloc, file sqlite3.c, line 18891.
*** [test] Signal 6

when compiling sqlite with options

CONFIGURE_ARGS+=--enable-debug
CPPFLAGS+=  -Wall

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

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

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

gcc (GCC) 4.2.1 20070831 patched [FreeBSD]

cpp -dM /dev/null | sort

#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-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 <d...@sqlite.org> wrote:
> On Sat, Jan 5, 2013 at 1:40 AM, Pavel Volkov <pavelivol...@gmail.com> 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] sqlite3.c:134542: warning: assignment from incompatible pointer type

2012-12-24 Thread Pavel Volkov 
Hello. And, excuse my.
1. It is 3.7.15.1 (fossil tag: release)
2. It is trivial and self-documented.

--- ext/rtree/sqlite3rtree.h.orig   2012-12-23 10:02:43.0 +0400
+++ ext/rtree/sqlite3rtree.h2012-12-23 10:03:43.0 +0400
@@ -47,7 +47,11 @@
 struct sqlite3_rtree_geometry {
   void *pContext; /* Copy of pContext passed to s_r_g_c() */
   int nParam; /* Size of array aParam[] */
+#ifdef SQLITE_RTREE_INT_ONLY
+  sqlite3_int64 *aParam;  /* Parameters passed to SQL geom function */
+#else
   double *aParam; /* Parameters passed to SQL geom function */
+#endif
   void *pUser;/* Callback implementation user data */
   void (*xDelUser)(void *);   /* Called by SQLite to clean up pUser */
 };

3. Does not apply to him. My system is:
FreeBSD test 9.1-PRERELEASE FreeBSD 9.1-PRERELEASE #2: Sat Oct 13
11:23:27 MSK 2012 root@test:/usr/obj/usr/src/sys/GENERIC  i386

On Sun, Dec 23, 2012 at 11:49 PM, Larry Brasfield
<larry_brasfi...@iinet.com> wrote:
> Pavel Volkov wrote:
>>
>> Please consider the following error:
>>
>> sqlite3.c: In function 'deserializeGeometry':
>> sqlite3.c:134542: warning: assignment from incompatible pointer type
>>
>> And the patch for it.
>
>
> Three questions arise from your message:
> 1. Which version of sqlite3.c ?  (It's not the latest, apparently.)
> 2. What patch?  (Attachments are lost when posting here.)
> 3. What has this got to do with the referenced post "Sqllite3 dll crash on
> ..."?
>
> --
> Larry Brasfield
>
>
> ___
> 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

[sqlite] sqlite3.c:134542: warning: assignment from incompatible pointer type

2012-12-23 Thread Pavel Volkov 
Hello.
Please consider the following error:

sqlite3.c: In function 'deserializeGeometry':
sqlite3.c:134542: warning: assignment from incompatible pointer type


And the patch for it.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users