What is it like?
пт, 20 июл. 2018 г., 14:21 Vlad Khorsun :
> 20.07.2018 14:45, liviuslivius wrote:
> > Hi,
> > i ask here to not spam into the tracker.
> > I know that indexes in Firebird are not transactional objects.
> > My understanding was that when we update record
> > then old record vesion
24.07.2018 11:13, liviuslivius wrote:
Hi,
question about this patch
https://github.com/FirebirdSQL/firebird/pull/105
Is this possible that this CN(commit number) of transactions (pair transaction
id + CN) can be stored into some table?
Currently - no. Probably we could find a way for it.
I
вт, 24 июл. 2018 г. в 17:06, liviuslivius :
> Is this possible that this CN(commit number) of transactions (pair
> transaction id + CN) can be stored into some table?
CN is not stored at all. A list of CommitNumbers is generated looking
into TIP on database init in memory. Then it's mainainted in
Ok, the name is not so important but call it recentCN
but extended sample
--
Is this possible that this CN(commit number) of transactions (pair transaction
id + CN) can be stored into some table?
Is it possible to retrive most recent CN from transaction start point (c
24.07.2018 13:43, Mark Rotteveel wrote:
The term SCN is already used by nbackup, lets not muddle the waters by overloading it for
another usecase.
Taking into account usage of "SCN" term in Oracle, it is better to invent a new one for
nbackup than for transaction-related counter.
--
WBR
> > you do
> > SELECT * from tableX where RDB$RECORD_VERSION>2
> >
> > above select will not see data commited by transaction id=1 because
> > it modify records before tr2 start
> > and tr1 is commited after tr2 start
>
> :) tr1 committed BEFORE select in tr2 and in read committed mode MUST
> se
On 2018-07-24 10:13, liviuslivius wrote:
Hi,
question about this patch
https://github.com/FirebirdSQL/firebird/pull/105
Is this possible that this CN(commit number) of transactions (pair
transaction id + CN) can be stored into some table?
Is it possible to retrive most recent CN from transactio
вт, 24 июл. 2018 г. в 13:15, liviuslivius :
>
> Hi,
>
> this is not the same
> consider:
>
> transaction id=1 exists and is not commited but have modified some records in
> tableX.
> you start new transaction id=2 (read commited isolation mode)
> you commit transaction id=1
>
>
> you do
> SELECT *
Hello Adriano , could you add also a badge to the readme ?
https://www.appveyor.com/docs/status-badges/
On Mon, Jul 23, 2018 at 10:26 PM, Adriano dos Santos Fernandes <
adrian...@gmail.com> wrote:
> On 23/07/2018 16:14, Dimitry Sibiryakov wrote:
> > Nobody cared to add it into project's file,
Hi,
this is not the same
consider:
transaction id=1 exists and is not commited but have modified some records in
tableX.
you start new transaction id=2 (read commited isolation mode)
you commit transaction id=1
you do
SELECT * from tableX where RDB$RECORD_VERSION>2
above select will not see
24.07.2018 10:13, liviuslivius wrote:
It can provide simple way to retrive new records/changes in tables (new
feature).
E.g. whe can then do
SELECT * FROM TABLEX WHERE CN>:SCN;
You already can do it with RDB$RECORD_VERSION.
--
WBR, SD.
---
Hi,
question about this patch
https://github.com/FirebirdSQL/firebird/pull/105
Is this possible that this CN(commit number) of transactions (pair transaction
id + CN) can be stored into some table?
Is it possible to retrive most recent CN from transaction start point (call
this SCN).
It can p
12 matches
Mail list logo