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]

Reply via email to