Something seems to have gone wrong in a temporal table. There’s a gap between the current record and the previous record that’s now in the history table. This gap looks like this:
Query:
select *, tsf_valid_from, tsf_valid_to
from adres for system_time all
where adres_id = 51714It’s as if the history data is no longer complete but we never manually deleted this data. This is a problem because we use this data for historical records such as invoices.
What could cause such a gap in temporal data?
