CREATE TABLE ato(i INTEGER, j TIMESTAMP TIME INDEX, PRIMARY KEY(i));

Affected Rows: 0

INSERT INTO ato VALUES(1, now()), (2, now());

Affected Rows: 2

SELECT i FROM ato;

+---+
| i |
+---+
| 1 |
| 2 |
+---+

ALTER TABLE ato SET 'ttl'='1d';

Affected Rows: 0

SELECT i FROM ato;

+---+
| i |
+---+
| 1 |
| 2 |
+---+

SHOW CREATE TABLE ato;

+-------+------------------------------------+
| Table | Create Table                       |
+-------+------------------------------------+
| ato   | CREATE TABLE IF NOT EXISTS "ato" ( |
|       |   "i" INT NULL,                    |
|       |   "j" TIMESTAMP(3) NOT NULL,       |
|       |   TIME INDEX ("j"),                |
|       |   PRIMARY KEY ("i")                |
|       | )                                  |
|       |                                    |
|       | ENGINE=mito                        |
|       | WITH(                              |
|       |   ttl = '1day'                     |
|       | )                                  |
+-------+------------------------------------+

ALTER TABLE ato SET 'ttl'='2d';

Affected Rows: 0

SELECT i FROM ato;

+---+
| i |
+---+
| 1 |
| 2 |
+---+

SHOW CREATE TABLE ato;

+-------+------------------------------------+
| Table | Create Table                       |
+-------+------------------------------------+
| ato   | CREATE TABLE IF NOT EXISTS "ato" ( |
|       |   "i" INT NULL,                    |
|       |   "j" TIMESTAMP(3) NOT NULL,       |
|       |   TIME INDEX ("j"),                |
|       |   PRIMARY KEY ("i")                |
|       | )                                  |
|       |                                    |
|       | ENGINE=mito                        |
|       | WITH(                              |
|       |   ttl = '2days'                    |
|       | )                                  |
+-------+------------------------------------+

ALTER TABLE ato SET 'ttl'=NULL;

Affected Rows: 0

SELECT i FROM ato;

+---+
| i |
+---+
| 1 |
| 2 |
+---+

SHOW CREATE TABLE ato;

+-------+------------------------------------+
| Table | Create Table                       |
+-------+------------------------------------+
| ato   | CREATE TABLE IF NOT EXISTS "ato" ( |
|       |   "i" INT NULL,                    |
|       |   "j" TIMESTAMP(3) NOT NULL,       |
|       |   TIME INDEX ("j"),                |
|       |   PRIMARY KEY ("i")                |
|       | )                                  |
|       |                                    |
|       | ENGINE=mito                        |
|       | WITH(                              |
|       |   ttl = 'forever'                  |
|       | )                                  |
+-------+------------------------------------+

ALTER TABLE ato SET 'ttl'='1s';

Affected Rows: 0

SHOW CREATE TABLE ato;

+-------+------------------------------------+
| Table | Create Table                       |
+-------+------------------------------------+
| ato   | CREATE TABLE IF NOT EXISTS "ato" ( |
|       |   "i" INT NULL,                    |
|       |   "j" TIMESTAMP(3) NOT NULL,       |
|       |   TIME INDEX ("j"),                |
|       |   PRIMARY KEY ("i")                |
|       | )                                  |
|       |                                    |
|       | ENGINE=mito                        |
|       | WITH(                              |
|       |   ttl = '1s'                       |
|       | )                                  |
+-------+------------------------------------+

ALTER TABLE ato SET 'ttl'='😁';

Error: 1004(InvalidArguments), Invalid set table option request: Invalid set region option request, key: ttl, value: 😁

ALTER TABLE ato SET '🕶️'='1s';

Error: 1004(InvalidArguments), Invalid set table option request: Invalid set region option request, key: 🕶️, value: 1s

SELECT i FROM ato;

+---+
| i |
+---+
| 1 |
| 2 |
+---+

ALTER TABLE ato SET 'compaction.twcs.time_window'='2h';

Affected Rows: 0

ALTER TABLE ato SET 'compaction.twcs.max_output_file_size'='500MB';

Affected Rows: 0

ALTER TABLE ato SET 'compaction.twcs.trigger_file_num'='2';

Affected Rows: 0

SHOW CREATE TABLE ato;

+-------+-----------------------------------------------------+
| Table | Create Table                                        |
+-------+-----------------------------------------------------+
| ato   | CREATE TABLE IF NOT EXISTS "ato" (                  |
|       |   "i" INT NULL,                                     |
|       |   "j" TIMESTAMP(3) NOT NULL,                        |
|       |   TIME INDEX ("j"),                                 |
|       |   PRIMARY KEY ("i")                                 |
|       | )                                                   |
|       |                                                     |
|       | ENGINE=mito                                         |
|       | WITH(                                               |
|       |   'compaction.twcs.max_output_file_size' = '500MB', |
|       |   'compaction.twcs.time_window' = '2h',             |
|       |   'compaction.twcs.trigger_file_num' = '2',         |
|       |   'compaction.type' = 'twcs',                       |
|       |   ttl = '1s'                                        |
|       | )                                                   |
+-------+-----------------------------------------------------+

