-- SQLNESS ARG version=v0.9.5
CREATE TABLE system_metrics (
    host STRING,
    idc STRING,
    cpu_util DOUBLE,
    memory_util DOUBLE,
    disk_util DOUBLE,
    ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP(),
    PRIMARY KEY(host, idc),
    TIME INDEX(ts)
);

Affected Rows: 0

INSERT INTO system_metrics
VALUES
    ("host1", "idc_a", 11.8, 10.3, 10.3, 1667446797450),
    ("host2", "idc_a", 80.0, 70.3, 90.0, 1667446797450),
    ("host1", "idc_b", 50.0, 66.7, 40.6, 1667446797450);

Affected Rows: 3

-- SQLNESS ARG version=latest
SHOW CREATE TABLE system_metrics;

+----------------+-----------------------------------------------------------+
| Table          | Create Table                                              |
+----------------+-----------------------------------------------------------+
| system_metrics | CREATE TABLE IF NOT EXISTS "system_metrics" (             |
|                |   "host" STRING NULL,                                     |
|                |   "idc" STRING NULL,                                      |
|                |   "cpu_util" DOUBLE NULL,                                 |
|                |   "memory_util" DOUBLE NULL,                              |
|                |   "disk_util" DOUBLE NULL,                                |
|                |   "ts" TIMESTAMP(3) NOT NULL DEFAULT current_timestamp(), |
|                |   TIME INDEX ("ts"),                                      |
|                |   PRIMARY KEY ("host", "idc")                             |
|                | )                                                         |
|                |                                                           |
|                | ENGINE=mito                                               |
|                |                                                           |
+----------------+-----------------------------------------------------------+

DROP TABLE system_metrics;

Affected Rows: 0

