Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Adriano dos Santos Fernandes
Vlad and others, Can you look at this? https://github.com/asfernandes/firebird/tree/work/sharing-snapshot It uses the simplest possible (and bad) IPC mechanism to manually test the idea of get the snapshot from others processes. It uses syntax: SET TRANSACTION SHARING SNAPSHOT FROM It is

[Firebird-devel] [FB-Tracker] Created: (CORE-5532) add support for data type TINYINT (byte) Number of 0..255

2017-05-05 Thread Roberto Carlos da Silva (JIRA)
add support for data type TINYINT (byte) Number of 0..255 - Key: CORE-5532 URL: http://tracker.firebirdsql.org/browse/CORE-5532 Project: Firebird Core Issue Type: New Feature

Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Adriano dos Santos Fernandes
On 05/05/2017 14:43, Dmitry Yemanov wrote: > 05.05.2017 20:01, Vlad Khorsun wrote: >> %type snap_shot >> snap_shot >> : SNAPSHOT >> | SNAPSHOT TABLE >> | SNAPSHOT TABLE STABILITY >> +| SNAPSHOT SHARING FROM > SNAPSHOT BASED ON > ? > Do you think with this words it's

Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Adriano dos Santos Fernandes
On 05/05/2017 14:01, Vlad Khorsun wrote: > >It doesn't forces (nor expresses) new transaction isolation level to be > SNAPSHOT. Yes, I forgot to inform it in comment for now. > Probably, it would be more natural to extend "snap_shot" rule in parser: > > iso_mode > : snap_shot >

Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Dmitry Yemanov
05.05.2017 20:01, Vlad Khorsun wrote: > > %typesnap_shot > snap_shot > : SNAPSHOT > | SNAPSHOT TABLE > | SNAPSHOT TABLE STABILITY > + | SNAPSHOT SHARING FROM SNAPSHOT BASED ON ? Dmitry

Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Vlad Khorsun
05.05.2017 18:59, Adriano dos Santos Fernandes write: > Vlad and others, > > Can you look at this? > > https://github.com/asfernandes/firebird/tree/work/sharing-snapshot I took a quick look, so don't get me too serious. Also, my opinion could be incomplete and be changed later :) > It uses

Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Vlad Khorsun
05.05.2017 20:36, Adriano dos Santos Fernandes wrote: > On 05/05/2017 14:01, Vlad Khorsun : ... >> I don't understand for what purpose tra_oldest_snapshot was added. > In my understand, it's a property that new transaction should copy from > the base transaction. Isn't it? No.

Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Adriano dos Santos Fernandes
Em 05/05/2017 18:01, Vlad Khorsun escreveu: > >Also, i offer to add additional rule for transaction which should export > its snapshot data (it allows to avoid export by all transactions), something > like: > >SET TRANSACTION ISOLATION LEVEL SNAPSHOT WITH SHARED SNAPSHOT > As we talk

Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Vlad Khorsun
05.05.2017 21:10, Adriano dos Santos Fernandes wrote: > On 05/05/2017 14:43, Dmitry Yemanov wrote: >> 05.05.2017 20:01, Vlad Khorsun wrote: >>> %type snap_shot >>> snap_shot >>> : SNAPSHOT >>> | SNAPSHOT TABLE >>> | SNAPSHOT TABLE STABILITY >>> + | SNAPSHOT SHARING FROM >>

Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Vlad Khorsun
06.05.2017 0:17, Adriano dos Santos Fernandes wrote: > Em 05/05/2017 18:01, Vlad Khorsun escreveu: > >> >> Also, i offer to add additional rule for transaction which should export >> its snapshot data (it allows to avoid export by all transactions), something >> like: >> >> SET