HISTORY_RETENTION_PERIOD / Bug

torsten.strauss

Hi redgate Team,

the following statement will cause an error from SQL Prompt and HISTORY_RETENTION_PERIOD will not suggested.

CREATE TABLE test
(
    col1 int NOT NULL PRIMARY KEY
  , col2 varchar(100) NULL
  , valid_from datetime2 GENERATED ALWAYS AS ROW START
  , valid_to datetime2 GENERATED ALWAYS AS ROW END
  , PERIOD FOR SYSTEM_TIME(valid_from, valid_to)
)
WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = history.test, HISTORY_RETENTION_PERIOD = 1 DAY));
GO

Would be good to see a fix - thanks!

Torsten

Eddie D

Hi, thank you for your forum post.

I will run this past my colleagues in the development team and update when I receive their reply.

Many Thanks
Eddie

Eddie D

Hi, thank you for your patience.  I have added the details of this forum post to bug Report SP-7596.  I will update this forum post, when a bug fix version becomes available.

Many Thanks
Eddie

Eddie D

Hi, thank you for your patience.

SQL Prompt V9.5.4.9799 was released a little earlier today which includes a fix for the bug reported in SP-7596.  To upgrade use the 'Check for Updates' option in the SQL Prompt menu -> Help or click the install link in the pop-up reminder that appears when you open SSMS (or Visual Studio).

Many Thanks
Eddie