4 ms·
Yes that is fascinating!: However, we are able to support schema changes between the present and the “as of” time. For example, if a column is deleted in
by pjungwir 10y ago
Yes that is fascinating!:
However, we are able to support schema changes
between the present and the “as of” time.
For example, if a column is deleted in the present
but exists at some time in the past,
a time-travel query requesting data
from before the column was deleted
will successfully return it.
I've noticed that hardly anyone writes about DDL for temporal tables. Snodgrass's book doesn't cover it. What happens when you add a `NOT NULL` column or change a column to `NOT NULL`? That kind of thing. There is plenty of research on temporal tables, but I haven't found any attempt at defining rules for these changes. (If someone knows of a paper or book chapter, I'd love to hear about it!)