Re: WIP: System Versioned Temporal Table

On 1/24/22 00:16, Corey Huinker wrote:
>> - Table schemas change, and all (SV active) AV items would logically
>> need to fit the active schema or be updated to do so. Different story
>> for SV, nothing there should ever need to be changed.
>>
> Yeah, there's a mess (which you state below) about what happens if you
> create a table and then rename a column, or drop a column and add a
> same-named column back of another type at a later date, etc. In theory,
> this means that the valid set of columns and their types changes according
> to the time range specified. I may not be remembering correctly, but Vik
> stated that the SQL spec seemed to imply that you had to track all those
> things.

The spec does not allow schema changes at all on a a system versioned
table, except to change the system versioning itself.
--
Vik Fearing