I don't understand this validation. I have a table on which the primary key (1 column) is also used as look-up display value. This should be unique. The code like below illustrates it the best I think;
-- code generated by the SF;
create table dbo.[dummy]
dummy_id varchar(100) not null,
dummy_description varchar(500) null,
tsf_valid_from datetime2 (2) generated always as row start hidden not null ,
tsf_valid_to datetime2 (2) generated always as row end hidden not null ,
constraint [dummy_pk] primary key clustered
period for system_time (tsf_valid_from, tsf_valid_to)
insert into dummy (dummy_id) values ('Test'), ('Test') -- second insert will fail
I think the validation is in this case invalid?
Best answer by René W
Hi, I can't reproduce it anymore, I don't have the project anymore (it was in a sandbox environment I've cleaned up). As said it's probably solved when we upgraded to 2021.1.