Valid time temporal query using dbms_flashback_archive and Joins/Union returns wrong results
(Doc ID 2543775.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
Wrong results occur for a temporal validity query , where multiple tables are joined .
If the order of the tables in the query ( with joins ) is changed , results are different (still incorrect ) .
Temporal validity query works fine for each individual table in isolation . Problem occurs when multiple tables are joined in the query .
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document