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
