Below are the warnings/errors that I see on compiling with the options -DSQLITE_INT64_TYPE=int -DSQLITE_32_BIT_ROWID=1
Compilation Output: ------------------- sqlite3.c: In function 'localtimeOffset': sqlite3.c:14443:37: warning: integer overflow in expression sqlite3.c: In function 'parseModifier': sqlite3.c:14523:51: warning: integer overflow in expression sqlite3.c: In function 'strftimeFunc': sqlite3.c:14933:55: warning: integer overflow in expression sqlite3.c: In function 'sqlite3VXPrintf': sqlite3.c:19859:13: warning: left shift count>= width of type sqlite3.c:19860:15: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3AtoF': sqlite3.c:21512:3: warning: left shift count>= width of type sqlite3.c:21527:5: warning: left shift count>= width of type sqlite3.c:21579:7: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3Atoi64': sqlite3.c:21717:3: warning: left shift count>= width of type sqlite3.c:21718:5: warning: left shift count>= width of type sqlite3.c:21733:5: warning: left shift count>= width of type sqlite3.c:21740:7: warning: left shift count>= width of type sqlite3.c:21748:7: warning: left shift count>= width of type sqlite3.c:21749:7: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3PutVarint': sqlite3.c:21840:3: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3GetVarint': sqlite3.c:21981:5: warning: left shift count>= width of type sqlite3.c:22002:5: warning: left shift count>= width of type sqlite3.c:22017:5: warning: left shift count>= width of type sqlite3.c:22035:5: warning: left shift count>= width of type sqlite3.c:22056:3: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3GetVarint32': sqlite3.c:22133:5: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3AddInt64': sqlite3.c:22329:5: warning: left shift count>= width of type sqlite3.c:22334:5: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3SubInt64': sqlite3.c:22341:3: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3MulInt64': sqlite3.c:22356:3: warning: left shift count>= width of type sqlite3.c:22356:11: warning: division by zero sqlite3.c:22357:3: warning: left shift count>= width of type sqlite3.c:22357:12: warning: division by zero sqlite3.c:22358:3: warning: left shift count>= width of type sqlite3.c:22358:11: warning: division by zero sqlite3.c:22359:3: warning: left shift count>= width of type sqlite3.c:22359:12: warning: division by zero sqlite3.c:22367:10: warning: integer overflow in expression sqlite3.c:22368:3: warning: left shift count>= width of type sqlite3.c: In function 'doubleToInt64': sqlite3.c:59129:3: warning: left shift count>= width of type sqlite3.c:59129:3: error: initializer element is not computable at load time sqlite3.c:59130:3: warning: left shift count>= width of type sqlite3.c:59130:3: error: initializer element is not computable at load time sqlite3.c: In function 'sqlite3VdbeIntegerAffinity': sqlite3.c:59226:4: warning: left shift count>= width of type sqlite3.c:59230:4: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3ValueFromExpr': sqlite3.c:59883:7: warning: left shift count>= width of type sqlite3.c:59886:9: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3VdbeSerialType': sqlite3.c:62609:7: warning: left shift count>= width of type sqlite3.c:62621:5: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3VdbeSerialGet': sqlite3.c:62804:7: warning: left shift count>= width of type sqlite3.c:62819:7: warning: left shift count>= width of type sqlite3.c:62819:29: warning: initializer element is not a constant expression sqlite3.c:62828:7: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3VdbeIdxRowid': sqlite3.c:63098:3: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3VdbeExec': sqlite3.c:66710:9: warning: left shift count>= width of type sqlite3.c:66972:9: warning: left shift count>= width of type sqlite3.c:67661:7: warning: left shift count>= width of type sqlite3.c:68934:9: warning: left shift count>= width of type sqlite3.c:69386:11: warning: left shift count>= width of type sqlite3.c:69414:9: warning: left shift count>= width of type sqlite3.c:69425:7: warning: left shift count>= width of type sqlite3.c:69436:7: warning: left shift count>= width of type sqlite3.c:69449:11: warning: left shift count>= width of type sqlite3.c: In function 'codeInteger': sqlite3.c:77450:7: warning: left shift count>= width of type sqlite3.c: In function 'roundFunc': sqlite3.c:87734:3: warning: left shift count>= width of type sqlite3.c:87736:3: warning: left shift count>= width of type sqlite3.c: In function 'randomFunc': sqlite3.c:87848:5: warning: left shift count>= width of type sqlite3.c: In function 'sqlite3Select': sqlite3.c:100614:3: warning: left shift count>= width of type sqlite3.c: In function 'whereCostFromDouble': sqlite3.c:106674:3: warning: right shift count>= width of type sqlite3.c: In function 'sqlite3_initialize': sqlite3.c:115742:5: warning: left shift count>= width of type --- End of output --- Is there some other version of sqlite that I may make use of when compiling with these options, where the width of the datatype is generated as 32 bits accordingly? Thanks, Girish ---------------------------------------- > From: girish.padhar...@outlook.com > To: sqlite-users@sqlite.org > Date: Wed, 7 Aug 2013 10:32:53 +0530 > Subject: Re: [sqlite] Problem with porting Sqlite to Arm embedded platform > > Thanks Richard for your suggestion. > > Well unfortunately, it did not work. Below is the result of the 'Select * > from sqlite_master'. > > The rootpage number is incorrect. The 32-bit higher and lower words are > interchanged. > > > > Output: > ------- > > Callback function called: > type = table > name = episodes > tbl_name = episodes > rootpage = 8589934592 <=== Must be 2 > sql = CREATE TABLE episodes ( > id integer primary key, > season int, > name text ) > > Callback function called: > type = table > name = foods > tbl_name = foods > rootpage = 30064771072 <=== Must be 7 > sql = CREATE TABLE foods( > id integer primary key, > type_id integer, > name text ) > > Callback function called: > type = table > name = foods_episodes > tbl_name = foods_episodes > rootpage = 77309411328 <=== Must be 18 (0x12) > sql = CREATE TABLE foods_episodes( > food_id integer, > episode_id integer ) > > Callback function called: > type = table > name = food_types > tbl_name = food_types > rootpage = 107374182400 <=== Must be 25 (0x19) > sql = CREATE TABLE food_types( > id integer primary key, > name text ) > > > > > Let me see if I can get the source code compiled properly for 32-bit port. I > still find compilation errors for 32 bit related stuff (word size is lesser, > right shift overflow ...) when I use the amalgamation code. > > > > Thanks again, > Girish > > > > ---------------------------------------- >> From: d...@sqlite.org >> Date: Tue, 6 Aug 2013 13:00:57 -0400 >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] Problem with porting Sqlite to Arm embedded platform >> >> On Tue, Aug 6, 2013 at 12:49 PM, Girish Padharthi < >> girish.padhar...@outlook.com> wrote: >> >>> After hours of searching in Google, I came across the right post >>> addressing this issue. (May be it was because I hadn't use the right >>> keywords before). >>> >>> http://marc.info/?l=sqlite-users&m=115557417523637&w=2 >>> >>> >>> http://sqlite.1065341.n5.nabble.com/Problems-with-sqlite-3-3-6-on-ARM-embedded-platform-td12883.html >>> >>> Thanks to anyone who has been trying to solve this problem and thanks to >>> the people who participated in the original post. >>> >>> >>> Could someone please suggest me as to which source files need to be used >>> for this purpose? I assume that the latest tarball should do but cross >>> compiling this in a win32 host fails (as mentioned at the end of the first >>> post). >>> >> >> Are you talking about the goofy mixed-endian values in ARM7, as described >> in this comment: http://www.sqlite.org/src/artifact/a6ea36a9dc?ln=2685-2718 >> >> If you are having that problem, compile using the any recent amalgamation >> (I recommend the prerelease snapshots on the >> http://www.sqlite.org/download.html page) and add the compile-time option: >> -DSQLITE_MIXED_ENDIAN_64BIT_FLOAT >> >> During testing, be sure to compile using -DSQLITE_DEBUG=1 at least once, as >> the comment highlighted above suggests. >> >> -- >> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
