Nikola Boyadjiev wrote: >
> Out App was working file until we changed the version to 1.0.89 and then we > started having weird behavior. We checked the database and out code for couple > of days trying to find where the problem is. We ran integrity check on the > database and its fine. I'm sending the files because recreating this issue is > not easy, it doesn't happen all the time. We have no problem with the queries > when using older version of SQLite, > only with v 1.0.89. > >I'm unable to reproduce the issue using the example database and query. >Having >an intermittent issue with query results normally indicates a threading >issue >(e.g. using the same System.Data.SQLite object instance from more than one >thread). Is that a possibility in this case? Can you provide any further >details related to this issue? -- >Joe Mistachkin Hello, Only one thread is using the System.Data.SQLite object. We are using C#, Target Framework - .NET 4 Client Profile, Platform - x86. Until few days ago we were using SQLite v 1.0.81. Then we changed it via NuGet. The NuGet package that we installed is System.Data.SQLite.x86 Version: 1.0.89.0. After we installed this package we started to have problems. After that we reverted back to using v 1.0.81 and the problems stopped. We are also using SQLite Expert Personal v 3.5.5.2423 ( http://www.sqliteexpert.com/download.html ) to view our database. By loading the database that was provided in the link in this tool and executing the query we get the same behavior, only one record from table [Products_UserItems] is returned. We checked out source code, and we get the same behavior from out app and this tool too. Hope this helps, if you need anything else just let me know. I'll try to provide it as fast as possible. Thanks, Nikola _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
