Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-06-04 Thread Jim Starkey
On 5/30/2015 10:48 AM, Dmitry Yemanov wrote: > 30.05.2015 11:29, Mark Rotteveel wrote: > >> To better understand the implications of the pull request by Maxim, I'd >> like to know the semantics of isc_tpb_autocommit. Is this documented >> anywhere? > I'm not aware of any place. > >> I'd especially

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-31 Thread Mark Rotteveel
On 30-5-2015 17:13, Vlad Khorsun wrote: >> I'd especially like to know at which point the commit is executed, and >> the impact this has on open resources (cursor, blob, etc). As far as I >> understand commit_retaining is used. What impact does that have on >> visibility of transactions and resourc

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-31 Thread Mark Rotteveel
On 30-5-2015 16:48, Dmitry Yemanov wrote: > Autocommit is executed at the end of every execute/fetch DSQL API call > and every start/send/receive/transact BLR API call, and *only* if that > API call modified some data or posted some event. > > As a side effect, this means that a select from a store

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Vlad Khorsun
30.05.2015 11:29, Mark Rotteveel wrote: > To better understand the implications of the pull request by Maxim, I'd > like to know the semantics of isc_tpb_autocommit. Is this documented > anywhere? AFAIR, no > I'd especially like to know at which point the commit is executed, and > the impact t

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Dmitry Yemanov
30.05.2015 11:29, Mark Rotteveel wrote: > To better understand the implications of the pull request by Maxim, I'd > like to know the semantics of isc_tpb_autocommit. Is this documented > anywhere? I'm not aware of any place. > I'd especially like to know at which point the commit is executed, an

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Dmitry Yemanov
30.05.2015 11:53, Mark Rotteveel wrote: > I'd also like to know when isc_tpb_autocommit was introduced. Somewhen before Firebird was created. Dmitry -- Firebird-Devel mailing list, web interface at https://lists.sour

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Mark Rotteveel
On 30-5-2015 10:29, Mark Rotteveel wrote: > To better understand the implications of the pull request by Maxim, I'd > like to know the semantics of isc_tpb_autocommit. Is this documented > anywhere? > > I'd especially like to know at which point the commit is executed, and > the impact this has on

[Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Mark Rotteveel
To better understand the implications of the pull request by Maxim, I'd like to know the semantics of isc_tpb_autocommit. Is this documented anywhere? I'd especially like to know at which point the commit is executed, and the impact this has on open resources (cursor, blob, etc). As far as I u