I have somewhat of a strange issue with SQLite 3.7.3.
I am cross-compiling the standard SQLite amalgamation 3.7.3 using GCC 3.4.4 on
Linux for a MIPS big endian system. The cross-compiler uses uClibc as the
standard library.
Compilation proceeds with no errors.
I copy the sqlite command line utility executable to the MIPS system and run it
from the command line.
./sqlite3 /tmp/mnt/mydata.db
sqlite> create table tbl1 (one varchar(10));
sqlite> insert into tbl1 values('hello world');
Error: no such table: tbl1
However, if I quit from the sqlite commandline and check my database, I do find
that the tbl1 has been created!!.
SQLite simply thinks that the table is not there however.
If I restart my sqlite3 commandline and reattach to the same database and then
do another insert, it still thinks that the table is not there and reports the
same "no such table" error.
I have tried compilation with a variety of compile flags without any change to
this behavior. I have tried disabling threading support but that doesn't help.
I see no errors and no other debug messages which give me a clue on what could
be wrong.
I am quite willing to debug this issue to figure out why sqlite is unable to
load tables from the existing database if someone can point me in the general
direction / functions in the source I should look at that could cause such
behavior.
Thanks in advance!
Best Regards,
Madhan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
