25.09.2018 19:02, Karol Bieniaszewski wrote:
What is then SNAPSHOT_CN?
This is the commit number of currently used snapshot, if present.
Non-RC transactions create snapshot at own start and SNAPSHOT_CN is the CN of
that snapshot.
RCRC transactions create snapshot when user query execution
What is then SNAPSHOT_CN? Is this last snapshot commited before my transaction
start?
Consider sample – what i try to accomplish (get deltas)
CREATE TABLE NAMES
(
ID integer NOT NULL,
NAME varchar(100),
TR_ID bigint,
CONSTRAINT INTEG_2 PRIMARY KEY (ID)
);
CREATE TABLE NAMES__DEL
(
ID