[sqlite] Possible caching issue between connections with specific inserts

Joe Mistachkin wrote: > > Thanks for the report. I'm looking into it now. > Hi Joe, I hope you are doing well. Did you have a chance to get any feedback about this case? Can you confirm that it is a bug or kind of expected behavior? If it is a bug, is there any chance that it will be fixed

Re: [sqlite] Possible caching issue between connections with specific inserts

Alexey Podogov wrote: > > Also, the issue can't be reproduced if: > - Cache size is set to 0; or > - Journal mode is WAL; or > - Password for database is too short (please see examples in the > demo code). > Thanks for the report. I'm looking into it now. -- Joe Mistachkin

[sqlite] Possible caching issue between connections with specific inserts

Hi SQLite development team. I think that I found a bug in SQLite or in System.Data.SQLite and isolated the case when it happens. In short, the newly added row can be missed if it is requested from another connection. The bug is quite stable and can be reproduced on my demo application each