Re: [sqlite] Understanding transactions

2014-02-04 Thread Igor Tandetnik
On 2/4/2014 6:43 PM, Yuriy Kaminskiy wrote: I've checked on 3.8.2, 3.8.1, 3.7.14, 3.7.7; results was exactly same. I've added sqlite3_libversion() output, and it matches expected version in all cases. This is on linux/i386/32-bit. Well, 3.5.9 on Windows 7 works to spec. That's all I know. You

Re: [sqlite] Understanding transactions

2014-02-04 Thread Yuriy Kaminskiy
Igor Tandetnik wrote: > On 2/4/2014 5:51 PM, Yuriy Kaminskiy wrote: >> Igor Tandetnik wrote: >>> On 2/4/2014 11:57 AM, Yuriy Kaminskiy wrote: Phew. Do you speak C? Enjoy. printf("insert...\r"); fflush(stdout); for(i = 0; i < 1000; i++) { rc = sqlite3_bind_i

Re: [sqlite] Understanding transactions

2014-02-04 Thread Igor Tandetnik
On 2/4/2014 5:51 PM, Yuriy Kaminskiy wrote: Igor Tandetnik wrote: On 2/4/2014 11:57 AM, Yuriy Kaminskiy wrote: Phew. Do you speak C? Enjoy. printf("insert...\r"); fflush(stdout); for(i = 0; i < 1000; i++) { rc = sqlite3_bind_int(ins_sth, 1, i); assert(rc == SQLITE_OK);

Re: [sqlite] Understanding transactions

2014-02-04 Thread Simon Slavin
On 4 Feb 2014, at 8:49pm, Igor Tandetnik wrote: > If it is unable to promote the lock, then the in-memory cache will be left in > an inconsistent state and so the error code is promoted from the relatively > benign SQLITE_BUSY to the more severe SQLITE_IOERR_BLOCKED. This error code > promoti

Re: [sqlite] Understanding transactions

2014-02-04 Thread Yuriy Kaminskiy
Igor Tandetnik wrote: > On 2/4/2014 11:57 AM, Yuriy Kaminskiy wrote: >> Phew. Do you speak C? Enjoy. >> >> printf("insert...\r"); fflush(stdout); >> for(i = 0; i < 1000; i++) { >> rc = sqlite3_bind_int(ins_sth, 1, i); >> assert(rc == SQLITE_OK); >> rc = sqlite3_step(ins_sth);

Re: [sqlite] Understanding transactions

2014-02-04 Thread Igor Tandetnik
On 2/4/2014 11:57 AM, Yuriy Kaminskiy wrote: Phew. Do you speak C? Enjoy. printf("insert...\r"); fflush(stdout); for(i = 0; i < 1000; i++) { rc = sqlite3_bind_int(ins_sth, 1, i); assert(rc == SQLITE_OK); rc = sqlite3_step(ins_sth); assert(rc == SQLITE_DO

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.91.0 have begun...

2014-02-04 Thread Joe Mistachkin
If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/";) prior to this coming Friday, February 7th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing li

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

2014-02-04 Thread Joe Mistachkin
Eric Schultz wrote: > > The 1.0.91.0 beta you gave me works perfect in my scenario. Thanks so much! > Any plan for when the final will be out? > The release is currently scheduled for Monday, February 10th (give or take a day or so). -- Joe Mistachkin __

Re: [sqlite] Understanding transactions

2014-02-04 Thread Yuriy Kaminskiy
Igor Tandetnik wrote: > On 2/4/2014 5:23 AM, Yuriy Kaminskiy wrote: >> How sqlite is supposed to behave when >> *) there are read-only transaction; >> *) there are update transaction on other connection; >> *) cache space is exhausted by update transaction; >> *) sqlite was not able to upgrade RESE

Re: [sqlite] sqlite3_column_name() issue with views

2014-02-04 Thread Richard Hipp
On Tue, Feb 4, 2014 at 11:34 AM, Stephan Beal wrote: > On Tue, Feb 4, 2014 at 2:52 AM, Richard Hipp wrote: > > > There is no "intended" behavior. > > http://www.sqlite.org/c3ref/mark/column_name.html?If+there+is+n*fied > > > i assume the broken image at the top of that page qualifies as "uninten

Re: [sqlite] sqlite3_column_name() issue with views

2014-02-04 Thread Stephan Beal
On Tue, Feb 4, 2014 at 2:52 AM, Richard Hipp wrote: > There is no "intended" behavior. > http://www.sqlite.org/c3ref/mark/column_name.html?If+there+is+n*fied i assume the broken image at the top of that page qualifies as "unintended behaviour" ;) http://www.sqlite.org/c3ref/images/sqlite370_ba

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

2014-02-04 Thread Eric Schultz
Joe, The 1.0.91.0 beta you gave me works perfect in my scenario. Thanks so much! Any plan for when the final will be out? Eric On Mon, Feb 3, 2014 at 3:12 PM, Joe Mistachkin wrote: > > Eric Schultz wrote: > > > > I can't seem to build the Interop.SQLite.dll files ("build.bat > > ReleaseNative

Re: [sqlite] Understanding transactions

2014-02-04 Thread Igor Tandetnik
On 2/4/2014 5:23 AM, Yuriy Kaminskiy wrote: How sqlite is supposed to behave when *) there are read-only transaction; *) there are update transaction on other connection; *) cache space is exhausted by update transaction; *) sqlite was not able to upgrade RESERVED lock to EXCLUSIVE due to presenc

Re: [sqlite] Understanding transactions

2014-02-04 Thread Yuriy Kaminskiy
Igor Tandetnik wrote: > On 2/3/2014 3:21 PM, Yuriy Kaminskiy wrote: >> Igor Tandetnik wrote: >>> On 2/3/2014 1:07 PM, Baruch Burstein wrote: 1) How does a transaction affect SELECTs? If I start a transaction and do an UPDATE/DELETE/INSERT, what data will a SELECT in the same tra