mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-07-04 04:50:37 +00:00
6b587eb0a5
* test: add recent sqlness compat cases Signed-off-by: discord9 <discord9@163.com> * test: add more sqlness compat cases Signed-off-by: discord9 <discord9@163.com> --------- Signed-off-by: discord9 <discord9@163.com>
66 lines
2.7 KiB
Plaintext
66 lines
2.7 KiB
Plaintext
SELECT ts, host, val FROM t_table_ttl ORDER BY ts, host;
|
|
|
|
+---------------------+--------+-----+
|
|
| ts | host | val |
|
|
+---------------------+--------+-----+
|
|
| 2099-02-08T00:00:00 | host_a | 1 |
|
|
| 2099-02-08T00:01:00 | host_b | 2 |
|
|
+---------------------+--------+-----+
|
|
|
|
SHOW CREATE TABLE t_table_ttl;
|
|
|
|
+-------------+--------------------------------------------+
|
|
| Table | Create Table |
|
|
+-------------+--------------------------------------------+
|
|
| t_table_ttl | CREATE TABLE IF NOT EXISTS "t_table_ttl" ( |
|
|
| | "ts" TIMESTAMP(3) NOT NULL, |
|
|
| | "host" STRING NULL, |
|
|
| | "val" INT NULL, |
|
|
| | TIME INDEX ("ts"), |
|
|
| | PRIMARY KEY ("host") |
|
|
| | ) |
|
|
| | |
|
|
| | ENGINE=mito |
|
|
| | WITH( |
|
|
| | ttl = '7days' |
|
|
| | ) |
|
|
+-------------+--------------------------------------------+
|
|
|
|
ALTER TABLE t_table_ttl SET 'ttl' = '30d';
|
|
|
|
Affected Rows: 0
|
|
|
|
SHOW CREATE TABLE t_table_ttl;
|
|
|
|
+-------------+--------------------------------------------+
|
|
| Table | Create Table |
|
|
+-------------+--------------------------------------------+
|
|
| t_table_ttl | CREATE TABLE IF NOT EXISTS "t_table_ttl" ( |
|
|
| | "ts" TIMESTAMP(3) NOT NULL, |
|
|
| | "host" STRING NULL, |
|
|
| | "val" INT NULL, |
|
|
| | TIME INDEX ("ts"), |
|
|
| | PRIMARY KEY ("host") |
|
|
| | ) |
|
|
| | |
|
|
| | ENGINE=mito |
|
|
| | WITH( |
|
|
| | ttl = '30days' |
|
|
| | ) |
|
|
+-------------+--------------------------------------------+
|
|
|
|
INSERT INTO t_table_ttl VALUES
|
|
('2099-02-08 00:02:00+0000', 'host_c', 3);
|
|
|
|
Affected Rows: 1
|
|
|
|
SELECT ts, host, val FROM t_table_ttl ORDER BY ts, host;
|
|
|
|
+---------------------+--------+-----+
|
|
| ts | host | val |
|
|
+---------------------+--------+-----+
|
|
| 2099-02-08T00:00:00 | host_a | 1 |
|
|
| 2099-02-08T00:01:00 | host_b | 2 |
|
|
| 2099-02-08T00:02:00 | host_c | 3 |
|
|
+---------------------+--------+-----+
|