The same warnings happen on Linux (Gentoo 1.4), gcc-3.3.3. The output of your test gives:
----------------------------------------------------------- sqlite> CREATE TABLE tbl(a INTEGER PRIMARY KEY, b INTEGER); sqlite> INSERT INTO tbl VALUES( -1, 1.12589990684e+15 ); sqlite> SELECT * FROM tbl; -1|1125899906840000 ----------------------------------------------------------- Seems there is no problem here. When I tried to do a "make test", it failed with: ----------------------------------------------------------- (...) ./sqlite-cvs/src/test5.c: In function `test_translate': ./sqlite-cvs/src/test5.c:157: warning: passing arg 1 of `Tcl_NewByteArrayObj' discards qualifiers from pointer target type ./sqlite-cvs/src/vdbe.c: In function `sqlite3VdbeExec': ./sqlite-cvs/src/vdbe.c:3022: warning: integer constant is too large for "long" type ./sqlite-cvs/src/vdbe.c:3029: warning: integer constant is too large for "long" type ./sqlite-cvs/src/tclsqlite.c: In function `DbObjCmd': ./sqlite-cvs/src/tclsqlite.c:416: warning: passing arg 3 of `Tcl_GetIndexFromObj' from incompatible pointer type ./sqlite-cvs/src/tclsqlite.c:720: warning: passing arg 1 of `Tcl_NewByteArrayObj' discards qualifiers from pointer target type ./sqlite-cvs/src/tclsqlite.c: In function `DbMain': ./sqlite-cvs/src/tclsqlite.c:1071: warning: passing arg 2 of `Tcl_CreateObjCommand' discards qualifiers from pointer target type /tmp/ccUvOu6w.o(.text+0x15a7): In function `test_bind_int64': ./sqlite-cvs/src/test1.c:1057: undefined reference to `Tcl_GetWideIntFromObj' /tmp/ccUvOu6w.o(.text+0x21ec): In function `test_column_int64': ./sqlite-cvs/src/test1.c:1589: undefined reference to `Tcl_NewWideIntObj' /tmp/ccwYWDx1.o(.text+0xfab): In function `btree_insert': ./sqlite-cvs/src/test3.c:775: undefined reference to `Tcl_GetWideIntFromObj' collect2: ld returned 1 exit status make: *** [testfixture] Error 1 ----------------------------------------------------------- I assume that is normal in this alpha stage, but what do you think? I used "configure --enable-utf8 --enable-incore-db". Regards, ~Nuno Lucas === On 2004-06-19, Daniel K wrote === >Can you try the following experiment and post the >results: > >CREATE TABLE tbl(a INTEGER PRIMARY KEY, b INTEGER); >INSERT INTO tbl VALUES( -1, 1.12589990684e+15 ); >SELECT * FROM tbl; > >and see what happens. If you get the right value >back (-1, 1125899906840000) then I think the warnings >are harmless. > >Thanks, >Dan. > > >--- Hans-Juergen Taenzer ><[EMAIL PROTECTED]> wrote: >> hello, >> >> compiling SQLite 3.0.0 in an cygwin environment I am >> getting compiler >> warnings: >> >> .../sqlite/src/util.c:1175: warning: integer >> constant is too large for >> "long" typ >> .../sqlite/src/vdbe.c:3022: warning: integer >> constant is too large for "long" typ >> .../sqlite/src/vdbe.c:3029: warning: integer >> constant is too large for "long" typ >> .../sqlite/src/vdbeaux.c:1474: warning: integer >> constant is too large for "long" >> .../sqlite/src/vdbeaux.c:1474: warning: integer >> constant is too large for "long" >> >> could I ignore this warnings? >> >> gcc is: gcc version 3.3.1 (cygming special) >> >> Hans-Jürgen Tänzer >> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]