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
