Hello everyone,

we are using Flashback Version Querys to detect changes in a table between two given SCNs.

In 12.2 this works just fine. In 19.6 it is broken.

For example:

Consider the folowing transaction:

insert into emp3(empno) values (1);

insert into emp3(empno) values (2);

insert into emp3(empno) values (3);

insert into emp3(empno) values (4);

insert into emp3(empno) values (5);

delete from emp3 where empno = 2 or empno = 4;

commit;

In 12.2 the version query yields the folowing results:

EMPNO ROWID VERSIONS_OPERATION VERSIONS_STARTSCN VERSIONS_ENDSCN SCN_RANGE

---------- ------------------ ------------------ ----------------- --------------- -----------------------------

1 AABDg8AAHAAGBifAAA I 28451518954 NULL 28451518686 and 28451518956

3 AABDg8AAHAAGBifAAC I 28451518954 NULL 28451518686 and 28451518956