ALTER TABLE ato UNSET 'compaction.twcs.time_window';

Affected Rows: 0

ALTER TABLE ato UNSET '🕶️';

Error: 1004(InvalidArguments), Invalid unset table option request: Invalid set region option request, key: 🕶️

SHOW CREATE TABLE ato;

+-------+-----------------------------------------------------+
| Table | Create Table                                        |
+-------+-----------------------------------------------------+
| ato   | CREATE TABLE IF NOT EXISTS "ato" (                  |
|       |   "i" INT NULL,                                     |
|       |   "j" TIMESTAMP(3) NOT NULL,                        |
|       |   TIME INDEX ("j"),                                 |
|       |   PRIMARY KEY ("i")                                 |
|       | )                                                   |
|       |                                                     |
|       | ENGINE=mito                                         |
|       | WITH(                                               |
|       |   'compaction.twcs.max_output_file_size' = '500MB', |
|       |   'compaction.twcs.trigger_file_num' = '2',         |
|       |   'compaction.type' = 'twcs',                       |
|       |   ttl = '1s'                                        |
|       | )                                                   |
+-------+-----------------------------------------------------+

ALTER TABLE ato SET 'compaction.twcs.trigger_file_num'='';

Affected Rows: 0

SHOW CREATE TABLE ato;

+-------+-----------------------------------------------------+
| Table | Create Table                                        |
+-------+-----------------------------------------------------+
| ato   | CREATE TABLE IF NOT EXISTS "ato" (                  |
|       |   "i" INT NULL,                                     |
|       |   "j" TIMESTAMP(3) NOT NULL,                        |
|       |   TIME INDEX ("j"),                                 |
|       |   PRIMARY KEY ("i")                                 |
|       | )                                                   |
|       |                                                     |
|       | ENGINE=mito                                         |
|       | WITH(                                               |
|       |   'compaction.twcs.max_output_file_size' = '500MB', |
|       |   'compaction.type' = 'twcs',                       |
|       |   ttl = '1s'                                        |
|       | )                                                   |
+-------+-----------------------------------------------------+

-- SQLNESS ARG restart=true
SHOW CREATE TABLE ato;

+-------+-----------------------------------------------------+
| Table | Create Table                                        |
+-------+-----------------------------------------------------+
| ato   | CREATE TABLE IF NOT EXISTS "ato" (                  |
|       |   "i" INT NULL,                                     |
|       |   "j" TIMESTAMP(3) NOT NULL,                        |
|       |   TIME INDEX ("j"),                                 |
|       |   PRIMARY KEY ("i")                                 |
|       | )                                                   |
|       |                                                     |
|       | ENGINE=mito                                         |
|       | WITH(                                               |
|       |   'compaction.twcs.max_output_file_size' = '500MB', |
|       |   'compaction.type' = 'twcs',                       |
|       |   ttl = '1s'                                        |
|       | )                                                   |
+-------+-----------------------------------------------------+

DROP TABLE ato;

Affected Rows: 0

CREATE TABLE phy (ts timestamp time index, val double) engine=metric with ("physical_metric_table" = "");

Affected Rows: 0

ALTER TABLE phy set ttl='2years';

Affected Rows: 0

SHOW CREATE TABLE phy;

+-------+------------------------------------+
| Table | Create Table                       |
+-------+------------------------------------+
| phy   | CREATE TABLE IF NOT EXISTS "phy" ( |
|       |   "ts" TIMESTAMP(3) NOT NULL,      |
|       |   "val" DOUBLE NULL,               |
|       |   TIME INDEX ("ts")                |
|       | )                                  |
|       |                                    |
|       | ENGINE=metric                      |
|       | WITH(                              |
|       |   physical_metric_table = '',      |
|       |   ttl = '2years'                   |
|       | )                                  |
+-------+------------------------------------+

ALTER TABLE phy UNSET 'ttl';

Affected Rows: 0

SHOW CREATE TABLE phy;

+-------+------------------------------------+
| Table | Create Table                       |
+-------+------------------------------------+
| phy   | CREATE TABLE IF NOT EXISTS "phy" ( |
|       |   "ts" TIMESTAMP(3) NOT NULL,      |
|       |   "val" DOUBLE NULL,               |
|       |   TIME INDEX ("ts")                |
|       | )                                  |
|       |                                    |
|       | ENGINE=metric                      |
|       | WITH(                              |
|       |   physical_metric_table = ''       |
|       | )                                  |
+-------+------------------------------------+

DROP TABLE phy;

Affected Rows: 0