CREATE DATABASE test_ttl_db WITH (ttl = '1 second');

USE test_ttl_db;

CREATE TABLE test_ttl(ts TIMESTAMP TIME INDEX, val INT);

SHOW CREATE TABLE test_ttl;

SHOW CREATE DATABASE test_ttl_db;

ALTER DATABASE test_ttl_db SET ttl = '1 day';

SHOW CREATE TABLE test_ttl;

SHOW CREATE DATABASE test_ttl_db;

ALTER TABLE test_ttl SET 'ttl' = '6 hours';

SHOW CREATE TABLE test_ttl;

ALTER TABLE test_ttl SET 'ttl' = 'instant';

SHOW CREATE TABLE test_ttl;

ALTER TABLE test_ttl SET 'ttl' = '0s';

SHOW CREATE TABLE test_ttl;

ALTER TABLE test_ttl SET 'ttl' = 'forever';

SHOW CREATE TABLE test_ttl;

SHOW CREATE DATABASE test_ttl_db;

ALTER TABLE test_ttl UNSET 'ttl';

SHOW CREATE TABLE test_ttl;

SHOW CREATE DATABASE test_ttl_db;

ALTER DATABASE test_ttl_db SET 'ttl' = 'forever';

SHOW CREATE TABLE test_ttl;

SHOW CREATE DATABASE test_ttl_db;

ALTER DATABASE test_ttl_db SET 'ttl' = '0s';

SHOW CREATE TABLE test_ttl;

SHOW CREATE DATABASE test_ttl_db;

ALTER DATABASE test_ttl_db SET 'ttl' = 'instant';

SHOW CREATE TABLE test_ttl;

SHOW CREATE DATABASE test_ttl_db;

ALTER DATABASE test_ttl_db UNSET 'ttl';

SHOW CREATE TABLE test_ttl;

SHOW CREATE DATABASE test_ttl_db;

ALTER TABLE test_ttl UNSET 'ttl';

SHOW CREATE TABLE test_ttl;

SHOW CREATE DATABASE test_ttl_db;

DROP TABLE test_ttl;

USE public;

DROP DATABASE test_ttl_db;

-- test both set database to instant and alter ttl to instant for a database is forbidden
CREATE DATABASE test_ttl_db WITH (ttl = 'instant');

CREATE DATABASE test_ttl_db_2 WITH (ttl = '1s');

ALTER DATABASE test_ttl_db_2 SET 'ttl' = 'instant';

DROP DATABASE test_ttl_db_2;