Hi Richard, The problem is actually elsewhere. I changed the filesystem and it works fine.
So the problem is not with sqlite but with our special filesystem. Sorry for having raised the alarm too quickly! Best regards, Fabrice -----Original Message----- From: Richard Hipp <d...@sqlite.org> Sender: sqlite-users-bounces@sqlite.orgDate: Tue, 11 Mar 2014 07:27:37 To: General Discussion of SQLite Database<sqlite-users@sqlite.org> Reply-To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] Bug in sqlite? Can't read tables just after creating them On Tue, Mar 11, 2014 at 6:35 AM, <ftrib...@falcon-one.com> wrote: > Hi, > > I found a problem in sqlite. > > In essence, here is what my code does: > 1 - It opens a database file > 2 - If it doesn't find certain tables, it assumes this is a new one and > creates the necessary tables and add a few entries in one of them (let's > call it mytable) > 3 - It queries mytable by doing a 'SELECT xyz, abc FROM mytable;' > > When I run this code on Debian, I don't have any problem. > > When I run it on my evaluation kit (ARM9), step 3 fails saying 'no such > table: mytable'. I found out that closing and then re-opening the database > file works. So I do steps 1 and 2, and close and re-open the database > file, and now step 3 works fine! > > For the time being, I have this workaround of closing/re-opening the > database file, but that's really a kludge. > > Any idea about from where this could come from? > No ideas. Please enable the error and warning log ( http://www.sqlite.org/errlog.html) and see if that provides any further information. > > Many thanks for any ideas! > > Fabrice > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- 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