[yunqa.de] Re: SQLite metadata

  • From: "Radovan Antloga" <radovan.antloga@xxxxxxxx>
  • To: <yunqa@xxxxxxxxxxxxx>
  • Date: Mon, 1 Jun 2009 12:50:30 +0200

Yes, that user was myself. I did add also that this can't
be reproduced with sqlite3.exe. Thank you Ralph for
your assistance and explanation!

Regards,
R.Antloga


----- Original Message ----- From: "Delphi Inspiration" <delphi@xxxxxxxx>
To: <yunqa@xxxxxxxxxxxxx>; <yunqa@xxxxxxxxxxxxx>
Sent: 1. junij 2009 12:21
Subject: [yunqa.de] Re: SQLite metadata


At 14:14 31.05.2009, Delphi Inspiration wrote:

At 16:06 30.05.2009, Radovan Antloga wrote:

I use descendent from TDISQLite3Database because
I have properties like CreateIfNotExists, PageSize,
Pragma, etc. Only difference I see that my component
execute pragmas after connect. So I modified your test.
I just execute pragma synchronous=full. I know default
is full but it can change so this should not be problem.

I can confirm your findings in both Delphi and C code. This makes me believe that it is probably a bug in SQLite.

I sent bug ticket to the SQLite developers and will keep you posted on any responses.

As it stands now, the chief SQLite3 developer (drh) does not regard this as a bug. See his explanation at

 http://www.sqlite.org/cvstrac/tktview?tn=3890

Please also note that at least one other SQLite user sees the current behaviour as problemeatic. Please feel free to add your opionions and arguments to the discussion!

Ralf

_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa



Other related posts: