Dynamic tables: TARGET_LAG parameter set to less than 1 minute for new or modified tables results in error¶

Dynamic tables, when TARGET_LAG is defined as < 1 minute, behave as follows:

Previously:

In a CREATE DYNAMIC TABLE or ALTER DYNAMIC TABLE statement, you can specify a value of less than 1 minute for the TARGET_LAG parameter.

Dynamic tables with TARGET_LAG defined as less than 1 minute function as if their TARGET_LAG was set to 1 minute.

Currently:

Executing a CREATE DYNAMIC TABLE or ALTER DYNAMIC TABLE statement with the TARGET_LAG set to less than 1 minute results in an error.

Any existing dynamic tables with TARGET_LAG defined as less than 1 minute continue to function as if their TARGET_LAG was set to 1 minute. Replacing an existing dynamic table with a new dynamic table that has TARGET_LAG defined as less than 1 minute results in an error.

Ref: 1247