FBDA select from <tab> versions scn between, returns scn versions outside range
select versions_startscn,versions_endscn from <tab> versions between scn 17948031196 and 17948217693
returns all rows with null , versions_startscn, versions_endscn. That is expected.
But it also returns 8 updates versions with versions_startscn between scn 17931757407-17917431118 and null versions_endscn.
scn_to_timestamp(17917431118 ) returns ora-8181
So the, Versions between scn 17948031196 and 17948217693, is being ignored ?
I assume because it really want to do a, versions between timestamp , and cannot resolve the time so treats scn value as null ? But that just seems silly, when there is a timestamp between?
Also those 8 version rows should not be there. The FDBA for <tab> has 2 days retention and was last purged 8 hours prior to running the select.